schema: Fix missing brace and broken script

The script would fail if arches-tables.sql didn't already exist.
The generated SQL was broken due to missing brace in CREATE TABLE.

diff --git a/schema/arches-tables.in b/schema/arches-tables.in
index 8a327e100e63ad57d0df7bb67fd74b3f6c017234..a7b649baef1a3028b2776f31580258bfdfa15a02 100644 (file)
--- a/schema/arches-tables.in
+++ b/schema/arches-tables.in
@@ -8,6 +8,7 @@ grant usage on schema "ARCH_public" to "ARCH", public;
 grant usage on schema "ARCH" to wb_security;
 
 create table "ARCH".packages
+(
     package character varying NOT NULL,
     distribution character varying NOT NULL,
     version character varying,

diff --git a/schema/arches-tables.sh b/schema/arches-tables.sh
index 846ce655669b3ab40468bc8d7dbebd6d8b079da2..0118c3528ad3aa8414aac77d23051b6aeb196e39 100755 (executable)
--- a/schema/arches-tables.sh
+++ b/schema/arches-tables.sh
@@ -2,5 +2,5 @@
 
 ARCHES="alpha amd64 arm armel hppa i386 ia64 kfreebsd-amd64 kfreebsd-i386 mips mipsel powerpc s390 sparc"
 
-rm arches-tables.sql
+rm -f arches-tables.sql
 for arch in $ARCHES; do sed -e "s/ARCH/$arch/g" < arches-tables.in >> arches-tables.sql ; done