INSERT INTO %%GLOBAL_tablePrefix%%categories
			(name, description, parentid, icon, security, approvaltype, catorder) VALUES 
			('Sample Category' , 'This is a sample category in your knowledge base.' , '0' , '1.gif' , 'public' , '0' , '0');
INSERT INTO %%GLOBAL_tablePrefix%%questions
			(title, answer, lastupdated, views, related, visible, sortorder, userid, posvotes, negvotes, score, emailed, detectrelated, metakeywords, metadescription, startdate, enableexpiry, expirydate, featured, workflowstatus) VALUES ('This is a sample article' , 'Use the Articles tab in the control panel to delete or make changes to
this article. If you are logged in as an administrator you can even
click the "Quick Edit" link in the public area of your knowledge base
to make changes to this article outside the control panel.' , '%%GLOBAL_OneHourAgo%%' , '0' , '' , '1' , '0' , '1' , '0' , '0' , '0' , '0' , '0' , '' , '' , '%%GLOBAL_OneHourAgo%%' , '0' , '%%GLOBAL_OneHourAgo%%' , '0' , 'auto_approved');
INSERT INTO %%GLOBAL_tablePrefix%%questions_history
				(questionid,title,answer,lastupdated,views,related,visible,sortorder,userid,posvotes,negvotes,score,emailed,detectrelated,metakeywords,metadescription,startdate,enableexpiry,expirydate,featured,workflowstatus) VALUES ('1', 'This is a sample article', 'Use the Articles tab in the control panel to delete or make changes to
this article. If you are logged in as an administrator you can even
click the "Quick Edit" link in the public area of your knowledge base
to make changes to this article outside the control panel.', '%%GLOBAL_OneHourAgo%%', '0', '', '1', '0', '1', '0', '0', '0', '0', '0', '', '', '%%GLOBAL_OneHourAgo%%', '0', '%%GLOBAL_OneHourAgo%%', '0', 'auto_approved');
IF OBJECTPROPERTY ( object_id('%%GLOBAL_tablePrefix%%questions'),
	                    'TableHasActiveFulltextIndex') = 1
				BEGIN
    				EXEC sp_fulltext_table '%%GLOBAL_tablePrefix%%questions', 'start_full'
				END;
IF OBJECTPROPERTY ( object_id('%%GLOBAL_tablePrefix%%questions_history'),
	                    'TableHasActiveFulltextIndex') = 1
				BEGIN
    				EXEC sp_fulltext_table '%%GLOBAL_tablePrefix%%questions_history', 'start_full'
				END;
insert into %%GLOBAL_tablePrefix%%categoryassociations(categoryid, questionid) values(1, 1);