· 8 years ago · Mar 15, 2018, 11:04 AM
1CREATE TABLE IF NOT EXISTS rp_users(
2id INT NOT NULL AUTO_INCREMENT,
3PRIMARY KEY(id),
4djname VARCHAR(30) NOT NULL,
5username VARCHAR(30) NOT NULL,
6passwrd VARCHAR(100) NOT NULL,
7email VARCHAR(50) NOT NULL,
8rank VARCHAR (20) NOT NULL,
9favsong VARCHAR(50) NOT NULL,
10favband VARCHAR(50) NOT NULL,
11favfood VARCHAR(50) NOT NULL,
12petpeeves VARCHAR(50) NOT NULL,
13sayings VARCHAR(70) NOT NULL,
14aboutyou VARCHAR(500) NOT NULL,
15avatar VARCHAR(200) NOT NULL,
16online VARCHAR(3) NOT NULL,
17notes VARCHAR(500) NOT NULL);
18CREATE TABLE IF NOT EXISTS rp_alerts(
19id INT NOT NULL AUTO_INCREMENT,
20PRIMARY KEY(id),
21toip VARCHAR(20) NOT NULL,
22message VARCHAR(400) NOT NULL,
23fromdj VARCHAR(50) NOT NULL,
24expire VARCHAR(20) NOT NULL);
25CREATE TABLE IF NOT EXISTS rp_chat(
26id INT NOT NULL AUTO_INCREMENT,
27PRIMARY KEY(id),
28djname VARCHAR(30) NOT NULL,
29message VARCHAR(150) NOT NULL,
30date VARCHAR(30) NOT NULL);
31CREATE TABLE IF NOT EXISTS rp_contact(
32id INT NOT NULL AUTO_INCREMENT,
33PRIMARY KEY(id),
34username VARCHAR(30) NOT NULL,
35email VARCHAR(50) NOT NULL,
36subject VARCHAR(50) NOT NULL,
37message VARCHAR(1000) NOT NULL,
38ipaddr VARCHAR(20) NOT NULL);
39CREATE TABLE IF NOT EXISTS rp_data(
40sitename VARCHAR(30) NOT NULL,
41adminemail VARCHAR(30) NOT NULL,
42serveraddr VARCHAR(50) NOT NULL,
43serverport VARCHAR(10) NOT NULL,
44serverpass VARCHAR(30) NOT NULL,
45panel_version VARCHAR(10) NOT NULL);
46CREATE TABLE IF NOT EXISTS rp_logs(
47id INT NOT NULL AUTO_INCREMENT,
48PRIMARY KEY(id),
49username VARCHAR(30) NOT NULL,
50date VARCHAR(30) NOT NULL,
51ipaddr VARCHAR(15) NOT NULL);
52CREATE TABLE IF NOT EXISTS rp_news(
53id INT NOT NULL AUTO_INCREMENT,
54PRIMARY KEY(id),
55poster VARCHAR(30) NOT NULL,
56ip VARCHAR(20) NOT NULL,
57date VARCHAR(20) NOT NULL,
58title VARCHAR(50) NOT NULL,
59article VARCHAR(5000) NOT NULL);
60CREATE TABLE IF NOT EXISTS rp_pm(
61id INT NOT NULL AUTO_INCREMENT,
62PRIMARY KEY(id),
63fromdj VARCHAR(30) NOT NULL,
64todj VARCHAR(30) NOT NULL,
65date VARCHAR(30) NOT NULL,
66subject VARCHAR(20) NOT NULL,
67message VARCHAR(500) NOT NULL);
68CREATE TABLE IF NOT EXISTS rp_songs(
69id INT NOT NULL AUTO_INCREMENT,
70PRIMARY KEY(id),
71title VARCHAR(50) NOT NULL,
72artist VARCHAR(50) NOT NULL,
73reason VARCHAR(100) NOT NULL);
74CREATE TABLE IF NOT EXISTS rp_request(
75id INT NOT NULL AUTO_INCREMENT,
76PRIMARY KEY(id),
77name VARCHAR(30) NOT NULL,
78type VARCHAR(30) NOT NULL,
79request VARCHAR(200) NOT NULL,
80ipaddr VARCHAR(20) NOT NULL);
81CREATE TABLE IF NOT EXISTS rp_timetable(
82`day` VARCHAR(30) NOT NULL ,
83`1` VARCHAR(30) NOT NULL ,
84`2` VARCHAR(30) NOT NULL ,
85`3` VARCHAR(30) NOT NULL ,
86`4` VARCHAR(30) NOT NULL ,
87`5` VARCHAR(30) NOT NULL ,
88`6` VARCHAR(30) NOT NULL ,
89`7` VARCHAR(30) NOT NULL ,
90`8` VARCHAR(30) NOT NULL ,
91`9` VARCHAR(30) NOT NULL ,
92`10` VARCHAR(30) NOT NULL ,
93`11` VARCHAR(30) NOT NULL ,
94`12` VARCHAR(30) NOT NULL ,
95`13` VARCHAR(30) NOT NULL ,
96`14` VARCHAR(30) NOT NULL ,
97`15` VARCHAR(30) NOT NULL ,
98`16` VARCHAR(30) NOT NULL ,
99`17` VARCHAR(30) NOT NULL ,
100`18` VARCHAR(30) NOT NULL ,
101`19` VARCHAR(30) NOT NULL ,
102`20` VARCHAR(30) NOT NULL ,
103`21` VARCHAR(30) NOT NULL ,
104`22` VARCHAR(30) NOT NULL ,
105`23` VARCHAR(30) NOT NULL ,
106`24` VARCHAR(30) NOT NULL);
107INSERT INTO `rp_timetable` (`day`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`,
108
109`10`, `11`, `12`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `24`)
110
111VALUES ('Monday','','','','','','','','','','','','','','','','','','','','','','','',''),
112
113('Tuesday','','','','','','','','','','','','','','','','','','','','','','','',''),
114
115('Wednesday','','','','','','','','','','','','','','','','','','','','','','','',''),
116
117('Thursday','','','','','','','','','','','','','','','','','','','','','','','',''),
118
119('Friday','','','','','','','','','','','','','','','','','','','','','','','',''),
120
121('Saturday','','','','','','','','','','','','','','','','','','','','','','','',''),
122
123('Sunday','','','','','','','','','','','','','','','','','','','','','','','','');
124CREATE TABLE IF NOT EXISTS rp_usrlogs(
125id INT NOT NULL AUTO_INCREMENT,
126PRIMARY KEY(id),
127username VARCHAR(30) NOT NULL,
128date VARCHAR(30) NOT NULL,
129ipaddr VARCHAR(15) NOT NULL,
130result VARCHAR(20) NOT NULL);
131delimiter $$
132
133CREATE TABLE IF NOT EXISTS `rp_blacklist` (
134 `ID` int(11) NOT NULL AUTO_INCREMENT,
135 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
136 `ip` varchar(17) NOT NULL,
137 `by` varchar(200) NOT NULL,
138 `reason` varchar(200) NOT NULL,
139 `byname` varchar(200) DEFAULT NULL,
140 `reqname` varchar(200) DEFAULT NULL,
141 PRIMARY KEY (`ID`)
142);
143delimiter $$
144
145CREATE TABLE `rp_applications` (
146 `ID` int(11) NOT NULL AUTO_INCREMENT,
147 `TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
148 `appread` varchar(5) NOT NULL,
149 `ip` varchar(200) NOT NULL,
150 `name` varchar(200) NOT NULL,
151 `djname` varchar(200) DEFAULT NULL,
152 `age` varchar(200) DEFAULT NULL,
153 `sex` varchar(200) NOT NULL,
154 `phone` varchar(200) NOT NULL,
155 `email` varchar(200) DEFAULT NULL,
156 `fav` varchar(200) DEFAULT NULL,
157 `address` varchar(200) NOT NULL,
158 `story` text,
159 `prevexp` text,
160 `why` text,
161 `lsrpfn` varchar(200) NOT NULL,
162 `agerl` varchar(200) NOT NULL,
163 `country` varchar(200) DEFAULT NULL,
164 `sexrl` varchar(200) DEFAULT NULL,
165 `mic` varchar(200) DEFAULT NULL,
166 `songs` varchar(200) DEFAULT NULL,
167 `english` varchar(200) DEFAULT NULL,
168 `storyrl` text,
169 PRIMARY KEY (`ID`)
170);