/PetaPoco.Tests/postgresql_init.sql

 1
 2DROP TABLE IF EXISTS petapoco;
 3
 4CREATE TABLE petapoco (
 5	id				bigserial NOT NULL,
 6	title			varchar(127) NOT NULL,
 7	draft			boolean NOT NULL,
 8	date_created	timestamp NOT NULL,
 9	date_edited		timestamp NULL,
10	content			text NOT NULL,
11	state			int NOT NULL,
12	"col w space"   int,
13	nullreal		real NULL,
14
15	PRIMARY KEY (id)
16);
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);