· 7 years ago · Feb 12, 2019, 08:56 PM
1CREATE TABLE IF NOT EXISTS `znote` (
2 `id` int(10) NOT NULL AUTO_INCREMENT,
3 `version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
4 `installed` int(10) NOT NULL,
5 `cached` int(11) DEFAULT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB;
8
9INSERT INTO `znote` (`version`, `installed`) VALUES
10('$version', '$time');
11
12CREATE TABLE IF NOT EXISTS `znote_accounts` (
13 `id` int(11) NOT NULL AUTO_INCREMENT,
14 `account_id` int(11) NOT NULL,
15 `ip` int(10) UNSIGNED NOT NULL,
16 `created` int(10) NOT NULL,
17 `points` int(10) DEFAULT 0,
18 `cooldown` int(10) DEFAULT 0,
19 `active` tinyint(4) NOT NULL DEFAULT '0',
20 `activekey` int(11) NOT NULL DEFAULT '0',
21 `flag` varchar(20) NOT NULL,
22 `secret` char(16) DEFAULT NULL,
23 PRIMARY KEY (`id`)
24) ENGINE=InnoDB;
25
26INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `flag`) VALUES
27('1', '0', '$time', '');
28
29CREATE TABLE IF NOT EXISTS `znote_news` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `title` varchar(30) NOT NULL,
32 `text` text NOT NULL,
33 `date` int(11) NOT NULL,
34 `pid` int(11) NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB;
37
38CREATE TABLE IF NOT EXISTS `znote_images` (
39 `id` int(11) NOT NULL AUTO_INCREMENT,
40 `title` varchar(30) NOT NULL,
41 `desc` text NOT NULL,
42 `date` int(11) NOT NULL,
43 `status` int(11) NOT NULL,
44 `image` varchar(30) NOT NULL,
45 `account_id` int(11) NOT NULL,
46 PRIMARY KEY (`id`)
47) ENGINE=InnoDB;
48
49CREATE TABLE IF NOT EXISTS `znote_paypal` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `txn_id` varchar(30) NOT NULL,
52 `email` varchar(255) NOT NULL,
53 `accid` int(11) NOT NULL,
54 `price` int(11) NOT NULL,
55 `points` int(11) NOT NULL,
56 PRIMARY KEY (`id`)
57) ENGINE=InnoDB;
58
59CREATE TABLE IF NOT EXISTS `znote_paygol` (
60 `id` int(11) NOT NULL AUTO_INCREMENT,
61 `account_id` int(11) NOT NULL,
62 `price` int(11) NOT NULL,
63 `points` int(11) NOT NULL,
64 `message_id` varchar(255) NOT NULL,
65 `service_id` varchar(255) NOT NULL,
66 `shortcode` varchar(255) NOT NULL,
67 `keyword` varchar(255) NOT NULL,
68 `message` varchar(255) NOT NULL,
69 `sender` varchar(255) NOT NULL,
70 `operator` varchar(255) NOT NULL,
71 `country` varchar(255) NOT NULL,
72 `currency` varchar(255) NOT NULL,
73 PRIMARY KEY (`id`)
74) ENGINE=InnoDB;
75
76CREATE TABLE IF NOT EXISTS `znote_players` (
77 `id` int(11) NOT NULL AUTO_INCREMENT,
78 `player_id` int(11) NOT NULL,
79 `created` int(11) NOT NULL,
80 `hide_char` tinyint(4) NOT NULL,
81 `comment` varchar(255) NOT NULL,
82 PRIMARY KEY (`id`)
83) ENGINE=InnoDB;
84
85INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES
86('1', '$time', '0', '');
87
88CREATE TABLE IF NOT EXISTS `znote_player_reports` (
89 `id` int(11) NOT NULL AUTO_INCREMENT,
90 `name` varchar(50) NOT NULL,
91 `posx` int(6) NOT NULL,
92 `posy` int(6) NOT NULL,
93 `posz` int(6) NOT NULL,
94 `report_description` VARCHAR(255) NOT NULL,
95 `date` INT(11) NOT NULL,
96 `status` TINYINT(3) NOT NULL DEFAULT '0',
97 PRIMARY KEY (`id`)
98) ENGINE=InnoDB;
99
100CREATE TABLE IF NOT EXISTS `znote_changelog` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `text` VARCHAR(255) NOT NULL,
103 `time` INT(11) NOT NULL,
104 `report_id` INT(11) NOT NULL,
105 `status` TINYINT(3) NOT NULL DEFAULT '0',
106 PRIMARY KEY (`id`)
107) ENGINE=InnoDB;
108
109CREATE TABLE IF NOT EXISTS `znote_shop` (
110 `id` int(11) NOT NULL AUTO_INCREMENT,
111 `type` int(11) NOT NULL,
112 `itemid` int(11) DEFAULT NULL,
113 `count` int(11) NOT NULL DEFAULT '1',
114 `description` varchar(255) NOT NULL,
115 `points` int(11) NOT NULL DEFAULT '10',
116 PRIMARY KEY (`id`)
117) ENGINE=InnoDB;
118
119CREATE TABLE IF NOT EXISTS `znote_shop_logs` (
120 `id` int(11) NOT NULL AUTO_INCREMENT,
121 `account_id` int(11) NOT NULL,
122 `player_id` int(11) NOT NULL,
123 `type` int(11) NOT NULL,
124 `itemid` int(11) NOT NULL,
125 `count` int(11) NOT NULL,
126 `points` int(11) NOT NULL,
127 `time` int(11) NOT NULL,
128 PRIMARY KEY (`id`)
129) ENGINE=InnoDB;
130
131CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `account_id` int(11) NOT NULL,
134 `type` int(11) NOT NULL,
135 `itemid` int(11) NOT NULL,
136 `count` int(11) NOT NULL,
137 `time` int(11) NOT NULL DEFAULT '0',
138 PRIMARY KEY (`id`)
139) ENGINE=InnoDB;
140
141CREATE TABLE IF NOT EXISTS `znote_visitors` (
142 `id` int(11) NOT NULL AUTO_INCREMENT,
143 `ip` int(11) NOT NULL,
144 `value` int(11) NOT NULL,
145 PRIMARY KEY (`id`)
146) ENGINE=InnoDB;
147
148CREATE TABLE IF NOT EXISTS `znote_visitors_details` (
149 `id` int(11) NOT NULL AUTO_INCREMENT,
150 `ip` int(11) NOT NULL,
151 `time` int(11) NOT NULL,
152 `type` tinyint(4) NOT NULL,
153 `account_id` int(11) NOT NULL,
154 PRIMARY KEY (`id`)
155) ENGINE=InnoDB;
156
157CREATE TABLE IF NOT EXISTS `znote_forum` (
158 `id` int(11) NOT NULL AUTO_INCREMENT,
159 `name` varchar(50) NOT NULL,
160 `access` tinyint(4) NOT NULL,
161 `closed` tinyint(4) NOT NULL,
162 `hidden` tinyint(4) NOT NULL,
163 `guild_id` int(11) NOT NULL,
164 PRIMARY KEY (`id`)
165) ENGINE=InnoDB;
166
167INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES
168('Staff Board', '4', '0', '0', '0'),
169('Tutors Board', '2', '0', '0', '0'),
170('Discussion', '1', '0', '0', '0'),
171('Feedback', '1', '0', '1', '0');
172
173CREATE TABLE IF NOT EXISTS `znote_forum_threads` (
174 `id` int(11) NOT NULL AUTO_INCREMENT,
175 `forum_id` int(11) NOT NULL,
176 `player_id` int(11) NOT NULL,
177 `player_name` varchar(50) NOT NULL,
178 `title` varchar(50) NOT NULL,
179 `text` text NOT NULL,
180 `created` int(11) NOT NULL,
181 `updated` int(11) NOT NULL,
182 `sticky` tinyint(4) NOT NULL,
183 `hidden` tinyint(4) NOT NULL,
184 `closed` tinyint(4) NOT NULL,
185 PRIMARY KEY (`id`)
186) ENGINE=InnoDB;
187
188CREATE TABLE IF NOT EXISTS `znote_forum_posts` (
189 `id` int(11) NOT NULL AUTO_INCREMENT,
190 `thread_id` int(11) NOT NULL,
191 `player_id` int(11) NOT NULL,
192 `player_name` varchar(50) NOT NULL,
193 `text` text NOT NULL,
194 `created` int(11) NOT NULL,
195 `updated` int(11) NOT NULL,
196 PRIMARY KEY (`id`)
197) ENGINE=InnoDB;
198
199CREATE TABLE IF NOT EXISTS `znote_deleted_characters` (
200 `id` int(11) NOT NULL AUTO_INCREMENT,
201 `original_account_id` int(11) NOT NULL,
202 `character_name` varchar(255) NOT NULL,
203 `time` datetime NOT NULL,
204 `done` tinyint(1) NOT NULL,
205 PRIMARY KEY (`id`)
206) ENGINE=InnoDB;
207
208CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
209 `id` int(11) NOT NULL AUTO_INCREMENT,
210 `limit` int(11) NOT NULL DEFAULT '0',
211 PRIMARY KEY (`id`),
212 FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
213) ENGINE=InnoDB;
214
215CREATE TABLE IF NOT EXISTS `znote_tickets` (
216 `id` int(11) NOT NULL AUTO_INCREMENT,
217 `owner` int(11) NOT NULL,
218 `username` varchar(32) CHARACTER SET latin1 NOT NULL,
219 `subject` text CHARACTER SET latin1 NOT NULL,
220 `message` text CHARACTER SET latin1 NOT NULL,
221 `ip` int(11) NOT NULL,
222 `creation` int(11) NOT NULL,
223 `status` varchar(20) CHARACTER SET latin1 NOT NULL,
224 PRIMARY KEY (`id`)
225) ENGINE=InnoDB;
226
227CREATE TABLE IF NOT EXISTS `znote_tickets_replies` (
228 `id` int(11) NOT NULL AUTO_INCREMENT,
229 `tid` int(11) NOT NULL,
230 `username` varchar(32) CHARACTER SET latin1 NOT NULL,
231 `message` text CHARACTER SET latin1 NOT NULL,
232 `created` int(11) NOT NULL,
233 PRIMARY KEY (`id`)
234) ENGINE=InnoDB;
235
236CREATE TABLE IF NOT EXISTS `znote_global_storage` (
237 `key` VARCHAR(32) NOT NULL,
238 `value` TEXT NOT NULL,
239 UNIQUE (`key`)
240) ENGINE=InnoDB;