Hi, i have recently shifted my website from shared hosting to vps with webuzo panel but when i am trying to import my database it is keep on giving me error can anyone help me how to fix this?
-- --------------------------------------------------------
--
-- Table structure for table `giftbox_coupons`
--
CREATE TABLE `giftbox_coupons` (
`id` int(11) NOT NULL,
`promotion` varchar(64) NOT NULL DEFAULT '',
`code` varchar(64) NOT NULL DEFAULT '',
`active` int(1) NOT NULL DEFAULT '1',
`min_reward` int(8) NOT NULL DEFAULT '0',
`max_reward` int(8) NOT NULL DEFAULT '0',
`total_rewards` int(16) NOT NULL DEFAULT '0',
`min_lvl` int(8) NOT NULL DEFAULT '0',
`total_users` int(8) NOT NULL DEFAULT '0',
`max_users` int(8) NOT NULL DEFAULT '10',
`active_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8
MySQL said: Documentation
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
-- --------------------------------------------------------
Regards
|