-- phpMyAdmin SQL Dump -- version 2.11.7 -- http://www.phpmyadmin.net -- -- Hoszt: localhost -- Létrehozás ideje: 2012. Jan 27. 11:00 -- Szerver verzió: 5.0.51 -- PHP Verzió: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Adatbázis: `etlap` -- -- -------------------------------------------------------- -- -- Tábla szerkezet: `et_menu` -- CREATE TABLE IF NOT EXISTS `et_menu` ( `id` int(11) NOT NULL auto_increment, `id_user` int(11) NOT NULL, `aktho` char(10) collate utf8_hungarian_ci NOT NULL, `m1` varchar(1) collate utf8_hungarian_ci NOT NULL, `m2` varchar(1) collate utf8_hungarian_ci NOT NULL, `m3` varchar(1) collate utf8_hungarian_ci NOT NULL, `m4` varchar(1) collate utf8_hungarian_ci NOT NULL, `m5` varchar(1) collate utf8_hungarian_ci NOT NULL, `m6` varchar(1) collate utf8_hungarian_ci NOT NULL, `m7` varchar(1) collate utf8_hungarian_ci NOT NULL, `m8` varchar(1) collate utf8_hungarian_ci NOT NULL, `m9` varchar(1) collate utf8_hungarian_ci NOT NULL, `m10` varchar(1) collate utf8_hungarian_ci NOT NULL, `m11` varchar(1) collate utf8_hungarian_ci NOT NULL, `m12` varchar(1) collate utf8_hungarian_ci NOT NULL, `m13` varchar(1) collate utf8_hungarian_ci NOT NULL, `m14` varchar(1) collate utf8_hungarian_ci NOT NULL, `m15` varchar(1) collate utf8_hungarian_ci NOT NULL, `m16` varchar(1) collate utf8_hungarian_ci NOT NULL, `m17` varchar(1) collate utf8_hungarian_ci NOT NULL, `m18` varchar(1) collate utf8_hungarian_ci NOT NULL, `m19` varchar(1) collate utf8_hungarian_ci NOT NULL, `m20` varchar(1) collate utf8_hungarian_ci NOT NULL, `m21` varchar(1) collate utf8_hungarian_ci NOT NULL, `m22` varchar(1) collate utf8_hungarian_ci NOT NULL, `m23` varchar(1) collate utf8_hungarian_ci NOT NULL, `m24` varchar(1) collate utf8_hungarian_ci NOT NULL, `m25` varchar(1) collate utf8_hungarian_ci NOT NULL, `m26` varchar(1) collate utf8_hungarian_ci NOT NULL, `m27` varchar(1) collate utf8_hungarian_ci NOT NULL, `m28` varchar(1) collate utf8_hungarian_ci NOT NULL, `m29` varchar(1) collate utf8_hungarian_ci NOT NULL, `m30` varchar(1) collate utf8_hungarian_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci AUTO_INCREMENT=2 ; -- -- Tábla adatok: `et_menu` -- INSERT INTO `et_menu` (`id`, `id_user`, `aktho`, `m1`, `m2`, `m3`, `m4`, `m5`, `m6`, `m7`, `m8`, `m9`, `m10`, `m11`, `m12`, `m13`, `m14`, `m15`, `m16`, `m17`, `m18`, `m19`, `m20`, `m21`, `m22`, `m23`, `m24`, `m25`, `m26`, `m27`, `m28`, `m29`, `m30`) VALUES (1, 1, '2012. JANU', 'A', 'B', 'C', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Tábla szerkezet: `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) collate latin2_hungarian_ci NOT NULL, `epulet` varchar(10) collate latin2_hungarian_ci default NULL, `emelet` varchar(2) collate latin2_hungarian_ci default NULL, `iroda` varchar(4) collate latin2_hungarian_ci default NULL, `telefon` varchar(12) collate latin2_hungarian_ci default NULL, `email` varchar(24) collate latin2_hungarian_ci default NULL, `login` varchar(10) collate latin2_hungarian_ci NOT NULL, `jelszo` varchar(40) collate latin2_hungarian_ci NOT NULL PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_hungarian_ci AUTO_INCREMENT=2; -- -- Tábla adatok: `users` -- INSERT INTO `users` (`id`, `name`, `epulet`, `emelet`, `iroda`, `telefon`, `email`, `login`, `jelszo`) VALUES (1, 'Bujáki György', '4', '2', '208', '25-314', 'bujaki.gyorgy@hm.gov.hu', 'bugyorr', 'abekubi');