Network System Laboratory - Backup diff of MySQL/ALTER(No. 4)

View the diff current.
View the source.
Go to MySQL/ALTER.

--- 3: 2016-08-01 (Mon) 17:29:41 iseki
+++ 4: 2016-08-03 (Wed) 19:09:14 iseki
@@ Line 1: / Line 1: @@
 *** ALTER コマンド [#m9239700]
 **** テーブルのコメントを変更 [#r765496a]
- alter table transactions COMMENT='Rev.11';
+ALTER TABLE transactions COMMENT='Rev.11';
 **** 項目を削除して，コメントを変更 [#cbea6952]
- alter table userinfo drop class, COMMENT='Rev.3';
+ ALTER TABLE userinfo DROP class, COMMENT='Rev.3';
+**** インデックスキーの登録 [#i1d8378f]
+ ALTER TABLE assets ADD INDEX CreatorID(CreatorID);
+- キーの確認
+ SHOW INDEX FROM assets
+**** インデックスキーの削除 [#d00a289c]
+ ALTER TABLE assets DROP INDEX CreatorID;
 *** RollBack to 0.8.2 [#f2769176]
  alter table userinfo drop type;