create.sql

基于ruby的进阶编程,大家可以对照教材<<Ruby on Rails快速Web应用开发实战>>,效果会更好

drop table if exists works;

create table works (
	id int unsigned not null auto_increment,
	nickname char(20) not null,
	sex  enum('帅哥','靓妹') not null default '帅哥',
	city char(20) null default '未知',
	email varchar(30)  null,
	qq varchar(15) null,
	ip char(15) null,
	thedatetime datetime null,
	title varchar(100) not null default '无标题',
	content text null,
	primary key (id)
);