X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=schema.sql;fp=schema.sql;h=700c2a3119a09f02d260b3b94e352b78719e044f;hb=f43f9263fc772dd9efcaeb62eff129d847ff9e86;hp=757b695613170ce1c7a0b9821f96eb4e1046837e;hpb=16be4472e8582f8d8d966b625165ef2e57fc21df;p=cavote.git diff --git a/schema.sql b/schema.sql index 757b695..700c2a3 100644 --- a/schema.sql +++ b/schema.sql @@ -47,7 +47,7 @@ create table votes ( is_weighted BOOLEAN DEFAULT 0 NOT NULL, is_open BOOLEAN DEFAULT 0 NOT NULL, is_terminated BOOLEAN DEFAULT 0 NOT NULL, - id_author INTEGER DEFAULT 1 NOT NULL, -- :COMMENT:maethor:120528: not null ? + id_author INTEGER DEFAULT 1 NOT NULL, id_group INTEGER DEFAULT 1 NOT NULL, FOREIGN KEY(id_author) REFERENCES users (id) ON DELETE SET DEFAULT, FOREIGN KEY(id_group) REFERENCES groups (id),