/PetaPoco.Tests/mysql_init.sql

 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;