diff options
Diffstat (limited to 'src/chef/database')
| -rw-r--r-- | src/chef/database/init.clj | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/chef/database/init.clj b/src/chef/database/init.clj index 7f23d27..ef4bd2f 100644 --- a/src/chef/database/init.clj +++ b/src/chef/database/init.clj @@ -7,9 +7,12 @@ :with-columns [[:id :integer :primary-key :autoincrement] [:name :text] [:question :text] - [:parent :integer]]})) ;TODO: create root category + [:parent :integer]]})) (jdbc/execute! db (sql/format {:create-table :recipes - :with-columns [[:id :integer :auto-increment :primary-key] + :with-columns [[:id :integer :primary-key :autoincrement] [:category :integer] [:title :text] - [:description :text]]}))) + [:unit :integer] + [:ingredients :text] + [:preparation :text] + [:thumbnail :text]]}))) |