/[drupal]/contributions/modules/accounttypes/accounttypes.install
ViewVC logotype

Diff of /contributions/modules/accounttypes/accounttypes.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.1.2.5 by rconstantine, Tue Sep 4 21:38:49 2007 UTC revision 1.1.2.6 by rconstantine, Wed Nov 28 22:36:53 2007 UTC
# Line 33  function accounttypes_install() { Line 33  function accounttypes_install() {
33      case 'pgsql':      case 'pgsql':
34        //I don't really know what I'm doing here, so if I screwed up the pgsql, let me know how to fix it.        //I don't really know what I'm doing here, so if I screwed up the pgsql, let me know how to fix it.
35        $query1 = db_query("CREATE TABLE {accounttypes} (        $query1 = db_query("CREATE TABLE {accounttypes} (
36                    atid serial CHECK (rid >= 0),                    atid SERIAL PRIMARY KEY,
37                    name varchar(64) NOT NULL default '',                    name varchar(64) NOT NULL,
38                    PRIMARY KEY (atid)                    UNIQUE (name)
39                                UNIQUE (name)                    )");
                 )");  
40        $query2 = db_query("CREATE TABLE {accounttypes_roles} (        $query2 = db_query("CREATE TABLE {accounttypes_roles} (
41                    atid int_unsigned NOT NULL default '0',                    atid int NOT NULL default '0',
42                    rid int_unsigned NOT NULL default '0',                    rid int NOT NULL default '0',
43                    initial smallint unsigned NOT NULL default '0',                    initial smallint NOT NULL default '0',
44                    PRIMARY KEY (atid, rid)                    PRIMARY KEY (atid, rid)
45                  )");                    )");
46        $query3 = db_query("CREATE TABLE {accounttypes_users} (        $query3 = db_query("CREATE TABLE {accounttypes_users} (
47                    uid int_unsigned NOT NULL default '0',                    uid int NOT NULL default '0',
48                    atid int_unsigned NOT NULL default '0',                    atid int NOT NULL default '0',
49                    PRIMARY KEY (uid)                    PRIMARY KEY (uid)
50                  )");                    )");
51        break;        break;
52    }    }
53    
Legend:
Removed from v.1.1.2.5  
changed lines
  Added in v.1.1.2.6
  ViewVC Help
Powered by ViewVC 1.1.3