· 9 years ago · Feb 04, 2017, 10:50 AM
1CREATE TABLE IF NOT EXISTS `deployed_versions` (
2 `id` int(8) NOT NULL,
3 `server_ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
4 `repository` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
5 `commit` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
6) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
7
8CREATE TABLE IF NOT EXISTS `deployments` (
9 `id` int(8) NOT NULL,
10 `repository` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
11 `commit` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
12) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;