DROP TABLE IF EXISTS `#__test`;
CREATE TABLE `#__test` (
`id` int(11) NOT NULL auto_increment,
`id_test` int(11) NOT NULL,
`published` varchar(25) NOT NULL,
`theme` text character set utf8 NOT NULL,
`questions` int(11) NULL DEFAULT '0',
`performed` int(11) NULL DEFAULT '0',
`gpa` ???(11) NULL DEFAULT '0',
`variant` int(11) NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
INSERT INTO `#__test` (`id`, `id_test`, `published`, `theme`, `questions`, `performed`, `gpa`, `variant`) VALUES
(1, 7636208, 1, 'Biology of human life', 21, 2, '3,5', 4),
(2, 6450272, 0, 'Chemistry of life', 19, 5, '5', 1);
|