Skip to main content

Spring Boot: SQL für Config Server

Spring Cloud Config Server Properties Tabelle für MySQL / MariaDB:

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP DATABASE IF EXISTS `cloud_config`;
CREATE DATABASE `cloud_config` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `cloud_config`;

DROP TABLE IF EXISTS `PROPERTIES`;
CREATE TABLE `PROPERTIES` (
  `application` varchar(255) NOT NULL,
  `profile` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`application`,`profile`,`label`,`key`),
  KEY `application_profile_label` (`application`,`profile`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `PROPERTIES` (`application`, `profile`, `label`, `key`, `value`) VALUES
('cfs',	'dev',	'0.0.0.1',	'jusoko.cfs.long_name',	'Spring Boot Configuration Server'),
('cfs',	'dev',	'0.0.0.1',	'jusoko.cfs.info',	'CFS 0.0.0 Build 1'),
('cfs',	'dev',	'0.0.0.1',	'jusoko.cfs.active_since',	'2021-04-18'),
('cfs',	'dev',	'0.0.0.1',	'jusoko.cfs.short_name',	'CFS');