when I run-
CREATE TABLE w3t_Events (
E_ID int(9) DEFAULT '0' NOT NULL auto_increment,
E_CalendarID int(9) unsigned DEFAULT '0' NOT NULL,
E_Number int(9) DEFAULT '0' NOT NULL,
E_Date int(11) unsigned DEFAULT '0' NOT NULL,
E_Time int(11),
E_Duration int(11) DEFAULT '0' NOT NULL,
E_Recurring char(1) DEFAULT 'N' NOT NULL,
E_Recurtype varchar(10),
E_End int(11),
E_Frequency int(11),
E_Days varchar(7),
E_Location text,
PRIMARY KEY (E_ID),
KEY E_CalendarID (E_CalendarID)
);
I get-
Results from your SQL command
Here are the results of your command: "CREATE TABLE w3t_Events ( E_ID int(9) DEFAULT '0' NOT NULL auto_increment, E_CalendarID int(9) unsigned DEFAULT '0' NOT NULL, E_Number int(9) DEFAULT '0' NOT NULL, E_Date int(11) unsigned DEFAULT '0' NOT NULL, E_Time int(11), E_Duration int(11) DEFAULT '0' NOT NULL, E_Recurring char(1) DEFAULT 'N' NOT NULL, E_Recurtype varchar(10), E_End int(11), E_Frequency int(11), E_Days varchar(7), E_Location text, PRIMARY KEY (E_ID), KEY E_CalendarID (E_CalendarID) ); ".
SQL ERROR: Unable to do_query: CREATE TABLE w3t_Events ( E_ID int(9) DEFAULT '0' NOT NULL auto_increment, E_CalendarID int(9) unsigned DEFAULT '0' NOT NULL, E_Number int(9) DEFAULT '0' NOT NULL, E_Date int(11) unsigned DEFAULT '0' NOT NULL, E_Time int(11), E_Duration int(11) DEFAULT '0' NOT NULL, E_Recurring char(1) DEFAULT 'N' NOT NULL, E_Recurtype varchar(10), E_End int(11), E_Frequency int(11), E_Days varchar(7), E_Location text, PRIMARY KEY (E_ID), KEY E_CalendarID (E_CalendarID) );
You have an error in your SQL syntax near '; ' at line 16 row(s) affected by your query.