-- -- 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 --