Subversion Repositories VORC

## Table: general_survey_answer
#
# +----------+------------------+------+-----+---------+----------------+
# | Field    | Type             | Null | Key | Default | Extra          |
# +----------+------------------+------+-----+---------+----------------+
# | aid      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
# | qid      | int(10) unsigned | NO   | MUL | NULL    |                |
# | uid      | int(11) unsigned | NO   |     | NULL    |                |
# | response | varchar(1024)    | YES  |     | NULL    |                |
# | added    | datetime         | NO   |     | NULL    |                |
# | page     | int(11)          | NO   |     | NULL    |                |
# | maxpage  | int(11) unsigned | NO   |     | NULL    |                |
# +----------+------------------+------+-----+---------+----------------+

CREATE TABLE `general_survey_answer` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `qid` int(10) unsigned NOT NULL,
  `uid` int(11) unsigned NOT NULL,
  `response` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `added` datetime NOT NULL,
  `page` int(11) NOT NULL,
  `maxpage` int(11) unsigned NOT NULL,
  PRIMARY KEY (`aid`),
  UNIQUE KEY `aid_UNIQUE` (`aid`),
  UNIQUE KEY `qid_RCid_page_UNIQUE` (`qid`,`uid`,`page`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci