[Server-devel] [PATCH] create_registration: Directly create a v3 format database

[Bernie Innocenti]

Signed-off-by: Bernie Innocenti <bernie at codewiz.org>
---
 idmgr.spec.in               |    2 +-
 scripts/create_registration |    4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/idmgr.spec.in b/idmgr.spec.in
index bbdbcd5..9f8d09e 100644
--- a/idmgr.spec.in
+++ b/idmgr.spec.in
@@ -52,7 +52,7 @@ getent group xousers > /dev/null 2>&1 || groupadd xousers
 #  Create the identity database, if there is no pre-existing one
 #  and set the current rev number
 if [ ! -r /home/idmgr/identity.db ] ; then
-   # creates a v2 format file
+   # creates a v3 format file
    /home/idmgr/create_registration
 fi
 
diff --git a/scripts/create_registration b/scripts/create_registration
index b72a950..190b0f9 100755
--- a/scripts/create_registration
+++ b/scripts/create_registration
@@ -20,6 +20,6 @@
 # create_registration
 # This script creates a new database for the registration server
 #
-sqlite3 /home/idmgr/identity.db "CREATE TABLE laptops ( serial VARCHAR(20) NOT NULL, nickname VARCHAR(200) NOT NULL, full_name VARCHAR(100) NOT NULL, pubkey TEXT NOT NULL, uuid VARCHAR(100), lastmodified TEXT DEFAULT '1970-11-12 12:34:56', PRIMARY KEY (serial) )"
+sqlite3 /home/idmgr/identity.db "CREATE TABLE laptops ( serial VARCHAR(20) NOT NULL, nickname VARCHAR(200) NOT NULL, full_name VARCHAR(100) NOT NULL, pubkey TEXT NOT NULL, uuid VARCHAR(100), lastmodified TEXT DEFAULT '1970-11-12 12:34:56', class_group INTEGER, PRIMARY KEY (serial) )"
 
-[ -x /home/idmgr/storage_format_version ] || echo 2 > /home/idmgr/storage_format_version
\ No newline at end of file
+[ -x /home/idmgr/storage_format_version ] || echo 3 > /home/idmgr/storage_format_version
-- 
1.5.6.5