pgsql/create_tables.pgsql
branchv0.6.x
changeset 547 5020c56f9388
parent 538 1f9ea5658627
child 549 44a808af6cf4
equal deleted inserted replaced
546:79f09cdd1a21 547:5020c56f9388
   102     gid         bigint NOT NULL DEFAULT nextval('domain_gid'),
   102     gid         bigint NOT NULL DEFAULT nextval('domain_gid'),
   103     qid         bigint NOT NULL DEFAULT 1, -- default quota limit
   103     qid         bigint NOT NULL DEFAULT 1, -- default quota limit
   104     ssid        bigint NOT NULL DEFAULT 1, -- default service_set
   104     ssid        bigint NOT NULL DEFAULT 1, -- default service_set
   105     tid         bigint NOT NULL DEFAULT 1, -- default transport
   105     tid         bigint NOT NULL DEFAULT 1, -- default transport
   106     domaindir   varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294
   106     domaindir   varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294
   107     note        varchar NULL DEFAULT NULL,
   107     note        text NULL DEFAULT NULL,
   108     CONSTRAINT  pkey_domain_data PRIMARY KEY (gid),
   108     CONSTRAINT  pkey_domain_data PRIMARY KEY (gid),
   109     CONSTRAINT  fkey_domain_data_qid_quotalimit FOREIGN KEY (qid)
   109     CONSTRAINT  fkey_domain_data_qid_quotalimit FOREIGN KEY (qid)
   110         REFERENCES quotalimit (qid),
   110         REFERENCES quotalimit (qid),
   111     CONSTRAINT  fkey_domain_data_ssid_service_set FOREIGN KEY (ssid)
   111     CONSTRAINT  fkey_domain_data_ssid_service_set FOREIGN KEY (ssid)
   112         REFERENCES service_set (ssid),
   112         REFERENCES service_set (ssid),
   131     gid         bigint NOT NULL,
   131     gid         bigint NOT NULL,
   132     mid         bigint NOT NULL DEFAULT 1,
   132     mid         bigint NOT NULL DEFAULT 1,
   133     qid         bigint NULL DEFAULT NULL,
   133     qid         bigint NULL DEFAULT NULL,
   134     ssid        bigint NULL DEFAULT NULL,
   134     ssid        bigint NULL DEFAULT NULL,
   135     tid         bigint NULL DEFAULT NULL,
   135     tid         bigint NULL DEFAULT NULL,
   136     note        varchar NULL DEFAULT NULL,
   136     note        text NULL DEFAULT NULL,
   137     CONSTRAINT  pkey_users PRIMARY KEY (local_part, gid),
   137     CONSTRAINT  pkey_users PRIMARY KEY (local_part, gid),
   138     CONSTRAINT  ukey_users_uid UNIQUE (uid),
   138     CONSTRAINT  ukey_users_uid UNIQUE (uid),
   139     CONSTRAINT  fkey_users_gid_domain_data FOREIGN KEY (gid)
   139     CONSTRAINT  fkey_users_gid_domain_data FOREIGN KEY (gid)
   140         REFERENCES domain_data (gid),
   140         REFERENCES domain_data (gid),
   141     CONSTRAINT  fkey_users_mid_maillocation FOREIGN KEY (mid)
   141     CONSTRAINT  fkey_users_mid_maillocation FOREIGN KEY (mid)