CREATE TABLE `contacts` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) DEFAULT NULL, `address` varchar(64) DEFAULT NULL, `city` varchar(64) DEFAULT NULL, `more_info` tinyint unsigned, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1 |