Skip to content

Instantly share code, notes, and snippets.

@Yaffle
Created January 1, 2012 18:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Yaffle/1547957 to your computer and use it in GitHub Desktop.
Save Yaffle/1547957 to your computer and use it in GitHub Desktop.
CREATE TABLE IF NOT EXISTS `rabota_ids` (
`ID` varchar( 255 ) NOT NULL DEFAULT '',
`region` varchar( 1 ) NOT NULL ,
`parsed` varchar( 1 ) DEFAULT '0',
`added` date NOT NULL ,
UNIQUE KEY `ID` ( `ID` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;
ALTER TABLE `zarplata_v` CHANGE `source` `source` ENUM( '0', '1', '2', '3', '4' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `zarplata_r` CHANGE `source` `source` ENUM( '0', '1', '2', '3', '4' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment