-- -- PostgreSQL database dump -- SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: aliases; Type: TABLE; Schema: public; Owner: evkk; Tablespace: -- CREATE TABLE aliases ( "ID" integer NOT NULL, fromword character varying(255), "WordID" integer, toword character varying(255) ); ALTER TABLE public.aliases OWNER TO evkk; -- -- Name: aliidseq; Type: SEQUENCE; Schema: public; Owner: evkk -- CREATE SEQUENCE aliidseq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.aliidseq OWNER TO evkk; -- -- Name: didseq; Type: SEQUENCE; Schema: public; Owner: evkk -- CREATE SEQUENCE didseq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.didseq OWNER TO evkk; -- -- Name: docrefs; Type: TABLE; Schema: public; Owner: evkk; Tablespace: -- CREATE TABLE docrefs ( word character varying(255), "DocumentID" character varying(50) NOT NULL, "ID" bigint NOT NULL, "language" character varying(10), wstat integer DEFAULT 0 NOT NULL, corpus character varying(25) ); ALTER TABLE public.docrefs OWNER TO evkk; -- -- Name: COLUMN docrefs.wstat; Type: COMMENT; Schema: public; Owner: evkk -- COMMENT ON COLUMN docrefs.wstat IS '0 - not handled 1 - in process 2 - no match 3 - fullmatch (unified, finished) 4 - multimatch (many options, finished) 5 - manual (unified, finished)'; -- -- Name: docfreq; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW docfreq AS SELECT docrefs."DocumentID", count(docrefs."DocumentID") AS count FROM docrefs GROUP BY docrefs."DocumentID" ORDER BY count(docrefs."DocumentID") DESC; ALTER TABLE public.docfreq OWNER TO postgres; -- -- Name: documents; Type: TABLE; Schema: public; Owner: evkk; Tablespace: -- CREATE TABLE documents ( "DocumentID" character varying(100) NOT NULL, title character varying(255), corpus character varying(25), "language" character varying(10) ); ALTER TABLE public.documents OWNER TO evkk; -- -- Name: firstchars; Type: VIEW; Schema: public; Owner: evkk -- CREATE VIEW firstchars AS SELECT DISTINCT substr((docrefs.word)::text, 1, 1) AS "char", count(docrefs.word) AS count FROM docrefs GROUP BY substr((docrefs.word)::text, 1, 1) ORDER BY substr((docrefs.word)::text, 1, 1), count(docrefs.word); ALTER TABLE public.firstchars OWNER TO evkk; -- -- Name: undecided; Type: TABLE; Schema: public; Owner: evkk; Tablespace: -- CREATE TABLE undecided ( "ID" integer NOT NULL, word character varying(100) NOT NULL, "option" character varying(255), "language" character varying(4), processed boolean DEFAULT false, tick boolean ); ALTER TABLE public.undecided OWNER TO evkk; -- -- Name: COLUMN undecided.processed; Type: COMMENT; Schema: public; Owner: evkk -- COMMENT ON COLUMN undecided.processed IS 'is it processed already?'; -- -- Name: COLUMN undecided.tick; Type: COMMENT; Schema: public; Owner: evkk -- COMMENT ON COLUMN undecided.tick IS 'tick indicates the chosen form of a word. Ticked words will be copied to words table automatically.'; -- -- Name: unidseq; Type: SEQUENCE; Schema: public; Owner: evkk -- CREATE SEQUENCE unidseq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.unidseq OWNER TO evkk; -- -- Name: widseq; Type: SEQUENCE; Schema: public; Owner: evkk -- CREATE SEQUENCE widseq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.widseq OWNER TO evkk; -- -- Name: words; Type: TABLE; Schema: public; Owner: evkk; Tablespace: -- CREATE TABLE words ( "ID" integer NOT NULL, word character varying(255), prim character varying(255), lemma character varying(255), category character varying(10), gram character varying(500), "language" character varying(4), raw character varying(255) ); ALTER TABLE public.words OWNER TO evkk; -- -- Name: TABLE words; Type: COMMENT; Schema: public; Owner: evkk -- COMMENT ON TABLE words IS 'ID 1 word näitab freq 123 prim näita lemma näitama category !02_AS gram (PlG | (SgN lang et raw aura =aura (SgN >aura !16_S '; -- -- Name: aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: -- ALTER TABLE ONLY aliases ADD CONSTRAINT aliases_pkey PRIMARY KEY ("ID"); -- -- Name: docid; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: -- ALTER TABLE ONLY documents ADD CONSTRAINT docid PRIMARY KEY ("DocumentID"); -- -- Name: documents_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: -- ALTER TABLE ONLY docrefs ADD CONSTRAINT documents_pkey PRIMARY KEY ("ID"); -- -- Name: undecided_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: -- ALTER TABLE ONLY undecided ADD CONSTRAINT undecided_pkey PRIMARY KEY ("ID"); -- -- Name: words_pkey; Type: CONSTRAINT; Schema: public; Owner: evkk; Tablespace: -- ALTER TABLE ONLY words ADD CONSTRAINT words_pkey PRIMARY KEY ("ID"); -- -- Name: alindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX alindex ON aliases USING btree (fromword); -- -- Name: docindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX docindex ON docrefs USING btree ("DocumentID"); -- -- Name: fromindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX fromindex ON aliases USING btree (fromword); -- -- Name: langindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX langindex ON undecided USING btree ("language"); -- -- Name: toindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX toindex ON aliases USING btree (toword); -- -- Name: windex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX windex ON undecided USING btree (word); -- -- Name: wordindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX wordindex ON words USING btree (word); -- -- Name: wrdindex; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX wrdindex ON docrefs USING btree (word); -- -- Name: wstatidx; Type: INDEX; Schema: public; Owner: evkk; Tablespace: -- CREATE INDEX wstatidx ON docrefs USING btree (wstat); -- -- Name: word; Type: FK CONSTRAINT; Schema: public; Owner: evkk -- ALTER TABLE ONLY aliases ADD CONSTRAINT word FOREIGN KEY ("WordID") REFERENCES words("ID"); -- -- 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; -- -- Name: docfreq; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE docfreq FROM PUBLIC; REVOKE ALL ON TABLE docfreq FROM postgres; GRANT ALL ON TABLE docfreq TO postgres; GRANT ALL ON TABLE docfreq TO PUBLIC; -- -- PostgreSQL database dump complete --