Skip to content

Commit 7aef0c2

Browse files
malinowskikammalinowskikam
committed
OTC-517: Moved all FK constraints from 1_schema_tables.sql
1 parent f944946 commit 7aef0c2

8 files changed

Lines changed: 3568 additions & 3554 deletions

File tree

‎concatenate_files.ps1‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
New-Item -ItemType Directory -Force output | Out-Null
2+
Get-Content (Get-ChildItem 'sql\migrations\1_migration_latest.sql','sql\stored_procedures\*.sql' -Recurse -File) > output\fullMigrationScipt.sql
3+
Get-Content (Get-ChildItem 'sql\base\*.sql','sql\stored_procedures\*.sql' -Recurse -File) > output\fullEmptyDatabase.sql
4+
Get-Content (Get-ChildItem 'sql\base\*.sql','sql\stored_procedures\*.sql','sql\demo\*.sql' -Recurse -File) > output\fullDemoDatabase.sql
5+
Get-Content (Get-ChildItem 'sql\base\*.sql','sql\stored_procedures\*.sql','sql\offline\central.sql' -Recurse -File) > output\fullOfflineCentralDatabase.sql
6+
Get-Content (Get-ChildItem 'sql\base\*.sql','sql\stored_procedures\*.sql','sql\offline\hf.sql' -Recurse -File) > output\fullOfflineHFDatabase.sql

‎concatenate_files.sh‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -3,6 +3,6 @@
33
mkdir output
44
cat sql/migrations/1_migration_latest.sql sql/stored_procedures/*.sql > output/fullMigrationScipt.sql
55
cat sql/base/*.sql sql/stored_procedures/*.sql > output/fullEmptyDatabase.sql
6-
cat sql/base/*.sql sql/stored_procedures/*.sql sql/stored_procedures/*.sql sql/demo/*.sql> output/fullDemoDatabase.sql
7-
cat sql/base/*.sql sql/stored_procedures/*.sql sql/stored_procedures/*.sql sql/offline/central.sql > output/fullOfflineCentralDatabase.sql
8-
cat sql/base/*.sql sql/stored_procedures/*.sql sql/stored_procedures/*.sql sql/offline/hf.sql > output/fullOfflineHFDatabase.sql
6+
cat sql/base/*.sql sql/stored_procedures/*.sql sql/demo/*.sql> output/fullDemoDatabase.sql
7+
cat sql/base/*.sql sql/stored_procedures/*.sql sql/offline/central.sql > output/fullOfflineCentralDatabase.sql
8+
cat sql/base/*.sql sql/stored_procedures/*.sql sql/offline/hf.sql > output/fullOfflineHFDatabase.sql

‎sql/base/1_schema_tables.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -958,7 +958,7 @@ CREATE TABLE [dbo].[tblControlNumber](
958958
[ValidityFrom] [datetime] NULL,
959959
[ValidityTo] [datetime] NULL,
960960
[AuditedUserID] [int] NULL,
961-
[PaymentID] [bigint] NULL CONSTRAINT FK_tblControlNumber_tblPayment FOREIGN KEY REFERENCES tblPayment(PaymentId),
961+
[PaymentID] [bigint] NULL,
962962
[ControlNumber] [nvarchar](50) NULL,
963963
[IssuedDate] [datetime] NULL,
964964
[Comment] [nvarchar](max) NULL,
@@ -1688,7 +1688,7 @@ SET QUOTED_IDENTIFIER ON
16881688
GO
16891689
CREATE TABLE [dbo].[tblPaymentDetails](
16901690
[PaymentDetailsID] [bigint] IDENTITY(1,1) NOT NULL,
1691-
[PaymentID] [bigint] NOT NULL CONSTRAINT FK_tblPaymentDetails_tblPayment FOREIGN KEY REFERENCES tblPayment(PaymentId),
1691+
[PaymentID] [bigint] NOT NULL,
16921692
[ProductCode] [nvarchar](8) NULL,
16931693
[InsuranceNumber] [nvarchar](12) NULL,
16941694
[PolicyStage] [nvarchar](1) NULL,

0 commit comments

Comments
 (0)