-- 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');

Index: admin/install_functions.php
===================================================================
--- admin/install_functions.php	(revision 5270)
+++ admin/install_functions.php	(working copy)
@@ -52,10 +52,22 @@
 
 			$t_data[$t_project_id][$t_name] = true;
 		}
+		
+		$t_unique_data = array();
+		foreach($t_data as $t_project_id => $t_categories) {
+		    foreach($t_categories as $t_name => $dummy) {
+			$t_unique_name = strtolower($t_name);
+			if (!is_array($t_unique_data[$t_project_id])) {
+    			    $t_unique_data[$t_project_id] = array();
+			}
+			$t_unique_data[$t_project_id][$t_unique_name] = $t_name;
+		    }
+		}
+		
 
 		# In every project, go through all the categories found, and create them and update the bug
-		foreach ( $t_data as $t_project_id => $t_categories ) {
-			foreach ( $t_categories as $t_name => $t_true ) {
+		foreach ( $t_unique_data as $t_project_id => $t_categories ) {
+			foreach ( $t_categories as $t_unique_name => $t_name ) {
 				$query = "INSERT INTO $t_category_table ( name, project_id ) VALUES ( " . db_param(0) . ', ' . db_param(1) . ' )';
 				db_query_bound( $query, array( $t_name, $t_project_id ) );
 				$t_category_id = db_insert_id( $t_category_table );