--
-- PostgreSQL database dump
--

-- Started on 2008-05-27 10:50:56 CEST

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 1605 (class 0 OID 0)
-- Dependencies: 1604
-- Name: DATABASE bacula; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON DATABASE bacula IS 'Catálogo de copias de seguridad';


--
-- TOC entry 1606 (class 0 OID 0)
-- Dependencies: 2
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- TOC entry 1208 (class 1259 OID 40303135)
-- Dependencies: 1539 2
-- Name: basefiles; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE basefiles (
    baseid serial NOT NULL,
    jobid integer NOT NULL,
    fileid integer NOT NULL,
    fileindex integer,
    basejobid integer
);


ALTER TABLE public.basefiles OWNER TO bacula;

--
-- TOC entry 1210 (class 1259 OID 40303144)
-- Dependencies: 2
-- Name: cdimages; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE cdimages (
    mediaid integer NOT NULL,
    lastburn timestamp without time zone NOT NULL
);


ALTER TABLE public.cdimages OWNER TO bacula;

--
-- TOC entry 1205 (class 1259 OID 40303116)
-- Dependencies: 1537 1538 2
-- Name: client; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE client (
    clientid serial NOT NULL,
    name text NOT NULL,
    uname text NOT NULL,
    autoprune smallint DEFAULT 0,
    fileretention bigint NOT NULL,
    jobretention bigint NOT NULL
);


ALTER TABLE public.client OWNER TO bacula;

--
-- TOC entry 1206 (class 1259 OID 40303126)
-- Dependencies: 2
-- Name: counters; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE counters (
    counter text NOT NULL,
    "minvalue" integer,
    "maxvalue" integer,
    currentvalue integer,
    wrapcounter text NOT NULL
);


ALTER TABLE public.counters OWNER TO bacula;

--
-- TOC entry 1201 (class 1259 OID 40303064)
-- Dependencies: 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 2
-- Name: device; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE device (
    deviceid serial NOT NULL,
    name text NOT NULL,
    mediatypeid integer NOT NULL,
    storageid integer NOT NULL,
    devmounts integer DEFAULT 0 NOT NULL,
    devreadbytes bigint DEFAULT 0 NOT NULL,
    devwritebytes bigint DEFAULT 0 NOT NULL,
    devreadbytessincecleaning bigint DEFAULT 0 NOT NULL,
    devwritebytessincecleaning bigint DEFAULT 0 NOT NULL,
    devreadtime bigint DEFAULT 0 NOT NULL,
    devwritetime bigint DEFAULT 0 NOT NULL,
    devreadtimesincecleaning bigint DEFAULT 0 NOT NULL,
    devwritetimesincecleaning bigint DEFAULT 0 NOT NULL,
    cleaningdate timestamp without time zone,
    cleaningperiod bigint DEFAULT 0 NOT NULL
);


ALTER TABLE public.device OWNER TO bacula;

--
-- TOC entry 1187 (class 1259 OID 40302942)
-- Dependencies: 1451 1452 1453 2
-- Name: file; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE file (
    fileid serial NOT NULL,
    fileindex integer DEFAULT 0 NOT NULL,
    jobid integer NOT NULL,
    pathid integer NOT NULL,
    filenameid integer NOT NULL,
    markid integer DEFAULT 0 NOT NULL,
    lstat text NOT NULL,
    md5 text NOT NULL
);


ALTER TABLE public.file OWNER TO bacula;

