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