[Tikiwiki-cvs] tiki/db tiki_1.8to1.9.sql,1.79.2.163,1.79.2.164

[<oh...@us...>]

Update of /cvsroot/tikiwiki/tiki/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6494/db

Modified Files:
      Tag: BRANCH-1-9
	tiki_1.8to1.9.sql 
Log Message:
update to make tiki18db + update script equal to tiki19db

Index: tiki_1.8to1.9.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v
retrieving revision 1.79.2.163
retrieving revision 1.79.2.164
diff -u -d -r1.79.2.163 -r1.79.2.164
--- tiki_1.8to1.9.sql	27 Apr 2006 17:46:20 -0000	1.79.2.163
+++ tiki_1.8to1.9.sql	28 Apr 2006 14:43:29 -0000	1.79.2.164
@@ -1263,4 +1263,11 @@
 
 # 2006-04-26 security issue, split template edit perm into edit and view perms
 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_view_templates', 'Can view site templates', 'admin', 'tiki');
-INSERT INTO users_grouppermissions VALUES ('Admins','tiki_p_view_templates','');
+
+# fixed reserved word use in mysql
+ALTER TABLE `tiki_articles` change `reads` `nbreads` int(14) default NULL ;
+ALTER TABLE `tiki_submissions` change `reads` `nbreads` int(14) default NULL ;
+ALTER TABLE `tiki_articles` DROP INDEX `reads`, ADD INDEX `nbreads` ( `nbreads` ) ;
+ALTER TABLE `tiki_submissions` DROP INDEX `reads`, ADD INDEX `nbreads` ( `nbreads` ) ;
+
+INSERT INTO tiki_modules VALUES ('quick_edit','l',2,NULL,NULL,0,NULL,NULL,'a:2:{i:0;s:10:\"Registered\";}');