tizen 2.4 release

[framework/security/key-manager.git] / data / scripts / migrate_2.sql

diff --git a/data/scripts/migrate_2.sql b/data/scripts/migrate_2.sql
index 5c629fe..8bd2fd2 100644 (file)
--- 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)