← Back to branch summary

~ubuntu-branches/ubuntu/hardy/gallery2/hardy-security

« back to all changes in this revision

Viewing changes to modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryMaintenanceMap.sql

  • Committer: Bazaar Package Importer
  • Author(s): Michael C. Schultheiss
  • Date: 2006-04-16 16:42:35 UTC
  • mfrom: (1.1.1 upstream)
  • Revision ID: james.westby@ubuntu.com-20060416164235-8uy0u4bfjdxpge2o
Tags: 2.1.1-1
http://bugs.debian.org/362936
http://bugs.debian.org/359000
http://bugs.debian.org/362152
* New upstream release (Closes: #362936)
  + Bugfixes for Postgres7 (Closes: #359000, #362152)

Show diffs side-by-side

added added

removed removed

Lines of Context:
modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/GalleryMaintenanceMap.sql
1
 
 
2
 
    -- This file was automatically generated from an XSL template, which is
3
 
    -- why it looks so ugly.  Editing it by hand would be a bad idea.
4
 
    --
5
 
 
6
 
    CREATE TABLE DB_TABLE_PREFIXMaintenanceMap (
7
 
  DB_COLUMN_PREFIXrunId
8
 
      INTEGER
9
 
    
10
 
    NOT NULL
11
 
  
12
 
      ,
13
 
    DB_COLUMN_PREFIXtaskId
14
 
      VARCHAR2(
15
 
       128 
16
 
      )
17
 
    
18
 
    NOT NULL
19
 
  
20
 
      ,
21
 
    DB_COLUMN_PREFIXtimestamp
22
 
      INTEGER
23
 
    
24
 
      ,
25
 
    DB_COLUMN_PREFIXsuccess
26
 
      NUMBER(1)
27
 
    
28
 
      ,
29
 
    DB_COLUMN_PREFIXdetails
30
 
      VARCHAR2(4000)
31
 
    
32
 
    );
33
 
 
34
 
  
35
 
    CREATE INDEX DB_TABLE_PREFIXMaintenanceMap_21687
36
 
    ON DB_TABLE_PREFIXMaintenanceMap
37
 
    (DB_COLUMN_PREFIXtaskId);
38
 
  
39
 
    ALTER TABLE DB_TABLE_PREFIXMaintenanceMap
40
 
      ADD PRIMARY KEY (DB_COLUMN_PREFIXrunId)
41
 
  ;
42
 
  
43
 
 
44
 
    INSERT INTO DB_TABLE_PREFIXSchema (
45
 
      DB_COLUMN_PREFIXname,
46
 
      DB_COLUMN_PREFIXmajor,
47
 
      DB_COLUMN_PREFIXminor
48
 
      ) VALUES (
49
 
      'MaintenanceMap',
50
 
      1,
51
 
      0
52
 
      );
53
 
 
54
 
  
 
 
b'\\ No newline at end of file'