Add some core table setup

[dak.git] / setup / core-init.d / 020_sections

diff --git a/setup/core-init.d/020_sections b/setup/core-init.d/020_sections
new file mode 100755 (executable)
index 0000000..b4c265f
--- /dev/null
+++ b/setup/core-init.d/020_sections
@@ -0,0 +1,66 @@
+#!/bin/sh
+
+echo "Creating default sections"
+
+set -e
+set -u
+
+SECTIONS="admin
+cli-mono
+comm
+database
+debian-installer
+debug
+devel
+doc
+editors
+electronics
+embedded
+fonts
+games
+gnome
+gnu-r
+gnustep
+graphics
+hamradio
+haskell
+httpd
+interpreters
+java
+kde
+kernel
+libdevel
+libs
+lisp
+localization
+mail
+math
+misc
+net
+news
+ocaml
+oldlibs
+otherosfs
+perl
+php
+python
+ruby
+science
+shells
+sound
+tasks
+tex
+text
+utils
+vcs
+video
+web
+x11
+xfce
+zope"
+
+for prefix in "" "contrib/" "non-free/"; do
+    for section in ${SECTIONS}; do
+        psql -c "INSERT INTO section (section) VALUES ('$prefix$section')" >/dev/null
+    done
+done