Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- databaseChangeLog:
- - changeSet:
- id: SSO_001
- author: unknown
- dbms: oracle, hsqldb
- changes:
- - createTable:
- remarks: "SSO Account Link initial table"
- tableName: Account_link
- columns:
- - column:
- name: internal_id
- type: number(20)
- constraints:
- nullable: false
- - column:
- name: id
- type: raw(16)
- constraints:
- nullable: false
- - column:
- name: program_name
- type: nvarchar2(255)
- constraints:
- nullable: false
- - column:
- name: local_username
- type: nvarchar2(255)
- constraints:
- nullable: false
- - column:
- name: user_type
- type: varchar2(30)
- constraints:
- nullable: false
- - column:
- name: sso_username
- type: nvarchar2(255)
- constraints:
- nullable: false
- - column:
- name: sso_id_provider
- type: nvarchar2(255)
- constraints:
- nullable: false
- - column:
- name: created_by
- type: varchar(30)
- constraints:
- nullable: false
- - column:
- name: created_date
- type: TIMESTAMP WITH TIME ZONE
- constraints:
- nullable: false
- - column:
- name: last_modified_by
- type: varchar(30)
- constraints:
- nullable: false
- - column:
- name: last_modified_date
- type: TIMESTAMP WITH TIME ZONE
- constraints:
- nullable: false
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement