-- SQL for the test table
--
-- Table person
--
CREATE TABLE `person` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(120) collate latin1_general_ci NOT NULL,
`age` int(3) NOT NULL,
`description` text collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
|