pgsql/create_tables.pgsql
branchv0.6.x
changeset 387 05dc4e1f8dff
parent 382 5e6bcb2e010e
child 388 dd95ed5bc9d2
equal deleted inserted replaced
386:b7854259ad74 387:05dc4e1f8dff
   117     uid         bigint NOT NULL,
   117     uid         bigint NOT NULL,
   118     path        varchar(16) NOT NULL,
   118     path        varchar(16) NOT NULL,
   119     current     bigint NOT NULL DEFAULT 0,
   119     current     bigint NOT NULL DEFAULT 0,
   120     CONSTRAINT  pkey_userquota_11 PRIMARY KEY (uid, path),
   120     CONSTRAINT  pkey_userquota_11 PRIMARY KEY (uid, path),
   121     CONSTRAINT  fkey_userquota_11_uid_users FOREIGN KEY (uid)
   121     CONSTRAINT  fkey_userquota_11_uid_users FOREIGN KEY (uid)
   122         REFERENCES users (uid)
   122         REFERENCES users (uid) ON DELETE CASCADE
   123 );
   123 );
   124 
   124 
   125 CREATE TABLE alias (
   125 CREATE TABLE alias (
   126     gid         bigint NOT NULL,
   126     gid         bigint NOT NULL,
   127     address     varchar(64) NOT NULL,-- only localpart w/o '@'
   127     address     varchar(64) NOT NULL,-- only localpart w/o '@'