[DELETED]Problema SQL

[SQRIN]

Comanda SQL:

-- --------------------------------------------------------
--
-- Table structure for table `inf_comments`
--
CREATE TABLE `inf_comments` (

`ID` INT( 11 ) NOT NULL ,
`comment_type` INT( 11 ) NOT NULL ,
`comment_topic` INT( 11 ) NOT NULL ,
`comment_UserID` INT( 11 ) NOT NULL ,
`comment_text` TEXT NOT NULL ,
`comment_hide` INT( 11 ) NOT NULL ,
`comment_extra` TEXT NOT NULL ,
`created_at` TIMESTAMP NOT NULL DEFAULTCURRENT_TIMESTAMP( ) ,
`updated_at` TIMESTAMP NOT NULL DEFAULTCURRENT_TIMESTAMP( )

) ENGINE = INNODB DEFAULT CHARSET = latin1;
 

 

MySQL zice: 

#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

[DiBlaine]

Incearca acum:

CREATE TABLE `inf_comments` (

`ID` INT( 11 ) NOT NULL ,
`comment_type` INT( 11 ) NOT NULL ,
`comment_topic` INT( 11 ) NOT NULL ,
`comment_UserID` INT( 11 ) NOT NULL ,
`comment_text` TEXT NOT NULL ,
`comment_hide` INT( 11 ) NOT NULL ,
`comment_extra` TEXT NOT NULL ,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP( ) ,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP( )
) ENGINE = INNODB DEFAULT CHARSET = latin1;

 

[Wildo]

Ai si tu un model de postare gen  

[SQRIN]

Acum 12 ore, DiBlaine a spus:

Incearca acum:

CREATE TABLE `inf_comments` ( `ID` INT( 11 ) NOT NULL , `comment_type` INT( 11 ) NOT NULL , `comment_topic` INT( 11 ) NOT NULL , `comment_UserID` INT( 11 ) NOT NULL , `comment_text` TEXT NOT NULL , `comment_hide` INT( 11 ) NOT NULL , `comment_extra` TEXT NOT NULL , `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP( ) , `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP( ) ) ENGINE = INNODB DEFAULT CHARSET = latin1;

CREATE TABLE `inf_comments` (

`ID` INT( 11 ) NOT NULL ,
`comment_type` INT( 11 ) NOT NULL ,
`comment_topic` INT( 11 ) NOT NULL ,
`comment_UserID` INT( 11 ) NOT NULL ,
`comment_text` TEXT NOT NULL ,
`comment_hide` INT( 11 ) NOT NULL ,
`comment_extra` TEXT NOT NULL ,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP( ) ,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP( )
) ENGINE = INNODB DEFAULT CHARSET = latin1;

 

tot nu mere

[DiBlaine]

Acum 11 ore, SQRIN a spus:

tot nu mere

eu am testat si mi a mers ce ti-am dat eu ...

[577777]

Topic-ul a fost șters deoarece nu ai respectat modelul de postare. Te rugăm sa revii cu alt topic in care să respecți modelul.

Topic șters!