8n3P343R

1SQL dotaz:
2
3
4-- --------------------------------------------------------
5
6--
7-- Štruktúra tabuľky pre tabuľku `registration`
8--
9
10CREATE TABLE IF NOT EXISTS `registration` (
11  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
12  `heslo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nezadané',
13  `registraciadna` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14  `icq` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
15  `prava` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'nevyplnené',
16  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
17  `loggeddna` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
18  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
19  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
20  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
21  `ban` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
22  `admin_group` text COLLATE utf8_unicode_ci NOT NULL,
23  `code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
24  U[...]
25MySQL hlásí: Dokumentace
26
27#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause