limit construction/training queues to 2

[browser-rts.git] / migrations / queue-limits.ts

diff --git a/migrations/queue-limits.ts b/migrations/queue-limits.ts
new file mode 100644 (file)
index 0000000..e55d18d
--- /dev/null
+++ b/migrations/queue-limits.ts
@@ -0,0 +1,14 @@
+import { db } from '../src/lib/db';
+
+const queries = [
+  'ALTER TABLE cities ADD COLUMN max_construction_queue int',
+  'ALTER TABLE cities ADD COLUMN max_training_queue int',
+  'UPDATE cities set max_construction_queue = 2, max_training_queue = 2'
+];
+
+async function main() {
+  queries.forEach(async sql => await db.raw(sql));
+  process.exit(0);
+}
+
+main();