# noinspection SqlNoDataSourceInspectionForFile
CREATE TABLE IF NOT EXISTS `b_trash` (
  `ID`        INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `NAME`      VARCHAR(255) NULL,
  `SITE_ID`   CHAR(2)      NULL,
  `ENTITY_ID` VARCHAR(255) NOT NULL,
  `MODULE_ID` VARCHAR(255) NOT NULL,
  `ACTION`    VARCHAR(255) NOT NULL,
  `CALLBACK`  VARCHAR(255) NOT NULL,
  `TIMESTAMP` TIMESTAMP    NOT NULL,
  `USER_ID`   INT UNSIGNED NULL,

  PRIMARY KEY (`ID`),
  KEY `IX_TRASH_USER_ID` (`USER_ID`),
  KEY `IX_TRASH_MODULE_ID` (`MODULE_ID`),
  KEY `IX_TRASH_ACTION` (`ACTION`),
  KEY `IX_TRASH_TIMESTAMP` (`TIMESTAMP`)
);

CREATE TABLE IF NOT EXISTS `b_trash_data` (
  `ID`       INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `TRASH_ID` INT UNSIGNED NOT NULL,
  `ACTION`   VARCHAR(255) NOT NULL,
  `DATA`     MEDIUMTEXT   NOT NULL,

  PRIMARY KEY (`ID`),
  KEY `IX_TRASH_TRASH_ID` (`TRASH_ID`, `ACTION`)
);

DROP TABLE `b_trash`;
DROP TABLE `b_trash_data`;

CREATE TABLE b_trash (
  ID        INT          NOT NULL IDENTITY (1, 1),
  NAME      VARCHAR(255) NULL,
  SITE_ID   CHAR(2)      NULL,
  ENTITY_ID VARCHAR(255) NOT NULL,
  MODULE_ID VARCHAR(255) NOT NULL,
  ACTION    VARCHAR(255) NOT NULL,
  CALLBACK  VARCHAR(255) NOT NULL,
  TIMESTAMP TIMESTAMP    NOT NULL,
  USER_ID   INT          NULL,

  CONSTRAINT b_trash_ibpk_1 PRIMARY KEY (ID),
)
  
CREATE INDEX b_trash_user_id_ibk
  ON b_trash (USER_ID)
  
CREATE INDEX b_trash_module_id_ibk
  ON b_trash (MODULE_ID)
  
CREATE INDEX b_trash_action_ibk
  ON b_trash (ACTION)
  
CREATE INDEX b_trash_timestamp_ibk
  ON b_trash (TIMESTAMP)
  
CREATE TABLE b_trash_data (
  ID       INT          NOT NULL IDENTITY (1, 1),
  TRASH_ID INT          NOT NULL,
  ACTION   VARCHAR(255) NOT NULL,
  DATA     TEXT   NOT NULL,

  PRIMARY KEY (ID)
)
  
CREATE INDEX b_trash_data_trash_id_ibk
  ON b_trash_data (TRASH_ID)
  

CREATE TABLE b_trash (
  ID number(11) NOT NULL,
  NAME      VARCHAR(255 char) NULL,
  SITE_ID   CHAR(2 char)      NULL,
  ENTITY_ID VARCHAR(255 char) NOT NULL,
  MODULE_ID VARCHAR(255 char) NOT NULL,
  ACTION    VARCHAR(255 char) NOT NULL,
  CALLBACK  VARCHAR(255 char) NOT NULL,
  TIMESTAMP NUMBER(11)    NOT NULL,
  USER_ID   NUMBER(11)          NULL,

  PRIMARY KEY (ID)
);

CREATE INDEX b_trash_user_id_ibk  ON b_trash (USER_ID);
CREATE INDEX b_trash_module_id_ibk  ON b_trash (MODULE_ID);
CREATE INDEX b_trash_action_ibk  ON b_trash (ACTION);
CREATE INDEX b_trash_timestamp_ibk  ON b_trash (TIMESTAMP);


CREATE TABLE b_trash_data (
  ID NUMBER (11) NOT NULL,
  TRASH_ID NUMBER (11)          NOT NULL,
  ACTION   VARCHAR(255 char) NOT NULL,
  DATA     CLOB         NOT NULL,

  PRIMARY KEY (ID)
);

CREATE INDEX b_trash_data_trash_id_ibk  ON b_trash_data (TRASH_ID);