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