Нужно достать SQL код из ORACLE SQL Modeler, и вставить его в SQLite, для дальнейшей работы с базой данных

Помогите пожалуйста достать SQL код из моделера, и вставить в SQLite, какие-бы вариации не подбирал, SQLite, постоянно ругается, ниже код SQL Server 2012.

скриншот реляционной модели

скриншот

CREATE TABLE BUILDING 
    (
     id VARCHAR (3) NOT NULL , 
     address VARCHAR (60) NOT NULL 
    )
GO

ALTER TABLE BUILDING ADD CONSTRAINT BUILDING_PK PRIMARY KEY CLUSTERED (id)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
GO

CREATE TABLE COMMANDANTS 
    (
     id VARCHAR (7) NOT NULL , 
     full_name VARCHAR (40) NOT NULL , 
     BUILDING_id VARCHAR (3) NOT NULL 
    )
GO

ALTER TABLE COMMANDANTS ADD CONSTRAINT COMMANDANTS_PK PRIMARY KEY CLUSTERED (id)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
GO

CREATE TABLE RESIDENCE_PERMIT 
    (
     check_in_date DATE NOT NULL , 
     eviction_date DATE , 
     ROOMS_Id VARCHAR (5) NOT NULL , 
     STUDENTS_Id VARCHAR (10) NOT NULL 
    )
GO

ALTER TABLE RESIDENCE_PERMIT ADD CONSTRAINT RESIDENCE_PERMIT_PK PRIMARY KEY CLUSTERED (STUDENTS_Id, ROOMS_Id)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
GO

CREATE TABLE ROOMS 
    (
     Id VARCHAR (5) NOT NULL , 
     number VARCHAR (5) NOT NULL , 
     total_beds TINYINT NOT NULL , 
     free_of_beds TINYINT NOT NULL , 
     SECTION_Id VARCHAR (7) NOT NULL 
    )
GO

ALTER TABLE ROOMS ADD CONSTRAINT ROOMS_PK PRIMARY KEY CLUSTERED (Id)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
GO

CREATE TABLE SECTION 
    (
     Id VARCHAR (7) NOT NULL , 
     number VARCHAR (4) NOT NULL , 
     number_of_rooms_per_section TINYINT NOT NULL , 
     BUILDING_id VARCHAR (3) NOT NULL 
    )
GO

ALTER TABLE SECTION ADD CONSTRAINT SECTION_PK PRIMARY KEY CLUSTERED (Id)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
GO

CREATE TABLE STUDENTS 
    (
     Id VARCHAR (10) NOT NULL , 
     full_name VARCHAR (50) NOT NULL , 
     birthdate DATE NOT NULL , 
     group_number VARCHAR (7) NOT NULL , 
     "foreign" BIT NOT NULL , 
     sex BIT NOT NULL 
    )
GO

ALTER TABLE STUDENTS ADD CONSTRAINT STUDENTS_PK PRIMARY KEY CLUSTERED (Id)
     WITH (
     ALLOW_PAGE_LOCKS = ON , 
     ALLOW_ROW_LOCKS = ON )
GO

ALTER TABLE COMMANDANTS 
    ADD CONSTRAINT COMMANDANTS_BUILDING_FK FOREIGN KEY 
    ( 
     BUILDING_id
    ) 
    REFERENCES BUILDING 
    ( 
     id 
    ) 
    ON DELETE NO ACTION 
    ON UPDATE NO ACTION 
GO

ALTER TABLE RESIDENCE_PERMIT 
    ADD CONSTRAINT RESIDENCE_PERMIT_ROOMS_FK FOREIGN KEY 
    ( 
     ROOMS_Id
    ) 
    REFERENCES ROOMS 
    ( 
     Id 
    ) 
    ON DELETE NO ACTION 
    ON UPDATE NO ACTION 
GO

ALTER TABLE RESIDENCE_PERMIT 
    ADD CONSTRAINT RESIDENCE_PERMIT_STUDENTS_FK FOREIGN KEY 
    ( 
     STUDENTS_Id
    ) 
    REFERENCES STUDENTS 
    ( 
     Id 
    ) 
    ON DELETE NO ACTION 
    ON UPDATE NO ACTION 
GO

ALTER TABLE ROOMS 
    ADD CONSTRAINT ROOMS_SECTION_FK FOREIGN KEY 
    ( 
     SECTION_Id
    ) 
    REFERENCES SECTION 
    ( 
     Id 
    ) 
    ON DELETE NO ACTION 
    ON UPDATE NO ACTION 
GO

ALTER TABLE SECTION 
    ADD CONSTRAINT SECTION_BUILDING_FK FOREIGN KEY 
    ( 
     BUILDING_id
    ) 
    REFERENCES BUILDING 
    ( 
     id 
    ) 
    ON DELETE NO ACTION 
    ON UPDATE NO ACTION 
GO

Ответы (0 шт):