diff options
Diffstat (limited to 'backend/migrations/2020-12-25-150728_transaction_date/up.sql')
-rw-r--r-- | backend/migrations/2020-12-25-150728_transaction_date/up.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/backend/migrations/2020-12-25-150728_transaction_date/up.sql b/backend/migrations/2020-12-25-150728_transaction_date/up.sql new file mode 100644 index 0000000..76f9820 --- /dev/null +++ b/backend/migrations/2020-12-25-150728_transaction_date/up.sql | |||
@@ -0,0 +1,4 @@ | |||
1 | -- Your SQL goes here | ||
2 | |||
3 | alter table transaction | ||
4 | add order_date date not null default curdate(); | ||