salix/db/versions/11330-greenMoss/00-firstScript.sql

CREATE TABLE IF NOT EXISTS vn.saySimpleCountry(
	countryFk MEDIUMINT(8) UNSIGNED,
	channel INT(4) COMMENT 'channel de whatsapp de saySimple',
	PRIMARY KEY (countryFk),
	CONSTRAINT `saySimpleCountry_FK` FOREIGN KEY (`countryFk`) REFERENCES vn.country (`id`) ON UPDATE CASCADE
);

CREATE TABLE IF NOT EXISTS vn.saySimpleConfig(
	id INT AUTO_INCREMENT PRIMARY KEY,
	url VARCHAR(255) NOT NULL
);

INSERT IGNORE INTO vn.saySimpleCountry (countryFk, channel) 
	VALUES (19, 1169),
			(8, 1183),
			(NULL, 1320);