Subversion Repositories VORC

## Table: general_survey_question
#
# +----------+------------------+------+-----+---------+----------------+
# | Field    | Type             | Null | Key | Default | Extra          |
# +----------+------------------+------+-----+---------+----------------+
# | qid      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
# | qorder   | int(10) unsigned | NO   |     | NULL    |                |
# | question | varchar(255)     | NO   |     | NULL    |                |
# | type     | varchar(45)      | NO   |     | NULL    |                |
# | required | tinyint(4)       | NO   |     | NULL    |                |
# | private  | tinyint(4)       | NO   |     | 0       |                |
# | added    | datetime         | NO   |     | NULL    |                |
# +----------+------------------+------+-----+---------+----------------+

CREATE TABLE `general_survey_question` (
  `qid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `qorder` int(10) unsigned NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(4) NOT NULL,
  `private` tinyint(4) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL,
  PRIMARY KEY (`qid`),
  UNIQUE KEY `qid_UNIQUE` (`qid`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci