﻿if exists (select * from sysobjects where id = object_id(N'[dnt_createadmingroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createadmingroup]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createattachment]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createattachment]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createfavorite]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createfavorite]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createpm]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpm]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createpoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpoll]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createpost]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpost]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createsearchcache]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createsearchcache]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createtopic]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createtopic]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_createuser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createuser]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_deletepostbypid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletepostbypid]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_deleteps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deleteps]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_deletetopicbytidlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletetopicbytidlist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getadmintopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getadmintopiclist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getfavoritescount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoritescount]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getfavoriteslist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfavoriteslist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getfirstpostid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfirstpostid]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getforumnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getforumnewtopics]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getlastpostlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getlastpostlist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getnewtopics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getnewtopics]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpmcount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpmcount]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpmlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpmlist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpoll]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpostcount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostcount]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpostcountbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostcountbycondition]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpostlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostlist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getpostlistbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpostlistbycondition]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getposttree]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getposttree]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getsinglepost]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getsinglepost]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccount]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiccountbycondition]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccountbycondition]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiccountbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiccountbytype]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiclistbydate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbydate]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiclistbynumber]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbynumber]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettopiclistbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbytype]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_gettoptopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettoptopiclist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_getuserlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getuserlist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_shrinklog]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_shrinklog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateadmingroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateadmingroup]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updatepoll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatepoll]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updatepost]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatepost]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateuserauthstr]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserauthstr]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateuseravatar]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuseravatar]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateuserforumsetting]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserforumsetting]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateuserpassword]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserpassword]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateuserprofile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateuserprofile]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_updateusersignature]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updateusersignature]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_admingroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_admingroups]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_adminvisitlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_adminvisitlog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_advertisements]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_advertisements]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_announcements]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_announcements]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_attachments]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_attachtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_attachtypes]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_bbcodes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_bbcodes]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_cachelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_cachelog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_creditslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_creditslog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_favorites]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_favorites]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_forumfields]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_forumfields]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_forumlinks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_forumlinks]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_forums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_forums]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_medals]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_medals]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_medalslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_medalslog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_moderatormanagelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_moderatormanagelog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_moderators]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_moderators]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_onlinelist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_onlinelist]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_paymentlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_paymentlog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_pms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_pms]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_polls]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_polls]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_posts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_posts]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_ratelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_ratelog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_searchcaches]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_searchcaches]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_smilies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_smilies]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_statistics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_statistics]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_templates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_templates]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_topics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_topics]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_userfields]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_userfields]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_usergroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_usergroups]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_users]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_words]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_words]
;