Importing a db table structure into a database using PHP MyAdmin the following table will not import. i can find no errors on the table, perhaps i am missing something.
-- --------------------------------------------------------
--
-- Table structure for tableconversations
CREATE TABLE
conversations
(cid
varchar(25) NOT NULL default '',uid
varchar(25) NOT NULL default '',msgstartdt
timestamp(14) NOT NULL,msgdttime
timestamp(14) NOT NULL,msgtext
blob NOT NULL
) ENGINE=MYISAM;-- --------------------------------------------------------
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `conversations`
--
CREATE TABLE `conversations` (
`cid` varchar( 25 ) NOT NULL default '',
`uid` varchar( 25 ) NOT NULL default '',
`msgstartdt` timestamp( 14 ) NOT NULL ,
`msgdttime` timestamp( 14 ) NOT NULL ,
`msgtext` blob NOT NULL ,
) ENGINE = MYISAM ;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL,
`msgdttime` timestamp(14) NOT NULL,
`msgtext` blob NOT NULL' at line 10