-- -- Selected TOC Entries: -- \connect - postgres -- -- TOC Entry ID 2 (OID 18981) -- -- Name: users_id_seq Type: SEQUENCE Owner: postgres -- CREATE SEQUENCE "users_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- -- TOC Entry ID 4 (OID 19000) -- -- Name: tipos_idtype_seq Type: SEQUENCE Owner: postgres -- CREATE SEQUENCE "tipos_idtype_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- -- TOC Entry ID 6 (OID 19019) -- -- 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 19019) -- -- 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 19050) -- -- Name: pga_forms Type: TABLE Owner: postgres -- CREATE TABLE "pga_forms" ( "formname" character varying(64), "formsource" text ); -- -- TOC Entry ID 9 (OID 19050) -- -- 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 19076) -- -- Name: pga_scripts Type: TABLE Owner: postgres -- CREATE TABLE "pga_scripts" ( "scriptname" character varying(64), "scriptsource" text ); -- -- TOC Entry ID 11 (OID 19076) -- -- 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 19102) -- -- 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 19102) -- -- 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 19131) -- -- Name: pga_schema Type: TABLE Owner: postgres -- CREATE TABLE "pga_schema" ( "schemaname" character varying(64), "schematables" text, "schemalinks" text ); -- -- TOC Entry ID 15 (OID 19131) -- -- 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 19158) -- -- 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 19158) -- -- 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 19186) -- -- Name: users Type: TABLE Owner: postgres -- CREATE TABLE "users" ( "id" integer DEFAULT nextval('users_id_seq'::text) NOT NULL, "login" character varying(10) NOT NULL, "nome" character varying(60) NOT NULL, "passwd" character varying(30) NOT NULL, "profissao" character varying(25) NOT NULL, "email" character varying(40), "telefone" character varying(9), "pergunta" character varying(50), Constraint "users_pkey" Primary Key ("id") ); -- -- TOC Entry ID 19 (OID 19207) -- -- Name: dados Type: TABLE Owner: postgres -- CREATE TABLE "dados" ( "id" integer DEFAULT nextval('dados_id_seq'::text) NOT NULL, "saldo" money NOT NULL, "visitas" integer DEFAULT 0 NOT NULL, "ultima" timestamp with time zone, Constraint "dados_pkey" Primary Key ("id") ); -- -- TOC Entry ID 20 (OID 19225) -- -- Name: tipos Type: TABLE Owner: postgres -- CREATE TABLE "tipos" ( "idtype" integer DEFAULT nextval('tipos_idtype_seq'::text) NOT NULL, "tipo" character varying(20) NOT NULL, Constraint "tipos_pkey" Primary Key ("idtype") ); -- -- TOC Entry ID 21 (OID 19240) -- -- Name: usertypes Type: TABLE Owner: postgres -- CREATE TABLE "usertypes" ( "id" integer NOT NULL, "idtype" integer NOT NULL, Constraint "usertypes_pkey" Primary Key ("id", "idtype") ); -- -- TOC Entry ID 22 (OID 19254) -- -- Name: logs Type: TABLE Owner: postgres -- CREATE TABLE "logs" ( "cod_user" integer NOT NULL, "url" character(150) NOT NULL, "count" integer DEFAULT 0 NOT NULL, "data_acesso" timestamp with time zone NOT NULL, Constraint "logs_pkey" Primary Key ("cod_user", "url") ); -- -- Data for TOC Entry ID 23 (OID 19019) -- -- Name: pga_queries Type: TABLE DATA Owner: postgres -- COPY "pga_queries" FROM stdin; \. -- -- Data for TOC Entry ID 24 (OID 19050) -- -- Name: pga_forms Type: TABLE DATA Owner: postgres -- COPY "pga_forms" FROM stdin; \. -- -- Data for TOC Entry ID 25 (OID 19076) -- -- Name: pga_scripts Type: TABLE DATA Owner: postgres -- COPY "pga_scripts" FROM stdin; \. -- -- Data for TOC Entry ID 26 (OID 19102) -- -- Name: pga_reports Type: TABLE DATA Owner: postgres -- COPY "pga_reports" FROM stdin; \. -- -- Data for TOC Entry ID 27 (OID 19131) -- -- Name: pga_schema Type: TABLE DATA Owner: postgres -- COPY "pga_schema" FROM stdin; esquema users 344.0 305.0 logs 176.0 304.0 tipos 679.0 319.0 usertypes 569.0 305.0 dados 472.0 306.0 {usertypes id dados id} {logs id users id} {users id dados id} {usertypes idtype tipos idtype} esquema users 344.0 305.0 logs 176.0 304.0 tipos 679.0 319.0 usertypes 569.0 305.0 dados 472.0 306.0 {usertypes id dados id} {logs id users id} {users id dados id} {usertypes idtype tipos idtype} \. -- -- Data for TOC Entry ID 28 (OID 19158) -- -- Name: pga_layout Type: TABLE DATA Owner: postgres -- COPY "pga_layout" FROM stdin; dados 4 id saldo visitas ultima 150 150 150 150 4 id saldo visitas ultima 150 150 150 150 tipos 2 idtype tipo 150 150 usertypes 2 id idtype 150 150 4 id saldo visitas ultima 150 150 150 150 users 8 id login nome passwd profissao email telefone pergunta 150 151 150 150 150 150 150 150 logs 4 cod_user url count data_acesso 150 353 150 150 \. -- -- Data for TOC Entry ID 29 (OID 19186) -- -- Name: users Type: TABLE DATA Owner: postgres -- COPY "users" FROM stdin; 41 si24844 Luis Soares 12tir.zIbWQ3c estudante si24844@tayra.localdomain 111111111 asdasd 49 luis luis 12tir.zIbWQ3c estudante si24844@tayra.localdomain 111111111 o numero é... 50 armando armando 12tir.zIbWQ3c Electricista si24844@tayra.localdomain 123456789 porque? \. -- -- Data for TOC Entry ID 30 (OID 19207) -- -- Name: dados Type: TABLE DATA Owner: postgres -- COPY "dados" FROM stdin; \. -- -- Data for TOC Entry ID 31 (OID 19225) -- -- Name: tipos Type: TABLE DATA Owner: postgres -- COPY "tipos" FROM stdin; 2 Administrador sec 3 Pagante 4 Nao pagante 1 Administrador \. -- -- Data for TOC Entry ID 32 (OID 19240) -- -- Name: usertypes Type: TABLE DATA Owner: postgres -- COPY "usertypes" FROM stdin; 1 1 1 2 2 1 2 2 3 1 3 2 49 1 50 4 41 4 \. -- -- Data for TOC Entry ID 33 (OID 19254) -- -- Name: logs Type: TABLE DATA Owner: postgres -- COPY "logs" FROM stdin; 43 /home/si24844/public_html/adb.novo/login_target.php 2 2001-11-13 00:27:00+00 48 /home/si24844/public_html/adb.novo/login_target.php 27 2001-11-14 17:01:00+00 48 /home/si24844/public_html/adb.novo/objectos.php 16 2001-11-14 17:01:00+00 48 /home/si24844/public_html/adb.novo/origens.php 16 2001-11-14 17:01:00+00 46 /home/si24844/public_html/adb.novo/login_target.php 1 2001-11-13 16:33:00+00 46 /home/si24844/public_html/adb.novo/origens.php 1 2001-11-13 16:33:00+00 47 /home/si24844/public_html/adb.novo/login_target.php 5 2001-11-14 15:03:00+00 47 /home/si24844/public_html/adb.novo/origens.php 5 2001-11-14 15:03:00+00 42 /home/si24844/public_html/adb.novo/origens.php 96 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/objectos.php 89 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/catalogo.php 82 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/arquivo/login_target.php 66 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/arquivo/origens.php 55 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/arquivo/objectos.php 38 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/arquivo/catalogo.php 17 2001-11-25 00:54:00+00 42 /home/si24844/public_html/adb.novo/login_target.php 111345 2001-11-25 00:00:00+00 49 /home/si24844/public_html/adb.novo/arquivo/catalogo.php 7 2002-02-24 22:42:00+00 49 /home/si24844/public_html/adb.novo/arquivo/fundos.php 7 2002-02-24 22:42:00+00 49 /home/si24844/public_html/adb.novo/arquivo/login_target.php 7 2002-02-24 22:42:00+00 49 /home/si24844/public_html/adb.novo/arquivo/objectos.php 7 2002-02-24 22:42:00+00 49 /home/si24844/public_html/adb.novo/arquivo/origens.php 7 2002-02-24 22:42:00+00 49 /home/si24844/public_html/adb.novo/Projectos.php 7 2002-02-24 22:42:00+00 41 /home/si24844/public_html/adb.novo/arquivo/login_target.php 1 2002-02-24 23:15:00+00 50 /home/si24844/public_html/adb.novo/arquivo/catalogo.php 19 2002-02-24 23:42:00+00 50 /home/si24844/public_html/adb.novo/arquivo/fundos.php 19 2002-02-24 23:42:00+00 50 /home/si24844/public_html/adb.novo/arquivo/login_target.php 19 2002-02-24 23:42:00+00 50 /home/si24844/public_html/adb.novo/arquivo/objectos.php 18 2002-02-24 23:42:00+00 50 /home/si24844/public_html/adb.novo/arquivo/origens.php 19 2002-02-24 23:42:00+00 50 /home/si24844/public_html/adb.novo/Projectos.php 18 2002-02-24 23:42:00+00 \. -- -- TOC Entry ID 3 (OID 18981) -- -- Name: users_id_seq Type: SEQUENCE SET Owner: -- SELECT setval ('"users_id_seq"', 50, 't'); -- -- TOC Entry ID 5 (OID 19000) -- -- Name: tipos_idtype_seq Type: SEQUENCE SET Owner: -- SELECT setval ('"tipos_idtype_seq"', 1, 'f');