diff options
author | msquare <msquare@notrademark.de> | 2014-11-25 18:38:18 +0100 |
---|---|---|
committer | msquare <msquare@notrademark.de> | 2014-11-25 18:38:18 +0100 |
commit | 82ad127fc9b2df4360cc191d14e1c7f9f38bd7bb (patch) | |
tree | 275afd4ba36e95dd411eb1be75483ae022fc74da /db/install.sql | |
parent | 17c41d821cdcb16b1374d6e6ba0635fabc49e987 (diff) | |
parent | 48c8ddaa445863ec9008a831f2045d0e010d7f3c (diff) |
Merge pull request #160 from robofish/questionFix
Fixed database schema to allow questions again
Diffstat (limited to 'db/install.sql')
-rw-r--r-- | db/install.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/install.sql b/db/install.sql index 1fc4b939..947eb51e 100644 --- a/db/install.sql +++ b/db/install.sql @@ -288,8 +288,8 @@ CREATE TABLE IF NOT EXISTS `Questions` ( `QID` bigint(20) NOT NULL AUTO_INCREMENT, `UID` int(11) NOT NULL DEFAULT '0', `Question` text NOT NULL, - `AID` int(11) NOT NULL DEFAULT '0', - `Answer` text NOT NULL, + `AID` int(11) DEFAULT NULL, + `Answer` text, PRIMARY KEY (`QID`), KEY `UID` (`UID`), KEY `AID` (`AID`) |