-- Convert schema './FileFormats-Schema-0.06-SQLite.sql' to './FileFormats-Schema-0.07-SQLite.sql':

BEGIN;









CREATE TEMPORARY TABLE structure_fields_temp_alter (
  struct_id integer NOT NULL,
  name varchar(255) NOT NULL,
  position integer NOT NULL,
  type_id integer NOT NULL,
  value varchar(1024),
  comments varchar(1024),
  PRIMARY KEY (struct_id, position)
);
INSERT INTO structure_fields_temp_alter SELECT struct_id, name, position, type_id, value, comments FROM structure_fields;
DROP TABLE structure_fields;
CREATE TABLE structure_fields (
  struct_id integer NOT NULL,
  name varchar(255) NOT NULL,
  position integer NOT NULL,
  type_id integer NOT NULL,
  value varchar(1024),
  comments varchar(1024),
  PRIMARY KEY (struct_id, position)
);
CREATE INDEX structure_fields_idx_struct_id_structure_field_ ON structure_fields (struct_id);
CREATE INDEX structure_fields_idx_type_id_s_structure_field ON structure_fields (type_id);
INSERT INTO structure_fields SELECT struct_id, name, position, type_id, value, comments FROM structure_fields_temp_alter;
DROP TABLE structure_fields_temp_alter;




COMMIT;

