CzAhQqy5

1/*
2SQLyog Enterprise - MySQL GUI v8.18 
3MySQL - 5.1.58-community : Database - bugtracker
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16/*Table structure for table `questbugs` */
17
18DROP TABLE IF EXISTS `questbugs`;
19
20CREATE TABLE `questbugs` (
21  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Row ID',
22  `quest_id` int(6) DEFAULT NULL COMMENT 'Quest ID',
23  `continent` tinyint(3) DEFAULT NULL COMMENT 'Continent where quest is',
24  `zone` int(6) DEFAULT NULL COMMENT 'Zone in continent',
25  `quest_title` varchar(255) DEFAULT NULL COMMENT 'Quest title',
26  `quest_description` text COMMENT 'Quest description',
27  `owner_acct` int(8) DEFAULT NULL COMMENT 'Account ID of bug owner',
28  `owner_login` varchar(100) DEFAULT NULL COMMENT 'Login of bug owner',
29  `owner_name` varchar(100) DEFAULT NULL COMMENT 'Screen name of bug owner',
30  `owner_ip` varchar(16) DEFAULT NULL COMMENT 'IP of bug owner',
31  `confirmed` int(4) DEFAULT NULL COMMENT 'Number of times quest is confirmed as bugged',
32  `denied` int(4) DEFAULT NULL COMMENT 'Number of times quest is confirmed as working',
33  `created` int(10) NOT NULL COMMENT 'Time of bug report',
34  `comments` tinyint(3) DEFAULT NULL COMMENT 'Number of comments made for this bug',
35  `fixed` tinyint(2) DEFAULT NULL COMMENT 'Tracking system. 0 = No, 1 = Yes',
36  `revision` int(5) DEFAULT NULL COMMENT 'FrostEmu Core/Scripts Revision',
37  PRIMARY KEY (`id`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8;
39
40/*Data for the table `questbugs` */
41
42/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
43/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
44/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
45/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;