-
Notifications
You must be signed in to change notification settings - Fork 0
/
script.sql
61 lines (55 loc) · 4.31 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
USE [band_tracker]
GO
/****** Object: Table [dbo].[bands] Script Date: 8/5/2016 11:29:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[bands](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[venues] Script Date: 8/5/2016 11:29:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[venues](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](255) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[venues_bands] Script Date: 8/5/2016 11:29:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[venues_bands](
[id] [int] IDENTITY(1,1) NOT NULL,
[venue_id] [int] NULL,
[band_id] [int] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[bands] ON
INSERT [dbo].[bands] ([id], [name]) VALUES (13, N'GnR')
INSERT [dbo].[bands] ([id], [name]) VALUES (14, N'Primus')
INSERT [dbo].[bands] ([id], [name]) VALUES (15, N'Metallica')
SET IDENTITY_INSERT [dbo].[bands] OFF
SET IDENTITY_INSERT [dbo].[venues] ON
INSERT [dbo].[venues] ([id], [name]) VALUES (8, N'Paramont')
INSERT [dbo].[venues] ([id], [name]) VALUES (7, N'Rock Candy')
INSERT [dbo].[venues] ([id], [name]) VALUES (9, N'Pheonix')
SET IDENTITY_INSERT [dbo].[venues] OFF
SET IDENTITY_INSERT [dbo].[venues_bands] ON
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (1, 6, 5)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (2, 6, 2)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (3, 6, 3)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (4, 7, 1)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (5, 7, 3)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (6, 8, 13)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (7, 9, 15)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (8, 7, 14)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (9, 8, 14)
INSERT [dbo].[venues_bands] ([id], [venue_id], [band_id]) VALUES (10, 8, 15)
SET IDENTITY_INSERT [dbo].[venues_bands] OFF