Subversion Repositories VORC

## Table: survey_answer
#
# +----------+------------------+------+-----+---------+----------------+
# | Field    | Type             | Null | Key | Default | Extra          |
# +----------+------------------+------+-----+---------+----------------+
# | aid      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
# | classid  | int(10) unsigned | NO   | MUL | NULL    |                |
# | qid      | int(10) unsigned | NO   |     | NULL    |                |
# | RCid     | 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 `survey_answer` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `classid` int(10) unsigned NOT NULL,
  `qid` int(10) unsigned NOT NULL,
  `RCid` 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` (`classid`,`qid`,`RCid`,`page`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci