| Author |
 Topic  |
|
|
RWSteele
Starting Member
USA
2 Posts |
 Posted - 01 July 2004 : 16:55:40
|
Hey all. I downloaded Snitz several months ago and I'm just now implimenting it into a site. So far I think it kicks butt, and I hope I can contribute something down the road. I have a couple database questions, so on with the show.
I'm in the process of importing data from another ASP/Access based forum (which is not supported anymore, but that's another story). I wanted to find out which of the following tables are actually used. I've performed a global search and the only file returned is setup.asp
FORUM_A_TOPICS or FORUM_TOPICS
FORUM_A_REPLYS or FORUM_REPLYS
I realize they are the same except for the primary key is not AutoNumber in the "FORUM_A_" tables.
Am I on crack or did I miss something in the README file?
My second question is pretty simple. Does anyone have a schema available online of the current database? I know I can print it out from Access but thought I would ask first.
Thanks in advance for any help. |
Yea, I'll get right on that. |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 01 July 2004 : 17:19:42
|
The "A" tables are populated when you are archiving older posts, the non-A ones are your normal, everyday tables.
Schema ? Nope sorry, not here ... most of it is in my head. THe problem with a schema is that as you install MODs the schema is expanded, so you'll get a base one ut that's about it. Printing your own is the answer. |
 |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 01 July 2004 : 17:20:54
|
| FORUM_TOPICS and FORUM_REPLYS are for the open topics and replys, FORUM_A_REPLYS and FORUM_A_TOPICS are for archived replys and topics. |
|
|
|
RWSteele
Starting Member
USA
2 Posts |
Posted - 01 July 2004 : 18:42:19
|
quote:
The "A" tables are populated when you are archiving older posts, the non-A ones are your normal, everyday tables.
Ahhhh...archives. That makes sense.
quote:
problem with a schema is that as you install MODs the schema is expanded...Printing your own is the answer.
And I did just that since all I wanted was a quick visual reference.
Thanks for the quick responses. Very cool!
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 02 July 2004 : 05:35:53
|
3 replies in a 90 second window ... must be some sort of record for perfect replies ?  |
|
|
|
chumbawumba
Junior Member
United Kingdom
304 Posts |
Posted - 02 July 2004 : 06:02:21
|
| you downloaded months ago, so you need to check that you are working with the latest version of snitz - 3.4.04 |
|
|
| |
Topic |
|
Topic Locked
