Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- PostgreSQL database dump
- --
- SET statement_timeout = 0;
- SET lock_timeout = 0;
- SET client_encoding = 'UTF8';
- SET standard_conforming_strings = on;
- SET check_function_bodies = false;
- SET client_min_messages = warning;
- --
- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
- --
- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
- --
- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
- --
- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
- SET search_path = public, pg_catalog;
- SET default_tablespace = '';
- SET default_with_oids = false;
- --
- -- Name: conjugaciones; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
- --
- CREATE TABLE conjugaciones (
- id_tipo_conjugacion integer,
- id_tiempo integer,
- id_persona integer,
- conjugacion text
- );
- ALTER TABLE public.conjugaciones OWNER TO postgres;
- --
- -- Name: personas; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
- --
- CREATE TABLE personas (
- id_persona integer NOT NULL,
- persona text NOT NULL,
- pronombre text
- );
- ALTER TABLE public.personas OWNER TO postgres;
- --
- -- Name: personas_id_persona_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE personas_id_persona_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.personas_id_persona_seq OWNER TO postgres;
- --
- -- Name: personas_id_persona_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE personas_id_persona_seq OWNED BY personas.id_persona;
- --
- -- Name: raiz_verbos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
- --
- CREATE TABLE raiz_verbos (
- id_raiz integer NOT NULL,
- raiz text NOT NULL,
- id_tipo_conjugacion integer NOT NULL,
- infinitivo text NOT NULL
- );
- ALTER TABLE public.raiz_verbos OWNER TO postgres;
- --
- -- Name: raiz_verbos_id_raiz_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE raiz_verbos_id_raiz_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.raiz_verbos_id_raiz_seq OWNER TO postgres;
- --
- -- Name: raiz_verbos_id_raiz_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE raiz_verbos_id_raiz_seq OWNED BY raiz_verbos.id_raiz;
- --
- -- Name: tiempos; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
- --
- CREATE TABLE tiempos (
- id_tiempo integer NOT NULL,
- tiempo text NOT NULL,
- id_modo integer
- );
- ALTER TABLE public.tiempos OWNER TO postgres;
- --
- -- Name: tiempos_id_tiempo_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE tiempos_id_tiempo_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.tiempos_id_tiempo_seq OWNER TO postgres;
- --
- -- Name: tiempos_id_tiempo_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE tiempos_id_tiempo_seq OWNED BY tiempos.id_tiempo;
- --
- -- Name: tipos_conjugacion; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
- --
- CREATE TABLE tipos_conjugacion (
- id_tipo integer NOT NULL,
- descripcion text
- );
- ALTER TABLE public.tipos_conjugacion OWNER TO postgres;
- --
- -- Name: tipos_conjugacion_id_tipo_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE tipos_conjugacion_id_tipo_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.tipos_conjugacion_id_tipo_seq OWNER TO postgres;
- --
- -- Name: tipos_conjugacion_id_tipo_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE tipos_conjugacion_id_tipo_seq OWNED BY tipos_conjugacion.id_tipo;
- --
- -- Name: id_persona; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY personas ALTER COLUMN id_persona SET DEFAULT nextval('personas_id_persona_seq'::regclass);
- --
- -- Name: id_raiz; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY raiz_verbos ALTER COLUMN id_raiz SET DEFAULT nextval('raiz_verbos_id_raiz_seq'::regclass);
- --
- -- Name: id_tiempo; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY tiempos ALTER COLUMN id_tiempo SET DEFAULT nextval('tiempos_id_tiempo_seq'::regclass);
- --
- -- Name: id_tipo; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY tipos_conjugacion ALTER COLUMN id_tipo SET DEFAULT nextval('tipos_conjugacion_id_tipo_seq'::regclass);
- --
- -- Data for Name: conjugaciones; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY conjugaciones (id_tipo_conjugacion, id_tiempo, id_persona, conjugacion) FROM stdin;
- 1 1 1 o
- 1 1 2 as
- 1 1 3 a
- 1 1 4 amos
- 1 1 5 áis
- 1 1 6 an
- \.
- --
- -- Data for Name: personas; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY personas (id_persona, persona, pronombre) FROM stdin;
- 1 Primera Singular yo
- 2 Segunda Singular tú
- 3 Tercera Singular él/ella/usted
- 4 Primera Plural nosotros
- 5 Segunda Plural vosotros
- 6 Tercera Plural ellos/ellas/ustedes
- \.
- --
- -- Name: personas_id_persona_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
- --
- SELECT pg_catalog.setval('personas_id_persona_seq', 6, true);
- --
- -- Data for Name: raiz_verbos; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY raiz_verbos (id_raiz, raiz, id_tipo_conjugacion, infinitivo) FROM stdin;
- 1 am 1 amar
- 2 abale 1 abalear
- \.
- --
- -- Name: raiz_verbos_id_raiz_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
- --
- SELECT pg_catalog.setval('raiz_verbos_id_raiz_seq', 2, true);
- --
- -- Data for Name: tiempos; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY tiempos (id_tiempo, tiempo, id_modo) FROM stdin;
- 1 Presente Indicativo \N
- \.
- --
- -- Name: tiempos_id_tiempo_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
- --
- SELECT pg_catalog.setval('tiempos_id_tiempo_seq', 1, true);
- --
- -- Data for Name: tipos_conjugacion; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY tipos_conjugacion (id_tipo, descripcion) FROM stdin;
- 1 -ar regular
- \.
- --
- -- Name: tipos_conjugacion_id_tipo_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
- --
- SELECT pg_catalog.setval('tipos_conjugacion_id_tipo_seq', 1, true);
- --
- -- Name: infinitivo_unique; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
- --
- ALTER TABLE ONLY raiz_verbos
- ADD CONSTRAINT infinitivo_unique UNIQUE (infinitivo);
- --
- -- Name: personas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
- --
- ALTER TABLE ONLY personas
- ADD CONSTRAINT personas_pkey PRIMARY KEY (id_persona);
- --
- -- Name: tiempos_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
- --
- ALTER TABLE ONLY tiempos
- ADD CONSTRAINT tiempos_pkey PRIMARY KEY (id_tiempo);
- --
- -- Name: tipos_conjugacion_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
- --
- ALTER TABLE ONLY tipos_conjugacion
- ADD CONSTRAINT tipos_conjugacion_pkey PRIMARY KEY (id_tipo);
- --
- -- Name: conjugaciones_id_persona_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY conjugaciones
- ADD CONSTRAINT conjugaciones_id_persona_fkey FOREIGN KEY (id_persona) REFERENCES personas(id_persona);
- --
- -- Name: conjugaciones_id_tiempo_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY conjugaciones
- ADD CONSTRAINT conjugaciones_id_tiempo_fkey FOREIGN KEY (id_tiempo) REFERENCES tiempos(id_tiempo);
- --
- -- Name: conjugaciones_id_tipo_conjugacion_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY conjugaciones
- ADD CONSTRAINT conjugaciones_id_tipo_conjugacion_fkey FOREIGN KEY (id_tipo_conjugacion) REFERENCES tipos_conjugacion(id_tipo);
- --
- -- Name: raiz_verbos_tipos_conjugacion_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY raiz_verbos
- ADD CONSTRAINT raiz_verbos_tipos_conjugacion_fk FOREIGN KEY (id_tipo_conjugacion) REFERENCES tipos_conjugacion(id_tipo);
- --
- -- 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 postgres;
- GRANT ALL ON SCHEMA public TO PUBLIC;
- --
- -- PostgreSQL database dump complete
- --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement