On 12 June 2015 at 06:42, Hick Gunter <hick at scigames.at> wrote: > You are creating each table in a separate file; a foreign key may only > reference a table in the same file. > > Your type declarations are faulty in that you are omitting an opening > parenthesis in a DECIMAL 4,3) declaration. > > SQLite does not constrain sizes, a TEXT(10) or a CHAR(1) variable my contain > arbitrary length strings; types only define affinities, the same fields could > be used to store integers, reals or BLOBS for that matter. > > SQLIte also does not implement fixed point numeric fields. DECIMAL (6,2) > defines a field of numeric affinity, i.e. if you provide a value that > contains a decimal point, it will be stored as a REAL. >
And table constraints (foreign key in timeslip table) must follow the column declarations Regards, Simon
