From: <oh...@us...> - 2006-04-28 14:43:35
|
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\";}'); |