Author |
Topic  |
|
Davio
Development Team Member
    
Jamaica
12217 Posts |
Posted - 30 September 2004 : 19:14:36
|
I have noticed in the inc_create_forum_mssql.asp file, that there is no query to delete the MS SQL tables before recreating them. Users have to manually delete these tables using Enterprise Manager before setting up the tables again. The link "Create database tables" on the setup.asp page after the database has been setup, does not recreate the tables, but only checks to see if the tables are already there. If it is, it does nothing.
The MySQL setup files does recreate the tables. It uses a DROP TABLE query before creating the tables.
Can I suggest this be included in the next update? It makes it easier to recreate the snitz forum tables when things go all wrong in the database, for whatever reason. |
Support Snitz Forums
|
Edited by - Davio on 30 September 2004 19:19:17 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 30 September 2004 : 19:26:13
|
sounds like a good idea to me. |
 |
|
PeeWee.Inc
Senior Member
   
United Kingdom
1893 Posts |
Posted - 30 September 2004 : 19:31:19
|
Shame it was just a little too late to be added to the update  |
De Priofundus Calmo Ad Te Damine |
 |
|
RichardKinser
Snitz Forums Admin
    
USA
16655 Posts |
Posted - 30 September 2004 : 19:41:55
|
Wasn't there a reason why this isn't there? I seem to remember that there was. Like if the table wasn't there and you execute a drop table query then it would throw an error? Something like that. |
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 30 September 2004 : 19:51:32
|
you can do
if exists (select * from dbo.sysobjects where id = object_id(N'[SnitzUser].[FORUM_MEMBERS]') and OBJECTPROPERTY(id,N'IsUserTable') = 1) drop table [SnitzUser].[FORUM_MEMBERS]
etc
|
 |
|
|
Topic  |
|