Views
- State: published
bugzilla-etna.sql
Document Actions
Click here to get the file
File contents
--
-- PostgreSQL database dump
--
SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET SESSION AUTHORIZATION 'postgres';
SET search_path = public, pg_catalog;
--
-- TOC entry 199 (OID 425139)
-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
--
CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
AS '$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAGE c;
--
-- TOC entry 228 (OID 795443471)
-- Name: plpython_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
--
CREATE FUNCTION plpython_call_handler() RETURNS language_handler
AS '$libdir/plpython', 'plpython_call_handler'
LANGUAGE c;
SET SESSION AUTHORIZATION DEFAULT;
--
-- TOC entry 197 (OID 425140)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
--
CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
--
-- TOC entry 198 (OID 795443472)
-- Name: plpythonu; Type: PROCEDURAL LANGUAGE; Schema: public; Owner:
--
CREATE PROCEDURAL LANGUAGE plpythonu HANDLER plpython_call_handler;
SET SESSION AUTHORIZATION 'postgres';
--
-- TOC entry 4 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
SET SESSION AUTHORIZATION 'postgres';
--
-- TOC entry 200 (OID 425142)
-- Name: txtidx_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION txtidx_in(cstring) RETURNS txtidx
AS '$libdir/tsearch', 'txtidx_in'
LANGUAGE c STRICT;
--
-- TOC entry 201 (OID 425143)
-- Name: txtidx_out(txtidx); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION txtidx_out(txtidx) RETURNS cstring
AS '$libdir/tsearch', 'txtidx_out'
LANGUAGE c STRICT;
--
-- TOC entry 5 (OID 425141)
-- Name: txtidx; Type: TYPE; Schema: public; Owner: postgres
--
CREATE TYPE txtidx (
INTERNALLENGTH = variable,
INPUT = txtidx_in,
OUTPUT = txtidx_out,
ALIGNMENT = int4,
STORAGE = extended
);
--
-- TOC entry 202 (OID 425145)
-- Name: txt2txtidx(text); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION txt2txtidx(text) RETURNS txtidx
AS '$libdir/tsearch', 'txt2txtidx'
LANGUAGE c STRICT;
--
-- TOC entry 203 (OID 425146)
-- Name: txtidxsize(txtidx); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION txtidxsize(txtidx) RETURNS integer
AS '$libdir/tsearch', 'txtidxsize'
LANGUAGE c STRICT;
--
-- TOC entry 204 (OID 425148)
-- Name: qtxt_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION qtxt_in(cstring) RETURNS query_txt
AS '$libdir/tsearch', 'qtxt_in'
LANGUAGE c STRICT;
--
-- TOC entry 205 (OID 425149)
-- Name: qtxt_out(query_txt); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION qtxt_out(query_txt) RETURNS cstring
AS '$libdir/tsearch', 'qtxt_out'
LANGUAGE c STRICT;
--
-- TOC entry 6 (OID 425147)
-- Name: query_txt; Type: TYPE; Schema: public; Owner: postgres
--
CREATE TYPE query_txt (
INTERNALLENGTH = variable,
INPUT = qtxt_in,
OUTPUT = qtxt_out,
ALIGNMENT = int4,
STORAGE = plain
);
--
-- TOC entry 206 (OID 425152)
-- Name: mqtxt_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION mqtxt_in(cstring) RETURNS mquery_txt
AS '$libdir/tsearch', 'mqtxt_in'
LANGUAGE c STRICT;
--
-- TOC entry 207 (OID 425153)
-- Name: mqtxt_out(mquery_txt); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION mqtxt_out(mquery_txt) RETURNS cstring
AS '$libdir/tsearch', 'qtxt_out'
LANGUAGE c STRICT;
--
-- TOC entry 7 (OID 425151)
-- Name: mquery_txt; Type: TYPE; Schema: public; Owner: postgres
--
CREATE TYPE mquery_txt (
INTERNALLENGTH = variable,
INPUT = mqtxt_in,
OUTPUT = mqtxt_out,
ALIGNMENT = int4,
STORAGE = plain
);
--
-- TOC entry 208 (OID 425155)
-- Name: querytree(query_txt); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION querytree(query_txt) RETURNS text
AS '$libdir/tsearch', 'querytree'
LANGUAGE c STRICT;
--
-- TOC entry 209 (OID 425156)
-- Name: querytree(mquery_txt); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION querytree(mquery_txt) RETURNS text
AS '$libdir/tsearch', 'querytree'
LANGUAGE c STRICT;
--
-- TOC entry 210 (OID 425157)
-- Name: execqtxt(txtidx, query_txt); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION execqtxt(txtidx, query_txt) RETURNS boolean
AS '$libdir/tsearch', 'execqtxt'
LANGUAGE c STRICT;
--
-- TOC entry 212 (OID 425158)
-- Name: execqtxt(txtidx, mquery_txt); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION execqtxt(txtidx, mquery_txt) RETURNS boolean
AS '$libdir/tsearch', 'execqtxt'
LANGUAGE c STRICT;
--
-- TOC entry 214 (OID 425159)
-- Name: rexecqtxt(query_txt, txtidx); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION rexecqtxt(query_txt, txtidx) RETURNS boolean
AS '$libdir/tsearch', 'rexecqtxt'
LANGUAGE c STRICT;
--
-- TOC entry 216 (OID 425160)
-- Name: rexecqtxt(mquery_txt, txtidx); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION rexecqtxt(mquery_txt, txtidx) RETURNS boolean
AS '$libdir/tsearch', 'rexecqtxt'
LANGUAGE c STRICT;
--
-- TOC entry 230 (OID 425161)
-- Name: @@; Type: OPERATOR; Schema: public; Owner: postgres
--
CREATE OPERATOR @@ (
PROCEDURE = execqtxt,
LEFTARG = txtidx,
RIGHTARG = query_txt,
COMMUTATOR = ~@,
RESTRICT = contsel,
JOIN = contjoinsel
);
--
-- TOC entry 229 (OID 425162)
-- Name: ~@; Type: OPERATOR; Schema: public; Owner: postgres
--
CREATE OPERATOR ~@ (
PROCEDURE = rexecqtxt,
LEFTARG = query_txt,
RIGHTARG = txtidx,
COMMUTATOR = @@,
RESTRICT = contsel,
JOIN = contjoinsel
);
--
-- TOC entry 232 (OID 425163)
-- Name: ##; Type: OPERATOR; Schema: public; Owner: postgres
--
CREATE OPERATOR ## (
PROCEDURE = execqtxt,
LEFTARG = txtidx,
RIGHTARG = mquery_txt,
COMMUTATOR = ~#,
RESTRICT = contsel,
JOIN = contjoinsel
);
--
-- TOC entry 231 (OID 425164)
-- Name: ~#; Type: OPERATOR; Schema: public; Owner: postgres
--
CREATE OPERATOR ~# (
PROCEDURE = rexecqtxt,
LEFTARG = mquery_txt,
RIGHTARG = txtidx,
COMMUTATOR = ##,
RESTRICT = contsel,
JOIN = contjoinsel
);
--
-- TOC entry 218 (OID 425165)
-- Name: tsearch(); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION tsearch() RETURNS "trigger"
AS '$libdir/tsearch', 'tsearch'
LANGUAGE c;
--
-- TOC entry 219 (OID 425167)
-- Name: gtxtidx_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_in(cstring) RETURNS gtxtidx
AS '$libdir/tsearch', 'gtxtidx_in'
LANGUAGE c STRICT;
--
-- TOC entry 220 (OID 425168)
-- Name: gtxtidx_out(gtxtidx); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_out(gtxtidx) RETURNS cstring
AS '$libdir/tsearch', 'gtxtidx_out'
LANGUAGE c STRICT;
--
-- TOC entry 8 (OID 425166)
-- Name: gtxtidx; Type: TYPE; Schema: public; Owner: postgres
--
CREATE TYPE gtxtidx (
INTERNALLENGTH = variable,
INPUT = gtxtidx_in,
OUTPUT = gtxtidx_out,
ALIGNMENT = int4,
STORAGE = plain
);
--
-- TOC entry 221 (OID 425170)
-- Name: gtxtidx_consistent(gtxtidx, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_consistent(gtxtidx, internal, integer) RETURNS boolean
AS '$libdir/tsearch', 'gtxtidx_consistent'
LANGUAGE c;
--
-- TOC entry 222 (OID 425171)
-- Name: gtxtidx_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_compress(internal) RETURNS internal
AS '$libdir/tsearch', 'gtxtidx_compress'
LANGUAGE c;
--
-- TOC entry 223 (OID 425172)
-- Name: gtxtidx_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_decompress(internal) RETURNS internal
AS '$libdir/tsearch', 'gtxtidx_decompress'
LANGUAGE c;
--
-- TOC entry 224 (OID 425173)
-- Name: gtxtidx_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_penalty(internal, internal, internal) RETURNS internal
AS '$libdir/tsearch', 'gtxtidx_penalty'
LANGUAGE c STRICT;
--
-- TOC entry 225 (OID 425174)
-- Name: gtxtidx_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_picksplit(internal, internal) RETURNS internal
AS '$libdir/tsearch', 'gtxtidx_picksplit'
LANGUAGE c;
--
-- TOC entry 226 (OID 425175)
-- Name: gtxtidx_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_union(bytea, internal) RETURNS integer[]
AS '$libdir/tsearch', 'gtxtidx_union'
LANGUAGE c;
--
-- TOC entry 227 (OID 425176)
-- Name: gtxtidx_same(gtxtidx, gtxtidx, internal); Type: FUNCTION; Schema: public; Owner: postgres
--
CREATE FUNCTION gtxtidx_same(gtxtidx, gtxtidx, internal) RETURNS internal
AS '$libdir/tsearch', 'gtxtidx_same'
LANGUAGE c;
--
-- TOC entry 233 (OID 425177)
-- Name: gist_txtidx_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres
--
CREATE OPERATOR CLASS gist_txtidx_ops
DEFAULT FOR TYPE txtidx USING gist AS
STORAGE gtxtidx ,
OPERATOR 1 @@(txtidx,query_txt) RECHECK ,
OPERATOR 2 ##(txtidx,mquery_txt) RECHECK ,
FUNCTION 1 gtxtidx_consistent(gtxtidx,internal,integer) ,
FUNCTION 2 gtxtidx_union(bytea,internal) ,
FUNCTION 3 gtxtidx_compress(internal) ,
FUNCTION 4 gtxtidx_decompress(internal) ,
FUNCTION 5 gtxtidx_penalty(internal,internal,internal) ,
FUNCTION 6 gtxtidx_picksplit(internal,internal) ,
FUNCTION 7 gtxtidx_same(gtxtidx,gtxtidx,internal);
SET SESSION AUTHORIZATION 'bugzilla';
--
-- TOC entry 9 (OID 1736246656)
-- Name: bz_schema; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE bz_schema (
schema_data bytea NOT NULL,
"version" numeric(3,2) NOT NULL
);
--
-- TOC entry 10 (OID 1736246664)
-- Name: attachments; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE attachments (
attach_id serial NOT NULL,
bug_id integer NOT NULL,
creation_ts timestamp(0) without time zone NOT NULL,
description text NOT NULL,
mimetype text NOT NULL,
ispatch smallint,
filename character varying(100) NOT NULL,
thedata bytea NOT NULL,
submitter_id integer NOT NULL,
isobsolete smallint DEFAULT 0 NOT NULL,
isprivate smallint DEFAULT 0 NOT NULL
);
--
-- TOC entry 11 (OID 1736246677)
-- Name: bug_group_map; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE bug_group_map (
bug_id integer NOT NULL,
group_id integer NOT NULL
);
--
-- TOC entry 12 (OID 1736246683)
-- Name: bug_severity; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE bug_severity (
id serial NOT NULL,
value character varying(64) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 13 (OID 1736246694)
-- Name: bug_status; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE bug_status (
id serial NOT NULL,
value character varying(64) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 14 (OID 1736246705)
-- Name: bugs; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE bugs (
bug_id serial NOT NULL,
assigned_to integer NOT NULL,
bug_file_loc text,
bug_severity character varying(64) NOT NULL,
bug_status character varying(64) NOT NULL,
creation_ts timestamp(0) without time zone,
delta_ts timestamp(0) without time zone NOT NULL,
short_desc text NOT NULL,
op_sys character varying(64) NOT NULL,
priority character varying(64) NOT NULL,
product_id integer NOT NULL,
rep_platform character varying(64) NOT NULL,
reporter integer NOT NULL,
"version" character varying(64) NOT NULL,
component_id integer NOT NULL,
resolution character varying(64) DEFAULT ''::character varying NOT NULL,
target_milestone character varying(20) DEFAULT '---'::character varying NOT NULL,
qa_contact integer,
status_whiteboard text DEFAULT ''::text NOT NULL,
votes integer DEFAULT 0 NOT NULL,
keywords text DEFAULT ''::text NOT NULL,
lastdiffed timestamp(0) without time zone,
everconfirmed smallint NOT NULL,
reporter_accessible smallint DEFAULT 1 NOT NULL,
cclist_accessible smallint DEFAULT 1 NOT NULL,
estimated_time numeric(5,2) DEFAULT 0 NOT NULL,
remaining_time numeric(5,2) DEFAULT 0 NOT NULL,
deadline timestamp(0) without time zone,
alias character varying(20)
);
--
-- TOC entry 15 (OID 1736246739)
-- Name: bugs_activity; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE bugs_activity (
bug_id integer NOT NULL,
attach_id integer,
who integer NOT NULL,
bug_when timestamp(0) without time zone NOT NULL,
fieldid integer NOT NULL,
added character varying(255),
removed character varying(255)
);
--
-- TOC entry 16 (OID 1736246746)
-- Name: category_group_map; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE category_group_map (
category_id integer NOT NULL,
group_id integer NOT NULL
);
--
-- TOC entry 17 (OID 1736246750)
-- Name: cc; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE cc (
bug_id integer NOT NULL,
who integer NOT NULL
);
--
-- TOC entry 18 (OID 1736246757)
-- Name: classifications; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE classifications (
id serial NOT NULL,
name character varying(64) NOT NULL,
description text
);
--
-- TOC entry 19 (OID 1736246769)
-- Name: components; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE components (
id serial NOT NULL,
name character varying(64) NOT NULL,
product_id integer NOT NULL,
initialowner integer NOT NULL,
initialqacontact integer,
description text NOT NULL
);
--
-- TOC entry 20 (OID 1736246780)
-- Name: dependencies; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE dependencies (
blocked integer NOT NULL,
dependson integer NOT NULL
);
--
-- TOC entry 21 (OID 1736246785)
-- Name: duplicates; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE duplicates (
dupe_of integer NOT NULL,
dupe integer NOT NULL
);
--
-- TOC entry 22 (OID 1736246790)
-- Name: email_setting; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE email_setting (
user_id integer NOT NULL,
relationship integer NOT NULL,
event integer NOT NULL
);
--
-- TOC entry 23 (OID 1736246796)
-- Name: fielddefs; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE fielddefs (
fieldid serial NOT NULL,
name character varying(64) NOT NULL,
description text NOT NULL,
mailhead smallint DEFAULT 0 NOT NULL,
sortkey integer NOT NULL,
obsolete smallint DEFAULT 0 NOT NULL
);
--
-- TOC entry 24 (OID 1736246809)
-- Name: flagexclusions; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE flagexclusions (
type_id integer NOT NULL,
product_id integer,
component_id integer
);
--
-- TOC entry 25 (OID 1736246813)
-- Name: flaginclusions; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE flaginclusions (
type_id integer NOT NULL,
product_id integer,
component_id integer
);
--
-- TOC entry 26 (OID 1736246817)
-- Name: flags; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE flags (
id integer NOT NULL,
type_id integer NOT NULL,
status character(1) NOT NULL,
bug_id integer NOT NULL,
attach_id integer,
creation_date timestamp(0) without time zone NOT NULL,
modification_date timestamp(0) without time zone,
setter_id integer,
requestee_id integer,
is_active smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 27 (OID 1736246827)
-- Name: flagtypes; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE flagtypes (
id integer NOT NULL,
name character varying(50) NOT NULL,
description text,
cc_list character varying(200),
target_type character(1) DEFAULT 'b'::bpchar NOT NULL,
is_active smallint DEFAULT 1 NOT NULL,
is_requestable smallint DEFAULT 0 NOT NULL,
is_requesteeble smallint DEFAULT 0 NOT NULL,
is_multiplicable smallint DEFAULT 0 NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
grant_group_id integer,
request_group_id integer
);
--
-- TOC entry 28 (OID 1736246841)
-- Name: group_control_map; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE group_control_map (
group_id integer NOT NULL,
product_id integer NOT NULL,
entry smallint NOT NULL,
membercontrol smallint NOT NULL,
othercontrol smallint NOT NULL,
canedit smallint NOT NULL
);
--
-- TOC entry 29 (OID 1736246846)
-- Name: group_group_map; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE group_group_map (
member_id integer NOT NULL,
grantor_id integer NOT NULL,
grant_type integer DEFAULT 0 NOT NULL
);
--
-- TOC entry 30 (OID 1736246853)
-- Name: groups; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE groups (
id serial NOT NULL,
name character varying(255) NOT NULL,
description text NOT NULL,
isbuggroup smallint NOT NULL,
last_changed timestamp(0) without time zone NOT NULL,
userregexp character varying(255) NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 31 (OID 1736246864)
-- Name: keyworddefs; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE keyworddefs (
id integer NOT NULL,
name character varying(64) NOT NULL,
description text
);
--
-- TOC entry 32 (OID 1736246873)
-- Name: keywords; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE keywords (
bug_id integer NOT NULL,
keywordid integer NOT NULL
);
--
-- TOC entry 33 (OID 1736246880)
-- Name: logincookies; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE logincookies (
cookie serial NOT NULL,
userid integer NOT NULL,
ipaddr character varying(40) NOT NULL,
lastused timestamp(0) without time zone NOT NULL
);
--
-- TOC entry 34 (OID 1736246887)
-- Name: longdescs; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE longdescs (
bug_id integer NOT NULL,
who integer NOT NULL,
bug_when timestamp(0) without time zone NOT NULL,
work_time numeric(5,2) DEFAULT 0 NOT NULL,
thetext text,
isprivate smallint DEFAULT 0 NOT NULL,
already_wrapped smallint DEFAULT 0 NOT NULL
);
--
-- TOC entry 35 (OID 1736246900)
-- Name: milestones; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE milestones (
product_id integer NOT NULL,
value character varying(20) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL
);
--
-- TOC entry 36 (OID 1736246905)
-- Name: namedqueries; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE namedqueries (
userid integer NOT NULL,
name character varying(64) NOT NULL,
linkinfooter smallint NOT NULL,
query text NOT NULL
);
--
-- TOC entry 37 (OID 1736246914)
-- Name: op_sys; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE op_sys (
id serial NOT NULL,
value character varying(64) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 38 (OID 1736246926)
-- Name: priority; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE priority (
id serial NOT NULL,
value character varying(64) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 39 (OID 1736246938)
-- Name: products; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE products (
id serial NOT NULL,
name character varying(64) NOT NULL,
classification_id integer DEFAULT 1 NOT NULL,
description text,
milestoneurl character varying(255) NOT NULL,
disallownew smallint NOT NULL,
votesperuser integer NOT NULL,
maxvotesperbug integer DEFAULT 10000 NOT NULL,
votestoconfirm integer NOT NULL,
defaultmilestone character varying(20) DEFAULT '---'::character varying NOT NULL
);
--
-- TOC entry 40 (OID 1736246951)
-- Name: profile_setting; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE profile_setting (
user_id integer NOT NULL,
setting_name character varying(32) NOT NULL,
setting_value character varying(32) NOT NULL
);
--
-- TOC entry 41 (OID 1736246957)
-- Name: profiles; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE profiles (
userid serial NOT NULL,
login_name character varying(255) NOT NULL,
cryptpassword character varying(128),
realname character varying(255),
disabledtext text NOT NULL,
mybugslink smallint DEFAULT 1 NOT NULL,
refreshed_when timestamp(0) without time zone NOT NULL,
extern_id character varying(64)
);
--
-- TOC entry 42 (OID 1736246968)
-- Name: profiles_activity; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE profiles_activity (
userid integer NOT NULL,
who integer NOT NULL,
profiles_when timestamp(0) without time zone NOT NULL,
fieldid integer NOT NULL,
oldvalue character varying(255),
newvalue character varying(255)
);
--
-- TOC entry 43 (OID 1736246976)
-- Name: quips; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE quips (
quipid serial NOT NULL,
userid integer,
quip text NOT NULL,
approved smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 44 (OID 1736246988)
-- Name: rep_platform; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE rep_platform (
id serial NOT NULL,
value character varying(64) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 45 (OID 1736247000)
-- Name: resolution; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE resolution (
id serial NOT NULL,
value character varying(64) NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
isactive smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 46 (OID 1736247012)
-- Name: series; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE series (
series_id serial NOT NULL,
creator integer NOT NULL,
category integer NOT NULL,
subcategory integer NOT NULL,
name character varying(64) NOT NULL,
frequency integer NOT NULL,
last_viewed timestamp(0) without time zone,
query text NOT NULL,
public smallint DEFAULT 0 NOT NULL
);
--
-- TOC entry 47 (OID 1736247025)
-- Name: series_categories; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE series_categories (
id serial NOT NULL,
name character varying(64) NOT NULL
);
--
-- TOC entry 48 (OID 1736247032)
-- Name: series_data; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE series_data (
series_id integer NOT NULL,
series_date timestamp(0) without time zone NOT NULL,
series_value integer NOT NULL
);
--
-- TOC entry 49 (OID 1736247036)
-- Name: setting; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE setting (
name character varying(32) NOT NULL,
default_value character varying(32) NOT NULL,
is_enabled smallint DEFAULT 1 NOT NULL
);
--
-- TOC entry 50 (OID 1736247042)
-- Name: setting_value; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE setting_value (
name character varying(32) NOT NULL,
value character varying(32) NOT NULL,
sortindex integer NOT NULL
);
--
-- TOC entry 51 (OID 1736247047)
-- Name: tokens; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE tokens (
userid integer NOT NULL,
issuedate timestamp(0) without time zone NOT NULL,
token character varying(16) NOT NULL,
tokentype character varying(8) NOT NULL,
eventdata character varying(255)
);
--
-- TOC entry 52 (OID 1736247053)
-- Name: user_group_map; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE user_group_map (
user_id integer NOT NULL,
group_id integer NOT NULL,
isbless smallint DEFAULT 0 NOT NULL,
grant_type integer DEFAULT 0 NOT NULL
);
--
-- TOC entry 53 (OID 1736247059)
-- Name: versions; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE versions (
value character varying(64) NOT NULL,
product_id integer NOT NULL
);
--
-- TOC entry 54 (OID 1736247063)
-- Name: votes; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE votes (
who integer NOT NULL,
bug_id integer NOT NULL,
vote_count integer NOT NULL
);
--
-- TOC entry 55 (OID 1736247068)
-- Name: watch; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE watch (
watcher integer NOT NULL,
watched integer NOT NULL
);
--
-- TOC entry 56 (OID 1736247075)
-- Name: whine_events; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE whine_events (
id serial NOT NULL,
owner_userid integer NOT NULL,
subject character varying(128),
body text
);
--
-- TOC entry 57 (OID 1736247086)
-- Name: whine_queries; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE whine_queries (
id serial NOT NULL,
eventid integer NOT NULL,
query_name character varying(64) DEFAULT ''::character varying NOT NULL,
sortkey integer DEFAULT 0 NOT NULL,
onemailperbug smallint DEFAULT 0 NOT NULL,
title character varying(128) DEFAULT ''::character varying NOT NULL
);
--
-- TOC entry 58 (OID 1736247099)
-- Name: whine_schedules; Type: TABLE; Schema: public; Owner: bugzilla
--
CREATE TABLE whine_schedules (
id serial NOT NULL,
eventid integer NOT NULL,
run_day character varying(32),
run_time character varying(32),
run_next timestamp(0) without time zone,
mailto integer NOT NULL,
mailto_type integer DEFAULT 0 NOT NULL
);
--
-- Data for TOC entry 234 (OID 1736246656)
-- Name: bz_schema; Type: TABLE DATA; Schema: public; Owner: bugzilla
--
COPY bz_schema (schema_data, "version") FROM stdin;
$VAR1 = {\\012 'attachments' => {\\012 'FIELDS' => [\\012 'attach_id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'MEDIUMSERIAL'\\012 },\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'creation_ts',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 },\\012 'description',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'mimetype',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'ispatch',\\012 {\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'filename',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(100)'\\012 },\\012 'thedata',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'LONGBLOB'\\012 },\\012 'submitter_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'isobsolete',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'isprivate',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'attachments_bug_id_idx',\\012 [\\012 'bug_id'\\012 ],\\012 'attachments_creation_ts_idx',\\012 [\\012 'creation_ts'\\012 ],\\012 'attachments_submitter_id_idx',\\012 [\\012 'submitter_id',\\012 'bug_id'\\012 ]\\012 ]\\012 },\\012 'bug_group_map' => {\\012 'FIELDS' => [\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'group_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'bug_group_map_bug_id_idx',\\012 {\\012 'FIELDS' => [\\012 'bug_id',\\012 'group_id'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'bug_group_map_group_id_idx',\\012 [\\012 'group_id'\\012 ]\\012 ]\\012 },\\012 'bug_severity' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'value',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'sortkey',\\012 {\\012 'DEFAULT' => 0,\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'isactive',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'bug_severity_value_idx',\\012 {\\012 'FIELDS' => [\\012 'value'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'bug_severity_sortkey_idx',\\012 [\\012 'sortkey',\\012 'value'\\012 ]\\012 ]\\012 },\\012 'bug_status' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'value',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'sortkey',\\012 {\\012 'DEFAULT' => 0,\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'isactive',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'bug_status_value_idx',\\012 {\\012 'FIELDS' => [\\012 'value'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'bug_status_sortkey_idx',\\012 [\\012 'sortkey',\\012 'value'\\012 ]\\012 ]\\012 },\\012 'bugs' => {\\012 'FIELDS' => [\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'MEDIUMSERIAL'\\012 },\\012 'assigned_to',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'bug_file_loc',\\012 {\\012 'TYPE' => 'TEXT'\\012 },\\012 'bug_severity',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'bug_status',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'creation_ts',\\012 {\\012 'TYPE' => 'DATETIME'\\012 },\\012 'delta_ts',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 },\\012 'short_desc',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'op_sys',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'priority',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'product_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'rep_platform',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'reporter',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'version',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'component_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'resolution',\\012 {\\012 'DEFAULT' => '\\\\'\\\\'',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'target_milestone',\\012 {\\012 'DEFAULT' => '\\\\'---\\\\'',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(20)'\\012 },\\012 'qa_contact',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'status_whiteboard',\\012 {\\012 'DEFAULT' => '\\\\'\\\\'',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'votes',\\012 {\\012 'DEFAULT' => '0',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'keywords',\\012 {\\012 'DEFAULT' => '\\\\'\\\\'',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'lastdiffed',\\012 {\\012 'TYPE' => 'DATETIME'\\012 },\\012 'everconfirmed',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'reporter_accessible',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'cclist_accessible',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'estimated_time',\\012 {\\012 'DEFAULT' => '0',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'decimal(5,2)'\\012 },\\012 'remaining_time',\\012 {\\012 'DEFAULT' => '0',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'decimal(5,2)'\\012 },\\012 'deadline',\\012 {\\012 'TYPE' => 'DATETIME'\\012 },\\012 'alias',\\012 {\\012 'TYPE' => 'varchar(20)'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'bugs_alias_idx',\\012 {\\012 'FIELDS' => [\\012 'alias'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'bugs_assigned_to_idx',\\012 [\\012 'assigned_to'\\012 ],\\012 'bugs_creation_ts_idx',\\012 [\\012 'creation_ts'\\012 ],\\012 'bugs_delta_ts_idx',\\012 [\\012 'delta_ts'\\012 ],\\012 'bugs_bug_severity_idx',\\012 [\\012 'bug_severity'\\012 ],\\012 'bugs_bug_status_idx',\\012 [\\012 'bug_status'\\012 ],\\012 'bugs_op_sys_idx',\\012 [\\012 'op_sys'\\012 ],\\012 'bugs_priority_idx',\\012 [\\012 'priority'\\012 ],\\012 'bugs_product_id_idx',\\012 [\\012 'product_id'\\012 ],\\012 'bugs_reporter_idx',\\012 [\\012 'reporter'\\012 ],\\012 'bugs_version_idx',\\012 [\\012 'version'\\012 ],\\012 'bugs_component_id_idx',\\012 [\\012 'component_id'\\012 ],\\012 'bugs_resolution_idx',\\012 [\\012 'resolution'\\012 ],\\012 'bugs_target_milestone_idx',\\012 [\\012 'target_milestone'\\012 ],\\012 'bugs_qa_contact_idx',\\012 [\\012 'qa_contact'\\012 ],\\012 'bugs_votes_idx',\\012 [\\012 'votes'\\012 ],\\012 'bugs_short_desc_idx',\\012 {\\012 'FIELDS' => [\\012 'short_desc'\\012 ]\\012 }\\012 ]\\012 },\\012 'bugs_activity' => {\\012 'FIELDS' => [\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'attach_id',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'who',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'bug_when',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 },\\012 'fieldid',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'added',\\012 {\\012 'TYPE' => 'TINYTEXT'\\012 },\\012 'removed',\\012 {\\012 'TYPE' => 'TINYTEXT'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'bugs_activity_bug_id_idx',\\012 [\\012 'bug_id'\\012 ],\\012 'bugs_activity_who_idx',\\012 [\\012 'who'\\012 ],\\012 'bugs_activity_bug_when_idx',\\012 [\\012 'bug_when'\\012 ],\\012 'bugs_activity_fieldid_idx',\\012 [\\012 'fieldid'\\012 ]\\012 ]\\012 },\\012 'bz_schema' => {\\012 'FIELDS' => [\\012 'schema_data',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'LONGBLOB'\\012 },\\012 'version',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'decimal(3,2)'\\012 }\\012 ]\\012 },\\012 'category_group_map' => {\\012 'FIELDS' => [\\012 'category_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'group_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'category_group_map_category_id_idx',\\012 {\\012 'FIELDS' => [\\012 'category_id',\\012 'group_id'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'cc' => {\\012 'FIELDS' => [\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'who',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'cc_bug_id_idx',\\012 {\\012 'FIELDS' => [\\012 'bug_id',\\012 'who'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'cc_who_idx',\\012 [\\012 'who'\\012 ]\\012 ]\\012 },\\012 'classifications' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'description',\\012 {\\012 'TYPE' => 'MEDIUMTEXT'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'classifications_name_idx',\\012 {\\012 'FIELDS' => [\\012 'name'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'components' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'product_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'initialowner',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'initialqacontact',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'description',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'components_product_id_idx',\\012 {\\012 'FIELDS' => [\\012 'product_id',\\012 'name'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'components_name_idx',\\012 [\\012 'name'\\012 ]\\012 ]\\012 },\\012 'dependencies' => {\\012 'FIELDS' => [\\012 'blocked',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'dependson',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'dependencies_blocked_idx',\\012 [\\012 'blocked'\\012 ],\\012 'dependencies_dependson_idx',\\012 [\\012 'dependson'\\012 ]\\012 ]\\012 },\\012 'duplicates' => {\\012 'FIELDS' => [\\012 'dupe_of',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'dupe',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'INT3'\\012 }\\012 ]\\012 },\\012 'email_setting' => {\\012 'FIELDS' => [\\012 'user_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'relationship',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT1'\\012 },\\012 'event',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT1'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'email_setting_user_id_idx',\\012 {\\012 'FIELDS' => [\\012 'user_id',\\012 'relationship',\\012 'event'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'fielddefs' => {\\012 'FIELDS' => [\\012 'fieldid',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'MEDIUMSERIAL'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'description',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'mailhead',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'sortkey',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'obsolete',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'fielddefs_name_idx',\\012 {\\012 'FIELDS' => [\\012 'name'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'fielddefs_sortkey_idx',\\012 [\\012 'sortkey'\\012 ]\\012 ]\\012 },\\012 'flagexclusions' => {\\012 'FIELDS' => [\\012 'type_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'product_id',\\012 {\\012 'TYPE' => 'INT2'\\012 },\\012 'component_id',\\012 {\\012 'TYPE' => 'INT2'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'flagexclusions_type_id_idx',\\012 [\\012 'type_id',\\012 'product_id',\\012 'component_id'\\012 ]\\012 ]\\012 },\\012 'flaginclusions' => {\\012 'FIELDS' => [\\012 'type_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'product_id',\\012 {\\012 'TYPE' => 'INT2'\\012 },\\012 'component_id',\\012 {\\012 'TYPE' => 'INT2'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'flaginclusions_type_id_idx',\\012 [\\012 'type_id',\\012 'product_id',\\012 'component_id'\\012 ]\\012 ]\\012 },\\012 'flags' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'type_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'status',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'char(1)'\\012 },\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'attach_id',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'creation_date',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 },\\012 'modification_date',\\012 {\\012 'TYPE' => 'DATETIME'\\012 },\\012 'setter_id',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'requestee_id',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'is_active',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'flags_bug_id_idx',\\012 [\\012 'bug_id',\\012 'attach_id'\\012 ],\\012 'flags_setter_id_idx',\\012 [\\012 'setter_id'\\012 ],\\012 'flags_requestee_id_idx',\\012 [\\012 'requestee_id'\\012 ],\\012 'flags_type_id_idx',\\012 [\\012 'type_id'\\012 ]\\012 ]\\012 },\\012 'flagtypes' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(50)'\\012 },\\012 'description',\\012 {\\012 'TYPE' => 'TEXT'\\012 },\\012 'cc_list',\\012 {\\012 'TYPE' => 'varchar(200)'\\012 },\\012 'target_type',\\012 {\\012 'DEFAULT' => '\\\\'b\\\\'',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'char(1)'\\012 },\\012 'is_active',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'is_requestable',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'is_requesteeble',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'is_multiplicable',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'sortkey',\\012 {\\012 'DEFAULT' => '0',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'grant_group_id',\\012 {\\012 'TYPE' => 'INT3'\\012 },\\012 'request_group_id',\\012 {\\012 'TYPE' => 'INT3'\\012 }\\012 ]\\012 },\\012 'group_control_map' => {\\012 'FIELDS' => [\\012 'group_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'product_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'entry',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'membercontrol',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'othercontrol',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'canedit',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'group_control_map_product_id_idx',\\012 {\\012 'FIELDS' => [\\012 'product_id',\\012 'group_id'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'group_control_map_group_id_idx',\\012 [\\012 'group_id'\\012 ]\\012 ]\\012 },\\012 'group_group_map' => {\\012 'FIELDS' => [\\012 'member_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'grantor_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'grant_type',\\012 {\\012 'DEFAULT' => '0',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT1'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'group_group_map_member_id_idx',\\012 {\\012 'FIELDS' => [\\012 'member_id',\\012 'grantor_id',\\012 'grant_type'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'groups' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'MEDIUMSERIAL'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(255)'\\012 },\\012 'description',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'TEXT'\\012 },\\012 'isbuggroup',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'last_changed',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 },\\012 'userregexp',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'TINYTEXT'\\012 },\\012 'isactive',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'groups_name_idx',\\012 {\\012 'FIELDS' => [\\012 'name'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'keyworddefs' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'description',\\012 {\\012 'TYPE' => 'MEDIUMTEXT'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'keyworddefs_name_idx',\\012 {\\012 'FIELDS' => [\\012 'name'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'keywords' => {\\012 'FIELDS' => [\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'keywordid',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'keywords_bug_id_idx',\\012 {\\012 'FIELDS' => [\\012 'bug_id',\\012 'keywordid'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'keywords_keywordid_idx',\\012 [\\012 'keywordid'\\012 ]\\012 ]\\012 },\\012 'logincookies' => {\\012 'FIELDS' => [\\012 'cookie',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'MEDIUMSERIAL'\\012 },\\012 'userid',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'ipaddr',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(40)'\\012 },\\012 'lastused',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'logincookies_lastused_idx',\\012 [\\012 'lastused'\\012 ]\\012 ]\\012 },\\012 'longdescs' => {\\012 'FIELDS' => [\\012 'bug_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'who',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'bug_when',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'DATETIME'\\012 },\\012 'work_time',\\012 {\\012 'DEFAULT' => '0',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'decimal(5,2)'\\012 },\\012 'thetext',\\012 {\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'isprivate',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'already_wrapped',\\012 {\\012 'DEFAULT' => 'FALSE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'longdescs_bug_id_idx',\\012 [\\012 'bug_id'\\012 ],\\012 'longdescs_who_idx',\\012 [\\012 'who'\\012 ],\\012 'longdescs_bug_when_idx',\\012 [\\012 'bug_when'\\012 ]\\012 ]\\012 },\\012 'milestones' => {\\012 'FIELDS' => [\\012 'product_id',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'value',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(20)'\\012 },\\012 'sortkey',\\012 {\\012 'DEFAULT' => 0,\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'milestones_product_id_idx',\\012 {\\012 'FIELDS' => [\\012 'product_id',\\012 'value'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'namedqueries' => {\\012 'FIELDS' => [\\012 'userid',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT3'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'linkinfooter',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 },\\012 'query',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'MEDIUMTEXT'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'namedqueries_userid_idx',\\012 {\\012 'FIELDS' => [\\012 'userid',\\012 'name'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 }\\012 ]\\012 },\\012 'op_sys' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'value',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'sortkey',\\012 {\\012 'DEFAULT' => 0,\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'isactive',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'op_sys_value_idx',\\012 {\\012 'FIELDS' => [\\012 'value'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'op_sys_sortkey_idx',\\012 [\\012 'sortkey',\\012 'value'\\012 ]\\012 ]\\012 },\\012 'priority' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'value',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'sortkey',\\012 {\\012 'DEFAULT' => 0,\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'isactive',\\012 {\\012 'DEFAULT' => 'TRUE',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'BOOLEAN'\\012 }\\012 ],\\012 'INDEXES' => [\\012 'priority_value_idx',\\012 {\\012 'FIELDS' => [\\012 'value'\\012 ],\\012 'TYPE' => 'UNIQUE'\\012 },\\012 'priority_sortkey_idx',\\012 [\\012 'sortkey',\\012 'value'\\012 ]\\012 ]\\012 },\\012 'products' => {\\012 'FIELDS' => [\\012 'id',\\012 {\\012 'NOTNULL' => 1,\\012 'PRIMARYKEY' => 1,\\012 'TYPE' => 'SMALLSERIAL'\\012 },\\012 'name',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'varchar(64)'\\012 },\\012 'classification_id',\\012 {\\012 'DEFAULT' => '1',\\012 'NOTNULL' => 1,\\012 'TYPE' => 'INT2'\\012 },\\012 'description',\\012 {\\012 'TYPE' => 'MEDIUMTEXT'\\012 },\\012 'milestoneurl',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' => 'TINYTEXT'\\012 },\\012 'disallownew',\\012 {\\012 'NOTNULL' => 1,\\012 'TYPE' =&