blob: 394a3e5b12eceaddbfbba85f3aa2551f9472bc7b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
use requestdb;
CREATE TABLE IF NOT EXISTS request_processing_data (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`SO_REQUEST_ID` VARCHAR(50) NOT NULL,
`GROUPING_ID` VARCHAR(100) NULL,
`NAME` VARCHAR(200) NOT NULL,
`VALUE` LONGTEXT,
`TAG` VARCHAR(200) NOT NULL,
`CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`),
UNIQUE INDEX `UK_request_processing_data` (
`SO_REQUEST_ID` ASC,
`GROUPING_ID` ASC,
`TAG` ASC,
`NAME` ASC
)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;
|