/kf6-qt6/pim/akonadi/autotests/server/dbtest_data/dbinit_mysql_incremental

0001 ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0
0002
0003 ALTER TABLE SchemaVersionTable ADD COLUMN generation INTEGER NOT NULL DEFAULT 0
0004
0005 ALTER TABLE ResourceTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0006
0007 ALTER TABLE ResourceTable ADD COLUMN name VARBINARY(255) NOT NULL UNIQUE
0008
0009 ALTER TABLE ResourceTable ADD COLUMN isVirtual BOOL DEFAULT false
0010
0011 ALTER TABLE CollectionTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0012
0013 ALTER TABLE CollectionTable ADD COLUMN remoteId VARBINARY(255)
0014
0015 ALTER TABLE CollectionTable ADD COLUMN remoteRevision VARBINARY(255)
0016
0017 ALTER TABLE CollectionTable ADD COLUMN name VARBINARY(255) NOT NULL
0018
0019 ALTER TABLE CollectionTable ADD COLUMN parentId BIGINT
0020
0021 ALTER TABLE CollectionTable ADD COLUMN resourceId BIGINT NOT NULL
0022
0023 ALTER TABLE CollectionTable ADD COLUMN enabled BOOL NOT NULL DEFAULT true
0024
0025 ALTER TABLE CollectionTable ADD COLUMN syncPref TINYINT DEFAULT 2
0026
0027 ALTER TABLE CollectionTable ADD COLUMN displayPref TINYINT DEFAULT 2
0028
0029 ALTER TABLE CollectionTable ADD COLUMN indexPref TINYINT DEFAULT 2
0030
0031 ALTER TABLE CollectionTable ADD COLUMN referenced BOOL NOT NULL DEFAULT false
0032
0033 ALTER TABLE CollectionTable ADD COLUMN cachePolicyInherit BOOL NOT NULL DEFAULT true
0034
0035 ALTER TABLE CollectionTable ADD COLUMN cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1
0036
0037 ALTER TABLE CollectionTable ADD COLUMN cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1
0038
0039 ALTER TABLE CollectionTable ADD COLUMN cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false
0040
0041 ALTER TABLE CollectionTable ADD COLUMN cachePolicyLocalParts VARBINARY(255)
0042
0043 ALTER TABLE CollectionTable ADD COLUMN queryString VARBINARY(32768)
0044
0045 ALTER TABLE CollectionTable ADD COLUMN queryAttributes VARBINARY(255)
0046
0047 ALTER TABLE CollectionTable ADD COLUMN queryCollections VARBINARY(255)
0048
0049 ALTER TABLE CollectionTable ADD COLUMN isVirtual BOOL DEFAULT false
0050
0051 ALTER TABLE MimeTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0052
0053 ALTER TABLE MimeTypeTable ADD COLUMN name VARBINARY(255) NOT NULL UNIQUE
0054
0055 ALTER TABLE PimItemTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0056
0057 ALTER TABLE PimItemTable ADD COLUMN rev INTEGER NOT NULL DEFAULT 0
0058
0059 ALTER TABLE PimItemTable ADD COLUMN remoteId VARBINARY(255)
0060
0061 ALTER TABLE PimItemTable ADD COLUMN remoteRevision VARBINARY(255)
0062
0063 ALTER TABLE PimItemTable ADD COLUMN gid VARBINARY(255)
0064
0065 ALTER TABLE PimItemTable ADD COLUMN collectionId BIGINT
0066
0067 ALTER TABLE PimItemTable ADD COLUMN mimeTypeId BIGINT
0068
0069 ALTER TABLE PimItemTable ADD COLUMN datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP
0070
0071 ALTER TABLE PimItemTable ADD COLUMN atime TIMESTAMP DEFAULT CURRENT_TIMESTAMP
0072
0073 ALTER TABLE PimItemTable ADD COLUMN dirty BOOL
0074
0075 ALTER TABLE PimItemTable ADD COLUMN size BIGINT NOT NULL DEFAULT 0
0076
0077 ALTER TABLE FlagTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0078
0079 ALTER TABLE FlagTable ADD COLUMN name VARBINARY(255) NOT NULL UNIQUE
0080
0081 ALTER TABLE PartTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0082
0083 ALTER TABLE PartTypeTable ADD COLUMN name VARBINARY(255) NOT NULL
0084
0085 ALTER TABLE PartTypeTable ADD COLUMN ns VARBINARY(255) NOT NULL
0086
0087 ALTER TABLE PartTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0088
0089 ALTER TABLE PartTable ADD COLUMN pimItemId BIGINT NOT NULL
0090
0091 ALTER TABLE PartTable ADD COLUMN data LONGBLOB
0092
0093 ALTER TABLE PartTable ADD COLUMN datasize BIGINT NOT NULL
0094
0095 ALTER TABLE PartTable ADD COLUMN version INTEGER DEFAULT 0
0096
0097 ALTER TABLE PartTable ADD COLUMN storage TINYINT DEFAULT 0
0098
0099 ALTER TABLE CollectionAttributeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0100
0101 ALTER TABLE CollectionAttributeTable ADD COLUMN collectionId BIGINT NOT NULL
0102
0103 ALTER TABLE CollectionAttributeTable ADD COLUMN type LONGBLOB NOT NULL
0104
0105 ALTER TABLE CollectionAttributeTable ADD COLUMN value LONGBLOB
0106
0107 ALTER TABLE TagTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0108
0109 ALTER TABLE TagTypeTable ADD COLUMN name VARBINARY(255) NOT NULL UNIQUE
0110
0111 ALTER TABLE TagTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0112
0113 ALTER TABLE TagTable ADD COLUMN gid VARBINARY(255) NOT NULL
0114
0115 ALTER TABLE TagTable ADD COLUMN parentId BIGINT
0116
0117 ALTER TABLE TagTable ADD COLUMN typeId BIGINT DEFAULT 1
0118
0119 ALTER TABLE TagAttributeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0120
0121 ALTER TABLE TagAttributeTable ADD COLUMN tagId BIGINT NOT NULL
0122
0123 ALTER TABLE TagAttributeTable ADD COLUMN type LONGBLOB NOT NULL
0124
0125 ALTER TABLE TagAttributeTable ADD COLUMN value LONGBLOB
0126
0127 ALTER TABLE TagRemoteIdResourceRelationTable ADD COLUMN tagId BIGINT NOT NULL
0128
0129 ALTER TABLE TagRemoteIdResourceRelationTable ADD COLUMN resourceId BIGINT NOT NULL
0130
0131 ALTER TABLE TagRemoteIdResourceRelationTable ADD COLUMN remoteId VARBINARY(255) NOT NULL
0132
0133 ALTER TABLE RelationTypeTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY
0134
0135 ALTER TABLE RelationTypeTable ADD COLUMN name VARBINARY(255) NOT NULL UNIQUE
0136
0137 ALTER TABLE RelationTable ADD COLUMN leftId BIGINT NOT NULL
0138
0139 ALTER TABLE RelationTable ADD COLUMN rightId BIGINT NOT NULL
0140
0141 ALTER TABLE RelationTable ADD COLUMN typeId BIGINT DEFAULT 1
0142
0143 ALTER TABLE RelationTable ADD COLUMN remoteId VARBINARY(255)
0144
0145 ALTER TABLE PimItemFlagRelation ADD COLUMN PimItem_id BIGINT NOT NULL
0146
0147 ALTER TABLE PimItemFlagRelation ADD COLUMN Flag_id BIGINT NOT NULL
0148
0149 ALTER TABLE PimItemTagRelation ADD COLUMN PimItem_id BIGINT NOT NULL
0150
0151 ALTER TABLE PimItemTagRelation ADD COLUMN Tag_id BIGINT NOT NULL
0152
0153 ALTER TABLE CollectionMimeTypeRelation ADD COLUMN Collection_id BIGINT NOT NULL
0154
0155 ALTER TABLE CollectionMimeTypeRelation ADD COLUMN MimeType_id BIGINT NOT NULL
0156
0157 ALTER TABLE CollectionPimItemRelation ADD COLUMN Collection_id BIGINT NOT NULL
0158
0159 ALTER TABLE CollectionPimItemRelation ADD COLUMN PimItem_id BIGINT NOT NULL
0160
0161 ALTER TABLE PimItemTable DROP FOREIGN KEY myForeignKeyIdentifier
0162
0163 ALTER TABLE CollectionAttributeTable DROP FOREIGN KEY myForeignKeyIdentifier
0164
0165 ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0166
0167 ALTER TABLE CollectionTable ADD FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0168
0169 ALTER TABLE PimItemTable ADD FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0170
0171 ALTER TABLE PimItemTable ADD FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT
0172
0173 ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0174
0175 ALTER TABLE PartTable ADD FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0176
0177 ALTER TABLE CollectionAttributeTable ADD FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0178
0179 ALTER TABLE TagTable ADD FOREIGN KEY (parentId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0180
0181 ALTER TABLE TagTable ADD FOREIGN KEY (typeId) REFERENCES TagTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT
0182
0183 ALTER TABLE TagAttributeTable ADD FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0184
0185 ALTER TABLE TagRemoteIdResourceRelationTable ADD FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0186
0187 ALTER TABLE TagRemoteIdResourceRelationTable ADD FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0188
0189 ALTER TABLE RelationTable ADD FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0190
0191 ALTER TABLE RelationTable ADD FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0192
0193 ALTER TABLE RelationTable ADD FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT
0194
0195 ALTER TABLE PimItemFlagRelation ADD FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0196
0197 ALTER TABLE PimItemFlagRelation ADD FOREIGN KEY (Flag_id) REFERENCES FlagTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0198
0199 ALTER TABLE PimItemTagRelation ADD FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0200
0201 ALTER TABLE PimItemTagRelation ADD FOREIGN KEY (Tag_id) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0202
0203 ALTER TABLE CollectionMimeTypeRelation ADD FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0204
0205 ALTER TABLE CollectionMimeTypeRelation ADD FOREIGN KEY (MimeType_id) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0206
0207 ALTER TABLE CollectionPimItemRelation ADD FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE
0208
0209 ALTER TABLE CollectionPimItemRelation ADD FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE