/usr/share/gforge/db/20030115.sql is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | CREATE SEQUENCE plugins_pk_seq;
CREATE TABLE plugins (plugin_id integer DEFAULT nextval('plugins_pk_seq'::text) NOT NULL,
plugin_name varchar(32) UNIQUE NOT NULL,
plugin_desc text,
CONSTRAINT plugins_pkey PRIMARY KEY (plugin_id));
CREATE SEQUENCE group_plugin_pk_seq;
CREATE TABLE group_plugin (group_plugin_id integer DEFAULT nextval('group_plugin_pk_seq'::text) NOT NULL,
group_id integer,
plugin_id integer,
CONSTRAINT group_plugin_pkey PRIMARY KEY (group_plugin_id),
CONSTRAINT group_plugin_group_id_fk FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL,
CONSTRAINT group_plugin_plugin_id_fk FOREIGN KEY (plugin_id) REFERENCES plugins(plugin_id) MATCH FULL);
CREATE SEQUENCE user_plugin_pk_seq;
CREATE TABLE user_plugin (user_plugin_id integer DEFAULT nextval('user_plugin_pk_seq'::text) NOT NULL,
user_id integer,
plugin_id integer,
CONSTRAINT user_plugin_pkey PRIMARY KEY (user_plugin_id),
CONSTRAINT user_plugin_user_id_fk FOREIGN KEY (user_id) REFERENCES users(user_id) MATCH FULL,
CONSTRAINT user_plugin_plugin_id_fk FOREIGN KEY (plugin_id) REFERENCES plugins(plugin_id) MATCH FULL);
|