equal
deleted
inserted
replaced
117 uid bigint NOT NULL, |
117 uid bigint NOT NULL, |
118 bytes bigint NOT NULL DEFAULT 0, |
118 bytes bigint NOT NULL DEFAULT 0, |
119 messages integer NOT NULL DEFAULT 0, |
119 messages integer NOT NULL DEFAULT 0, |
120 CONSTRAINT pkey_userquota PRIMARY KEY (uid), |
120 CONSTRAINT pkey_userquota PRIMARY KEY (uid), |
121 CONSTRAINT fkey_userquota_uid_users FOREIGN KEY (uid) |
121 CONSTRAINT fkey_userquota_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 '@' |