· 9 years ago · Jan 31, 2017, 07:26 PM
1IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[venueseries_publication]') AND type in (N'U'))
2 DROP TABLE [dbo].[venueseries_publication]
3GO
4
5IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[author_publication]') AND type in (N'U'))
6 DROP TABLE [dbo].[author_publication]
7GO
8
9IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[author]') AND type in (N'U'))
10 DROP TABLE [dbo].[author]
11GO
12
13CREATE TABLE [author] (
14 [id] int NOT NULL,
15 [name] varchar(50),
16 [vorname] varchar(50),
17 [familienname] varchar(50),
18 [homepage] varchar(500)
19)
20
21ALTER TABLE [author] ADD PRIMARY KEY ([id])
22
23IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[publication]') AND type in (N'U'))
24 DROP TABLE [dbo].[publication]
25GO
26
27CREATE TABLE [publication] (
28 [id] int NOT NULL,
29 [dblp_code] varchar(1000),
30 [title] varchar(1000),
31 [jahr] varchar(1000),
32 [startseite] varchar(1000),
33 [endseite] varchar(1000)
34)
35
36ALTER TABLE [publication] ADD PRIMARY KEY ([id])
37
38CREATE TABLE [author_publication] (
39 [publication_id] int,
40 [author_id] int,
41 [position] int,
42 CONSTRAINT fk_author_publication1 FOREIGN KEY(publication_id) REFERENCES [publication](id),
43 CONSTRAINT fk_author_publication2 FOREIGN KEY(author_id) REFERENCES [author](id)
44)
45
46IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[venueseries]') AND type in (N'U'))
47 DROP TABLE [dbo].[venueseries]
48GO
49
50CREATE TABLE [venueseries] (
51 [id] int NOT NULL,
52 [name] varchar(250),
53 [typ] varchar(250)
54)
55
56ALTER TABLE [venueseries] ADD PRIMARY KEY ([id])
57
58CREATE TABLE [venueseries_publication] (
59 [venue_id] int,
60 [publication_id] int,
61 CONSTRAINT fk_venueseries_publication1 FOREIGN KEY(venue_id) REFERENCES [venueseries](id),
62 CONSTRAINT fk_venueseries_publication2 FOREIGN KEY(publication_id) REFERENCES [publication](id)
63)
64
65IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OLE DB-Ziel ACM Author]') AND type in (N'U'))
66 DROP TABLE [dbo].[OLE DB-Ziel ACM Author]
67GO
68
69CREATE TABLE [OLE DB-Ziel ACM Author] (
70 [pos] tinyint,
71 [Name] nvarchar(255),
72 [Institution] nvarchar(255),
73 [Publication_Id] numeric(20,0)
74)
75
76IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OLE DB-Ziel ACM CitingPub]') AND type in (N'U'))
77 DROP TABLE [dbo].[OLE DB-Ziel ACM CitingPub]
78GO
79
80CREATE TABLE [OLE DB-Ziel ACM CitingPub] (
81 [id] bigint NOT NULL,
82 [text] nvarchar(4000),
83 [Publication_Id] numeric(20,0),
84)
85
86IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OLE DB-Ziel ACM Publication]') AND type in (N'U'))
87 DROP TABLE [dbo].[OLE DB-Ziel ACM Publication]
88GO
89
90CREATE TABLE [OLE DB-Ziel ACM Publication] (
91 [Publication_Id] numeric(20,0) NOT NULL,
92 [id] bigint,
93 [Title] nvarchar(1000),
94 [Fulltext] nvarchar(255),
95 [StartPage] int,
96 [EndPage] int
97)
98
99IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OLE DB-Ziel ACM Venue]') AND type in (N'U'))
100 DROP TABLE [dbo].[OLE DB-Ziel ACM Venue]
101GO
102
103CREATE TABLE [OLE DB-Ziel ACM Venue] (
104 [id] bigint NOT NULL,
105 [year] int,
106 [text] nvarchar(255),
107 [Publication_Id] numeric(20,0)
108)
109
110IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OLE DB-Ziel ACM VenueSeries]') AND type in (N'U'))
111 DROP TABLE [dbo].[OLE DB-Ziel ACM VenueSeries]
112GO
113
114CREATE TABLE [OLE DB-Ziel ACM VenueSeries] (
115 [id] nvarchar(255) NOT NULL,
116 [text] nvarchar(255),
117 [Publication_Id] numeric(20,0)
118)
119
120IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OLE DB-Ziel GS Pub]') AND type in (N'U'))
121 DROP TABLE [dbo].[OLE DB-Ziel GS Pub]
122GO
123
124CREATE TABLE [OLE DB-Ziel GS Pub] (
125 [id] numeric(20,0),
126 [Title] nvarchar(1000),
127 [URL] nvarchar(1000),
128 [NoOfCitings] int,
129 [Additional] nvarchar(1000),
130 [Author] nvarchar(1000),
131 [Venue] nvarchar(1000),
132 [Hostname] nvarchar(1000)
133)