Skip to content

Instantly share code, notes, and snippets.

@magefad
Created February 23, 2013 13:59
Show Gist options
  • Save magefad/5019864 to your computer and use it in GitHub Desktop.
Save magefad/5019864 to your computer and use it in GitHub Desktop.
ALTER TABLE `fad_blog` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `fad_blog` CHANGE `type` `type` BOOLEAN NOT NULL DEFAULT TRUE;
ALTER TABLE `fad_blog_post` CHANGE `access_type` `access_type` BOOLEAN NOT NULL DEFAULT TRUE;
ALTER TABLE `fad_blog_post` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `fad_comment` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `fad_gallery` CHANGE `status` `status` BOOLEAN NOT NULL DEFAULT TRUE;
update `fad_gallery` set status=1;
ALTER TABLE `fad_gallery_photo` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '1';
update `fad_gallery_photo` set status=1;
ALTER TABLE `fad_menu` CHANGE `status` `status` BOOLEAN NOT NULL DEFAULT TRUE;
ALTER TABLE `fad_news` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '1';
update `fad_news` set status=1;
ALTER TABLE `fad_page` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '1';
update `fad_page` set status=1;
ALTER TABLE `fad_user` CHANGE `status` `status` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `fad_user` CHANGE `birth_date` `birth_date` DATE NULL DEFAULT NULL;
ALTER TABLE `fad_user` CHANGE `photo` `photo` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `fad_user` CHANGE `email` `email` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `fad_menu` CHANGE `code` `code` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `href` `href` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
ALTER TABLE `fad_page` CHANGE `keywords` `keywords` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment