1DROP TABLE IF EXISTS `users`;
2CREATE TABLE IF NOT EXISTS `users` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `username` varchar(255) NOT NULL,
5 `password` varchar(255) NOT NULL,
6 `mobile` text NOT NULL,
7 `verified` tinyint(1) NOT NULL DEFAULT '0',
8 PRIMARY KEY (`id`)
9)
10