Revision of Create TERA Databases

1 file changed, 53 insertions

script.sql(file created)

		@@ -0,0 +1,53 @@
1	+	-- Create PlanetDB_2800
2	+	IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'PlanetDB_2800')
3	+	BEGIN
4	+	PRINT 'Creating PlanetDB_2800...'
5	+	CREATE DATABASE PlanetDB_2800
6	+	PRINT 'PlanetDB_2800 created successfully.'
7	+	END
8	+	ELSE
9	+	BEGIN
10	+	PRINT 'PlanetDB_2800 already exists.'
11	+	END
12	+	GO
13	+
14	+	-- Create SharedDB_2800
15	+	IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'SharedDB_2800')
16	+	BEGIN
17	+	PRINT 'Creating SharedDB_2800...'
18	+	CREATE DATABASE SharedDB_2800
19	+	PRINT 'SharedDB_2800 created successfully.'
20	+	END
21	+	ELSE
22	+	BEGIN
23	+	PRINT 'SharedDB_2800 already exists.'
24	+	END
25	+	GO
26	+
27	+	-- Create CollectionDB_2800
28	+	IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'CollectionDB_2800')
29	+	BEGIN
30	+	PRINT 'Creating CollectionDB_2800...'
31	+	CREATE DATABASE CollectionDB_2800
32	+	PRINT 'CollectionDB_2800 created successfully.'
33	+	END
34	+	ELSE
35	+	BEGIN
36	+	PRINT 'CollectionDB_2800 already exists.'
37	+	END
38	+	GO
39	+
40	+	-- Create LogDB_2800
41	+	IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = 'LogDB_2800')
42	+	BEGIN
43	+	PRINT 'Creating LogDB_2800...'
44	+	CREATE DATABASE LogDB_2800
45	+	PRINT 'LogDB_2800 created successfully.'
46	+	END
47	+	ELSE
48	+	BEGIN
49	+	PRINT 'LogDB_2800 already exists.'
50	+	END
51	+	GO
52	+
53	+	-- End of script

Newer Older