HYTOS

PRAGMA foreign_keys = OFF;

create table Copy_Components(

    UID TEXT NOT NULL,

    Symbols_UID TEXT NOT NULL,

    Name TEXT, [Index] INTEGER,

    X REAL,

    Y REAL,

    Rotation REAL,

    ScaleX REAL DEFAULT 1,

    ScaleY REAL DEFAULT 1,

    CONSTRAINT PK_Components PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Symbols_UID FOREIGN KEY (

        Symbols_UID

    )

    REFERENCES Symbols (UID)

);

insert into Copy_Components (UID, Symbols_UID, Name, [Index], X, Y, Rotation)

select UID, Symbols_UID, Name, [Index], X, Y, Rotation from Components;

drop table Components;

alter table Copy_Components rename to Components;

PRAGMA foreign_keys = ON;