From 5fdedad7285b75c7a128b53ec1afbcc9137f1ccb Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Tue, 28 Jan 2003 15:13:30 +0000
Subject: [PATCH] userflag table now created in upgrade script (bugfix #171)

---
 misc/koha.mysql        |  6 ------
 updater/updatedatabase | 11 ++++++++++-
 2 files changed, 10 insertions(+), 7 deletions(-)

diff --git a/misc/koha.mysql b/misc/koha.mysql
index 32fa963d39..f7532d6872 100644
--- a/misc/koha.mysql
+++ b/misc/koha.mysql
@@ -786,9 +786,3 @@ CREATE TABLE users (
   level smallint(6)
 );
 
-CREATE TABLE userflags (
-  bit int(11) NOT NULL default '0',
-  flag char(30),
-  flagdesc char(255),
-  defaulton int(11)
-);
\ No newline at end of file
diff --git a/updater/updatedatabase b/updater/updatedatabase
index 8e633215c6..13504a9527 100755
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -203,6 +203,12 @@ my %requiretables=(
   									PRIMARY KEY  (id),
   									KEY name (category)
 								)",
+	userflags =>		"( bit int(11) NOT NULL default '0',
+  							flag char(30), flagdesc char(255),
+  							defaulton int(11)
+						)",
+);
+
 	);
 
 
@@ -247,7 +253,7 @@ my %dropable_table=(
 # modified.
 
 my %tabledata=(
-    userflags => [ 
+    userflags => [
     	{ uniquefieldrequired => 'bit', bit => 0, flag => 'superlibrarian', flagdesc => 'Access to all librarian functions', defaulton => 0 },
     	{ uniquefieldrequired => 'bit', bit => 1, flag => 'circulate', flagdesc => 'Circulate books', defaulton => 0 },
     	{ uniquefieldrequired => 'bit', bit => 2, flag => 'catalogue', flagdesc => 'View Catalogue (Librarian Interface)', defaulton => 0 },
@@ -538,6 +544,9 @@ $sth->finish;
 exit;
 
 # $Log$
+# Revision 1.36  2003/01/28 15:13:30  tipaul
+# userflag table now created in upgrade script (bugfix #171)
+#
 # Revision 1.35  2003/01/27 03:12:49  acli
 # Reworded the description for "acquisitions" to make it fit on the screen
 #
-- 
2.39.2