|
|
| Line 1: |
Line 1: |
| − | ---
| + | [http://www.geeklog.net/filemgmt/visit.php?lid=902 Geelook 1.5 beta Diagram] |
| − | --- CREATE DATABASE: geeklog 1.5 beta
| |
| − | ---
| |
| − | CREATE DATABASE IF NOT EXISTS geek
| |
| − | CHARACTER SET latin1;
| |
| − | | |
| − | CREATE TABLE IF NOT EXISTS geek.gl_access
| |
| − | (
| |
| − | acc_ft_id MEDIUMINT(8) NOT NULL DEFAULT 0,
| |
| − | acc_grp_id MEDIUMINT(8) NOT NULL DEFAULT 0,
| |
| − | CONSTRAINT PRIMARY KEY (acc_ft_id, acc_grp_id)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 7
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = FIXED;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_article_images
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_article_images
| |
| − | (
| |
| − | ai_sid VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | ai_img_num TINYINT(2) UNSIGNED NOT NULL,
| |
| − | ai_filename VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (ai_sid, ai_img_num)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_blocks
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_blocks
| |
| − | (
| |
| − | bid SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | is_enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | name VARCHAR(48) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | type VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'normal',
| |
| − | title VARCHAR(48) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | tid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'All',
| |
| − | blockorder SMALLINT(5) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | content TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | allow_autotags TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | rdfurl VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | rdfupdated DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
| |
| − | rdf_last_modified VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | rdf_etag VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | rdflimit SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | onleft TINYINT(3) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | phpblockfn VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | help VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | CONSTRAINT PRIMARY KEY (bid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 112
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: blocks_bid
| |
| − | --
| |
| − | CREATE INDEX blocks_bid ON geek.gl_blocks
| |
| − | (
| |
| − | bid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: blocks_is_enabled
| |
| − | --
| |
| − | CREATE INDEX blocks_is_enabled ON geek.gl_blocks
| |
| − | (
| |
| − | is_enabled
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: blocks_tid
| |
| − | --
| |
| − | CREATE INDEX blocks_tid ON geek.gl_blocks
| |
| − | (
| |
| − | tid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: blocks_type
| |
| − | --
| |
| − | CREATE INDEX blocks_type ON geek.gl_blocks
| |
| − | (
| |
| − | type
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: blocks_name
| |
| − | --
| |
| − | CREATE INDEX blocks_name ON geek.gl_blocks
| |
| − | (
| |
| − | name
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: blocks_onleft
| |
| − | --
| |
| − | CREATE INDEX blocks_onleft ON geek.gl_blocks
| |
| − | (
| |
| − | onleft
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_commentcodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_commentcodes
| |
| − | (
| |
| − | code TINYINT NOT NULL DEFAULT 0,
| |
| − | name VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 24
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_commentmodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_commentmodes
| |
| − | (
| |
| − | mode VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | name VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (mode)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 23
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_comments
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_comments
| |
| − | (
| |
| − | cid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | type VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'article',
| |
| − | sid VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | date DATETIME NULL,
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | comment TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | score TINYINT NOT NULL DEFAULT 0,
| |
| − | reason TINYINT NOT NULL DEFAULT 0,
| |
| − | pid INT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | lft MEDIUMINT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | rht MEDIUMINT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | indent MEDIUMINT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | ipaddress VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (cid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: comments_sid
| |
| − | --
| |
| − | CREATE INDEX comments_sid ON geek.gl_comments
| |
| − | (
| |
| − | sid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: comments_uid
| |
| − | --
| |
| − | CREATE INDEX comments_uid ON geek.gl_comments
| |
| − | (
| |
| − | uid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: comments_lft
| |
| − | --
| |
| − | CREATE INDEX comments_lft ON geek.gl_comments
| |
| − | (
| |
| − | lft
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: comments_rht
| |
| − | --
| |
| − | CREATE INDEX comments_rht ON geek.gl_comments
| |
| − | (
| |
| − | rht
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: comments_date
| |
| − | --
| |
| − | CREATE INDEX comments_date ON geek.gl_comments
| |
| − | (
| |
| − | date
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_conf_values
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_conf_values
| |
| − | (
| |
| − | name VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | value TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | type VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | group_name VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | default_value TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | subgroup INT NULL,
| |
| − | selectionArray INT NULL,
| |
| − | sort_order INT NULL,
| |
| − | fieldset INT NULL
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 77
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_cookiecodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_cookiecodes
| |
| − | (
| |
| − | cc_value INT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | cc_descr VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (cc_value)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 20
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_dateformats
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_dateformats
| |
| − | (
| |
| − | dfid TINYINT NOT NULL DEFAULT 0,
| |
| − | format VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | description VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (dfid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 44
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_events
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_events
| |
| − | (
| |
| − | eid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | postmode VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'plaintext',
| |
| − | datestart DATE NULL,
| |
| − | dateend DATE NULL,
| |
| − | url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | hits MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | address1 VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | address2 VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | city VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | state VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | zipcode VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | allday TINYINT(1) NOT NULL DEFAULT 0,
| |
| − | event_type VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | location VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | timestart TIME NULL,
| |
| − | timeend TIME NULL,
| |
| − | CONSTRAINT PRIMARY KEY (eid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: events_eid
| |
| − | --
| |
| − | CREATE INDEX events_eid ON geek.gl_events
| |
| − | (
| |
| − | eid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: events_event_type
| |
| − | --
| |
| − | CREATE INDEX events_event_type ON geek.gl_events
| |
| − | (
| |
| − | event_type
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: events_datestart
| |
| − | --
| |
| − | CREATE INDEX events_datestart ON geek.gl_events
| |
| − | (
| |
| − | datestart
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: events_dateend
| |
| − | --
| |
| − | CREATE INDEX events_dateend ON geek.gl_events
| |
| − | (
| |
| − | dateend
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_eventsubmission
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_eventsubmission
| |
| − | (
| |
| − | eid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | location VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | datestart DATE NULL,
| |
| − | dateend DATE NULL,
| |
| − | url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | allday TINYINT(1) NOT NULL DEFAULT 0,
| |
| − | zipcode VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | state VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | city VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | address2 VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | address1 VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | event_type VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | timestart TIME NULL,
| |
| − | timeend TIME NULL,
| |
| − | CONSTRAINT PRIMARY KEY (eid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 148
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_featurecodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_featurecodes
| |
| − | (
| |
| − | code TINYINT NOT NULL DEFAULT 0,
| |
| − | name VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 20
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_features
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_features
| |
| − | (
| |
| − | ft_id MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
| |
| − | ft_name VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | ft_descr VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | ft_gl_core TINYINT(1) NOT NULL DEFAULT 0,
| |
| − | CONSTRAINT PRIMARY KEY (ft_id)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 52
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: ft_name
| |
| − | --
| |
| − | CREATE INDEX ft_name ON geek.gl_features
| |
| − | (
| |
| − | ft_name
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_frontpagecodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_frontpagecodes
| |
| − | (
| |
| − | code TINYINT NOT NULL DEFAULT 0,
| |
| − | name VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 24
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_group_assignments
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_group_assignments
| |
| − | (
| |
| − | ug_main_grp_id MEDIUMINT(8) NOT NULL DEFAULT 0,
| |
| − | ug_uid MEDIUMINT(8) UNSIGNED NULL,
| |
| − | ug_grp_id MEDIUMINT(8) UNSIGNED NULL
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 10
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = FIXED;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: group_assignments_ug_main_grp_id
| |
| − | --
| |
| − | CREATE INDEX group_assignments_ug_main_grp_id ON geek.gl_group_assignments
| |
| − | (
| |
| − | ug_main_grp_id
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: group_assignments_ug_uid
| |
| − | --
| |
| − | CREATE INDEX group_assignments_ug_uid ON geek.gl_group_assignments
| |
| − | (
| |
| − | ug_uid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: ug_main_grp_id
| |
| − | --
| |
| − | CREATE INDEX ug_main_grp_id ON geek.gl_group_assignments
| |
| − | (
| |
| − | ug_main_grp_id
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_groups
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_groups
| |
| − | (
| |
| − | grp_id MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
| |
| − | grp_name VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | grp_descr VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | grp_gl_core TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | CONSTRAINT PRIMARY KEY (grp_id),
| |
| − | CONSTRAINT grp_name UNIQUE (grp_name)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 59
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_linkcategories
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_linkcategories
| |
| − | (
| |
| − | cid VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | pid VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | category VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | tid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | created DATETIME NULL,
| |
| − | modified DATETIME NULL,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | CONSTRAINT PRIMARY KEY (cid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 86
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: links_pid
| |
| − | --
| |
| − | CREATE INDEX links_pid ON geek.gl_linkcategories
| |
| − | (
| |
| − | pid
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_links
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_links
| |
| − | (
| |
| − | lid VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | cid VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | title VARCHAR(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | hits INT NOT NULL DEFAULT 0,
| |
| − | date DATETIME NULL,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | CONSTRAINT PRIMARY KEY (lid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 192
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: links_category
| |
| − | --
| |
| − | CREATE INDEX links_category ON geek.gl_links
| |
| − | (
| |
| − | cid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: links_date
| |
| − | --
| |
| − | CREATE INDEX links_date ON geek.gl_links
| |
| − | (
| |
| − | date
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_linksubmission
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_linksubmission
| |
| − | (
| |
| − | lid VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | cid VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | title VARCHAR(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | hits INT NULL,
| |
| − | date DATETIME NULL,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | CONSTRAINT PRIMARY KEY (lid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_maillist
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_maillist
| |
| − | (
| |
| − | code INT(1) NOT NULL DEFAULT 0,
| |
| − | name CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 37
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = FIXED;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_personal_events
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_personal_events
| |
| − | (
| |
| − | eid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 0,
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | event_type VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | datestart DATE NULL,
| |
| − | dateend DATE NULL,
| |
| − | address1 VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | address2 VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | city VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | state VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | zipcode VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | allday TINYINT(1) NOT NULL DEFAULT 0,
| |
| − | url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | postmode VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'plaintext',
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | location VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | timestart TIME NULL,
| |
| − | timeend TIME NULL,
| |
| − | CONSTRAINT PRIMARY KEY (eid, uid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_pingservice
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_pingservice
| |
| − | (
| |
| − | pid SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | name VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | ping_url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | site_url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | method VARCHAR(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | is_enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | CONSTRAINT PRIMARY KEY (pid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 92
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: pingservice_is_enabled
| |
| − | --
| |
| − | CREATE INDEX pingservice_is_enabled ON geek.gl_pingservice
| |
| − | (
| |
| − | is_enabled
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_plugins
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_plugins
| |
| − | (
| |
| − | pi_name VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | pi_version VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | pi_gl_version VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | pi_enabled TINYINT(3) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | pi_homepage VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (pi_name)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 56
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: plugins_enabled
| |
| − | --
| |
| − | CREATE INDEX plugins_enabled ON geek.gl_plugins
| |
| − | (
| |
| − | pi_enabled
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_pollanswers
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_pollanswers
| |
| − | (
| |
| − | pid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | qid MEDIUMINT NOT NULL DEFAULT 0,
| |
| − | aid TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | answer VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | votes MEDIUMINT(8) UNSIGNED NULL,
| |
| − | remark VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (pid, qid, aid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 46
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_pollquestions
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_pollquestions
| |
| − | (
| |
| − | qid MEDIUMINT NOT NULL DEFAULT 0,
| |
| − | pid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | question VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (qid, pid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 68
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_polltopics
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_polltopics
| |
| − | (
| |
| − | pid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | topic VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | voters MEDIUMINT(8) UNSIGNED NULL,
| |
| − | questions INT NOT NULL DEFAULT 0,
| |
| − | date DATETIME NULL,
| |
| − | display TINYINT NOT NULL DEFAULT 0,
| |
| − | open TINYINT(1) NOT NULL DEFAULT 1,
| |
| − | hideresults TINYINT(1) NOT NULL DEFAULT 0,
| |
| − | commentcode TINYINT NOT NULL DEFAULT 0,
| |
| − | statuscode TINYINT NOT NULL DEFAULT 0,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | CONSTRAINT PRIMARY KEY (pid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 88
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: pollquestions_pid
| |
| − | --
| |
| − | CREATE INDEX pollquestions_pid ON geek.gl_polltopics
| |
| − | (
| |
| − | pid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: pollquestions_date
| |
| − | --
| |
| − | CREATE INDEX pollquestions_date ON geek.gl_polltopics
| |
| − | (
| |
| − | date
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: pollquestions_display
| |
| − | --
| |
| − | CREATE INDEX pollquestions_display ON geek.gl_polltopics
| |
| − | (
| |
| − | display
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: pollquestions_commentcode
| |
| − | --
| |
| − | CREATE INDEX pollquestions_commentcode ON geek.gl_polltopics
| |
| − | (
| |
| − | commentcode
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: pollquestions_statuscode
| |
| − | --
| |
| − | CREATE INDEX pollquestions_statuscode ON geek.gl_polltopics
| |
| − | (
| |
| − | statuscode
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_pollvoters
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_pollvoters
| |
| − | (
| |
| − | id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | pid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | ipaddress VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | date INT(10) UNSIGNED NULL,
| |
| − | CONSTRAINT PRIMARY KEY (id)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_postmodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_postmodes
| |
| − | (
| |
| − | code CHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | name CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 43
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = FIXED;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_sessions
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_sessions
| |
| − | (
| |
| − | sess_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | start_time INT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | remote_ip VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | md5_sess_id VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (sess_id)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 28
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: sess_id
| |
| − | --
| |
| − | CREATE INDEX sess_id ON geek.gl_sessions
| |
| − | (
| |
| − | sess_id
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: start_time
| |
| − | --
| |
| − | CREATE INDEX start_time ON geek.gl_sessions
| |
| − | (
| |
| − | start_time
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: remote_ip
| |
| − | --
| |
| − | CREATE INDEX remote_ip ON geek.gl_sessions
| |
| − | (
| |
| − | remote_ip
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_sortcodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_sortcodes
| |
| − | (
| |
| − | code CHAR(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
| |
| − | name CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 37
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = FIXED;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_spamx
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_spamx
| |
| − | (
| |
| − | name VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | value VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: spamx_name
| |
| − | --
| |
| − | CREATE INDEX spamx_name ON geek.gl_spamx
| |
| − | (
| |
| − | name
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_speedlimit
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_speedlimit
| |
| − | (
| |
| − | id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | ipaddress VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | date INT(10) UNSIGNED NULL,
| |
| − | type VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'submit',
| |
| − | CONSTRAINT PRIMARY KEY (id)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: type_ipaddress
| |
| − | --
| |
| − | CREATE INDEX type_ipaddress ON geek.gl_speedlimit
| |
| − | (
| |
| − | type,
| |
| − | ipaddress
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: date
| |
| − | --
| |
| − | CREATE INDEX date ON geek.gl_speedlimit
| |
| − | (
| |
| − | date
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_staticpage
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_staticpage
| |
| − | (
| |
| − | sp_id VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | sp_uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | sp_title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | sp_content TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | sp_hits MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | sp_date DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
| |
| − | sp_format VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | sp_onmenu TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | sp_label VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | commentcode TINYINT NOT NULL DEFAULT 0,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | sp_centerblock TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | sp_help VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | sp_tid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'none',
| |
| − | sp_where TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | sp_php TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | sp_nf TINYINT(1) UNSIGNED NULL DEFAULT 0,
| |
| − | sp_inblock TINYINT(1) UNSIGNED NULL DEFAULT 1,
| |
| − | postmode VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'html',
| |
| − | CONSTRAINT PRIMARY KEY (sp_id)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: staticpage_sp_uid
| |
| − | --
| |
| − | CREATE INDEX staticpage_sp_uid ON geek.gl_staticpage
| |
| − | (
| |
| − | sp_uid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: staticpage_sp_date
| |
| − | --
| |
| − | CREATE INDEX staticpage_sp_date ON geek.gl_staticpage
| |
| − | (
| |
| − | sp_date
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: staticpage_sp_onmenu
| |
| − | --
| |
| − | CREATE INDEX staticpage_sp_onmenu ON geek.gl_staticpage
| |
| − | (
| |
| − | sp_onmenu
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: staticpage_sp_centerblock
| |
| − | --
| |
| − | CREATE INDEX staticpage_sp_centerblock ON geek.gl_staticpage
| |
| − | (
| |
| − | sp_centerblock
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: staticpage_sp_tid
| |
| − | --
| |
| − | CREATE INDEX staticpage_sp_tid ON geek.gl_staticpage
| |
| − | (
| |
| − | sp_tid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: staticpage_sp_where
| |
| − | --
| |
| − | CREATE INDEX staticpage_sp_where ON geek.gl_staticpage
| |
| − | (
| |
| − | sp_where
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_statuscodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_statuscodes
| |
| − | (
| |
| − | code INT(1) NOT NULL DEFAULT 0,
| |
| − | name CHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 37
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = FIXED;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_stories
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_stories
| |
| − | (
| |
| − | sid VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | draft_flag TINYINT(3) UNSIGNED NULL DEFAULT 0,
| |
| − | tid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'General',
| |
| − | date DATETIME NULL,
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | introtext TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | bodytext TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | hits MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | numemails MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | comments MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | trackbacks MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | related TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | featured TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | show_topic_icon TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | commentcode TINYINT NOT NULL DEFAULT 0,
| |
| − | trackbackcode TINYINT NOT NULL DEFAULT 0,
| |
| − | statuscode TINYINT NOT NULL DEFAULT 0,
| |
| − | expire DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
| |
| − | postmode VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'html',
| |
| − | advanced_editor_mode TINYINT(1) UNSIGNED NULL DEFAULT 0,
| |
| − | frontpage TINYINT(3) UNSIGNED NULL DEFAULT 1,
| |
| − | in_transit TINYINT(1) UNSIGNED NULL DEFAULT 0,
| |
| − | owner_id MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) NOT NULL DEFAULT 2,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | CONSTRAINT PRIMARY KEY (sid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 636
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_sid
| |
| − | --
| |
| − | CREATE INDEX stories_sid ON geek.gl_stories
| |
| − | (
| |
| − | sid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_tid
| |
| − | --
| |
| − | CREATE INDEX stories_tid ON geek.gl_stories
| |
| − | (
| |
| − | tid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_uid
| |
| − | --
| |
| − | CREATE INDEX stories_uid ON geek.gl_stories
| |
| − | (
| |
| − | uid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_featured
| |
| − | --
| |
| − | CREATE INDEX stories_featured ON geek.gl_stories
| |
| − | (
| |
| − | featured
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_hits
| |
| − | --
| |
| − | CREATE INDEX stories_hits ON geek.gl_stories
| |
| − | (
| |
| − | hits
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_statuscode
| |
| − | --
| |
| − | CREATE INDEX stories_statuscode ON geek.gl_stories
| |
| − | (
| |
| − | statuscode
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_expire
| |
| − | --
| |
| − | CREATE INDEX stories_expire ON geek.gl_stories
| |
| − | (
| |
| − | expire
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_date
| |
| − | --
| |
| − | CREATE INDEX stories_date ON geek.gl_stories
| |
| − | (
| |
| − | date
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_frontpage
| |
| − | --
| |
| − | CREATE INDEX stories_frontpage ON geek.gl_stories
| |
| − | (
| |
| − | frontpage
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: stories_in_transit
| |
| − | --
| |
| − | CREATE INDEX stories_in_transit ON geek.gl_stories
| |
| − | (
| |
| − | in_transit
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_storysubmission
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_storysubmission
| |
| − | (
| |
| − | sid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | tid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'General',
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | introtext TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | bodytext TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | date DATETIME NULL,
| |
| − | postmode VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'html',
| |
| − | CONSTRAINT PRIMARY KEY (sid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 308
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_syndication
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_syndication
| |
| − | (
| |
| − | fid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | type VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'geeklog',
| |
| − | topic VARCHAR(48) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '::all',
| |
| − | header_tid VARCHAR(48) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'none',
| |
| − | format VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'RSS-2.0',
| |
| − | limits VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '10',
| |
| − | content_length SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | title VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | description TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | feedlogo VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | filename VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'geeklog.rss',
| |
| − | charset VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'UTF-8',
| |
| − | language VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'en-gb',
| |
| − | is_enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | updated DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
| |
| − | update_info TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (fid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 112
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: syndication_type
| |
| − | --
| |
| − | CREATE INDEX syndication_type ON geek.gl_syndication
| |
| − | (
| |
| − | type
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: syndication_topic
| |
| − | --
| |
| − | CREATE INDEX syndication_topic ON geek.gl_syndication
| |
| − | (
| |
| − | topic
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: syndication_is_enabled
| |
| − | --
| |
| − | CREATE INDEX syndication_is_enabled ON geek.gl_syndication
| |
| − | (
| |
| − | is_enabled
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: syndication_updated
| |
| − | --
| |
| − | CREATE INDEX syndication_updated ON geek.gl_syndication
| |
| − | (
| |
| − | updated
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_tokens
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_tokens
| |
| − | (
| |
| − | token VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | created DATETIME NOT NULL,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL,
| |
| − | urlfor VARCHAR(2000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | ttl MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | CONSTRAINT PRIMARY KEY (token)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 120
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_topics
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_topics
| |
| − | (
| |
| − | tid VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | topic VARCHAR(48) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | imageurl VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | sortnum TINYINT(3) NULL,
| |
| − | limitnews TINYINT(3) NULL,
| |
| − | is_default TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | archive_flag TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | owner_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | group_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | perm_owner TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_group TINYINT(1) UNSIGNED NOT NULL DEFAULT 3,
| |
| − | perm_members TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | perm_anon TINYINT(1) UNSIGNED NOT NULL DEFAULT 2,
| |
| − | CONSTRAINT PRIMARY KEY (tid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 68
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_trackback
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_trackback
| |
| − | (
| |
| − | cid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
| |
| − | sid VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | url VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | title VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | blog VARCHAR(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | excerpt TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | date DATETIME NULL,
| |
| − | type VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'article',
| |
| − | ipaddress VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (cid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: trackback_sid
| |
| − | --
| |
| − | CREATE INDEX trackback_sid ON geek.gl_trackback
| |
| − | (
| |
| − | sid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: trackback_url
| |
| − | --
| |
| − | CREATE INDEX trackback_url ON geek.gl_trackback
| |
| − | (
| |
| − | url
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: trackback_type
| |
| − | --
| |
| − | CREATE INDEX trackback_type ON geek.gl_trackback
| |
| − | (
| |
| − | type
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: trackback_date
| |
| − | --
| |
| − | CREATE INDEX trackback_date ON geek.gl_trackback
| |
| − | (
| |
| − | date
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_trackbackcodes
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_trackbackcodes
| |
| − | (
| |
| − | code TINYINT NOT NULL DEFAULT 0,
| |
| − | name VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (code)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 24
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_usercomment
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_usercomment
| |
| − | (
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | commentmode VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'threaded',
| |
| − | commentorder VARCHAR(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'ASC',
| |
| − | commentlimit MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 100,
| |
| − | CONSTRAINT PRIMARY KEY (uid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 24
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_userindex
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_userindex
| |
| − | (
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | tids VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | etids TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | aids VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | boxes VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | noboxes TINYINT NOT NULL DEFAULT 0,
| |
| − | maxstories TINYINT NULL,
| |
| − | CONSTRAINT PRIMARY KEY (uid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 20
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: userindex_uid
| |
| − | --
| |
| − | CREATE INDEX userindex_uid ON geek.gl_userindex
| |
| − | (
| |
| − | uid
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: userindex_noboxes
| |
| − | --
| |
| − | CREATE INDEX userindex_noboxes ON geek.gl_userindex
| |
| − | (
| |
| − | noboxes
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: userindex_maxstories
| |
| − | --
| |
| − | CREATE INDEX userindex_maxstories ON geek.gl_userindex
| |
| − | (
| |
| − | maxstories
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_userinfo
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_userinfo
| |
| − | (
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | about TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | location VARCHAR(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | pgpkey TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | userspace VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | tokens TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | totalcomments MEDIUMINT NOT NULL DEFAULT 0,
| |
| − | lastgranted INT(10) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | lastlogin VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
| |
| − | CONSTRAINT PRIMARY KEY (uid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 30
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_userprefs
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_userprefs
| |
| − | (
| |
| − | uid MEDIUMINT(8) NOT NULL DEFAULT 1,
| |
| − | noicons TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | willing TINYINT(3) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | dfid TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
| |
| − | tzid VARCHAR(125) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | emailstories TINYINT NOT NULL DEFAULT 1,
| |
| − | emailfromadmin TINYINT(1) NOT NULL DEFAULT 1,
| |
| − | emailfromuser TINYINT(1) NOT NULL DEFAULT 1,
| |
| − | showonline TINYINT(1) NOT NULL DEFAULT 1,
| |
| − | CONSTRAINT PRIMARY KEY (uid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 20
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | --
| |
| − | -- CREATE TABLE: gl_users
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_users
| |
| − | (
| |
| − | uid MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
| |
| − | username VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | remoteusername VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | remoteservice VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | fullname VARCHAR(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | passwd VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | email VARCHAR(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | homepage VARCHAR(96) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | sig VARCHAR(160) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | regdate DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00,
| |
| − | photo VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | cookietimeout INT(8) UNSIGNED NULL DEFAULT 28800,
| |
| − | theme VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | language VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | pwrequestid VARCHAR(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | status SMALLINT(5) UNSIGNED NOT NULL DEFAULT 1,
| |
| − | num_reminders TINYINT(1) NOT NULL DEFAULT 0,
| |
| − | CONSTRAINT PRIMARY KEY (uid)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 112
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: LOGIN
| |
| − | --
| |
| − | CREATE INDEX LOGIN ON geek.gl_users
| |
| − | (
| |
| − | uid,
| |
| − | passwd,
| |
| − | username
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: users_username
| |
| − | --
| |
| − | CREATE INDEX users_username ON geek.gl_users
| |
| − | (
| |
| − | username
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: users_fullname
| |
| − | --
| |
| − | CREATE INDEX users_fullname ON geek.gl_users
| |
| − | (
| |
| − | fullname
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: users_email
| |
| − | --
| |
| − | CREATE INDEX users_email ON geek.gl_users
| |
| − | (
| |
| − | email
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: users_passwd
| |
| − | --
| |
| − | CREATE INDEX users_passwd ON geek.gl_users
| |
| − | (
| |
| − | passwd
| |
| − | );
| |
| − | | |
| − | --
| |
| − | -- CREATE INDEX: users_pwrequestid
| |
| − | --
| |
| − | CREATE INDEX users_pwrequestid ON geek.gl_users
| |
| − | (
| |
| − | pwrequestid
| |
| − | );
| |
| − | --
| |
| − | -- CREATE TABLE: gl_vars
| |
| − | --
| |
| − | CREATE TABLE IF NOT EXISTS geek.gl_vars
| |
| − | (
| |
| − | name VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
| |
| − | value VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
| |
| − | CONSTRAINT PRIMARY KEY (name)
| |
| − | )
| |
| − | ENGINE = MyISAM
| |
| − | AVG_ROW_LENGTH = 28
| |
| − | COLLATE latin1_swedish_ci
| |
| − | ROW_FORMAT = DYNAMIC;
| |
