[3526] | 1 | |
---|
| 2 | CREATE TABLE phpgw_mydms_acls |
---|
| 3 | ( |
---|
| 4 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_acls'::regclass), |
---|
| 5 | target integer NOT NULL DEFAULT 0, |
---|
| 6 | targettype integer NOT NULL DEFAULT 0, |
---|
| 7 | userid integer NOT NULL DEFAULT (-1), |
---|
| 8 | groupid integer NOT NULL DEFAULT (-1), |
---|
| 9 | "mode" integer NOT NULL DEFAULT 0, |
---|
| 10 | CONSTRAINT phpgw_mydms_acls_key UNIQUE (id) |
---|
| 11 | ) |
---|
| 12 | WITH (OIDS=TRUE); |
---|
| 13 | ALTER TABLE phpgw_mydms_acls OWNER TO postgres; |
---|
| 14 | |
---|
| 15 | |
---|
| 16 | |
---|
| 17 | CREATE TABLE phpgw_mydms_documentcontent |
---|
| 18 | ( |
---|
| 19 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_documentcontent'::regclass), |
---|
| 20 | "document" integer DEFAULT 0, |
---|
| 21 | "version" integer DEFAULT 0, |
---|
| 22 | "comment" text, |
---|
| 23 | date integer DEFAULT 0, |
---|
| 24 | createdby integer DEFAULT 0, |
---|
| 25 | dir character varying(10) NOT NULL DEFAULT ' '::character varying, |
---|
| 26 | orgfilename character varying(150) NOT NULL DEFAULT ' '::character varying, |
---|
| 27 | filetype character varying(10) NOT NULL DEFAULT ' '::character varying, |
---|
| 28 | mimetype character varying(70) NOT NULL DEFAULT ' '::character varying, |
---|
| 29 | CONSTRAINT phpgw_mydms_documentcontent_key UNIQUE (id) |
---|
| 30 | ) |
---|
| 31 | WITH (OIDS=TRUE); |
---|
| 32 | ALTER TABLE phpgw_mydms_documentcontent OWNER TO postgres; |
---|
| 33 | |
---|
| 34 | |
---|
| 35 | |
---|
| 36 | CREATE TABLE phpgw_mydms_documentlinks |
---|
| 37 | ( |
---|
| 38 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_documentlinks'::regclass), |
---|
| 39 | "document" integer NOT NULL DEFAULT 0, |
---|
| 40 | target integer NOT NULL DEFAULT 0, |
---|
| 41 | userid integer NOT NULL DEFAULT 0, |
---|
| 42 | public boolean NOT NULL DEFAULT true, |
---|
| 43 | CONSTRAINT phpgw_mydms_documentlinks_key UNIQUE (id) |
---|
| 44 | ) |
---|
| 45 | WITH (OIDS=TRUE); |
---|
| 46 | ALTER TABLE phpgw_mydms_documentlinks OWNER TO postgres; |
---|
| 47 | |
---|
| 48 | |
---|
| 49 | |
---|
| 50 | |
---|
| 51 | CREATE TABLE phpgw_mydms_documents |
---|
| 52 | ( |
---|
| 53 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_documents'::regclass), |
---|
| 54 | "name" character varying(150) DEFAULT NULL::character varying, |
---|
| 55 | "comment" text, |
---|
| 56 | date integer DEFAULT 0, |
---|
| 57 | expires integer DEFAULT 0, |
---|
| 58 | "owner" integer DEFAULT 0, |
---|
| 59 | folder integer DEFAULT 0, |
---|
| 60 | inheritaccess boolean NOT NULL DEFAULT true, |
---|
| 61 | defaultaccess integer NOT NULL DEFAULT 0, |
---|
| 62 | locked integer NOT NULL DEFAULT (-1), |
---|
| 63 | keywords text, |
---|
| 64 | "sequence" double precision NOT NULL, |
---|
| 65 | CONSTRAINT phpgw_mydms_documents_key UNIQUE (id) |
---|
| 66 | ) |
---|
| 67 | WITH (OIDS=TRUE); |
---|
| 68 | ALTER TABLE phpgw_mydms_documents OWNER TO postgres; |
---|
| 69 | |
---|
| 70 | |
---|
| 71 | |
---|
| 72 | |
---|
| 73 | CREATE TABLE phpgw_mydms_folders |
---|
| 74 | ( |
---|
| 75 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_folders'::regclass), |
---|
| 76 | "name" character varying(90) DEFAULT NULL::character varying, |
---|
| 77 | parent integer DEFAULT 0, |
---|
| 78 | "comment" text, |
---|
| 79 | "owner" integer DEFAULT 0, |
---|
| 80 | inheritaccess boolean NOT NULL DEFAULT true, |
---|
| 81 | defaultaccess integer NOT NULL DEFAULT 0, |
---|
| 82 | "sequence" double precision NOT NULL, |
---|
| 83 | CONSTRAINT phpgw_mydms_folders_key UNIQUE (id) |
---|
| 84 | ) |
---|
| 85 | WITH (OIDS=TRUE); |
---|
| 86 | ALTER TABLE phpgw_mydms_folders OWNER TO postgres; |
---|
| 87 | |
---|
| 88 | |
---|
| 89 | |
---|
| 90 | |
---|
| 91 | CREATE TABLE phpgw_mydms_groupmembers |
---|
| 92 | ( |
---|
| 93 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_groupmembers'::regclass), |
---|
| 94 | groupid integer NOT NULL DEFAULT 0, |
---|
| 95 | userid integer NOT NULL DEFAULT 0, |
---|
| 96 | CONSTRAINT phpgw_mydms_groupmembers_key UNIQUE (id) |
---|
| 97 | ) |
---|
| 98 | WITH (OIDS=TRUE); |
---|
| 99 | ALTER TABLE phpgw_mydms_groupmembers OWNER TO postgres; |
---|
| 100 | |
---|
| 101 | |
---|
| 102 | |
---|
| 103 | |
---|
| 104 | CREATE TABLE phpgw_mydms_groups |
---|
| 105 | ( |
---|
| 106 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_groups'::regclass), |
---|
| 107 | "name" character varying(50) DEFAULT NULL::character varying, |
---|
| 108 | "comment" text, |
---|
| 109 | CONSTRAINT phpgw_mydms_groups_key UNIQUE (id) |
---|
| 110 | ) |
---|
| 111 | WITH (OIDS=TRUE); |
---|
| 112 | ALTER TABLE phpgw_mydms_groups OWNER TO postgres; |
---|
| 113 | |
---|
| 114 | |
---|
| 115 | |
---|
| 116 | |
---|
| 117 | CREATE TABLE phpgw_mydms_keywordcategories |
---|
| 118 | ( |
---|
| 119 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_keywordcategories'::regclass), |
---|
| 120 | "name" character varying(255) NOT NULL DEFAULT ''::character varying, |
---|
| 121 | "owner" integer NOT NULL DEFAULT 0, |
---|
| 122 | CONSTRAINT phpgw_mydms_keywordcategories_key UNIQUE (id) |
---|
| 123 | ) |
---|
| 124 | WITH (OIDS=TRUE); |
---|
| 125 | ALTER TABLE phpgw_mydms_keywordcategories OWNER TO postgres; |
---|
| 126 | |
---|
| 127 | |
---|
| 128 | |
---|
| 129 | |
---|
| 130 | CREATE TABLE phpgw_mydms_keywords |
---|
| 131 | ( |
---|
| 132 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_keywords'::regclass), |
---|
| 133 | category integer NOT NULL DEFAULT 0, |
---|
| 134 | keywords text, |
---|
| 135 | CONSTRAINT phpgw_mydms_keywords_key UNIQUE (id) |
---|
| 136 | ) |
---|
| 137 | WITH (OIDS=TRUE); |
---|
| 138 | ALTER TABLE phpgw_mydms_keywords OWNER TO postgres; |
---|
| 139 | |
---|
| 140 | |
---|
| 141 | |
---|
| 142 | |
---|
| 143 | CREATE TABLE phpgw_mydms_notify |
---|
| 144 | ( |
---|
| 145 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_notify'::regclass), |
---|
| 146 | target integer NOT NULL DEFAULT 0, |
---|
| 147 | targettype integer NOT NULL DEFAULT 0, |
---|
| 148 | userid integer NOT NULL DEFAULT (-1), |
---|
| 149 | groupid integer NOT NULL DEFAULT (-1), |
---|
| 150 | CONSTRAINT phpgw_mydms_notify_key UNIQUE (id) |
---|
| 151 | ) |
---|
| 152 | WITH (OIDS=TRUE); |
---|
| 153 | ALTER TABLE phpgw_mydms_notify OWNER TO postgres; |
---|
| 154 | |
---|
| 155 | |
---|
| 156 | |
---|
| 157 | |
---|
| 158 | |
---|
| 159 | CREATE TABLE phpgw_mydms_sessions |
---|
| 160 | ( |
---|
| 161 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_sessions'::regclass), |
---|
| 162 | userid integer NOT NULL DEFAULT 0, |
---|
| 163 | lastaccess integer NOT NULL DEFAULT 0, |
---|
| 164 | theme character varying(30) NOT NULL DEFAULT ''::character varying, |
---|
| 165 | "language" character varying(30) NOT NULL DEFAULT ''::character varying, |
---|
| 166 | CONSTRAINT phpgw_mydms_sessions_key UNIQUE (id) |
---|
| 167 | ) |
---|
| 168 | WITH (OIDS=TRUE); |
---|
| 169 | ALTER TABLE phpgw_mydms_sessions OWNER TO postgres; |
---|
| 170 | |
---|
| 171 | |
---|
| 172 | |
---|
| 173 | |
---|
| 174 | CREATE TABLE phpgw_mydms_userimages |
---|
| 175 | ( |
---|
| 176 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_userimages'::regclass), |
---|
| 177 | userid integer NOT NULL DEFAULT 0, |
---|
| 178 | image oid, |
---|
| 179 | mimetype character varying(10) NOT NULL DEFAULT ''::character varying, |
---|
| 180 | CONSTRAINT phpgw_mydms_userimages_key UNIQUE (id) |
---|
| 181 | ) |
---|
| 182 | WITH (OIDS=TRUE); |
---|
| 183 | ALTER TABLE phpgw_mydms_userimages OWNER TO postgres; |
---|
| 184 | |
---|
| 185 | |
---|
| 186 | |
---|
| 187 | |
---|
| 188 | CREATE TABLE phpgw_mydms_users |
---|
| 189 | ( |
---|
| 190 | id integer NOT NULL DEFAULT nextval('seq_phpgw_mydms_users'::regclass), |
---|
| 191 | "login" character varying(50) DEFAULT NULL::character varying, |
---|
| 192 | pwd character varying(50) DEFAULT NULL::character varying, |
---|
| 193 | fullname character varying(100) DEFAULT NULL::character varying, |
---|
| 194 | email character varying(70) DEFAULT NULL::character varying, |
---|
| 195 | "comment" text, |
---|
| 196 | isadmin integer NOT NULL DEFAULT 0, |
---|
| 197 | CONSTRAINT phpgw_mydms_users_key UNIQUE (id) |
---|
| 198 | ) |
---|
| 199 | WITH (OIDS=TRUE); |
---|
| 200 | ALTER TABLE phpgw_mydms_users OWNER TO postgres; |
---|
| 201 | |
---|
| 202 | |
---|
| 203 | |
---|
| 204 | |
---|
| 205 | |
---|