PostgreSQL database support

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
softexpert

PostgreSQL database support

Post by softexpert »

Hi,

Your pgsql.sql file is out of date. Here is my updated version.

Code: Select all

--
-- Table structure for table 'mantis_bug_file_table'
--
CREATE TABLE mantis_bug_file_table
(
  "id" serial NOT NULL,
  bug_id int4 NOT NULL DEFAULT 0,
  title varchar(250) NOT NULL DEFAULT ''::character varying,
  description varchar(250) NOT NULL DEFAULT ''::character varying,
  diskfile varchar(250) NOT NULL DEFAULT ''::character varying,
  filename varchar(250) NOT NULL DEFAULT ''::character varying,
  folder varchar(250) NOT NULL DEFAULT ''::character varying,
  filesize int4 NOT NULL DEFAULT 0,
  file_type varchar(250) NOT NULL DEFAULT ''::character varying,
  date_added timestamp NOT NULL DEFAULT now(),
  content text NOT NULL,
  CONSTRAINT mantis_bug_file_table_pkey PRIMARY KEY ("id")
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_bug_file_table'
--


--
-- Table structure for table 'mantis_bug_history_table'
--

CREATE TABLE mantis_bug_history_table
(
  "id" serial NOT NULL,
  user_id int4 NOT NULL DEFAULT 0,
  bug_id int4 NOT NULL DEFAULT 0,
  date_modified timestamp NOT NULL DEFAULT now(),
  field_name varchar(32) NOT NULL DEFAULT ''::character varying,
  old_value varchar(128) NOT NULL DEFAULT ''::character varying,
  new_value varchar(128) NOT NULL DEFAULT ''::character varying,
  "type" int4 NOT NULL DEFAULT 0,
  CONSTRAINT mantis_bug_history_table_pkey PRIMARY KEY ("id"),
  CONSTRAINT fk_mantis_bug_history_table_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

CREATE INDEX mantis_bug_history_table_bug_id
  ON mantis_bug_history_table
  USING btree
  (bug_id);

CREATE INDEX mantis_bug_history_table_bug_id
  ON mantis_bug_history_table
  USING btree
  (bug_id);

--
-- Dumping data for table 'mantis_bug_history_table'
--


--
-- Table structure for table 'mantis_bug_monitor_table'
--

CREATE TABLE mantis_bug_monitor_table
(
  user_id int4 NOT NULL DEFAULT 0,
  bug_id int4 NOT NULL DEFAULT 0,
  CONSTRAINT mantis_bug_monitor_table_pkey PRIMARY KEY (user_id, bug_id)
  CONSTRAINT fk_mantis_bug_monitor_table_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_bug_monitor_table'
--


--
-- Table structure for table 'mantis_bug_relationship_table'
--

CREATE TABLE mantis_bug_relationship_table
(
  "id" serial NOT NULL,
  source_bug_id int4 NOT NULL DEFAULT 0,
  destination_bug_id int4 NOT NULL DEFAULT 0,
  relationship_type int4 NOT NULL DEFAULT 0,
  CONSTRAINT mantis_bug_relationship_table_pkey PRIMARY KEY (id)
) 
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_bug_relationship_table'
--


--
-- Table structure for table 'mantis_bug_table'
--

CREATE TABLE mantis_bug_table
(
  "id" serial NOT NULL,
  project_id int4 NOT NULL DEFAULT 0,
  reporter_id int4 NOT NULL DEFAULT 0,
  handler_id int4 NOT NULL DEFAULT 0,
  duplicate_id int4 NOT NULL DEFAULT 0,
  priority int4 NOT NULL DEFAULT 30,
  severity int4 NOT NULL DEFAULT 50,
  reproducibility int4 NOT NULL DEFAULT 10,
  status int4 NOT NULL DEFAULT 10,
  resolution int4 NOT NULL DEFAULT 10,
  projection int4 NOT NULL DEFAULT 10,
  "category" varchar(64) NOT NULL DEFAULT ''::character varying,
  date_submitted timestamp NOT NULL DEFAULT now(),
  last_updated timestamp NOT NULL DEFAULT now(),
  eta int4 NOT NULL DEFAULT 10,
  bug_text_id int4 NOT NULL DEFAULT 0,
  os varchar(32) NOT NULL DEFAULT ''::character varying,
  os_build varchar(32) NOT NULL DEFAULT ''::character varying,
  platform varchar(32) NOT NULL DEFAULT ''::character varying,
  version varchar(64) NOT NULL DEFAULT ''::character varying,
  fixed_in_version varchar(64) NOT NULL DEFAULT ''::character varying,
  "build" varchar(32) NOT NULL DEFAULT ''::character varying,
  profile_id int4 NOT NULL DEFAULT 0,
  view_state int4 NOT NULL DEFAULT 10,
  "summary" varchar(128) NOT NULL DEFAULT ''::character varying,
  sponsorship_total int8 NOT NULL DEFAULT 0,
  sticky int2 NOT NULL DEFAULT 0,
  CONSTRAINT mantis_bug_table_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;

CREATE INDEX mantis_bug_table_sponsorship_total
  ON mantis_bug_table
  USING btree
  (sponsorship_total);

CREATE INDEX mantis_bug_table_fixed_in_version
  ON mantis_bug_table
  USING btree
  (fixed_in_version);


--
-- Dumping data for table 'mantis_bug_table'
--


--
-- Table structure for table 'mantis_bug_text_table'
--

CREATE TABLE mantis_bug_text_table
(
  "id" serial NOT NULL,
  description text NOT NULL,
  steps_to_reproduce text NOT NULL,
  additional_information text NOT NULL,
  CONSTRAINT mantis_bug_text_table_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_bug_text_table'
--


--
-- Table structure for table 'mantis_bugnote_table'
--

CREATE TABLE mantis_bugnote_table
(
  "id" serial NOT NULL,
  bug_id int4 NOT NULL DEFAULT 0,
  reporter_id int4 NOT NULL DEFAULT 0,
  bugnote_text_id int4 NOT NULL DEFAULT 0,
  view_state int4 NOT NULL DEFAULT 10,
  date_submitted timestamp NOT NULL DEFAULT now(),
  last_modified timestamp NOT NULL DEFAULT now(),
  CONSTRAINT mantis_bugnote_table_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_bugnote_table'
--


--
-- Table structure for table 'mantis_bugnote_text_table'
--

CREATE TABLE mantis_bugnote_text_table
(
  "id" serial NOT NULL,
  note text NOT NULL,
  CONSTRAINT mantis_bugnote_text_table_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_bugnote_text_table'
--

--
-- Table structure for table 'mantis_config_table'
--

CREATE TABLE mantis_config_table (
  config_id varchar(64) NOT NULL default ''::character varying,
  project_id int8 NOT NULL default 0,
  user_id int8 NOT NULL default 0,
  access_reqd int8 default 0,
  "type" int8 default 90,
  value text NOT NULL,
  CONSTRAINT mantis_config_table_pkey PRIMARY KEY (config_id, project_id, user_id),
  CONSTRAINT mantis_config_table_config_id UNIQUE (config_id)
);

--
-- Dumping data for table 'mantis_custom_field_project_table'
--


--
-- Table structure for table 'mantis_custom_field_project_table'
--

CREATE TABLE mantis_custom_field_project_table
(
  field_id int4 NOT NULL DEFAULT 0,
  project_id int4 NOT NULL DEFAULT 0,
  "sequence" int4 NOT NULL DEFAULT 0,
  CONSTRAINT mantis_custom_field_project_table_pkey PRIMARY KEY (field_id, project_id)
) 
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_custom_field_project_table'
--


--
-- Table structure for table 'mantis_custom_field_string_table'
--

CREATE TABLE mantis_custom_field_string_table
(
  field_id int4 NOT NULL DEFAULT 0,
  bug_id int4 NOT NULL DEFAULT 0,
  value varchar(255) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT mantis_custom_field_string_table_pkey PRIMARY KEY (field_id, bug_id)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_custom_field_string_table'
--


--
-- Table structure for table 'mantis_custom_field_table'
--

CREATE TABLE mantis_custom_field_table
(
  "id" serial NOT NULL,
  name varchar(64) NOT NULL DEFAULT ''::character varying,
  "type" int4 NOT NULL DEFAULT 0,
  possible_values varchar(255) NOT NULL DEFAULT ''::character varying,
  default_value varchar(255) NOT NULL DEFAULT ''::character varying,
  valid_regexp varchar(255) NOT NULL DEFAULT ''::character varying,
  access_level_r int4 NOT NULL DEFAULT 0,
  access_level_rw int4 NOT NULL DEFAULT 0,
  length_min int4 NOT NULL DEFAULT 0,
  length_max int4 NOT NULL DEFAULT 0,
  advanced int4 NOT NULL DEFAULT 0,
  require_report int2 NOT NULL default 0,
  require_update int2 NOT NULL default 0,
  display_report int2 NOT NULL default 1,
  display_update int2 NOT NULL default 1,
  require_resolved int2 NOT NULL default 0,
  display_resolved int2 NOT NULL default 0,
  display_closed int2 NOT NULL default 0,
  require_closed int2 NOT NULL default 0,
  CONSTRAINT mantis_custom_field_table_pkey PRIMARY KEY ("id"),
  CONSTRAINT mantis_custom_field_table_name UNIQUE (name)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_custom_field_table'
--

--
-- Table structure for table 'mantis_filters_table'
--

CREATE TABLE mantis_filters_table
(
  "id" serial NOT NULL,
  user_id int8 DEFAULT 0,
  project_id int8 DEFAULT 0,
  is_public int2 DEFAULT null,
  name varchar(64),
  filter_string text,
  CONSTRAINT mantis_filters_table_pkey PRIMARY KEY ("id"),
  CONSTRAINT fk_mantis_filters_table_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITH OIDS;

--
-- Dumping data for table 'mantis_filters_table'
--


--
-- Table structure for table 'mantis_news_table'
--

CREATE TABLE mantis_news_table
(
  "id" serial NOT NULL,
  project_id int4 NOT NULL DEFAULT 0,
  poster_id int4 NOT NULL DEFAULT 0,
  date_posted timestamp NOT NULL DEFAULT now(),
  last_modified timestamp NOT NULL DEFAULT now(),
  view_state int4 NOT NULL DEFAULT 10,
  announcement int2 NOT NULL DEFAULT 0,
  headline varchar(64) NOT NULL DEFAULT ''::character varying,
  "body" text NOT NULL,
  CONSTRAINT mantis_news_table_pkey PRIMARY KEY ("id")
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_news_table'
--


--
-- Table structure for table 'mantis_project_category_table'
--

CREATE TABLE mantis_project_category_table
(
  project_id int4 NOT NULL DEFAULT 0,
  "category" varchar(64) NOT NULL DEFAULT ''::character varying,
  user_id int4 NOT NULL DEFAULT 0,
  CONSTRAINT mantis_project_category_table_pkey PRIMARY KEY (project_id, category),
  CONSTRAINT fk_mantis_project_category_table_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_project_category_table'
--


--
-- Table structure for table 'mantis_project_file_table'
--

CREATE TABLE mantis_project_file_table
(
  id serial NOT NULL,
  project_id int4 NOT NULL DEFAULT 0,
  title varchar(250) NOT NULL DEFAULT ''::character varying,
  description varchar(250) NOT NULL DEFAULT ''::character varying,
  diskfile varchar(250) NOT NULL DEFAULT ''::character varying,
  filename varchar(250) NOT NULL DEFAULT ''::character varying,
  folder varchar(250) NOT NULL DEFAULT ''::character varying,
  filesize int4 NOT NULL DEFAULT 0,
  file_type varchar(250) NOT NULL DEFAULT ''::character varying,
  date_added timestamp NOT NULL DEFAULT now(),
  content text NOT NULL,
  CONSTRAINT mantis_project_file_table_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_project_file_table'
--

--
-- Table structure for table 'mantis_project_hierarchy_table'
--

CREATE TABLE mantis_project_hierarchy_table
(
  child_id int8 DEFAULT 0,
  parent_id int8 DEFAULT 0
)
WITH OIDS;

--
-- Dumping data for table 'mantis_project_hierarchy_table'
--

--
-- Table structure for table 'mantis_project_table'
--

CREATE TABLE mantis_project_table
(
  "id" serial NOT NULL,
  name varchar(128) NOT NULL DEFAULT ''::character varying,
  status int4 NOT NULL DEFAULT 10,
  enabled int4 NOT NULL DEFAULT 1,
  view_state int4 NOT NULL DEFAULT 10,
  access_min int4 NOT NULL DEFAULT 10,
  file_path varchar(250) NOT NULL DEFAULT ''::character varying,
  description text NOT NULL,
  CONSTRAINT mantis_project_table_pkey PRIMARY KEY (id),
  CONSTRAINT mantis_project_table_name UNIQUE (name)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_project_table'
--


--
-- Table structure for table 'mantis_project_user_list_table'
--

CREATE TABLE mantis_project_user_list_table
(
  project_id int4 NOT NULL DEFAULT 0,
  user_id int4 NOT NULL DEFAULT 0,
  access_level int4 NOT NULL DEFAULT 10,
  CONSTRAINT mantis_project_user_list_table_pkey PRIMARY KEY (project_id, user_id),
  CONSTRAINT fk_mantis_project_user_list_table_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;
--
-- Dumping data for table 'mantis_project_user_list_table'
--


--
-- Table structure for table 'mantis_project_version_table'
--

CREATE TABLE mantis_project_version_table
(
  "id" serial NOT NULL,
  project_id int4 NOT NULL DEFAULT 0,
  version varchar(64) NOT NULL DEFAULT ''::character varying,
  date_order timestamp NOT NULL DEFAULT now(),
  description text,
  released int2 NOT NULL DEFAULT 1,
  CONSTRAINT mantis_project_version_table_pkey PRIMARY KEY (project_id, version)
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_project_version_table'
--

--
-- Table structure for table 'mantis_sponsorship_table'
--

CREATE TABLE mantis_sponsorship_table (
  "id" serial NOT NULL,
  bug_id int8 NOT NULL default 0,
  user_id int8 NOT NULL default 0,
  amount int8 NOT NULL default 0,
  logo varchar(128) NOT NULL default ''::character varying,
  url varchar(128) NOT NULL default ''::character varying,
  paid int2 NOT NULL default 0,
  date_submitted timestamp NOT NULL default now(),
  last_updated timestamp NOT NULL default now(),
  CONSTRAINT mantis_sponsorship_table_pkey PRIMARY KEY ("id"),
  CONSTRAINT fk_mantis_sponsorship_table_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

CREATE INDEX mantis_sponsorship_table_bug_id
  ON mantis_sponsorship_table
  USING btree
  (bug_id);

CREATE INDEX mantis_sponsorship_table_user_id
  ON mantis_sponsorship_table
  USING btree
  (user_id);

--
-- Dumping data for table 'mantis_sponsorship_table'
--


--
-- Table structure for table 'mantis_tokens_table'
--

CREATE TABLE mantis_tokens_table (
  "id" serial NOT NULL,
  owner int8 NOT NULL default '0',
  "type" int8 NOT NULL default '0',
  "timestamp" timestamp NOT NULL default now(),
  expiry timestamp  DEFAULT null,
  value text NOT NULL,
  CONSTRAINT mantis_tokens_table_pkey PRIMARY KEY ("id")
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_tokens_table'
--


--
-- Table structure for table 'mantis_upgrade_table'
--

CREATE TABLE mantis_upgrade_table
(
  upgrade_id varchar(20) NOT NULL DEFAULT ''::character varying,
  description varchar(255) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT mantis_upgrade_table_pkey PRIMARY KEY (upgrade_id)
) 
WITHOUT OIDS;
--
-- Dumping data for table 'mantis_upgrade_table'
--

INSERT INTO mantis_upgrade_table VALUES ('0.13-1','Add mantis_project_table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-2','Insert default project into mantis_project_table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-3','Add mantis_project_category_table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-4','Add mantis_project_version_table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-5','Add project_id column to mantis_bug_table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-6','Change category column in mantis_bug_table to varchar');
INSERT INTO mantis_upgrade_table VALUES ('0.13-7','Change version column in mantis_bug_table to varchar');
INSERT INTO mantis_upgrade_table VALUES ('0.13-8','Set project_id to \"0000001\" for all bugs');
INSERT INTO mantis_upgrade_table VALUES ('0.13-9','Add project_id column news table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-10','Set project_id to \"0000001\" for all news postings');
INSERT INTO mantis_upgrade_table VALUES ('0.13-11','Added login count to user table');
INSERT INTO mantis_upgrade_table VALUES ('0.13-12','Add manager to access_levels');
INSERT INTO mantis_upgrade_table VALUES ('0.13-13','Make username unique');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-0','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-1','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-2','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-3','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-4','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-5','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-6','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-7','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-8','');
INSERT INTO mantis_upgrade_table VALUES ('0.14a-9','');
INSERT INTO mantis_upgrade_table VALUES ('0.14-0','Change some of the TIMESTAMP fields to timestamp');
INSERT INTO mantis_upgrade_table VALUES ('0.14-1','Change some of the TIMESTAMP fields to timestamp');
INSERT INTO mantis_upgrade_table VALUES ('0.14-2','Change some of the TIMESTAMP fields to timestamp');
INSERT INTO mantis_upgrade_table VALUES ('0.14-3','Change some of the TIMESTAMP fields to timestamp');
INSERT INTO mantis_upgrade_table VALUES ('0.14-4','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-5','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-6','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-7','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-8','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-9','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-10','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-11','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-12','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-13','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-14','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-15','int Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-16','Change CHAR(3) to int');
INSERT INTO mantis_upgrade_table VALUES ('0.14-17','Change CHAR(3) to int');
INSERT INTO mantis_upgrade_table VALUES ('0.14-18','Change CHAR(3) to int');
INSERT INTO mantis_upgrade_table VALUES ('0.14-19','Change CHAR(3) to int');
INSERT INTO mantis_upgrade_table VALUES ('0.14-20','Change CHAR(3) to int');
INSERT INTO mantis_upgrade_table VALUES ('0.14-21','Change CHAR(3) to int');
INSERT INTO mantis_upgrade_table VALUES ('0.14-22','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-23','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-24','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-25','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-26','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-27','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-28','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-29','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-30','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-31','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-32','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-33','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-34','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-35','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-36','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-37','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-38','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-39','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-40','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-41','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-42','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-43','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-44','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-45','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-46','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-47','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-48','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-49','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-50','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-51','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-52','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-53','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-54','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-55','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-56','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-57','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-58','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-59','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-60','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-61','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-62','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-63','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-64','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-65','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-66','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-67','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-68','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-69','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-70','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-71','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-72','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-73','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-74','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-75','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-76','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-77','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-78','ENUM Updates (Before ALTERation)');
INSERT INTO mantis_upgrade_table VALUES ('0.14-79','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-80','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-81','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-82','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-83','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-84','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-85','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-86','Change ENUM to INT');
INSERT INTO mantis_upgrade_table VALUES ('0.14-87','Update dates to be legal');
INSERT INTO mantis_upgrade_table VALUES ('0.14-88','Update dates to be legal');
INSERT INTO mantis_upgrade_table VALUES ('0.14-89','Update dates to be legal');
INSERT INTO mantis_upgrade_table VALUES ('0.14-90','Shorten cookie string to 64 characters');
INSERT INTO mantis_upgrade_table VALUES ('0.14-91','Add file_path to projects');
INSERT INTO mantis_upgrade_table VALUES ('0.14-92','Add access_min to projects');
INSERT INTO mantis_upgrade_table VALUES ('0.14-93','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-94','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-95','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-96','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-97','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-98','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-99','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-100','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-101','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-102','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-103','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-104','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-105','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-106','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-107','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-108','Add new user prefs');
INSERT INTO mantis_upgrade_table VALUES ('0.14-109','Make new project level user access table');
INSERT INTO mantis_upgrade_table VALUES ('0.14-110','Make new project file table');
INSERT INTO mantis_upgrade_table VALUES ('0.14-111','Make new bug file table');
INSERT INTO mantis_upgrade_table VALUES ('0.14-112','more varchar to enum conversions');
INSERT INTO mantis_upgrade_table VALUES ('0.14-113','more varchar to enum conversions');
INSERT INTO mantis_upgrade_table VALUES ('0.14-114','Need this entry for the project listing to work');
INSERT INTO mantis_upgrade_table VALUES ('0.14-115','Add ordering field for versions');
INSERT INTO mantis_upgrade_table VALUES ('0.14-116','Make the cookie string unique');
INSERT INTO mantis_upgrade_table VALUES ('0.15-1','Add file type column to bug file table');
INSERT INTO mantis_upgrade_table VALUES ('0.15-2','Add file type column to project file table');
INSERT INTO mantis_upgrade_table VALUES ('0.15-3','');
INSERT INTO mantis_upgrade_table VALUES ('0.15-4','');
INSERT INTO mantis_upgrade_table VALUES ('0.15-5','');
INSERT INTO mantis_upgrade_table VALUES ('0.15-6','');
INSERT INTO mantis_upgrade_table VALUES ('0.15-7','');
INSERT INTO mantis_upgrade_table VALUES ('0.15-8','Create bug history table');
INSERT INTO mantis_upgrade_table VALUES ('0.15-9','Add order field to project version table');
INSERT INTO mantis_upgrade_table VALUES ('0.16-1','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-2','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-3','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-4','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-5','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-6','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-7','Add view_state to bug table');
INSERT INTO mantis_upgrade_table VALUES ('0.16-8','Add view_state to bugnote table');
INSERT INTO mantis_upgrade_table VALUES ('0.16-9','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-10','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-11','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-12','');
INSERT INTO mantis_upgrade_table VALUES ('0.16-13','Add project_id to user pref table');
INSERT INTO mantis_upgrade_table VALUES ('0.16-14','Create bug relationship table');
INSERT INTO mantis_upgrade_table VALUES ('0.16-15','Create bug monitor table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-1','Printing Preference Table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-2','Bug history');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-3','Auto-assigning of bugs for a default user per category');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-4','Private news support');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-5','Allow news items to stay at the top');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-6','relationship support');
INSERT INTO mantis_upgrade_table VALUES ('0.17-custom-field-1','Add mantis_custom_field_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-custom-field-2','Add mantis_custom_field_string_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-custom-field-3','Add mantis_custom_field_project_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-7','Drop mantis_project_customization_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-8','Drop votes column of mantis_bug_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-9','Add primary key on mantis_project_version_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-10','Add primary key on mantis_project_user_list_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-11','Add primary key on mantis_project_category_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-12','Add primary key on mantis_bug_monitor_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-13','Remove zerofill on mantis_bug_file_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-14','Remove zerofill on mantis_bug_file_table.bug_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-15','Remove zerofill on mantis_bug_history_table.user_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-16','Remove zerofill on mantis_bug_history_table.bug_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-17','Remove zerofill on mantis_bug_monitor_table.user_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-18','Remove zerofill on mantis_bug_relationship_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-19','Remove zerofill on mantis_bug_relationship_table.source_bug_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-20','Remove zerofill on mantis_bug_relationship_table.destination_bug_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-21','Remove zerofill on mantis_bug_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-22','Remove zerofill on mantis_bug_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-23','Remove zerofill on mantis_bug_table.reporter_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-24','Remove zerofill on mantis_bug_table.handler_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-25','Remove zerofill on mantis_bug_table.duplicate_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-26','Remove zerofill on mantis_bug_table.bug_text_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-27','Remove zerofill on mantis_bug_table.profile_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-28','Remove zerofill on mantis_bug_text_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-29','Remove zerofill on mantis_bugnote_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-30','Remove zerofill on mantis_bugnote_table.bug_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-31','Remove zerofill on mantis_bugnote_table.reporter_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-32','Remove zerofill on mantis_bugnote_table.bugnote_text_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-33','Remove zerofill on mantis_bugnote_text_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-34','Remove zerofill on mantis_news_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-35','Remove zerofill on mantis_news_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-36','Remove zerofill on mantis_news_table.poster_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-37','Remove zerofill on mantis_project_category_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-38','Remove zerofill on mantis_project_file_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-39','Remove zerofill on mantis_project_file_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-40','Remove zerofill on mantis_project_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-41','Remove zerofill on mantis_project_user_list_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-42','Remove zerofill on mantis_project_user_list_table.user_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-43','Remove zerofill on mantis_project_version_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-44','Remove zerofill on mantis_user_pref_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-45','Remove zerofill on mantis_user_pref_table.user_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-46','Remove zerofill on mantis_user_pref_table.project_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-47','Remove zerofill on mantis_user_pref_table.default_profile');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-48','Remove zerofill on mantis_user_pref_table.default_project');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-49','Remove zerofill on mantis_user_print_pref_table.user_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-50','Remove zerofill on mantis_user_profile_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-51','Remove zerofill on mantis_user_profile_table.user_id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-jf-52','Remove zerofill on mantis_user_table.id');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-1','Set default for mantis_bug_file_table.date_added (incorrect for 0.15 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-2','Correct values for mantis_bug_file_table.date_added (incorrect for 0.15 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-3','Set default for mantis_project_file_table.date_added (incorrect for 0.15 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-4','Correct values for mantis_project_file_table.date_added (incorrect for 0.15 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-5','Set default for mantis_bug_table.build (incorrect for 0.16 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-6','Correct values for mantis_bug_table.build (incorrect for 0.16 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-7','Set default for mantis_user_table.date_created (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-8','Correct values for mantis_user_table.date_created (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-9','Set default for mantis_project_table.enabled to 1 (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-10','Set default for mantis_news_table.date_posted (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-11','Correct values for mantis_news_table.date_posted (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-12','Set default for mantis_bug_table.date_submitted (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-13','Correct values for mantis_bug_table.date_submitted (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-14','Set default for mantis_bugnote_table.date_submitted (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-15','Correct values for mantis_bugnote_table.date_submitted (incorrect for < 0.17 installs)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-16','Add unique index to cookie_string if it is not already there (incorrect for > 0.14)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-17','Remove mantis_project_version_table.ver_order (incorrect for < 0.15)');
INSERT INTO mantis_upgrade_table VALUES ('0.17-compat-18','Remove users from project 0');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-1','Fix double escaped data in mantis_bug_file_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-2','Fix double escaped data in mantis_bug_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-3','Fix double escaped data in mantis_bug_text_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-4','Fix double escaped data in mantis_bugnote_text_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-5','Fix double escaped data in mantis_news_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-6','Fix double escaped data in mantis_project_file_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-7','Fix double escaped data in mantis_project_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-8','Fix double escaped data in mantis_user_profile_table');
INSERT INTO mantis_upgrade_table VALUES ('0.17-vb-19','Add id field to bug history table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-9','Fix double escaped data in mantis_bug_history_table');
INSERT INTO mantis_upgrade_table VALUES ('escaping-fix-10','Remove history entries where type=0 and the old value = new value.  These existed because of escaping errors');
INSERT INTO mantis_upgrade_table VALUES ('0.18-vb-1','Add index on bug_id field in mantis_bug_file_table.');
INSERT INTO mantis_upgrade_table VALUES ('filtersdb-1', 'Add mantis_filters_table');
INSERT INTO mantis_upgrade_table VALUES ('emailsevs-1', 'Add the necessary columns for email severity filtering');
INSERT INTO mantis_upgrade_table VALUES ('sponsorship-1', 'Add sponsorships table');
INSERT INTO mantis_upgrade_table VALUES ('sponsorship-2', 'Add sponsorship_total to bug table');
INSERT INTO mantis_upgrade_table VALUES ('sponsorship-3', 'Add an index on sponsorship_total in bug table');
INSERT INTO mantis_upgrade_table VALUES ('fixed_in_version-1', 'Add fixed_in_version field to bug table.');
INSERT INTO mantis_upgrade_table VALUES ('fixed_in_version-2', 'Add index on fixed_in_version field in bug table.');
INSERT INTO mantis_upgrade_table VALUES ('user_realname', 'Add real name to user information.');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-1', 'Allow custom fields to be set/required for resolve/close/report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-2', 'Allow custom fields to be set/required for resolve/close/report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-3', 'Allow custom fields to be set/required for resolve/close/report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-4', 'Allow custom fields to be set/required for resolve/close/report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-5', 'Allow custom fields to be set/required for resolve/close/report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-6', 'Allow custom fields to be set/required for resolve/close/report/update');
INSERT INTO mantis_upgrade_table VALUES ('version_remove_pk', 'Remove project_id+version primary key');
INSERT INTO mantis_upgrade_table VALUES ('version_add_version_', 'Add id to version table and use it as primary key');
INSERT INTO mantis_upgrade_table VALUES ('version_add_project_', 'Add a unique index for project_id + version combination.');
INSERT INTO mantis_upgrade_table VALUES ('version_add_descript', 'Add description field to versions.');
INSERT INTO mantis_upgrade_table VALUES ('version_add_released', 'Add released flag to determine whether the version was released or still a future release.');
INSERT INTO mantis_upgrade_table VALUES ('relationship-1', 'Add index on source_bug_id field in mantis_bug_relationship_table');
INSERT INTO mantis_upgrade_table VALUES ('relationship-2', 'Add index on destination_bug_id field in mantis_bug_relationship_table');
INSERT INTO mantis_upgrade_table VALUES ('relationship-3', 'Translate duplicate id information in a new duplicate relationship');
INSERT INTO mantis_upgrade_table VALUES ('relationship-4', 'Fix swapped value in duplicate relationship');
INSERT INTO mantis_upgrade_table VALUES ('cat_user_id_unsigned', 'Change the user_id in mantis_project_category_table to unsigned int.');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-7', 'Allow custom fields to be hidden/displayed for report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-8', 'Allow custom fields to be hidden/displayed for report/update');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-9', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-10', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-11', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-12', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-13', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-14', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-15', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-16', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-17', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-18', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-19', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('custom_fields-20', 'Rename Column');
INSERT INTO mantis_upgrade_table VALUES ('lost-password', 'Add the necessary columns for managing lost passwords');
INSERT INTO mantis_upgrade_table VALUES ('delete-admin-over', 'Delete any project level access overrides for admin users');
INSERT INTO mantis_upgrade_table VALUES ('0.18-bugnote-limit', 'Add email_bugnote_limit to user preference table');
INSERT INTO mantis_upgrade_table VALUES ('0.18-bugnote-order', 'Add bugnote_order to user preference table');
INSERT INTO mantis_upgrade_table VALUES ('cb_ml_upgrade', 'Upgrade custom field types (checkbox, list, multilist) to support advanced filtering');
INSERT INTO mantis_upgrade_table VALUES ('bugnote-type', 'Add note type column to bugnote');
INSERT INTO mantis_upgrade_table VALUES ('bugnote-attr', 'Add note_attr column to bugnote');
INSERT INTO mantis_upgrade_table VALUES ('tokensdb-1', 'Add mantis_tokens_table');
INSERT INTO mantis_upgrade_table VALUES ('sticky-issues', 'Add sticky column to bug table');
INSERT INTO mantis_upgrade_table VALUES ('project-hierarchy', 'Add project hierarchy table');
INSERT INTO mantis_upgrade_table VALUES ('configdb-1', 'Add mantis_config_table');
INSERT INTO mantis_upgrade_table VALUES ('field_shorten-1', 'shorten field names: lost_password_in_progress_count');
INSERT INTO mantis_upgrade_table VALUES ('field_naming-1', 'DBMS compatibility: access is a reserved word');
INSERT INTO mantis_upgrade_table VALUES ('configdb-un', 'Drop mantis_config_table unique key');
INSERT INTO mantis_upgrade_table VALUES ('configdb-pk', 'Add mantis_config_table primary key');
INSERT INTO mantis_upgrade_table VALUES ('config-key1', 'make mantis_config_table keys not null');
INSERT INTO mantis_upgrade_table VALUES ('config-key2', 'make mantis_config_table keys not null');
INSERT INTO mantis_upgrade_table VALUES ('note_bug_id_index', 'Add index on bug_id in bugnotes table');


--
-- Table structure for table 'mantis_user_pref_table'
--

CREATE TABLE mantis_user_pref_table
(
  "id" serial NOT NULL,
  user_id int4 NOT NULL DEFAULT 0,
  project_id int4 NOT NULL DEFAULT 0,
  default_profile int4 NOT NULL DEFAULT 0,
  default_project int4 NOT NULL DEFAULT 0,
  advanced_report int4 NOT NULL DEFAULT 0,
  advanced_view int4 NOT NULL DEFAULT 0,
  advanced_update int4 NOT NULL DEFAULT 0,
  refresh_delay int4 NOT NULL DEFAULT 0,
  redirect_delay int4 NOT NULL DEFAULT 0,
  bugnote_order varchar(4) DEFAULT 'ASC'::character varying,
  email_on_new int2 NOT NULL DEFAULT 0,
  email_on_assigned int2 NOT NULL DEFAULT 0,
  email_on_feedback int2 NOT NULL DEFAULT 0,
  email_on_resolved int2 NOT NULL DEFAULT 0,
  email_on_closed int2 NOT NULL DEFAULT 0,
  email_on_reopened int2 NOT NULL DEFAULT 0,
  email_on_bugnote int2 NOT NULL DEFAULT 0,
  email_on_status int2 NOT NULL DEFAULT 0,
  email_on_priority int4 NOT NULL DEFAULT 0,
  email_on_priority_minimum_severity int2 DEFAULT 10,
  email_on_status_minimum_severity int2 DEFAULT 10,
  email_on_bugnote_minimum_severity int2 DEFAULT 10,
  email_on_reopened_minimum_severity int2 DEFAULT 10,
  email_on_closed_minimum_severity int2 DEFAULT 10,
  email_on_resolved_minimum_severity int2 DEFAULT 10,
  email_on_feedback_minimum_severity int2 DEFAULT 10,
  email_on_assigned_minimum_severity int2 DEFAULT 10,
  email_on_new_minimum_severity int2 DEFAULT 10,
  email_bugnote_limit int2 DEFAULT 0,
  "language" varchar(32) NOT NULL DEFAULT 'english'::character varying,
  CONSTRAINT mantis_user_pref_table_pkey PRIMARY KEY (id),
  CONSTRAINT fk_mantis_user_pref_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_user_pref_table'
--


--
-- Table structure for table 'mantis_user_print_pref_table'
--

CREATE TABLE mantis_user_print_pref_table
(
  user_id int4 NOT NULL DEFAULT 0,
  print_pref varchar(27) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT mantis_user_print_pref_table_pkey PRIMARY KEY (user_id),
  CONSTRAINT fk_mantis_user_print_pref_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_user_print_pref_table'
--


--
-- Table structure for table 'mantis_user_profile_table'
--

CREATE TABLE mantis_user_profile_table
(
  "id" serial NOT NULL,
  user_id int4 NOT NULL DEFAULT 0,
  platform varchar(32) NOT NULL DEFAULT ''::character varying,
  os varchar(32) NOT NULL DEFAULT ''::character varying,
  os_build varchar(32) NOT NULL DEFAULT ''::character varying,
  description text NOT NULL,
  CONSTRAINT mantis_user_profile_table_pkey PRIMARY KEY (id),
  CONSTRAINT fk_mantis_user_profile_mantis_user FOREIGN KEY (user_id) REFERENCES mantis_user_table (id) ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITHOUT OIDS;

--
-- Dumping data for table 'mantis_user_profile_table'
--


--
-- Table structure for table 'mantis_user_table'
--

CREATE TABLE mantis_user_table
(
  "id" serial NOT NULL,
  username varchar(32) NOT NULL DEFAULT ''::character varying,
  realname varchar(64),
  email varchar(64) NOT NULL DEFAULT ''::character varying,
  "password" varchar(32) NOT NULL DEFAULT ''::character varying,
  date_created timestamp NOT NULL DEFAULT now(),
  last_visit timestamp NOT NULL DEFAULT now(),
  enabled int4 NOT NULL DEFAULT 1,
  protected int4 NOT NULL DEFAULT 0,
  access_level int4 NOT NULL DEFAULT 10,
  login_count int4 NOT NULL DEFAULT 0,
  cookie_string varchar(64) NOT NULL DEFAULT ''::character varying,
  failed_login_count int4 DEFAULT 0,
  lost_password_request_count int4 DEFAULT 0,
  CONSTRAINT mantis_user_table_pkey PRIMARY KEY (id),
  CONSTRAINT mantis_user_table_cookie_string UNIQUE (cookie_string),
  CONSTRAINT mantis_user_table_username UNIQUE (username)
) 
WITHOUT OIDS;
--
-- Dumping data for table 'mantis_user_table'
--

INSERT INTO mantis_user_table VALUES (1,'administrator','administrator','admin@email','63a9f0ea7bb98050796b649e85481845',now(),now(),1,1,90,3,'asdjkljkl',0,0);
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:

Post by thraxisp »

Could you please attach this file to an issue in http://bugs.mantisbt.org/ ?

We are working on a common installer using ADODB to eliminate the sql files. This is covered in #5289.
Post Reply