Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 SQL Server has tables, which I want to retain
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rgarg
Starting Member

30 Posts

Posted - 14 August 2002 :  11:04:00  Show Profile
Hi,

I plan on installing SNITZ forum with SQL Server as the database. The database currently has some tables in it. I was wondering, if installing SNITZ would interfere with the current tables in any way like deleting them?

Thanks,
Rajit

D3mon
Senior Member

United Kingdom
1685 Posts

Posted - 14 August 2002 :  11:17:33  Show Profile  Visit D3mon's Homepage
By default Snitz will create all it's tablenames with a prefix of 'FORUM_' like:

FORUM_MEMBERS
FORUM_FORUM
FORUM_CATEGORY etc..

So long as you dont currently have an tables called FORUM_[something] you'll be ok.

if you change these lines in config.asp (around line 50):

strTablePrefix = "snitz_"
strMemberTablePrefix = "snitz_"

then the new tables Snitz creates will all be prefixed with these words like:

snitz_MEMBERS
snitz_FORUM
snitz_CATEGORY etc..

this way you can run many different Snitz forums from one database.



Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won"
Go to Top of Page

rgarg
Starting Member

30 Posts

Posted - 14 August 2002 :  11:33:12  Show Profile
quote:
Originally posted by D3mon

By default Snitz will create all it's tablenames with a prefix of 'FORUM_' like:

FORUM_MEMBERS
FORUM_FORUM
FORUM_CATEGORY etc..

So long as you dont currently have an tables called FORUM_[something] you'll be ok.

if you change these lines in config.asp (around line 50):

strTablePrefix = "snitz_"
strMemberTablePrefix = "snitz_"

then the new tables Snitz creates will all be prefixed with these words like:

snitz_MEMBERS
snitz_FORUM
snitz_CATEGORY etc..

this way you can run many different Snitz forums from one database.





Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07