﻿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_createpost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_createpost1]

;

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_deletepost1bypid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletepost1bypid]

;

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_getfirstpost1id]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getfirstpost1id]

;

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_getpost1count]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getpost1count]

;

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

;

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_getsinglepost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getsinglepost1]

;

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_gettopiclistbytype]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_gettopiclistbytype]

;

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

;

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_updatepost1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_updatepost1]

;

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_checkemailandsecques]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_checkemailandsecques]

;

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

;

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

;

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

;

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

;

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

;

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

;

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

;

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_postid]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_postid]

;

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

;

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_tablelist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_tablelist]

;

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]
;



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


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


