- 20 Ağu 2016
- 459
- 0
Script kurarken mysql hatası aldım nasıl çözebilirim?
Kod:
SQL sorgusu:
-- -------------------------------------------------------- -- -- Tablo için tablo yapısı `bayi_islem` -- CREATE TABLE `bayi_islem` ( `bayiIslemID` int(10) NOT NULL, `bayiID` int(10) UNSIGNED NOT NULL, `islemTip` varchar(10) COLLATE utf8_turkish_ci NOT NULL, `mediaID` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL, `mediaCode` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL, `userID` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL, `userName` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL, `allComments` longtext COLLATE utf8_turkish_ci, `imageUrl` varchar(250) COLLATE utf8_turkish_ci NOT NULL, `minKrediTotal` int(11) UNSIGNED DEFAULT NULL, `maxKrediTotal` int(11) UNSIGNED DEFAULT NULL, `krediTotal` int(10) UNSIGNED NOT NULL, `krediLeft` int(10) UNSIGNED NOT NULL, `startDate` timestamp NULL DEFAULT NULL, `endDate` timestamp NULL DEFAULT NULL, `isActive` tinyint(1) UNSIGNED NOT NULL DEFAULT '1', `eklen****rihi` timestamp NOT NULL DEFAULT CUR[...]
MySQL çıktısı: Belgeler
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause