Warning, file /libraries/kdb/tests/features/schema.sql was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).
0001 0002 begin; 0003 0004 drop table kexi__objects; 0005 drop table kexi__fields; 0006 drop table kexi__querydata; 0007 drop table kexi__db; 0008 0009 CREATE TABLE kexi__objects (o_id Integer, o_type Byte, o_name Text(200), 0010 o_caption Text, o_help LongText); 0011 0012 CREATE TABLE kexi__fields (t_id Integer, f_type Byte, f_name Text(200), 0013 f_length Integer, f_precision Integer, 0014 f_constraints Integer, f_options Integer, f_order Integer, 0015 f_caption Text(200), f_help Text); 0016 0017 CREATE TABLE kexi__querydata (q_id Integer, q_sql LongText, q_valid Boolean ); 0018 0019 CREATE TABLE kexi__parts (p_id Integer, p_name Text, p_mime Text, p_url Text); 0020 0021 CREATE TABLE kexi__db (db_property Text(32), db_value LongText ); 0022 0023 insert into kexi__objects values (1, 1, 'persons', 'Persons', 'Persons group in our factory'); 0024 insert into kexi__fields values (1, 3, 'id', 0, 0, 16, 0, 0, null, null); 0025 insert into kexi__fields values (1, 1, 'age', 0, 0, 16, 0, 1, null, null); 0026 insert into kexi__fields values (1, 11, 'name', 30, 0, 16, 0, 2, null, null); 0027 insert into kexi__fields values (1, 11, 'surname', 30, 0, 16, 0, 3, null, null); 0028 0029 insert into kexi__objects values (2, 1, 'cars', 'Cars', 'Cars owned by persons'); 0030 insert into kexi__fields values (2, 3, 'id', 0, 0, 16, 0, 0, null, null); 0031 insert into kexi__fields values (2, 3, 'owner', 0, 0, 16, 0, 1, null, null); 0032 insert into kexi__fields values (2, 11, 'model', 30, 0, 16, 0, 2, null, null); 0033 0034 insert into kexi__db values ('kexidb_major_ver', '1'); 0035 insert into kexi__db values ('kexidb_minor_ver', '2'); 0036 0037 commit; 0038