 ) TYPE=MyISAM ;
 
 
-
+#2005-12-09 lfagundes
+INSERT INTO `tiki_categorized_objects` SELECT `objectId` FROM `tiki_objects`;
+
+
+
+

# $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.9to1.10.sql,v 1.64 2005-12-07 15:03:55 lfagundes Exp $

# The following script will update a tiki database from verion 1.9 to 1.10
# 

  PRIMARY KEY  (`tagId`)
) TYPE=MyISAM;

#2005-12-06 lfagundes

ALTER TABLE `tiki_categorized_objects` rename to `tiki_objects`;
ALTER TABLE `tiki_objects` CHANGE `catObjectId` `objectId` int(12) not null;
ALTER TABLE `tiki_objects` CHANGE `objId` `itemId` varchar(255);

CREATE TABLE `tiki_freetagged_objects` (
  `tagId` int(12) NOT NULL auto_increment,
  `objectId` int(11) NOT NULL default 0,
