1 DROP TABLE IF EXISTS `mxchange_admin_menu`;
\r
2 CREATE TABLE `mxchange_admin_menu` (
\r
3 `id` bigint(22) NOT NULL auto_increment,
\r
4 `action` varchar(255) NOT NULL default '',
\r
5 `what` varchar(255) NOT NULL default '',
\r
6 `title` varchar(50) NOT NULL default '',
\r
7 `sort` bigint(20) NOT NULL default '0',
\r
8 `descr` blob NOT NULL,
\r
12 DROP TABLE IF EXISTS `mxchange_admins`;
\r
13 CREATE TABLE `mxchange_admins` (
\r
14 `id` bigint(20) NOT NULL auto_increment,
\r
15 `login` varchar(100) NOT NULL default '',
\r
16 `password` varchar(40) NOT NULL default '',
\r
20 DROP TABLE IF EXISTS `mxchange_cats`;
\r
21 CREATE TABLE `mxchange_cats` (
\r
22 `id` bigint(22) NOT NULL auto_increment,
\r
23 `cat` varchar(255) NOT NULL default '',
\r
24 `visible` enum('Y','N') NOT NULL default 'Y',
\r
25 `sort` bigint(20) NOT NULL default '0',
\r
29 DROP TABLE IF EXISTS `mxchange_config`;
\r
30 CREATE TABLE `mxchange_config` (
\r
31 `config` tinyint(1) NOT NULL default '0',
\r
32 `pass_len` tinyint(4) NOT NULL default '5',
\r
33 `points_register` bigint(20) NOT NULL default '0',
\r
34 `points_ref` bigint(20) NOT NULL default '0',
\r
35 `least_cats` tinyint(4) NOT NULL default '5',
\r
36 `check_double_email` enum('Y','N') NOT NULL default 'Y',
\r
37 `check_double_pass` enum('Y','N') NOT NULL default 'N',
\r
38 `admin_notify` enum('Y','N') NOT NULL default 'Y',
\r
39 `url_tlock` bigint(20) NOT NULL default '86400',
\r
40 `test_text` enum('Y','N') NOT NULL default 'Y',
\r
41 `max_tlength` bigint(20) NOT NULL default '1000',
\r
42 `test_subj` enum('Y','N') NOT NULL default 'Y',
\r
43 `autosend_active` enum('Y','N') NOT NULL default 'N',
\r
44 PRIMARY KEY (`config`)
\r
47 INSERT INTO `mxchange_config` VALUES (0,5,2000,200,5,'Y','N','Y',86400,'Y',1000,'Y','N');
\r
49 DROP TABLE IF EXISTS `mxchange_guest_menu`;
\r
50 CREATE TABLE `mxchange_guest_menu` (
\r
51 `id` bigint(22) NOT NULL auto_increment,
\r
52 `action` varchar(20) NOT NULL default '',
\r
53 `what` varchar(20) NOT NULL default '',
\r
54 `title` varchar(50) NOT NULL default '',
\r
55 `sort` bigint(20) NOT NULL default '0',
\r
56 `visible` enum('Y','N') NOT NULL default 'Y',
\r
57 `locked` enum('Y','N') NOT NULL default 'Y',
\r
58 `counter` bigint(20) NOT NULL default '0',
\r
62 DROP TABLE IF EXISTS `mxchange_max_receive`;
\r
63 CREATE TABLE `mxchange_max_receive` (
\r
64 `id` bigint(22) NOT NULL auto_increment,
\r
65 `value` mediumint(9) NOT NULL default '0',
\r
66 `comment` varchar(255) NOT NULL default '',
\r
70 DROP TABLE IF EXISTS `mxchange_member_menu`;
\r
71 CREATE TABLE `mxchange_member_menu` (
\r
72 `id` bigint(22) NOT NULL auto_increment,
\r
73 `action` varchar(20) NOT NULL default '',
\r
74 `what` varchar(20) NOT NULL default '',
\r
75 `title` varchar(50) NOT NULL default '',
\r
76 `sort` bigint(20) NOT NULL default '0',
\r
77 `visible` enum('Y','N') NOT NULL default 'Y',
\r
78 `locked` enum('Y','N') NOT NULL default 'Y',
\r
79 `descr` blob NOT NULL,
\r
80 `counter` bigint(20) NOT NULL default '0',
\r
84 DROP TABLE IF EXISTS `mxchange_mod_reg`;
\r
85 CREATE TABLE `mxchange_mod_reg` (
\r
86 `id` bigint(20) NOT NULL auto_increment,
\r
87 `module` varchar(50) NOT NULL default '',
\r
88 `locked` enum('Y','N') NOT NULL default 'Y',
\r
89 `hidden` enum('Y','N') NOT NULL default 'N',
\r
90 `admin_only` enum('Y','N') NOT NULL default 'N',
\r
91 `title` varchar(200) NOT NULL default '',
\r
92 `mem_only` enum('Y','N') NOT NULL default 'N',
\r
93 `clicks` bigint(20) NOT NULL default '0',
\r
97 INSERT INTO `mxchange_mod_reg` VALUES (1,'admin','N','N','Y','','N',0);
\r
98 INSERT INTO `mxchange_mod_reg` VALUES (2,'index','N','N','N','','N',0);
\r
99 INSERT INTO `mxchange_mod_reg` VALUES (3,'frameset','Y','N','N','','N',0);
\r
100 INSERT INTO `mxchange_mod_reg` VALUES (4,'login','N','N','N','','Y',0);
\r
101 INSERT INTO `mxchange_mod_reg` VALUES (6,'frametester','N','Y','N','','N',0);
\r
102 INSERT INTO `mxchange_mod_reg` VALUES (7,'loader','N','Y','N','','N',0);
\r
103 INSERT INTO `mxchange_mod_reg` VALUES (8,'order','N','N','N','','N',0);
\r
105 DROP TABLE IF EXISTS `mxchange_payments`;
\r
106 CREATE TABLE `mxchange_payments` (
\r
107 `id` bigint(20) NOT NULL auto_increment,
\r
108 `time` int(11) NOT NULL default '0',
\r
109 `payment` float(5,3) NOT NULL default '0.000',
\r
110 `mail_title` varchar(255) NOT NULL default '',
\r
111 `price` float(5,3) NOT NULL default '0.000',
\r
115 DROP TABLE IF EXISTS `mxchange_pool`;
\r
116 CREATE TABLE `mxchange_pool` (
\r
117 `id` bigint(20) NOT NULL auto_increment,
\r
118 `sender` bigint(20) NOT NULL default '0',
\r
119 `subject` varchar(200) NOT NULL default '',
\r
120 `text` longblob NOT NULL,
\r
121 `receivers` longblob NOT NULL,
\r
122 `payment_id` tinyint(4) NOT NULL default '0',
\r
123 `data_type` enum('TEMP','SEND','NEW','ADMIN') NOT NULL default 'TEMP',
\r
124 `timestamp` varchar(10) NOT NULL default '0',
\r
125 `url` tinytext NOT NULL,
\r
126 `target_send` bigint(20) NOT NULL default '0',
\r
127 `cat_id` bigint(20) NOT NULL default '0',
\r
131 DROP TABLE IF EXISTS `mxchange_refbanner`;
\r
132 CREATE TABLE `mxchange_refbanner` (
\r
133 `id` bigint(22) NOT NULL auto_increment,
\r
134 `url` text NOT NULL,
\r
135 `alternate` text NOT NULL,
\r
136 `visible` enum('Y','N') NOT NULL default 'Y',
\r
137 `counter` bigint(22) NOT NULL default '0',
\r
141 DROP TABLE IF EXISTS `mxchange_refdepths`;
\r
142 CREATE TABLE `mxchange_refdepths` (
\r
143 `id` tinyint(4) NOT NULL auto_increment,
\r
144 `level` tinyint(4) NOT NULL default '0',
\r
145 `percents` tinyint(4) NOT NULL default '0',
\r
149 INSERT INTO `mxchange_refdepths` VALUES (1,0,100);
\r
150 INSERT INTO `mxchange_refdepths` VALUES (2,1,30);
\r
151 INSERT INTO `mxchange_refdepths` VALUES (3,2,15);
\r
152 INSERT INTO `mxchange_refdepths` VALUES (4,3,10);
\r
153 INSERT INTO `mxchange_refdepths` VALUES (5,4,8);
\r
154 INSERT INTO `mxchange_refdepths` VALUES (6,5,5);
\r
156 DROP TABLE IF EXISTS `mxchange_refsystem`;
\r
157 CREATE TABLE `mxchange_refsystem` (
\r
158 `id` bigint(22) NOT NULL auto_increment,
\r
159 `userid` bigint(20) NOT NULL default '0',
\r
160 `level` tinyint(4) NOT NULL default '0',
\r
161 `counter` bigint(20) NOT NULL default '0',
\r
165 DROP TABLE IF EXISTS `mxchange_user_cats`;
\r
166 CREATE TABLE `mxchange_user_cats` (
\r
167 `id` bigint(22) NOT NULL auto_increment,
\r
168 `userid` bigint(20) NOT NULL default '0',
\r
169 `cat_id` tinyint(4) NOT NULL default '0',
\r
173 DROP TABLE IF EXISTS `mxchange_user_data`;
\r
174 CREATE TABLE `mxchange_user_data` (
\r
175 `userid` bigint(22) NOT NULL auto_increment,
\r
176 `surname` varchar(255) NOT NULL default '',
\r
177 `family` varchar(255) NOT NULL default '',
\r
178 `street_nr` varchar(255) NOT NULL default '',
\r
179 `country` varchar(4) NOT NULL default '',
\r
180 `zip` varchar(6) NOT NULL default '',
\r
181 `city` varchar(255) NOT NULL default '',
\r
182 `email` varchar(255) NOT NULL default '',
\r
183 `birth_day` char(2) NOT NULL default '01',
\r
184 `birth_month` char(2) NOT NULL default '01',
\r
185 `birth_year` varchar(4) NOT NULL default '1970',
\r
186 `password` varchar(32) NOT NULL default '',
\r
187 `max_mails` int(11) NOT NULL default '0',
\r
188 `receive_mails` int(11) NOT NULL default '0',
\r
189 `refid` bigint(22) NOT NULL default '0',
\r
190 `status` enum('UNCONFIRMED','CONFIRMED','LOCKED') NOT NULL default 'UNCONFIRMED',
\r
191 `user_hash` varchar(32) NOT NULL default '',
\r
192 `REMOTE_ADDR` varchar(15) NOT NULL default '0.0.0.0',
\r
193 `last_online` varchar(10) NOT NULL default '0',
\r
194 `last_module` varchar(20) NOT NULL default '',
\r
195 `ref_clicks` bigint(20) NOT NULL default '0',
\r
196 `total_logins` bigint(20) NOT NULL default '0',
\r
197 `sex` enum('M','F') NOT NULL default 'M',
\r
198 `used_points` double(22,3) NOT NULL default '0.000',
\r
199 `emails_sent` bigint(20) NOT NULL default '0',
\r
200 PRIMARY KEY (`userid`)
\r
203 DROP TABLE IF EXISTS `mxchange_user_points`;
\r
204 CREATE TABLE `mxchange_user_points` (
\r
205 `id` bigint(22) NOT NULL auto_increment,
\r
206 `userid` bigint(22) NOT NULL default '0',
\r
207 `ref_depth` tinyint(4) NOT NULL default '0',
\r
208 `points` double(22,3) NOT NULL default '0.000',
\r
212 alter table `mxchange_config` add `max_send` tinyint not null default '100';
\r
213 alter table `mxchange_config` add `url_blacklist` enum('Y','N') not null default 'Y';
\r
214 alter table `mxchange_config` add `auto_purge` tinyint not null default '14';
\r
215 alter table `mxchange_config` add `auto_purge_active` enum('Y','N') not null default 'Y';
\r
217 alter table `mxchange_pool` modify `url` tinytext not null;
\r
218 alter table `mxchange_pool` change `url` `url` tinyblob not null;
\r
219 alter table `mxchange_pool` modify `data_type` enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP';
\r
221 DROP TABLE IF EXISTS `mxchange_user_links`;
\r
222 CREATE TABLE `mxchange_user_links` (
\r
223 `id` bigint(20) NOT NULL auto_increment,
\r
224 `stats_id` bigint(20) NOT NULL default '0',
\r
225 `userid` bigint(20) NOT NULL default '0',
\r
226 `link_type` enum('NORMAL') NOT NULL default 'NORMAL',
\r
230 DROP TABLE IF EXISTS `mxchange_user_stats`;
\r
231 CREATE TABLE `mxchange_user_stats` (
\r
232 `id` bigint(20) NOT NULL auto_increment,
\r
233 `userid` bigint(20) NOT NULL default '0',
\r
234 `cat_id` bigint(20) NOT NULL default '0',
\r
235 `payment_id` bigint(20) NOT NULL default '0',
\r
236 `subject` varchar(200) NOT NULL default '',
\r
237 `url` tinyblob NOT NULL,
\r
238 `max_rec` bigint(20) NOT NULL default '0',
\r
239 `timestamp_ordered` varchar(10) NOT NULL default '',
\r
240 `pool_id` bigint(20) NOT NULL default '0',
\r
241 `timestamp_sstart` varchar(10) NOT NULL default '',
\r
242 `timestamp_send` varchar(10) NOT NULL default '',
\r
246 alter table `mxchange_user_data` add `joined` varchar(10) not null default '0';
\r
247 alter table `mxchange_config` add `last_update` varchar(10) not null default '0';
\r
249 UPDATE `mxchange_member_menu` SET `locked` = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;
\r
251 UPDATE `mxchange_guest_menu` SET `counter`=0;
\r
252 UPDATE `mxchange_member_menu` SET `counter`=0;
\r
254 INSERT INTO `mxchange_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);
\r
255 alter table `mxchange_pool` modify `data_type` enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP';
\r
256 alter table `mxchange_config` add `unconfirmed` bigint not null default '100';
\r
257 alter table `mxchange_config` add `profile_lock` bigint not null default '86400';
\r
258 alter table `mxchange_user_data` add `last_update` varchar(10) not null default '0';
\r
259 alter table `mxchange_refbanner` add `clicks` bigint not null default '0';
\r
260 alter table `mxchange_config` add `online_timeout` bigint not null default '1800';
\r
262 alter table `mxchange_config` add `mad_timestamp` varchar(10) not null default '0';
\r
263 alter table `mxchange_config` add `mad_count` bigint not null;
\r
264 alter table `mxchange_config` add `profile_update` bigint not null default '15768000';
\r
265 alter table `mxchange_config` add `send_prof_update` enum('Y','N') not null default 'Y';
\r
266 alter table `mxchange_config` add `resend_profile_update` bigint not null default '172800';
\r
268 alter table `mxchange_user_data` add `last_profile_sent` varchar(10) not null default '0';
\r
269 alter table `mxchange_user_data` add `notified` enum('Y','N') not null default 'N';
\r
271 alter table `mxchange_config` add `patch_level` varchar(100) not null default '78';
\r
272 alter table `mxchange_config` add `patch_ctime` varchar(10) not null default '0';
\r
274 alter table `mxchange_admins` add `email` varchar(255) not null;
\r
276 DROP TABLE IF EXISTS `mxchange_task_system`;
\r
277 CREATE TABLE `mxchange_task_system` (
\r
278 `id` bigint(20) NOT NULL auto_increment,
\r
279 `assigned_admin` bigint(20) NOT NULL default '0',
\r
280 `userid` bigint(20) NOT NULL default '0',
\r
281 `status` enum('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL default 'NEW',
\r
282 `task_type` enum('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL default 'FIRST_USER',
\r
283 `subject` varchar(255) NOT NULL default '',
\r
284 `text` longblob NOT NULL,
\r
285 `task_created` varchar(10) NOT NULL default '0',
\r
286 KEY (`assigned_admin`),
\r
290 ALTER TABLE `mxchange_pool` ADD INDEX (`sender`);
\r
291 ALTER TABLE `mxchange_pool` ADD INDEX (`payment_id`);
\r
292 ALTER TABLE `mxchange_pool` ADD INDEX (`cat_id`);
\r
293 ALTER TABLE `mxchange_refsystem` ADD INDEX (`userid`);
\r
294 ALTER TABLE `mxchange_task_system` ADD INDEX (`assigned_admin`);
\r
295 ALTER TABLE `mxchange_task_system` ADD INDEX (`userid`);
\r
296 ALTER TABLE `mxchange_user_cats` ADD INDEX (`userid`);
\r
297 ALTER TABLE `mxchange_user_cats` ADD INDEX (`cat_id`);
\r
298 ALTER TABLE `mxchange_user_data` ADD INDEX (`refid`);
\r
299 ALTER TABLE `mxchange_user_links` ADD INDEX (`userid`);
\r
300 ALTER TABLE `mxchange_user_links` ADD INDEX (`stats_id`);
\r
301 ALTER TABLE `mxchange_user_points` ADD INDEX (`userid`);
\r
302 ALTER TABLE `mxchange_user_stats` ADD INDEX (`userid`);
\r
303 ALTER TABLE `mxchange_user_stats` ADD INDEX (`cat_id`);
\r
304 ALTER TABLE `mxchange_user_stats` ADD INDEX (`payment_id`);
\r
305 ALTER TABLE `mxchange_user_stats` ADD INDEX (`pool_id`);
\r
307 alter table `mxchange_user_stats` add `clicks` bigint not null;
\r
308 alter table `mxchange_config` add `code_length` tinyint not null default '5';
\r
309 alter table `mxchange_config` add `guest_stats` enum('MEMBERS','MODULES','INACTIVE') not null default 'MEMBERS';
\r
310 alter table `mxchange_config` add `ref_payout` tinyint not null default '5';
\r
311 alter table `mxchange_user_data` add `ref_payout` tinyint not null default '0';
\r
312 alter table `mxchange_user_points` add `locked_points` bigint not null default '0';
\r
314 DROP TABLE IF EXISTS `mxchange_extensions`;
\r
315 CREATE TABLE `mxchange_extensions` (
\r
316 `id` bigint(20) NOT NULL auto_increment,
\r
317 `ext_name` varchar(255) NOT NULL default '',
\r
318 `ext_lang_file` varchar(255) NOT NULL default '',
\r
319 `ext_active` enum('Y','N') NOT NULL default 'N',
\r
320 `ext_version` varchar(255) NOT NULL default '0.',
\r
324 DROP TABLE IF EXISTS `mxchange_jackpot`;
\r
325 CREATE TABLE `mxchange_jackpot` (
\r
326 `ok` char(2) NOT NULL default 'ok',
\r
327 `points` double(23,3) NOT NULL default '0.000',
\r
331 alter table `mxchange_config` add `activate_xchange` bigint(20) not null default '100';
\r
332 alter table `mxchange_config` add `order_multi_page` enum('Y','N') not null default 'Y';
\r
333 alter table `mxchange_config` add `display_refid` enum('Y','N') not null default 'Y';
\r
334 alter table `mxchange_config` add `ip_timeout` bigint(20) not null default '86400';
\r
335 alter table `mxchange_pool` add `zip` varchar(6) not null default '';
\r
337 alter table `mxchange_task_system` change `task_type` `task_type` varchar(255) not null default 'FIRST_USER';
\r
338 alter table `mxchange_user_data` modify `zip` varchar(6) not null default '';
\r
339 alter table `mxchange_admin_menu` modify `action` varchar(255) not null default '';
\r
340 alter table `mxchange_admin_menu` modify `what` varchar(255) not null default '';
\r
341 alter table `mxchange_user_data` modify `last_module` varchar(255) not null default '';
\r
342 alter table `mxchange_config` add `allow_direct_pay` enum('N', 'Y') not null default 'N';
\r
343 alter table `mxchange_user_data` modify `last_profile_sent` varchar(10) not null default '0';
\r
344 alter table `mxchange_user_data` modify `last_update` varchar(10) not null default '0';
\r
345 alter table `mxchange_user_data` modify `joined` varchar(10) not null default '0';
\r
346 alter table `mxchange_user_data` modify `last_online` varchar(10) not null default '0';
\r