 
 # mose 2006-12-28
 # changing username max length
-ALTER TABLE tiki_newsreader_marks DROP PRIMARY KEY , ADD PRIMARY KEY (user(100),serverId,groupName(100));
-ALTER TABLE tiki_page_footnotes DROP PRIMARY KEY , ADD PRIMARY KEY (user(150),pageName(100));
-ALTER TABLE tiki_user_taken_quizzes DROP PRIMARY KEY , ADD PRIMARY KEY (user,quizId(50));
-ALTER TABLE tiki_user_votings DROP PRIMARY KEY , ADD PRIMARY KEY (user(100),id(100));
+ALTER TABLE tiki_newsreader_marks DROP PRIMARY KEY ;
+alter table tiki_newsreader_marks change user user varchar(200) not null default '';
+ALTER TABLE tiki_newsreader_marks ADD PRIMARY KEY (user(100),serverId,groupName(100));
+ALTER TABLE tiki_page_footnotes DROP PRIMARY KEY ;
+alter table tiki_page_footnotes change user user varchar(200) not null default '';
+ALTER TABLE tiki_page_footnotes ADD PRIMARY KEY (user(150),pageName(100));
+alter table tiki_user_taken_quizzes change user user varchar(200) not null default '';
+ALTER TABLE tiki_user_taken_quizzes DROP PRIMARY KEY ;
+ALTER TABLE tiki_user_taken_quizzes ADD PRIMARY KEY (user,quizId(50));
+alter table tiki_user_votings change user user varchar(200) not null default '';
+ALTER TABLE tiki_user_votings DROP PRIMARY KEY ;
+ALTER TABLE tiki_user_votings ADD PRIMARY KEY (user(100),id(100));
 ALTER TABLE tiki_user_watches DROP PRIMARY KEY ;
 ALTER TABLE tiki_user_watches change user user varchar(200) not null default '' ;
 ALTER TABLE tiki_user_watches ADD PRIMARY KEY (user(100),event,object(50));

alter table galaxia_instance_activities change user user varchar(200) not null default '';
alter table tiki_freetagged_objects change user user varchar(200) not null default '';
 
# fixes with key length
ALTER TABLE tiki_theme_control_objects DROP PRIMARY KEY , ADD PRIMARY KEY (objId(100), type(100));








alter table tiki_sessions change user user varchar(200) not null default '';
alter table tiki_semaphores change user user varchar(200) not null default '';
alter table tiki_pages change user user varchar(200) not null default '';
alter table tiki_newsreader_servers change user user varchar(200) not null default '';
alter table tiki_minical_topics change user user varchar(200) not null default '';
alter table tiki_minical_events change user user varchar(200) not null default '';
alter table tiki_mailin_accounts change user user varchar(200) not null default '';
