· 8 years ago · Nov 16, 2017, 04:10 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL,
3 `email` varchar(50) NOT NULL,
4 `name` varchar(50) NOT NULL,
5 `password` varchar(32) NOT NULL,
6 `regtime` int(14) NOT NULL,
7 `ref` int(14) NOT NULL,
8 `prava` int(1) NOT NULL,
9 `balance_p` decimal(10,2) NOT NULL,
10 `balance_m` decimal(10,2) NOT NULL,
11 `bonus` decimal(10,2) NOT NULL,
12 `dohod` decimal(10,2) NOT NULL,
13 `dohod_1` decimal(10,2) NOT NULL,
14 `all_dohod` decimal(10,2) NOT NULL,
15 `ip` varchar(100) NOT NULL,
16 `status` int(1) NOT NULL DEFAULT '0'
17) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;