equal
deleted
inserted
replaced
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 '@' |