[Tikiwiki-devel] Understanding tiki_1.8to1.9.sql vs tiki.sql

[Marc L. <mar...@av...>]

Hi!

Question about tiki_1.8to1.9.sql vs tiki.sql  : If I do a clean install 
(vs tiki.sql) and just after, I do a tiki_1.8to1.9.sql, shouldn't the DB 
not change. ie DB should remain exactly the same?

In a recent test, clean install is 202 tables after script, it's 204.

I end up with some duplicates of menu item, exemple for example some 
homework menu items. Some others things also change...


Compare: (<) beforeupgradescript.sql (198064 bytes)
   with: (>) afterupgradescript.sql (205065 bytes)


< -- Generation Time: Feb 12, 2005 at 10:22 PM
---
 > -- Generation Time: Feb 12, 2005 at 10:24 PM



 > INSERT INTO `tiki_menu_options` VALUES (176, 42, 'o', 'Shoutbox 
Words', 'tiki-admin_shoutbox_words.php', 1191, '', 
'tiki_p_admin_shoutbox', '');
 > INSERT INTO `tiki_menu_options` VALUES (177, 42, 's', 'Homework', 
'tiki-hw_teacher_assignments.php', 270, 'feature_homework', 
'tiki_p_hw_teacher', '');
 > INSERT INTO `tiki_menu_options` VALUES (178, 42, 'o', 'Assignments', 
'tiki-hw_teacher_assignments.php', 272, 'feature_homework', 
'tiki_p_hw_teacher', '');
 > INSERT INTO `tiki_menu_options` VALUES (179, 42, 'o', 'Grading 
Queue', 'tiki-hw_teacher_grading_queue.php', 274, 'feature_homework', 
'tiki_p_hw_teacher', '');
 > INSERT INTO `tiki_menu_options` VALUES (180, 42, 'o', 'Last Changes', 
'tiki-hw_teacher_last_changes.php', 276, 'feature_homework', 
'tiki_p_hw_teacher', '');
 > INSERT INTO `tiki_menu_options` VALUES (181, 42, 's', 'Homework', 
'tiki-hw_student_assignments.php', 280, 'feature_homework', 
'tiki_p_hw_student', '');
 > INSERT INTO `tiki_menu_options` VALUES (182, 42, 'o', 'Assignments', 
'tiki-hw_teacher_assignments.php', 282, 'feature_homework', 
'tiki_p_hw_student', '');
 > INSERT INTO `tiki_menu_options` VALUES (183, 42, 'o', 'Last Changes', 
'tiki-hw_teacher_assignments.php', 284, 'feature_homework', 
'tiki_p_hw_student', '');


3085c3108
< INSERT INTO `tiki_preferences` VALUES ('email_encoding', 'utf-8');
---
 > INSERT INTO `tiki_preferences` VALUES ('default_wiki_diff_style', 'old');


CREATE TABLE `tiki_trackers` (

<   `name` varchar(80) default NULL,
---
 >   `name` varchar(255) default NULL,


CREATE TABLE `users_objectpermissions`

<   PRIMARY KEY  (`objectId`,`objectType`,`groupName`(30),`permName`)
---
 >   PRIMARY KEY  (`objectId`,`groupName`(30),`permName`)


CREATE TABLE `users_users`

<   KEY `score` (`score`)
---
 >   KEY `score` (`score`),
 >   KEY `score_2` (`score`)


Can someone confirm if/how this should be solved?

-- 
M ;-)

//////////////////////////////////////////////////////////////////
/                                                                /
/ Marc Laporte       <|>                  http://marclaporte.com /
/ Avantech.net       <|>                     http://avantech.net /
/ Tiki CMS/Groupware <|> http://tikiwiki.org/UserPagemarclaporte /
/                                                                /
//////////////////////////////////////////////////////////////////