API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 27th, 2017
871
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 14.06 KB | None | 0 0
raw download clone embed print report
  1. -- Copiando estrutura para tabela nxplus.won_auctions
  2. CREATE TABLE IF NOT EXISTS `won_auctions` (
  3.   `id` int(11) NOT NULL AUTO_INCREMENT,
  4.   `auction_id` int(11) NOT NULL DEFAULT '0',
  5.   `accept_denied` varchar(100) NOT NULL DEFAULT '',
  6.   `userid` int(11) NOT NULL DEFAULT '0',
  7.   `won_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  8.   `accept_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  9.   `payment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  10.   `invoice_flag` enum('0','1') NOT NULL DEFAULT '0',
  11.   `situacaodescr` varchar(50) NOT NULL,
  12.   `dataenvio` datetime NOT NULL,
  13.   PRIMARY KEY (`id`)
  14. ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=latin1;
  15.  
  16. -- Copiando dados para a tabela nxplus.won_auctions: ~34 rows (aproximadamente)
  17. /*!40000 ALTER TABLE `won_auctions` DISABLE KEYS */;
  18. INSERT IGNORE INTO `won_auctions` (`id`, `auction_id`, `accept_denied`, `userid`, `won_date`, `accept_date`, `payment_date`, `invoice_flag`, `situacaodescr`, `dataenvio`) VALUES
  19.     (31, 30, 'Accepted', 40, '2017-06-30 11:39:43', '2017-06-30 11:39:56', '2017-06-30 11:49:30', '0', 'Enviado', '2017-07-07 23:01:03'),
  20.     (32, 31, 'Accepted', 40, '2017-06-30 11:39:43', '2017-06-30 11:52:23', '2017-06-30 12:09:37', '0', 'Enviado', '2017-07-07 23:01:00'),
  21.     (34, 32, 'Accepted', 40, '2017-06-30 11:56:45', '2017-06-30 12:02:11', '2017-06-30 11:53:03', '0', 'Enviado', '2017-07-07 23:01:06'),
  22.     (35, 34, 'Accepted', 40, '2017-07-01 09:35:08', '2017-07-01 09:35:40', '2017-07-01 09:38:50', '0', 'Preparando Envio', '0000-00-00 00:00:00'),
  23.     (36, 33, '', 36, '2017-07-01 11:09:20', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  24.     (37, 35, '', 39, '2017-07-01 11:10:20', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  25.     (38, 39, 'Accepted', 40, '2017-07-01 12:04:19', '2017-07-01 12:08:29', '2017-07-01 12:08:57', '0', 'Enviado', '2017-07-07 23:00:54'),
  26.     (39, 40, '', 40, '2017-07-01 12:04:32', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  27.     (40, 41, 'Accepted', 40, '2017-07-01 12:06:30', '2017-07-01 12:07:27', '2017-07-01 12:08:17', '0', 'Enviado', '2017-07-07 23:00:54'),
  28.     (41, 42, 'Accepted', 40, '2017-07-01 16:41:08', '2017-07-01 16:41:29', '2017-07-01 16:41:49', '0', 'Enviado', '2017-07-07 23:00:55'),
  29.     (42, 43, 'Accepted', 40, '2017-07-01 16:42:31', '2017-07-01 16:42:57', '2017-07-01 16:48:40', '0', 'Enviado', '2017-07-07 23:00:56'),
  30.     (43, 44, 'Accepted', 40, '2017-07-01 16:42:45', '2017-07-01 16:49:00', '2017-07-01 16:49:34', '0', 'Enviado', '2017-07-07 23:00:56'),
  31.     (44, 45, 'Accepted', 40, '2017-07-01 18:13:38', '2017-07-01 18:39:17', '2017-07-01 18:39:56', '0', 'Enviado', '2017-07-07 23:00:57'),
  32.     (45, 52, 'Accepted', 40, '2017-07-01 18:59:10', '2017-07-02 23:36:36', '0000-00-00 00:00:00', '0', 'Aguardando Pagamentoo', '0000-00-00 00:00:00'),
  33.     (46, 53, 'Accepted', 40, '2017-07-02 22:43:38', '2017-07-04 18:23:58', '2017-07-07 23:53:42', '0', 'Preparando Envio', '0000-00-00 00:00:00'),
  34.     (47, 57, '', 40, '2017-07-02 23:33:36', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  35.     (48, 58, '', 40, '2017-07-02 23:35:18', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  36.     (49, 56, '', 40, '2017-07-02 23:41:24', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  37.     (50, 55, '', 40, '2017-07-06 04:03:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  38.     (51, 66, 'Accepted', 40, '2017-07-06 05:13:28', '2017-07-06 10:56:30', '2017-07-06 10:57:12', '0', 'Enviado', '2017-07-07 23:00:24'),
  39.     (52, 67, 'Accepted', 40, '2017-07-06 05:14:49', '2017-07-07 23:52:33', '0000-00-00 00:00:00', '0', 'Aguardando Pagamentoo', '0000-00-00 00:00:00'),
  40.     (53, 68, '', 36, '2017-07-06 06:58:50', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  41.     (54, 71, '', 36, '2017-07-11 09:33:25', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  42.     (55, 72, '', 38, '2017-07-11 09:39:28', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  43.     (56, 73, '', 39, '2017-07-11 09:54:21', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  44.     (57, 74, '', 39, '2017-07-11 10:17:10', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  45.     (58, 76, '', 39, '2017-08-16 16:57:28', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  46.     (59, 84, '', 38, '2017-09-18 19:35:03', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  47.     (60, 65, '', 39, '2017-10-16 13:55:19', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  48.     (61, 69, '', 37, '2017-10-16 13:55:40', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  49.     (62, 64, '', 36, '2017-10-16 13:55:54', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  50.     (63, 75, '', 36, '2017-10-16 13:55:54', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  51.     (65, 82, '', 42, '2017-10-18 14:52:55', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00'),
  52.     (66, 87, '', 39, '2017-10-18 17:02:19', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '', '0000-00-00 00:00:00');
  53. /*!40000 ALTER TABLE `won_auctions` ENABLE KEYS */;
  54.  
  55.  
  56. -- Copiando estrutura para tabela nxplus.registration
  57. CREATE TABLE IF NOT EXISTS `registration` (
  58.   `id` int(11) NOT NULL AUTO_INCREMENT,
  59.   `username` varchar(100) NOT NULL DEFAULT '',
  60.   `firstname` varchar(100) NOT NULL DEFAULT '',
  61.   `lastname` varchar(100) NOT NULL DEFAULT '',
  62.   `sex` varchar(10) NOT NULL DEFAULT '',
  63.   `birth_date` date DEFAULT NULL,
  64.   `addressline1` varchar(255) NOT NULL DEFAULT '',
  65.   `addressline2` varchar(255) NOT NULL DEFAULT '',
  66.   `numero` varchar(10) NOT NULL,
  67.   `complemento` varchar(100) NOT NULL,
  68.   `city` varchar(100) NOT NULL DEFAULT '',
  69.   `state` varchar(100) NOT NULL DEFAULT '',
  70.   `country` varchar(100) NOT NULL DEFAULT '',
  71.   `postcode` varchar(50) NOT NULL DEFAULT '',
  72.   `phone` varchar(50) NOT NULL DEFAULT '',
  73.   `mobile_no` varchar(20) NOT NULL DEFAULT '',
  74.   `full_mobileno` varchar(20) NOT NULL DEFAULT '',
  75.   `email` varchar(150) NOT NULL DEFAULT '',
  76.   `password` varchar(50) NOT NULL DEFAULT '',
  77.   `delivery_name` varchar(100) DEFAULT '',
  78.   `delivery_addressline1` varchar(255) DEFAULT '',
  79.   `delivery_addressline2` varchar(255) DEFAULT '',
  80.   `delivery_city` varchar(100) DEFAULT '',
  81.   `delivery_state` varchar(100) DEFAULT '',
  82.   `delivery_country` varchar(100) DEFAULT '',
  83.   `delivery_postcode` varchar(50) DEFAULT '',
  84.   `delivery_phone` varchar(50) DEFAULT '',
  85.   `terms_condition` int(5) DEFAULT '0',
  86.   `privacy` int(5) DEFAULT '0',
  87.   `newsletter_email` varchar(100) DEFAULT '',
  88.   `newslatter` int(5) DEFAULT '0',
  89.   `final_bids` int(10) NOT NULL DEFAULT '0',
  90.   `account_status` int(2) NOT NULL DEFAULT '0',
  91.   `member_status` enum('0','1') NOT NULL DEFAULT '0',
  92.   `user_delete_flag` varchar(10) NOT NULL DEFAULT '',
  93.   `sponser` int(11) NOT NULL DEFAULT '0',
  94.   `register_date` date NOT NULL DEFAULT '0000-00-00',
  95.   `sms_flag` enum('0','1') NOT NULL DEFAULT '0',
  96.   `admin_user_flag` enum('0','1') NOT NULL DEFAULT '0',
  97.   `verify_code` varchar(100) NOT NULL,
  98.   `cpf` varchar(255) NOT NULL DEFAULT '',
  99.   `rg` varchar(255) DEFAULT '',
  100.   `ip_registro` varchar(15) NOT NULL DEFAULT '',
  101.   PRIMARY KEY (`id`)
  102. ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1 PACK_KEYS=0;
  103.  
  104. -- Copiando dados para a tabela nxplus.registration: ~17 rows (aproximadamente)
  105. /*!40000 ALTER TABLE `registration` DISABLE KEYS */;
  106. INSERT IGNORE INTO `registration` (`id`, `username`, `firstname`, `lastname`, `sex`, `birth_date`, `addressline1`, `addressline2`, `numero`, `complemento`, `city`, `state`, `country`, `postcode`, `phone`, `mobile_no`, `full_mobileno`, `email`, `password`, `delivery_name`, `delivery_addressline1`, `delivery_addressline2`, `delivery_city`, `delivery_state`, `delivery_country`, `delivery_postcode`, `delivery_phone`, `terms_condition`, `privacy`, `newsletter_email`, `newslatter`, `final_bids`, `account_status`, `member_status`, `user_delete_flag`, `sponser`, `register_date`, `sms_flag`, `admin_user_flag`, `verify_code`, `cpf`, `rg`, `ip_registro`) VALUES
  107.     (36, 'Carlos', 'Carlos', ' ', 'Male', '0000-00-00', '', '', '', '', '', '', '1', '', '', '', '', 'asdasd@asdad.com', 'password', '', '', '', '', '', '', '', '', 1, 1, '', 0, 0, 1, '0', '', 0, '2017-06-30', '0', '1', '', '', '', ''),
  108.     (37, 'lucasgomes', 'Lucas', ' ', 'Male', '0000-00-00', '', '', '', '', '', '', 'none', '', '', '', '', 'asdasd@asdada.com', 'password', '', '', '', '', '', '', '', '', 1, 1, '', 0, 0, 1, '0', '', 0, '2017-06-30', '0', '1', '', '', '', ''),
  109.     (38, 'MariaLurdes', 'Maria', ' ', 'Male', '0000-00-00', '', '', '', '', '', '', 'none', '', '', '', '', 'MariaLurdes@asd.com', 'password', '', '', '', '', '', '', '', '', 1, 1, '', 0, 0, 1, '0', '', 0, '2017-06-30', '0', '1', '', '', '', ''),
  110.     (39, 'Alberto', 'Alberto', ' ', 'Male', '0000-00-00', '', '', '', '', '', '', 'none', '', '', '', '', 'asdasdasd@asdasd.com', 'password', '', '', '', '', '', '', '', '', 1, 1, '', 0, 0, 1, '0', '', 0, '2017-06-30', '0', '1', '', '', '', ''),
  111.     (40, 'sander', 'SANDER LUIS DELLA SANTA', '', 'Male', '1997-01-27', 'Colonia Nova', 'Colonia Nova', '0', 'Interior', 'Vila L�ngaro', 'RS', '1', '99955-000', '(54) 99923-1603', '(54) 99231-603', '+(54) 99231-603', 'sanderlds@gmail.comm', '123456789', '', '', '', '', '', '', '', '', 1, 1, '', 0, 16337, 1, '0', '', 0, '2017-06-30', '0', '0', 'd93fa92962ddff020707834aac474cfd', '038.871.580-40', '', '177.22.83.1'),
  112.     (41, 'tess123', 'Teste Novo', '', 'Male', '1990-12-05', 'Rua quinze', 'Centro', '189', '', 'Sergipe', 'AC', '1', '77900-000', '(62) 35478-965', '', '+', '123@123.com', '123456', '', '', '', '', '', '', '', '', 1, 1, '', 0, 0, 1, '0', '', 0, '2017-07-07', '0', '0', 'c6343a676355808a6474b004839c4885', '194.974.152-49', '', '189.82.219.244'),
  113.     (42, 'nxhost', 'Francisco', '', 'Male', '0000-00-00', 'wwww', 'centro', '1', '', 'Tapejara', 'AC', '1', '99950-000', '(44) 44343-4343', '(43) 43434-343', '', 'nx3designer@gmail.com', '202020', '', '', '', '', '', '', '', '', 1, 1, '', 0, 4945, 1, '0', '', 0, '2017-07-25', '0', '0', '99b4f45e017b4f907e27477cd83663ff', '589.889.550-72', '', '131.221.15.57'),
  114.     (43, 'tendamaceno', 'Rodrigo Damaceno', '', 'Male', '1985-09-07', 'Rua Fernão Dias ', 'Gonzaga', '04', 'Loja 11', 'São Vicente', 'SP', '1', '11055-220', '(13) 99108-3185', '(13) 99108-3185', '', 'tendamaceno@gmail.com', '123456', '', '', '', '', '', '', '', '', 1, 1, '', 0, 5, 1, '0', '', 0, '2017-07-25', '0', '0', 'deae00086f607e8225cb4f2513457cf3', '228.129.858-28', '', '179.215.124.215'),
  115.     (44, 'ANA PAULA', 'Ana Paula de Souza Costa', '', 'Female', '1962-03-07', 'RUA  LÚCIA VIVEIROS ', 'NEOPOLIS', '615', 'CASA 8', 'NATAL', 'RN', '1', '59086-005', '(84) 09998-2532', '(84) 09945-6820', '', 'juridico@protegrn.com.br', 'sp0862', '', '', '', '', '', '', '', '', 1, 1, '', 0, 55, 0, '0', '', 0, '2017-08-03', '0', '0', '702be98721ccf9d20f6865cf93f8a014', '359.265.384-91', '', '10.15.60.19'),
  116.     (45, 'ernildo', 'ernildo junior', '', 'Male', '1977-09-22', 'rua dr floriano mendes freire 590', 'rua dr floriano mendes freire 590', '590', '', 'campina grande', 'PB', '1', '58415-575', '(83) 98730-0303', '(83) 98730-0303', '', 'ernildojunior@hotmail.com', 'ju220977', '', '', '', '', '', '', '', '', 1, 1, '', 0, 53, 1, '0', '', 0, '2017-08-12', '0', '0', '1cb98e7708e168ce0a6defac916122bb', '007.599.264-76', '', '10.15.60.19'),
  117.     (46, 'jucasilva', 'Juca Silva', '', 'Male', '1990-08-29', 'Rua Ivan Vigne ', 'Centro', '111', 'apartamento 11', 'Nova Iguaçu', 'RJ', '1', '26255-158', '(21) 98738-5533', '(21) 98738-5533', '', 'juca@gmail.com', 'fbi7-0Om>%S0', '', '', '', '', '', '', '', '', 1, 1, '', 0, 55, 0, '0', '', 0, '2017-08-15', '0', '0', '17edb208ae3bae8fc3f34e0715a99445', '131.130.337-56', '', '10.15.60.19'),
  118.     (47, 'Marcos', 'Marcos', '', 'Male', '1983-04-27', 'Rua da Copa', 'Copa', '13', '', 'Copa', 'AC', '1', '13003-23', '(32) 65545-6845', '', '', 'marcos@system.com', '123456789', '', '', '', '', '', '', '', '', 1, 1, '', 0, 55, 0, '0', '', 0, '2017-08-21', '0', '0', 'dfefdb66581190514404f57cdf74a8eb', '337.444.397-47', '', '10.15.60.19'),
  119.     (48, 'fulano', 'Fulano de tal', '', 'Male', '0000-00-00', 'Rua fulano de tal', 'Cetro', '44', 'Centro', 'Aquela', 'AC', '1', '58115-000', '(43) 15424-6863', '(74) 68379-4045', '', 'sdgçKASGD@KALkldv.com', 'killemall83', '', '', '', '', '', '', '', '', 1, 1, '', 0, 55, 1, '0', '', 0, '2017-08-24', '0', '0', '3342949e2e99fc2f304de6fdd626a188', '127.458.144-35', '', '10.15.60.19'),
  120.     (49, 'chico5', 'Francisco', '', 'Male', '0000-00-00', 'R GIRUA CS B 66, CAVALHADA', 'centro', '44', '', 'Tapejara', 'AC', '1', '91740-220', '444444444444444', '(51) 31576-595', '', 'franciscowitschoreck@gmail.com', '202020', '', '', '', '', '', '', '', '', 1, 1, '', 0, 55, 1, '0', '', 0, '2017-09-09', '0', '0', 'e059ce6e334899766ff50d9637049355', '250.865.485-00', '', '10.15.60.19'),
  121.     (50, 'baiano', 'Elenaldo santos', '', 'Male', '1976-01-10', 'mansur contar 267', 'mansur contar 267', '436', 'Cada', 'Campo Grande', 'MS', '1', '79073-251', '(67) 99142-2140', '(67) 99142-2140', '', 'elenaldocelular@gmail.com', '15451545', '', '', '', '', '', '', '', '', 1, 1, '', 0, 50, 1, '0', '', 0, '2017-09-18', '0', '0', 'ceaa51c0079f301ec8ab0955b7050a2b', '945.619.235-00', '', '10.15.60.19'),
  122.     (51, 'teste2017', 'teste', 'teste', 'Male', '1951-02-20', 'juyjd', 'kjfhj', '', '', 'ghfjgf', 'jgf', '62', '4554', '5', '654', '+654', 'teste@teste.com', 'teste2017', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, 0, '0', '', 0, '2017-10-03', '0', '0', 'bad0f4a4304f10282207540406838208', '773.524.636-66', '212112', ''),
  123.     (52, 'TESTEXLX', 'Usuario Teste Teste', '', 'Male', '0000-00-00', 'hahsahs', 'hashashas', '6236', '2323732', 'gasgsa', 'RS', '1', '01230-000', '(11) 54841-158', '(11) 55844-4158', '', 'teste@testtstestete.com', '123456789', '', '', '', '', '', '', '', '', 1, 1, '', 0, 20, 1, '0', '', 0, '2017-10-18', '0', '0', '6f20246231236c27673a2c4b37c3271a', '440.473.474-34', '', '10.15.60.19');
  124. /*!40000 ALTER TABLE `registration` ENABLE KEYS */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!