[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    extragear/graphics/digikam/data/database
From:       Holger Foerster <hamsi2k () freenet ! de>
Date:       2010-06-29 19:09:38
Message-ID: 20100629190938.E8BE6AC8E0 () svn ! kde ! org
[Download RAW message or body]

SVN commit 1144375 by foerster:

Update MySQL schema to use 32 characters for MD5 hash values.
Added schema update statements for next database schema version.

CCMAIL: marcel.wiesweg@gmx.de

 M  +13 -2     dbconfig.xml.cmake  


--- trunk/extragear/graphics/digikam/data/database/dbconfig.xml.cmake \
#1144374:1144375 @@ -245,6 +245,11 @@
                 END;</statement>
             </dbaction>
 
+            <!-- Migration from DB Version XXX to DB Version YYY -->
+            <dbaction name="updateSchemaFromXXXToYYY" mode="transaction">
+            </dbaction>
+            
+
             <dbaction name="getItemURLsInAlbumByItemName" mode="transaction">
                 <statement mode="query">SELECT Albums.relativePath, Images.name FROM \
Images INNER JOIN Albums ON Albums.id=Images.album WHERE Albums.id=:albumID ORDER BY \
Images.name COLLATE NOCASE;</statement>  </dbaction>
@@ -558,7 +563,7 @@
                             category INTEGER NOT NULL,
                             modificationDate DATETIME,
                             fileSize INTEGER,
-                            uniqueHash VARCHAR(16),
+                            uniqueHash VARCHAR(32),
                             UNIQUE (album, name(332)));</statement>
             <statement mode="plain">CREATE TABLE ImageHaarMatrix
                             (imageid INTEGER PRIMARY KEY,
@@ -714,6 +719,12 @@
             END;</statement>
             </dbaction>
 
+            <!-- Migration from DB Version XXX to DB Version YYY -->
+            <dbaction name="updateSchemaFromXXXToYYY" mode="transaction">
+                <statement mode="query">ALTER TABLE UniqueHashes CHANGE uniqueHash \
uniqueHash VARCHAR(32);</statement> +                <statement mode="query">ALTER \
TABLE Images       CHANGE uniqueHash uniqueHash VARCHAR(32);</statement> +            \
</dbaction> +            
             <dbaction name="checkIfDatabaseExists" mode="transaction">
                 <statement mode="query">SELECT Albums.relativePath, Images.name FROM \
Images INNER JOIN Albums ON Albums.id=Images.album WHERE Albums.id=:albumID ORDER BY \
Images.name;</statement>  </dbaction>
@@ -853,7 +864,7 @@
                             data LONGBLOB)
                 </statement>
                 <statement mode="query">CREATE TABLE UniqueHashes
-                            (uniqueHash VARCHAR(16),
+                            (uniqueHash VARCHAR(32),
                             fileSize INTEGER,
                             thumbId INTEGER,
                             UNIQUE(uniqueHash, fileSize))


[prev in list] [next in list] [prev in thread] [next in thread]