tables.php

jsp程序开发系统

CREATE TABLE quickreply (
  id int(10) NOT NULL auto_increment,
  category int(10) NOT NULL default '0',
  techid int(10) NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  response mediumtext NOT NULL,
  PRIMARY KEY  (id),
  KEY techid (techid)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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)
)

";

$queries[] = "

CREATE TABLE report_relations (
  reportid int(10) NOT NULL default '0',
  statid int(10) NOT NULL default '0'
)

";

$queries[] = "

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)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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),
  KEY techid (techid)
)

";

$queries[] = "

CREATE TABLE settings (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(75) NOT NULL default '',
  settings varchar(255) default NULL,
  value mediumtext NOT NULL,
  category int(10) NOT NULL default '0',
  description mediumtext,
  field_type varchar(255) NOT NULL default '',
  show_order int(10) NOT NULL default '0',
  options varchar(250) NOT NULL default '',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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)
)

";

$queries[] = "

CREATE TABLE tech (
  id int(10) NOT NULL auto_increment,
  username varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  signature mediumtext NOT NULL,
  email varchar(255) NOT NULL default '',
  p_close_ticket int(1) NOT NULL default '0',
  p_tech_view int(1) NOT NULL default '0',
  p_tech_edit int(1) NOT NULL default '0',
  p_add_k int(1) NOT NULL default '0',
  p_edit_k int(1) NOT NULL default '0',
  p_delete_k int(1) NOT NULL default '0',
  p_add_c_k int(1) NOT NULL default '0',
  p_delete_c_k int(1) NOT NULL default '0',
  is_admin int(1) NOT NULL default '0',
  p_edit_c_k int(1) NOT NULL default '0',
  p_edit_users int(1) NOT NULL default '0',
  p_delete_users int(1) NOT NULL default '0',
  p_add_announcements int(1) NOT NULL default '0',
  p_delete_announcements int(1) NOT NULL default '0',
  p_create_users int(1) NOT NULL default '0',
  p_edit_announcements int(1) NOT NULL default '0',
  p_delete_other int(1) NOT NULL default '0',
  p_delete_own int(1) NOT NULL default '0',
  userfield_selection mediumtext NOT NULL,
  fielddisplay mediumtext NOT NULL,
  alert_reply_your int(1) NOT NULL default '0',
  alert_reply_cat int(1) NOT NULL default '0',
  alert_reply_all int(1) NOT NULL default '0',
  alert_new_cat int(1) NOT NULL default '0',
  alert_new_all int(1) NOT NULL default '0',
  alert_pm int(1) NOT NULL default '0',
  alert_sound int(1) NOT NULL default '0',
  alert_popup int(1) NOT NULL default '0',
  alert_time int(10) NOT NULL default '0',
  alert_frequency int(2) NOT NULL default '0',
  cats_user varchar(250) NOT NULL default '',
  cats_admin varchar(250) NOT NULL default '',
  email_new_email int(1) NOT NULL default '0',
  email_new_sms int(1) NOT NULL default '0',
  email_reply_email int(1) NOT NULL default '0',
  email_reply_sms int(1) NOT NULL default '0',
  email_own_email int(1) NOT NULL default '0',
  email_own_sms int(1) NOT NULL default '0',
  sms varchar(250) NOT NULL default '',
  disabled int(1) NOT NULL default '0',
  email_assigned int(1) NOT NULL default '0',
  email_pm int(1) NOT NULL default '0',
  weekstart int(11) NOT NULL default '7',
  p_approve_new_registrations int(1) NOT NULL default '0',
  password_cookie varchar(8) NOT NULL default '',
  disabled_reason varchar(255) NOT NULL default '',
  email_attachments int(1) NOT NULL default '0',
  email_own_attachments int(1) NOT NULL default '0',
  copy_to_clipboard int(1) NOT NULL default '0',
  p_user_expire int(1) NOT NULL default '1',
  selected_sound varchar(255) default '',
  p_quickedit int(1) NOT NULL default '0',
  p_global_note int(1) NOT NULL default '0',
  email_faq int(1) NOT NULL default '0',
  footer int(10) NOT NULL default '0',
  p_html_tech int(1) NOT NULL default '0',
  p_html_user int(1) NOT NULL default '0',
  timezone int(10) NOT NULL default '0',
  timezone_dst int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

CREATE TABLE tech_attachments (
  id int(10) NOT NULL auto_increment,
  blobid int(10) NOT NULL default '0',
  filename varchar(250) NOT NULL default '',
  filesize varchar(50) NOT NULL default '',
  techid int(10) NOT NULL default '0',
  category int(10) NOT NULL default '0',
  extension varchar(10) NOT NULL default '',
  timestamp int(10) NOT NULL default '0',
  comments mediumtext NOT NULL,
  PRIMARY KEY  (id),
  KEY techid (techid),
  KEY category (category)
)

";

$queries[] = "

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),
  KEY techid (techid,category)
)

";

$queries[] = "

CREATE TABLE tech_email (
  techid int(10) NOT NULL default '0',
  fieldname varchar(250) NOT NULL default '',
  value varchar(250) NOT NULL default '',
  newreply int(1) NOT NULL default '0',
  newticket int(1) NOT NULL default '0',
  email int(1) NOT NULL default '0',
  sms int(1) NOT NULL default '0',
  KEY techid (techid)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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),
  KEY category (category)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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)
)

";

$queries[] = "

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),
  KEY techid (techid,category)
)

";

$queries[] = "

CREATE TABLE tech_sendmail (
  id int(10) NOT NULL auto_increment,
  parent int(10) NOT NULL default '0',
  techid int(10) NOT NULL default '0',
  subject varchar(255) NOT NULL default '',
  message mediumtext NOT NULL,
  from_email varchar(255) NOT NULL default '',
  to_email varchar(255) NOT NULL default '',
  tracking int(1) NOT NULL default '0',
  awaiting_reply int(1) NOT NULL default '0',
  pass varchar(7) NOT NULL default '',
  date_sent int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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),
  KEY techid (techid)
)

";

$queries[] = "

CREATE TABLE tech_start_tickets (
  techid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  KEY techid (techid)
)

";

$queries[] = "

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,
  PRIMARY KEY (id),
  KEY techid (techid)
 
)

";

$queries[] = "

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),
  KEY techid (techid)
)

";

$queries[] = "

CREATE TABLE tech_ticket_watch (
  id int(10) NOT NULL auto_increment,
  ticketid int(10) NOT NULL default '0',
  created int(10) NOT NULL default '0',
  datetodo date NOT NULL default '0000-00-00',
  completed int(1) NOT NULL default '0',
  techid int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY date (datetodo),
  KEY techid (created)
)

";

$queries[] = "

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),
  KEY techid (techid)
)

";

$queries[] = "

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),
  KEY techid (techid)
)

";

$queries[] = "

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),