upgrade_tables.sql

jsp程序开发系统

CREATE TABLE tech_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 tech_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 tech_internal_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 tech_internal_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 tech_news ( id int(10) unsigned NOT NULL auto_increment, title varchar(255) NOT NULL default '', details mediumtext NOT NULL, techid int(10) NOT NULL default '0', date int(10) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE tech_notes ( id int(10) NOT NULL auto_increment, title varchar(250) NOT NULL default '', note mediumtext NOT NULL, timestamp int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', category int(10) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE tech_session ( sessionid char(32) NOT NULL default '', techid int(10) unsigned NOT NULL default '0', useragent char(250) NOT NULL default '', lastactivity int(10) unsigned NOT NULL default '0', location char(255) NOT NULL default '', language int(10) NOT NULL default '0', techzone INT(1) DEFAULT '0', PRIMARY KEY  (sessionid,sessionid), KEY sessionid (sessionid)) TYPE=MyISAM;
CREATE TABLE tech_start_tickets ( techid int(10) NOT NULL default '0', userid int(10) NOT NULL default '0', KEY techid (techid)) TYPE=MyISAM;
CREATE TABLE tech_ticket_save ( ticketid int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', message mediumtext NOT NULL, category int(10) NOT NULL default '0', id int(10) unsigned NOT NULL auto_increment, KEY techid (techid), KEY id (id)) TYPE=MyISAM;
CREATE TABLE tech_ticket_search ( id int(11) NOT NULL auto_increment, techid int(11) NOT NULL default '0', save_name varchar(255) NOT NULL default '', save_type enum('search','result') NOT NULL default 'search', data mediumtext, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE tech_timelog ( id int(11) NOT NULL auto_increment, techid int(11) default '0', activity char(255) default NULL, stamp int(11) default NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE tech_timelog_archive ( id int(11) NOT NULL auto_increment, techid int(11) default '0', activity char(255) default NULL, stamp int(11) default NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE template ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL default '', template mediumtext, category int(10) default NULL, description varchar(255) NOT NULL default '', upgraded int(1) NOT NULL default '0', changed int(1) NOT NULL default '0', custom int(1) NOT NULL default '0', version_upgrade int(1) NOT NULL default '0', template_unparsed mediumtext NOT NULL, displayorder int(3) NOT NULL default '0', backup int(1) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE template_cat ( id int(10) NOT NULL auto_increment, name varchar(255) NOT NULL default '', description mediumtext NOT NULL, PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE template_email ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL default '', template mediumtext, category varchar(50) NOT NULL default '0', description varchar(255) NOT NULL default '', upgraded int(1) NOT NULL default '0', changed int(1) NOT NULL default '0', custom int(1) NOT NULL default '0', version_upgrade int(1) NOT NULL default '0', template_unparsed mediumtext NOT NULL, displayorder int(3) NOT NULL default '0', backup int(1) NOT NULL default '0', language int(1) NOT NULL default '0', subject varchar(250) NOT NULL default '', PRIMARY KEY  (id), UNIQUE KEY id (id), KEY name (name)) TYPE=MyISAM;
CREATE TABLE template_replace ( id int(10) unsigned NOT NULL auto_increment, name varchar(75) NOT NULL default '', value mediumtext NOT NULL, description mediumtext, displayorder int(10) NOT NULL default '0', custom int(1) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE template_words ( wordref varchar(50) NOT NULL default '', language int(10) NOT NULL default '0', text mediumtext NOT NULL, category int(10) NOT NULL default '0', UNIQUE KEY wordref (wordref,language)) TYPE=MyISAM;
CREATE TABLE template_words_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 ticket_fielddisplay ( id int(10) unsigned NOT NULL auto_increment, code mediumtext NOT NULL, name varchar(250) NOT NULL default '', example varchar(250) NOT NULL default '', UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE ticket_log ( id int(10) NOT NULL auto_increment, ticketid int(10) NOT NULL default '0', actionid int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', timestamp int(10) NOT NULL default '0', userid int(10) NOT NULL default '0', id_before int(10) NOT NULL default '0', id_after int(10) NOT NULL default '0', detail_before mediumtext NOT NULL, detail_after mediumtext NOT NULL, extra varchar(250) NOT NULL default '', PRIMARY KEY  (id), UNIQUE KEY id (id), KEY ticketid (ticketid)) TYPE=MyISAM;
CREATE TABLE ticket_merge (old_id int(10) NOT NULL DEFAULT '0', old_ref varchar(20) NOT NULL DEFAULT '', new_id int(10) NOT NULL DEFAULT '0', new_ref varchar(20) NOT NULL DEFAULT '');
CREATE TABLE ticket_message_source ( messageid int(10) NOT NULL default '0', source mediumtext NOT NULL, PRIMARY KEY  (messageid), KEY id (messageid)) TYPE=MyISAM;
CREATE TABLE ticket_notes ( id int(10) unsigned NOT NULL auto_increment, ticketid int(10) NOT NULL default '0', date int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', note mediumtext NOT NULL, UNIQUE KEY id (id), KEY techid (techid)) TYPE=MyISAM;
CREATE TABLE user_bill ( id int(10) NOT NULL auto_increment, userid int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', ticketid int(10) NOT NULL default '0', time int(10) NOT NULL default '0', paid int(1) NOT NULL default '0', billable int(1) default '0', charge float default '0', stamp int(10) NOT NULL default '0', PRIMARY KEY  (id)) TYPE=MyISAM; 
CREATE TABLE user_email ( email varchar(250) NOT NULL default '', userid int(10) NOT NULL default '0', validated int(1) NOT NULL default '0', authcode varchar(20) NOT NULL default '', KEY email (email), KEY userid (userid)) TYPE=MyISAM;
CREATE TABLE user_groups ( id int(10) NOT NULL auto_increment, name varchar(250) NOT NULL default '', PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE user_help ( id int(10) NOT NULL auto_increment, category int(10) NOT NULL default '0', name varchar(250) NOT NULL default '', displayorder int(10) NOT NULL default '0', PRIMARY KEY  (id), KEY category (category)) TYPE=MyISAM;
CREATE TABLE user_help_cats ( id int(10) NOT NULL auto_increment, displayorder int(10) NOT NULL default '0', is_custom int(1) NOT NULL default '0', name varchar(250) NOT NULL default '', KEY id (id)) TYPE=MyISAM;
CREATE TABLE user_help_cats_entries ( id int(10) NOT NULL auto_increment, categoryid int(10) NOT NULL default '0', languageid int(10) NOT NULL default '0', entry mediumtext NOT NULL, PRIMARY KEY  (id)) TYPE=MyISAM;
CREATE TABLE user_help_entries ( id int(10) NOT NULL auto_increment, helpid int(10) NOT NULL default '0', language int(10) NOT NULL default '0', title varchar(250) NOT NULL default '', helpentry mediumtext NOT NULL, PRIMARY KEY (id), KEY language (language,helpid)) TYPE=MyISAM;
CREATE TABLE user_notes ( id int(10) NOT NULL auto_increment, userid int(10) NOT NULL default '0', techid int(10) NOT NULL default '0', note mediumtext NOT NULL, timestamp int(10) NOT NULL default '0', global int(1) NOT NULL default '0', PRIMARY KEY  (id), UNIQUE KEY id (id)) TYPE=MyISAM;
CREATE TABLE user_session ( sessionid char(32) NOT NULL default '', userid int(10) unsigned NOT NULL default '0', useragent char(250) NOT NULL default '', lastactivity int(10) unsigned NOT NULL default '0', location char(255) NOT NULL default '', language int(10) NOT NULL default '0', PRIMARY KEY  (sessionid,sessionid), KEY sessionid (sessionid)) TYPE=MyISAM;