Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `users` (
- `id` int(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(20) COLLATE utf8_bin NOT NULL,
- `email` varchar(50) COLLATE utf8_bin NOT NULL,
- `passhash` varchar(50) COLLATE utf8_bin NOT NULL,
- `invitecode` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '''nocode''',
- `registration_ts` int(20) NOT NULL,
- `last_activity` int(20) NOT NULL,
- `class` int(20) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `id` (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement