CREATE TABLE ATTRIBUTE ( 
 ATTRID INT NOT NULL, 
 ATTRNAME VARCHAR (50)  NOT NULL, 
 PRIMARY KEY ( ATTRID ) 
); 
GO
 
CREATE TABLE CATEGORYS ( 
 CATEGORYID INT NOT NULL, 
 CATTYPEID INT NOT NULL, 
 CATEGORY VARCHAR (50) NOT NULL, 
 CREATED DATETIME DEFAULT GETDATE() NOT NULL, 
 CREATEDBY INT NOT NULL, 
 ACTIVE INT DEFAULT 0 NOT NULL, 
 ACTIVEBY INT, 
 DATEMOD DATETIME
); 
GO
 
CREATE TABLE CATTYPE ( 
 CATTYPEID INT NOT NULL, 
 CATTYPENAME VARCHAR (50) NOT NULL, 
 CREATED DATETIME DEFAULT GETDATE() NOT NULL, 
 CREATEDBY INT NOT NULL, 
 ACTIVE INT DEFAULT 0 NOT NULL, 
 ACTIVEBY INT, 
 DATEMOD DATETIME
); 
GO
 
CREATE TABLE CONTACT ( 
 CONTACTID INT, 
 FIRSTNAME VARCHAR (50), 
 LASTNAME VARCHAR (50), 
 EMAIL VARCHAR (50), 
 MESSAGE TEXT, 
 MAILDATE DATETIME, 
 USERID INT, 
 ANSWER INT, 
 ACTIVE INT
); 
GO
 
CREATE TABLE CONTENT ( 
 CONTENTID INT NOT NULL, 
 CONTENTNAME VARCHAR (50), 
 BODY TEXT, 
 USERID INT, 
 DATEMOD DATETIME, 
 SIGNOFF INT, 
 ADMINID INT, 
 CATEGORYID INT, 
 SIGNDATETIME DATETIME, 
 SYNOPSIS VARCHAR (500), 
 RATING FLOAT DEFAULT 0 NOT NULL, 
 RATINGS INT DEFAULT 0 NOT NULL, 
 REPLIES INT DEFAULT 0 NOT NULL, 
 KEYPHRASE VARCHAR (100), 
 PRIMARY KEY ( CONTENTID ) 
); 
GO
CREATE TABLE CONTENT2 ( 
 CONTENTID INT NOT NULL, 
 LANGUAGEID INT DEFAULT 3846 NOT NULL, 
 CATEGORYID INT NOT NULL, 
 USERID INT NOT NULL, 
 DATEMOD DATETIME DEFAULT GETDATE() NOT NULL, 
 SIGNOFF INT DEFAULT 0 NOT NULL, 
 SIGNDATETIME DATETIME, 
 ADMINID INT, 
 PRIV INT DEFAULT 0 NOT NULL, 
 CONTENTNAME VARCHAR (50) NOT NULL, 
 SYNOPSIS VARCHAR (255), 
 BODY TEXT, 
 RATING FLOAT DEFAULT 0 NOT NULL, 
 RATINGS INT DEFAULT 0 NOT NULL, 
 REPLIES INT DEFAULT 0 NOT NULL
); 
GO
 
CREATE TABLE ELEMENT ( 
 ELEMENTID INT NOT NULL, 
 ELEMENTNAME VARCHAR (100) NOT NULL, 
 PRIMARY KEY ( ELEMENTID ) 
); 
 
CREATE TABLE LANGUAGE ( 
 LANGUAGEID INT NOT NULL, 
 LANGUAGENAME VARCHAR (50) NOT NULL 
);
GO
 
CREATE TABLE MEMBATTR ( 
 MEMBATTRID INT NOT NULL, 
 MEMBERID INT NOT NULL, 
 ATTRID  INT NOT NULL, 
 SEQ INT NOT NULL, 
 PRIV INT NOT NULL, 
 ATTRVALUE VARCHAR (255), 
 REMARKS VARCHAR (255), 
 PRIMARY KEY ( MEMBATTRID )
);
GO 
 
CREATE TABLE MEMBER ( 
 MEMBERID INT NOT NULL, 
 CREATEDATETIME DATETIME DEFAULT GETDATE() NOT NULL, 
 DATEMOD DATETIME DEFAULT GETDATE() NOT NULL, 
 FIRSTNAME VARCHAR (50) NOT NULL, 
 LASTNAME VARCHAR (50) NOT NULL, 
 PRIV INT DEFAULT 2 NOT NULL, 
 ACTIVE INT DEFAULT 1 NOT NULL, 
 PRIMARY KEY ( MEMBERID ) 
);
GO 
 
CREATE TABLE POSTS ( 
 POSTDATE DATETIME, 
 POPDATE VARCHAR (350), 
 AUTHOR  VARCHAR (350), 
 SUBJECT VARCHAR (350), 
 SORTSUBJECT VARCHAR (350), 
 HEADER VARCHAR (2000), 
 ID INT, 
 BODY TEXT, 
 TESTDATE VARCHAR (50) 
);
GO 
 
CREATE INDEX POSTS_INDEX ON POSTS (ID, SUBJECT); 
GO
 
CREATE TABLE RATING ( 
 RATINGID INT NOT NULL, 
 USERID INT NOT NULL, 
 CONTENTID INT NOT NULL, 
 DATECREATED DATETIME DEFAULT GETDATE() NOT NULL, 
 LASTMOD DATETIME DEFAULT GETDATE() NOT NULL, 
 RATINGVALUE INT NOT NULL, 
 CONSTRAINT RATINGBETWEEN1AND5 CHECK (ratingvalue between 1 and 5) , 
 CONSTRAINT ONERATINGPERUSERPERARTICLE UNIQUE (USERID, CONTENTID), 
 PRIMARY KEY ( RATINGID ) 
);
GO 
 
