Add some core table setup

[dak.git] / setup / core-init.d / 010_queues

diff --git a/setup/core-init.d/010_queues b/setup/core-init.d/010_queues
new file mode 100755 (executable)
index 0000000..c00e13b
--- /dev/null
+++ b/setup/core-init.d/010_queues
@@ -0,0 +1,28 @@
+#!/bin/sh
+
+set -e
+set -u
+
+echo "Creating core queues"
+
+QUEUEBASE="${DAKBASE}/queue"
+
+psql -c "INSERT INTO policy_queue (queue_name, path, perms, change_perms,
+                                   generate_metadata, stay_of_execution, send_to_build_queues)
+                           VALUES ('unchecked', '${QUEUEBASE}/unchecked', '0660', '0660',
+                                   FALSE, 86400, FALSE)" >/dev/null
+
+psql -c "INSERT INTO policy_queue (queue_name, path, perms, change_perms,
+                                   generate_metadata, stay_of_execution, send_to_build_queues)
+                           VALUES ('new', '${QUEUEBASE}/new', '0660', '0660',
+                                   FALSE, 86400, FALSE)" >/dev/null
+
+psql -c "INSERT INTO policy_queue (queue_name, path, perms, change_perms,
+                                   generate_metadata, stay_of_execution, send_to_build_queues)
+                           VALUES ('newstage', '${QUEUEBASE}/newstage', '0660', '0660',
+                                   FALSE, 86400, FALSE)" >/dev/null
+
+psql -c "INSERT INTO policy_queue (queue_name, path, perms, change_perms,
+                                   generate_metadata, stay_of_execution, send_to_build_queues)
+                           VALUES ('byhand', '${QUEUEBASE}/byhand', '0660', '0660',
+                                   FALSE, 86400, FALSE)" >/dev/null