Translations:Kexi/Tutorials/Importing SQLite database into Kexi/15/en

• Type a name for every column presented by the schema in the step 3.
• Use the Property Editor on the right hand to give each column in this table proper data type.
  • For INTEGER types, eg. dateTime INTEGER as seen on the schema, select Integer Number in the Data Type column of the Table Designer.
  • For REAL types, eg. barometer REAL as seen on the schema, select Floating Point Number in the Data Type column of the Table Designer.
• In addition, set the dateTime column as the primary key for the table in the Property Editor.
• Also, usUnits and interval columns have NOT NULL specifier assigned. To do the same in Kexi, set Required property to Yes for these columns in the Property Editor.