zUKQKrdT

1IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_publication_venue]') AND type in (N'U'))
2    DROP TABLE [dbo].[acm_publication_venue] 
3GO
4
5IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_author_publication]') AND type in (N'U'))
6    DROP TABLE [dbo].[acm_author_publication]
7GO
8
9IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_author]') AND type in (N'U'))
10    DROP TABLE [dbo].[acm_author]
11GO
12
13CREATE TABLE [acm_author] (
14    [author_id] bigint NOT NULL IDENTITY(1,1) PRIMARY KEY, 
15    [Name] nvarchar(255),
16    [Institution] nvarchar(255),
17    [publication_id] bigint, 
18    [pos] numeric(20,0)
19)
20
21IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_publication]') AND type in (N'U'))
22    DROP TABLE [dbo].[acm_publication]
23GO
24
25CREATE TABLE [acm_publication] (
26    [publication_id] bigint NOT NULL PRIMARY KEY,
27    [id] bigint,
28    [Title] nvarchar(1000),
29    [Fulltext] nvarchar(255),
30    [StartPage] int,
31    [EndPage] int
32)
33
34CREATE TABLE [acm_author_publication] (
35    [author_id] bigint NOT NULL, 
36    [publication_id] bigint NOT NULL,
37    [pos] tinyint,
38    CONSTRAINT fk_acm_author_publication1 FOREIGN KEY(publication_id) REFERENCES [acm_publication](publication_id),
39    CONSTRAINT fk_acm_author_publication2 FOREIGN KEY(author_id) REFERENCES [acm_author](author_id)
40)
41
42IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_venue]') AND type in (N'U'))
43    DROP TABLE [dbo].[acm_venue]
44GO
45
46CREATE TABLE [acm_venue] (
47    [venue_id] bigint NOT NULL PRIMARY KEY,
48    [year] int,
49    [text] nvarchar(255)
50)
51
52IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_venueseries]') AND type in (N'U'))
53    DROP TABLE [dbo].[acm_venueseries]
54GO
55
56CREATE TABLE [acm_venueseries] (
57    [id] nvarchar(255) NOT NULL PRIMARY KEY,
58    [text] nvarchar(255)
59)
60
61CREATE TABLE [acm_publication_venue] (
62    [publication_id] bigint NOT NULL,
63    [venue_id] bigint NOT NULL,
64    [venueseries_id] nvarchar(255) NOT NULL,
65    CONSTRAINT fk_acm_publication_venue1 FOREIGN KEY(publication_id) REFERENCES [acm_publication](publication_id),
66    CONSTRAINT fk_acm_publication_venue2 FOREIGN KEY(venue_id) REFERENCES [acm_venue](venue_id),
67    CONSTRAINT fk_acm_publication_venue3 FOREIGN KEY(venueseries_id) REFERENCES [acm_venueseries](id)
68)
69
70IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[acm_citing_pub]') AND type in (N'U'))
71    DROP TABLE [dbo].[acm_citing_pub]
72GO
73
74CREATE TABLE [acm_citing_pub] (
75    [id] bigint NOT NULL,
76    [text] nvarchar(4000),
77    [publication_id] bigint,
78)