· 9 years ago · Jan 04, 2017, 03:30 AM
1-- ----------------------------
2-- Table structure for `staffapplication`
3-- ----------------------------
4
5DROP TABLE IF EXISTS `staffapplication`;
6CREATE TABLE `staffapplication` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `username` text,
9 `realname` text,
10 `skype` text,
11 `age` text,
12 `functie` text,
13 `onlinetime` text,
14 `experience` text,
15 `quarrel` text,
16 `serious` text,
17 `improve` text,
18 `microphone` text,
19 `ip` text,
20 `date` text,
21 PRIMARY KEY (`id`)
22) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
23
24-- ----------------------------
25-- Table structure for `uotw`
26-- ----------------------------
27
28DROP TABLE IF EXISTS `uotw`;
29CREATE TABLE `uotw` (
30 `userid` varchar(255) DEFAULT NULL,
31 `text` text
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34-- ----------------------------
35-- Records of uotw
36-- ----------------------------
37INSERT INTO `uotw` VALUES ('115', 'Ik ben de beste speler!');
38
39-- ----------------------------
40-- Table structure for `teams`
41-- ----------------------------
42DROP TABLE IF EXISTS `teams`;
43CREATE TABLE `teams` (
44 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
45 `name` varchar(50) NOT NULL,
46 `badgeid` varchar(5) NOT NULL,
47 PRIMARY KEY (`id`),
48 UNIQUE KEY `id` (`id`)
49) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
50
51-- ----------------------------
52-- Records of teams
53-- ----------------------------
54INSERT INTO `teams` VALUES ('1', 'Spam Team', 'SPAM');
55INSERT INTO `teams` VALUES ('3', 'Bouw Team', 'BOUW');
56INSERT INTO `teams` VALUES ('4', 'Event Team', 'EVENT');
57INSERT INTO `teams` VALUES ('5', 'Pixelaar', 'PIXEL');
58INSERT INTO `teams` VALUES ('6', 'Gok Team', 'GOK');
59
60-- ----------------------------
61
62ALTER TABLE users ADD pin VARCHAR(4);
63ALTER TABLE users ADD teamrank int(1) DEFAULT 0;
64ALTER TABLE users ADD fbid varchar(255) DEFAULT NULL;
65ALTER TABLE users ADD fbenable enum('0','1','2') DEFAULT 2;
66
67
68-- ----------------------------
69-- Table structure for `cms_news_like`
70-- ----------------------------
71DROP TABLE IF EXISTS `cms_news_like`;
72CREATE TABLE `cms_news_like` (
73 `id` int(11) NOT NULL AUTO_INCREMENT,
74 `userid` int(255) DEFAULT NULL,
75 `newsid` int(255) DEFAULT NULL,
76 PRIMARY KEY (`id`)
77) ENGINE=InnoDB DEFAULT CHARSET=latin1;
78
79-- ----------------------------
80-- Table structure for `cms_news_message`
81-- ----------------------------
82DROP TABLE IF EXISTS `cms_news_message`;
83CREATE TABLE `cms_news_message` (
84 `id` int(11) NOT NULL AUTO_INCREMENT,
85 `date` int(11) NOT NULL DEFAULT '0',
86 `newsid` int(11) DEFAULT NULL,
87 `userid` int(11) DEFAULT NULL,
88 `message` varchar(250) DEFAULT NULL,
89 `hash` varchar(255) DEFAULT NULL,
90 PRIMARY KEY (`id`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1;
92
93-- ----------------------------
94-- Table structure for `referrer`
95-- ----------------------------
96DROP TABLE IF EXISTS `referrer`;
97CREATE TABLE `referrer` (
98 `id` int(11) NOT NULL AUTO_INCREMENT,
99 `userid` decimal(10,0) DEFAULT NULL,
100 `refid` decimal(10,0) DEFAULT NULL,
101 `diamonds` decimal(10,0) DEFAULT NULL,
102 PRIMARY KEY (`id`)
103) ENGINE=InnoDB DEFAULT CHARSET=utf8;
104
105-- ----------------------------
106-- Table structure for `referrerbank`
107-- ----------------------------
108DROP TABLE IF EXISTS `referrerbank`;
109CREATE TABLE `referrerbank` (
110 `id` int(11) NOT NULL AUTO_INCREMENT,
111 `userid` varchar(255) DEFAULT NULL,
112 `diamonds` varchar(255) DEFAULT NULL,
113 PRIMARY KEY (`id`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115
116-- ----------------------------
117-- Table structure for `resetpassword`
118-- ----------------------------
119DROP TABLE IF EXISTS `resetpassword`;
120CREATE TABLE `resetpassword` (
121 `id` int(11) NOT NULL AUTO_INCREMENT,
122 `userid` int(11) DEFAULT NULL,
123 `resetkey` varchar(255) DEFAULT NULL,
124 `enable` enum('0','1') DEFAULT '0',
125 PRIMARY KEY (`id`)
126) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;