15 years on The Web
miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
Master Class miniBB Support Forums / Master Class /   

db shema questions

Author ike
#1 | Posted: 11 Feb 2004 19:22 | Edited by: ike 
Hi .

I need to reinsert all the posts from and older forum into our new minibb forum. They were extracted and formatted into simple XML, and will now be inserted manually (via SQL INSERT statements) into the new database. This is where I need some help. The db schema you use is poorly commented. I got some info from the setup_mysql.php file, and am asking you for the rest.

The DB seams to contain 6 tables; of those I only need two: $Tt (topics) and $Tp (posts). Please explain to me, what their fields are, in what format, and what a specific values mean.

Thanks in advance,
-ike, .si

Author Team
#2 | Posted: 12 Feb 2004 10:35 
You can find database structure in _install_mysql.sql
Field names are intuitive to understand, I guess.

Author ike
#3 | Posted: 12 Feb 2004 15:33 
You guessed rather right. :)
Muchus thx, team.

If your ever need any text cut-up work (sed, awk and the like) or shell programming (bash), drop me line. My email is in your database.

Master Class miniBB Support Forums / Master Class / db shema questions Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.

Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB