Uploading DB help
#1

Hello everybody, Now i face a problem while uploading my db files, and it is

Код:
SQL query:

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

 `nw_id` INT( 11 ) NOT NULL ,
 `nw_title` VARCHAR( 24 ) NOT NULL ,
 `nw_body` LONGTEXT,
 `nw_sticked` TINYINT( 1 ) NOT NULL DEFAULT  '0',
 `nw_user` INT( 11 ) NOT NULL ,
 `nw_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1067 - Invalid default value for 'nw_dateSQL query:

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

 `nw_id` INT( 11 ) NOT NULL ,
 `nw_title` VARCHAR( 24 ) NOT NULL ,
 `nw_body` LONGTEXT,
 `nw_sticked` TINYINT( 1 ) NOT NULL DEFAULT  '0',
 `nw_user` INT( 11 ) NOT NULL ,
 `nw_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation

#1067 - Invalid default value for 'nw_date
Reply


Messages In This Thread
Uploading DB help - by ctopha - 04.08.2016, 17:42
Re: Uploading DB help - by Konstantinos - 04.08.2016, 17:50
Re: Uploading DB help - by ctopha - 04.08.2016, 18:08

Forum Jump:


Users browsing this thread: 1 Guest(s)