← Back to branch summary

~ubuntu-branches/ubuntu/quantal/gallery2/quantal

« back to all changes in this revision

Viewing changes to modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryPluginMap.sql

  • Committer: Bazaar Package Importer
  • Author(s): Michael C. Schultheiss
  • Date: 2005-11-29 15:50:12 UTC
  • Revision ID: james.westby@ubuntu.com-20051129155012-wtophp03lu01kdgl
Tags: upstream-2.0.2
Import upstream version 2.0.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryPluginMap.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_PREFIXPluginMap (
 
7
  DB_COLUMN_PREFIXpluginType
 
8
      VARCHAR(
 
9
      
 
10
          32
 
11
        
 
12
      )
 
13
    
 
14
      NOT NULL
 
15
    
 
16
      ,
 
17
    DB_COLUMN_PREFIXpluginId
 
18
      VARCHAR(
 
19
      
 
20
          32
 
21
        
 
22
      )
 
23
    
 
24
      NOT NULL
 
25
    
 
26
      ,
 
27
    DB_COLUMN_PREFIXactive
 
28
      SMALLINT
 
29
    
 
30
      NOT NULL
 
31
    
 
32
    );
 
33
 
 
34
  
 
35
    ALTER TABLE DB_TABLE_PREFIXPluginMap
 
36
    ADD PRIMARY KEY (DB_COLUMN_PREFIXpluginType
 
37
        ,
 
38
      DB_COLUMN_PREFIXpluginId);
 
39
    
 
40
 
 
41
    INSERT INTO DB_TABLE_PREFIXSchema (
 
42
      DB_COLUMN_PREFIXname,
 
43
      DB_COLUMN_PREFIXmajor,
 
44
      DB_COLUMN_PREFIXminor
 
45
      ) VALUES (
 
46
      'PluginMap',
 
47
      1,
 
48
      1
 
49
      );
 
50
 
 
51
  
 
 
b'\\ No newline at end of file'