6 lines
299 B
SQL
6 lines
299 B
SQL
ALTER TABLE `zt_project` drop COLUMN `product`;
|
|
ALTER TABLE `zt_project` drop COLUMN `statge`;
|
|
ALTER TABLE `zt_project` drop COLUMN `storyConcept`;
|
|
ALTER TABLE `zt_product` drop COLUMN `storyConcept`;
|
|
UPDATE zt_todo SET assignedTo=account,assignedBy=account,assignedDate=`date` WHERE assignedTo='';
|