EVOLUTION-MANAGER

Edit File: alter_table_add_primary_key.result

DROP TABLE IF EXISTS ids; CREATE TABLE ids ( id INT NOT NULL ) ENGINE=Mroonga DEFAULT CHARSET=utf8; INSERT INTO ids VALUES (1); INSERT INTO ids VALUES (2); ALTER TABLE ids ADD PRIMARY KEY (id); SHOW CREATE TABLE ids; Table Create Table ids CREATE TABLE `ids` ( `id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 SELECT * FROM ids WHERE id = 2; id 2 DROP TABLE ids;