CREATE TABLE SC_Forums_Forum 
(
	forumId			int		NOT NULL ,
	forumName		varchar (1000)	NOT NULL ,
	forumDescription	varchar (2000)	NULL ,
	forumCreationDate	varchar (50)	NOT NULL ,
	forumCloseDate		varchar (50)	NULL ,
	forumCreator		varchar (255)	NOT NULL ,
	forumActive		int		NOT NULL ,
	forumParent		int		DEFAULT 0 NOT NULL ,
	forumModes		varchar (50)	NULL ,
	forumLockLevel		int		NULL ,
	instanceId		varchar (50)	NOT NULL , 
	categoryId		varchar (50)	NULL
);

CREATE TABLE SC_Forums_Message 
(
	messageId		int		NOT NULL ,
	messageTitle		varchar (1000)	NOT NULL ,
	messageAuthor		varchar (255)	NOT NULL ,
	messageCreationDate	varchar (50)	NULL ,
	forumId			int		NOT NULL ,
	messageParentId		int		NULL ,
	messageText		varchar (2000)	NULL,
	messageCreationTime	char(13)	DEFAULT('0000000000000')	NOT NULL
);

CREATE TABLE SC_Forums_Rights 
(
	userId			varchar (255)	NOT NULL ,
	forumId			varchar (255)	NOT NULL 
);

CREATE TABLE SC_Forums_Subscription 
(
	userId			varchar (255)	NOT NULL ,
	messageId		varchar (255)	NOT NULL 
);

CREATE TABLE SC_Forums_HistoryUser
(
	userId			varchar (255)	NOT NULL ,
	messageId 		int		NOT NULL , 
	lastAccess		varchar (50)	NOT NULL
);  
Correct create table only for postgresql
Correct create table only for postgresql

git-svn-id: 7f0d99e15c3d719532f2b0716a1f95728c3076a0@137 a8e77078-a1c7-4fa5-b8fc-53c5178a176c
