onion.php

ProjectPier 源码 很好的项目管理程序

CREATE TABLE `<?php echo $table_prefix ?>attached_files` (
  `rel_object_manager` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  `rel_object_id` int(10) unsigned NOT NULL default '0',
  `file_id` int(10) unsigned NOT NULL default '0',
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`rel_object_manager`,`rel_object_id`,`file_id`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

CREATE TABLE `<?php echo $table_prefix ?>comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rel_object_id` int(10) unsigned NOT NULL default '0',
  `rel_object_manager` varchar(30) <?php echo $default_collation ?> NOT NULL default '',
  `text` text <?php echo $default_collation ?>,
  `is_private` tinyint(1) unsigned NOT NULL default '0',
  `is_anonymous` tinyint(1) unsigned NOT NULL default '0',
  `author_name` varchar(50) <?php echo $default_collation ?> default NULL,
  `author_email` varchar(100) <?php echo $default_collation ?> default NULL,
  `author_homepage` varchar(100) <?php echo $default_collation ?> NOT NULL default '',
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned default NULL,
  `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `object_id` (`rel_object_id`,`rel_object_manager`),
  KEY `created_on` (`created_on`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

CREATE TABLE `<?php echo $table_prefix ?>file_repo` (
  `id` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
  `content` longblob NOT NULL,
  `order` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `order` (`order`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

CREATE TABLE `<?php echo $table_prefix ?>file_repo_attributes` (
  `id` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
  `attribute` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  `value` text <?php echo $default_collation ?> NOT NULL,
  PRIMARY KEY  (`id`,`attribute`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

CREATE TABLE `<?php echo $table_prefix ?>project_file_revisions` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `file_id` int(10) unsigned NOT NULL default '0',
  `file_type_id` smallint(5) unsigned NOT NULL default '0',
  `repository_id` varchar(40) <?php echo $default_collation ?> NOT NULL default '',
  `thumb_filename` varchar(44) <?php echo $default_collation ?> default NULL,
  `revision_number` int(10) unsigned NOT NULL default '0',
  `comment` text <?php echo $default_collation ?>,
  `type_string` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  `filesize` int(10) unsigned NOT NULL default '0',
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned default NULL,
  `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `file_id` (`file_id`),
  KEY `updated_on` (`updated_on`),
  KEY `revision_number` (`revision_number`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

CREATE TABLE `<?php echo $table_prefix ?>project_files` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `project_id` int(10) unsigned NOT NULL default '0',
  `folder_id` smallint(5) unsigned NOT NULL default '0',
  `filename` varchar(100) <?php echo $default_collation ?> NOT NULL default '',
  `description` text <?php echo $default_collation ?>,
  `is_private` tinyint(1) unsigned NOT NULL default '0',
  `is_important` tinyint(1) unsigned NOT NULL default '0',
  `is_locked` tinyint(1) unsigned NOT NULL default '0',
  `is_visible` tinyint(1) unsigned NOT NULL default '0',
  `expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `comments_enabled` tinyint(1) unsigned NOT NULL default '1',
  `anonymous_comments_enabled` tinyint(1) unsigned NOT NULL default '0',
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned default '0',
  `updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned default '0',
  PRIMARY KEY  (`id`),
  KEY `project_id` (`project_id`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

CREATE TABLE `<?php echo $table_prefix ?>project_folders` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `project_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(50) <?php echo $default_collation ?> NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `project_id` (`project_id`,`name`)
) ENGINE=InnoDB <?php echo $default_charset ?>;

ALTER TABLE `<?php echo $table_prefix ?>application_logs` CHANGE `object_id` `rel_object_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>application_logs` CHANGE `object_manager_class` `rel_object_manager` varchar(50) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>application_logs` MODIFY COLUMN `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>application_logs` ADD COLUMN `is_silent` tinyint(1) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `<?php echo $table_prefix ?>companies` MODIFY COLUMN `client_of_id` smallint(5) unsigned;
ALTER TABLE `<?php echo $table_prefix ?>companies` MODIFY COLUMN `logo_file` varchar(44);
ALTER TABLE `<?php echo $table_prefix ?>companies` ADD COLUMN `timezone` float(3,1) NOT NULL DEFAULT '0.0';

ALTER TABLE `<?php echo $table_prefix ?>project_messages` ADD COLUMN `comments_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1';
ALTER TABLE `<?php echo $table_prefix ?>project_messages` ADD COLUMN `anonymous_comments_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>project_messages` DROP COLUMN `is_locked`;

ALTER TABLE `<?php echo $table_prefix ?>project_milestones` MODIFY COLUMN `description` text;

ALTER TABLE `<?php echo $table_prefix ?>project_tasks` MODIFY COLUMN `text` text;

ALTER TABLE `<?php echo $table_prefix ?>project_users` CHANGE `can_upload_documents` `can_upload_files` tinyint(1) unsigned DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>project_users` CHANGE `can_manage_documents` `can_manage_files` tinyint(1) unsigned DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>project_users` ADD COLUMN `can_assign_to_owners` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>project_users` ADD COLUMN `can_assign_to_other` tinyint(1) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `<?php echo $table_prefix ?>searchable_objects` CHANGE `object_manager_class` `rel_object_manager` varchar(50) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>searchable_objects` CHANGE `object_id` `rel_object_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>searchable_objects` DROP KEY `PRIMARY`, ADD PRIMARY KEY (`rel_object_manager`,`rel_object_id`,`column_name`);

ALTER TABLE `<?php echo $table_prefix ?>tags` CHANGE `object_id` `rel_object_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>tags` CHANGE `object_manager_class` `rel_object_manager` varchar(50) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>tags` DROP KEY `object_id`, ADD INDEX `object_id` (`rel_object_id`,`rel_object_manager`);

ALTER TABLE `<?php echo $table_prefix ?>users` MODIFY COLUMN `company_id` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `<?php echo $table_prefix ?>users` MODIFY COLUMN `username` varchar(50) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>users` ADD COLUMN `token` varchar(40) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>users` ADD COLUMN `salt` varchar(13) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>users` ADD COLUMN `twister` varchar(10) NOT NULL;
ALTER TABLE `<?php echo $table_prefix ?>users` MODIFY COLUMN `avatar_file` varchar(44);
ALTER TABLE `<?php echo $table_prefix ?>users` ADD COLUMN `timezone` float(3,1) NOT NULL DEFAULT '0.0';
ALTER TABLE `<?php echo $table_prefix ?>users` DROP COLUMN `password`;
ALTER TABLE `<?php echo $table_prefix ?>users` DROP KEY `session_id`;
ALTER TABLE `<?php echo $table_prefix ?>users` DROP COLUMN `session_id`;