/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
- DROP TABLE IF EXISTS petapoco;
- CREATE TABLE petapoco (
- id bigint AUTO_INCREMENT NOT NULL,
- title varchar(127) NOT NULL,
- draft BOOL NOT NULL,
- date_created datetime NOT NULL,
- date_edited datetime NULL,
- content longtext NOT NULL,
- state smallint UNSIGNED NOT NULL,
- `col w space` int,
- nullreal float NULL,
-
- PRIMARY KEY (id)
- ) ENGINE=INNODB;
- DROP TABLE IF EXISTS petapoco2;
- CREATE TABLE petapoco2 (
- email varchar(127) NOT NULL,
- name varchar(127) NOT NULL,
- PRIMARY KEY (email)
- ) ENGINE=INNODB;