| Author |
 Topic  |
|
|
philwhite
Starting Member
Germany
47 Posts |
 Posted - 10 December 2004 : 14:37:18
|
Had a good hunt round the forums with the search function, but I can't find an answer to precisely this problem.
I need to import a pretty large amount of threads from an entirely proprietary system dating from 1997 or so.
It appears that most of what Snitz needs is there in one form or another or can be dummied up.
My question: What are the minimum requiremens for the integrity of the database if I add records to FORUM_TOPICS/FORUM_REPLY or FORUM_A_TOPICS/FORUM_A_REPLY?
Clearly, the topic IDs and the reply IDs need to be unique and reference each other properly, but that's handled automatically if all goes well.
I don't intend importing the user base (disruption of the board is the main reason for moving to a grown-up system), and all topics and replies will be assigned to a dummy user "Archive Post" or "Archive Reply". They were not timestamped, but I can handle that with an incremented timestamp on each topic/reply as long as they all predate the new board.
I'd put the poster's name in the foot of the post as it is on our current system.
So, what does the T_STATUS field do in the FORUM_TOPICS table (and what does the corresponding R_STATUS field do in the FORUM_REPLY table)?
And, most importantly, have I forgotten anything?
|
Phil White |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 December 2004 : 14:48:57
|
I think T_STATUS and R_STATUS have to do with locked/unlocked/moderated/unmoderated
Just curious, what are you transferring your data from? what kind of db? what software?
Also, any dynamically generated TOPIC_ID might not necassarily be referenced correctly in the FORUM_REPLY table |
-Stim |
 |
|
|
philwhite
Starting Member
Germany
47 Posts |
Posted - 10 December 2004 : 14:59:36
|
The DB is Access, snd the new board will run on Access as well, so it makes life a little easier. I'd be happier with MySQL, but this is an emergency stopgap (have to change provider for MySQL or pay a fistful of readies for MS SQL2000). The "software" was entirely homegrown and evolved in the hands of someone learning the rudiments of programming. The code of the ASPs is wild in places, but most is autogenerated from FrontPage.
The IDs in the current DB are not dynamic, so it shouldn't be a problem. I'll probably just not import them and let the autonumber do the rest. Alternatively, I'll have to increment them above the current board max.
|
Phil White |
|
|
| |
Topic |
|
|
|
Topic Locked
