summaryrefslogtreecommitdiffstats
path: root/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql
blob: 171cb2d9201aa1bf3e9c57650a2bc1c1dbc8802c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
CREATE SCHEMA IF NOT EXISTS `optimizer` DEFAULT CHARACTER SET utf8 ;

CREATE TABLE IF NOT EXISTS `optimizer`.`request` (
  uuid BINARY(16) NOT NULL,
  request LONGTEXT NOT NULL,
  created_time BIGINT(20) NULL DEFAULT NULL,
  request_start BIGINT(20) NULL DEFAULT NULL,
  request_end BIGINT(20) NULL DEFAULT NULL,
  status VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`uuid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS `optimizer`.`response` (
  uuid BINARY(16) NOT NULL,
  repsonse LONGTEXT NULL DEFAULT NULL,
  delivered_time BIGINT(20) NULL DEFAULT NULL,
  PRIMARY KEY (`uuid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


CREATE TABLE IF NOT EXISTS `optimizer`.`topology` (
  uuid BINARY(16) NOT NULL,
  topology LONGTEXT NULL DEFAULT NULL,
  topology_start BIGINT(20) NULL DEFAULT NULL,
  topology_end BIGINT(20) NULL DEFAULT NULL,
  topology_retries INT NULL DEFAULT NULL,
  topology_polling_interval INT NULL DEFAULT NULL,
  PRIMARY KEY (`uuid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS `optimizer`.`tickets` (
  uuid BINARY(16) NOT NULL,
  tickets LONGTEXT NULL DEFAULT NULL,
  tickets_start BIGINT(20) NULL DEFAULT NULL,
  tickets_end BIGINT(20) NULL DEFAULT NULL,
  tickets_retries INT NULL DEFAULT NULL,
  topology_polling_interval INT NULL DEFAULT NULL,
  PRIMARY KEY (`uuid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

CREATE TABLE IF NOT EXISTS `optimizer`.`optimizer` (
  uuid BINARY(16) NOT NULL,
  optimize_response LONGTEXT NULL DEFAULT NULL,
  optimize_start BIGINT(20) NULL DEFAULT NULL,
  optimize_end BIGINT(20) NULL DEFAULT NULL,
  optimize_retries INT NULL DEFAULT NULL,
  optimize_polling_interval INT NULL DEFAULT NULL,
  PRIMARY KEY (`uuid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;