}
public void upgradeDb(String version) {
- if (version.equals("0.85")) {
- executeSql("alter table note add column titleColor integer");
- executeSql("alter table note add column thumbnail blob");
- executeSql("alter table note add column thumbnailneeded boolean");
- executeSql("Update note set thumbnailneeded = true;");
- executeSql("create index NOTE_NOTEBOOK_INDEX on note (notebookguid, guid);");
- executeSql("create index NOTETAGS_TAG_INDEX on notetags (tagguid, noteguid);");
- version = "0.86";
- Global.setDatabaseVersion(version);
- }
- if (version.equals("0.86")) {
-
- executeSql("alter table notebook add column publishingUri VarChar");
- executeSql("alter table notebook add column publishingOrder Integer");
- executeSql("alter table notebook add column publishingAscending Boolean");
- executeSql("alter table notebook add column publishingPublicDescription varchar");
- executeSql("alter table notebook add column stack varchar");
- executeSql("alter table notebook add column icon blob");
- executeSql("alter table notebook add column readOnly boolean");
- executeSql("alter table notebook add column linked boolean");
-
- executeSql("alter table tag add column realname varchar");
- executeSql("alter table tag add column linked boolean");
- executeSql("alter table tag add column icon blob");
- executeSql("alter table tag add column notebookguid varchar");
- executeSql("alter table SavedSearch add column icon blob");
-
- executeSql("create index NOTE_THUMBNAIL_INDEX on note (thumbnailneeded, guid);");
- executeSql("create index NOTE_EXPUNGED_INDEX on note (isExpunged, guid);");
- executeSql("create index NOTE_DUEDATE_INDEX on note (attributeSubjectDate, guid);");
- executeSql("create index TAG_NOTEBOOK_INDEX on tag (notebookGuid);");
-
- executeSql("update note set thumbnailneeded=true, thumbnail=null;");
- executeSql("update notebook set publishingUri='', " +
- "publishingAscending=false, stack='', readonly=false, publishingOrder=1, " +
- "publishingPublicDescription='', linked=false");
- executeSql("update tag set linked=false, realname='', notebookguid=''");
-
- sharedNotebookTable.createTable();
- linkedNotebookTable.createTable();
- systemIconTable.createTable();
- inkImagesTable.createTable();
-
- version = "0.95";
- executeSql("Insert into Sync (key, value) values ('FullNotebookSync', 'true')");
- executeSql("Insert into Sync (key, value) values ('FullLinkedNotebookSync', 'true')");
- executeSql("Insert into Sync (key, value) values ('FullSharedNotebookSync', 'true')");
- executeSql("Insert into Sync (key, value) values ('FullInkNoteImageSync', 'true')");
- Global.setDatabaseVersion(version);
- }
- if (version.equals("0.95")) {
- if (dbTableExists("words"))
- executeSql("Drop table words;");
- if (dbTableExists("NoteResources"))
- executeSql("Drop table NoteResources;");
- }
if (!dbTableColumnExists("NOTE", "ORIGINAL_GUID")) {
executeSql("alter table note add column ORIGINAL_GUID VarChar");
executeSql("create index NOTE_ORIGINAL_GUID_INDEX on note (original_guid, guid);");