experimental modification for MySQL 4.1 with UTF-8
Well, I could not resist and try to run TW190 on MySQL4.1. It worked if on my WAMP localhost, but has some strange issues on Unix production server.
Nevermind, here's a little help for whoever cares - some table modifications to fit into MySQL 4.1 limit of 1000Bytes for indexes (like primary key). With UTF8 charset this is a problem since 1 character = 3 Bytes in UTF8. I had to cut most fields into VARCHAR(150) and I don't guarantee one bit that it'll work.
Copy to clipboard
ALTER TABLE `tiki_newsreader_marks` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `serverId` `serverId` INT( 12 ) DEFAULT '0' NOT NULL , CHANGE `groupName` `groupName` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `timestamp` `timestamp` INT( 14 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_page_footnotes` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `pageName` `pageName` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `data` `data` TEXT CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL; ALTER TABLE `tiki_searchindex` CHANGE `searchword` `searchword` VARCHAR( 80 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `location` `location` VARCHAR( 80 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `page` `page` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `count` `count` INT( 11 ) DEFAULT '1' NOT NULL , CHANGE `last_update` `last_update` INT( 11 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_secdb` CHANGE `md5_value` `md5_value` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `filename` `filename` VARCHAR( 240 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `tiki_version` `tiki_version` VARCHAR( 60 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `severity` `severity` INT( 4 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_user_assigned_modules` CHANGE `name` `name` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `position` `position` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `ord` `ord` INT( 4 ) DEFAULT NULL , CHANGE `type` `type` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL; ALTER TABLE `tiki_user_taken_quizzes` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `quizId` `quizId` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL; ALTER TABLE `tiki_user_votings` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `id` `id` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `optionId` `optionId` INT( 10 ) DEFAULT '0' NOT NULL; ALTER TABLE `tiki_user_watches` CHANGE `user` `user` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `event` `event` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `object` `object` VARCHAR( 140 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci NOT NULL , CHANGE `hash` `hash` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `type` `type` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `url` `url` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL , CHANGE `email` `email` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_slovak_ci DEFAULT NULL;
;){kind=link}
;){kind=link}