Table Schema?

[randyripoff]

Hello,

Is there a simple table schema available somewhere for smf?  I've converted from IPB, but a few things didn't convert like smileys, the banlist and badwords, and I want to try to import that data myself, but I need to know which data goes where before doing so.

[Rudolf]

If you have access to your database you can look up yourself. Like using phpMyAdmin.

[randyripoff]

No, it's not an issue of not having the data, or being unable to access the database.

For instance, there are fields in the smf_smileys folder called smileyRow and smileyOrder.  They are non-null fields, and I need to figure out how to populate them.  There's no equivalent in IPB.

Is there anything that describes not just the data types, but also the purpose of each field?

[Rudolf]

I'm affraid not.
The documentation is far from that point.
In the mean time I did a a summary of the smf schema,
even if it won't help you much, you can check it up here. It is for SMF 1.1 RC2

You could tell what table and row you don't understand and maybe someone can answer to you.
Step by step.

Edit: fixed the url

[randyripoff]

Thanks for pulling that together.  However, the link is turning up a page not found error.

[Rudolf]

I fixed the url.