Dtrumbower at 16:46, 18 September 2007

2007-09-18T16:46:34Z

New page

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

DatabaseSchema - Revision history

Dirk: Fixed formatting and added category

Dtrumbower at 16:46, 18 September 2007

@@ Line 1: / Line 1: @@
+<pre>--
 -- Database: `geeklog 1.4.1`
 --
@@ Line 859: / Line 858: @@
    PRIMARY KEY  (`name`)
 ) ;