Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on May 7th, 2010  |  syntax: SQL  |  size: 2.71 KB  |  views: 136  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- Estructura de tabla para la tabla `users`
  2. --
  3.  
  4. CREATE TABLE IF NOT EXISTS `users` (
  5.   `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  6.   `name` varchar(60) NOT NULL DEFAULT '',
  7.   `pass` varchar(32) NOT NULL DEFAULT '',
  8.   `mail` varchar(64) DEFAULT '',
  9.   `mode` tinyint(4) NOT NULL DEFAULT '0',
  10.   `sort` tinyint(4) DEFAULT '0',
  11.   `threshold` tinyint(4) DEFAULT '0',
  12.   `theme` varchar(255) NOT NULL DEFAULT '',
  13.   `signature` varchar(255) NOT NULL DEFAULT '',
  14.   `signature_format` smallint(6) NOT NULL DEFAULT '0',
  15.   `created` int(11) NOT NULL DEFAULT '0',
  16.   `access` int(11) NOT NULL DEFAULT '0',
  17.   `login` int(11) NOT NULL DEFAULT '0',
  18.   `status` tinyint(4) NOT NULL DEFAULT '0',
  19.   `timezone` varchar(8) DEFAULT NULL,
  20.   `language` varchar(12) NOT NULL DEFAULT '',
  21.   `picture` varchar(255) NOT NULL DEFAULT '',
  22.   `init` varchar(64) DEFAULT '',
  23.   `data` longtext,
  24.   PRIMARY KEY (`uid`),
  25.   UNIQUE KEY `name` (`name`),
  26.   KEY `access` (`access`),
  27.   KEY `created` (`created`),
  28.   KEY `mail` (`mail`)
  29. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
  30.  
  31. --
  32. -- Volcar la base de datos para la tabla `users`
  33. --
  34.  
  35. INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `mode`, `sort`, `threshold`, `theme`, `signature`, `signature_format`, `created`, `access`, `login`, `status`, `timezone`, `language`, `picture`, `init`, `data`) VALUES
  36. (0, '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, NULL, '', '', '', NULL),
  37. (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'asdffasd@daassda.com', 0, 0, 0, '', '', 0, 1271958828, 1273272059, 1273265874, 1, NULL, '', '', 'asdffasd@daassda.com', 'a:0:{}'),
  38. (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";}'),
  39. (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";}'),
  40. (5, 'placeholder-for-uid-1', '', 'placeholder-for-uid-1', 0, 0, 0, '', '', 0, 1272540811, 0, 0, 0, NULL, '', '', '', 'a:0:{}'),
  41. (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";}'),
  42. (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";}');
clone this paste RAW Paste Data