DROP TABLE ReadOnlyIdEntity;
DROP TABLE PrimitiveIdEntity;
DROP TABLE ImmutableWithManualIdentity;

CREATE TABLE ReadOnlyIdEntity (
    ID NUMBER GENERATED by default on null as IDENTITY PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE TABLE PrimitiveIdEntity (
    ID NUMBER GENERATED by default on null as IDENTITY PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE TABLE ImmutableWithManualIdentity (
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE TABLE SimpleSeq (
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE SEQUENCE simple_seq_seq START WITH 1;

CREATE TABLE PersistableSeq (
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE SEQUENCE persistable_seq_seq START WITH 1;

CREATE TABLE PrimitiveIdSeq (
    ID NUMBER PRIMARY KEY,
    NAME VARCHAR2(100)
);

CREATE SEQUENCE "primitive_seq_seq" START WITH 1;
