--
-- example schema
-- --------------
-- schema file for sqlite3 database
-- to be used in this example
--

CREATE TABLE posts (
  `id`    INTEGER PRIMARY KEY,
  `uid`   INTEGER,
  `title` TEXT,
  `body`  TEXT,
  `size`  INTEGER,
  `date`  INTEGER
);

CREATE TABLE comments (
  `id`      INTEGER PRIMARY KEY,
  `post_id` INTEGER,
  `title`   TEXT,
  `body`    TEXT,
  `size`    INTEGER,
  `date`    INTEGER
);

--
-- example schema
-- --------------
-- schema file for sqlite3 database
-- to be used in this example
--

DROP TABLE IF EXISTS posts;
CREATE TABLE posts (
  `id`    INTEGER PRIMARY KEY,
  `uid`   INTEGER,
  `title` TEXT,
  `body`  TEXT,
  `size`  INTEGER,
  `date`  INTEGER
);

DROP TABLE IF EXISTS comments;
CREATE TABLE comments (
  `id`      INTEGER PRIMARY KEY,
  `post_id` INTEGER,
  `title`   TEXT,
  `body`    TEXT,
  `size`    INTEGER,
  `date`    INTEGER
);

Improve Sqlite3 schema by adding drop statement
Improve Sqlite3 schema by adding drop statement

Drop, if exists, before create table. Easier to reset database.
