key ID_2
Hej med jer, jeg skal oprette denne tabel på min server. Hvor i phpmyadmin skal jeg indføre. ID er både Primary Key og Unique ID er det i ordenUNIQUE ID (ID, PollName),
KEY ID_2 (ID)
CREATE TABLE pollcontent (
ID int(11) NOT NULL auto_increment,
PollName varchar(40) NOT NULL,
Question mediumtext NOT NULL,
Selection1 mediumtext NOT NULL,
Selection2 mediumtext NOT NULL,
Selection3 mediumtext NOT NULL,
Selection4 mediumtext NOT NULL,
Selection5 mediumtext NOT NULL,
Selection6 mediumtext NOT NULL,
Selection7 mediumtext NOT NULL,
Selection8 mediumtext NOT NULL,
Selection9 mediumtext NOT NULL,
Selection10 mediumtext NOT NULL,
Selection11 mediumtext NOT NULL,
Selection12 mediumtext NOT NULL,
Selection13 mediumtext NOT NULL,
Selection14 mediumtext NOT NULL,
Selection15 mediumtext NOT NULL,
Selection16 mediumtext NOT NULL,
Selection17 mediumtext NOT NULL,
Selection18 mediumtext NOT NULL,
Selection19 mediumtext NOT NULL,
Selection20 mediumtext NOT NULL,
Status varchar(10) NOT NULL,
PRIMARY KEY (ID),
UNIQUE ID (ID, PollName),
KEY ID_2 (ID)
);
