EVOLUTION-MANAGER

Edit File: alter_table_drop_primary_key.result

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