Geeklog Forums

-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gl_plugins`
--

INSERT INTO `gl_plugins` VALUES ('staticpages', '1.4.2', '1.4.0', 1, 'http://www.geeklog.net/');
INSERT INTO `gl_plugins` VALUES ('spamx', '1.0.3', '1.4.0', 1, 'http://www.pigstye.net/gplugs/staticpages/index.php/spamx');
INSERT INTO `gl_plugins` VALUES ('phpbbbridge', '1.02', '1.3.10', 1, 'http://demo.dogcows.net/');
INSERT INTO `gl_plugins` VALUES ('links', '1.0', '1.4.0', 1, 'http://www.geeklog.net/');
INSERT INTO `gl_plugins` VALUES ('polls', '1.0', '1.4.0', 1, 'http://www.geeklog.net/');

 

--
-- Table structure for table `gl_filemgmt_broken`
--

CREATE TABLE `gl_filemgmt_broken` (
  `reportid` int(5) NOT NULL auto_increment,
  `lid` int(11) NOT NULL default '0',
  `sender` int(11) NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`reportid`),
  KEY `lid` (`lid`),
  KEY `sender` (`sender`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `gl_filemgmt_broken`
--


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

--
-- Table structure for table `gl_filemgmt_category`
--

CREATE TABLE `gl_filemgmt_category` (
  `cid` int(5) unsigned NOT NULL auto_increment,
  `pid` int(5) unsigned NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `imgurl` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`cid`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `gl_filemgmt_category`
--


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

--
-- Table structure for table `gl_filemgmt_downloadhistory`
--

CREATE TABLE `gl_filemgmt_downloadhistory` (
  `uid` mediumint(8) NOT NULL default '0',
  `lid` int(11) NOT NULL default '0',
  `remote_ip` varchar(15) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `lid` (`lid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gl_filemgmt_downloadhistory`
--


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

--
-- Table structure for table `gl_filemgmt_filedesc`
--

CREATE TABLE `gl_filemgmt_filedesc` (
  `lid` int(11) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gl_filemgmt_filedesc`
--


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

--
-- Table structure for table `gl_filemgmt_filedetail`
--

CREATE TABLE `gl_filemgmt_filedetail` (
  `lid` int(11) unsigned NOT NULL auto_increment,
  `cid` int(5) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(250) NOT NULL default '',
  `homepage` varchar(100) NOT NULL default '',
  `version` varchar(10) NOT NULL default '',
  `size` int(8) NOT NULL default '0',
  `platform` varchar(50) NOT NULL default '',
  `logourl` varchar(250) NOT NULL default '',
  `submitter` int(11) NOT NULL default '0',
  `status` tinyint(2) NOT NULL default '0',
  `date` int(10) NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '0',
  `rating` double(6,4) NOT NULL default '0.0000',
  `votes` int(11) unsigned NOT NULL default '0',
  `comments` tinyint(2) NOT NULL default '1',
  PRIMARY KEY  (`lid`),
  KEY `cid` (`cid`),
  KEY `status` (`status`),
  KEY `title` (`title`(40))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `gl_filemgmt_filedetail`
--


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

--
-- Table structure for table `gl_filemgmt_votedata`
--

CREATE TABLE `gl_filemgmt_votedata` (
  `ratingid` int(11) unsigned NOT NULL auto_increment,
  `lid` int(11) unsigned NOT NULL default '0',
  `ratinguser` int(11) NOT NULL default '0',
  `rating` tinyint(3) unsigned NOT NULL default '0',
  `ratinghostname` varchar(60) NOT NULL default '',
  `ratingtimestamp` int(10) NOT NULL default '0',
  PRIMARY KEY  (`ratingid`),
  KEY `ratinguser` (`ratinguser`),
  KEY `ratinghostname` (`ratinghostname`),
  KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `gl_filemgmt_votedata`
--