-- Convert schema './FileFormats-Schema-0.02-SQLite.sql' to './FileFormats-Schema-0.03-SQLite.sql':

BEGIN;

CREATE TABLE systems (
  id INTEGER PRIMARY KEY NOT NULL,
  name varchar(255) NOT NULL,
  comments varchar(16384) NOT NULL
);











CREATE TEMPORARY TABLE types_temp_alter (
  id INTEGER PRIMARY KEY NOT NULL,
  system_id integer NOT NULL,
  name varchar(255) NOT NULL,
  comments varchar(16384) NOT NULL
);
INSERT INTO types_temp_alter SELECT id, system_id, name, comments FROM types;
DROP TABLE types;
CREATE TABLE types (
  id INTEGER PRIMARY KEY NOT NULL,
  system_id integer NOT NULL,
  name varchar(255) NOT NULL,
  comments varchar(16384) NOT NULL
);
INSERT INTO types SELECT id, system_id, name, comments FROM types_temp_alter;
DROP TABLE types_temp_alter;


COMMIT;
