ysAJb6h6

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Localhost
5Source Server Version : 50509
6Source Host           : localhost:3306
7Source Database       : webwow
8
9Target Server Type    : MYSQL
10Target Server Version : 50509
11File Encoding         : 65001
12
13Date: 2011-03-11 18:57:37
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `accounts_more`
20-- ----------------------------
21DROP TABLE IF EXISTS `accounts_more`;
22CREATE TABLE `accounts_more` (
23  `id` bigint(20) NOT NULL AUTO_INCREMENT,
24  `acc_login` varchar(55) COLLATE latin1_general_ci NOT NULL,
25  `vp` bigint(55) NOT NULL DEFAULT '0',
26  `question_id` int(11) NOT NULL,
27  `answer` varchar(100) COLLATE latin1_general_ci NOT NULL,
28  `dp` bigint(55) NOT NULL DEFAULT '0',
29  `gmlevel` int(11) DEFAULT NULL,
30  PRIMARY KEY (`id`,`acc_login`)
31) ENGINE=MyISAM AUTO_INCREMENT=2591 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Account Information';
32
33-- ----------------------------
34-- Records of accounts_more
35-- ----------------------------
36INSERT INTO `accounts_more` VALUES ('2590', 'ADMIN', '9000', '2', 'yourmom', '9000', '3');
37
38-- ----------------------------
39-- Table structure for `comments`
40-- ----------------------------
41DROP TABLE IF EXISTS `comments`;
42CREATE TABLE `comments` (
43  `id` bigint(20) NOT NULL AUTO_INCREMENT,
44  `poster` varchar(255) COLLATE latin1_general_ci NOT NULL,
45  `content` text COLLATE latin1_general_ci NOT NULL,
46  `newsid` int(11) NOT NULL,
47  `timepost` varchar(100) COLLATE latin1_general_ci NOT NULL,
48  `datepost` varchar(100) COLLATE latin1_general_ci NOT NULL,
49  PRIMARY KEY (`id`)
50) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='News Comments Database';
51
52-- ----------------------------
53-- Records of comments
54-- ----------------------------
55
56-- ----------------------------
57-- Table structure for `news`
58-- ----------------------------
59DROP TABLE IF EXISTS `news`;
60CREATE TABLE `news` (
61  `id` bigint(20) NOT NULL AUTO_INCREMENT,
62  `title` varchar(255) COLLATE latin1_general_ci NOT NULL,
63  `content` longtext COLLATE latin1_general_ci NOT NULL,
64  `iconid` int(11) NOT NULL,
65  `timepost` varchar(100) COLLATE latin1_general_ci NOT NULL,
66  `datepost` varchar(100) COLLATE latin1_general_ci NOT NULL,
67  `author` varchar(50) COLLATE latin1_general_ci NOT NULL,
68  PRIMARY KEY (`id`)
69) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Website News';
70
71-- ----------------------------
72-- Records of news
73-- ----------------------------
74INSERT INTO `news` VALUES ('95', 'Welcome!', '<p><span style=\"color: white\">This is your new awesome website. Please be sure to LEAVE THE FOOTER ALONE! and +rep Jeutie on AC-Web if you like the release. Contact Evil! If you want custom logos or images. Enjoy!</span></p>', '0', '1299865425', 'March 11, 2011', 'admin');
75
76-- ----------------------------
77-- Table structure for `pages`
78-- ----------------------------
79DROP TABLE IF EXISTS `pages`;
80CREATE TABLE `pages` (
81  `id` bigint(20) NOT NULL AUTO_INCREMENT,
82  `title` varchar(255) COLLATE latin1_general_ci NOT NULL,
83  `link` varchar(255) COLLATE latin1_general_ci NOT NULL,
84  `description` varchar(255) COLLATE latin1_general_ci NOT NULL,
85  `position` int(11) NOT NULL DEFAULT '1' COMMENT '1 for default 2 for below',
86  `orderby` int(11) NOT NULL DEFAULT '0',
87  PRIMARY KEY (`id`)
88) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Website URL database';
89
90-- ----------------------------
91-- Records of pages
92-- ----------------------------
93
94-- ----------------------------
95-- Table structure for `paypal_data`
96-- ----------------------------
97DROP TABLE IF EXISTS `paypal_data`;
98CREATE TABLE `paypal_data` (
99  `id` bigint(21) NOT NULL AUTO_INCREMENT,
100  `login` varchar(55) COLLATE latin1_general_ci NOT NULL,
101  `txnid` varchar(255) COLLATE latin1_general_ci NOT NULL,
102  `amount` bigint(21) NOT NULL,
103  `who` varchar(255) COLLATE latin1_general_ci NOT NULL,
104  `whendon` bigint(100) NOT NULL DEFAULT '0',
105  `comment` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
106  PRIMARY KEY (`id`)
107) ENGINE=MyISAM AUTO_INCREMENT=222 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='PayPal Information';
108
109-- ----------------------------
110-- Records of paypal_data
111-- ----------------------------
112
113-- ----------------------------
114-- Table structure for `shop`
115-- ----------------------------
116DROP TABLE IF EXISTS `shop`;
117CREATE TABLE `shop` (
118  `id` int(11) NOT NULL AUTO_INCREMENT,
119  `sep` varchar(3) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
120  `name` text COLLATE latin1_general_ci NOT NULL,
121  `itemid` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
122  `color` tinytext COLLATE latin1_general_ci NOT NULL,
123  `cat` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
124  `sort` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
125  `cost` varchar(11) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
126  `charges` varchar(11) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
127  `donateorvote` int(5) NOT NULL DEFAULT '0' COMMENT '0 is vote 1 is donation item',
128  `description` varchar(255) COLLATE latin1_general_ci DEFAULT 'No Description',
129  `custom` varchar(3) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
130  `realm` tinyint(4) NOT NULL,
131  PRIMARY KEY (`id`)
132) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Donation Shop';
133
134-- ----------------------------
135-- Records of shop
136-- ----------------------------
137INSERT INTO `shop` VALUES ('46', '1', 'Mounts', '0', '', '2', '0', '0', '0', '1', 'No Description', '0', '1');
138INSERT INTO `shop` VALUES ('48', '1', 'Companions', '0', '', '4', '0', '0', '0', '1', 'No Description', '0', '1');
139INSERT INTO `shop` VALUES ('49', '0', 'Celestial Steed', '54811', '4', '2', '2', '10', '1', '1', 'This is a 280% speed horse mount.', '0', '1');
140INSERT INTO `shop` VALUES ('50', '0', 'X-53 Touring Rocket', '54860', '4', '2', '3', '10', '1', '1', 'This is a 280% speed duo-seat rocket mount.', '0', '1');
141INSERT INTO `shop` VALUES ('54', '0', 'Swift Zhevra', '37719', '4', '2', '1', '10', '1', '1', 'This is a 100% speed Zhevra mount.', '0', '1');
142INSERT INTO `shop` VALUES ('55', '0', 'Lil\' Phylactery', '49693', '3', '4', '1', '5', '1', '1', 'This is a rare companion.', '0', '1');
143INSERT INTO `shop` VALUES ('56', '0', 'Lil\' XT', '54847', '3', '4', '2', '5', '1', '1', 'This is a rare companion.', '0', '1');
144INSERT INTO `shop` VALUES ('57', '0', 'Pandaren Monk', '49665', '3', '4', '3', '5', '1', '1', 'This is a rare companion.', '0', '1');
145INSERT INTO `shop` VALUES ('58', '0', 'Wind Rider Cub', '49663', '3', '4', '4', '5', '1', '1', 'This is a rare companion.', '0', '1');
146INSERT INTO `shop` VALUES ('59', '0', 'Gryphon Hatcheling', '49662', '3', '4', '5', '5', '1', '1', 'This is a rare companion.', '0', '1');
147INSERT INTO `shop` VALUES ('64', '0', 'Reins of the Black Proto-Drake', '44164', '4', '2', '4', '15', '1', '1', 'This is a 310% speed Proto-Drake mount.', '0', '1');
148INSERT INTO `shop` VALUES ('65', '0', 'Reins of the Plagued Proto-Drake', '44175', '4', '2', '5', '15', '1', '1', 'This is a 310% speed Proto-Drake mount.', '0', '1');
149INSERT INTO `shop` VALUES ('66', '0', 'Deadly Gladiator\'s Frostwyrm', '46708', '4', '2', '6', '15', '1', '1', 'This is a 310% speed Frostwyrm mount.', '0', '1');
150INSERT INTO `shop` VALUES ('67', '0', 'Black Qiraji Resonating Crystal', '21176', '5', '2', '7', '10', '1', '1', 'This is a 100% speed Qiraji mount.', '0', '1');
151
152-- ----------------------------
153-- Table structure for `shoutbox`
154-- ----------------------------
155DROP TABLE IF EXISTS `shoutbox`;
156CREATE TABLE `shoutbox` (
157  `id` int(5) NOT NULL AUTO_INCREMENT,
158  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
159  `user` varchar(25) NOT NULL DEFAULT 'anonimous',
160  `message` varchar(255) NOT NULL DEFAULT '',
161  `ip` varchar(255) DEFAULT NULL,
162  PRIMARY KEY (`id`)
163) ENGINE=MyISAM AUTO_INCREMENT=591 DEFAULT CHARSET=latin1 COMMENT='Shoutbox Database';
164
165-- ----------------------------
166-- Records of shoutbox
167-- ----------------------------
168INSERT INTO `shoutbox` VALUES ('590', '2011-03-11 18:54:29', 'admin', 'This is your shoutbox. GM\'s will have a GM tag.', '127.0.0.1');
169
170-- ----------------------------
171-- Table structure for `vote_costs`
172-- ----------------------------
173DROP TABLE IF EXISTS `vote_costs`;
174CREATE TABLE `vote_costs` (
175  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
176  `start_itemlevel` int(10) NOT NULL DEFAULT '0',
177  `end_itemlevel` int(10) NOT NULL,
178  `points` int(100) NOT NULL DEFAULT '0',
179  PRIMARY KEY (`id`)
180) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Vote Shop Costs';
181
182-- ----------------------------
183-- Records of vote_costs
184-- ----------------------------
185INSERT INTO `vote_costs` VALUES ('2', '50', '100', '20');
186INSERT INTO `vote_costs` VALUES ('1', '1', '50', '10');
187INSERT INTO `vote_costs` VALUES ('3', '100', '120', '30');
188INSERT INTO `vote_costs` VALUES ('4', '120', '150', '40');
189INSERT INTO `vote_costs` VALUES ('5', '150', '180', '50');
190INSERT INTO `vote_costs` VALUES ('6', '180', '190', '60');
191INSERT INTO `vote_costs` VALUES ('7', '190', '199', '70');
192INSERT INTO `vote_costs` VALUES ('8', '200', '210', '80');
193INSERT INTO `vote_costs` VALUES ('9', '210', '230', '90');
194INSERT INTO `vote_costs` VALUES ('10', '230', '240', '100');
195INSERT INTO `vote_costs` VALUES ('11', '240', '250', '110');
196INSERT INTO `vote_costs` VALUES ('12', '250', '260', '120');
197INSERT INTO `vote_costs` VALUES ('13', '260', '270', '130');
198INSERT INTO `vote_costs` VALUES ('14', '271', '280', '140');
199
200-- ----------------------------
201-- Table structure for `vote_data`
202-- ----------------------------
203DROP TABLE IF EXISTS `vote_data`;
204CREATE TABLE `vote_data` (
205  `id` bigint(21) NOT NULL AUTO_INCREMENT,
206  `userid` bigint(21) NOT NULL,
207  `siteid` bigint(21) NOT NULL,
208  `timevoted` bigint(21) NOT NULL,
209  PRIMARY KEY (`id`)
210) ENGINE=MyISAM AUTO_INCREMENT=5456 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Voting Data';
211
212-- ----------------------------
213-- Records of vote_data
214-- ----------------------------
215
216-- ----------------------------
217-- Table structure for `vote_items`
218-- ----------------------------
219DROP TABLE IF EXISTS `vote_items`;
220CREATE TABLE `vote_items` (
221  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
222  `name` varchar(255) NOT NULL DEFAULT '',
223  `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0',
224  `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
225  `show` enum('yes','no') NOT NULL DEFAULT 'yes',
226  `realm` tinyint(4) NOT NULL,
227  `custom` tinyint(4) NOT NULL,
228  PRIMARY KEY (`entry`),
229  KEY `idx_name` (`name`)
230) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Vote Shop Items';
231
232-- ----------------------------
233-- Records of vote_items
234-- ----------------------------
235INSERT INTO `vote_items` VALUES ('49646', 'Core Hound Pup', '3', '120', 'yes', '1', '0');
236INSERT INTO `vote_items` VALUES ('41133', 'Unhatched Mr. Chilly', '3', '120', 'yes', '1', '0');
237INSERT INTO `vote_items` VALUES ('34492', 'Rocket Chicken', '3', '120', 'yes', '1', '0');
238INSERT INTO `vote_items` VALUES ('32588', 'Banana Charm', '3', '120', 'yes', '1', '0');
239INSERT INTO `vote_items` VALUES ('23712', 'Hippogryph Hatchling', '3', '120', 'yes', '1', '0');
240INSERT INTO `vote_items` VALUES ('22114', 'Pink Murloc Egg', '3', '120', 'yes', '1', '0');
241INSERT INTO `vote_items` VALUES ('20371', 'Blue Murloc Egg', '3', '120', 'yes', '1', '0');
242INSERT INTO `vote_items` VALUES ('39286', 'Frosty\'s Collar', '3', '120', 'yes', '1', '0');
243INSERT INTO `vote_items` VALUES ('38050', 'Soul-Trader Beacon', '3', '120', 'yes', '1', '0');
244INSERT INTO `vote_items` VALUES ('35226', 'X-51 Nether-Rocket X-TREME', '4', '240', 'yes', '1', '0');
245INSERT INTO `vote_items` VALUES ('38576', 'Big Battle Bear', '4', '180', 'yes', '1', '0');
246INSERT INTO `vote_items` VALUES ('49284', 'Swift Spectral Tiger', '4', '180', 'yes', '1', '0');
247INSERT INTO `vote_items` VALUES ('23720', 'Riding Turtle', '4', '180', 'yes', '1', '0');
248INSERT INTO `vote_items` VALUES ('46802', 'Heavy Murloc Egg', '3', '120', 'yes', '1', '0');
249INSERT INTO `vote_items` VALUES ('54069', 'Blazing Hippogryph', '4', '240', 'yes', '1', '0');
250INSERT INTO `vote_items` VALUES ('13582', 'Zergling Leash', '3', '120', 'yes', '1', '0');
251INSERT INTO `vote_items` VALUES ('56806', 'Mini Thor', '3', '120', 'yes', '1', '0');
252INSERT INTO `vote_items` VALUES ('13584', 'Diablo Stone', '3', '120', 'yes', '1', '0');
253INSERT INTO `vote_items` VALUES ('25535', 'Netherwhelp\'s Collar', '3', '120', 'yes', '1', '0');
254INSERT INTO `vote_items` VALUES ('13583', 'Panda Collar', '3', '120', 'yes', '1', '0');
255INSERT INTO `vote_items` VALUES ('35227', 'Goblin Weather Machine - Prototype 01-B', '4', '100', 'yes', '1', '0');
256INSERT INTO `vote_items` VALUES ('34499', 'Paper Flying Machine Kit', '3', '100', 'yes', '1', '0');
257INSERT INTO `vote_items` VALUES ('33223', 'Fishing Chair', '3', '100', 'yes', '1', '0');
258INSERT INTO `vote_items` VALUES ('43599', 'Big Blizzard Bear', '3', '180', 'yes', '1', '0');
259INSERT INTO `vote_items` VALUES ('30360', 'Lurky\'s Egg', '3', '120', 'yes', '1', '0');
260INSERT INTO `vote_items` VALUES ('45180', 'Murkimus\' Little Spear', '3', '120', 'yes', '1', '0');
261INSERT INTO `vote_items` VALUES ('44819', 'Baby Blizzard Bear', '0', '120', 'yes', '1', '0');
262INSERT INTO `vote_items` VALUES ('49362', 'Onyxian Whelpling', '0', '120', 'yes', '1', '0');
263INSERT INTO `vote_items` VALUES ('46767', 'Warbot Ignition Key', '3', '120', 'yes', '1', '0');
264INSERT INTO `vote_items` VALUES ('46765', 'Blue War Fuel', '3', '100', 'yes', '1', '0');
265INSERT INTO `vote_items` VALUES ('46766', 'Red War Fuel', '3', '100', 'yes', '1', '0');