diff options
Diffstat (limited to 'verify')
| -rw-r--r-- | verify/items.sql | 3 | ||||
| -rw-r--r-- | verify/items@v1.0.0-alpha.1.sql | 16 | 
2 files changed, 18 insertions, 1 deletions
| diff --git a/verify/items.sql b/verify/items.sql index 9a561cf..22a4ee3 100644 --- a/verify/items.sql +++ b/verify/items.sql @@ -9,7 +9,8 @@ SELECT id,         amount,         note,         created_at, -       updated_at +       updated_at, +       article_id    FROM kakeibo.items   WHERE FALSE; diff --git a/verify/items@v1.0.0-alpha.1.sql b/verify/items@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..9a561cf --- /dev/null +++ b/verify/items@v1.0.0-alpha.1.sql @@ -0,0 +1,16 @@ +-- Verify kakeibo:items on pg + +BEGIN; + +SELECT id, +       transaction_id, +       category, +       subcategory, +       amount, +       note, +       created_at, +       updated_at +  FROM kakeibo.items + WHERE FALSE; + +ROLLBACK; | 
