GeeklogWiki - User contributions [en]

Geeklog 1.5

2008-05-12T19:07:51Z

Dtrumbower:

[http://www.geeklog.net/filemgmt/visit.php?lid=902 Geelook 1.5 beta Diagram]

Geeklog 1.5

2008-05-12T16:48:05Z

Dtrumbower:

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

Geeklog 1.5

2008-05-12T16:44:58Z

Dtrumbower:

Programmers/Developers Documentation

2008-05-12T16:43:18Z

Dtrumbower:

# [[Introduction]]
# [[Installation]]
# [[Administration]]
# [[Users Documentation]]
# Programmers/Developers Documentation
## [[Beginner's Guide to Programming]]
### [[Coding Guidelines|Geeklog Coding Standards]]
### [[Security and Common Practices]]
## [[Plugin Development]]
### [[Plugin Developers Handbook]]
### Plugin API
###* [[Extending Site Statistics with your plugin|Statistics]]
###* [[Integrating the Comment Engine|Comments]]
###* [[Using Geeklog's Search Engine|Search]]
###* [[Adding Moderation Capability|Moderation]]
###* [[RSS API]]
###* [[Misc Plugin API's that dont fit any where else|Misc]]
###* [[PluginConfiguration]]
## Misc. Programming Topics
### [[StripSlashes|A Note on StripSlashes and Other Friends]]
### [[StoryArchitecture|The Story Architecture]]
### [[AdminLists|Displaying Tables]]
### [[DatabaseSchema|Database Schema]]
###* [[Geeklog 1.5]]
### [[CVS]]
### [[Google Summer of Code|Google Summer of Code™]]
## Related Topics
### [[Translations]]
### [[Theme Developers Guide]]

[[Geeklog Documentation|Main Table of Contents]]<br>
[[Complete Table of Contents]]

DatabaseSchema

2007-09-18T16:46:34Z

Dtrumbower:

--
-- Database: `geeklog 1.4.1`
--

-- --------------------------------------------------------

--
-- Table structure for table `gl_access`
--

CREATE TABLE `gl_access` (
`acc_ft_id` mediumint(8) NOT NULL default '0',
`acc_grp_id` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`acc_ft_id`,`acc_grp_id`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_article_images`
--

CREATE TABLE `gl_article_images` (
`ai_sid` varchar(40) NOT NULL,
`ai_img_num` tinyint(2) unsigned NOT NULL,
`ai_filename` varchar(128) NOT NULL,
PRIMARY KEY (`ai_sid`,`ai_img_num`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_blocks`
--

CREATE TABLE `gl_blocks` (
`bid` smallint(5) unsigned NOT NULL auto_increment,
`is_enabled` tinyint(1) unsigned NOT NULL default '1',
`name` varchar(48) NOT NULL default '',
`type` varchar(20) NOT NULL default 'normal',
`title` varchar(48) default NULL,
`tid` varchar(20) NOT NULL default 'All',
`blockorder` smallint(5) unsigned NOT NULL default '1',
`content` text,
`allow_autotags` tinyint(1) unsigned NOT NULL default '0',
`rdfurl` varchar(255) default NULL,
`rdfupdated` datetime NOT NULL default '0000-00-00 00:00:00',
`rdflimit` smallint(5) unsigned NOT NULL default '0',
`onleft` tinyint(3) unsigned NOT NULL default '1',
`phpblockfn` varchar(64) default '',
`help` varchar(255) default '',
`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',
PRIMARY KEY (`bid`),
KEY `blocks_bid` (`bid`),
KEY `blocks_is_enabled` (`is_enabled`),
KEY `blocks_tid` (`tid`),
KEY `blocks_type` (`type`),
KEY `blocks_name` (`name`),
KEY `blocks_onleft` (`onleft`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_commentcodes`
--

CREATE TABLE `gl_commentcodes` (
`code` tinyint(4) NOT NULL default '0',
`name` varchar(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_commentmodes`
--

CREATE TABLE `gl_commentmodes` (
`mode` varchar(10) NOT NULL default '',
`name` varchar(32) default NULL,
PRIMARY KEY (`mode`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_comments`
--

CREATE TABLE `gl_comments` (
`cid` int(10) unsigned NOT NULL auto_increment,
`type` varchar(30) NOT NULL default 'article',
`sid` varchar(40) NOT NULL default '',
`date` datetime default NULL,
`title` varchar(128) default NULL,
`comment` text,
`score` tinyint(4) NOT NULL default '0',
`reason` tinyint(4) 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) NOT NULL default '',
PRIMARY KEY (`cid`),
KEY `comments_sid` (`sid`),
KEY `comments_uid` (`uid`),
KEY `comments_lft` (`lft`),
KEY `comments_rht` (`rht`),
KEY `comments_date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_cookiecodes`
--

CREATE TABLE `gl_cookiecodes` (
`cc_value` int(8) unsigned NOT NULL default '0',
`cc_descr` varchar(20) NOT NULL default '',
PRIMARY KEY (`cc_value`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_dateformats`
--

CREATE TABLE `gl_dateformats` (
`dfid` tinyint(4) NOT NULL default '0',
`format` varchar(32) default NULL,
`description` varchar(64) default NULL,
PRIMARY KEY (`dfid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_events`
--

CREATE TABLE `gl_events` (
`eid` varchar(20) NOT NULL default '',
`title` varchar(128) default NULL,
`description` text,
`postmode` varchar(10) NOT NULL default 'plaintext',
`datestart` date default NULL,
`dateend` date default NULL,
`url` varchar(255) default 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) default NULL,
`address2` varchar(40) default NULL,
`city` varchar(60) default NULL,
`state` char(2) default NULL,
`zipcode` varchar(5) default NULL,
`allday` tinyint(1) NOT NULL default '0',
`event_type` varchar(40) NOT NULL default '',
`location` varchar(128) default NULL,
`timestart` time default NULL,
`timeend` time default NULL,
PRIMARY KEY (`eid`),
KEY `events_eid` (`eid`),
KEY `events_event_type` (`event_type`),
KEY `events_datestart` (`datestart`),
KEY `events_dateend` (`dateend`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_eventsubmission`
--

CREATE TABLE `gl_eventsubmission` (
`eid` varchar(20) NOT NULL default '',
`title` varchar(128) default NULL,
`description` text,
`location` varchar(128) default NULL,
`datestart` date default NULL,
`dateend` date default NULL,
`url` varchar(255) default NULL,
`allday` tinyint(1) NOT NULL default '0',
`zipcode` varchar(5) default NULL,
`state` char(2) default NULL,
`city` varchar(60) default NULL,
`address2` varchar(40) default NULL,
`address1` varchar(40) default NULL,
`event_type` varchar(40) NOT NULL default '',
`timestart` time default NULL,
`timeend` time default NULL,
PRIMARY KEY (`eid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_featurecodes`
--

CREATE TABLE `gl_featurecodes` (
`code` tinyint(4) NOT NULL default '0',
`name` varchar(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_features`
--

CREATE TABLE `gl_features` (
`ft_id` mediumint(8) NOT NULL auto_increment,
`ft_name` varchar(20) NOT NULL default '',
`ft_descr` varchar(255) NOT NULL default '',
`ft_gl_core` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ft_id`),
KEY `ft_name` (`ft_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_frontpagecodes`
--

CREATE TABLE `gl_frontpagecodes` (
`code` tinyint(4) NOT NULL default '0',
`name` varchar(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_groups`
--

CREATE TABLE `gl_groups` (
`grp_id` mediumint(8) NOT NULL auto_increment,
`grp_name` varchar(50) NOT NULL default '',
`grp_descr` varchar(255) NOT NULL default '',
`grp_gl_core` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`grp_id`),
UNIQUE KEY `grp_name` (`grp_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_group_assignments`
--

CREATE TABLE `gl_group_assignments` (
`ug_main_grp_id` mediumint(8) NOT NULL default '0',
`ug_uid` mediumint(8) unsigned default NULL,
`ug_grp_id` mediumint(8) unsigned default NULL,
KEY `group_assignments_ug_main_grp_id` (`ug_main_grp_id`),
KEY `group_assignments_ug_uid` (`ug_uid`),
KEY `ug_main_grp_id` (`ug_main_grp_id`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_links`
--

CREATE TABLE `gl_links` (
`lid` varchar(40) NOT NULL default '',
`category` varchar(32) default NULL,
`url` varchar(255) default NULL,
`description` text,
`title` varchar(96) default NULL,
`hits` int(11) NOT NULL default '0',
`date` datetime default 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',
PRIMARY KEY (`lid`),
KEY `links_lid` (`lid`),
KEY `links_category` (`category`),
KEY `links_date` (`date`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_linksubmission`
--

CREATE TABLE `gl_linksubmission` (
`lid` varchar(40) NOT NULL default '',
`category` varchar(32) default NULL,
`url` varchar(255) default NULL,
`description` text,
`title` varchar(96) default NULL,
`hits` int(11) default NULL,
`date` datetime default NULL,
PRIMARY KEY (`lid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_maillist`
--

CREATE TABLE `gl_maillist` (
`code` int(1) NOT NULL default '0',
`name` char(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_personal_events`
--

CREATE TABLE `gl_personal_events` (
`eid` varchar(20) NOT NULL default '',
`title` varchar(128) default NULL,
`event_type` varchar(40) NOT NULL default '',
`datestart` date default NULL,
`dateend` date default NULL,
`address1` varchar(40) default NULL,
`address2` varchar(40) default NULL,
`city` varchar(60) default NULL,
`state` char(2) default NULL,
`zipcode` varchar(5) default NULL,
`allday` tinyint(1) NOT NULL default '0',
`url` varchar(255) default NULL,
`description` text,
`postmode` varchar(10) 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',
`uid` mediumint(8) NOT NULL default '0',
`location` varchar(128) default NULL,
`timestart` time default NULL,
`timeend` time default NULL,
PRIMARY KEY (`eid`,`uid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_pingservice`
--

CREATE TABLE `gl_pingservice` (
`pid` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(128) default NULL,
`ping_url` varchar(255) default NULL,
`site_url` varchar(255) default NULL,
`method` varchar(80) default NULL,
`is_enabled` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`pid`),
KEY `pingservice_is_enabled` (`is_enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_plugins`
--

CREATE TABLE `gl_plugins` (
`pi_name` varchar(30) NOT NULL default '',
`pi_version` varchar(20) NOT NULL default '',
`pi_gl_version` varchar(20) NOT NULL default '',
`pi_enabled` tinyint(3) unsigned NOT NULL default '1',
`pi_homepage` varchar(128) NOT NULL default '',
PRIMARY KEY (`pi_name`),
KEY `plugins_enabled` (`pi_enabled`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_pollanswers`
--

CREATE TABLE `gl_pollanswers` (
`qid` varchar(20) NOT NULL default '',
`aid` tinyint(3) unsigned NOT NULL default '0',
`answer` varchar(255) default NULL,
`votes` mediumint(8) unsigned default NULL,
`remark` varchar(255) default NULL,
PRIMARY KEY (`qid`,`aid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_pollquestions`
--

CREATE TABLE `gl_pollquestions` (
`qid` varchar(20) NOT NULL default '',
`question` varchar(255) default NULL,
`voters` mediumint(8) unsigned default NULL,
`date` datetime default NULL,
`display` tinyint(4) NOT NULL default '0',
`commentcode` tinyint(4) NOT NULL default '0',
`statuscode` tinyint(4) 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',
PRIMARY KEY (`qid`),
KEY `pollquestions_qid` (`qid`),
KEY `pollquestions_display` (`display`),
KEY `pollquestions_commentcode` (`commentcode`),
KEY `pollquestions_statuscode` (`statuscode`),
KEY `pollquestions_date` (`date`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_pollvoters`
--

CREATE TABLE `gl_pollvoters` (
`id` int(10) unsigned NOT NULL auto_increment,
`qid` varchar(20) NOT NULL default '',
`ipaddress` varchar(15) NOT NULL default '',
`date` int(10) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_postmodes`
--

CREATE TABLE `gl_postmodes` (
`code` char(10) NOT NULL default '',
`name` char(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_sessions`
--

CREATE TABLE `gl_sessions` (
`sess_id` int(10) unsigned NOT NULL default '0',
`start_time` int(10) unsigned NOT NULL default '0',
`remote_ip` varchar(15) NOT NULL default '',
`uid` mediumint(8) NOT NULL default '1',
`md5_sess_id` varchar(128) default NULL,
PRIMARY KEY (`sess_id`),
KEY `sess_id` (`sess_id`),
KEY `start_time` (`start_time`),
KEY `remote_ip` (`remote_ip`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_sortcodes`
--

CREATE TABLE `gl_sortcodes` (
`code` char(4) NOT NULL default '0',
`name` char(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_spamx`
--

CREATE TABLE `gl_spamx` (
`name` varchar(20) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
KEY `spamx_name` (`name`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_speedlimit`
--

CREATE TABLE `gl_speedlimit` (
`id` int(10) unsigned NOT NULL auto_increment,
`ipaddress` varchar(15) NOT NULL default '',
`date` int(10) unsigned default NULL,
`type` varchar(30) NOT NULL default 'submit',
PRIMARY KEY (`id`),
KEY `type_ipaddress` (`type`,`ipaddress`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_staticpage`
--

CREATE TABLE `gl_staticpage` (
`sp_id` varchar(40) NOT NULL default '',
`sp_uid` mediumint(8) NOT NULL default '1',
`sp_title` varchar(128) NOT NULL default '',
`sp_content` text 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) NOT NULL default '',
`sp_onmenu` tinyint(1) unsigned NOT NULL default '0',
`sp_label` varchar(64) default 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',
`sp_centerblock` tinyint(1) unsigned NOT NULL default '0',
`sp_help` varchar(255) default '',
`sp_tid` varchar(20) 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 default '0',
`sp_inblock` tinyint(1) unsigned default '1',
`postmode` varchar(16) NOT NULL default 'html',
PRIMARY KEY (`sp_id`),
KEY `staticpage_sp_uid` (`sp_uid`),
KEY `staticpage_sp_date` (`sp_date`),
KEY `staticpage_sp_onmenu` (`sp_onmenu`),
KEY `staticpage_sp_centerblock` (`sp_centerblock`),
KEY `staticpage_sp_tid` (`sp_tid`),
KEY `staticpage_sp_where` (`sp_where`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_statuscodes`
--

CREATE TABLE `gl_statuscodes` (
`code` int(1) NOT NULL default '0',
`name` char(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_stories`
--

CREATE TABLE `gl_stories` (
`sid` varchar(40) NOT NULL default '',
`uid` mediumint(8) NOT NULL default '1',
`draft_flag` tinyint(3) unsigned default '0',
`tid` varchar(20) NOT NULL default 'General',
`date` datetime default NULL,
`title` varchar(128) default NULL,
`introtext` text,
`bodytext` text,
`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,
`featured` tinyint(3) unsigned NOT NULL default '0',
`show_topic_icon` tinyint(1) unsigned NOT NULL default '1',
`commentcode` tinyint(4) NOT NULL default '0',
`trackbackcode` tinyint(4) NOT NULL default '0',
`statuscode` tinyint(4) NOT NULL default '0',
`expire` datetime NOT NULL default '0000-00-00 00:00:00',
`postmode` varchar(10) NOT NULL default 'html',
`advanced_editor_mode` tinyint(1) unsigned default '0',
`frontpage` tinyint(3) unsigned default '1',
`in_transit` tinyint(1) unsigned 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',
PRIMARY KEY (`sid`),
KEY `stories_sid` (`sid`),
KEY `stories_tid` (`tid`),
KEY `stories_uid` (`uid`),
KEY `stories_featured` (`featured`),
KEY `stories_hits` (`hits`),
KEY `stories_statuscode` (`statuscode`),
KEY `stories_expire` (`expire`),
KEY `stories_date` (`date`),
KEY `stories_frontpage` (`frontpage`),
KEY `stories_in_transit` (`in_transit`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_storysubmission`
--

CREATE TABLE `gl_storysubmission` (
`sid` varchar(20) NOT NULL default '',
`uid` mediumint(8) NOT NULL default '1',
`tid` varchar(20) NOT NULL default 'General',
`title` varchar(128) default NULL,
`introtext` text,
`date` datetime default NULL,
`postmode` varchar(10) NOT NULL default 'html',
PRIMARY KEY (`sid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_syndication`
--

CREATE TABLE `gl_syndication` (
`fid` int(10) unsigned NOT NULL auto_increment,
`type` varchar(30) NOT NULL default 'geeklog',
`topic` varchar(48) NOT NULL default '::all',
`header_tid` varchar(48) NOT NULL default 'none',
`format` varchar(20) NOT NULL default 'RSS-2.0',
`limits` varchar(5) NOT NULL default '10',
`content_length` smallint(5) unsigned NOT NULL default '0',
`title` varchar(40) NOT NULL default '',
`description` text,
`feedlogo` varchar(255) default NULL,
`filename` varchar(40) NOT NULL default 'geeklog.rss',
`charset` varchar(20) NOT NULL default 'UTF-8',
`language` varchar(20) 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,
PRIMARY KEY (`fid`),
KEY `syndication_type` (`type`),
KEY `syndication_topic` (`topic`),
KEY `syndication_is_enabled` (`is_enabled`),
KEY `syndication_updated` (`updated`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_topics`
--

CREATE TABLE `gl_topics` (
`tid` varchar(20) NOT NULL default '',
`topic` varchar(48) default NULL,
`imageurl` varchar(255) default NULL,
`sortnum` tinyint(3) default NULL,
`limitnews` tinyint(3) default 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',
PRIMARY KEY (`tid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_trackback`
--

CREATE TABLE `gl_trackback` (
`cid` int(10) unsigned NOT NULL auto_increment,
`sid` varchar(40) NOT NULL,
`url` varchar(255) default NULL,
`title` varchar(128) default NULL,
`blog` varchar(80) default NULL,
`excerpt` text,
`date` datetime default NULL,
`type` varchar(30) NOT NULL default 'article',
`ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`cid`),
KEY `trackback_sid` (`sid`),
KEY `trackback_url` (`url`),
KEY `trackback_type` (`type`),
KEY `trackback_date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_trackbackcodes`
--

CREATE TABLE `gl_trackbackcodes` (
`code` tinyint(4) NOT NULL default '0',
`name` varchar(32) default NULL,
PRIMARY KEY (`code`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_tzcodes`
--

CREATE TABLE `gl_tzcodes` (
`tz` char(3) NOT NULL default '',
`offset` int(1) default NULL,
`description` varchar(64) default NULL,
PRIMARY KEY (`tz`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_usercomment`
--

CREATE TABLE `gl_usercomment` (
`uid` mediumint(8) NOT NULL default '1',
`commentmode` varchar(10) NOT NULL default 'threaded',
`commentorder` varchar(4) NOT NULL default 'ASC',
`commentlimit` mediumint(8) unsigned NOT NULL default '100',
PRIMARY KEY (`uid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_userindex`
--

CREATE TABLE `gl_userindex` (
`uid` mediumint(8) NOT NULL default '1',
`tids` varchar(255) NOT NULL default '',
`etids` text,
`aids` varchar(255) NOT NULL default '',
`boxes` varchar(255) NOT NULL default '',
`noboxes` tinyint(4) NOT NULL default '0',
`maxstories` tinyint(4) default NULL,
PRIMARY KEY (`uid`),
KEY `userindex_uid` (`uid`),
KEY `userindex_noboxes` (`noboxes`),
KEY `userindex_maxstories` (`maxstories`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_userinfo`
--

CREATE TABLE `gl_userinfo` (
`uid` mediumint(8) NOT NULL default '1',
`about` text,
`location` varchar(96) NOT NULL default '',
`pgpkey` text,
`userspace` varchar(255) NOT NULL default '',
`tokens` tinyint(3) unsigned NOT NULL default '0',
`totalcomments` mediumint(9) NOT NULL default '0',
`lastgranted` int(10) unsigned NOT NULL default '0',
`lastlogin` varchar(10) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_userprefs`
--

CREATE TABLE `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` char(3) NOT NULL default 'edt',
`emailstories` tinyint(4) 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',
PRIMARY KEY (`uid`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_users`
--

CREATE TABLE `gl_users` (
`uid` mediumint(8) NOT NULL auto_increment,
`username` varchar(16) NOT NULL default '',
`remoteusername` varchar(60) default NULL,
`remoteservice` varchar(60) default NULL,
`fullname` varchar(80) default NULL,
`passwd` varchar(32) NOT NULL default '',
`email` varchar(96) default NULL,
`homepage` varchar(96) default NULL,
`sig` varchar(160) NOT NULL default '',
`regdate` datetime NOT NULL default '0000-00-00 00:00:00',
`photo` varchar(128) default NULL,
`cookietimeout` int(8) unsigned default '28800',
`theme` varchar(64) default NULL,
`language` varchar(64) default NULL,
`pwrequestid` varchar(16) default NULL,
`status` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `LOGIN` (`uid`,`passwd`,`username`),
KEY `users_username` (`username`),
KEY `users_fullname` (`fullname`),
KEY `users_email` (`email`),
KEY `users_passwd` (`passwd`),
KEY `users_pwrequestid` (`pwrequestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `gl_vars`
--

CREATE TABLE `gl_vars` (
`name` varchar(20) NOT NULL default '',
`value` varchar(128) default NULL,
PRIMARY KEY (`name`)
) ;

Database SchemaG2

2005-03-21T20:17:21Z

Dtrumbower:

The database schema for GL2 is still in flux. The last thorough schema draft, created by Dwight Trumbower, includes partial schemas for several modules. You can see a visual representation of the database [http://geeklog.tsystemscorp.com/schema/geek2.gif here] and MySQL DDL [http://geeklog.tsystemscorp.com/schema/g2mysqlcreate.sql here].

A more current, though less pretty, version of the [http://cvs.geeklog.net/co.php/Geeklog-2/sql/create.sql schema] can be found in the [http://cvs.geeklog.net/co.php/Geeklog-2/ Geeklog 2 CVS]. Note that the schema is still likely to go through several more permutations before reaching a final state.