mambax7/gwiki

#
# gwiki tables v1.0
#

CREATE TABLE gwiki_pages (
  gwiki_id         INT(10)      NOT NULL AUTO_INCREMENT,
  keyword          VARCHAR(128) NOT NULL DEFAULT '',
  display_keyword  VARCHAR(128) NOT NULL DEFAULT '',
  title            VARCHAR(255) NOT NULL DEFAULT '',
  body             TEXT         NOT NULL,
  parent_page      VARCHAR(128) NOT NULL DEFAULT '',
  page_set_home    VARCHAR(128) NOT NULL DEFAULT '',
  page_set_order   INT(4)       NOT NULL DEFAULT '0',
  meta_description TEXT         NOT NULL,
  meta_keywords    VARCHAR(512) NOT NULL DEFAULT '',
  lastmodified     INT(10)      NOT NULL DEFAULT '0',
  uid              INT(10)      NOT NULL DEFAULT '0',
  admin_lock       TINYINT      NOT NULL DEFAULT '0',
  active           TINYINT      NOT NULL DEFAULT '0',
  search_body      TEXT         NOT NULL,
  toc_cache        TEXT         NOT NULL,
  show_in_index    TINYINT      NOT NULL DEFAULT 1,
  gwiki_version    INT(4)       NOT NULL DEFAULT '0',

  PRIMARY KEY (gwiki_id, active),
  KEY activekey (active, keyword),
  KEY keyword (keyword),
  KEY parent (active, parent_page),
  KEY pageset (active, page_set_home),
  KEY lastmod (active, lastmodified),
  KEY pageindex (active, show_in_index, display_keyword)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_pageids (
  page_id   INT(10)      NOT NULL AUTO_INCREMENT,
  keyword   VARCHAR(128) NOT NULL DEFAULT '',
  created   INT(10)      NOT NULL DEFAULT '0',
  hit_count INT(10)      NOT NULL DEFAULT '0',

  PRIMARY KEY (page_id),
  UNIQUE KEY (keyword)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_group_prefix (
  group_prefix_id INT(10) NOT NULL AUTO_INCREMENT,
  group_id        INT(10) NOT NULL DEFAULT '0',
  prefix_id       INT(10) NOT NULL DEFAULT '0',

  PRIMARY KEY (group_prefix_id)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_prefix (
  prefix_id           INT(10)      NOT NULL AUTO_INCREMENT,
  prefix              VARCHAR(128) NOT NULL DEFAULT '',
  prefix_home         VARCHAR(128) NOT NULL DEFAULT '',
  prefix_auto_name    TINYINT(1)   NOT NULL DEFAULT '0',
  prefix_template_id  INT(10)      NOT NULL DEFAULT '0',
  prefix_is_external  TINYINT(1)   NOT NULL DEFAULT '0',
  prefix_external_url VARCHAR(512) NOT NULL DEFAULT '',

  PRIMARY KEY (prefix_id),
  UNIQUE KEY (prefix)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_template (
  template_id    INT(10)      NOT NULL AUTO_INCREMENT,
  template       VARCHAR(128) NOT NULL DEFAULT '',
  template_body  TEXT         NOT NULL,
  template_notes TEXT         NOT NULL,

  PRIMARY KEY (template_id)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_page_images (
  image_id         INT(10)      NOT NULL AUTO_INCREMENT,
  keyword          VARCHAR(128) NOT NULL DEFAULT '',
  image_name       VARCHAR(128) NOT NULL DEFAULT '',
  image_alt_text   VARCHAR(255) NOT NULL DEFAULT '',
  image_file       VARCHAR(255) NOT NULL DEFAULT '',
  use_to_represent INT(1)       NOT NULL DEFAULT '0',

  PRIMARY KEY (image_id),
  UNIQUE KEY (keyword, image_name)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_page_files (
  file_id          INT(10)      NOT NULL AUTO_INCREMENT,
  keyword          VARCHAR(128) NOT NULL DEFAULT '',
  file_name        VARCHAR(128) NOT NULL DEFAULT '',
  file_path        VARCHAR(255) NOT NULL DEFAULT '',
  file_type        VARCHAR(128) NOT NULL DEFAULT '',
  file_icon        VARCHAR(64)  NOT NULL DEFAULT '',
  file_size        INT(10)      NOT NULL DEFAULT '0',
  file_upload_date INT(10)      NOT NULL DEFAULT '0',
  file_description TEXT,
  file_uid         INT(10)      NOT NULL DEFAULT '0',

  PRIMARY KEY (file_id),
  UNIQUE KEY (keyword, file_name)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

CREATE TABLE gwiki_pagelinks (
  from_keyword VARCHAR(128) NOT NULL DEFAULT '',
  to_keyword   VARCHAR(128) NOT NULL DEFAULT '',

  PRIMARY KEY (from_keyword, to_keyword),
  KEY (to_keyword),
  KEY (from_keyword)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;