diff options
Diffstat (limited to 'testdata/ref/sc5000/firmware-1.2.2/p.db.sql')
-rw-r--r-- | testdata/ref/sc5000/firmware-1.2.2/p.db.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/testdata/ref/sc5000/firmware-1.2.2/p.db.sql b/testdata/ref/sc5000/firmware-1.2.2/p.db.sql new file mode 100644 index 0000000..88b36df --- /dev/null +++ b/testdata/ref/sc5000/firmware-1.2.2/p.db.sql @@ -0,0 +1,8 @@ +PRAGMA foreign_keys=OFF; +BEGIN TRANSACTION; +CREATE TABLE PerformanceData ( [id] INTEGER, [isAnalyzed] NUMERIC, [isRendered] NUMERIC, [trackData] BLOB, [highResolutionWaveFormData] BLOB, [overviewWaveFormData] BLOB, [beatData] BLOB, [quickCues] BLOB, [loops] BLOB, [hasSeratoValues] NUMERIC, [hasRekordboxValues] NUMERIC, [hasTraktorValues] NUMERIC, PRIMARY KEY ( [id] ) ); +CREATE TABLE Information ( [id] INTEGER, [uuid] TEXT, [schemaVersionMajor] INTEGER, [schemaVersionMinor] INTEGER, [schemaVersionPatch] INTEGER, [currentPlayedIndiciator] INTEGER, [lastRekordBoxLibraryImportReadCounter] INTEGER, PRIMARY KEY ( [id] ) ); +INSERT INTO Information VALUES(1,'66f43cb6-c2be-402a-8613-c432dea837f4',1,13,0,0,0); +CREATE INDEX index_PerformanceData_id ON PerformanceData ( id ); +CREATE INDEX index_Information_id ON Information ( id ); +COMMIT; |