17 lines
315 B
MySQL
17 lines
315 B
MySQL
|
create or replace table accountpolls
|
||
|
|
(
|
||
|
|
id int auto_increment,
|
||
|
|
accountId int not null,
|
||
|
|
pollId int not null,
|
||
|
|
value tinyint not null,
|
||
|
|
primary key (id, accountId, pollId)
|
||
|
|
)
|
||
|
|
charset=latin1;
|
||
|
|
|
||
|
|
create or replace index accountId
|
||
|
|
on accountpolls (accountId);
|
||
|
|
|
||
|
|
create or replace index pollId
|
||
|
|
on accountpolls (pollId);
|
||
|
|
|