OpenACS

donb
committed
oacs-4-6:donb:20030313185658
on 13 Mar 03
Changed &lt to the datetime arrows like we use everywhere else 'cause
they're cute!
openacs-4/.../postgresql/download-create.sql (+11 -9)
304 304 select content_type__register_child_type(
305 305       'cr_download_rep',
306 306       'cr_download_archive_desc',
307 307           'generic',
308 308           0,
309 309           null
310 310 );
311 311
312 312 create view download_repository_obj as
313 313        select repository_id,
314 314                   o.*,
315 315                   i.parent_id,
316 316                           r.title,
317 317                           r.description,
318 318                           r.content as help_text
319 319        from download_repository dr, acs_objects o, cr_items i, cr_revisions r
320 320            where dr.repository_id = o.object_id and
321 321                          i.item_id = o.object_id and
322 322              r.revision_id = i.live_revision;
323 323
  324
324 325 create view download_archives_obj as
325 326        select cri.parent_id as repository_id,
326 327                           cri.name as archive_name,
327 328                           cri.latest_revision,
328 329                           cri.live_revision,
329 330               da.archive_id,
330 331                           da.archive_type_id,
331 332                           da.archive_desc_id,
332                 desc_item.title as summary,
333                             desc_item.description as description,
334                             desc_item.mime_type as description_type,
335                 desc_item.creation_user,
336                             desc_item.creation_date,
337                             desc_item.creation_ip
338          from download_archives da, cr_items cri, download_archive_descsi desc_item
339              where da.archive_desc_id = desc_item.revision_id and
  333               crr.title as summary,
  334                           crr.description as description,
  335                           crr.mime_type as description_type,
  336               o.creation_user,
  337                           o.creation_date,
  338                           o.creation_ip
  339        from download_archives da, cr_items cri, cr_revisions crr, acs_objects o
  340            where da.archive_desc_id = crr.revision_id and
  341                          da.archive_desc_id = o.object_id and
340 342                          da.archive_id = cri.item_id;
341 343
342 344 create view download_arch_revisions_obj as
343 345        select dar.*,
344 346                           o.*,
345 347                           r.item_id as archive_id,
346 348                           r.title as file_name,
347 349                           r.description as version_name,
348 350                           r.publish_date,
349 351                           r.mime_type,
350 352                           r.content
351 353        from download_archive_revisions dar, acs_objects o, cr_revisions r
352 354            where dar.revision_id = o.object_id and
353 355                          dar.revision_id = r.revision_id;
354 356
355 357 create view download_downloads_repository as
356 358        select dd.*,
357 359                           (select repository_id
358 360                            from download_archives_obj da, cr_revisions r
359 361                            where dd.revision_id = r.revision_id and