Breaking News: Grepper is joining You.com. Read the official announcement!

SQL Scripts

Pragya Keshap answered on February 19, 2023 Popularity 9/10 Helpfulness 2/10

answer SQL Scripts

SQL Scripts

Comment

The database should have a property table to make the JDBC work as a backend. Also, for our testing purposes, we'll add a few records of user-service configuration. Similarly, you can add configuration for other services as well:

-- schema.sql
CREATE TABLE IF NOT EXISTS properties (
    id IDENTITY PRIMARY KEY,
    application VARCHAR(128),
    profile VARCHAR(128),
    label VARCHAR(128),
    key VARCHAR(512),
    value VARCHAR(512)
);

https://www.sqlshack.com/learn-sql-sql-script/

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql sql-scripts

Link to this answer
Share Copy Link