tables.php

jsp程序开发系统

<?php

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE blobs (
  id int(10) unsigned NOT NULL auto_increment,
  blobdata longblob NOT NULL,
  PRIMARY KEY  (id)
)

";

$queries[] = "

CREATE TABLE calendar_task (
  id int(10) NOT NULL auto_increment,
  title varchar(250) NOT NULL default '',
  description mediumtext NOT NULL,
  techmaker int(10) NOT NULL default '0',
  multistaff int(1) NOT NULL default '0',
  globalcomplete int(1) NOT NULL default '0',
  notifycompletion int(1) NOT NULL default '0',
  repeattype int(1) NOT NULL default '0',
  value1 int(10) NOT NULL default '0',
  value2 varchar(250) NOT NULL default '0',
  starttime time NOT NULL default '00:00:00',
  startdate date NOT NULL default '0000-00-00',
  enddate date NOT NULL default '0000-00-00',
  endtime time NOT NULL default '00:00:00',
  timezone int(10) NOT NULL default '0',
  weekstart int(10) NOT NULL default '0',
  timezone_dst int(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY repeattype (repeattype),
  KEY startdate (startdate),
  KEY enddate (enddate)
)

";

$queries[] = "

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
)

";

$queries[] = "

CREATE TABLE calendar_task_tech (
  id int(10) NOT NULL auto_increment,
  eventid int(10) NOT NULL default '0',
  email_due int(1) NOT NULL default '0',
  email_before1 int(3) NOT NULL default '0',
  email_before2 int(3) NOT NULL default '0',
  techid int(1) NOT NULL default '0',
  completed int(1) NOT NULL default '0',
  stamp int(10) default '0',
  PRIMARY KEY  (id),
  KEY eventid (eventid)
)

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE faq_articles (
  id int(10) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  answer mediumtext NOT NULL,
  techid_made int(10) NOT NULL default '0',
  date_made int(10) NOT NULL default '0',
  techid_modified int(10) NOT NULL default '0',
  date_modified int(10) NOT NULL default '0',
  question mediumtext NOT NULL,
  category int(10) NOT NULL default '0',
  show_order int(10) NOT NULL default '0',
  to_validate int(1) NOT NULL default '0',
  keywords mediumtext NOT NULL,
  userid int(10) NOT NULL default '0',
  rating int(10) NOT NULL default '0',
  votes int(10) NOT NULL default '0',
  ref varchar(20) NOT NULL default '',
  question_html int(1) NOT NULL default '0',
  answer_html int(1) NOT NULL default '0',
  views int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY catid (category),
  UNIQUE KEY ref (ref)
)

";

$queries[] = "

CREATE TABLE faq_articles_related (
  show_article int(10) NOT NULL default '0',
  related_article int(10) NOT NULL default '0',
  KEY show_article (show_article)
)

";

$queries[] = "

CREATE TABLE faq_attachments (
  id int(10) NOT NULL auto_increment,
  blobid int(10) NOT NULL default '0',
  filename varchar(255) NOT NULL default '0',
  filesize varchar(255) NOT NULL default '0',
  extension varchar(10) NOT NULL default '0',
  articleid int(10) NOT NULL default '0',
  techid int(10) NOT NULL default '0',
  timestamp int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY articleid (articleid)
)

";

$queries[] = "

CREATE TABLE faq_cats (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  articles int(10) NOT NULL default '0',
  parent int(10) NOT NULL default '0',
  show_order int(10) NOT NULL default '0',
  p_loggedin int(1) NOT NULL default '0',
  p_restricted int(1) NOT NULL default '0',
  parentlist varchar(250) NOT NULL default '0',
  totalarticles int(10) NOT NULL default '0',
  newdate int(10) NOT NULL default '0',
  editdate int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY parent (parent)
)

";

$queries[] = "

CREATE TABLE faq_cats_related (
  show_cat int(10) NOT NULL default '0',
  related_cat int(10) NOT NULL default '0',
  KEY show_cat (show_cat)
)

";

$queries[] = "

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',
  new int(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY new (new),
  KEY articleid (articleid)
)

";

$queries[] = "

CREATE TABLE faq_keywords (
  articles varchar(100) NOT NULL default '',
  word varchar(50) NOT NULL default '',
  PRIMARY KEY  (word)
)

";

$queries[] = "

CREATE TABLE faq_permissions (
  catid int(10) NOT NULL default '0',
  groupid int(10) NOT NULL default '0',
  UNIQUE KEY groupid (groupid,catid)
)

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE gateway_accounts (
  id int(10) NOT NULL auto_increment,
  email char(75) NOT NULL default '',
  category int(10) NOT NULL default '0',
  priority int(10) NOT NULL default '0',
  tech int(10) NOT NULL default '0',
  auto_reply int(1) NOT NULL default '0',
  auto_new int(1) NOT NULL default '0',
  is_default int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE gateway_error (
  id int(10) NOT NULL auto_increment,
  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',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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 varchar(64) NOT NULL default 'user',
  PRIMARY KEY  (id)
)

";

$queries[] = "

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

";

$queries[] = "

CREATE TABLE gateway_source (
  id int(10) NOT NULL auto_increment,
  source mediumtext NOT NULL,
  headers mediumtext NOT NULL,
  PRIMARY KEY  (id)
)

";

$queries[] = "

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

";

$queries[] = "

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',
  isocode varchar(250) NOT NULL default '',
  contenttype varchar(250) NOT NULL default '',
  direction enum('ltr','rtl') NOT NULL default 'ltr',
  installid int(10) NOT NULL default '0',
  PRIMARY KEY (id)
)

";

$queries[] = "

CREATE TABLE 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',
  logged_in int(1) NOT NULL default '0',
  logged_out int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

CREATE TABLE pm_relations (
  pmid int(10) NOT NULL,
  techid int(10) NOT NULL default '0',
  is_read int(1) NOT NULL default '0',
  PRIMARY KEY  (pmid, techid)
)

";

$queries[] = "

CREATE TABLE pm_source (
  id int(10) NOT NULL auto_increment,
  fromid int(10) NOT NULL default '0',
  title varchar(250) NOT NULL default '',
  message mediumtext NOT NULL,
  timestamp int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
)

";

$queries[] = "

CREATE TABLE query_log (
  id int(11) NOT NULL auto_increment,
  query mediumtext,
  explain_log mediumtext,
  duration decimal(15,10) default NULL,
  stamp int(11) default NULL,
  filename varchar(250) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY duration (duration),
  KEY stamp (stamp)
)

";

$queries[] = "