diff options
36 files changed, 0 insertions, 206 deletions
diff --git a/src/libraries/qmfclient/qmf.qrc b/src/libraries/qmfclient/qmf.qrc index fb9cbc0b..647cc3b0 100644 --- a/src/libraries/qmfclient/qmf.qrc +++ b/src/libraries/qmfclient/qmf.qrc @@ -1,56 +1,24 @@ <RCC> <qresource prefix="/QmfSql/QSQLITE"> <file alias="mailaccounts">resources/mailaccounts.sqlite.sql</file> - <file alias="mailaccounts-100-101">resources/mailaccounts-100-101.sqlite.sql</file> - <file alias="mailaccounts-101-102">resources/mailaccounts-101-102.sqlite.sql</file> - <file alias="mailaccounts-102-103">resources/mailaccounts-102-103.sqlite.sql</file> - <file alias="mailaccounts-104-105">resources/mailaccounts-104-105.sqlite.sql</file> - <file alias="mailaccounts-105-106">resources/mailaccounts-105-106.sqlite.sql</file> - <file alias="mailaccounts-106-107">resources/mailaccounts-106-107.sqlite.sql</file> <file alias="mailaccountcustom">resources/mailaccountcustom.sqlite.sql</file> <file alias="mailaccountconfig">resources/mailaccountconfig.sqlite.sql</file> <file alias="mailaccountfolders">resources/mailaccountfolders.sqlite.sql</file> <file alias="mailfolders">resources/mailfolders.sqlite.sql</file> - <file alias="mailfolders-101-102">resources/mailfolders-101-102.sqlite.sql</file> - <file alias="mailfolders-102-103">resources/mailfolders-102-103.sqlite.sql</file> - <file alias="mailfolders-103-104">resources/mailfolders-103-104.sqlite.sql</file> - <file alias="mailfolders-104-105">resources/mailfolders-104-105.sqlite.sql</file> - <file alias="mailfolders-105-106">resources/mailfolders-105-106.sqlite.sql</file> <file alias="mailfoldercustom">resources/mailfoldercustom.sqlite.sql</file> <file alias="mailfolderlinks">resources/mailfolderlinks.sqlite.sql</file> <file alias="mailmessages">resources/mailmessages.sqlite.sql</file> - <file alias="mailmessages-100-101">resources/mailmessages-100-101.sqlite.sql</file> - <file alias="mailmessages-101-102">resources/mailmessages-101-102.sqlite.sql</file> - <file alias="mailmessages-102-103">resources/mailmessages-102-103.sqlite.sql</file> - <file alias="mailmessages-103-104">resources/mailmessages-103-104.sqlite.sql</file> - <file alias="mailmessages-104-105">resources/mailmessages-104-105.sqlite.sql</file> - <file alias="mailmessages-106-107">resources/mailmessages-106-107.sqlite.sql</file> - <file alias="mailmessages-107-108">resources/mailmessages-107-108.sqlite.sql</file> - <file alias="mailmessages-108-109">resources/mailmessages-108-109.sqlite.sql</file> - <file alias="mailmessages-109-110">resources/mailmessages-109-110.sqlite.sql</file> - <file alias="mailmessages-110-111">resources/mailmessages-110-111.sqlite.sql</file> - <file alias="mailmessages-111-112">resources/mailmessages-111-112.sqlite.sql</file> - <file alias="mailmessages-112-113">resources/mailmessages-112-113.sqlite.sql</file> - <file alias="mailmessages-113-114">resources/mailmessages-113-114.sqlite.sql</file> <file alias="mailmessagecustom">resources/mailmessagecustom.sqlite.sql</file> - <file alias="mailmessagecustom-100-101">resources/mailmessagecustom-100-101.sqlite.sql</file> <file alias="deletedmessages">resources/deletedmessages.sqlite.sql</file> - <file alias="deletedmessages-100-101">resources/deletedmessages-100-101.sqlite.sql</file> <file alias="mailstatusflags">resources/mailstatusflags.sqlite.sql</file> - <file alias="mailstatusflags-100-101">resources/mailstatusflags-100-101.sqlite.sql</file> <file alias="mailmessageidentifiers">resources/mailmessageidentifiers.sqlite.sql</file> - <file alias="mailmessageidentifiers-100-101">resources/mailmessageidentifiers-100-101.sqlite.sql</file> <file alias="mailsubjects">resources/mailsubjects.sqlite.sql</file> <file alias="mailthreads">resources/mailthreads.sqlite.sql</file> - <file alias="mailthreads-100-101">resources/mailthreads-100-101.sqlite.sql</file> <file alias="mailthreadsubjects">resources/mailthreadsubjects.sqlite.sql</file> <file alias="missingmessages">resources/missingmessages.sqlite.sql</file> - <file alias="missingmessages-100-101">resources/missingmessages-100-101.sqlite.sql</file> <file alias="missingancestors">resources/missingancestors.sqlite.sql</file> - <file alias="missingancestors-100-101">resources/missingancestors-100-101.sqlite.sql</file> <file alias="maintenancerecord">resources/maintenancerecord.sqlite.sql</file> <file alias="obsoletefiles">resources/obsoletefiles.sqlite.sql</file> - <file alias="mailthreads-101-102">resources/mailthreads-101-102.sqlite.sql</file> <file alias="mailaccounts-107-108">resources/mailaccounts-107-108.sqlite.sql</file> </qresource> </RCC> diff --git a/src/libraries/qmfclient/resources/deletedmessages-100-101.sqlite.sql b/src/libraries/qmfclient/resources/deletedmessages-100-101.sqlite.sql deleted file mode 100644 index 3508a662..00000000 --- a/src/libraries/qmfclient/resources/deletedmessages-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE deletedmessages ADD COLUMN parentfolderid INTEGER REFERENCES mailfolders(id); diff --git a/src/libraries/qmfclient/resources/mailaccounts-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailaccounts-100-101.sqlite.sql deleted file mode 100644 index e19c44ba..00000000 --- a/src/libraries/qmfclient/resources/mailaccounts-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailaccounts ADD COLUMN status INTEGER; diff --git a/src/libraries/qmfclient/resources/mailaccounts-101-102.sqlite.sql b/src/libraries/qmfclient/resources/mailaccounts-101-102.sqlite.sql deleted file mode 100644 index 8db00d0c..00000000 --- a/src/libraries/qmfclient/resources/mailaccounts-101-102.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailaccounts ADD COLUMN signature VARCHAR; diff --git a/src/libraries/qmfclient/resources/mailaccounts-102-103.sqlite.sql b/src/libraries/qmfclient/resources/mailaccounts-102-103.sqlite.sql deleted file mode 100644 index 1e63b70a..00000000 --- a/src/libraries/qmfclient/resources/mailaccounts-102-103.sqlite.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE mailaccounts SET status = status | ( SELECT (1 << (max(statusbit) + 0)) FROM mailstatusflags WHERE context = 'accountstatus' ) WHERE type <> 3 AND type <> 5; -UPDATE mailaccounts SET status = status | ( SELECT (1 << (max(statusbit) + 1)) FROM mailstatusflags WHERE context = 'accountstatus' ) WHERE (type == 0 OR type == 1); diff --git a/src/libraries/qmfclient/resources/mailaccounts-104-105.sqlite.sql b/src/libraries/qmfclient/resources/mailaccounts-104-105.sqlite.sql deleted file mode 100644 index f04657fa..00000000 --- a/src/libraries/qmfclient/resources/mailaccounts-104-105.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE mailaccounts SET status = status | ( SELECT (1 << max(statusbit)) FROM mailstatusflags WHERE context = 'accountstatus' ); diff --git a/src/libraries/qmfclient/resources/mailaccounts-105-106.sqlite.sql b/src/libraries/qmfclient/resources/mailaccounts-105-106.sqlite.sql deleted file mode 100644 index 8d87ddce..00000000 --- a/src/libraries/qmfclient/resources/mailaccounts-105-106.sqlite.sql +++ /dev/null @@ -1,14 +0,0 @@ -ALTER TABLE mailaccounts RENAME TO wasmailaccounts; - -CREATE TABLE mailaccounts( - id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, - type INTEGER NOT NULL, - name VARCHAR, - emailaddress VARCHAR, - status INTEGER, - signature VARCHAR); - -INSERT INTO mailaccounts (id, type, name, emailaddress, status, signature) - SELECT id, type, name, emailaddress, status, signature FROM wasmailaccounts; - -DROP TABLE wasmailaccounts; diff --git a/src/libraries/qmfclient/resources/mailaccounts-106-107.sqlite.sql b/src/libraries/qmfclient/resources/mailaccounts-106-107.sqlite.sql deleted file mode 100644 index 1d9736c1..00000000 --- a/src/libraries/qmfclient/resources/mailaccounts-106-107.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailaccounts ADD COLUMN lastsynchronized TIMESTAMP; diff --git a/src/libraries/qmfclient/resources/mailfolders-101-102.sqlite.sql b/src/libraries/qmfclient/resources/mailfolders-101-102.sqlite.sql deleted file mode 100644 index 5cb59322..00000000 --- a/src/libraries/qmfclient/resources/mailfolders-101-102.sqlite.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mailfolders ADD COLUMN servercount INTEGER DEFAULT 0; -ALTER TABLE mailfolders ADD COLUMN serverunreadcount INTEGER DEFAULT 0; diff --git a/src/libraries/qmfclient/resources/mailfolders-102-103.sqlite.sql b/src/libraries/qmfclient/resources/mailfolders-102-103.sqlite.sql deleted file mode 100644 index 036871fd..00000000 --- a/src/libraries/qmfclient/resources/mailfolders-102-103.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailfolders ADD COLUMN serverundiscoveredcount INTEGER DEFAULT 0; diff --git a/src/libraries/qmfclient/resources/mailfolders-103-104.sqlite.sql b/src/libraries/qmfclient/resources/mailfolders-103-104.sqlite.sql deleted file mode 100644 index c6ea4de1..00000000 --- a/src/libraries/qmfclient/resources/mailfolders-103-104.sqlite.sql +++ /dev/null @@ -1,4 +0,0 @@ -UPDATE mailmessages SET parentfolderid=1 WHERE parentfolderid IN (2,3,4,5); -UPDATE mailmessages SET previousparentfolderid=1 WHERE previousparentfolderid IN (2,3,4,5); -DELETE FROM mailfolders WHERE id IN (2,3,4,5); -UPDATE mailfolders SET displayname='Local Storage' WHERE id=1; diff --git a/src/libraries/qmfclient/resources/mailfolders-104-105.sqlite.sql b/src/libraries/qmfclient/resources/mailfolders-104-105.sqlite.sql deleted file mode 100644 index 562a775a..00000000 --- a/src/libraries/qmfclient/resources/mailfolders-104-105.sqlite.sql +++ /dev/null @@ -1,18 +0,0 @@ -ALTER TABLE mailfolders RENAME TO old_mailfolders; - -CREATE TABLE mailfolders ( - id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, - name VARCHAR(255) NOT NULL, - parentid INTEGER, - parentaccountid INTEGER, - status INTEGER, - displayname VARCHAR(255), - servercount INTEGER, - serverunreadcount INTEGER, - serverundiscoveredcount INTEGER, - FOREIGN KEY (parentaccountid) REFERENCES mailaccounts(id), - FOREIGN KEY (parentid) REFERENCES mailfolder(id)); - -INSERT INTO mailfolders SELECT * FROM old_mailfolders; -DROP TABLE old_mailfolders; - diff --git a/src/libraries/qmfclient/resources/mailfolders-105-106.sqlite.sql b/src/libraries/qmfclient/resources/mailfolders-105-106.sqlite.sql deleted file mode 100644 index f2f73f41..00000000 --- a/src/libraries/qmfclient/resources/mailfolders-105-106.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM mailfolders WHERE id = 1; diff --git a/src/libraries/qmfclient/resources/mailmessagecustom-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailmessagecustom-100-101.sqlite.sql deleted file mode 100644 index bb939aca..00000000 --- a/src/libraries/qmfclient/resources/mailmessagecustom-100-101.sqlite.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE mailmessagecustom -SET name = "qmf-content-size" -WHERE name = "qtopiamail-content-size" diff --git a/src/libraries/qmfclient/resources/mailmessageidentifiers-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailmessageidentifiers-100-101.sqlite.sql deleted file mode 100644 index c5a4a82f..00000000 --- a/src/libraries/qmfclient/resources/mailmessageidentifiers-100-101.sqlite.sql +++ /dev/null @@ -1,11 +0,0 @@ -ALTER TABLE mailmessageidentifiers RENAME TO wasmailmessageidentifiers; - -CREATE TABLE mailmessageidentifiers( - id INTEGER, - identifier VARCHAR, - FOREIGN KEY (id) REFERENCES mailmessages(id)); - -INSERT INTO mailmessageidentifiers (id, identifier) - SELECT id, identifier FROM wasmailmessageidentifiers; - -DROP TABLE wasmailmessageidentifiers; diff --git a/src/libraries/qmfclient/resources/mailmessages-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-100-101.sqlite.sql deleted file mode 100644 index f683ae3b..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-100-101.sqlite.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE mailmessages SET mailfile = 'qtopiamailfile:' || mailfile WHERE mailfile <> ''; - diff --git a/src/libraries/qmfclient/resources/mailmessages-101-102.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-101-102.sqlite.sql deleted file mode 100644 index 3dc423d8..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-101-102.sqlite.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mailmessages ADD COLUMN responseid INTEGER; -ALTER TABLE mailmessages ADD COLUMN responsetype INTEGER; diff --git a/src/libraries/qmfclient/resources/mailmessages-102-103.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-102-103.sqlite.sql deleted file mode 100644 index c3f3330f..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-102-103.sqlite.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE mailmessages SET frommailbox = NULL; - diff --git a/src/libraries/qmfclient/resources/mailmessages-103-104.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-103-104.sqlite.sql deleted file mode 100644 index ca7f31eb..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-103-104.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailmessages ADD COLUMN receivedstamp TIMESTAMP; diff --git a/src/libraries/qmfclient/resources/mailmessages-104-105.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-104-105.sqlite.sql deleted file mode 100644 index b1cb2299..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-104-105.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE mailstatusflags SET name = 'ContentAvailable' WHERE name = 'Downloaded' AND context = 'messagestatus'; diff --git a/src/libraries/qmfclient/resources/mailmessages-105-106.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-105-106.sqlite.sql deleted file mode 100644 index 21670f5b..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-105-106.sqlite.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE mailmessages SET status = status - (SELECT 1 << (statusbit-1) FROM mailstatusflags WHERE name = "Read") WHERE status & (SELECT 1 << (statusbit-1) FROM mailstatusflags WHERE name = "Read"); - -UPDATE mailmessages SET status = status | (SELECT 1 << (statusbit-1) FROM mailstatusflags WHERE name = "Read") WHERE status & (SELECT 1 << (statusbit-1) FROM mailstatusflags WHERE name = "ReadElsewhere"); diff --git a/src/libraries/qmfclient/resources/mailmessages-106-107.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-106-107.sqlite.sql deleted file mode 100644 index b5d74554..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-106-107.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE mailmessages SET previousparentfolderid = NULL; diff --git a/src/libraries/qmfclient/resources/mailmessages-107-108.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-107-108.sqlite.sql deleted file mode 100644 index e093cd3c..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-107-108.sqlite.sql +++ /dev/null @@ -1,37 +0,0 @@ -UPDATE mailmessages SET previousparentfolderid = 0 WHERE previousparentfolderid IS NULL; - -ALTER TABLE mailmessages RENAME TO old_mailmessages; - -CREATE TABLE mailmessages ( - id INTEGER PRIMARY KEY NOT NULL, - type INTEGER NOT NULL, - parentfolderid INTEGER NOT NULL, - previousparentfolderid INTEGER NOT NULL, - sender VARCHAR, - recipients VARCHAR, - subject VARCHAR, - stamp TIMESTAMP, - status INTEGER, - parentaccountid INTEGER, - frommailbox VARCHAR, - mailfile VARCHAR, - serveruid VARCHAR, - size INTEGER, - contenttype INTEGER, - responseid INTEGER, - responsetype INTEGER, - receivedstamp TIMESTAMP, - FOREIGN KEY (parentfolderid) REFERENCES mailfolders(id), - FOREIGN KEY (parentaccountid) REFERENCES mailaccounts(id)); - -INSERT INTO mailmessages SELECT * FROM old_mailmessages; -DROP TABLE old_mailmessages; - -CREATE INDEX parentfolderid_idx ON mailmessages("parentfolderid"); -CREATE INDEX parentaccountid_idx ON mailmessages("parentaccountid"); -CREATE INDEX frommailbox_idx ON mailmessages("frommailbox"); -CREATE INDEX stamp_idx ON mailmessages("stamp"); - - - - diff --git a/src/libraries/qmfclient/resources/mailmessages-108-109.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-108-109.sqlite.sql deleted file mode 100644 index aeadb75a..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-108-109.sqlite.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE mailmessages ADD COLUMN copyserveruid VARCHAR NOT NULL DEFAULT ''; -ALTER TABLE mailmessages ADD COLUMN restorefolderid INTEGER NOT NULL DEFAULT 0; -ALTER TABLE mailmessages ADD COLUMN listid VARCHAR NOT NULL DEFAULT ''; -ALTER TABLE mailmessages ADD COLUMN rfcid VARCHAR NOT NULL DEFAULT ''; - -CREATE INDEX rfcid_idx ON mailmessages("rfcid"); diff --git a/src/libraries/qmfclient/resources/mailmessages-109-110.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-109-110.sqlite.sql deleted file mode 100644 index 917efe8f..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-109-110.sqlite.sql +++ /dev/null @@ -1,36 +0,0 @@ -ALTER TABLE mailmessages RENAME TO old_mailmessages; - -CREATE TABLE mailmessages ( - id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, - type INTEGER NOT NULL, - parentfolderid INTEGER NOT NULL, - previousparentfolderid INTEGER NOT NULL, - sender VARCHAR, - recipients VARCHAR, - subject VARCHAR, - stamp TIMESTAMP, - status INTEGER, - parentaccountid INTEGER, - frommailbox VARCHAR, - mailfile VARCHAR, - serveruid VARCHAR, - size INTEGER, - contenttype INTEGER, - responseid INTEGER, - responsetype INTEGER, - receivedstamp TIMESTAMP, - copyserveruid VARCHAR NOT NULL DEFAULT '', - restorefolderid INTEGER NOT NULL DEFAULT 0, - listid VARCHAR NOT NULL DEFAULT '', - rfcid VARCHAR NOT NULL DEFAULT '', - FOREIGN KEY (parentfolderid) REFERENCES mailfolders(id), - FOREIGN KEY (parentaccountid) REFERENCES mailaccounts(id)); - -INSERT INTO mailmessages SELECT * FROM old_mailmessages; -DROP TABLE old_mailmessages; - -CREATE INDEX parentfolderid_idx ON mailmessages("parentfolderid"); -CREATE INDEX parentaccountid_idx ON mailmessages("parentaccountid"); -CREATE INDEX frommailbox_idx ON mailmessages("frommailbox"); -CREATE INDEX stamp_idx ON mailmessages("stamp"); - diff --git a/src/libraries/qmfclient/resources/mailmessages-110-111.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-110-111.sqlite.sql deleted file mode 100644 index b6a1128e..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-110-111.sqlite.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE mailmessages -SET mailfile = "qmfstoragemanager" || substr(mailfile, length("qtopiamailfile")+1, 1000000) -WHERE mailfile like "qtopiamailfile:%"; diff --git a/src/libraries/qmfclient/resources/mailmessages-111-112.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-111-112.sqlite.sql deleted file mode 100644 index 514b828f..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-111-112.sqlite.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mailmessages ADD COLUMN preview VARCHAR NOT NULL DEFAULT ''; - diff --git a/src/libraries/qmfclient/resources/mailmessages-112-113.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-112-113.sqlite.sql deleted file mode 100644 index 83cd9578..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-112-113.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailmessages ADD COLUMN latestinconversation INTEGER; diff --git a/src/libraries/qmfclient/resources/mailmessages-113-114.sqlite.sql b/src/libraries/qmfclient/resources/mailmessages-113-114.sqlite.sql deleted file mode 100644 index e69de29b..00000000 --- a/src/libraries/qmfclient/resources/mailmessages-113-114.sqlite.sql +++ /dev/null diff --git a/src/libraries/qmfclient/resources/mailstatusflags-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailstatusflags-100-101.sqlite.sql deleted file mode 100644 index 4684e341..00000000 --- a/src/libraries/qmfclient/resources/mailstatusflags-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE mailstatusflags SET name='CanTransmit' WHERE context='accountstatus' AND name='CanSend'; diff --git a/src/libraries/qmfclient/resources/mailthreadmessages-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailthreadmessages-100-101.sqlite.sql deleted file mode 100644 index 0d97d5be..00000000 --- a/src/libraries/qmfclient/resources/mailthreadmessages-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -CREATE INDEX threadmessageid_idx ON mailthreadmessages("messageid"); diff --git a/src/libraries/qmfclient/resources/mailthreadmessages-101-102.sqlite.sql b/src/libraries/qmfclient/resources/mailthreadmessages-101-102.sqlite.sql deleted file mode 100644 index 3e8fed91..00000000 --- a/src/libraries/qmfclient/resources/mailthreadmessages-101-102.sqlite.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT INTO mailmessages(threadid) FROM (SELECT id mailthreadmessages) - - -DROP TABLE mailthreadmessages("messageid"); diff --git a/src/libraries/qmfclient/resources/mailthreads-100-101.sqlite.sql b/src/libraries/qmfclient/resources/mailthreads-100-101.sqlite.sql deleted file mode 100644 index c1c9c429..00000000 --- a/src/libraries/qmfclient/resources/mailthreads-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mailthreads ADD COLUMN parentaccountid INTEGER; diff --git a/src/libraries/qmfclient/resources/mailthreads-101-102.sqlite.sql b/src/libraries/qmfclient/resources/mailthreads-101-102.sqlite.sql deleted file mode 100644 index 0ac66a63..00000000 --- a/src/libraries/qmfclient/resources/mailthreads-101-102.sqlite.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM mailthreads; -ALTER TABLE mailthreads ADD COLUMN subject VARCHAR; -ALTER TABLE mailthreads ADD COLUMN preview VARCHAR; -ALTER TABLE mailthreads ADD COLUMN senders VARCHAR; -ALTER TABLE mailthreads ADD COLUMN lastDate TIMESTAMP; -ALTER TABLE mailthreads ADD COLUMN startedDate TIMESTAMP; -ALTER TABLE mailthreads ADD COLUMN status INTEGER; diff --git a/src/libraries/qmfclient/resources/missingancestors-100-101.sqlite.sql b/src/libraries/qmfclient/resources/missingancestors-100-101.sqlite.sql deleted file mode 100644 index eaf451d1..00000000 --- a/src/libraries/qmfclient/resources/missingancestors-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE missingancestors ADD COLUMN state INTEGER DEFAULT 0; diff --git a/src/libraries/qmfclient/resources/missingmessages-100-101.sqlite.sql b/src/libraries/qmfclient/resources/missingmessages-100-101.sqlite.sql deleted file mode 100644 index a6d81278..00000000 --- a/src/libraries/qmfclient/resources/missingmessages-100-101.sqlite.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE missingmessages ADD COLUMN level INTEGER; |