PageRenderTime 12ms CodeModel.GetById 1ms app.highlight 7ms RepoModel.GetById 2ms app.codeStats 0ms

/PetaPoco.Tests/mysql_init.sql

http://github.com/toptensoftware/PetaPoco
SQL | 24 lines | 19 code | 5 blank | 0 comment | 0 complexity | 5bfaf12eb9b42e25e31442a16a335266 MD5 | raw file
 1DROP TABLE IF EXISTS petapoco;
 2
 3CREATE TABLE petapoco (
 4
 5	id				bigint AUTO_INCREMENT NOT NULL,
 6	title			varchar(127) NOT NULL,
 7	draft			BOOL NOT NULL,
 8	date_created	datetime NOT NULL,
 9	date_edited		datetime NULL,
10	content			longtext NOT NULL,
11	state			smallint UNSIGNED NOT NULL,
12	`col w space`	int,
13	nullreal		float NULL,
14	
15	PRIMARY KEY (id)
16) ENGINE=INNODB;
17
18DROP TABLE IF EXISTS petapoco2;
19
20CREATE TABLE petapoco2 (
21	email		varchar(127) NOT NULL,
22	name		varchar(127) NOT NULL,
23	PRIMARY KEY (email)
24) ENGINE=INNODB;