diff options
Diffstat (limited to 'gentoobrowse/datasources/schema.sql')
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index 161af0d..fbc86ec 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -369,6 +369,18 @@ CREATE SEQUENCE masksets_setno_seq ALTER TABLE masksets_setno_seq OWNER TO gentoo; -- Name: masksets_setno_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo ALTER SEQUENCE masksets_setno_seq OWNED BY masksets.setno; +-- Name: news; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: +CREATE TABLE news ( + newsid text NOT NULL, + title text NOT NULL, + posted date NOT NULL, + authorname text NOT NULL, + authoremail text NOT NULL, + atomspec text[], + body text[] NOT NULL, + urls text[] +); +ALTER TABLE news OWNER TO gentoo; -- Name: package_bugs; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: CREATE TABLE package_bugs ( packageid integer NOT NULL, @@ -565,6 +577,9 @@ ALTER TABLE ONLY filetypes -- Name: pk_files; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: ALTER TABLE ONLY files ADD CONSTRAINT pk_files PRIMARY KEY (fileid); +-- Name: pk_news; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: +ALTER TABLE ONLY news + ADD CONSTRAINT pk_news PRIMARY KEY (newsid); -- Name: pk_package_changelogs; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: ALTER TABLE ONLY package_changelogs ADD CONSTRAINT pk_package_changelogs PRIMARY KEY (packageid, date, n, repoid); @@ -646,6 +661,8 @@ CREATE INDEX idx_ebuildrdeps_package ON ebuild_rdeps USING btree (packageid); CREATE INDEX idx_ebuilds_firstseen ON ebuilds USING btree (firstseen); -- Name: idx_ebuilduses_use; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: CREATE INDEX idx_ebuilduses_use ON ebuild_uses USING btree (use); +-- Name: idx_news_posted; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: +CREATE INDEX idx_news_posted ON news USING btree (posted); -- Name: idx_package_name; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: CREATE INDEX idx_package_name ON packages USING btree (name); -- Name: idx_packagebugs_bug; Type: INDEX; Schema: gentoobrowse; Owner: gentoo; Tablespace: |