Skip to content

Instantly share code, notes, and snippets.

View sergiy's full-sized avatar

Sergiy Tytarenko sergiy

View GitHub Profile
@sergiy
sergiy / shadow_example.sql
Created July 19, 2012 14:32
online schema change
/*
-- existing table structure, missing index for the field1
CREATE TABLE IF NOT EXISTS `table1` (
`id` int(11) NOT NULL auto_increment,
`field1` int(11) not null,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
*/