Skip to content

Instantly share code, notes, and snippets.

@gtudan

gtudan/multi-tenancy-init-schema.sql Secret

Created August 8, 2017 17:29
Show Gist options
  • Save gtudan/49615c4665b18b23ab0b1df7af1afb26 to your computer and use it in GitHub Desktop.
Save gtudan/49615c4665b18b23ab0b1df7af1afb26 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
multi-tenancy-init-schema.sql
CREATE SCHEMA tenant1;
CREATE TABLE tenant1.users( id BIGINT PRIMARY KEY, user_name VARCHAR(255) NOT NULL);
CREATE SCHEMA tenant2;
CREATE TABLE tenant2.users( id BIGINT PRIMARY KEY, user_name VARCHAR(255) NOT NULL);
INSERT INTO tenant1.users VALUES (1, 'ernie');
INSERT INTO tenant2.users VALUES (1, 'bert');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment