Changeset 9641 for branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql

Timestamp:

06/18/13 11:39:31 (11 years ago)

Author:

spimming

Message:

#1888:

• Users now contain ContactInformation
• Fixed formatting in invoice template
• Fixed calculation for next invoice date
• Worked on indentation for invoice fields

File:

• branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql (modified) (2 diffs)

branches/OaaS/HeuristicLab.Services.Optimization.Billing.Test/DDLScript.sql

@@ -79 +79 @@
 create table [dbo].[Users] (
     [UserId] [bigint] not null identity,
+    [ContactInformationId] [bigint] not null,
     [Name] [nvarchar](max) null,
     primary key ([UserId])
@@ -91 +92 @@
 alter table [dbo].[UsageRecords] add constraint [UsageRecord_Product] foreign key ([ProductId]) references [dbo].[Products]([ProductId]);
 alter table [dbo].[UsageRecords] add constraint [UsageRecord_User] foreign key ([UserId]) references [dbo].[Users]([UserId]);
+alter table [dbo].[Users] add constraint [User_ContactInformation] foreign key ([ContactInformationId]) references [dbo].[ContactInformations]([ContactInformationId]);
 alter table [dbo].[PaymentInformations] add constraint [User_PaymentInformation] foreign key ([UserId]) references [dbo].[Users]([UserId]);