Skip to content

Instantly share code, notes, and snippets.

@atme
Last active August 29, 2015 14:21
Show Gist options
  • Select an option

  • Save atme/37005f6384bbdb2ec13d to your computer and use it in GitHub Desktop.

Select an option

Save atme/37005f6384bbdb2ec13d to your computer and use it in GitHub Desktop.
ALTER TABLE some_table ADD(
`created` bigint(11) NOT NULL,
`author` int(11) NOT NULL,
`last_author` int(11) NOT NULL,
`last_edit` bigint(11) NOT NULL,
`seo_index` tinyint(1) NOT NULL DEFAULT '1',
`seo_title` varchar(256) NOT NULL,
`seo_h1` varchar(256) NOT NULL,
`seo_description` varchar(512) NOT NULL,
`seo_keywords` varchar(512) NOT NULL,
`social_likes` tinyint(1) NOT NULL,
`social_comments_vk` tinyint(1) NOT NULL,
`social_comments_fb` tinyint(1) NOT NULL,
`seo_show_sitemap_xml` tinyint(1) NOT NULL,
`seo_show_sitemap_html` tinyint(1) NOT NULL,
`seo_robots` varchar(64) NOT NULL,
`seo_sitemap_changefreq` varchar(64) NOT NULL,
`seo_sitemap_lastmod` varchar(64) NOT NULL,
`seo_sitemap_priority` varchar(64) NOT NULL
)
ALTER TABLE `categories` ADD `seo_title_en` VARCHAR( 256 ) NOT NULL AFTER `seo_keywords` ,
ADD `seo_h1_en` VARCHAR( 256 ) NOT NULL AFTER `seo_title_en` ,
ADD `seo_description_en` VARCHAR( 512 ) NOT NULL AFTER `seo_h1_en` ,
ADD `seo_keywords_en` VARCHAR( 512 ) NOT NULL AFTER `seo_description_en` ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment