 DROP TABLE IF EXISTS `countries`;
 CREATE TABLE IF NOT EXISTS `countries` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `name` varchar(250) NOT NULL,
+  `name` varchar(10) NOT NULL,
+  `abbr` varchar(10) NOT NULL,
+  `code` char(11) NOT NULL,
   `slug` char(100) NOT NULL,
   `status` smallint(1) unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),

  KEY `institution_id` (`institution_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='advertisement table';


-- --------------------------------------------------------


-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `abbr` , `code`, `slug`, `status`) VALUES(1, 'Philippines', 'PH', 63 ,'test', 1);

-- --------------------------------------------------------
--
