Programming/Tips

mantis_project_category_table

acidpop 2014. 8. 29. 16:04
반응형

CREATE TABLE mantis_project_category_table (
project_id INTEGER UNSIGNED NOT NULL DEFAULT 0,
category VARCHAR(64) NOT NULL DEFAULT '',
user_id INTEGER UNSIGNED NOT NULL DEFAULT 0,
                 PRIMARY KEY (project_id, category)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;



http://dryja.info/mantis-to-redmine-migration/



migrate_for_mantis 파일에서 다음 문자열 수정



date_submitted

 ->

date_submitted_redmine

last_updated

 ->

 last_updated_redmine

 date_added

 ->

 date_added_redmine

 date_posted

 ->

 date_posted_redmine

 date_order

 ->

 date_order_redmine