cms2day Forum - Community & Support rund ums cms2day

MySQL-Abfrage(n)

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `benutzername` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `passwort` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(1) NOT NULL,
  `cookie` text COLLATE utf8_unicode_ci NOT NULL,
  `lastlogin` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `logintime` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rights_pages` text COLLATE utf8_unicode_ci NOT NULL,
  `rights_module` text COLLATE utf8_unicode_ci NOT NULL,
  `rights_edit` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rights_wartung` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rights_update` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `rights_frontend` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;