Skip to content

Instantly share code, notes, and snippets.

@erikfrey

erikfrey/gist:641123

Created October 22, 2010 18:35
Show Gist options
  • Save erikfrey/641123 to your computer and use it in GitHub Desktop.
Save erikfrey/641123 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
ALTER TABLE `fact`.`news_events_clue` MODIFY COLUMN `article_id` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
MODIFY COLUMN `relation` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
MODIFY COLUMN `primary_parameters` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
MODIFY COLUMN `optional_parameters` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
MODIFY COLUMN `sentence` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
MODIFY COLUMN `version` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment