Add some core table setup

[dak.git] / setup / core-init.d / 060_archive

diff --git a/setup/core-init.d/060_archive b/setup/core-init.d/060_archive
new file mode 100755 (executable)
index 0000000..2938344
--- /dev/null
+++ b/setup/core-init.d/060_archive
@@ -0,0 +1,17 @@
+#!/bin/sh
+
+set -e
+set -u
+
+POOLPATH="${DAKBASE}/ftp/pool"
+
+echo "Setting up archive and locations"
+psql -c "INSERT INTO archive (name, origin_server, description)
+                      VALUES ('${DAKHOST}', '${DAKFQDN}', 'Master server')" >/dev/null
+
+for component in main contrib non-free; do
+    psql -c "INSERT INTO location (path, type, component, archive)
+                          VALUES ('${POOLPATH}', 'pool',
+                                  (SELECT id FROM component WHERE name = '${component}'),
+                                  (SELECT id FROM archive WHERE name = '${DAKHOST}'))" >/dev/null
+done