AppDB Fix up creating tables

Tony Lambregts tony_lambregts at telusplanet.net
Sat Apr 17 10:58:50 CDT 2004


When I set up the AppDB on my system I ran into a couple of problems. First,
The create_tables script was not executable and didn't have the shell 
directive "#! /bin/sh". Second, when the tables were set up there was a 
default user set up but it had no administrative rights.

Change log: Fix up creating tables

Files changed: tables/create_tables
               tables/user_list.sql
               tables/user_privs.sql

-- 
Tony Lambregts

Index: create_tables
===================================================================
RCS file: /home/wine/appdb/tables/create_tables,v
retrieving revision 1.1
diff -u -r1.1 create_tables
--- create_tables	24 Mar 2004 15:52:09 -0000	1.1
+++ create_tables	17 Apr 2004 15:23:05 -0000
@@ -1,3 +1,5 @@
+#! /bin/sh
+
 echo Creating appdb tables
 mysql -u root < appdb_tables.sql
 
Index: user_list.sql
===================================================================
RCS file: /home/wine/appdb/tables/user_list.sql,v
retrieving revision 1.2
diff -u -r1.2 user_list.sql
--- user_list.sql	24 Mar 2004 15:51:49 -0000	1.2
+++ user_list.sql	17 Apr 2004 15:23:05 -0000
@@ -16,7 +16,7 @@
 	unique(username(12))
 );
 
-insert into user_list values (NOW(), 0, 'int', password('testing'), 'Charles Loep',
-	'charles at codeweavers.com', NOW(), 0, 0xffffffff);
-update user_list set userid = 1000 where username = 'int';
+insert into user_list values (NOW(), 0, 'admin', password('testing'), 'Administrator',
+	'Admin at localhost', NOW(), 0, 0xffffffff);
+update user_list set userid = 1000 where username = 'admin';
 
Index: user_privs.sql
===================================================================
RCS file: /home/wine/appdb/tables/user_privs.sql,v
retrieving revision 1.2
diff -u -r1.2 user_privs.sql
--- user_privs.sql	24 Mar 2004 15:51:49 -0000	1.2
+++ user_privs.sql	17 Apr 2004 15:23:05 -0000
@@ -8,3 +8,4 @@
 	primary key(userid)
 );
 
+insert into user_privs values (1000, 'admin');





More information about the wine-patches mailing list