--
-- TOC entry 1183 (class 1259 OID 40302920)
-- Dependencies: 1449 2
-- Name: filename; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE filename (
    filenameid serial NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.filename OWNER TO bacula;

--
-- TOC entry 1191 (class 1259 OID 40302978)
-- Dependencies: 1463 2
-- Name: fileset; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE fileset (
    filesetid serial NOT NULL,
    fileset text NOT NULL,
    md5 text NOT NULL,
    createtime timestamp without time zone NOT NULL
);


ALTER TABLE public.fileset OWNER TO bacula;

--
-- TOC entry 1189 (class 1259 OID 40302959)
-- Dependencies: 1454 1455 1456 1457 1458 1459 1460 1461 1462 2
-- Name: job; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE job (
    jobid serial NOT NULL,
    job text NOT NULL,
    name text NOT NULL,
    "type" character(1) NOT NULL,
    "level" character(1) NOT NULL,
    clientid integer,
    jobstatus character(1) NOT NULL,
    schedtime timestamp without time zone NOT NULL,
    starttime timestamp without time zone,
    endtime timestamp without time zone,
    jobtdate bigint NOT NULL,
    volsessionid integer DEFAULT 0 NOT NULL,
    volsessiontime integer DEFAULT 0 NOT NULL,
    jobfiles integer DEFAULT 0 NOT NULL,
    jobbytes bigint DEFAULT 0 NOT NULL,
    joberrors integer DEFAULT 0 NOT NULL,
    jobmissingfiles integer DEFAULT 0 NOT NULL,
    poolid integer,
    filesetid integer,
    purgedfiles smallint DEFAULT 0 NOT NULL,
    hasbase smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.job OWNER TO bacula;

--
-- TOC entry 1193 (class 1259 OID 40302989)
-- Dependencies: 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 2
-- Name: jobmedia; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE jobmedia (
    jobmediaid serial NOT NULL,
    jobid integer NOT NULL,
    mediaid integer NOT NULL,
    firstindex integer DEFAULT 0 NOT NULL,
    lastindex integer DEFAULT 0 NOT NULL,
    startfile integer DEFAULT 0 NOT NULL,
    endfile integer DEFAULT 0 NOT NULL,
    startblock bigint DEFAULT 0 NOT NULL,
    endblock bigint DEFAULT 0 NOT NULL,
    volindex integer DEFAULT 0 NOT NULL,
    "copy" integer DEFAULT 0 NOT NULL,
    stripe integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.jobmedia OWNER TO bacula;

--
-- TOC entry 1195 (class 1259 OID 40303006)
-- Dependencies: 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 2
-- Name: media; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE media (
    mediaid serial NOT NULL,
    volumename text NOT NULL,
    slot integer DEFAULT 0 NOT NULL,
    poolid integer NOT NULL,
    mediatype text NOT NULL,
    labeltype integer DEFAULT 0 NOT NULL,
    firstwritten timestamp without time zone,
    lastwritten timestamp without time zone,
    labeldate timestamp without time zone,
    voljobs integer DEFAULT 0 NOT NULL,
    volfiles integer DEFAULT 0 NOT NULL,
    volblocks integer DEFAULT 0 NOT NULL,
    volmounts integer DEFAULT 0 NOT NULL,
    volbytes bigint DEFAULT 0 NOT NULL,
    volparts integer DEFAULT 0 NOT NULL,
    volerrors integer DEFAULT 0 NOT NULL,
    volwrites integer DEFAULT 0 NOT NULL,
    volcapacitybytes bigint DEFAULT 0 NOT NULL,
    volstatus text NOT NULL,
    recycle smallint DEFAULT 0 NOT NULL,
    volretention bigint DEFAULT 0 NOT NULL,
    voluseduration bigint DEFAULT 0 NOT NULL,
    maxvoljobs integer DEFAULT 0 NOT NULL,
    maxvolfiles integer DEFAULT 0 NOT NULL,
    maxvolbytes bigint DEFAULT 0 NOT NULL,
    inchanger smallint DEFAULT 0 NOT NULL,
    storageid integer DEFAULT 0,
    mediaaddressing smallint DEFAULT 0 NOT NULL,
    volreadtime bigint DEFAULT 0 NOT NULL,
    volwritetime bigint DEFAULT 0 NOT NULL,
    endfile integer DEFAULT 0 NOT NULL,
    endblock bigint DEFAULT 0 NOT NULL,
    CONSTRAINT media_volstatus CHECK (((((((((((((volstatus = 'Full'::text) OR (volstatus = 'Archive'::text)) OR (volstatus = 'Append'::text)) OR (volstatus = 'Recycle'::text)) OR (volstatus = 'Purged'::text)) OR (volstatus = 'Read-Only'::text)) OR (volstatus = 'Disabled'::text)) OR (volstatus = 'Error'::text)) OR (volstatus = 'Busy'::text)) OR (volstatus = 'Used'::text)) OR (volstatus = 'Cleaning'::text)) OR (volstatus = 'Scratch'::text)))
);


ALTER TABLE public.media OWNER TO bacula;

--
-- TOC entry 1197 (class 1259 OID 40303042)
-- Dependencies: 1500 1501 2
-- Name: mediatype; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE mediatype (
    mediatypeid serial NOT NULL,
    mediatype text NOT NULL,
    readonly integer DEFAULT 0
);


ALTER TABLE public.mediatype OWNER TO bacula;

--
-- TOC entry 1185 (class 1259 OID 40302931)
-- Dependencies: 1450 2
-- Name: path; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE path (
    pathid serial NOT NULL,
    path text NOT NULL
);


ALTER TABLE public.path OWNER TO bacula;

--
-- TOC entry 1180 (class 1259 OID 23592)
-- Dependencies: 2
-- Name: pga_diagrams; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_diagrams (
    diagramname character varying(64) NOT NULL,
    diagramtables text,
    diagramlinks text
);


ALTER TABLE public.pga_diagrams OWNER TO victor;

--
-- TOC entry 1179 (class 1259 OID 23587)
-- Dependencies: 2
-- Name: pga_forms; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_forms (
    formname character varying(64) NOT NULL,
    formsource text
);


ALTER TABLE public.pga_forms OWNER TO victor;

--
-- TOC entry 1174 (class 1259 OID 23562)
-- Dependencies: 2
-- Name: pga_graphs; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_graphs (
    graphname character varying(64) NOT NULL,
    graphsource text,
    graphcode text
);


ALTER TABLE public.pga_graphs OWNER TO victor;

--
-- TOC entry 1176 (class 1259 OID 23572)
-- Dependencies: 2
-- Name: pga_images; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_images (
    imagename character varying(64) NOT NULL,
    imagesource text
);


ALTER TABLE public.pga_images OWNER TO victor;

--
-- TOC entry 1175 (class 1259 OID 23567)
-- Dependencies: 2
-- Name: pga_layout; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_layout (
    tablename character varying(64) NOT NULL,
    nrcols smallint,
    colnames text,
    colwidth text
);


ALTER TABLE public.pga_layout OWNER TO victor;

--
-- TOC entry 1177 (class 1259 OID 23577)
-- Dependencies: 2
-- Name: pga_queries; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_queries (
    queryname character varying(64) NOT NULL,
    querytype character(1),
    querycommand text,
    querytables text,
    querylinks text,
    queryresults text,
    querycomments text
);


ALTER TABLE public.pga_queries OWNER TO victor;

--
-- TOC entry 1178 (class 1259 OID 23582)
-- Dependencies: 2
-- Name: pga_reports; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_reports (
    reportname character varying(64) NOT NULL,
    reportsource text,
    reportbody text,
    reportprocs text,
    reportoptions text
);


ALTER TABLE public.pga_reports OWNER TO victor;

--
-- TOC entry 1181 (class 1259 OID 23597)
-- Dependencies: 2
-- Name: pga_scripts; Type: TABLE; Schema: public; Owner: victor; Tablespace: 
--

CREATE TABLE pga_scripts (
    scriptname character varying(64) NOT NULL,
    scriptsource text
);


ALTER TABLE public.pga_scripts OWNER TO victor;

--
-- TOC entry 1203 (class 1259 OID 40303084)
-- Dependencies: 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 2
-- Name: pool; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE pool (
    poolid serial NOT NULL,
    name text NOT NULL,
    numvols integer DEFAULT 0 NOT NULL,
    maxvols integer DEFAULT 0 NOT NULL,
    useonce smallint DEFAULT 0 NOT NULL,
    usecatalog smallint DEFAULT 0 NOT NULL,
    acceptanyvolume smallint DEFAULT 0 NOT NULL,
    volretention bigint DEFAULT 0 NOT NULL,
    voluseduration bigint DEFAULT 0 NOT NULL,
    maxvoljobs integer DEFAULT 0 NOT NULL,
    maxvolfiles integer DEFAULT 0 NOT NULL,
    maxvolbytes bigint DEFAULT 0 NOT NULL,
    autoprune smallint DEFAULT 0 NOT NULL,
    recycle smallint DEFAULT 0 NOT NULL,
    pooltype text,
    labeltype integer DEFAULT 0 NOT NULL,
    labelformat text NOT NULL,
    enabled smallint DEFAULT 1 NOT NULL,
    scratchpoolid integer DEFAULT 0,
    recyclepoolid integer DEFAULT 0,
    nextpoolid integer DEFAULT 0,
    migrationhighbytes bigint DEFAULT 0,
    migrationlowbytes bigint DEFAULT 0,
    migrationtime bigint DEFAULT 0,
    CONSTRAINT pool_pooltype CHECK (((((((pooltype = 'Backup'::text) OR (pooltype = 'Copy'::text)) OR (pooltype = 'Cloned'::text)) OR (pooltype = 'Archive'::text)) OR (pooltype = 'Migration'::text)) OR (pooltype = 'Scratch'::text)))
);


ALTER TABLE public.pool OWNER TO bacula;

--
-- TOC entry 1212 (class 1259 OID 40303150)
-- Dependencies: 2
-- Name: status; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE status (
    jobstatus character(1) NOT NULL,
    jobstatuslong text
);


ALTER TABLE public.status OWNER TO bacula;

--
-- TOC entry 1199 (class 1259 OID 40303053)
-- Dependencies: 1502 1503 2
-- Name: storage; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE "storage" (
    storageid serial NOT NULL,
    name text NOT NULL,
    autochanger integer DEFAULT 0
);


ALTER TABLE public."storage" OWNER TO bacula;

--
-- TOC entry 1209 (class 1259 OID 40303140)
-- Dependencies: 2
-- Name: unsavedfiles; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE unsavedfiles (
    unsavedid integer NOT NULL,
    jobid integer NOT NULL,
    pathid integer NOT NULL,
    filenameid integer NOT NULL
);


ALTER TABLE public.unsavedfiles OWNER TO bacula;

--
-- TOC entry 1211 (class 1259 OID 40303148)
-- Dependencies: 2
-- Name: version; Type: TABLE; Schema: public; Owner: bacula; Tablespace: 
--

CREATE TABLE version (
    versionid integer NOT NULL
);


ALTER TABLE public.version OWNER TO bacula;

--
-- TOC entry 1596 (class 16386 OID 40303139)
-- Dependencies: 1208 1208
-- Name: basefiles_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY basefiles
    ADD CONSTRAINT basefiles_pkey PRIMARY KEY (baseid);


--
-- TOC entry 1600 (class 16386 OID 40303147)
-- Dependencies: 1210 1210
-- Name: cdimages_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY cdimages
    ADD CONSTRAINT cdimages_pkey PRIMARY KEY (mediaid);


--
-- TOC entry 1592 (class 16386 OID 40303124)
-- Dependencies: 1205 1205
-- Name: client_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY client
    ADD CONSTRAINT client_pkey PRIMARY KEY (clientid);


--
-- TOC entry 1594 (class 16386 OID 40303132)
-- Dependencies: 1206 1206
-- Name: counters_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY counters
    ADD CONSTRAINT counters_pkey PRIMARY KEY (counter);


--
-- TOC entry 1586 (class 16386 OID 40303081)
-- Dependencies: 1201 1201
-- Name: device_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY device
    ADD CONSTRAINT device_pkey PRIMARY KEY (deviceid);


--
-- TOC entry 1568 (class 16386 OID 40302951)
-- Dependencies: 1187 1187
-- Name: file_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY file
    ADD CONSTRAINT file_pkey PRIMARY KEY (fileid);


--
-- TOC entry 1558 (class 16386 OID 40302927)
-- Dependencies: 1183 1183
-- Name: filename_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY filename
    ADD CONSTRAINT filename_pkey PRIMARY KEY (filenameid);


--
-- TOC entry 1574 (class 16386 OID 40302985)
-- Dependencies: 1191 1191
-- Name: fileset_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY fileset
    ADD CONSTRAINT fileset_pkey PRIMARY KEY (filesetid);


--
-- TOC entry 1571 (class 16386 OID 40302974)
-- Dependencies: 1189 1189
-- Name: job_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY job
    ADD CONSTRAINT job_pkey PRIMARY KEY (jobid);


--
-- TOC entry 1577 (class 16386 OID 40303002)
-- Dependencies: 1193 1193
-- Name: jobmedia_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY jobmedia
    ADD CONSTRAINT jobmedia_pkey PRIMARY KEY (jobmediaid);


--
-- TOC entry 1579 (class 16386 OID 40303038)
-- Dependencies: 1195 1195
-- Name: media_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY media
    ADD CONSTRAINT media_pkey PRIMARY KEY (mediaid);


--
-- TOC entry 1582 (class 16386 OID 40303050)
-- Dependencies: 1197 1197
-- Name: mediatype_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY mediatype
    ADD CONSTRAINT mediatype_pkey PRIMARY KEY (mediatypeid);


--
-- TOC entry 1561 (class 16386 OID 40302938)
-- Dependencies: 1185 1185
-- Name: path_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY path
    ADD CONSTRAINT path_pkey PRIMARY KEY (pathid);


--
-- TOC entry 1553 (class 16386 OID 23615)
-- Dependencies: 1180 1180
-- Name: pga_diagrams_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_diagrams
    ADD CONSTRAINT pga_diagrams_pkey PRIMARY KEY (diagramname);


--
-- TOC entry 1551 (class 16386 OID 23613)
-- Dependencies: 1179 1179
-- Name: pga_forms_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_forms
    ADD CONSTRAINT pga_forms_pkey PRIMARY KEY (formname);


--
-- TOC entry 1541 (class 16386 OID 23603)
-- Dependencies: 1174 1174
-- Name: pga_graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_graphs
    ADD CONSTRAINT pga_graphs_pkey PRIMARY KEY (graphname);


--
-- TOC entry 1545 (class 16386 OID 23607)
-- Dependencies: 1176 1176
-- Name: pga_images_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_images
    ADD CONSTRAINT pga_images_pkey PRIMARY KEY (imagename);


--
-- TOC entry 1543 (class 16386 OID 23605)
-- Dependencies: 1175 1175
-- Name: pga_layout_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_layout
    ADD CONSTRAINT pga_layout_pkey PRIMARY KEY (tablename);


--
-- TOC entry 1547 (class 16386 OID 23609)
-- Dependencies: 1177 1177
-- Name: pga_queries_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_queries
    ADD CONSTRAINT pga_queries_pkey PRIMARY KEY (queryname);


--
-- TOC entry 1549 (class 16386 OID 23611)
-- Dependencies: 1178 1178
-- Name: pga_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_reports
    ADD CONSTRAINT pga_reports_pkey PRIMARY KEY (reportname);


--
-- TOC entry 1555 (class 16386 OID 23617)
-- Dependencies: 1181 1181
-- Name: pga_scripts_pkey; Type: CONSTRAINT; Schema: public; Owner: victor; Tablespace: 
--

ALTER TABLE ONLY pga_scripts
    ADD CONSTRAINT pga_scripts_pkey PRIMARY KEY (scriptname);


--
-- TOC entry 1589 (class 16386 OID 40303112)
-- Dependencies: 1203 1203
-- Name: pool_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY pool
    ADD CONSTRAINT pool_pkey PRIMARY KEY (poolid);


--
-- TOC entry 1602 (class 16386 OID 40303156)
-- Dependencies: 1212 1212
-- Name: status_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY status
    ADD CONSTRAINT status_pkey PRIMARY KEY (jobstatus);


--
-- TOC entry 1584 (class 16386 OID 40303061)
-- Dependencies: 1199 1199
-- Name: storage_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY "storage"
    ADD CONSTRAINT storage_pkey PRIMARY KEY (storageid);


--
-- TOC entry 1598 (class 16386 OID 40303143)
-- Dependencies: 1209 1209
-- Name: unsavedfiles_pkey; Type: CONSTRAINT; Schema: public; Owner: bacula; Tablespace: 
--

ALTER TABLE ONLY unsavedfiles
    ADD CONSTRAINT unsavedfiles_pkey PRIMARY KEY (unsavedid);


--
-- TOC entry 1590 (class 1259 OID 40303125)
-- Dependencies: 1205
-- Name: client_name_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE UNIQUE INDEX client_name_idx ON client USING btree (name);


--
-- TOC entry 1562 (class 1259 OID 40302955)
-- Dependencies: 1187
-- Name: file_filenameid_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX file_filenameid_idx ON file USING btree (filenameid);


--
-- TOC entry 1563 (class 1259 OID 40302953)
-- Dependencies: 1187 1187
-- Name: file_fp_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX file_fp_idx ON file USING btree (filenameid, pathid);


--
-- TOC entry 1564 (class 1259 OID 40302952)
-- Dependencies: 1187
-- Name: file_jobid_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX file_jobid_idx ON file USING btree (jobid);


--
-- TOC entry 1565 (class 1259 OID 40302956)
-- Dependencies: 1187 1187 1187
-- Name: file_jpfid_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX file_jpfid_idx ON file USING btree (jobid, pathid, filenameid);


--
-- TOC entry 1566 (class 1259 OID 40302954)
-- Dependencies: 1187
-- Name: file_pathid_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX file_pathid_idx ON file USING btree (pathid);


--
-- TOC entry 1556 (class 1259 OID 40302928)
-- Dependencies: 1183
-- Name: filename_name_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX filename_name_idx ON filename USING btree (name);


--
-- TOC entry 1572 (class 1259 OID 40302986)
-- Dependencies: 1191
-- Name: fileset_name_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX fileset_name_idx ON fileset USING btree (fileset);


--
-- TOC entry 1575 (class 1259 OID 40303003)
-- Dependencies: 1193 1193
-- Name: job_media_job_id_media_id_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX job_media_job_id_media_id_idx ON jobmedia USING btree (jobid, mediaid);


--
-- TOC entry 1569 (class 1259 OID 40302975)
-- Dependencies: 1189
-- Name: job_name_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX job_name_idx ON job USING btree (name);


--
-- TOC entry 1580 (class 1259 OID 40303039)
-- Dependencies: 1195
-- Name: media_volumename_id; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE UNIQUE INDEX media_volumename_id ON media USING btree (volumename);


--
-- TOC entry 1559 (class 1259 OID 40302939)
-- Dependencies: 1185
-- Name: path_name_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX path_name_idx ON "path" USING btree ("path");


--
-- TOC entry 1587 (class 1259 OID 40303113)
-- Dependencies: 1203
-- Name: pool_name_idx; Type: INDEX; Schema: public; Owner: bacula; Tablespace: 
--

CREATE INDEX pool_name_idx ON pool USING btree (name);


--
-- TOC entry 1607 (class 0 OID 0)
-- Dependencies: 2
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2008-05-27 10:50:57 CEST

--
-- PostgreSQL database dump complete
--