CREATE TABLE REPLIES ( 
 COMMENTID INT, 
 CONTENTID INT, 
 USERID VARCHAR (50) , 
 MESSAGE TEXT, 
 DATEMOD DATETIME, 
 GRRRS INT, 
 MESSAGENAME VARCHAR (50) 
);
GO 
 
CREATE TABLE RESPONSE ( 
 CONRESID INT, 
 CONTACTID INT, 
 RESPONDER INT, 
 RESPONSE TEXT, 
 MAILDATE DATETIME, 
 ACTIVE INT, 
 RESPNDR INT, 
 RESPNS INT, 
 REPLY TEXT
);
GO 
 
CREATE TABLE SCHEME ( 
 SCHEMEID INT NOT NULL, 
 SCHEMEUSERID INT NOT NULL, 
 SCHEMENAME VARCHAR (50) NOT NULL, 
 PRIV INT DEFAULT 0 NOT NULL, 
 PRIMARY KEY ( SCHEMEID ) 
);
GO 
 
CREATE TABLE SCHEMEELEMENT ( 
 SCHEMEELEMID INT NOT NULL, 
 SCHEMEID INT NOT NULL, 
 ELEMENTID INT NOT NULL, 
 SCHEMEELEMVALUE VARCHAR (100) NOT NULL, 
 PRIMARY KEY ( SCHEMEELEMID ) 
); 
GO
 
CREATE TABLE SEARCHINDEX ( 
 SINDEX INT, 
 USERID INT, 
 DATEMOD DATETIME 
);
GO 
 
CREATE TABLE THELIST ( 
 POSTDATE DATETIME, 
 POPDATE VARCHAR (350), 
 AUTHOR VARCHAR (350), 
 SUBJECT VARCHAR (350), 
 SORTSUBJECT VARCHAR (350), 
 HEADER VARCHAR (2000), 
 ID INT, 
 BODY TEXT, 
 CONTENT TEXT
);
GO 
 
CREATE TABLE THETIPS ( 
 TIP_ID INT NOT NULL, 
 TIP_DATE DATETIME NOT NULL, 
 AUTHOR_ID INT, 
 TIP_TYPE VARCHAR (200), 
 AUTHOR VARCHAR (50) , 
 BODY TEXT, 
 PRIMARY KEY ( TIP_ID ) 
);
GO 
 
CREATE TABLE USERS ( 
 USERID INT NOT NULL, 
 WHO VARCHAR (50) NOT NULL, 
 PASS VARCHAR (50) NOT NULL, 
 CREATEDATE DATETIME DEFAULT GETDATE() NOT NULL, 
 DATEMOD DATETIME DEFAULT GETDATE() NOT NULL, 
 LASTLOGIN  DATETIME DEFAULT GETDATE() NOT NULL, 
 LEAVEOUT INT DEFAULT 0 NOT NULL, 
 NOTIFY INT DEFAULT 1 NOT NULL, 
 ADMIN INT DEFAULT 0 NOT NULL, 
 ACTIVE INT DEFAULT 1 NOT NULL, 
 GOD INT DEFAULT 0 NOT NULL, 
 THELIST INT DEFAULT 0 NOT NULL, 
 USERPRIV INT DEFAULT 1 NOT NULL, 
 PRIV INT DEFAULT 3 NOT NULL, 
 FIRSTNAME VARCHAR (50) , 
 LASTNAME VARCHAR (50) , 
 EMAIL VARCHAR (50) , 
 MEMBERID INT, 
 COOKIE VARCHAR (50) , 
 PRIMARY KEY ( USERID ) 
); 
 
ALTER TABLE MEMBATTR ADD 
 CONSTRAINT [FK_MEMBATTR_MEMBER] FOREIGN KEY 
 (
  [MEMBERID]
 ) REFERENCES MEMBER (
  [MEMBERID]
 )
GO
 
ALTER TABLE MEMBATTR ADD 
 CONSTRAINT [FK_MEMBATTR_ATTRIBUTE] FOREIGN KEY 
 (
  [ATTRID]
 ) REFERENCES ATTRIBUTE (
  [ATTRID]
 )
GO
 
ALTER TABLE RATING ADD 
 CONSTRAINT [FK_RATING_USERS] FOREIGN KEY 
 (
  [USERID]
 ) REFERENCES USERS (
  [USERID]
 )
GO 
 
ALTER TABLE RATING ADD 
 CONSTRAINT [FK_RATING_CONTENT] FOREIGN KEY 
 (
  [CONTENTID]
 ) REFERENCES CONTENT (
  [CONTENTID]
 )
GO  
 
ALTER TABLE SCHEME ADD 
 CONSTRAINT [FK_SCHEME_USERS] FOREIGN KEY 
 (
  [SCHEMEUSERID]
 ) REFERENCES USERS (
  [USERID]
 )
GO   
 
ALTER TABLE SCHEMEELEMENT ADD 
 CONSTRAINT [FK_SCHEMEELEMENT_SCHEME] FOREIGN KEY 
 (
  [SCHEMEID]
 ) REFERENCES SCHEME (
  [SCHEMEID]
 )
GO   
 
ALTER TABLE SCHEMEELEMENT ADD 
 CONSTRAINT [FK_SCHEMEELEMENT_ELEMENT] FOREIGN KEY 
 (
  [ELEMENTID]
 ) REFERENCES ELEMENT (
  [ELEMENTID]
 )
GO