create database moodletest;

use moodletest;

CREATE TABLE `mdl_choice` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `course` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `format` tinyint(2) unsigned NOT NULL default '0',
  `publish` tinyint(2) unsigned NOT NULL default '0',
  `release` tinyint(2) unsigned NOT NULL default '0',
  `display` int(4) unsigned NOT NULL default '0',
  `allowupdate` tinyint(2) unsigned NOT NULL default '0',
  `showunanswered` tinyint(2) unsigned NOT NULL default '0',
  `limitanswers` tinyint(3) unsigned NOT NULL default '0',
  `timeopen` int(10) unsigned NOT NULL default '0',
  `timeclose` int(10) unsigned NOT NULL default '0',
  `timemodified` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `course` (`course`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Available choices are stored here.' AUTO_INCREMENT=17 ;


INSERT INTO mdl_choice ( COURSE, NAME, TEXT, FORMAT, `RELEASE`, DISPLAY, ALLOWUPDATE, SHOWUNANSWERED, LIMITANSWERS, TIMEOPEN, TIMECLOSE, TIMEMODIFIED ) VALUES ( 630, 'Ice Cream', 'What flavor is your favorite? ', 1, 0, 0, 0, 0, 0, 0, 0, 1121535063 );

INSERT INTO mdl_choice ( COURSE, NAME, TEXT, FORMAT, RELEASE, DISPLAY, ALLOWUPDATE, SHOWUNANSWERED, LIMITANSWERS, TIMEOPEN, TIMECLOSE, TIMEMODIFIED ) VALUES ( 630, 'Ice Cream', 'What flavor is your favorite? ', 1, 0, 0, 0, 0, 0, 0, 0, 1121535063 );