EXEC spInsertBoxes 'Login','R',1,'X','controls/Login.ascx',-1;
EXEC spInsertMenu 'Login','X','controls/Login.ascx',6;
EXEC spUpdateBoxItem '4','Users Online','R','2','X','controls/UsersOnline.ascx','-1';
EXEC spUpdateBoxItem '3','Other Links','R','3','M','','-1';
EXEC spUpdateBoxItem '5','User CP','R','4','M','','0';
EXEC spInsertAbbrv 'X','Load Control','Y', 'Y';
EXEC spInsertAbbrv 'F','Read File','Y', 'Y';
EXEC spInsertAbbrv 'W','Read Website','Y', 'Y';
EXEC spInsertAbbrv 'DB','Query Database','Y', 'Y';
EXEC spInsertAbbrv 'LE','Redirect to External Link','Y', '';
EXEC spInsertAbbrv 'LI','Redirect to Internal Link','Y', '';
EXEC spInsertAbbrv 'M','Menu Box','', 'Y';
UPDATE tblConfig set key_value='1.1.0.0' WHERE key_name='Portal Version';
UPDATE tblSmilies SET smiley_abbr='(:o)' WHERE smiley_abbr='&#60;:o)';
UPDATE tblCommentEntries SET commententry_dateTime=GetDate() WHERE commententry_dateTime IS NULL;
UPDATE tblCommentEntries SET commententry_pageID=SUBSTRING(commententry_posting_page, CHARINDEX('?id=', commententry_posting_page) + 4, 2) WHERE commententry_pageID IS NULL;
UPDATE tblCommentPages SET commentpage_pageID=19 WHERE commentpage_pageID IS NULL;
