· 8 years ago · Mar 16, 2018, 02:38 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(7) unsigned NOT NULL default '0',
3 `username` varchar(20) NOT NULL default '',
4 `password` varchar(20) NOT NULL default '',
5 `time_last_seen` datetime NOT NULL default '0000-00-00 00:00:00',
6 `ip` varchar(20) NOT NULL default '',
7 `type` int(7) default NULL,
8 `first_name` varchar(50) NOT NULL default '',
9 `last_name` varchar(50) NOT NULL default '',
10 `email` varchar(255) NOT NULL default '',
11 PRIMARY KEY (`id`) );