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 '[email protected]', |
| 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; |