Forums

creating tables in a database (4 posts)

  1. Chad_Coleman
    Member
    Posted 7 years ago #

    I'm trying to install this Subscription form on my site, and it calls to create a table in my wordpress database. I have no idea how to do this.
    The instructions were not quite written for a complete novice.

    1. Create the wp_email_list table in your Word Press
    MySQL database.
    If your wp table prefix is something other than
    "wp_" you need to update this table to match it.
    [Use sql/wp_email_list.sql]

    Included was that file 'wp_email_list.sql'. and it reads as so:

    CREATE TABLE wp_email_list (
    id int(11) NOT NULL auto_increment,
    email_addr varchar(255) default NULL,
    gets_mail int(11) default NULL,
    last_modified timestamp(14) NOT NULL,
    date_subscribed datetime default NULL,
    PRIMARY KEY (id)
    ) TYPE=MyISAM;

    Can anybody give me a fairly detailed walkthrough?
    It would be very much appreciated. Thanks

  2. James
    Happiness Engineer
    Posted 7 years ago #

    This isn't my specialty...yet...but the first question anyone around here will ask you is: Do you have MySQL access through phpmyadmin?

  3. Kafkaesqui
    Moderator
    Posted 7 years ago #

    Easiest just to copy the whole line above (CREATE TABLE wp_email_list ...), go into your database through phpMyAdmin, click the SQL tab, paste the line in the "run SQL query" textbox, and click Go.

  4. Chad_Coleman
    Member
    Posted 7 years ago #

    Thanks K, Worked nicely.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.