2016-04-20 22:35 GMT+02:00 Cecil Westerhof <cldwesterhof at gmail.com>:
> 2016-04-20 22:21 GMT+02:00 Scott Robison <scott at casaderobison.com>: > >> On Wed, Apr 20, 2016 at 2:00 PM, Cecil Westerhof <cldwesterhof at gmail.com> >> wrote: >> >> > How stupid that I did not think about Google Drive. :'-( Here it is: >> > https://drive.google.com/file/d/0BzW5q7uL-6z0SDdya2REaFNFUVE >> > >> > ?I am very curious. >> > >> >> I downloaded this and opened it with sqlite3.exe shell version 3.11.0. >> >> D:\>\bin\sqlite3.exe checkUUID.sqlite >> SQLite version 3.11.0 2016-02-15 17:29:24 >> Enter ".help" for usage hints. >> sqlite> .schema >> sqlite> >> >> It's a big enough file, but there is no schema present. >> > > ?That is strange, because I get: > sqlite3 checkUUID.sqlite > SQLite version 3.8.7.1 2014-10-29 13:59:56 > Enter ".help" for usage hints. > sqlite> .schema > CREATE TABLE testUniqueUUID ( > UUID blob, > > PRIMARY KEY(UUID) > CHECK(TYPEOF(UUID) = 'blob' AND > LENGTH(UUID) = 16 AND > SUBSTR(HEX(UUID), 13, 1) == '4' AND > SUBSTR(HEX(UUID), 17, 1) IN ('8', '9', 'A', 'B') > ) > ); > ? > > ?I am going to investigate.? > ?Interesting: when I unzip the .gz file, I have the same problem. Something went wrong. I will try to correct it.? -- Cecil Westerhof
