diff options
| author | Camil Staps | 2015-10-14 19:40:29 +0200 |
|---|---|---|
| committer | Camil Staps | 2015-10-14 19:40:29 +0200 |
| commit | adddd3ff8630bb8c5fc7355bcd0d09f226353f67 (patch) | |
| tree | ae26c76eb0a9d7bdc496885bba2105ae00f19e5a /migrations/2015_10_14_17201444836042_create_verses_table.py | |
| parent | Only insert from dump when non-empty (diff) | |
Using Orator migrations
Diffstat (limited to 'migrations/2015_10_14_17201444836042_create_verses_table.py')
| -rw-r--r-- | migrations/2015_10_14_17201444836042_create_verses_table.py | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/migrations/2015_10_14_17201444836042_create_verses_table.py b/migrations/2015_10_14_17201444836042_create_verses_table.py new file mode 100644 index 0000000..b95aa50 --- /dev/null +++ b/migrations/2015_10_14_17201444836042_create_verses_table.py @@ -0,0 +1,21 @@ +from orator.migrations import Migration + + +class CreateVersesTable(Migration): + + def up(self): + """ + Run the migrations. + """ + with self.schema.create('verses') as table: + table.string('book') + table.small_integer('chapter') + table.small_integer('nr') + table.foreign('book').references('canonical_name').on('books') + table.primary(['book', 'chapter', 'nr']) + + def down(self): + """ + Revert the migrations. + """ + self.schema.drop('verses') |