DROP TABLE IF EXISTS `certificates_generatedcertificate`;

CREATE TABLE `certificates_generatedcertificate` (`id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `download_url` varchar(128) NOT NULL, `grade` varchar(5) NOT NULL, `course_id` varchar(255) NOT NULL, `key` varchar(32) NOT NULL, `distinction` tinyint(1) NOT NULL, `status` varchar(32) NOT NULL, `verify_uuid` varchar(32) NOT NULL, `download_uuid` varchar(32) NOT NULL, `name` varchar(255) NOT NULL, `created_date` datetime NOT NULL, `modified_date` datetime NOT NULL, `error_reason` varchar(512) NOT NULL, `mode` varchar(32) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `certificates_generatedcertifica_course_id_1389f6b2d72f5e78_uniq` (`course_id`,`user_id`), KEY `certificates_generatedcertificate_fbfc09f1` (`user_id`), KEY `certificates_generatedcertific_verify_uuid_1b5a14bb83c471ff_uniq` (`verify_uuid`)) ENGINE=InnoDB AUTO_INCREMENT=16061337 DEFAULT CHARSET=utf8;

INSERT INTO `certificates_generatedcertificate` VALUES (1, 1, 'example.com', '0.27', 'course-v1:edX+DemoX+Demo_Course', '319a92979a02e7fede3a83f9c1c020c0', 0, 'downloadable', 'a6c04f14d61d49f7981d004ff9433eea', 'ec411520403d4db5acf5add7b9eb8d11', 'John Doe', '2012-11-09 23:13:21', '2012-11-10 00:10:14', '', 'honor'),(2, 2, 'example.com', '0.58', 'course-v1:edX+DemoX+Demo_Course', '0ca7774b84d513fca3e77f66d4015c17', 0, 'downloadable', '079d741605944779921bd8d435e8b82a', '67973c34c2eb43909fb4983f850f3d9d', 'John Doe', '2012-11-09 23:31:34', '2012-11-10 00:05:46', '', 'honor'),(3, 3, 'example.com', '0.0', 'course-v1:edX+DemoX+Demo_Course', '', 0, 'notpassing', '', '', 'Jane Doe', '2012-11-10 00:12:10', '2012-11-26 19:03:01', '', 'honor'),(4, 4, '', '0.0', 'course-v1:edX+DemoX+Demo_Course', '', 0, 'notpassing', '', '', 'John Doe', '2012-11-10 00:12:10', '2012-11-26 19:00:59', '', 'honor');

