Merge pull request apolloconfig#538 from nobodyiam/delta-sql

lepdou · web-flow · commit d5a9c5fedf3e · 2017-02-10T10:20:40.000+08:00
add delta schema to upgrade db from v0.4.0 to v0.5.0
diff --git a/scripts/sql/delta/v040-v050/apolloconfigdb-v040-v050.sql b/scripts/sql/delta/v040-v050/apolloconfigdb-v040-v050.sql
@@ -0,0 +1,11 @@
+# delta schema to upgrade apollo config db from v0.4.0 to v0.5.0
+
+Use ApolloConfigDB;
+
+DROP TABLE `Privilege`;
+ALTER TABLE `Release` DROP `Status`;
+ALTER TABLE `Namespace` ADD KEY `IX_NamespaceName` (`NamespaceName`(191));
+ALTER TABLE `Cluster` ADD KEY `IX_ParentClusterId` (`ParentClusterId`);
+ALTER TABLE `AppNamespace` ADD KEY `IX_AppId` (`AppId`);
+ALTER TABLE `App` DROP INDEX `Name`;
+ALTER TABLE `App` ADD KEY `Name` (`Name`);
diff --git a/scripts/sql/delta/v040-v050/apolloportaldb-v040-v050.sql b/scripts/sql/delta/v040-v050/apolloportaldb-v040-v050.sql
@@ -0,0 +1,7 @@
+# delta schema to upgrade apollo portal db from v0.4.0 to v0.5.0
+
+Use ApolloPortalDB;
+
+ALTER TABLE `AppNamespace` ADD KEY `IX_AppId` (`AppId`);
+ALTER TABLE `App` DROP INDEX `Name`;
+ALTER TABLE `App` ADD KEY `Name` (`Name`);
