diff options
Diffstat (limited to 'gentoobrowse/datasources/schema.sql')
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 64 |
1 files changed, 32 insertions, 32 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index fc6c064..2b268e0 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -33,7 +33,7 @@ CREATE TYPE ebuildversion AS ( ); -ALTER TYPE gentoobrowse.ebuildversion OWNER TO gentoo; +ALTER TYPE ebuildversion OWNER TO gentoo; SET default_tablespace = ''; @@ -52,7 +52,7 @@ CREATE TABLE bugs ( ); -ALTER TABLE gentoobrowse.bugs OWNER TO gentoo; +ALTER TABLE bugs OWNER TO gentoo; -- -- Name: TABLE bugs; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -269,7 +269,7 @@ CREATE TABLE packages ( ); -ALTER TABLE gentoobrowse.packages OWNER TO gentoo; +ALTER TABLE packages OWNER TO gentoo; -- -- Name: TABLE packages; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -320,7 +320,7 @@ CREATE TABLE categories ( ); -ALTER TABLE gentoobrowse.categories OWNER TO gentoo; +ALTER TABLE categories OWNER TO gentoo; -- -- Name: TABLE categories; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -339,7 +339,7 @@ CREATE TABLE ebuild_archs ( ); -ALTER TABLE gentoobrowse.ebuild_archs OWNER TO gentoo; +ALTER TABLE ebuild_archs OWNER TO gentoo; -- -- Name: TABLE ebuild_archs; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -362,7 +362,7 @@ CREATE TABLE ebuild_deps ( ); -ALTER TABLE gentoobrowse.ebuild_deps OWNER TO gentoo; +ALTER TABLE ebuild_deps OWNER TO gentoo; -- -- Name: TABLE ebuild_deps; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -382,7 +382,7 @@ CREATE TABLE ebuild_masks ( ); -ALTER TABLE gentoobrowse.ebuild_masks OWNER TO gentoo; +ALTER TABLE ebuild_masks OWNER TO gentoo; -- -- Name: ebuild_rdeps; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -398,7 +398,7 @@ CREATE TABLE ebuild_rdeps ( ); -ALTER TABLE gentoobrowse.ebuild_rdeps OWNER TO gentoo; +ALTER TABLE ebuild_rdeps OWNER TO gentoo; -- -- Name: ebuild_uses; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -410,7 +410,7 @@ CREATE TABLE ebuild_uses ( ); -ALTER TABLE gentoobrowse.ebuild_uses OWNER TO gentoo; +ALTER TABLE ebuild_uses OWNER TO gentoo; -- -- Name: TABLE ebuild_uses; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -435,7 +435,7 @@ CREATE TABLE ebuilds ( ); -ALTER TABLE gentoobrowse.ebuilds OWNER TO gentoo; +ALTER TABLE ebuilds OWNER TO gentoo; -- -- Name: TABLE ebuilds; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -455,7 +455,7 @@ CREATE TABLE filecache ( ); -ALTER TABLE gentoobrowse.filecache OWNER TO gentoo; +ALTER TABLE filecache OWNER TO gentoo; -- -- Name: files; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -471,7 +471,7 @@ CREATE TABLE files ( ); -ALTER TABLE gentoobrowse.files OWNER TO gentoo; +ALTER TABLE files OWNER TO gentoo; -- -- Name: file_masks; Type: VIEW; Schema: gentoobrowse; Owner: gentoo @@ -485,7 +485,7 @@ CREATE VIEW file_masks AS WHERE (((f.filename = 'package.mask'::text) AND (f.fileid = fc.fileid)) AND (fc.line > 32)); -ALTER TABLE gentoobrowse.file_masks OWNER TO gentoo; +ALTER TABLE file_masks OWNER TO gentoo; -- -- Name: file_masks_withset; Type: VIEW; Schema: gentoobrowse; Owner: gentoo @@ -505,7 +505,7 @@ CREATE VIEW file_masks_withset AS FROM file_masks o; -ALTER TABLE gentoobrowse.file_masks_withset OWNER TO gentoo; +ALTER TABLE file_masks_withset OWNER TO gentoo; -- -- Name: filetypes; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -520,7 +520,7 @@ CREATE TABLE filetypes ( ); -ALTER TABLE gentoobrowse.filetypes OWNER TO gentoo; +ALTER TABLE filetypes OWNER TO gentoo; -- -- Name: TABLE filetypes; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -539,7 +539,7 @@ CREATE TABLE license ( ); -ALTER TABLE gentoobrowse.license OWNER TO gentoo; +ALTER TABLE license OWNER TO gentoo; -- -- Name: masksets; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -554,7 +554,7 @@ CREATE TABLE masksets ( ); -ALTER TABLE gentoobrowse.masksets OWNER TO gentoo; +ALTER TABLE masksets OWNER TO gentoo; -- -- Name: package_bugs; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -567,7 +567,7 @@ CREATE TABLE package_bugs ( ); -ALTER TABLE gentoobrowse.package_bugs OWNER TO gentoo; +ALTER TABLE package_bugs OWNER TO gentoo; -- -- Name: TABLE package_bugs; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -590,7 +590,7 @@ CREATE TABLE package_changelogs ( ); -ALTER TABLE gentoobrowse.package_changelogs OWNER TO gentoo; +ALTER TABLE package_changelogs OWNER TO gentoo; -- -- Name: package_urls; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -602,7 +602,7 @@ CREATE TABLE package_urls ( ); -ALTER TABLE gentoobrowse.package_urls OWNER TO gentoo; +ALTER TABLE package_urls OWNER TO gentoo; -- -- Name: TABLE package_urls; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -623,7 +623,7 @@ CREATE SEQUENCE seq_categoryid CACHE 1; -ALTER TABLE gentoobrowse.seq_categoryid OWNER TO gentoo; +ALTER TABLE seq_categoryid OWNER TO gentoo; -- -- Name: seq_categoryid; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo @@ -644,7 +644,7 @@ CREATE SEQUENCE seq_fileid CACHE 1; -ALTER TABLE gentoobrowse.seq_fileid OWNER TO gentoo; +ALTER TABLE seq_fileid OWNER TO gentoo; -- -- Name: seq_fileid; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo @@ -665,7 +665,7 @@ CREATE SEQUENCE seq_packageid CACHE 1; -ALTER TABLE gentoobrowse.seq_packageid OWNER TO gentoo; +ALTER TABLE seq_packageid OWNER TO gentoo; -- -- Name: seq_packageid; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo @@ -684,7 +684,7 @@ CREATE TABLE use_global ( ); -ALTER TABLE gentoobrowse.use_global OWNER TO gentoo; +ALTER TABLE use_global OWNER TO gentoo; -- -- Name: use_group; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -697,7 +697,7 @@ CREATE TABLE use_group ( ); -ALTER TABLE gentoobrowse.use_group OWNER TO gentoo; +ALTER TABLE use_group OWNER TO gentoo; -- -- Name: use_groups; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -709,7 +709,7 @@ CREATE TABLE use_groups ( ); -ALTER TABLE gentoobrowse.use_groups OWNER TO gentoo; +ALTER TABLE use_groups OWNER TO gentoo; -- -- Name: use_groups_usegroupid_seq; Type: SEQUENCE; Schema: gentoobrowse; Owner: gentoo @@ -723,7 +723,7 @@ CREATE SEQUENCE use_groups_usegroupid_seq CACHE 1; -ALTER TABLE gentoobrowse.use_groups_usegroupid_seq OWNER TO gentoo; +ALTER TABLE use_groups_usegroupid_seq OWNER TO gentoo; -- -- Name: use_groups_usegroupid_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo @@ -743,7 +743,7 @@ CREATE TABLE use_local ( ); -ALTER TABLE gentoobrowse.use_local OWNER TO gentoo; +ALTER TABLE use_local OWNER TO gentoo; -- -- Name: user_ebuild_emails; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -756,7 +756,7 @@ CREATE TABLE user_ebuild_emails ( ); -ALTER TABLE gentoobrowse.user_ebuild_emails OWNER TO gentoo; +ALTER TABLE user_ebuild_emails OWNER TO gentoo; -- -- Name: user_packages; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: @@ -769,7 +769,7 @@ CREATE TABLE user_packages ( ); -ALTER TABLE gentoobrowse.user_packages OWNER TO gentoo; +ALTER TABLE user_packages OWNER TO gentoo; -- -- Name: TABLE user_packages; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -792,7 +792,7 @@ CREATE TABLE users ( ); -ALTER TABLE gentoobrowse.users OWNER TO gentoo; +ALTER TABLE users OWNER TO gentoo; -- -- Name: TABLE users; Type: COMMENT; Schema: gentoobrowse; Owner: gentoo @@ -813,7 +813,7 @@ CREATE SEQUENCE users_userid_seq CACHE 1; -ALTER TABLE gentoobrowse.users_userid_seq OWNER TO gentoo; +ALTER TABLE users_userid_seq OWNER TO gentoo; -- -- Name: users_userid_seq; Type: SEQUENCE OWNED BY; Schema: gentoobrowse; Owner: gentoo |