CREATE MEMORY TABLE PUBLIC.ANDROIDAPPS(AID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,PACKAGENAME VARCHAR(255) NOT NULL,VERSIONCODE INTEGER NOT NULL,MAINVERSION INTEGER NOT NULL,PATCHVERSION INTEGER NOT NULL,NAME VARCHAR(255) NOT NULL,VERSION VARCHAR(255) NOT NULL,MINSDK INTEGER NOT NULL)
CREATE MEMORY TABLE PUBLIC.PERMISSIONS(PID BIGINT,NAME VARCHAR(255),FOREIGN KEY(PID) REFERENCES PUBLIC.ANDROIDAPPS(AID) ON DELETE CASCADE)