M3CgXreD

1----------------------------------- [Knot Table] -------------------------------------
2-- RAT_Rating table
3--------------------------------------------------------------------------------------
4IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'RAT_Rating' and type LIKE '%U%')
5CREATE TABLE [dbo].[RAT_Rating] (
6   RAT_ID tinyint not null,
7   RAT_Rating varchar(42) not null unique,
8   Metadata_RAT int not null,
9   primary key (
10      RAT_ID asc
11   )
12);
13GO
14
15----------------------------------- [Knot Table] -------------------------------------
16-- PAT_ParentalType table
17--------------------------------------------------------------------------------------
18IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'PAT_ParentalType' and type LIKE '%U%')
19CREATE TABLE [dbo].[PAT_ParentalType] (
20   PAT_ID tinyint not null,
21   PAT_ParentalType varchar(42) not null unique,
22   Metadata_PAT int not null,
23   primary key (
24      PAT_ID asc
25   )
26);
27GO