WAUrWu5X

1
2CREATE TABLE IF NOT EXISTS users(
3    id int(10) PRIMARY KEY AUTO_INCREMENT,
4    address VARCHAR(60) UNIQUE NOT NULL,
5    deposit_address VARCHAR(60) UNIQUE NOT NULL,
6    balance bigint unsigned not null,
7    regdate bigint unsigned not null,
8    ipsused text not null,
9    token varchar(255) not null,
10    level int(1) not null default 1,
11    level_days_left int not null,
12    last_claim bigint unsigned not null,
13    last_claim_ip varchar(30) not null,
14    referrer int(10) unsigned not null,
15    referredc bigint unsigned not null,
16    referredu bigint unsigned not null
17) ENGINE=InnoDB;
18
19CREATE TABLE IF NOT EXISTS banned_ips(
20    id int(10) unsigned PRIMARY KEY AUTO_INCREMENT,
21    ip varchar(18) unique not null
22) ENGINE=InnoDB;
23
24CREATE TABLE IF NOT EXISTS withdrawals (
25    id bigint unsigned PRIMARY KEY AUTO_INCREMENT,
26    user_id int(11) unsigned not null,
27    address varchar(60) not null,
28    amount bigint unsigned not null,
29    txid varchar(255) not null,
30    status varchar(20) not null,
31    time bigint unsigned not null
32) ENGINE=InnoDB;
33
34CREATE TABLE IF NOT EXISTS deposits (
35    id int(10) unsigned PRIMARY KEY AUTO_INCREMENT,
36    address varchar(60) not null,
37    amount bigint unsigned not null,
38    confirmations int(1) unsigned not null default 0,
39    credited int(1) unsigned not null default 0,
40    time bigint unsigned not null,
41    txid varchar(255) unique not null,
42    user_id int(12) unsigned not null
43) ENGINE=InnoDB;
44
45CREATE TABLE IF NOT EXISTS faqs(
46    id int(10) unsigned PRIMARY KEY AUTO_INCREMENT,
47    question varchar(255) not null,
48    answer text not null
49) ENGINE=InnoDB;
50
51CREATE TABLE IF NOT EXISTS ads (
52    box_name varchar(255),
53    box_content text
54)ENGINE=InnoDB;
55
56INSERT INTO ads (box_name, box_content) VALUES ('dash_top', '');
57INSERT INTO ads (box_name, box_content) VALUES ('dash_left', '');
58INSERT INTO ads (box_name, box_content) VALUES ('dash_right', '');
59INSERT INTO ads (box_name, box_content) VALUES ('dash_bot', '');
60INSERT INTO ads (box_name, box_content) VALUES ('dash_captcha', '');
61INSERT INTO ads (box_name, box_content) VALUES ('dash_upgrade', '');
62INSERT INTO ads (box_name, box_content) VALUES ('dash_plans', '');
63INSERT INTO ads (box_name, box_content) VALUES ('dash_deposit', '');
64INSERT INTO ads (box_name, box_content) VALUES ('dash_withdraw', '');
65
66INSERT INTO ads (box_name, box_content) VALUES ('aff_top', '');
67INSERT INTO ads (box_name, box_content) VALUES ('aff_left', '');
68INSERT INTO ads (box_name, box_content) VALUES ('aff_right', '');
69INSERT INTO ads (box_name, box_content) VALUES ('aff_bot', '');
70INSERT INTO ads (box_name, box_content) VALUES ('aff_link', '');
71INSERT INTO ads (box_name, box_content) VALUES ('aff_stats', '');
72
73INSERT INTO ads (box_name, box_content) VALUES ('pay_top', '');
74INSERT INTO ads (box_name, box_content) VALUES ('pay_left', '');
75INSERT INTO ads (box_name, box_content) VALUES ('pay_right', '');
76INSERT INTO ads (box_name, box_content) VALUES ('pay_bot', '');
77INSERT INTO ads (box_name, box_content) VALUES ('pay_between', '');
78
79INSERT INTO ads (box_name, box_content) VALUES ('faq_top', '');
80INSERT INTO ads (box_name, box_content) VALUES ('faq_left', '');
81INSERT INTO ads (box_name, box_content) VALUES ('faq_right', '');
82INSERT INTO ads (box_name, box_content) VALUES ('faq_bot', '');
83INSERT INTO ads (box_name, box_content) VALUES ('faq_below', '');
84INSERT INTO ads (box_name, box_content) VALUES ('faq_between', '');
85
86INSERT INTO ads (box_name, box_content) VALUES ('sup_top', '');
87INSERT INTO ads (box_name, box_content) VALUES ('sup_left', '');
88INSERT INTO ads (box_name, box_content) VALUES ('sup_right', '');
89INSERT INTO ads (box_name, box_content) VALUES ('sup_bot', '');
90INSERT INTO ads (box_name, box_content) VALUES ('sup_email', '');
91INSERT INTO ads (box_name, box_content) VALUES ('sup_text', '');
92INSERT INTO ads (box_name, box_content) VALUES ('sup_captcha', '');
93INSERT INTO ads (box_name, box_content) VALUES ('sup_button', '');
94
95CREATE TABLE IF NOT EXISTS settings(
96    `id` int unsigned PRIMARY KEY AUTO_INCREMENT,
97    `name` varchar(255) unique not null,
98    `value` varchar(255) not null
99) ENGINE=InnoDB;
100
101INSERT INTO settings(name, value) VALUES ('claim_time_1', '600');
102INSERT INTO settings(name, value) VALUES ('affiliate_1', '1');
103INSERT INTO settings(name, value) VALUES ('affiliate_premium_1', '20');
104INSERT INTO settings(name, value) VALUES ('claim_amount_1','120');
105INSERT INTO settings(name, value) VALUES ('claim_auto_1', '0');
106INSERT INTO settings(name, value) VALUES ('see_ads_1', '1');
107
108INSERT INTO settings(name, value) VALUES ('claim_time_2', '600');
109INSERT INTO settings(name, value) VALUES ('affiliate_2', '2');
110INSERT INTO settings(name, value) VALUES ('affiliate_premium_2', '30');
111INSERT INTO settings(name, value) VALUES ('claim_amount_2', '260');
112INSERT INTO settings(name, value) VALUES ('claim_auto_2', '1');
113INSERT INTO settings(name, value) VALUES ('see_ads_2', '0');
114
115INSERT INTO settings(name, value) VALUES ('claim_time_3', '600');
116INSERT INTO settings(name, value) VALUES ('affiliate_3', '3');
117INSERT INTO settings(name, value) VALUES ('affiliate_premium_3', '40');
118INSERT INTO settings(name, value) VALUES ('claim_amount_3', '2600');
119INSERT INTO settings(name, value) VALUES ('claim_auto_3', '1');
120INSERT INTO settings(name, value) VALUES ('see_ads_3', '0');
121
122INSERT INTO settings(name, value) VALUES ('claim_time_4', '600');
123INSERT INTO settings(name, value) VALUES ('affiliate_4', '4');
124INSERT INTO settings(name, value) VALUES ('affiliate_premium_4', '50');
125INSERT INTO settings(name, value) VALUES ('claim_amount_4', '26000');
126INSERT INTO settings(name, value) VALUES ('claim_auto_4', '1');
127INSERT INTO settings(name, value) VALUES ('see_ads_4', '0');
128
129INSERT INTO settings(name, value) VALUES ('claim_time_5', '600');
130INSERT INTO settings(name, value) VALUES ('affiliate_5', '5');
131INSERT INTO settings(name, value) VALUES ('affiliate_premium_5', '60');
132INSERT INTO settings(name, value) VALUES ('claim_amount_5', '130000');
133INSERT INTO settings(name, value) VALUES ('claim_auto_5', '1');
134INSERT INTO settings(name, value) VALUES ('see_ads_5', '0');
135
136INSERT INTO settings(name, value) VALUES ('price_2', '0.01');
137INSERT INTO settings(name, value) VALUES ('price_3', '0.1');
138INSERT INTO settings(name, value) VALUES ('price_4', '1');
139INSERT INTO settings(name, value) VALUES ('price_5', '5');
140
141INSERT INTO settings(name, value) VALUES ('minimum_withdrawal', '100000');
142INSERT INTO settings(name, value) VALUES ('maximum_withdrawal', '10000000000');