CREATE TABLE Readers id int 11 NOT NULL auto_increment sername varchar

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
CREATE TABLE Readers (
id int(11) NOT NULL auto_increment,
sername varchar(30) default NULL,
`name` varchar(30) NOT NULL,
datebirth varchar(10) default NULL,
address varchar(60) default NULL,
contphone varchar(20) default NULL,
sex enum('m','f') default NULL,
email varchar(45) NOT NULL,
`password` varchar(32) NOT NULL,
`status` smallint(2) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
INSERT INTO Readers VALUES (1, 'r0n9', 'GOL', '621115200', '', '', 'm', 'ron9.gol@gmail.com', md5('1'), 0);