Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6b51c7e

Browse files
Step 2. Add Liquibase and generate init script
1 parentb0eab87 commit6b51c7e

File tree

4 files changed

+71
-0
lines changed

4 files changed

+71
-0
lines changed

‎liquibase-and-spring-boot/blog/build.gradle‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -20,6 +20,7 @@ dependencies {
2020
runtimeOnly'org.postgresql:postgresql'
2121
testImplementation'org.springframework.boot:spring-boot-starter-test'
2222
testRuntimeOnly'org.junit.platform:junit-platform-launcher'
23+
implementation'org.liquibase:liquibase-core'
2324
}
2425

2526
tasks.named('test') {

‎liquibase-and-spring-boot/blog/src/main/resources/application.properties‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -4,3 +4,4 @@ spring.datasource.url=jdbc:postgresql://localhost/blog
44
spring.datasource.username=root
55
spring.datasource.password=root
66
spring.datasource.driver-class-name=org.postgresql.Driver
7+
spring.liquibase.change-log=classpath:/db/changelog/db.changelog-master.xml
Lines changed: 61 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,61 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
<databaseChangeLog
3+
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
4+
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
5+
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
6+
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.24.xsd"
7+
objectQuotingStrategy="QUOTE_ONLY_RESERVED_WORDS">
8+
<changeSetid="1715755200992-1"author="georgii (generated)">
9+
<createTabletableName="users">
10+
<columnautoIncrement="true"name="id"type="BIGINT">
11+
<constraintsnullable="false"primaryKey="true"primaryKeyName="pk_users"/>
12+
</column>
13+
<columnname="created_by"type="VARCHAR(255)"/>
14+
<columnname="created_date"type="TIMESTAMP WITHOUT TIME ZONE"/>
15+
<columnname="last_modified_by"type="VARCHAR(255)"/>
16+
<columnname="last_modified_date"type="TIMESTAMP WITHOUT TIME ZONE"/>
17+
<columnname="first_name"type="VARCHAR(255)">
18+
<constraintsnullable="false"/>
19+
</column>
20+
<columnname="last_name"type="VARCHAR(255)">
21+
<constraintsnullable="false"/>
22+
</column>
23+
<columnname="email"type="VARCHAR(255)"/>
24+
<columnname="fax"type="VARCHAR(255)"/>
25+
<columnname="last_activity"type="TIMESTAMP WITHOUT TIME ZONE"/>
26+
</createTable>
27+
</changeSet>
28+
<changeSetid="1715755200992-2"author="georgii (generated)">
29+
<createIndexindexName="idx_user_names"tableName="users">
30+
<columnname="first_name"/>
31+
<columnname="last_name"/>
32+
</createIndex>
33+
</changeSet>
34+
<changeSetid="1715755200992-3"author="georgii (generated)">
35+
<createTabletableName="posts">
36+
<columnautoIncrement="true"name="id"type="BIGINT">
37+
<constraintsnullable="false"primaryKey="true"primaryKeyName="pk_posts"/>
38+
</column>
39+
<columnname="created_by"type="VARCHAR(255)"/>
40+
<columnname="created_date"type="TIMESTAMP WITHOUT TIME ZONE"/>
41+
<columnname="last_modified_by"type="VARCHAR(255)"/>
42+
<columnname="last_modified_date"type="TIMESTAMP WITHOUT TIME ZONE"/>
43+
<columnname="title"type="VARCHAR(255)">
44+
<constraintsnullable="false"/>
45+
</column>
46+
<columnname="text"type="OID">
47+
<constraintsnullable="false"/>
48+
</column>
49+
<columnname="published_at"type="TIMESTAMP WITHOUT TIME ZONE"/>
50+
<columnname="author_id"type="BIGINT">
51+
<constraintsnullable="false"/>
52+
</column>
53+
</createTable>
54+
</changeSet>
55+
<changeSetid="1715755200992-4"author="georgii (generated)">
56+
<addForeignKeyConstraintbaseColumnNames="author_id"baseTableName="posts"constraintName="fk_posts_on_author"
57+
onDelete="NO ACTION"onUpdate="NO ACTION"referencedColumnNames="id"
58+
referencedTableName="users"/>
59+
</changeSet>
60+
61+
</databaseChangeLog>
Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,8 @@
1+
<?xml version="1.0" encoding="UTF-8"?>
2+
3+
<databaseChangeLog
4+
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
5+
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
6+
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">
7+
<includefile="db/changelog/2024/05/initial.xml"/>
8+
</databaseChangeLog>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp