• Home
• com.swisscom.cloud.sb
• database
• 6.12.2
• source code
• V1_0_10__create_application_user_table.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V1_0_10__create_application_user_table.sql Maven / Gradle / Ivy

DROP PROCEDURE IF EXISTS create_application_user_table;
DELIMITER //

CREATE PROCEDURE create_application_user_table()
  BEGIN

    CREATE TABLE application_user
    (
      id       INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
      username VARCHAR(30)     NOT NULL,
      password VARCHAR(100)    NOT NULL,
      enabled  BOOL            NOT NULL,
      role     VARCHAR(20)     NOT NULL,
      platform_guid VARCHAR(36)     NOT NULL
    );
    CREATE UNIQUE INDEX application_user_id_uindex
      ON application_user (id);
    CREATE UNIQUE INDEX application_user_name_uindex
      ON application_user (username);
  END//

DELIMITER ;
CALL create_application_user_table();