-- Estructura de tabla para la tabla `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`uid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(60) NOT NULL DEFAULT '',
`pass` VARCHAR(32) NOT NULL DEFAULT '',
`mail` VARCHAR(64) DEFAULT '',
`mode` tinyint(4) NOT NULL DEFAULT '0',
`sort` tinyint(4) DEFAULT '0',
`threshold` tinyint(4) DEFAULT '0',
`theme` VARCHAR(255) NOT NULL DEFAULT '',
`signature` VARCHAR(255) NOT NULL DEFAULT '',
`signature_format` SMALLINT(6) NOT NULL DEFAULT '0',
`created` INT(11) NOT NULL DEFAULT '0',
`access` INT(11) NOT NULL DEFAULT '0',
`login` INT(11) NOT NULL DEFAULT '0',
`status` tinyint(4) NOT NULL DEFAULT '0',
`timezone` VARCHAR(8) DEFAULT NULL,
`language` VARCHAR(12) NOT NULL DEFAULT '',
`picture` VARCHAR(255) NOT NULL DEFAULT '',
`init` VARCHAR(64) DEFAULT '',
`data` longtext,
PRIMARY KEY (`uid`),
UNIQUE KEY `name` (`name`),
KEY `access` (`access`),
KEY `created` (`created`),
KEY `mail` (`mail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Volcar la base de datos para la tabla `users`
--
INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `mode`, `sort`, `threshold`, `theme`, `signature`, `signature_format`, `created`, `access`, `login`, `status`, `timezone`, `language`, `picture`, `init`, `data`) VALUES
(0, '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, NULL, '', '', '', NULL),
(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'asdffasd@daassda.com', 0, 0, 0, '', '', 0, 1271958828, 1273272059, 1273265874, 1, NULL, '', '', 'asdffasd@daassda.com', 'a:0:{}'),
(3, 'desde_hijo1', 'e10adc3949ba59abbe56e057f20f883e', 'desde_hijo1@yoco.net', 0, 0, 0, '', '', 0, 1271961122, 1273272553, 1273260852, 1, '-10800', '', '', 'desde_hijo1@yoco.net', 'a:1:{s:13:"form_build_id";s:37:"form-ce2c5a8bfba0b798d6f151205d9acd26";}'),
(4, 'desde_hijo2', 'e10adc3949ba59abbe56e057f20f883e', 'desde_hijo2@yoco.net', 0, 0, 0, '', '', 0, 1271970862, 1273160587, 1273159197, 1, '-10800', '', '', 'desde_hijo2@yoco.net', 'a:1:{s:13:"form_build_id";s:37:"form-384e3df2bd143fc80f7df15f276ddb42";}'),
(5, 'placeholder-for-uid-1', '', 'placeholder-for-uid-1', 0, 0, 0, '', '', 0, 1272540811, 0, 0, 0, NULL, '', '', '', 'a:0:{}'),
(6, 'hijo1', 'e10adc3949ba59abbe56e057f20f883e', 'hijo1@yoco.net', 0, 0, 0, '', '', 0, 1273073779, 1273158994, 1273159026, 1, '-10800', '', '', 'hijo1@yoco.net', 'a:1:{s:13:"form_build_id";s:37:"form-b1ca6100ffe438ed58fb5ab8e1af4c86";}'),
(7, 'hijo2', 'e10adc3949ba59abbe56e057f20f883e', 'palihue-roles-hijo2@yoco.net', 0, 0, 0, '', '', 0, 1273077759, 1273159176, 1273159176, 1, '-10800', '', '', 'palihue-roles-hijo2@yoco.net', 'a:1:{s:13:"form_build_id";s:37:"form-1326e781ae2f1c9f029ce2728ff8950c";}');