Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/056.slowvote.sql
| CREATE TABLE {$NAMESPACE}_slowvote.slowvote_poll ( | CREATE TABLE {$NAMESPACE}_slowvote.slowvote_poll ( | ||||
| id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | ||||
| question VARCHAR(255) NOT NULL, | question VARCHAR(255) NOT NULL, | ||||
| phid VARCHAR(64) BINARY NOT NULL, | phid VARCHAR(64) BINARY NOT NULL, | ||||
| UNIQUE KEY (phid), | UNIQUE KEY (phid), | ||||
| authorPHID VARCHAR(64) BINARY NOT NULL, | authorPHID VARCHAR(64) BINARY NOT NULL, | ||||
| responseVisibility INT UNSIGNED NOT NULL, | responseVisibility INT UNSIGNED NOT NULL, | ||||
| shuffle INT UNSIGNED NOT NULL, | shuffle INT UNSIGNED NOT NULL, | ||||
| Show All 25 Lines | CREATE TABLE {$NAMESPACE}_slowvote.slowvote_choice ( | ||||
| id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | ||||
| pollID INT UNSIGNED NOT NULL, | pollID INT UNSIGNED NOT NULL, | ||||
| KEY (pollID), | KEY (pollID), | ||||
| optionID INT UNSIGNED NOT NULL, | optionID INT UNSIGNED NOT NULL, | ||||
| authorPHID VARCHAR(64) BINARY NOT NULL, | authorPHID VARCHAR(64) BINARY NOT NULL, | ||||
| KEY (authorPHID), | KEY (authorPHID), | ||||
| dateCreated INT UNSIGNED NOT NULL, | dateCreated INT UNSIGNED NOT NULL, | ||||
| dateModified INT UNSIGNED NOT NULL | dateModified INT UNSIGNED NOT NULL | ||||
| ); | ); | ||||
| No newline at end of file | |||||