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