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