upgrade_tables.sql

jsp程序开发系统

CREATE TABLE admin_help_cat ( id int(10) NOT NULL auto_increment, name varchar(250) NOT NULL default '', displayorder int(10) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE admin_help_entry ( id int(10) NOT NULL auto_increment, category int(10) NOT NULL default '0', entry mediumtext NOT NULL, displayorder int(10) NOT NULL default '0', title varchar(250) NOT NULL default '', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE calendar_task_iteration ( task_techid int(11) NOT NULL default '0', taskid int(11) default NULL, completed int(11) default NULL, date date default NULL, time time default NULL) TYPE=MyISAM;
CREATE TABLE cron_options ( id int(10) NOT NULL auto_increment, title varchar(250) NOT NULL default '', options mediumtext NOT NULL, day int(2) NOT NULL default '0', hour int(1) NOT NULL default '0', scriptname varchar(250) NOT NULL default '', description mediumtext NOT NULL, nextrun int(10) NOT NULL default '0', templates mediumtext NOT NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE data ( id int(10) NOT NULL auto_increment, name varchar(250) NOT NULL default '', data longtext NOT NULL, isdefault int(1) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE escalate ( id int(10) unsigned NOT NULL auto_increment, dayswaiting int(10) NOT NULL default '0', daysopen int(10) NOT NULL default '0', category int(10) NOT NULL default '0', priority int(10) NOT NULL default '0', tech int(10) NOT NULL default '0', techemail varchar(250) NOT NULL default '', UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE faq_cats_related ( show_cat int(10) NOT NULL default '0', related_cat int(10) NOT NULL default '0') TYPE=MyISAM; 
CREATE TABLE faq_comments ( id int(10) NOT NULL auto_increment, userid int(10) NOT NULL default '0', useremail varchar(250) NOT NULL default '', comments mediumtext NOT NULL, articleid int(10) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE faq_keywords ( articles varchar(100) NOT NULL default '', word varchar(50) NOT NULL default '', PRIMARY KEY  (word)) TYPE=MyISAM;
CREATE TABLE faq_permissions ( catid int(10) NOT NULL default '0', groupid int(10) NOT NULL default '0', UNIQUE KEY groupid (groupid,catid)) TYPE=MyISAM;
CREATE TABLE faq_rating ( ipaddress varchar(20) NOT NULL default '', faqid int(10) NOT NULL default '0', rating int(10) NOT NULL default '0', timestamp int(10) NOT NULL default '0', userid int(10) NOT NULL default '0', session int(10) NOT NULL default '0') TYPE=MyISAM;
CREATE TABLE faq_searchlog ( id int(10) NOT NULL auto_increment, time int(10) NOT NULL default '0', query mediumtext NOT NULL, results int(10) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id), KEY id_2 (id)) TYPE=MyISAM;
CREATE TABLE `faq_subscriptions` ( id int(10) unsigned NOT NULL auto_increment, catid int(10) NOT NULL default '0', articleid int(10) NOT NULL default '0', new int(1) NOT NULL default '0', edit int(1) NOT NULL default '0', userid int(10) NOT NULL default '0', PRIMARY KEY  (id), KEY articleid (articleid), KEY catid (catid)) TYPE=MyISAM;
CREATE TABLE faq_word ( id int(10) NOT NULL default '0', word varchar(250) NOT NULL default '', distribution decimal(10,0) NOT NULL default '0', total int(10) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE faq_wordindex ( wordid int(10) NOT NULL default '0', articleid int(10) NOT NULL default '0', distribution int(10) NOT NULL default '0', in_keyword int(1) NOT NULL default '0', in_comment int(1) NOT NULL default '0', in_title int(1) NOT NULL default '0') TYPE=MyISAM;
CREATE TABLE gateway_auto ( id int(10) unsigned NOT NULL auto_increment, email varchar(250) NOT NULL default '', type varchar(50) NOT NULL default '', timestamp int(11) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE gateway_error ( id int(10) NOT NULL default '0', logid int(10) NOT NULL default '0', error varchar(250) NOT NULL default '', timestamp int(10) NOT NULL default '0', sourceid int(10) NOT NULL default '0') TYPE=MyISAM;
CREATE TABLE gateway_pop_accounts ( id int(11) NOT NULL auto_increment, accountid int(11) default NULL, server varchar(64) default NULL, username varchar(64) default NULL, password varchar(64) default NULL, target ENUM('user','tech','return') NOT NULL DEFAULT 'user', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE gateway_pop_failures ( id int(11) NOT NULL auto_increment, messageid varchar(255) default NULL, reason varchar(255) default NULL, stamp int(11) default NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE gateway_source ( id int(10) NOT NULL auto_increment, source mediumtext NOT NULL, headers mediumtext NOT NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE gateway_spam ( id int(10) NOT NULL auto_increment, type varchar(250) NOT NULL default '', regex int(1) NOT NULL default '0', textmatch mediumtext NOT NULL, is_delete int(1) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id), KEY id_2 (id)) TYPE=MyISAM;
CREATE TABLE languages ( id int(10) NOT NULL auto_increment, name varchar(250) NOT NULL default '', is_selectable int(1) NOT NULL default '0', custom int(1) NOT NULL default '0', UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE query_log ( id int(11) NOT NULL auto_increment, query mediumtext, explain_log mediumtext, duration float default NULL, stamp int(11) default NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE quickreply ( id int(10) NOT NULL auto_increment, category int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', global int(1) NOT NULL default '0', name varchar(50) NOT NULL default '', response mediumtext NOT NULL, PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE quickreply_cat ( id int(10) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', techid int(10) NOT NULL default '0', global int(1) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE report ( id int(10) NOT NULL auto_increment, title varchar(250) NOT NULL default '', name varchar(250) NOT NULL default '', description mediumtext NOT NULL, lastrun int(10) NOT NULL default '0', format varchar(250) NOT NULL default '', email varchar(250) NOT NULL default '', repeattype varchar(250) NOT NULL default '', value1 varchar(250) NOT NULL default '', value2 varchar(250) NOT NULL default '', style int(10) NOT NULL default '0', path varchar(250) NOT NULL default '', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE report_relations ( reportid int(10) NOT NULL default '0', statid int(10) NOT NULL default '0') TYPE=MyISAM; 
CREATE TABLE report_stat ( id int(10) NOT NULL auto_increment, title varchar(250) NOT NULL default '', description mediumtext NOT NULL, variable1 varchar(250) NOT NULL default '', variable2 varchar(250) NOT NULL default '', variable1times mediumtext NOT NULL, variable2times mediumtext NOT NULL, dateaffect varchar(250) NOT NULL default '', displaytype varchar(50) NOT NULL default '', appendix int(1) NOT NULL default '0', displayfields mediumtext NOT NULL, fixed_general mediumtext NOT NULL, fixed_user mediumtext NOT NULL, fixed_ticket mediumtext NOT NULL, PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM; 
CREATE TABLE report_style ( id int(10) unsigned NOT NULL auto_increment, name varchar(250) NOT NULL default '', title_colour varchar(250) NOT NULL default '', description_colour varchar(250) NOT NULL default '', PRIMARY KEY  (id), KEY id (id)) TYPE=MyISAM;
CREATE TABLE search ( id int(10) NOT NULL auto_increment, query mediumtext NOT NULL, results mediumtext NOT NULL, time int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', total int(10) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id), KEY techid (techid), KEY techid_2 (techid)) TYPE=MyISAM;
CREATE TABLE settings_cat ( id int(10) NOT NULL auto_increment, name varchar(255) NOT NULL default '', description mediumtext NOT NULL, defaultdisplay int(1) NOT NULL default '0', displayorder int(11) default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE spellwords ( word varchar(25) NOT NULL default '0', soundex varchar(25) NOT NULL default '', PRIMARY KEY  (word), UNIQUE KEY word (word), KEY word_2 (word), KEY sx (soundex)) TYPE=MyISAM;
CREATE TABLE tech_bookmarks ( id int(10) NOT NULL auto_increment, url varchar(250) NOT NULL default '', comments mediumtext NOT NULL, displayorder int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', name varchar(250) NOT NULL default '', category int(10) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE tech_folders ( techid int(10) NOT NULL default '0', type varchar(250) NOT NULL default '', categories mediumtext NOT NULL, UNIQUE KEY techid (techid,type)) TYPE=MyISAM;