upgrade2.9a-2.9b.sql

来自「java开源项目源代码」· SQL 代码 · 共 7 行

BEGIN;
DROP TABLE WORequirements;
DROP TABLE WOIssues;
ALTER TABLE `WorksOrders` ADD `UnitsRecd` DOUBLE DEFAULT '0' NOT NULL AFTER `UnitsReqd` ;
ALTER TABLE `WWW_Users` CHANGE `Language` `Language` VARCHAR( 5 ) DEFAULT 'en_GB' NOT NULL;
COMMIT;