· 8 years ago · Mar 11, 2018, 01:34 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
5/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
6/*!40101 SET NAMES utf8 */;
7
8
9CREATE TABLE IF NOT EXISTS `users` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `user` varchar(20) NOT NULL,
12 `pass` varchar(20) NOT NULL,
13 `email` varchar(30) DEFAULT NULL,
14 PRIMARY KEY (`id`),
15 UNIQUE KEY `user` (`user`)
16) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;