1 files changed, 50 insertions, 0 deletions
diff --git a/ihatemoney/migrations/versions/cb038f79982e_sqlite_autoincrement.py b/ihatemoney/migrations/versions/cb038f79982e_sqlite_autoincrement.py
new file mode 100644
index 0000000..ae5ab32
--- /dev/null
+++ b/ihatemoney/migrations/versions/cb038f79982e_sqlite_autoincrement.py
@@ -0,0 +1,50 @@
+"""sqlite_autoincrement
+
+Revision ID: cb038f79982e
+Revises: 2dcb0c0048dc
+Create Date: 2020-04-13 17:40:02.426957
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = "cb038f79982e"
+down_revision = "2dcb0c0048dc"
+
+from alembic import op
+import sqlalchemy as sa
+
+
+def upgrade():
+    alter_table_batches = [
+        op.batch_alter_table(
+            "person", recreate="always", table_kwargs={"sqlite_autoincrement": True}
+        ),
+        op.batch_alter_table(
+            "bill", recreate="always", table_kwargs={"sqlite_autoincrement": True}
+        ),
+        op.batch_alter_table(
+            "billowers", recreate="always", table_kwargs={"sqlite_autoincrement": True}
+        ),
+    ]
+
+    for batch_op in alter_table_batches:
+        with batch_op:
+            pass
+
+
+def downgrade():
+    alter_table_batches = [
+        op.batch_alter_table(
+            "person", recreate="always", table_kwargs={"sqlite_autoincrement": False}
+        ),
+        op.batch_alter_table(
+            "bill", recreate="always", table_kwargs={"sqlite_autoincrement": False}
+        ),
+        op.batch_alter_table(
+            "billowers", recreate="always", table_kwargs={"sqlite_autoincrement": False}
+        ),
+    ]
+
+    for batch_op in alter_table_batches:
+        with batch_op:
+            pass