-
Notifications
You must be signed in to change notification settings - Fork 0
/
script.sql
334 lines (306 loc) · 91.2 KB
/
script.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
CREATE TABLE [dbo].[ARTISTS](
[GUID] [uniqueidentifier] NOT NULL,
[NAME] [nvarchar](50) NOT NULL,
[BIRTH_DATE] [datetime] NULL,
CONSTRAINT [PK_ARTISTS] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[EVENT_DATE_PLACE](
[EVENT_GUID] [uniqueidentifier] NOT NULL,
[PLACE_GUID] [uniqueidentifier] NOT NULL,
[DATE_BEGIN] [datetime] NOT NULL,
[DATE_END] [datetime] NULL,
[RESERVED_PLACES] [int] NULL,
CONSTRAINT [PK_EVENT_DATE_PLACE] PRIMARY KEY CLUSTERED
(
[EVENT_GUID] ASC,
[PLACE_GUID] ASC,
[DATE_BEGIN] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[EVENT_TYPES](
[GUID] [uniqueidentifier] NOT NULL,
[DESCRIPTION] [nvarchar](50) NULL,
CONSTRAINT [PK_EVENT_TYPES] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[EVENTS](
[GUID] [uniqueidentifier] NOT NULL,
[TITLE] [nvarchar](500) NULL,
[DESCRIPTION] [nvarchar](max) NULL,
[PRICE] [real] NOT NULL,
[EVENT_TYPE_GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_EVENTS] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[EVENTS_ARTISTS](
[EVENTS_GUID] [uniqueidentifier] NOT NULL,
[ARTISTS_GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_EVENTS_ARTISTS] PRIMARY KEY CLUSTERED
(
[EVENTS_GUID] ASC,
[ARTISTS_GUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[PLACES](
[GUID] [uniqueidentifier] NOT NULL,
[NAME] [nvarchar](50) NOT NULL,
[ADRESS] [nvarchar](50) NULL,
[DESCRIPTION] [nvarchar](max) NULL,
[NUMBER_PLACES] [real] NOT NULL,
[WEB_SITE] [nvarchar](500) NULL,
[LOCATION_PERCENT] [numeric](5, 2) NULL,
CONSTRAINT [PK_PLACES] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[USERS](
[LOGIN] [nvarchar](50) NOT NULL,
[PASSWORD] [nvarchar](max) NOT NULL,
[NOM] [nvarchar](50) NULL,
[PRENOM] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[LOGIN] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'54b3a9d4-1fcb-4201-9aba-027f7edda938', N'SCORPIONS', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'62d7af51-d440-4a0a-9b0e-1536b36c6fd4', N'TCHOUPI FAIT SON SPECTACLE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'fb24dd14-b246-46f3-940b-1590ce2dcc31', N'ELIE SEMOUN', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'd17426ac-5f4d-4ae2-b9a8-20d4ef030182', N'DRACULA - L AMOUR PLUS FORT QUE LA MORT', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'91485148-bcf2-4fe5-a8ca-295280f48c90', N'SHOW DANCE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'39b1e14a-db38-4c9b-8906-32e257ddd4cb', N'HOLLIE COOK', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'a4d42cc4-6b7f-40c5-9faf-3505c0501fcd', N'STEPHANE ROUSSEAU', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'5563221b-4113-457c-9103-3582e91545ba', N'MAGIC SYSTEM', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'a7fa2209-8661-4028-b70f-36870867368b', N'YANNICK NOAH', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'f53ccf0e-2ae5-4202-b5a4-3ca22bed9b2b', N'JUSTICE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'59f3f7c7-365e-450e-8179-3eb76b6e575c', N'BENABAR', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'28e41662-a756-4fef-9004-3f5e7b432cfc', N'FREDERIC FRANCOIS', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'0ee1c959-4295-4036-b351-4a82000f3cea', N'ANNIE CORDIE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'33fd7536-2976-40fc-a40a-4da74946b360', N'MIOSSEC', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'df2471d0-ab03-433b-9feb-53dcfdd1470f', N'JULIEN CLERC', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'7b17fcff-22b9-4ca1-859a-5fd64cb73f29', N'CARAVAN PALACE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'301049f8-e9a8-4eb9-ad55-60932d77e6ab', N'ALDEBERT', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'92506379-ef68-4629-9a2d-6592e2394c7e', N'SPARTACUS (Moscou Theatre Ballet)', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'8445b29b-ba53-4a54-860a-695c10c44ea0', N'ORELSAN', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'e6e01982-2f02-4074-9b3b-69a130d9ab2e', N'PATRICK FIORI', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'e615253a-47d7-4c01-bacc-6d097e3cce91', N'LE TOUR DU MONDE EN 80 JOURS (PHILIPPE CANDELORO)', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'3afc9acf-52e3-4371-a38d-78543ff2e53f', N'CABARET, LE MUSICAL DE BROADWAY', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'1d1b66c0-4c06-4d28-9301-7d6fc1d44805', N'CHARLIE WINSTON', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'8fc96ea0-8af8-4ee6-b5d8-7f670ede6865', N'THRILLER LIVE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'fb198939-36ca-43ff-8bfd-85d7ecfb21be', N'LES CHEVALIERS DU FIEL', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'7b2dcc4e-936e-49b2-bac2-8bfd408bbc9a', N'RFM PARTY 80 LA TOURNEE BEST OF', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'24967b23-53e2-4feb-93f4-8c091e01048c', N'STING', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'aea553b9-d096-41fd-8f2e-8c1af8190f2f', N'DISNEY SUR GLACE / LES MONDES ENCHANTES', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'7c27bbcc-e366-4de3-aee3-93aa3a950acd', N'ADAM & EVE LA SECONDE CHANCE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'74072afc-17ef-46df-8b4c-9447b4afff1f', N'IZIA', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'fec89f24-edf0-47be-8581-9b2089559416', N'MAMMA MIA !', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'97a55459-03fd-4669-9a31-9b9351fa4d9e', N'MICHEL DELPECH', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'916912e9-ff50-4179-b11f-a2af925297d1', N'TRYO', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'3fceead4-2ef8-4ab6-8627-ab0ff7ace89f', N'FABRICE EBOUE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'2d296e4d-3feb-4d92-a7f8-b4beb0cbda5f', N'SHEILA', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'99b800a8-f79c-4315-90fd-b524437d5499', N'DANI LARY', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'ffe21c4e-7b87-4eef-a54c-c0068a8791ed', N'test', CAST(0x0000A150016BB860 AS DateTime))
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'1f061a67-4537-4382-9d0e-c33d13ee8cd3', N'VERONIC DICAIRE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'ec65d061-97e5-46b6-86ee-c549cc5e398d', N'AUGUST BURNS RED', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'd0a977f0-e09a-40c0-8248-c597de99b4bb', N'VOCA PEOPLE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'7bf44bb9-943c-4969-abac-c938d1e51e9c', N'LE BAL DE L AFRIQUE ENCHANTEE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'3742c4d3-8c3d-4e74-b296-cf0342e2d317', N'OPERA ECLATE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'0943fd52-4e57-44da-a5f3-e41b3acfcf0a', N'KRONOS QUARTET', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'1a429f1e-f556-4351-a019-e86f32a82afa', N'ROCK THE BALLET', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'b702e080-ea4f-4505-92ac-e87971634a57', N'HOLIDAY ON ICE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'fa17aecb-d7f8-4ade-a2ba-ea6c6e3530f0', N'THE DELANO ORCHESTRA', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'341ea982-11e5-477a-b9f0-f5a1ebc4f789', N'ZAZIE', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'b1027731-0cc1-42e2-87c5-f8bee6b9ce0a', N'SIMPLE PLAN', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'2ce47841-2758-48e3-b6f2-f9972d1eebe9', N'GERARD LENORMAN', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'0667d810-1c50-4e0d-8be2-fa91c2fb332f', N'MULAN (par LES ETOILES DU CIRQUE DE PEKIN)', NULL)
INSERT [dbo].[ARTISTS] ([GUID], [NAME], [BIRTH_DATE]) VALUES (N'c6223cda-4fe6-42d0-b5c2-fc051d4d99e7', N'ELISABETH BUFFET', NULL)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'668112c6-e0a5-4c74-90f3-018dac823e60', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FFB0151D460 AS DateTime), CAST(0x00009FFB00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'87baa67a-d007-4603-ac78-0371ca67b7d5', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0130151D460 AS DateTime), CAST(0x0000A01300000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'64f2ba3a-4fac-46e9-b5ee-050f53c924fd', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x00009FDF0151D460 AS DateTime), CAST(0x00009FDF00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'af62f733-19cf-4f5b-b649-07372ab2c414', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x00009FE20151D460 AS DateTime), CAST(0x00009FE200000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'af62f733-19cf-4f5b-b649-07372ab2c414', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x00009FE30151D460 AS DateTime), CAST(0x00009FE300000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'17d01afb-de65-4090-9ccc-136d7696b1be', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0E80151D460 AS DateTime), CAST(0x0000A0E800000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'17d01afb-de65-4090-9ccc-136d7696b1be', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0E90151D460 AS DateTime), CAST(0x0000A0E900000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'895e3a88-8a32-4229-b771-1982993e2397', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A02C01457850 AS DateTime), CAST(0x0000A02C00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'8def45fc-d0f7-4798-a759-1a7f8e1ea172', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FD501499700 AS DateTime), CAST(0x00009FD500000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'5cacbe87-8757-4f15-a15d-2c7287ac7457', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A01B015A11C0 AS DateTime), CAST(0x0000A01B00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'523b8978-f1e1-4987-8782-2e02155d87fb', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0010151D460 AS DateTime), CAST(0x0000A00100000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'09baea59-0575-4cb5-94b0-31c41ae76400', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A01800FF6EA0 AS DateTime), CAST(0x0000A01800000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'58e569bd-12fb-4630-8ec3-3604e921a63a', N'68874d7a-32cf-498c-8412-00aeef38981c', CAST(0x00009FD10151D460 AS DateTime), CAST(0x00009FD100000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'30004e81-c4e8-4aba-8b42-361eb6dbb1c1', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A01E0151D460 AS DateTime), CAST(0x0000A01E00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'30004e81-c4e8-4aba-8b42-361eb6dbb1c1', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A01F0151D460 AS DateTime), CAST(0x0000A01F00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'04f754bc-d4e6-4e06-9ffe-3a587ebc140b', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A05901499700 AS DateTime), CAST(0x0000A05900000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'7ec1fcca-0260-4409-938a-4a40cf638c66', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0280151D460 AS DateTime), CAST(0x0000A02800000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'2c55d4a7-ef31-4cc1-bcb8-52d3944e2c6e', N'68874d7a-32cf-498c-8412-00aeef38981c', CAST(0x00009FDD0151D460 AS DateTime), CAST(0x00009FDD00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'c7801a87-5c44-44b5-bec0-55de4a0a7358', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A017016A8C80 AS DateTime), CAST(0x0000A01700000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'746a669f-b14a-4ff0-9c27-5c8bfe815ba0', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0100151D460 AS DateTime), CAST(0x0000A01000000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'3e5f6727-4079-4d6e-96b4-5f021ee64b63', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A00D0151D460 AS DateTime), CAST(0x0000A00D00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'c2f9fb8e-2c65-4370-a202-629fecd3e93b', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A0750151D460 AS DateTime), CAST(0x0000A07500000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'c3b065e8-83b9-42fe-bd9c-63194b38bcf1', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0250151D460 AS DateTime), CAST(0x0000A02500000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'bc982fc4-75df-4071-9804-712b2ff14a87', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FE50151D460 AS DateTime), CAST(0x00009FE500000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'697150dc-84cf-4c2f-8fe6-726bb3cc64e4', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A02401499700 AS DateTime), CAST(0x0000A02400000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'f6038ff6-8925-4265-b71f-72da040d0071', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A0130151D460 AS DateTime), CAST(0x0000A01300000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'265a4e97-25d6-46f5-903d-787cea4ec807', N'68874d7a-32cf-498c-8412-00aeef38981c', CAST(0x00009FDB01499700 AS DateTime), CAST(0x00009FDB00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'c0e51606-0914-4eac-97e9-7886d10be5e1', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0570130DEE0 AS DateTime), CAST(0x0000A05700000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'1ff48408-cd50-411f-b697-7bce6db8005a', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A017014DB5B0 AS DateTime), CAST(0x0000A01700000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'61b3ff9d-81f3-412a-bfc6-7dfa32b4648d', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0F401499700 AS DateTime), CAST(0x0000A0F400000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'91c8a07f-334e-40a7-b838-894b74f7765b', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A05D015A11C0 AS DateTime), CAST(0x0000A05D00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'ff3f271e-3ce7-4986-a16f-894ca4fa90d8', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0480151D460 AS DateTime), CAST(0x0000A04800000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'e56acfee-722f-46a0-ab9e-91c6d59062af', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x00009FD80151D460 AS DateTime), CAST(0x00009FD800000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'436cb84f-daa9-4a0e-a56c-9aeb15a0a1ae', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A06101499700 AS DateTime), CAST(0x0000A06100000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'27173111-6143-4bd9-b939-afa5cea615db', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A04701499700 AS DateTime), CAST(0x0000A04700000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'389933ea-0a84-49dc-8cfb-b3b751e8980f', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A0070151D460 AS DateTime), CAST(0x0000A00700000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'c968dad0-6952-428c-b747-b3e67c94e55f', N'68874d7a-32cf-498c-8412-00aeef38981c', CAST(0x0000A01E0151D460 AS DateTime), CAST(0x0000A01E00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'f83dd128-fd91-4fbc-b6b7-b824c8bdb089', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0090151D460 AS DateTime), CAST(0x0000A00900000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'acb477c2-9251-48d0-86ca-b976a18271fc', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0400151D460 AS DateTime), CAST(0x0000A04000000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'acb477c2-9251-48d0-86ca-b976a18271fc', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0410151D460 AS DateTime), CAST(0x0000A04100000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'acb477c2-9251-48d0-86ca-b976a18271fc', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0420151D460 AS DateTime), CAST(0x0000A04200000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'1b22ef71-79b5-48b1-9871-b9d952256b21', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0FD0151D460 AS DateTime), CAST(0x0000A0FD00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'1b22ef71-79b5-48b1-9871-b9d952256b21', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A0FE0151D460 AS DateTime), CAST(0x0000A0FE00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'afc9a070-47b2-4fcb-8c61-bc2ee5e7d5af', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A00E0151D460 AS DateTime), CAST(0x0000A00E00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'a22bb1ac-f072-4438-af82-c3781ff8509c', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FF10151D460 AS DateTime), CAST(0x00009FF100000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'0ec84437-d784-4669-b472-cb2d494773c3', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FD80151D460 AS DateTime), CAST(0x00009FD800000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'530bc3ba-b457-46d1-8518-cb5f2c39a174', N'70261e05-6a5f-40f8-8a87-b550ce6b07dc', CAST(0x0000A0CD00000000 AS DateTime), CAST(0x0000A13800000000 AS DateTime), 150)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'0bd844a9-6617-4cb9-a250-d32347faf093', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A00F0151D460 AS DateTime), CAST(0x0000A00F00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'e76f67b3-34fa-4fb9-a93e-d5f4f22ba086', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FEC0151D460 AS DateTime), CAST(0x00009FEC00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'355c8b90-98b0-4e96-b795-d97b320f0eca', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x0000A00A011826C0 AS DateTime), CAST(0x0000A00A00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'03c1c537-d996-47b0-b272-ead5d82f4712', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x00009FE20151D460 AS DateTime), CAST(0x00009FE200000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'aff6f645-f778-4c92-9e87-f471a42abead', N'02067331-7162-4c80-9133-921ae828556b', CAST(0x00009ECB01499700 AS DateTime), CAST(0x00009ECB00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'726aee7e-e79f-43b2-9668-f5696b4a25f1', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A0250151D460 AS DateTime), CAST(0x0000A02500000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'96ca7bf8-fb6f-4325-97ef-f8f3146d400c', N'a7c77b00-887b-4f1e-9a17-142830855d4b', CAST(0x0000A03D0151D460 AS DateTime), CAST(0x0000A03D00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_DATE_PLACE] ([EVENT_GUID], [PLACE_GUID], [DATE_BEGIN], [DATE_END], [RESERVED_PLACES]) VALUES (N'40c68d22-e531-4fcc-b456-fcb69be5a3f0', N'68874d7a-32cf-498c-8412-00aeef38981c', CAST(0x0000A00E01499700 AS DateTime), CAST(0x0000A00E00000000 AS DateTime), 800)
INSERT [dbo].[EVENT_TYPES] ([GUID], [DESCRIPTION]) VALUES (N'9cc78b3e-3296-4746-a737-760f66ddb830', N'Exposition')
INSERT [dbo].[EVENT_TYPES] ([GUID], [DESCRIPTION]) VALUES (N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40', N'Concert')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'668112c6-e0a5-4c74-90f3-018dac823e60', N'HOLLIE COOK', NULL, 22, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'87baa67a-d007-4603-ac78-0371ca67b7d5', N'ROCK THE BALLET', NULL, 46, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'64f2ba3a-4fac-46e9-b5ee-050f53c924fd', N'DANI LARY', N'Magie', 48, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'af62f733-19cf-4f5b-b649-07372ab2c414', N'DISNEY SUR GLACE / LES MONDES ENCHANTES', NULL, 45, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'17d01afb-de65-4090-9ccc-136d7696b1be', N'ADAM & EVE LA SECONDE CHANCE', NULL, 25, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'895e3a88-8a32-4229-b771-1982993e2397', N'BENABAR', N'Concert', 30, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'8def45fc-d0f7-4798-a759-1a7f8e1ea172', N'ZAZIE', N'Concert', 45, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'5cacbe87-8757-4f15-a15d-2c7287ac7457', N'TCHOUPI FAIT SON SPECTACLE', NULL, 25, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'523b8978-f1e1-4987-8782-2e02155d87fb', N'STING', N'Concert', 40, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'09baea59-0575-4cb5-94b0-31c41ae76400', N'SPARTACUS (Moscou Theatre Ballet)', N'Comédie musicale', 42, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'58e569bd-12fb-4630-8ec3-3604e921a63a', N'ELISABETH BUFFET', NULL, 28, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'30004e81-c4e8-4aba-8b42-361eb6dbb1c1', N'CABARET, LE MUSICAL DE BROADWAY', NULL, 79, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'04f754bc-d4e6-4e06-9ffe-3a587ebc140b', N'JULIEN CLERC', N'Concert', 40, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'7ec1fcca-0260-4409-938a-4a40cf638c66', N'VOCA PEOPLE', N'Concert', 43, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'2c55d4a7-ef31-4cc1-bcb8-52d3944e2c6e', N'KRONOS QUARTET', NULL, 27, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'c7801a87-5c44-44b5-bec0-55de4a0a7358', N'LE BAL DE L AFRIQUE ENCHANTEE', NULL, 14, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'746a669f-b14a-4ff0-9c27-5c8bfe815ba0', N'MULAN (par LES ETOILES DU CIRQUE DE PEKIN)', NULL, 36, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'3e5f6727-4079-4d6e-96b4-5f021ee64b63', N'STEPHANE ROUSSEAU', N'Humour', 39, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'c2f9fb8e-2c65-4370-a202-629fecd3e93b', N'AUGUST BURNS RED', NULL, 22, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'c3b065e8-83b9-42fe-bd9c-63194b38bcf1', N'AGE TENDRE ET TETES DE BOIS - 7eme SAISON', N'Concert', 50, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'bc982fc4-75df-4071-9804-712b2ff14a87', N'JUSTICE', NULL, 50, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'697150dc-84cf-4c2f-8fe6-726bb3cc64e4', N'YANNICK NOAH', N'Concert', 49, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'f6038ff6-8925-4265-b71f-72da040d0071', N'ALDEBERT', NULL, 27, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'265a4e97-25d6-46f5-903d-787cea4ec807', N'OPERA ECLATE', NULL, 45, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'c0e51606-0914-4eac-97e9-7886d10be5e1', N'THRILLER LIVE', NULL, 70, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'1ff48408-cd50-411f-b697-7bce6db8005a', N'RFM PARTY 80 LA TOURNEE BEST OF', NULL, 55, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'61b3ff9d-81f3-412a-bfc6-7dfa32b4648d', N'TRYO', N'Concert', 35, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'91c8a07f-334e-40a7-b838-894b74f7765b', N'DRACULA - L AMOUR PLUS FORT QUE LA MORT', N'Comedie Musicale', 45, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'ff3f271e-3ce7-4986-a16f-894ca4fa90d8', N'FREDERIC FRANCOIS', N'Concert', 50, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'e56acfee-722f-46a0-ab9e-91c6d59062af', N'PATRICK FIORI', N'Concert', 44, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'436cb84f-daa9-4a0e-a56c-9aeb15a0a1ae', N'SCORPIONS', N'Concert', 66, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'27173111-6143-4bd9-b939-afa5cea615db', N'ELIE SEMOUN', N'Humour', 40, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'389933ea-0a84-49dc-8cfb-b3b751e8980f', N'ORELSAN', NULL, 22, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'c968dad0-6952-428c-b747-b3e67c94e55f', N'GERARD LENORMAN', N'Concert', 40, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'f83dd128-fd91-4fbc-b6b7-b824c8bdb089', N'VERONIC DICAIRE', NULL, 43, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'acb477c2-9251-48d0-86ca-b976a18271fc', N'HOLIDAY ON ICE', N'Comedie Musicale sur Pattins :)', 50, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'1b22ef71-79b5-48b1-9871-b9d952256b21', N'MAMMA MIA !', N'Comedie Musicale', 35, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'afc9a070-47b2-4fcb-8c61-bc2ee5e7d5af', N'LES CHEVALIERS DU FIEL', N'Humour', 48, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'a22bb1ac-f072-4438-af82-c3781ff8509c', N'MIOSSEC', NULL, 24, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'0ec84437-d784-4669-b472-cb2d494773c3', N'THE DELANO ORCHESTRA', NULL, 13, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'530bc3ba-b457-46d1-8518-cb5f2c39a174', N'Du crayon au pinceau, les coulisses de la création.', N'Expo temporaire qui propose les oeuvres préparatoires de tableaux présentés dans les collections du MARQ', 20, N'9cc78b3e-3296-4746-a737-760f66ddb830')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'0bd844a9-6617-4cb9-a250-d32347faf093', N'CHARLIE WINSTON', NULL, 27, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'e76f67b3-34fa-4fb9-a93e-d5f4f22ba086', N'IZIA', NULL, 25, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'355c8b90-98b0-4e96-b795-d97b320f0eca', N'LE TOUR DU MONDE EN 80 JOURS (PHILIPPE CANDELORO)', NULL, 49, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'03c1c537-d996-47b0-b272-ead5d82f4712', N'FABRICE EBOUE', N'Humour', 28, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'aff6f645-f778-4c92-9e87-f471a42abead', N'MAGIC SYSTEM', NULL, 29, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'726aee7e-e79f-43b2-9668-f5696b4a25f1', N'CARAVAN PALACE', NULL, 20, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'96ca7bf8-fb6f-4325-97ef-f8f3146d400c', N'SIMPLE PLAN', NULL, 29, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS] ([GUID], [TITLE], [DESCRIPTION], [PRICE], [EVENT_TYPE_GUID]) VALUES (N'40c68d22-e531-4fcc-b456-fcb69be5a3f0', N'SHOW DANCE', NULL, 40, N'203cfa80-472d-47fa-acf6-f3ac8b7f2c40')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'668112c6-e0a5-4c74-90f3-018dac823e60', N'39b1e14a-db38-4c9b-8906-32e257ddd4cb')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'87baa67a-d007-4603-ac78-0371ca67b7d5', N'1a429f1e-f556-4351-a019-e86f32a82afa')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'64f2ba3a-4fac-46e9-b5ee-050f53c924fd', N'99b800a8-f79c-4315-90fd-b524437d5499')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'af62f733-19cf-4f5b-b649-07372ab2c414', N'aea553b9-d096-41fd-8f2e-8c1af8190f2f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'17d01afb-de65-4090-9ccc-136d7696b1be', N'7c27bbcc-e366-4de3-aee3-93aa3a950acd')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'895e3a88-8a32-4229-b771-1982993e2397', N'59f3f7c7-365e-450e-8179-3eb76b6e575c')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'8def45fc-d0f7-4798-a759-1a7f8e1ea172', N'341ea982-11e5-477a-b9f0-f5a1ebc4f789')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'5cacbe87-8757-4f15-a15d-2c7287ac7457', N'62d7af51-d440-4a0a-9b0e-1536b36c6fd4')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'523b8978-f1e1-4987-8782-2e02155d87fb', N'24967b23-53e2-4feb-93f4-8c091e01048c')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'09baea59-0575-4cb5-94b0-31c41ae76400', N'92506379-ef68-4629-9a2d-6592e2394c7e')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'58e569bd-12fb-4630-8ec3-3604e921a63a', N'c6223cda-4fe6-42d0-b5c2-fc051d4d99e7')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'30004e81-c4e8-4aba-8b42-361eb6dbb1c1', N'3afc9acf-52e3-4371-a38d-78543ff2e53f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'04f754bc-d4e6-4e06-9ffe-3a587ebc140b', N'df2471d0-ab03-433b-9feb-53dcfdd1470f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'7ec1fcca-0260-4409-938a-4a40cf638c66', N'd0a977f0-e09a-40c0-8248-c597de99b4bb')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'2c55d4a7-ef31-4cc1-bcb8-52d3944e2c6e', N'0943fd52-4e57-44da-a5f3-e41b3acfcf0a')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c7801a87-5c44-44b5-bec0-55de4a0a7358', N'7bf44bb9-943c-4969-abac-c938d1e51e9c')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'746a669f-b14a-4ff0-9c27-5c8bfe815ba0', N'0667d810-1c50-4e0d-8be2-fa91c2fb332f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'3e5f6727-4079-4d6e-96b4-5f021ee64b63', N'a4d42cc4-6b7f-40c5-9faf-3505c0501fcd')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c2f9fb8e-2c65-4370-a202-629fecd3e93b', N'ec65d061-97e5-46b6-86ee-c549cc5e398d')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c3b065e8-83b9-42fe-bd9c-63194b38bcf1', N'0ee1c959-4295-4036-b351-4a82000f3cea')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c3b065e8-83b9-42fe-bd9c-63194b38bcf1', N'97a55459-03fd-4669-9a31-9b9351fa4d9e')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c3b065e8-83b9-42fe-bd9c-63194b38bcf1', N'2d296e4d-3feb-4d92-a7f8-b4beb0cbda5f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'bc982fc4-75df-4071-9804-712b2ff14a87', N'f53ccf0e-2ae5-4202-b5a4-3ca22bed9b2b')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'697150dc-84cf-4c2f-8fe6-726bb3cc64e4', N'a7fa2209-8661-4028-b70f-36870867368b')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'f6038ff6-8925-4265-b71f-72da040d0071', N'301049f8-e9a8-4eb9-ad55-60932d77e6ab')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'265a4e97-25d6-46f5-903d-787cea4ec807', N'3742c4d3-8c3d-4e74-b296-cf0342e2d317')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c0e51606-0914-4eac-97e9-7886d10be5e1', N'8fc96ea0-8af8-4ee6-b5d8-7f670ede6865')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'1ff48408-cd50-411f-b697-7bce6db8005a', N'7b2dcc4e-936e-49b2-bac2-8bfd408bbc9a')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'61b3ff9d-81f3-412a-bfc6-7dfa32b4648d', N'916912e9-ff50-4179-b11f-a2af925297d1')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'91c8a07f-334e-40a7-b838-894b74f7765b', N'd17426ac-5f4d-4ae2-b9a8-20d4ef030182')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'ff3f271e-3ce7-4986-a16f-894ca4fa90d8', N'28e41662-a756-4fef-9004-3f5e7b432cfc')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'e56acfee-722f-46a0-ab9e-91c6d59062af', N'e6e01982-2f02-4074-9b3b-69a130d9ab2e')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'436cb84f-daa9-4a0e-a56c-9aeb15a0a1ae', N'54b3a9d4-1fcb-4201-9aba-027f7edda938')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'27173111-6143-4bd9-b939-afa5cea615db', N'fb24dd14-b246-46f3-940b-1590ce2dcc31')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'389933ea-0a84-49dc-8cfb-b3b751e8980f', N'8445b29b-ba53-4a54-860a-695c10c44ea0')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'c968dad0-6952-428c-b747-b3e67c94e55f', N'2ce47841-2758-48e3-b6f2-f9972d1eebe9')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'f83dd128-fd91-4fbc-b6b7-b824c8bdb089', N'1f061a67-4537-4382-9d0e-c33d13ee8cd3')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'acb477c2-9251-48d0-86ca-b976a18271fc', N'b702e080-ea4f-4505-92ac-e87971634a57')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'1b22ef71-79b5-48b1-9871-b9d952256b21', N'fec89f24-edf0-47be-8581-9b2089559416')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'afc9a070-47b2-4fcb-8c61-bc2ee5e7d5af', N'fb198939-36ca-43ff-8bfd-85d7ecfb21be')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'a22bb1ac-f072-4438-af82-c3781ff8509c', N'33fd7536-2976-40fc-a40a-4da74946b360')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'0ec84437-d784-4669-b472-cb2d494773c3', N'fa17aecb-d7f8-4ade-a2ba-ea6c6e3530f0')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'0bd844a9-6617-4cb9-a250-d32347faf093', N'1d1b66c0-4c06-4d28-9301-7d6fc1d44805')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'e76f67b3-34fa-4fb9-a93e-d5f4f22ba086', N'74072afc-17ef-46df-8b4c-9447b4afff1f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'355c8b90-98b0-4e96-b795-d97b320f0eca', N'e615253a-47d7-4c01-bacc-6d097e3cce91')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'03c1c537-d996-47b0-b272-ead5d82f4712', N'3fceead4-2ef8-4ab6-8627-ab0ff7ace89f')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'aff6f645-f778-4c92-9e87-f471a42abead', N'5563221b-4113-457c-9103-3582e91545ba')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'726aee7e-e79f-43b2-9668-f5696b4a25f1', N'7b17fcff-22b9-4ca1-859a-5fd64cb73f29')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'96ca7bf8-fb6f-4325-97ef-f8f3146d400c', N'b1027731-0cc1-42e2-87c5-f8bee6b9ce0a')
INSERT [dbo].[EVENTS_ARTISTS] ([EVENTS_GUID], [ARTISTS_GUID]) VALUES (N'40c68d22-e531-4fcc-b456-fcb69be5a3f0', N'91485148-bcf2-4fe5-a8ca-295280f48c90')
INSERT [dbo].[PLACES] ([GUID], [NAME], [ADRESS], [DESCRIPTION], [NUMBER_PLACES], [WEB_SITE], [LOCATION_PERCENT]) VALUES (N'68874d7a-32cf-498c-8412-00aeef38981c', N'Maison de la culture', N'Bd François Mitterrand 63000 Clermont Ferrand', N'Salle de spectacle', 1000, N'http://www.clermont-ferrand.fr', CAST(2.50 AS Numeric(5, 2)))
INSERT [dbo].[PLACES] ([GUID], [NAME], [ADRESS], [DESCRIPTION], [NUMBER_PLACES], [WEB_SITE], [LOCATION_PERCENT]) VALUES (N'a7c77b00-887b-4f1e-9a17-142830855d4b', N'Coopérative de mai', N'rue serge Gainsbourg 63000 Clermont Ferrand', N'Première scène de musiques actuelles de Clermont-Ferrand mais aussi de toute la région Auvergne, elle se situe à une place stratégique dans la ville, place du 1er Mai, sur les vestiges de lancienne coopérative Michelin : à dix minutes du centre ville.', 1500, N'www.lacoope.org', CAST(5.00 AS Numeric(5, 2)))
INSERT [dbo].[PLACES] ([GUID], [NAME], [ADRESS], [DESCRIPTION], [NUMBER_PLACES], [WEB_SITE], [LOCATION_PERCENT]) VALUES (N'02067331-7162-4c80-9133-921ae828556b', N'Zenith d''Auvergne', N'Plaine de Sarliève BP80 63802 Cournon d''Auvergne', N'Intégré à l''ensemble Grande Halle d''Auvergne, à laquelle il donne une signature architecturale forte avec sa silhouette en forme de cheminée de volcan et ses hublots circulaires, le Zénith est une salle de spectacle qui obéit à sa propre programmation, indépendamment des autres manifestations programmées à la Grande Halle.', 8500, N'http://www.zenith-auvergne.com', CAST(10.00 AS Numeric(5, 2)))
INSERT [dbo].[PLACES] ([GUID], [NAME], [ADRESS], [DESCRIPTION], [NUMBER_PLACES], [WEB_SITE], [LOCATION_PERCENT]) VALUES (N'70261e05-6a5f-40f8-8a87-b550ce6b07dc', N'Musée d''Art Roger Quillot', N'place Louis Detaix', N'Musée des Beaux Arts', 2000, N'http://www.clermont-ferrand.fr/-Musee-d-art-Roger-Quilliot-MARQ-40-.html', CAST(3.75 AS Numeric(5, 2)))
INSERT [dbo].[USERS] ([LOGIN], [PASSWORD], [NOM], [PRENOM]) VALUES (N'Toto', N'12299170891009567410982971131211871132061153230', N'Toto', N'Toto')
ALTER TABLE [dbo].[ARTISTS] ADD CONSTRAINT [DF_ARTISTS_GUID] DEFAULT (newid()) FOR [GUID]
ALTER TABLE [dbo].[EVENT_TYPES] ADD CONSTRAINT [DF_EVENT_TYPES_GUID] DEFAULT (newid()) FOR [GUID]
ALTER TABLE [dbo].[EVENTS] ADD CONSTRAINT [DF_EVENTS_GUID] DEFAULT (newid()) FOR [GUID]
ALTER TABLE [dbo].[EVENTS] ADD CONSTRAINT [DF_EVENTS_PRICE] DEFAULT ((0)) FOR [PRICE]
ALTER TABLE [dbo].[PLACES] ADD CONSTRAINT [DF_PLACES_GUID] DEFAULT (newid()) FOR [GUID]
ALTER TABLE [dbo].[PLACES] ADD CONSTRAINT [DF_PLACE_NUMBER_PLACES] DEFAULT ((1)) FOR [NUMBER_PLACES]
ALTER TABLE [dbo].[EVENT_DATE_PLACE] WITH CHECK ADD CONSTRAINT [FK_EVENT_DATE_PLACE_EVENTS] FOREIGN KEY([EVENT_GUID])
REFERENCES [dbo].[EVENTS] ([GUID])
ALTER TABLE [dbo].[EVENT_DATE_PLACE] CHECK CONSTRAINT [FK_EVENT_DATE_PLACE_EVENTS]
ALTER TABLE [dbo].[EVENT_DATE_PLACE] WITH CHECK ADD CONSTRAINT [FK_EVENT_DATE_PLACE_PLACES] FOREIGN KEY([PLACE_GUID])
REFERENCES [dbo].[PLACES] ([GUID])
ALTER TABLE [dbo].[EVENT_DATE_PLACE] CHECK CONSTRAINT [FK_EVENT_DATE_PLACE_PLACES]
ALTER TABLE [dbo].[EVENTS] WITH CHECK ADD CONSTRAINT [FK_EVENTS_EVENT_TYPES] FOREIGN KEY([EVENT_TYPE_GUID])
REFERENCES [dbo].[EVENT_TYPES] ([GUID])
ALTER TABLE [dbo].[EVENTS] CHECK CONSTRAINT [FK_EVENTS_EVENT_TYPES]
ALTER TABLE [dbo].[EVENTS_ARTISTS] WITH CHECK ADD CONSTRAINT [FK_EVENTS_ARTISTS_ARTISTS] FOREIGN KEY([ARTISTS_GUID])
REFERENCES [dbo].[ARTISTS] ([GUID])
ALTER TABLE [dbo].[EVENTS_ARTISTS] CHECK CONSTRAINT [FK_EVENTS_ARTISTS_ARTISTS]
ALTER TABLE [dbo].[EVENTS_ARTISTS] WITH CHECK ADD CONSTRAINT [FK_EVENTS_ARTISTS_EVENTS] FOREIGN KEY([EVENTS_GUID])
REFERENCES [dbo].[EVENTS] ([GUID])
ALTER TABLE [dbo].[EVENTS_ARTISTS] CHECK CONSTRAINT [FK_EVENTS_ARTISTS_EVENTS]