From: Kenzaburo Ito <kenito@30...> - 2002-06-14 00:07:25
Anyone wanting to bang away on a fairly large dataset can use this:
I'm running into some horrid slowdowns locally (44 seconds to viewall!!!) so I
know we're going to have to make some serious improvements. Some of the
columns may already have some indices built so watch out when you apply the
indices (or you may need to remove them first).
I advise you to make a new database and import the data.
I added 3 new admin users... plain, crypt, and md5. All with the password
'root'. I've mangled all the old passwords/emails/cookie_strings.
Additionally you'll need to upgrade parts of the database to match the current
ALTER TABLE mantis_bug_history_table ADD type INT(2) NOT NULL
ALTER TABLE mantis_project_category_table ADD user_id INT(7) NOT NULL
ALTER TABLE mantis_news_table ADD view_state INT(2) DEFAULT '10' NOT NULL
ALTER TABLE mantis_news_table ADD announcement INT(1) NOT NULL AFTER view_state;
ALTER TABLE mantis_bug_relationship_table ADD id INT(7) UNSIGNED ZEROFILL NOT
NULL AUTO_INCREMENT PRIMARY KEY FIRST;
Let me know if anything is awry.