2 files changed, 3 insertions, 0 deletions
diff --git a/data/scripts/migrate_1.sql b/data/scripts/migrate_1.sql
index 39e2d70..1ced1dd 100644
--- a/data/scripts/migrate_1.sql
+++ b/data/scripts/migrate_1.sql
@@ -24,6 +24,7 @@
 -- isolate old data
 ALTER TABLE PERMISSION_TABLE RENAME TO OLD_PERMISSION_TABLE;
 DROP INDEX perm_index_idx;
+DROP INDEX ckm_index_label;
 
 
 -- create new structure
diff --git a/data/scripts/migrate_2.sql b/data/scripts/migrate_2.sql
index 5c629fe..8bd2fd2 100644
--- a/data/scripts/migrate_2.sql
+++ b/data/scripts/migrate_2.sql
@@ -23,12 +23,14 @@
 
 -- isolate old data
 DROP INDEX perm_index_idx;
+DROP INDEX name_index_idx;
 
 
 -- create new structure
 CREATE TABLE SCHEMA_INFO(name TEXT PRIMARY KEY NOT NULL,
                          value TEXT);
 ALTER TABLE NAME_TABLE RENAME TO NAMES;
+CREATE INDEX name_index_idx ON NAMES(idx);
 -- need to create OBJECT table from scratch,
 -- as SQLite does not support "ALTER COLUMN"
 -- (REFERENCES NAME_TABLE --> NAMES)