· 8 years ago · Jul 18, 2018, 03:02 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(256) NOT NULL,
4 `avatar` varchar(256) NOT NULL,
5 `money` int(255) NOT NULL,
6 `ref_percent` int(255) NOT NULL DEFAULT '15',
7 `referals` int(11) DEFAULT NULL,
8 `zarabotok` int(11) DEFAULT NULL,
9 `login` varchar(256) NOT NULL,
10 `login2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
11 `is_admin` int(11) NOT NULL,
12 `is_yt` int(11) NOT NULL,
13 `ref_use` int(11) DEFAULT NULL,
14 `profit` int(11) NOT NULL,
15 `opened` int(11) NOT NULL,
16 `ref_link` varchar(256) DEFAULT 'none',
17 `deposit` int(11) NOT NULL,
18 `bonus_money` int(11) NOT NULL,
19 `remember_token` varchar(100) NOT NULL,
20 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
21 `updated_at` timestamp NOT NULL DEFAULT '2016-11-08 21:32:40',
22 PRIMARY KEY (`id`)
23) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;