feat: auto-generating Chinook_PostgreSql_SerialPKs.sql

YavinOwens · Feb 10, 2024 · 8526cb7 · 8526cb7
1 parent 383c1f7
commit 8526cb7
Show file tree

Hide file tree

Showing 6 changed files with 15,742 additions and 31,549 deletions.
diff --git a/ChinookDatabase/DataSources/ChinookDatabase.tt b/ChinookDatabase/DataSources/ChinookDatabase.tt
@@ -23,6 +23,7 @@ var options = new
 								new OracleStrategy { PrimaryKeyStrategy = PrimaryKeyStrategy.None, Encoding = Encoding.UTF8 },
 								new PostgreSqlStrategy { PrimaryKeyStrategy = PrimaryKeyStrategy.None, Encoding = Encoding.Default },
 								new PostgreSqlStrategy { PrimaryKeyStrategy = PrimaryKeyStrategy.Identity, Encoding = Encoding.Default },
+								new PostgreSqlStrategy { PrimaryKeyStrategy = PrimaryKeyStrategy.Serial, Encoding = Encoding.Default },
 								new Db2Strategy { PrimaryKeyStrategy = PrimaryKeyStrategy.None, Encoding = Encoding.Default }
 						   	},
 	OutputFiles = new List<OutputFile>()

diff --git a/ChinookDatabase/DataSources/ChinookDatabase.txt b/ChinookDatabase/DataSources/ChinookDatabase.txt
@@ -29,6 +29,7 @@ This is the list of files included in the complete version.
 | Oracle | {"CreateOracle.bat"} | Batch file to create the Chinook database. |
 | PostgreSql | {"Chinook_PostgreSql.sql"} | SQL script to create the Chinook database.  |
 | PostgreSql | {"Chinook_PostgreSql_AutoIncrementPKs.sql"} | SQL script to create the Chinook database. Auto incremented primary keys. |
+| PostgreSql | {"Chinook_PostgreSql_SerialPKs.sql"} | SQL script to create the Chinook database.  |
 | PostgreSql | {"CreatePostgreSql.bat"} | Batch file to create the Chinook database. |
 | Sqlite | {"Chinook_Sqlite.sql"} | SQL script to create the Chinook database.  |
 | Sqlite | {"Chinook_Sqlite.sqlite"} | Chinook database file.  |