tables.php

jsp程序开发系统

  KEY name (name)
)

";

$queries[] = "

CREATE TABLE template_cat (
  id int(10) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description mediumtext NOT NULL,
  PRIMARY KEY  (id)
)

";

$queries[] = "

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(10) NOT NULL default '0',
  subject varchar(250) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY name (name)
)

";

$queries[] = "

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

";

$queries[] = "

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',
  cust int(1) NOT NULL default '0',
  KEY language (language)
)

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE ticket (
  id int(10) NOT NULL auto_increment,
  subject varchar(250) NOT NULL default '',
  userid int(10) NOT NULL default '0',
  tech int(10) NOT NULL default '0',
  category int(10) NOT NULL default '0',
  priority int(10) NOT NULL default '0',
  language int(10) NOT NULL default '0',
  is_locked int(1) NOT NULL default '0',
  is_open int(1) NOT NULL default '0',
  awaiting_tech int(1) NOT NULL default '0',
  date_opened int(10) NOT NULL default '0',
  date_closed int(10) NOT NULL default '0',
  date_lastreply int(10) NOT NULL default '0',
  date_lastreply_tech int(10) NOT NULL default '0',
  date_locked int(10) NOT NULL default '0',
  lock_techid int(10) NOT NULL default '0',
  email varchar(250) NOT NULL default '',
  ref varchar(20) NOT NULL default '',
  gatewayid int(10) NOT NULL default '0',
  ticketemail varchar(250) NOT NULL default '',
  nodisplay int(1) NOT NULL default '0',
  date_awaiting_toggled int(10) NOT NULL default '0',
  authcode varchar(250) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY userid (userid),
  KEY techid (tech),
  KEY category (category),
  KEY priority (priority),
  KEY date_opened (date_opened),
  UNIQUE KEY ref (ref),
  KEY is_open (is_open),
  KEY awaiting_tech (awaiting_tech),
  KEY nodisplay (nodisplay)
)

";

$queries[] = "

CREATE TABLE ticket_attachments (
  id int(10) NOT NULL auto_increment,
  filename varchar(255) NOT NULL default '0',
  filesize varchar(255) NOT NULL default '0',
  ticketid int(10) NOT NULL default '0',
  blobid int(10) NOT NULL default '0',
  techid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  temporaryid int(10) NOT NULL default '0',
  timestamp int(10) NOT NULL default '0',
  extension varchar(5) NOT NULL default '',
  toemail int(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ticketid (ticketid)
)

";

$queries[] = "

CREATE TABLE ticket_cat (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(255) default NULL,
  cat_order int(5) NOT NULL default '0',
  user_view int(1) NOT NULL default '0',
  user_select int(1) NOT NULL default '0',
  show_category int(10) NOT NULL default '0',
  require_registration tinyint(4) NOT NULL default '0',
  auto_assign_tech int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

CREATE TABLE ticket_def (
  id int(10) unsigned NOT NULL auto_increment,
  name mediumtext,
  display_name varchar(255) NOT NULL default '',
  description mediumtext,
  formtype enum('input','select','textarea','multiselect','radio','checkbox','system') NOT NULL default 'select',
  user_editable int(1) NOT NULL default '0',
  user_viewable int(1) NOT NULL default '0',
  ticket_start int(1) NOT NULL default '0',
  tech_viewable int(1) NOT NULL default '0',
  tech_editable int(1) NOT NULL default '0',
  default_value varchar(255) default NULL,
  parsed_default_value varchar(255) default NULL,
  data mediumtext NOT NULL,
  extrainput int(1) NOT NULL default '0',
  maxoptions smallint(4) NOT NULL default '0',
  minoptions smallint(4) NOT NULL default '0',
  maxlength smallint(6) NOT NULL default '0',
  minlength smallint(6) NOT NULL default '0',
  regex varchar(255) default NULL,
  error_message mediumtext,
  required int(1) NOT NULL default '0',
  length int(10) NOT NULL default '0',
  height int(10) NOT NULL default '0',
  perline int(2) NOT NULL default '1',
  displayorder int(10) NOT NULL default '0',
  extrainput_location int(1) NOT NULL default '0',
  extrainput_text varchar(250) NOT NULL default '',
  multiselect int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE ticket_message (
  id int(10) unsigned NOT NULL auto_increment,
  ticketid int(10) NOT NULL default '0',
  message mediumtext,
  date int(10) default NULL,
  techid int(10) NOT NULL default '0',
  ipaddress varchar(16) NOT NULL default '',
  sourceid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  striptags int(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ticketid (ticketid),
  KEY techid (techid)
)

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE ticket_pri (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  pri_order int(10) NOT NULL default '0',
  user_view int(1) NOT NULL default '0',
  user_select int(1) NOT NULL default '0',
  show_priority int(10) NOT NULL default '0',
  auto_assign_tech int(10) NOT NULL default '0',
  require_registration int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

CREATE TABLE `user` (
  id int(10) unsigned NOT NULL auto_increment,
  username varchar(250) NOT NULL default '',
  email varchar(250) NOT NULL default '',
  validate_key varchar(6) NOT NULL default '0',
  awaiting_validation int(1) NOT NULL default '0',
  `password` varchar(250) NOT NULL default '',
  date_registered int(10) NOT NULL default '0',
  language int(10) NOT NULL default '0',
  password_cookie varchar(8) NOT NULL default '',
  password_url varchar(8) NOT NULL default '',
  autoresponds int(1) NOT NULL default '0',
  disabled int(1) NOT NULL default '0',
  awaiting_manual_validation int(1) NOT NULL default '0',
  expire_tickets int(10) NOT NULL default '0',
  expire_date int(10) NOT NULL default '0',
  expire_type enum('none','ticket','date','both') default 'none',
  disabled_reason varchar(255) default NULL,
  timezone int(10) NOT NULL default '0',
  weekstart int(10) NOT NULL default '0',
  name varchar(250) NOT NULL default '',
  timezone_dst int(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY username (username),
  KEY email (email),
  KEY awaiting_manual_validation (awaiting_manual_validation)
)

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE user_def (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(255) default NULL,
  display_name mediumtext NOT NULL,
  description mediumtext,
  formtype enum('input','select','textarea','multiselect','radio','checkbox','system') NOT NULL default 'select',
  user_editable int(1) NOT NULL default '0',
  user_viewable int(1) NOT NULL default '0',
  user_start int(1) NOT NULL default '0',
  tech_viewable int(1) NOT NULL default '0',
  tech_editable int(1) NOT NULL default '0',
  default_value varchar(255) default NULL,
  parsed_default_value varchar(255) default NULL,
  data mediumtext NOT NULL,
  extrainput int(1) NOT NULL default '0',
  maxoptions smallint(4) NOT NULL default '0',
  minoptions smallint(4) NOT NULL default '0',
  maxlength smallint(6) NOT NULL default '0',
  minlength smallint(6) NOT NULL default '0',
  regex varchar(255) default NULL,
  error_message varchar(255) default NULL,
  required int(1) NOT NULL default '0',
  length int(10) NOT NULL default '0',
  height int(10) NOT NULL default '0',
  perline int(2) NOT NULL default '1',
  displayorder int(10) NOT NULL default '0',
  extrainput_location int(1) NOT NULL default '0',
  extrainput_text varchar(250) NOT NULL default '',
  multiselect int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE user_groups (
  id int(10) NOT NULL auto_increment,
  name varchar(250) NOT NULL default '',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

?>