| -- /usr/pgsql-9.1/bin/pg_dump --schema-only scannr | -- /usr/pgsql-9.1/bin/pg_dump --schema-only scannr |
| -- | -- |
| -- PostgreSQL database dump | -- PostgreSQL database dump |
| -- | -- |
| SET statement_timeout = 0; | SET statement_timeout = 0; |
| SET client_encoding = 'UTF8'; | SET client_encoding = 'UTF8'; |
| SET standard_conforming_strings = on; | SET standard_conforming_strings = on; |
| SET check_function_bodies = false; | SET check_function_bodies = false; |
| SET client_min_messages = warning; | SET client_min_messages = warning; |
| -- | -- |
| -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: | -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: |
| -- | -- |
| CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; | CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; |
| -- | -- |
| -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: | -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: |
| -- | -- |
| COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; |
| SET search_path = public, pg_catalog; | SET search_path = public, pg_catalog; |
| SET default_tablespace = ''; | SET default_tablespace = ''; |
| SET default_with_oids = false; | SET default_with_oids = false; |
| -- | -- |
| -- Name: recordings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | -- Name: recordings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- | -- |
| CREATE TABLE recordings ( | CREATE TABLE recordings ( |
| filename text NOT NULL, | filename text NOT NULL, |
| tgid text, | tgid text, |
| tgname text, | tgname text, |
| sitename text, | sitename text, |
| call_timestamp timestamp with time zone DEFAULT now(), | call_timestamp timestamp with time zone DEFAULT now(), |
| length integer | length integer |
| ); | ); |
| ALTER TABLE public.recordings OWNER TO postgres; | ALTER TABLE public.recordings OWNER TO postgres; |
| -- | -- |
| -- Name: tgids; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | -- Name: tgids; Type: TABLE; Schema: public; Owner: postgres; Tablespace: |
| -- | -- |
| CREATE TABLE tgids ( | CREATE TABLE tgids ( |
| tgid text NOT NULL, | tgid text NOT NULL, |
| subfleet smallint, | subfleet smallint, |
| mode character(1) DEFAULT 'D'::bpchar NOT NULL, | mode character(1) DEFAULT 'D'::bpchar NOT NULL, |
| alpha_tag text NOT NULL, | alpha_tag text NOT NULL, |
| service_tag text, | service_tag text, |
| category smallint | category smallint |
| ); | ); |
| ALTER TABLE public.tgids OWNER TO postgres; | ALTER TABLE public.tgids OWNER TO postgres; |
| -- | -- |
| -- Name: recordings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | -- Name: recordings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- | -- |
| ALTER TABLE ONLY recordings | ALTER TABLE ONLY recordings |
| ADD CONSTRAINT recordings_pkey PRIMARY KEY (filename); | ADD CONSTRAINT recordings_pkey PRIMARY KEY (filename); |
| -- | -- |
| -- Name: tgids_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | -- Name: tgids_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: |
| -- | -- |
| ALTER TABLE ONLY tgids | ALTER TABLE ONLY tgids |
| ADD CONSTRAINT tgids_pkey PRIMARY KEY (tgid); | ADD CONSTRAINT tgids_pkey PRIMARY KEY (tgid); |
| -- | -- |
| -- Name: public; Type: ACL; Schema: -; Owner: postgres | -- Name: public; Type: ACL; Schema: -; Owner: postgres |
| -- | -- |
| REVOKE ALL ON SCHEMA public FROM PUBLIC; | REVOKE ALL ON SCHEMA public FROM PUBLIC; |
| REVOKE ALL ON SCHEMA public FROM postgres; | REVOKE ALL ON SCHEMA public FROM postgres; |
| GRANT ALL ON SCHEMA public TO postgres; | GRANT ALL ON SCHEMA public TO postgres; |
| GRANT ALL ON SCHEMA public TO PUBLIC; | GRANT ALL ON SCHEMA public TO PUBLIC; |
| -- | -- |
| -- PostgreSQL database dump complete | -- PostgreSQL database dump complete |
| -- | -- |
| CREATE TABLE "compilation" ( | |
| "filename" text NOT NULL, | |
| "files" text ARRAY NOT NULL, | |
| "datetime" timestamp NOT NULL | |
| ); | |
| CREATE TABLE "trunk_log" ( | |
| "id" text NOT NULL, | |
| "datetime" integer NOT NULL, | |
| "site" integer NOT NULL, | |
| "action" text NOT NULL, | |
| "sourcetype" character(1) NOT NULL, | |
| "sourceid" smallint NOT NULL, | |
| "targettype" character(1) NOT NULL, | |
| "targetid" smallint NOT NULL, | |
| "channel" smallint NOT NULL, | |
| "calltype" text NOT NULL | |
| ); |