Announcement

Collapse
No announcement yet.

What is the database stucture like?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • What is the database stucture like?

    From what I can gather the new vB5 uses one table to store all the data, is this correct?

  • #2
    Not a one table for the whole vBulletin script, But there's a one table for all of the content and it's called "node" so forums and threads ... etc are nodes.
    Marco Mamdouh Fahem.
    OUZMind Lead Developers
    vBFoster Lead Developers

    Comment


    • #3
      200 tables.
      Shamil Nunhuck, - Radon Systems Ltd.
      VPS + Dedicated Server Hosting and Management
      vBulletin Hosting and Services
      Server / Website Consultation

      Comment


      • #4
        Originally posted by Marco Mamdouh View Post
        Not a one table for the whole vBulletin script, But there's a one table for all of the content and it's called "node" so forums and threads ... etc are nodes.
        Thank you Mamdouh and Shamil.

        Could you explain a little bit more regarding this 'node' table. It must have many fields to be able to combine several tables that were once separate tables in vB4.

        It would be interesting to know what tables were combined into this one 'node' table.

        Comment


        • #5
          Originally posted by Andy View Post
          Thank you Mamdouh and Shamil.

          Could you explain a little bit more regarding this 'node' table. It must have many fields to be able to combine several tables that were once separate tables in vB4.

          It would be interesting to know what tables were combined into this one 'node' table.
          It's a long story I'd say

          However in a short answer is yes, There's 54 fields in node table that controls the node viewing operation, And there's content type and routes which are controlling what is this node belong to.
          Marco Mamdouh Fahem.
          OUZMind Lead Developers
          vBFoster Lead Developers

          Comment


          • #6
            Thank you Marco.

            Is this node table just like any other table in mySQL, meaning it has rows and fields.

            Could you expand explain a little bit what you mean by "And there's content type and routes which are controlling what is this node belong to".

            Comment


            • #7
              For sure any table should has rows and fields, That's how MySQL tables are work
              I can't do that in a reply because by this I'm going to explain the whole new vBulletin 5 system, I'd suggest install vB5 and check it out.
              Marco Mamdouh Fahem.
              OUZMind Lead Developers
              vBFoster Lead Developers

              Comment


              • #8
                Originally posted by Andy View Post
                Thank you Marco.

                Is this node table just like any other table in mySQL, meaning it has rows and fields.

                Could you expand explain a little bit what you mean by "And there's content type and routes which are controlling what is this node belong to".
                Think of nodes as defining the structure of your site. Forums, threads, blogs, and placeholders for the content beneath. The disparate content types that 5 supports each have their own table for their own specific content (text, photo, link, & poll are the ones I remember being there).

                If you've got the publishing suite, it's EXACTLY the same idea on the CMS. Sections/Articles were both nodes, but articles have a separate table that contained the text information.

                Comment


                • #9
                  Thanks Dead Eddie. I don't have the suite so not able to see what you mean.

                  How does a node table define a structure? Perhaps an example of how a thread information is stored. You have the threadid, postid and pagetext, how is it different now?

                  Comment


                  • #10
                    Think of the structure your forum. You've got categories, forums under those categories, threads within the forums, and posts within the threads. Within 5, the first 3 are contained entirely within the node table.

                    Posts also sit on the node table, but because there is extra information needed to store posts (e.g. the post text), the extra information is stored within a new "text" table that is used for all the other text content types (blog posts, private messages, comments).

                    So, category is a node, forum is a node, thread is a node, and post is a node joined to text.

                    Comment


                    • #11
                      Originally posted by Dead Eddie View Post

                      Posts also sit on the node table, but because there is extra information needed to store posts (e.g. the post text), the extra information is stored within a new "text" table that is used for all the other text content types (blog posts, private messages, comments).
                      I think I'm starting to understand why this schema is used. For example if you want to search for a word, one query can search all the content types as opposed to searching several tables.

                      Thank you Eddie.

                      Comment


                      • #12
                        nodes as in Drupal type nodes?
                        Steve, Webmaster and Admin
                        www.pokecommunity.com

                        Comment


                        • #13
                          Originally posted by pokesph View Post
                          nodes as in Drupal type nodes?
                          Personally, I'm not familiar enough with Drupal nodes to answer. What specifically were you comparing?

                          If you wanted to compare to something, I'd compare with the vb4 CMS nodes. The database structure is virtually identical.

                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X