16 lines
437 B
MySQL
16 lines
437 B
MySQL
|
-- drop unique constraint for motion by specific voter from votes
|
||
|
|
CREATE TABLE votes_new
|
||
|
|
(
|
||
|
|
decision INTEGER NOT NULL,
|
||
|
|
voter INTEGER NOT NULL,
|
||
|
|
vote INTEGER NOT NULL,
|
||
|
|
voted DATETIME NOT NULL,
|
||
|
|
notes TEXT NOT NULL DEFAULT ''
|
||
|
|
);
|
||
|
|
|
||
|
|
INSERT INTO votes_new (decision, voter, vote, voted, notes)
|
||
|
|
SELECT decision, voter, vote, voted, notes
|
||
|
|
FROM votes;
|
||
|
|
|
||
|
|
DROP TABLE votes;
|
||
|
|
ALTER TABLE votes_new RENAME TO votes;
|