CREATE TABLE transport(
id INTEGER PRIMARY KEY,
 number text,
 series text,
 model text,
 type text,
 provider text,
 idnumber text,
 factory text,
 yeardate integer,
 chassis text,
 body text,
 engine text,
 regNom text);

CREATE TABLE personal (   
 
  id INTEGER PRIMARY KEY,
  number int,
  rank text,
  name text,
  serial text,
  date integer
);