bNvjsinP

1ujeb.se/pppooo
2
3SET ANSI_NULLS ON
4GO
5SET QUOTED_IDENTIFIER ON
6GO
7IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Klienci]') AND type in (N'U'))
8BEGIN
9CREATE TABLE [dbo].[Klienci](
10	[Id] [int] IDENTITY(1,1) NOT NULL,
11	[Klient] [varchar](50) NULL,
12 CONSTRAINT [PK_Klienci] PRIMARY KEY CLUSTERED 
13(
14	[Id] ASC
15)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
16) ON [PRIMARY]
17END
18GO
19SET ANSI_NULLS ON
20GO
21SET QUOTED_IDENTIFIER ON
22GO
23IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Czas]') AND type in (N'U'))
24BEGIN
25CREATE TABLE [dbo].[Czas](
26	[Id] [int] IDENTITY(1,1) NOT NULL,
27	[Miesiac] [int] NULL,
28	[Kwartal] [int] NULL,
29	[Rok] [int] NULL,
30	[Data] [char](7) NULL,
31 CONSTRAINT [PK_Czas] PRIMARY KEY CLUSTERED 
32(
33	[Id] ASC
34)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
35) ON [PRIMARY]
36END
37GO
38SET ANSI_NULLS ON
39GO
40SET QUOTED_IDENTIFIER ON
41GO
42IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Regiony]') AND type in (N'U'))
43BEGIN
44CREATE TABLE [dbo].[Regiony](
45	[Id] [int] IDENTITY(1,1) NOT NULL,
46	[Region] [varchar](20) NULL,
47 CONSTRAINT [PK_Regiony] PRIMARY KEY CLUSTERED 
48(
49	[Id] ASC
50)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
51) ON [PRIMARY]
52END
53GO
54SET ANSI_NULLS ON
55GO
56SET QUOTED_IDENTIFIER ON
57GO
58IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Towary]') AND type in (N'U'))
59BEGIN
60CREATE TABLE [dbo].[Towary](
61	[Id] [int] IDENTITY(1,1) NOT NULL,
62	[Sprzet] [varchar](40) NULL,
63	[Podgrupa] [varchar](40) NULL,
64	[Grupa] [char](2) NULL,
65 CONSTRAINT [PK_Towary] PRIMARY KEY CLUSTERED 
66(
67	[Id] ASC
68)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
69) ON [PRIMARY]
70END
71GO
72SET ANSI_NULLS ON
73GO
74SET QUOTED_IDENTIFIER ON
75GO
76IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sprzedaz_plan]') AND type in (N'U'))
77BEGIN
78CREATE TABLE [dbo].[Sprzedaz_plan](
79	[Cena] [money] NULL,
80	[Ilosc] [money] NULL,
81	[Obrot] [money] NULL,
82	[Klient_Id] [int] NOT NULL,
83	[Region_Id] [int] NOT NULL,
84	[Towary_Id] [int] NOT NULL,
85	[Czas_Id] [int] NOT NULL,
86 CONSTRAINT [PK__Sprzedaz_plan__1B0907CE] PRIMARY KEY CLUSTERED 
87(
88	[Klient_Id] ASC,
89	[Region_Id] ASC,
90	[Towary_Id] ASC,
91	[Czas_Id] ASC
92)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
93) ON [PRIMARY]
94END
95GO
96SET ANSI_NULLS ON
97GO
98SET QUOTED_IDENTIFIER ON
99GO
100IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Sprzedaz_hist]') AND type in (N'U'))
101BEGIN
102CREATE TABLE [dbo].[Sprzedaz_hist](
103	[Cena] [money] NULL,
104	[Ilosc] [money] NULL,
105	[Obrot] [money] NULL,
106	[Klient_Id] [int] NOT NULL,
107	[Region_Id] [int] NOT NULL,
108	[Towary_Id] [int] NOT NULL,
109	[Czas_Id] [int] NOT NULL,
110 CONSTRAINT [PK__Sprzedaz_hist__1BFD2C07] PRIMARY KEY CLUSTERED 
111(
112	[Klient_Id] ASC,
113	[Region_Id] ASC,
114	[Towary_Id] ASC,
115	[Czas_Id] ASC
116)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
117) ON [PRIMARY]
118END
119GO
120IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_plan_Czas]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_plan]'))
121ALTER TABLE [dbo].[Sprzedaz_plan]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_plan_Czas] FOREIGN KEY([Czas_Id])
122REFERENCES [dbo].[Czas] ([Id])
123GO
124IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_plan_Klienci]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_plan]'))
125ALTER TABLE [dbo].[Sprzedaz_plan]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_plan_Klienci] FOREIGN KEY([Klient_Id])
126REFERENCES [dbo].[Klienci] ([Id])
127GO
128IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_plan_Regiony]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_plan]'))
129ALTER TABLE [dbo].[Sprzedaz_plan]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_plan_Regiony] FOREIGN KEY([Region_Id])
130REFERENCES [dbo].[Regiony] ([Id])
131GO
132IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_plan_Towary]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_plan]'))
133ALTER TABLE [dbo].[Sprzedaz_plan]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_plan_Towary] FOREIGN KEY([Towary_Id])
134REFERENCES [dbo].[Towary] ([Id])
135GO
136IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_hist_Czas]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_hist]'))
137ALTER TABLE [dbo].[Sprzedaz_hist]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_hist_Czas] FOREIGN KEY([Czas_Id])
138REFERENCES [dbo].[Czas] ([Id])
139GO
140IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_hist_Klienci]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_hist]'))
141ALTER TABLE [dbo].[Sprzedaz_hist]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_hist_Klienci] FOREIGN KEY([Klient_Id])
142REFERENCES [dbo].[Klienci] ([Id])
143GO
144IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_hist_Regiony]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_hist]'))
145ALTER TABLE [dbo].[Sprzedaz_hist]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_hist_Regiony] FOREIGN KEY([Region_Id])
146REFERENCES [dbo].[Regiony] ([Id])
147GO
148IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sprzedaz_hist_Towary]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sprzedaz_hist]'))
149ALTER TABLE [dbo].[Sprzedaz_hist]  WITH CHECK ADD  CONSTRAINT [FK_Sprzedaz_hist_Towary] FOREIGN KEY([Towary_Id])
150REFERENCES [dbo].[Towary] ([Id])