diff options
Diffstat (limited to 'src/db.phel')
| -rw-r--r-- | src/db.phel | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/db.phel b/src/db.phel index 3f50ccc..a83a290 100644 --- a/src/db.phel +++ b/src/db.phel @@ -4,6 +4,6 @@ (def conn (pdo/connect "sqlite:test.db")) (defn initialize-database [] - (pdo/exec conn "create table if not exists books (id integer primary key autoincrement, title varchar(255), subtitle varchar(255))") - (pdo/exec conn "create table if not exists authors (id integer primary key autoincrement, name varchar(255))") + (pdo/exec conn "create table if not exists books (id integer primary key autoincrement, title varchar(255), subtitle varchar(255), created_at integer, updated_at integer)") + (pdo/exec conn "create table if not exists authors (id integer primary key autoincrement, name varchar(255), created_at integer, updated_at integer)") (pdo/exec conn "create table if not exists authors_books (author_id integer, book_id integer)")) |