Нужно достать 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

