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)
);
