 alter table tiki_users change user user varchar(200) not null default '';
 alter table tiki_userpoints change user user varchar(200) not null default '';
 alter table tiki_userfiles change user user varchar(200) not null default '';
-alter table tiki_user_votings change user user varchar(200) not null default '';
 alter table tiki_user_tasks change user user varchar(200) not null default '';
-alter table tiki_user_taken_quizzes change user user varchar(200) not null default '';
 alter table tiki_user_quizzes change user user varchar(200) not null default '';
 alter table tiki_user_preferences change user user varchar(200) not null default '';
 alter table tiki_user_postings change user user varchar(200) not null default '';

ALTER TABLE tiki_files ADD KEY(archiveId);
ALTER TABLE tiki_files ADD KEY(galleryId);
ALTER TABLE tiki_user_assigned_modules  DROP PRIMARY KEY , ADD PRIMARY KEY (name(30),user,position);
ALTER TABLE tiki_theme_control_objects DROP PRIMARY KEY , ADD PRIMARY KEY (objId, type);
ALTER TABLE tiki_objects ADD KEY(itemId, type);
ALTER TABLE users_users ADD KEY(registrationDate);
ALTER TABLE tiki_rss_modules ADD KEY(name);

	# $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.9to1.10.sql,v 1.130 2007-01-01 09:37:31 mose Exp $

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