CREATE TABLE myuser.items (
  id NUMBER(4) GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 101) NOT NULL PRIMARY KEY,
  name VARCHAR2(255) NOT NULL,
  description VARCHAR2(512),
  cost FLOAT
);
-- supplemental logging to provide full data to LogMiner
ALTER TABLE myuser.items ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
-- c##logminer user needs to be able to read this table for snapshotting
GRANT SELECT ON myuser.items TO c##logminer;

INSERT INTO myuser.items VALUES (NULL,'book','textbook',3.14);
INSERT INTO myuser.items VALUES (NULL,'clock','12 hour',4.1);
