/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

  1. DROP TABLE IF EXISTS petapoco;
  2. CREATE TABLE petapoco (
  3. id bigint AUTO_INCREMENT NOT NULL,
  4. title varchar(127) NOT NULL,
  5. draft BOOL NOT NULL,
  6. date_created datetime NOT NULL,
  7. date_edited datetime NULL,
  8. content longtext NOT NULL,
  9. state smallint UNSIGNED NOT NULL,
  10. `col w space` int,
  11. nullreal float NULL,
  12. PRIMARY KEY (id)
  13. ) ENGINE=INNODB;
  14. DROP TABLE IF EXISTS petapoco2;
  15. CREATE TABLE petapoco2 (
  16. email varchar(127) NOT NULL,
  17. name varchar(127) NOT NULL,
  18. PRIMARY KEY (email)
  19. ) ENGINE=INNODB;