-- -- Selected TOC Entries: -- \connect - postgres -- -- TOC Entry ID 2 (OID 18721) -- -- Name: bases_id_seq Type: SEQUENCE Owner: postgres -- CREATE SEQUENCE "bases_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- -- TOC Entry ID 4 (OID 18740) -- -- Name: doctypes_tipo_seq Type: SEQUENCE Owner: postgres -- CREATE SEQUENCE "doctypes_tipo_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- -- TOC Entry ID 6 (OID 18759) -- -- Name: pga_queries Type: TABLE Owner: postgres -- CREATE TABLE "pga_queries" ( "queryname" character varying(64), "querytype" character(1), "querycommand" text, "querytables" text, "querylinks" text, "queryresults" text, "querycomments" text ); -- -- TOC Entry ID 7 (OID 18759) -- -- Name: pga_queries Type: ACL Owner: -- REVOKE ALL on "pga_queries" from PUBLIC; GRANT ALL on "pga_queries" to PUBLIC; GRANT ALL on "pga_queries" to "postgres"; -- -- TOC Entry ID 8 (OID 18790) -- -- Name: pga_forms Type: TABLE Owner: postgres -- CREATE TABLE "pga_forms" ( "formname" character varying(64), "formsource" text ); -- -- TOC Entry ID 9 (OID 18790) -- -- Name: pga_forms Type: ACL Owner: -- REVOKE ALL on "pga_forms" from PUBLIC; GRANT ALL on "pga_forms" to PUBLIC; GRANT ALL on "pga_forms" to "postgres"; -- -- TOC Entry ID 10 (OID 18816) -- -- Name: pga_scripts Type: TABLE Owner: postgres -- CREATE TABLE "pga_scripts" ( "scriptname" character varying(64), "scriptsource" text ); -- -- TOC Entry ID 11 (OID 18816) -- -- Name: pga_scripts Type: ACL Owner: -- REVOKE ALL on "pga_scripts" from PUBLIC; GRANT ALL on "pga_scripts" to PUBLIC; GRANT ALL on "pga_scripts" to "postgres"; -- -- TOC Entry ID 12 (OID 18842) -- -- Name: pga_reports Type: TABLE Owner: postgres -- CREATE TABLE "pga_reports" ( "reportname" character varying(64), "reportsource" text, "reportbody" text, "reportprocs" text, "reportoptions" text ); -- -- TOC Entry ID 13 (OID 18842) -- -- Name: pga_reports Type: ACL Owner: -- REVOKE ALL on "pga_reports" from PUBLIC; GRANT ALL on "pga_reports" to PUBLIC; GRANT ALL on "pga_reports" to "postgres"; -- -- TOC Entry ID 14 (OID 18871) -- -- Name: pga_schema Type: TABLE Owner: postgres -- CREATE TABLE "pga_schema" ( "schemaname" character varying(64), "schematables" text, "schemalinks" text ); -- -- TOC Entry ID 15 (OID 18871) -- -- Name: pga_schema Type: ACL Owner: -- REVOKE ALL on "pga_schema" from PUBLIC; GRANT ALL on "pga_schema" to PUBLIC; GRANT ALL on "pga_schema" to "postgres"; -- -- TOC Entry ID 16 (OID 18898) -- -- Name: pga_layout Type: TABLE Owner: postgres -- CREATE TABLE "pga_layout" ( "tablename" character varying(64), "nrcols" smallint, "colnames" text, "colwidth" text ); -- -- TOC Entry ID 17 (OID 18898) -- -- Name: pga_layout Type: ACL Owner: -- REVOKE ALL on "pga_layout" from PUBLIC; GRANT ALL on "pga_layout" to PUBLIC; GRANT ALL on "pga_layout" to "postgres"; -- -- TOC Entry ID 18 (OID 18926) -- -- Name: bases Type: TABLE Owner: postgres -- CREATE TABLE "bases" ( "id" integer DEFAULT nextval('bases_id_seq'::text) NOT NULL, "descricao" character(100) NOT NULL, "nome" character(20), "url" character varying(100), "activa" boolean NOT NULL, "tipo" integer, Constraint "bases_pkey" Primary Key ("id") ); -- -- TOC Entry ID 19 (OID 18945) -- -- Name: doctypes Type: TABLE Owner: postgres -- CREATE TABLE "doctypes" ( "tipo" integer DEFAULT nextval('doctypes_tipo_seq'::text) NOT NULL, "descricao" character(50) NOT NULL, Constraint "doctypes_pkey" Primary Key ("tipo") ); -- -- Data for TOC Entry ID 20 (OID 18759) -- -- Name: pga_queries Type: TABLE DATA Owner: postgres -- COPY "pga_queries" FROM stdin; \. -- -- Data for TOC Entry ID 21 (OID 18790) -- -- Name: pga_forms Type: TABLE DATA Owner: postgres -- COPY "pga_forms" FROM stdin; \. -- -- Data for TOC Entry ID 22 (OID 18816) -- -- Name: pga_scripts Type: TABLE DATA Owner: postgres -- COPY "pga_scripts" FROM stdin; \. -- -- Data for TOC Entry ID 23 (OID 18842) -- -- Name: pga_reports Type: TABLE DATA Owner: postgres -- COPY "pga_reports" FROM stdin; \. -- -- Data for TOC Entry ID 24 (OID 18871) -- -- Name: pga_schema Type: TABLE DATA Owner: postgres -- COPY "pga_schema" FROM stdin; \. -- -- Data for TOC Entry ID 25 (OID 18898) -- -- Name: pga_layout Type: TABLE DATA Owner: postgres -- COPY "pga_layout" FROM stdin; bases 6 id descricao nome url activa {tipo} 150 150 150 150 150 150 doctypes 2 tipo descricao 150 150 \. -- -- Data for TOC Entry ID 26 (OID 18926) -- -- Name: bases Type: TABLE DATA Owner: postgres -- COPY "bases" FROM stdin; 0 Assembleia Distrital de Braga www.adb.uminho.pt f 1 7 Cartas Annuas da Etiopia \N \N f 1 6 Bulario Bracarense \N \N f 1 9 Colecço Cronológica \N \N f 1 11 Colecção dos Manuscritos \N \N f 1 12 Colegiadas \N \N f 1 13 Comendas \N \N f 1 16 Gavetas do Cabido \N \N f 1 17 Governo Civil \N \N f 1 22 Inquirições do Monástico - Conventual \N \N f 1 19 Inquirições dos Dignatários da Sé de Braga \N \N f 1 25 Inventário Orfanológico de Monção \N \N f 1 15 Gaveta f 1 18 Inquirições inquiricoes www.adb.uminho.pt t 2 8 Cartas f 2 14 Familiares f 1 \. -- -- Data for TOC Entry ID 27 (OID 18945) -- -- Name: doctypes Type: TABLE DATA Owner: postgres -- COPY "doctypes" FROM stdin; 2 Texto 1 Bases de Dados \. -- -- TOC Entry ID 3 (OID 18721) -- -- Name: bases_id_seq Type: SEQUENCE SET Owner: -- SELECT setval ('"bases_id_seq"', 25, 't'); -- -- TOC Entry ID 5 (OID 18740) -- -- Name: doctypes_tipo_seq Type: SEQUENCE SET Owner: -- SELECT setval ('"doctypes_tipo_seq"', 2, 't');