NDRsHRUW

1CREATE TABLE IF NOT EXISTS `SIP_SETTINGS` (
2  `ID`                  BIGINT NOT NULL AUTO_INCREMENT,
3  `LABEL`               VARCHAR(255) UNIQUE NOT NULL,
4  `SIP_CODEC`           varchar(255) DEFAULT NULL,
5  `SIP_LOGIN`           varchar(255) DEFAULT NULL,
6  `SIP_SERVER`          varchar(255) DEFAULT NULL,
7  `SIP_DOMAIN`          varchar(255) DEFAULT NULL,
8  `SIP_PASSWORD`        varchar(255) DEFAULT NULL,
9  `CLIENT_TWILIO_SID`   varchar(255) DEFAULT NULL,
10  `SIP_CONNECTION_TYPE` varchar(255) DEFAULT NULL,
11  PRIMARY KEY (`ID`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13
14
15#default sip settings
16INSERT INTO `SIP_SETTINGS` (LABEL, SIP_CODEC, SIP_SERVER, SIP_CONNECTION_TYPE) VALUE (
17  "Default",
18  "G_711a",
19  "91.220.164.8",
20  "CLIENT_INFRASTRUCTURE"
21);
22
23
24#default state
25ALTER TABLE CAMPAIGN_SETTINGS ADD COLUMN `SIP_SETTINGS_ID` BIGINT NOT NULL DEFAULT 1,
26ADD CONSTRAINT `CAMPAIGN_SETTINGS_TO_SIP_SETTINGS` FOREIGN KEY (`SIP_SETTINGS_ID`) REFERENCES SIP_SETTINGS(`ID`);