-- Table structure for table `mantis_project_category_table`
DROP TABLE IF EXISTS `mantis_project_category_table`;
CREATE TABLE `mantis_project_category_table` (
-- Dumping data for table `mantis_project_category_table`
LOCK TABLES `mantis_project_category_table` WRITE;
/*!40000 ALTER TABLE `mantis_project_category_table` DISABLE KEYS */;
INSERT INTO `mantis_project_category_table` VALUES (1,'bugtracker',0),(1,'other',0),(1,'security',0),(2,'other',0),(2,'php',0),(2,'system',0),(3,'php',0),(3,'other',0),(4,'GUI',0),(4,'other',0),(5,'Błąd: interfejs',0),(5,'Błąd: inny',0),(6,'GUI',0),(6,'Misc',0),(3,'javascript',0),(8,'Kategoria 1',0),(8,'Kategoria 2',0),(11,'Błąd funkcjonalności',0),(11,'Błąd wyglądu',0),(11,'Zmiana funkcjonalności',0),(11,'Zmiana wyglądu',0),(11,'Dane',0),(12,'system',0),(12,'konfigurator lokalny',0),(12,'system uaktualnien',0),(2,'docs',0),(11,'Dokumentacja',0),(11,'Prace dodatkowe',0),(14,'Błąd',0),(14,'Zmiana funkcjonalności',0),(15,'Błąd importu',0),(15,'Błąd GUI',0),(15,'Zmiana funkcjonalności',0),(15,'Inny',0),(14,'Inny',0),(5,'Zlecenie: inne',0),(5,'Zlecenie: dane',0),(5,'Zlecenie: interfejs',0),(5,'Błąd: raport',0),(5,'Błąd: dane',0),(5,'Zlecenie: raport',0),(16,'dane',0),(16,'inny',0),(16,'interfejs',0),(16,'raport',0),(18,'Interfejs użytkownika',0),(17,'Kategoria 2',0),(17,'Kategoria 1',0),(16,'dokumentacja',0),(18,'Import płatności',0),(18,'Raporty',0),(18,'Baza danych',0),(18,'Inny',0),(19,'Lack of action',0),(19,'Improper functionality',0),(19,'Improper calculation',0),(19,'Lack of functionality',0),(19,'Incorrect action',0),(19,'Causes software instability',0),(19,'Not intuitive or not ergonomic behaviour',0),(20,' Błąd funkcjonalności',0),(20,' Błąd wyglądu',0),(20,'Dane',0),(20,'Dokumentacja',0),(20,'Prace dodatkowe',0),(20,' Zmiana funkcjonalności',0),(20,' Zmiana wyglądu',0),(21,'Formularze',0),(21,'Struktura bazy',0),(21,'Dokumentacja',0),(22,'Błąd funkcjonalności',0),(22,'Błąd wyglądu',0),(22,'Dane',0),(22,'Dokumentacja',0),(22,'Prace dodatkowe',0),(22,'Zmiana funkcjonalności',0),(22,'Zmiana wyglądu',0),(23,'Błąd funkcjonalności',0),(23,'Błąd wyglądu',0),(23,'Dane',0),(23,'Dokumentacja',0),(23,'Prace dodatkowe',0),(23,'Zmiana funkcjonalności',0),(23,'Zmiana wyglądu',0),(24,'Błąd funkcjonalności',0),(24,'Błąd wyglądu',0),(24,'Dane',0),(24,'Dokumentacja',0),(24,'Prace dodatkowe',0),(24,'Zmiana funkcjonalności',0),(24,'Zmiana wyglądu',0),(25,'Błąd funkcjonalności',0),(25,'Błąd wyglądu',0),(25,'Dane',0),(25,'Dokumentacja',0),(25,'Prace dodatkowe',0),(25,'Zmiana funkcjonalności',0),(25,'Zmiana interfejsu',0),(26,'Causes software instability',0),(26,'Improper calculation',0),(26,'Improper functionality',0),(26,'Incorrect action',0),(26,'Lack of action',0),(26,'Lack of functionality',0),(26,'Not intuitive or not ergonomic behaviour',0),(29,'Błąd funkcjonalności',0),(29,'Błąd wyglądu',0),(29,'Dane',0),(29,'Dokumentacja',0),(29,'Prace dodatkowe',0),(29,'Zmiana funkcjonalności',0),(29,'Zmiana wyglądu',0),(28,'Błąd funkcjonalności',0),(28,'Błąd wyglądu',0),(28,'Dane',0),(28,'Dokumentacja',0),(28,'Prace dodatkowe',0),(28,'Zmiana funkcjonalności',0),(28,'Zmiana wyglądu',0),(27,'Dokumentacja',0),(27,'Formularze',0),(27,' Struktura bazy',0),(30,'Błąd funkcjonalności',0),(30,'Błąd wyglądu',0),(31,'Improper calculation',0),(31,'Causes software instability',0),(30,'Zmiana funkcjonalności',0),(30,'Zmiana wyglądu',0),(31,'Improper functionality',0),(31,'Incorrect action',0),(31,'Lack of action',0),(31,'Lack of functionality',0),(31,'Not intuitive or not ergonomic behaviour',0),(32,'Volvo',0),(32,'Euroservice',0),(32,'Other',0),(32,'KNS',0),(36,'Błąd funkcjonalności',0),(35,'Inny',0),(35,'Baza danych',0),(35,'Raport',0),(35,'Interfejs',0),(35,'Dokumentacja',0),(36,'Błąd wyglądu',0),(36,'Dane',0),(36,'Dokumentacja',0),(36,'Prace dodatkowe',0),(36,'Zmiana funkcjonalności',0),(36,'Zmiana wyglądu',0),(39,'Causes software instability',0),(37,'Maestro General',0),(37,'MyPlan General',0),(37,'MyPlan UC12',0),(37,'MyPlan UC11',0),(37,'MyPlan UC10',0),(39,'Improper calculation',0),(39,'Improper functionality',0),(39,'Incorrect action',0),(39,'Lack of action',0),(39,'Lack of functionality',0),(39,'Not intuitive or not ergonomic behaviour',0),(39,'GUI change',0),(39,'Release information',0),(39,'Documentation',0),(38,'zmiana funkcjonalności',0),(38,'błąd',0),(38,'zmiana wyglądu',0),(38,'nowa funkcjonalność',0),(38,'notatka',0),(40,'Causes software instability',0),(40,'Documentation',0),(43,'Prace dodatkowe',0),(43,'Dokumentacja',0),(40,'Improper functionality',0),(43,'Dane',0),(43,'Błąd wyglądu',0),(40,'Lack of functionality',0),(43,'Błąd funkcjonalności',0),(40,'Release information',0),(43,'Zmiana funkcjonalności',0),(43,'Zmiana wyglądu',0),(42,'Błąd funkcjonalności',0),(42,'Błąd wyglądu',0),(42,'Dane',0),(42,'Dokumentacja',0),(42,'Prace dodatkowe',0),(42,'Zmiana funkcjonalności',0),(42,'Zmiana wyglądu',0),(41,'Błąd funkcjonalności',0),(41,'Błąd wyglądu',0),(41,'Dane',0),(41,'Dokumentacja',0),(41,'Prace dodatkowe',0),(41,'Zmiana funkcjonalności',0),(41,'Zmiana wyglądu',0),(44,'błąd',0),(44,'notatka',0),(44,'nowa funkcjonalność',0),(44,'zmiana funkcjonalności',0),(44,'zmiana wyglądu',0),(47,'Question about specification',0),(48,'Błąd funkcjonalności',0),(48,'Błąd wyglądu',0),(48,'Dane',0),(48,'Dokumentacja',0),(48,'Prace dodatkowe',0),(48,'Zmiana funkcjonalności',0),(48,'Zmiana wyglądu',0),(51,'błąd',0),(51,'notatka',0),(51,'nowa funkcjonalność',0),(51,'zmiana funkcjonalności',0),(51,'zmiana wyglądu',0),(54,'Interfejs - błąd',0),(54,'Interfejs - propozycja',0),(54,'Treść - błąd',0),(54,'Treść - propozycja',0),(55,'JBOSS - krytyczny',0),(55,'PostgreSQL - krytyczny',0),(55,'Linux - krytyczny',0),(55,'Linux - niekrytyczny',0),(55,'JBOSS - ważny',0),(55,'JBOSS - niekrytyczny',0),(55,'PostgreSQL - niekrytyczny',0),(55,'PostgreSQL - ważny',0),(55,'Hibernate - krytyczny',0),(55,'Hibernate - niekrytyczny',0),(55,'Hibernate - ważny',0),(55,'Tomcat - ważny',0),(55,'Tomcat - krytyczny',0),(55,'Tomcat - niekrytyczny',0),(56,'Nowa funkcjonalność',0),(56,'Błąd',0),(56,'Uwaga',0),(56,'Zmiana funkcjonalności',0),(57,'błąd',0),(57,'notatka',0),(57,'nowa funkcjonalność',0),(57,'zmiana funkcjonalności',0),(57,'zmiana wyglądu',0),(57,'pytanie',0),(58,'błąd',0),(58,'notatka',0),(58,'nowa funkcjonalność',0),(58,'pytanie',0),(58,'zmiana funkcjonalności',0),(58,'zmiana wyglądu',0),(59,'błąd',0),(59,'notatka',0),(59,'nowa funkcjonalność',0),(59,'pytanie',0),(59,'zmiana funkcjonalności',0),(59,'zmiana wyglądu',0),(60,'błąd',0),(60,'notatka',0),(60,'nowa funkcjonalność',0),(60,'pytanie',0),(60,'zmiana funkcjonalności',0),(60,'zmiana wyglądu',0),(61,'błąd',0),(61,'notatka',0),(61,'nowa funkcjonalność',0),(61,'pytanie',0),(61,'zmiana funkcjonalności',0),(61,'zmiana wyglądu',0),(54,'Zlecenie - treść',0),(54,'Zlecenie - inne',0),(66,'dokumentacja',0),(66,'D2Struct',182),(66,'projekt',0),(68,'GUI - błąd',0),(68,'GUI - propozycja',0),(66,'D2Doc',181),(66,'UI',150),(69,'Environment',0),(69,'CBKWS',0),(69,'Java APP',0),(69,'PHP APP',0),(69,'Docs',0),(66,'D2Assist',181),(70,'GUI',0),(70,'API',0),(68,'DAO - błąd',0),(68,'DAO - propozycja',0),(68,'Baza - błąd',0),(68,'Baza - propozycja',0),(66,'D2Mem',0),(66,'D2Sec',0),(66,'EGIS-impl',0),(73,'Baza - błąd',0),(73,'Baza - propozycja',0),(73,'DAO - błąd',0),(73,'DAO - propozycja',0),(73,'GUI - błąd',0),(73,'GUI - propozycja',0),(73,'Kod',0),(73,'Funkcjonalność - propozycja',0),(73,'Funkcjonalność - błąd',0),(74,'TODO',0),(74,'UI',0),(74,'Dokumentacja',0),(74,'Framework',0),(74,'Integracja',0),(74,'Środowisko',0),(75,'GUI',0),(72,'WWW: błąd',0),(72,'WWW: propozycja',0),(72,'Baza danych: błąd',0),(72,'Skanowanie: błąd',0),(72,'Skanowanie: propozycja',0),(76,'Baza danych: błąd',0),(76,'Skanowanie: błąd',0),(76,'Skanowanie: propozycja',0),(76,'WWW: błąd',0),(76,'WWW: propozycja',0),(83,'Tester oprogramowania',0),(83,'Programista niskopoziomowy',0),(76,'Baza danych: propozycja',0),(83,'Administrator',0),(83,'Java Developer',0),(84,'Programista Oracle',0),(84,'Java Developer',0),(85,'Java Developer',0),(84,'Programista dekoderow',0),(82,'Ksiazki',0),(82,'Sprzet',0),(82,'Artykuly biurowe',0),(82,'Zakupy prywatne',0),(83,'Generic Developer',0),(75,'Baza - błąd',0),(75,'Baza - propozycja',0),(75,'DAO - błąd',0),(75,'DAO - propozycja',0),(75,'Funkcjonalność - błąd',0),(75,'Funkcjonalność - propozycja',0),(75,'GUI - błąd',0),(75,'GUI - propozycja',0),(75,'Kod',0),(85,'Developer',0),(73,'Zadanie do wykonania',0),(83,'Technical Lead',0),(83,'Programista baz danych',0),(94,'Nagra',0),(94,'GUI',0),(94,'Tuner',0),(94,'Filtry',0),(94,'Sterowniki',0),(94,'Inne',0),(97,'Build and deployment',151),(97,'Logic Layer',20),(97,'Processing Layer',151),(97,'TODO',0),(97,'System Layer',151),(97,'Documentation',0),(97,'SAD',20),(95,'różne',0),(97,'Tests',211),(97,'Core',151),(96,'Organization',0),(96,'Analysis',0),(102,'Raport - błąd',0),(102,'Raport - propozycja',0),(102,'PLSQL - błąd',0),(102,'PLSQL - propozycja',0),(102,'Inne - błąd',0),(101,'błąd',0),(101,'notatka',0),(101,'nowa funkcjonalność',0),(101,'zmiana funkcjonalności',0),(101,'zmiana wyglądu',0),(101,'--bez kategorii--',0),(101,'regiony',0),(103,'błąd',0),(103,'brakująca funkcjonalność',0),(103,'zmiana / dodanie nowej funkcjonalności',0),(103,'kosmetyka / tuning',0),(108,'Analiza',149),(108,'Build',105),(108,'Devel',0),(108,'Docs',0),(108,'Projekt',105),(99,'Development',0),(99,'Tests',0),(99,'Integration',0),(99,'Documentation',0),(100,'Documentation',0),(100,'Tests',0),(100,'Logic',0),(98,'Development',0),(109,'zmiana / dodanie nowej funkcjonalności',0),(109,'kosmetyka / tuning',0),(109,'błąd',0),(109,'brakująca funkcjonalność',0),(110,'Inne',0),(110,'Nowa funkcjonalność',0),(110,'Krytyczne',0),(110,'Ważne',0),(98,'Documentation',0),(98,'Integration',0),(98,'Tests',0),(83,'Grafik',0),(110,'Konsultacje',0),(110,'Gwarancja',0);
/*!40000 ALTER TABLE `mantis_project_category_table` ENABLE KEYS */;
INSERT INTO `mantis_upgrade_table` VALUES ('0.13-1','Add mantis_project_table'),('0.13-2','Insert default project into mantis_project_table'),('0.13-3','Add mantis_project_category_table'),('0.13-4','Add mantis_project_version_table'),('0.13-5','Add project_id column to mantis_bug_table'),('0.13-6','Change category column in mantis_bug_table to varchar'),('0.13-7','Change version column in mantis_bug_table to varchar'),('0.13-8','Set project_id to \"0000001\" for all bugs'),('0.13-9','Add project_id column news table'),('0.13-10','Set project_id to \"0000001\" for all news postings'),('0.13-11','Added login count to user table'),('0.13-12','Add manager to access_levels'),('0.13-13','Make username unique'),('0.14a-0',''),('0.14a-1',''),('0.14a-2',''),('0.14a-3',''),('0.14a-4',''),('0.14a-5',''),('0.14a-6',''),('0.14a-7',''),('0.14a-8',''),('0.14a-9',''),('0.14-0','Change some of the TIMESTAMP fields to DATETIME'),('0.14-1','Change some of the TIMESTAMP fields to DATETIME'),('0.14-2','Change some of the TIMESTAMP fields to DATETIME'),('0.14-3','Change some of the TIMESTAMP fields to DATETIME'),('0.14-4','INT(1) Updates (Before ALTERation)'),('0.14-5','INT(1) Updates (Before ALTERation)'),('0.14-6','INT(1) Updates (Before ALTERation)'),('0.14-7','INT(1) Updates (Before ALTERation)'),('0.14-8','INT(1) Updates (Before ALTERation)'),('0.14-9','INT(1) Updates (Before ALTERation)'),('0.14-10','INT(1) Updates (Before ALTERation)'),('0.14-11','INT(1) Updates (Before ALTERation)'),('0.14-12','INT(1) Updates (Before ALTERation)'),('0.14-13','INT(1) Updates (Before ALTERation)'),('0.14-14','INT(1) Updates (Before ALTERation)'),('0.14-15','INT(1) Updates (Before ALTERation)'),('0.14-16','Change CHAR(3) to INT(1)'),('0.14-17','Change CHAR(3) to INT(1)'),('0.14-18','Change CHAR(3) to INT(1)'),('0.14-19','Change CHAR(3) to INT(1)'),('0.14-20','Change CHAR(3) to INT(1)'),('0.14-21','Change CHAR(3) to INT(1)'),('0.14-22','ENUM Updates (Before ALTERation)'),('0.14-23','ENUM Updates (Before ALTERation)'),('0.14-24','ENUM Updates (Before ALTERation)'),('0.14-25','ENUM Updates (Before ALTERation)'),('0.14-26','ENUM Updates (Before ALTERation)'),('0.14-27','ENUM Updates (Before ALTERation)'),('0.14-28','ENUM Updates (Before ALTERation)'),('0.14-29','ENUM Updates (Before ALTERation)'),('0.14-30','ENUM Updates (Before ALTERation)'),('0.14-31','ENUM Updates (Before ALTERation)'),('0.14-32','ENUM Updates (Before ALTERation)'),('0.14-33','ENUM Updates (Before ALTERation)'),('0.14-34','ENUM Updates (Before ALTERation)'),('0.14-35','ENUM Updates (Before ALTERation)'),('0.14-36','ENUM Updates (Before ALTERation)'),('0.14-37','ENUM Updates (Before ALTERation)'),('0.14-38','ENUM Updates (Before ALTERation)'),('0.14-39','ENUM Updates (Before ALTERation)'),('0.14-40','ENUM Updates (Before ALTERation)'),('0.14-41','ENUM Updates (Before ALTERation)'),('0.14-42','ENUM Updates (Before ALTERation)'),('0.14-43','ENUM Updates (Before ALTERation)'),('0.14-44','ENUM Updates (Before ALTERation)'),('0.14-45','ENUM Updates (Before ALTERation)'),('0.14-46','ENUM Updates (Before ALTERation)'),('0.14-47','ENUM Updates (Before ALTERation)'),('0.14-48','ENUM Updates (Before ALTERation)'),('0.14-49','ENUM Updates (Before ALTERation)'),('0.14-50','ENUM Updates (Before ALTERation)'),('0.14-51','ENUM Updates (Before ALTERation)'),('0.14-52','ENUM Updates (Before ALTERation)'),('0.14-53','ENUM Updates (Before ALTERation)'),('0.14-54','ENUM Updates (Before ALTERation)'),('0.14-55','ENUM Updates (Before ALTERation)'),('0.14-56','ENUM Updates (Before ALTERation)'),('0.14-57','ENUM Updates (Before ALTERation)'),('0.14-58','ENUM Updates (Before ALTERation)'),('0.14-59','ENUM Updates (Before ALTERation)'),('0.14-60','ENUM Updates (Before ALTERation)'),('0.14-61','ENUM Updates (Before ALTERation)'),('0.14-62','ENUM Updates (Before ALTERation)'),('0.14-63','ENUM Updates (Before ALTERation)'),('0.14-64','ENUM Updates (Before ALTERation)'),('0.14-65','ENUM Updates (Before ALTERation)'),('0.14-66','ENUM Updates (Before ALTERation)'),('0.14-67','ENUM Updates (Before ALTERation)'),('0.14-68','ENUM Updates (Before ALTERation)'),('0.14-69','ENUM Updates (Before ALTERation)'),('0.14-70','ENUM Updates (Before ALTERation)'),('0.14-71','ENUM Updates (Before ALTERation)'),('0.14-72','ENUM Updates (Before ALTERation)'),('0.14-73','ENUM Updates (Before ALTERation)'),('0.14-74','ENUM Updates (Before ALTERation)'),('0.14-75','ENUM Updates (Before ALTERation)'),('0.14-76','ENUM Updates (Before ALTERation)'),('0.14-77','ENUM Updates (Before ALTERation)'),('0.14-78','ENUM Updates (Before ALTERation)'),('0.14-79','Change ENUM to INT'),('0.14-80','Change ENUM to INT'),('0.14-81','Change ENUM to INT'),('0.14-82','Change ENUM to INT'),('0.14-83','Change ENUM to INT'),('0.14-84','Change ENUM to INT'),('0.14-85','Change ENUM to INT'),('0.14-86','Change ENUM to INT'),('0.14-87','Update dates to be legal'),('0.14-88','Update dates to be legal'),('0.14-89','Update dates to be legal'),('0.14-90','Shorten cookie string to 64 characters'),('0.14-91','Add file_path to projects'),('0.14-92','Add access_min to projects'),('0.14-93','Add new user prefs'),('0.14-94','Add new user prefs'),('0.14-95','Add new user prefs'),('0.14-96','Add new user prefs'),('0.14-97','Add new user prefs'),('0.14-98','Add new user prefs'),('0.14-99','Add new user prefs'),('0.14-100','Add new user prefs'),('0.14-101','Add new user prefs'),('0.14-102','Add new user prefs'),('0.14-103','Add new user prefs'),('0.14-104','Add new user prefs'),('0.14-105','Add new user prefs'),('0.14-106','Add new user prefs'),('0.14-107','Add new user prefs'),('0.14-108','Add new user prefs'),('0.14-109','Make new project level user access table'),('0.14-110','Make new project file table'),('0.14-111','Make new bug file table'),('0.14-112','more varchar to enum conversions'),('0.14-113','more varchar to enum conversions'),('0.14-114','Need this entry for the project listing to work'),('0.14-115','Add ordering field for versions'),('0.14-116','Make the cookie string unique'),('0.15-1','Add file type column to bug file table'),('0.15-2','Add file type column to project file table'),('0.15-3',''),('0.15-4',''),('0.15-5',''),('0.15-6',''),('0.15-7',''),('0.15-8','Create bug history table'),('0.15-9','Add order field to project version table'),('0.16-1',''),('0.16-2',''),('0.16-3',''),('0.16-4',''),('0.16-5',''),('0.16-6',''),('0.16-7','Add view_state to bug table'),('0.16-8','Add view_state to bugnote table'),('0.16-9',''),('0.16-10',''),('0.16-11',''),('0.16-12',''),('0.16-13','Add project_id to user pref table'),('0.16-14','Create bug relationship table'),('0.16-15','Create bug monitor table'),('0.17-jf-1','Printing Preference Table'),('0.17-jf-2','Bug history'),('0.17-jf-3','Auto-assigning of bugs for a default user per category'),('0.17-jf-4','Private news support'),('0.17-jf-5','Allow news items to stay at the top'),('0.17-jf-6','relationship support'),('0.17-custom-field-1','Add mantis_custom_field_table'),('0.17-custom-field-2','Add mantis_custom_field_string_table'),('0.17-custom-field-3','Add mantis_custom_field_project_table'),('0.17-jf-7','Drop mantis_project_customization_table'),('0.17-jf-8','Drop votes column of mantis_bug_table'),('0.17-jf-9','Add primary key on mantis_project_version_table'),('0.17-jf-10','Add primary key on mantis_project_user_list_table'),('0.17-jf-11','Add primary key on mantis_project_category_table'),('0.17-jf-12','Add primary key on mantis_bug_monitor_table'),('0.17-jf-13','Remove zerofill on mantis_bug_file_table.id'),('0.17-jf-14','Remove zerofill on mantis_bug_file_table.bug_id'),('0.17-jf-15','Remove zerofill on mantis_bug_history_table.user_id'),('0.17-jf-16','Remove zerofill on mantis_bug_history_table.bug_id'),('0.17-jf-17','Remove zerofill on mantis_bug_monitor_table.user_id'),('0.17-jf-18','Remove zerofill on mantis_bug_relationship_table.id'),('0.17-jf-19','Remove zerofill on mantis_bug_relationship_table.source_bug_id'),('0.17-jf-20','Remove zerofill on mantis_bug_relationship_table.destination_bug_id'),('0.17-jf-21','Remove zerofill on mantis_bug_table.id'),('0.17-jf-22','Remove zerofill on mantis_bug_table.project_id'),('0.17-jf-23','Remove zerofill on mantis_bug_table.reporter_id'),('0.17-jf-24','Remove zerofill on mantis_bug_table.handler_id'),('0.17-jf-25','Remove zerofill on mantis_bug_table.duplicate_id'),('0.17-jf-26','Remove zerofill on mantis_bug_table.bug_text_id'),('0.17-jf-27','Remove zerofill on mantis_bug_table.profile_id'),('0.17-jf-28','Remove zerofill on mantis_bug_text_table.id'),('0.17-jf-29','Remove zerofill on mantis_bugnote_table.id'),('0.17-jf-30','Remove zerofill on mantis_bugnote_table.bug_id'),('0.17-jf-31','Remove zerofill on mantis_bugnote_table.reporter_id'),('0.17-jf-32','Remove zerofill on mantis_bugnote_table.bugnote_text_id'),('0.17-jf-33','Remove zerofill on mantis_bugnote_text_table.id'),('0.17-jf-34','Remove zerofill on mantis_news_table.id'),('0.17-jf-35','Remove zerofill on mantis_news_table.project_id'),('0.17-jf-36','Remove zerofill on mantis_news_table.poster_id'),('0.17-jf-37','Remove zerofill on mantis_project_category_table.project_id'),('0.17-jf-38','Remove zerofill on mantis_project_file_table.id'),('0.17-jf-39','Remove zerofill on mantis_project_file_table.project_id'),('0.17-jf-40','Remove zerofill on mantis_project_table.id'),('0.17-jf-41','Remove zerofill on mantis_project_user_list_table.project_id'),('0.17-jf-42','Remove zerofill on mantis_project_user_list_table.user_id'),('0.17-jf-43','Remove zerofill on mantis_project_version_table.project_id'),('0.17-jf-44','Remove zerofill on mantis_user_pref_table.id'),('0.17-jf-45','Remove zerofill on mantis_user_pref_table.user_id'),('0.17-jf-46','Remove zerofill on mantis_user_pref_table.project_id'),('0.17-jf-47','Remove zerofill on mantis_user_pref_table.default_profile'),('0.17-jf-48','Remove zerofill on mantis_user_pref_table.default_project'),('0.17-jf-49','Remove zerofill on mantis_user_print_pref_table.user_id'),('0.17-jf-50','Remove zerofill on mantis_user_profile_table.id'),('0.17-jf-51','Remove zerofill on mantis_user_profile_table.user_id'),('0.17-jf-52','Remove zerofill on mantis_user_table.id'),('0.17-compat-1','Set default for mantis_bug_file_table.date_added (incorrect for 0.15 installs)'),('0.17-compat-2','Correct values for mantis_bug_file_table.date_added (incorrect for 0.15 installs)'),('0.17-compat-3','Set default for mantis_project_file_table.date_added (incorrect for 0.15 installs)'),('0.17-compat-4','Correct values for mantis_project_file_table.date_added (incorrect for 0.15 installs)'),('0.17-compat-5','Set default for mantis_bug_table.build (incorrect for 0.16 installs)'),('0.17-compat-6','Correct values for mantis_bug_table.build (incorrect for 0.16 installs)'),('0.17-compat-7','Set default for mantis_user_table.date_created (incorrect for < 0.17 installs)'),('0.17-compat-8','Correct values for mantis_user_table.date_created (incorrect for < 0.17 installs)'),('0.17-compat-9','Set default for mantis_project_table.enabled to 1 (incorrect for < 0.17 installs)'),('0.17-compat-10','Set default for mantis_news_table.date_posted (incorrect for < 0.17 installs)'),('0.17-compat-11','Correct values for mantis_news_table.date_posted (incorrect for < 0.17 installs)'),('0.17-compat-12','Set default for mantis_bug_table.date_submitted (incorrect for < 0.17 installs)'),('0.17-compat-13','Correct values for mantis_bug_table.date_submitted (incorrect for < 0.17 installs)'),('0.17-compat-14','Set default for mantis_bugnote_table.date_submitted (incorrect for < 0.17 installs)'),('0.17-compat-15','Correct values for mantis_bugnote_table.date_submitted (incorrect for < 0.17 installs)'),('0.17-compat-16','Add unique index to cookie_string if it is not already there (incorrect for > 0.14)'),('0.17-compat-17','Remove mantis_project_version_table.ver_order (incorrect for < 0.15)'),('0.17-compat-18','Remove users from project 0'),('0.17-vb-19','Add id field to bug history table'),('0.18-vb-1','Add index on bug_id field in mantis_bug_file_table.'),('filtersdb-1','Add mantis_filters_table'),('emailsevs-1','Add the necessary columns for email severity filtering'),('sponsorship-1','Add sponsorships table'),('sponsorship-2','Add sponsorship_total to bug table'),('sponsorship-3','Add an index on sponsorship_total in bug table'),('fixed_in_version-1','Add fixed_in_version field to bug table.'),('fixed_in_version-2','Add index on fixed_in_version field in bug table.'),('user_realname','Add real name to user information.'),('custom_fields-1','Allow custom fields to be set/required for resolve/close/report/update'),('custom_fields-2','Allow custom fields to be set/required for resolve/close/report/update'),('custom_fields-3','Allow custom fields to be set/required for resolve/close/report/update'),('custom_fields-4','Allow custom fields to be set/required for resolve/close/report/update'),('custom_fields-5','Allow custom fields to be set/required for resolve/close/report/update'),('custom_fields-6','Allow custom fields to be set/required for resolve/close/report/update'),('version_remove_pk','Remove project_id+version primary key'),('version_add_version_','Add id to version table and use it as primary key'),('version_add_project_','Add a unique index for project_id + version combination.'),('version_add_descript','Add description field to versions.'),('version_add_released','Add released flag to determine whether the version was released or still a future release.'),('relationship-1','Add index on source_bug_id field in mantis_bug_relationship_table'),('relationship-2','Add index on destination_bug_id field in mantis_bug_relationship_table'),('relationship-3','Translate duplicate id information in a new duplicate relationship'),('relationship-4','Fix swapped value in duplicate relationship'),('cat_user_id_unsigned','Change the user_id in mantis_project_category_table to unsigned int.'),('custom_fields-7','Allow custom fields to be hidden/displayed for report/update'),('custom_fields-8','Allow custom fields to be hidden/displayed for report/update'),('custom_fields-9','Rename Column'),('custom_fields-10','Rename Column'),('custom_fields-11','Rename Column'),('custom_fields-12','Rename Column'),('custom_fields-13','Rename Column'),('custom_fields-14','Rename Column'),('custom_fields-15','Rename Column'),('custom_fields-16','Rename Column'),('custom_fields-17','Rename Column'),('custom_fields-18','Rename Column'),('custom_fields-19','Rename Column'),('custom_fields-20','Rename Column'),('lost-password','Add the necessary columns for managing lost passwords'),('delete-admin-over','Delete any project level access overrides for admin users'),('0.18-bugnote-limit','Add email_bugnote_limit to user preference table'),('0.18-bugnote-order','Add bugnote_order to user preference table'),('cb_ml_upgrade','Upgrade custom field types (checkbox, list, multilist) to support advanced filtering'),('bugnote-type','Add note type column to bugnote'),('bugnote-attr','Add note_attr column to bugnote'),('tokensdb-1','Add mantis_tokens_table'),('sticky-issues','Add sticky column to bug table'),('project-hierarchy','Add project hierarchy table'),('configdb-1','Add mantis_config_table'),('field_shorten-1','shorten field names: lost_password_in_progress_count'),('field_naming-1','DBMS compatibility: access is a reserved word'),('configdb-un','Drop mantis_config_table unique key'),('config-key1','make mantis_config_table keys not null'),('config-key2','make mantis_config_table keys not null'),('configdb-pk','Add mantis_config_table primary key'),('note_bug_id_index','Add index on bug_id in bugnotes table'),('project_child_index','Add index on child_id in project heirarchy table'),('bug_status_index','Add index on status in bug table'),('bug_project_index','Add index on project_id in bug table'),('note_updated_index','Add index on last_modified in bugnotes table'),('project_vs_index','Add index on view_state in project table'),('project_uid_index','Add index on user_id in project_user table'),('user_enabled_index','Add index on enabled in user table'),('user_access_index','Add index on access_level in user table'),('cf_string_bug_index','Add index on bug_id in custom_field_string table'),('pref_new_min','change pref email_on_new_minimum_severity for database compabilility'),('pref_assigned_min','change pref email_on_assigned_minimum_severity for database compabilility'),('pref_feedback_min','change pref email_on_feedback_minimum_severity for database compabilility'),('pref_status_min','change pref email_on_minimum_severity for database compabilility'),('pref_resolved_min','change pref email_on_resolved_minimum_severity for database compabilility'),('pref_closed_min','change pref email_on_closed_minimum_severity for database compabilility'),('pref_reopened_min','change pref email_on_reopened_minimum_severity for database compabilility'),('pref_bugnote_min','change pref email_on_bugnote_minimum_severity for database compabilility'),('pref_priority_min','change pref email_on_priority_minimum_severity for database compabilility'),('release_51','Mark release for database version 51'),('def_fixed_in_v','add default for fixed in version');