aXdkY94L

1<?xml version="1.0" encoding="UTF-8"?>
2<list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
3      xsi:noNamespaceSchemaLocation="../../../../../../tools/database-utils/src/main/resources/changeLog.xsd">
4    <changeLog id="V1.0" author="GenCloud" desc="account data table">
5        <changeSet>
6            <sqlQuery>
7                SELECT pg_catalog.set_config('search_path', 'public', false);
8
9                CREATE TABLE IF NOT EXISTS account_data
10                (
11                    id             INT                                    NOT NULL,
12                    accountname    VARCHAR(45)                            NOT NULL,
13                    password       VARCHAR(128),
14                    email          VARCHAR(255),
15                    created_time   TIMESTAMP    DEFAULT CURRENT_TIMESTAMP NOT NULL,
16                    last_ip        VARCHAR(15)  DEFAULT NULL              NOT NULL,
17                    last_server_id SMALLINT     DEFAULT 1,
18                    hmac_key       VARCHAR(128) DEFAULT NULL
19                );
20
21                CREATE UNIQUE INDEX account_data_username_uindex
22                    ON account_data (accountname);
23
24                ALTER TABLE account_data
25                    ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
26                        SEQUENCE NAME account_data_id_seq
27                            START WITH 1
28                            INCREMENT BY 1
29                            NO MINVALUE
30                            NO MAXVALUE
31                            CACHE 1
32                        );
33
34                ALTER TABLE account_data
35                    ADD CONSTRAINT account_data_pk
36                        PRIMARY KEY (id)
37            </sqlQuery>
38            <scriptFile path="db/auth/V1.0__account_data_table.sql"/>
39        </changeSet>
40
41        <rollbackOptions rollbackIfHashNotCompatible="true">
42            <sqlQuery>
43                SELECT pg_catalog.set_config('search_path', 'public', false);
44                DROP TABLE IF EXISTS account_data;
45            </sqlQuery>
46
47            <scriptFile path="db/auth/drop_V1.1.sql"/>
48        </rollbackOptions>
49    </changeLog>
50</list>
51