Skip to content

Instantly share code, notes, and snippets.

@e06widu
Created July 9, 2013 14:02
Show Gist options
  • Select an option

  • Save e06widu/5957587 to your computer and use it in GitHub Desktop.

Select an option

Save e06widu/5957587 to your computer and use it in GitHub Desktop.
CREATE TABLE IF NOT EXISTS `mrl_region` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(200) NOT NULL,
`userId` int(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
INSERT INTO `mrl_region` (`id`, `Name`, `userId`) VALUES
(1, 'ASIA-EAST', 20),
(2, 'ASIA-SOUTH AND SOUTH EAST', 0),
(3, 'AFRICA', 0),
(4, 'AUSTRALIA AND OCEANIA', 0),
(5, 'EASTERN EUROPE AND CIS STATES ', 0),
(6, 'LATIN AMERICA AND CARIBBEAN ', 0),
(7, 'MIDDLE EAST', 0),
(8, 'NORTH AMERICA ', 0),
(9, 'WESTERN EUROPE ', 0);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment