QuestTimer_UserQuests

CREATE TABLE `QuestTimer_UserQuests` ( `username` varchar(30) NOT NULL default '', `password` varchar(30) NOT NULL default '', `lastmodified` datetime NOT NULL default '0000-00-00 00:00:00', `lastuploaded` datetime NOT NULL default '0000-00-00 00:00:00', `uploadct` int(11) NOT NULL default '0', `acctchars` text NOT NULL, `gmtoffset` varchar(10) NOT NULL default '-0500', `questxml` text NOT NULL, PRIMARY KEY (`username`,`password`) ) TYPE=MyISAM


QuestTimer_Admins

CREATE TABLE `QuestTimer_Admins` ( `admin_username` varchar(16) NOT NULL default '', `admin_password` varchar(32) NOT NULL default '', PRIMARY KEY (`admin_username`) ) TYPE=MyISAM


QuestTimer_AvailableQuests

CREATE TABLE `QuestTimer_AvailableQuests` ( `QuestID` int(11) NOT NULL auto_increment, `QuestName` varchar(75) NOT NULL default '', `Days` int(11) NOT NULL default '0', `Hours` int(11) NOT NULL default '0', `Minutes` int(11) NOT NULL default '0', `Text` varchar(255) default '', `Item` varchar(100) default '', `Chest` varchar(100) default '', `Droppable` tinyint(1) NOT NULL default '0', `SubmittedBy` varchar(50) default '', `DateAdded` datetime NOT NULL default '0000-00-00 00:00:00', `Approved` tinyint(1) NOT NULL default '0', `ApprovedBy` varchar(50) NOT NULL default '', PRIMARY KEY (`QuestID`) ) TYPE=MyISAM


QuestTimer_DeletedQuests

CREATE TABLE `QuestTimer_DeletedQuests` ( `QuestID` int(11) NOT NULL default '0', `QuestName` varchar(75) NOT NULL default '', `Days` int(11) NOT NULL default '0', `Hours` int(11) NOT NULL default '0', `Minutes` int(11) NOT NULL default '0', `Text` varchar(255) default '', `Item` varchar(100) default '', `Chest` varchar(100) default '', `Droppable` tinyint(1) NOT NULL default '0', `SubmittedBy` varchar(50) default '', `DateAdded` datetime NOT NULL default '0000-00-00 00:00:00', `Approved` tinyint(1) NOT NULL default '0', `ApprovedBy` varchar(50) NOT NULL default '', PRIMARY KEY (`QuestID`) ) TYPE=MyISAM


Decal_DownloadCounts

CREATE TABLE `Decal_DownloadCounts` ( `PluginName` varchar(250) default NULL, `Version` varchar(30) default NULL, `Count` int(11) default NULL, `FirstDL` date default NULL, `LastDL` date default NULL ) TYPE=MyISAM