/PetaPoco.Tests/postgresql_init.sql
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);