· 8 years ago · Feb 18, 2018, 10:30 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `uid` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(100) NOT NULL,
4 `password` varchar(150) NOT NULL,
5 `email` varchar(120) NOT NULL,
6 `ip` varchar(100) NOT NULL,
7 `session` varchar(1000) NOT NULL,
8 PRIMARY KEY (`uid`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;