【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,development_structure.sql,希望对大家有所帮助!
CREATE TABLE `hello_texts` (
`id` int(10) unsigned NOT NULL auto_increment,
`lang_code` varchar(45) NOT NULL,
`text` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `schema_info` (
`version` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`pass
word` varchar(255) NOT NULL,
`created_at` datetime default NULL,
`nick_name` varchar(100) default NULL,
`age` int(11) default NULL,
`sex` tinyint(1) default NULL,
`picture` blob,
`height` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO schema_info (version) VALUES (4)