1.2.4-to-2.0.0.sql

PHP 知识管理系统（基于树结构的知识管理系统）, 英文原版的PHP源码。

DROP TABLE IF EXISTS zseq_groups_units_link;
CREATE TABLE zseq_groups_units_link (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_groups_units_link` SELECT MAX(`id`) FROM `groups_units_link`;
ALTER TABLE `groups_units_link` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_help;
CREATE TABLE zseq_help (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_help` SELECT MAX(`id`) FROM `help`;
ALTER TABLE `help` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_links;
CREATE TABLE zseq_links (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_links` SELECT MAX(`id`) FROM `links`;
ALTER TABLE `links` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_metadata_lookup;
CREATE TABLE zseq_metadata_lookup (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_metadata_lookup` SELECT MAX(`id`) FROM `metadata_lookup`;
ALTER TABLE `metadata_lookup` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_mime_types;
CREATE TABLE zseq_mime_types (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_mime_types` SELECT MAX(`id`) FROM `mime_types`;
ALTER TABLE `mime_types` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_news;
CREATE TABLE zseq_news (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_news` SELECT MAX(`id`) FROM `news`;
ALTER TABLE `news` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_organisations_lookup;
CREATE TABLE zseq_organisations_lookup (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_organisations_lookup` SELECT MAX(`id`) FROM `organisations_lookup`;
ALTER TABLE `organisations_lookup` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_roles;
CREATE TABLE zseq_roles (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_roles` SELECT MAX(`id`) FROM `roles`;
ALTER TABLE `roles` CHANGE `id` `id` INT( 11 ) NOT NULL;

ALTER TABLE `search_document_user_link` DROP `id`;

DROP TABLE IF EXISTS zseq_status_lookup;
CREATE TABLE zseq_status_lookup (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_status_lookup` SELECT MAX(`id`) FROM `status_lookup`;
ALTER TABLE `status_lookup` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_system_settings;
CREATE TABLE zseq_system_settings (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_system_settings` SELECT MAX(`id`) FROM `system_settings`;
ALTER TABLE `system_settings` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_time_period;
CREATE TABLE zseq_time_period (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_time_period` SELECT MAX(`id`) FROM `time_period`;
ALTER TABLE `time_period` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_time_unit_lookup;
CREATE TABLE zseq_time_unit_lookup (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_time_unit_lookup` SELECT MAX(`id`) FROM `time_unit_lookup`;
ALTER TABLE `time_unit_lookup` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_units_lookup;
CREATE TABLE zseq_units_lookup (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_units_lookup` SELECT MAX(`id`) FROM `units_lookup`;
ALTER TABLE `units_lookup` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_units_organisations_link;
CREATE TABLE zseq_units_organisations_link (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_units_organisations_link` SELECT MAX(`id`) FROM `units_organisations_link`;
ALTER TABLE `units_organisations_link` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_users;
CREATE TABLE zseq_users (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_users` SELECT MAX(`id`) FROM `users`;
ALTER TABLE `users` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_users_groups_link;
CREATE TABLE zseq_users_groups_link (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_users_groups_link` SELECT MAX(`id`) FROM `users_groups_link`;
ALTER TABLE `users_groups_link` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_web_documents;
CREATE TABLE zseq_web_documents (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_web_documents` SELECT MAX(`id`) FROM `web_documents`;
ALTER TABLE `web_documents` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_web_documents_status_lookup;
CREATE TABLE zseq_web_documents_status_lookup (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_web_documents_status_lookup` SELECT MAX(`id`) FROM `web_documents_status_lookup`;
ALTER TABLE `web_documents_status_lookup` CHANGE `id` `id` INT( 11 ) NOT NULL;

DROP TABLE IF EXISTS zseq_web_sites;
CREATE TABLE zseq_web_sites (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO `zseq_web_sites` SELECT MAX(`id`) FROM `web_sites`;
ALTER TABLE `web_sites` CHANGE `id` `id` INT( 11 ) NOT NULL;


ALTER TABLE `users` ADD UNIQUE (
 `username` 
); 
ALTER TABLE `document_types_lookup` ADD UNIQUE (
 `name` 
);
ALTER TABLE `groups_lookup` ADD UNIQUE (
 `name` 
); 
ALTER TABLE `organisations_lookup` ADD UNIQUE (
 `name` 
); 
ALTER TABLE `roles` ADD UNIQUE (
 `name` 
); 
ALTER TABLE `units_lookup` ADD UNIQUE (
`name`
);

DROP TABLE IF EXISTS `browse_criteria`;
CREATE TABLE `browse_criteria` (
  `id` int(11) NOT NULL default '0',
  `criteria_id` int(11) NOT NULL default '0',
  `precedence` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `criteria_id` (`criteria_id`),
  UNIQUE KEY `precedence` (`precedence`)
) TYPE=InnoDB;

INSERT INTO `browse_criteria` VALUES (1, -1, 0);
INSERT INTO `browse_criteria` VALUES (2, -2, 1);
INSERT INTO `browse_criteria` VALUES (3, -3, 2);
INSERT INTO `browse_criteria` VALUES (4, -4, 3);
INSERT INTO `browse_criteria` VALUES (5, -5, 4);

DROP TABLE IF EXISTS `zseq_browse_criteria`;
CREATE TABLE `zseq_browse_criteria` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `zseq_browse_criteria` SELECT MAX(`id`) FROM `browse_criteria`;

ALTER TABLE `folders` ADD `permission_folder_id` INT;
ALTER TABLE `folders` ADD INDEX ( `permission_folder_id` ) ;

ALTER TABLE `documents` ADD `created` DATETIME NOT NULL ;
ALTER TABLE `documents` ADD INDEX ( `created` ) ;

UPDATE documents AS D, document_transactions AS T SET D.created = T.datetime WHERE T.document_id = D.id AND T.transaction_id = 1;

ALTER TABLE `document_text` DROP `id`;