ka2 on "[Plugin: Custom DataBase Tables] "Failed to Create Table" error"

ساخت وبلاگ

Hi,

At the values of enum type, it should use single quote.
I was able to successfully created table in the following SQL.

CREATE TABLE wp_ha65rf_pin ( ID bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', DOB date NOT NULL, TOB time NOT NULL, Planet enum('Sun','Moon','Mars','Venus','Jupiter','Satu','Uranus','Neptune','Pluto') NOT NULL, Sign enum('Aries','Taurus','Gemini','Cancer','Leo','Virgo','Libra','Scorpio','Sagittarius','Caprico','Aquarius','Pisces') NOT NULL, House enum('First','Second','Third','Fourth','Fifth','Sixth','Seventh','Eighth','Ninth','Tenth','Eleventh','Twelfth') NOT NULL, Aspect enum('Conjunction','Opposition','Sextile','Semi-Sextile','Square','Semi-Square','Trine','Quincunx','Sesqui-Square','Quintile','Bi-Quintile','Parallel','Contra Parallel') NOT NULL, NP enum('Sun','Moon','Mars','Venus','Jupiter','Satu','Uranus','Neptune','Pluto') NOT NULL, NS enum('Aries','Taurus','Gemini','Cancer','Leo','Virgo','Libra','Scorpio','Sagittarius','Caprico','Aquarius','Pisces') NOT NULL, NH enum('First','Second','Third','Fourth','Fifth','Sixth','Seventh','Eighth','Ninth','Tenth','Eleventh','Twelfth') NOT NULL, OtherAs enum('Yes','No') NOT NULL, Event varchar(3000) NOT NULL, created datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Created Datetime', updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated Datetime', PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Planets in Transit'

Thank you,

WordPress ...
ما را در سایت WordPress دنبال می کنید

برچسب : نویسنده : استخدام کار wpss بازدید : 94 تاريخ : سه شنبه 7 ارديبهشت 1395 ساعت: 11:35