OpenACS

lars
committed
MAIN:lars:20031015080919
on 15 Oct 03
Initial revision
openacs-4/.../oracle/acs-mail-create.sql (+3 -3)
226 226 create table acs_mail_multipart_parts (
227 227     multipart_id integer
228 228         constraint acs_mail_mp_parts_mp_id_fk
229 229             references acs_mail_multiparts
230 230                 on delete cascade,
231 231     mime_filename varchar2(1000),
232 232     mime_disposition varchar2(1000),
233 233     sequence_number integer,
234 234     content_item_id integer
235 235         constraint acs_mail_mp_parts_c_obj_id_fk references cr_items,
236 236     constraint acs_mail_multipart_parts_pk
237 237         primary key (multipart_id, sequence_number)
238 238 );
239 239 --RI Index
240 240 create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id);
241 241
242 242 -- Mail Links
243 243
244 244 create table acs_mail_links (
245 245     mail_link_id integer
246           constraint acs_mail_links_mail_links_id_pk primary key
247           constraint acs_mail_links_mail_links_id_fk references acs_objects
  246         constraint a_m_l_mail_links_id_pk primary key
  247         constraint a_m_l_mail_links_id_fk references acs_objects
248 248         on delete cascade,
249 249     body_id integer
250 250         constraint acs_mail_links_body_id_nn not null
251 251         constraint acs_mail_links_body_id_fk references acs_mail_bodies
252 252 );
253 253
254 254 --RI Index
255 255 create index acs_mail_links_body_id_idx ON acs_mail_links(body_id);
256 256
257 257
258 258 -- API -----------------------------------------------------------------
259 259
260 260 -- APIs for the datamodel in this file, separated out for future upgrades
261 261 @@ acs-mail-packages-create
262 262
263 263 -- Supporting Datamodels -----------------------------------------------
264 264
265 265 -- The mail queue datamodel
266 266 @@ acs-mail-queue-create
267 267