-- --------------------------------------------------------
-- Server Version:               5.5.47-0+deb7u1 - (Debian)
-- Server Betriebssystem:        debian-linux-gnu
-- HeidiSQL Version:             9.5.0.5196
-- --------------------------------------------------------


-- Exportiere Struktur von Tabelle tofriends.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `fullname` varchar(100) NOT NULL DEFAULT '',
  `disabled` enum('Y','N') NOT NULL DEFAULT 'N',
  `edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `search` enum('Y','N') NOT NULL DEFAULT 'Y',
  `change_pw` enum('Y','N') NOT NULL DEFAULT 'Y',
  `manage_user` enum('Y','N') NOT NULL DEFAULT 'N',
  `manage_article` enum('Y','N') NOT NULL DEFAULT 'Y',
  `manage_menu` enum('Y','N') NOT NULL DEFAULT 'Y',
  `manage_blocked` enum('Y','N') NOT NULL DEFAULT 'Y',
  `manage_config` enum('Y','N') NOT NULL DEFAULT 'N',
  `manage_global` enum('Y','N') NOT NULL DEFAULT 'N',
  `manage_shop` enum('Y','N') NOT NULL DEFAULT 'N',
  `delete` enum('Y','N') NOT NULL DEFAULT 'N',
  `report` enum('Y','N') NOT NULL DEFAULT 'N',
  `reset` enum('Y','N') NOT NULL DEFAULT 'N',
  `flush` enum('Y','N') NOT NULL DEFAULT 'N',
  `read_protected` enum('Y','N') NOT NULL DEFAULT 'N',
  `link` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

-- Exportiere Daten aus Tabelle tofriends.users: 6 rows
INSERT INTO `users` (`id`, `login`, `email`, `password`, `fullname`, `disabled`, `edit`, `search`, `change_pw`, `manage_user`, `manage_article`, `manage_menu`, `manage_blocked`, `manage_config`, `manage_global`, `manage_shop`, `delete`, `report`, `reset`, `flush`, `read_protected`, `link`) VALUES
	(1, 'guest', '', 'd41d8cd98f00b204e9800998ecf8427e', 'nicht eingeloggt', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL),
	(2, 'soek', 'soek@gmx.de', 'a2c2b57a75f72f415eb1463c483fdc17', 'Sören Kahl', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', NULL),
	(4, 'schweller', '', 'cffbfdbf252cc688f7090ffe74088023', 'Stefan Otto', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'Y', ''),
	(5, 'fred', '', 'cdf3ea5f24041e20fadf8776b1d6ad79', 'Fred Pürthner', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'Y', NULL),
	(6, 'oli', '', 'f2ace00a0f53dd30bba32ef5e5e913f2', 'Oliver Spangenberg', 'N', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'Y', ''),
	(7, 'gilmour', '', 'b5c0770c9b78e902faef46d460c295f8', 'Michael Felber', 'N', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'Y', '');

