MYSQL Table and Field Definitions

  • klyxmaster

    (@klyxmaster)


    15 years, 2 months ago

    Is there a link, wiki etc.. that explains in detail the tables and their fields?
    I am changing to wordpress as it is better suited for what I need. I have a 2k database that I started to enter manually, then I realized it would be easier to just do it via php.

    however, I can only do the post. I would like to know what certain fields do and where they get their values (example postmeta.edit_lock/last, meta_id, post_id)

    While I am sure some of you know the answer to those, I would prefer just a link or a documentation. All the reading I found is how to use wp.

    EDIT:
    found this:
    http://codex.wordpress.org/Database_Description

    but it does not tell me how they are created or what they are for
    example:
    http://codex.wordpress.org/Database_Description#Table:_wp_postmeta

    does not tell you anything you cant find int he phpmyadmin (or your favorite db editor)

Viewing 4 replies - 1 through 4 (of 4 total)
  • esmi

    (@esmi)

    15 years, 2 months ago

    Why are you entering content via the db instead of via WordPress?

    Thread Starter klyxmaster

    (@klyxmaster)

    15 years, 2 months ago

    Your question :
    1. off topic
    2. doesn’t answer the original post.

    I have a 2k database that I started to enter manually, then I realized it would be easier to just do it via php

    manually = via wordpress

    I did use:
    [Code moderated as per the Forum Rules. Please use the pastebin]

    however this does not allow multiple category posting and does not allow for a feature image to be inserted.

    With my current script I can download images,put them in the correct folder, format my post as needed. but in order for the feature IMAGE to work correctly it needs certain criteria to be inserted in the postmeta. The above only deals with a post and one category

    WP in nothing short of a giant gui for a SQL database of posts.

    If you would like more details as to why or link to site, email me as it is not the topic of this post.

    danhgilmore

    (@danhgilmore)

    15 years, 2 months ago

    @klyxmaster – I’m not sure that there is documentation describing how the tables are created. The postmeta table should be created when the blog/site is created. Try this: http://phpxref.ftwr.co.uk/wordpress/_functions/wpmu_create_blog.html

    Thread Starter klyxmaster

    (@klyxmaster)

    15 years, 2 months ago

    @danhgilmore
    Hi..
    Yes did see that earlier. meta_id and post_id (i believe this one references the actual id of the post) but the metaa_id eludes me. the meta_value and meta_key I already figured out. I just want to make sure when i set those values the correspond to the right post. I believe meta_id is autoincrement, so most likely I can just leave that blank and wp will handle that.

    If I find anything i’ll post it here. Its actually a large database provided by my vendor and how i want each post formatted goes beyond the standard “auto-posts” scripts out there. If I wanted a simple icon, body, category, the above script would work perfect. 🙂

    thanks for the reply!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘MYSQL Table and Field Definitions’ is closed to new replies.

Tags