SHOW:
|
|
- or go back to the newest paste.
1 | /*Table structure for table `account_type` */ | |
2 | ||
3 | DROP TABLE IF EXISTS `account_type`; | |
4 | ||
5 | CREATE TABLE `account_type` ( | |
6 | - | `type` varchar(10) DEFAULT NULL, |
6 | + | `type` varchar(10) DEFAULT 'Base', |
7 | - | `bonus` int(2) DEFAULT NULL |
7 | + | `bonus` int(2) DEFAULT '5' |
8 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
9 | ||
10 | /*Table structure for table `chat` */ | |
11 | ||
12 | DROP TABLE IF EXISTS `chat`; | |
13 | ||
14 | CREATE TABLE `chat` ( | |
15 | `chat_id` int(11) NOT NULL AUTO_INCREMENT, | |
16 | `name` varchar(15) NOT NULL, | |
17 | `message` varchar(140) NOT NULL, | |
18 | `ip` varchar(18) NOT NULL, | |
19 | `time` int(11) NOT NULL, | |
20 | `delete` int(11) NOT NULL DEFAULT '0', | |
21 | PRIMARY KEY (`chat_id`) | |
22 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
23 | ||
24 | /*Table structure for table `friends` */ | |
25 | ||
26 | DROP TABLE IF EXISTS `friends`; | |
27 | ||
28 | CREATE TABLE `friends` ( | |
29 | `friendID` int(11) NOT NULL COMMENT 'Child', | |
30 | `userID` int(11) DEFAULT NULL COMMENT 'Parent', | |
31 | `total` int(11) DEFAULT '0', | |
32 | `cashed_month1` int(1) DEFAULT '0', | |
33 | `cashed_month2` int(1) DEFAULT '0', | |
34 | `cashed_month3` int(1) DEFAULT '0', | |
35 | `cashed_month4` int(1) DEFAULT '0', | |
36 | `cashed_month5` int(1) DEFAULT '0', | |
37 | `cashed_month6` int(1) DEFAULT '0', | |
38 | `cashed_month7` int(1) DEFAULT '0', | |
39 | `cashed_month8` int(1) DEFAULT '0', | |
40 | `cashed_month9` int(1) DEFAULT '0', | |
41 | `cashed_month10` int(1) DEFAULT '0', | |
42 | `cashed_month11` int(1) DEFAULT '0', | |
43 | `cashed_month12` int(1) DEFAULT '0' | |
44 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
45 | ||
46 | /*Table structure for table `login_attempts` */ | |
47 | ||
48 | DROP TABLE IF EXISTS `login_attempts`; | |
49 | ||
50 | CREATE TABLE `login_attempts` ( | |
51 | `user_id` int(11) NOT NULL, | |
52 | `time` varchar(50) NOT NULL, | |
53 | `login_time` varchar(60) DEFAULT NULL, | |
54 | `access_address` varchar(45) DEFAULT NULL | |
55 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
56 | ||
57 | /*Table structure for table `members` */ | |
58 | ||
59 | DROP TABLE IF EXISTS `members`; | |
60 | ||
61 | CREATE TABLE `members` ( | |
62 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
63 | `acc_type` varchar(10) DEFAULT 'Base', | |
64 | - | `status` int(11) DEFAULT '0', |
64 | + | `status` int(1) DEFAULT '0', |
65 | - | `username` varchar(30) DEFAULT 'testusername', |
65 | + | `username` varchar(30), |
66 | - | `email` varchar(50) DEFAULT 'test@test.com', |
66 | + | `email` varchar(50), |
67 | `facebook` varchar(50) DEFAULT NULL, | |
68 | `password` char(128) DEFAULT NULL, | |
69 | `salt` char(128) DEFAULT NULL, | |
70 | - | `pwd_changed` int(11) DEFAULT '0', |
70 | + | `pwd_changed` int(1) DEFAULT '0', |
71 | - | `phone` varchar(9) DEFAULT '123456789', |
71 | + | `phone` varchar(9), |
72 | - | `mobile` varchar(9) DEFAULT '123456789', |
72 | + | `mobile` varchar(9), |
73 | - | `zipcode` varchar(5) DEFAULT '01234', |
73 | + | `zipcode` varchar(5), |
74 | - | `saddress` varchar(60) DEFAULT 'C\\ Falsa, 123', |
74 | + | `saddress` varchar(60), |
75 | `name` varchar(60) DEFAULT NULL, | |
76 | `logotipo` varchar(60) DEFAULT 'no-photo.png', | |
77 | `reg_time` varchar(60) DEFAULT NULL, | |
78 | `last_updated` varchar(60) DEFAULT '0000-00-00 00:00:00', | |
79 | `reg_ip` varchar(45) DEFAULT NULL, | |
80 | `last_ip` varchar(45) DEFAULT '0.0.0.0', | |
81 | `last_updated_ip` varchar(45) DEFAULT '0.0.0.0', | |
82 | `month1` int(1) DEFAULT '0', | |
83 | `month2` int(1) DEFAULT '0', | |
84 | `month3` int(1) DEFAULT '0', | |
85 | `month4` int(1) DEFAULT '0', | |
86 | `month5` int(1) DEFAULT '0', | |
87 | `month6` int(1) DEFAULT '0', | |
88 | `month7` int(1) DEFAULT '0', | |
89 | `month8` int(1) DEFAULT '0', | |
90 | `month9` int(1) DEFAULT '0', | |
91 | `month10` int(1) DEFAULT '0', | |
92 | `month11` int(1) DEFAULT '0', | |
93 | `month12` int(1) DEFAULT '0', | |
94 | PRIMARY KEY (`id`) | |
95 | ) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8; |