· 7 years ago · Sep 07, 2018, 08:54 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `username` varchar(48) CHARACTER SET utf8 NOT NULL,
4 `password` varchar(48) CHARACTER SET utf8 NOT NULL,
5 `email` varchar(255) CHARACTER SET utf8 NOT NULL,
6 `sid` varchar(32) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=222223 ;