10-units.sql

来自「PHP 知识管理系统（基于树结构的知识管理系统）, 英文原版的PHP源码。」· SQL 代码 · 共 6 行

ALTER TABLE `folders` DROP INDEX `fk_unit_id`; # was INDEX (`unit_id`)
ALTER TABLE `folders` DROP COLUMN `unit_id`; # was int(11) default NULL
ALTER TABLE `units_lookup` CHANGE COLUMN `folder_id` `folder_id` int(11) NOT NULL default '0';
DROP TABLE `groups_units_link`;
DROP TABLE `zseq_groups_units_link`;