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

/PetaPoco.Tests/postgresql_init.sql

http://github.com/toptensoftware/PetaPoco
SQL | 24 lines | 19 code | 5 blank | 0 comment | 0 complexity | 5be45f30d94e9c5dfc450727d8ee46ea MD5 | raw file
 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);