DatabaseSchema

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

) ;