-- phpMyAdmin SQL Dump -- version 3.4.11.1 -- http://www.phpmyadmin.net -- -- Servidor: localhost -- Tiempo de generación: 05-10-2012 a las 15:57:45 -- Versión del servidor: 5.1.65 -- Versión de PHP: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de datos: `carey584_magic` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `usuarios` -- CREATE TABLE IF NOT EXISTS `usuarios` ( `referencia` bigint(20) NOT NULL AUTO_INCREMENT, `nombre` varchar(250) NOT NULL DEFAULT '', `apellido` varchar(250) NOT NULL DEFAULT '', `pais` varchar(250) NOT NULL DEFAULT '', `email` varchar(250) NOT NULL DEFAULT '', `password` varchar(250) NOT NULL DEFAULT '', `compra` varchar(255) NOT NULL DEFAULT '', `cmd` varchar(255) NOT NULL, `handling_amount` varchar(250) NOT NULL DEFAULT '', `discount` varchar(250) NOT NULL DEFAULT '', `insurance_amount` varchar(250) NOT NULL DEFAULT '', `payer_id` varchar(250) NOT NULL DEFAULT '', `btn_id` varchar(250) NOT NULL DEFAULT '', `ipn_track_id` varchar(250) NOT NULL DEFAULT '', `shipping` varchar(250) NOT NULL DEFAULT '', `charset` varchar(250) NOT NULL DEFAULT '', `payment_gross` varchar(250) NOT NULL DEFAULT '', `shipping_discount` varchar(250) NOT NULL DEFAULT '', `receipt_id` varchar(250) NOT NULL DEFAULT '', `verify_sign` varchar(250) NOT NULL DEFAULT '', `item_name` varchar(250) NOT NULL DEFAULT '', `txn_type` varchar(250) NOT NULL DEFAULT '', `receiver_id` varchar(250) NOT NULL DEFAULT '', `payment_fee` varchar(250) NOT NULL DEFAULT '', `mc_currency` varchar(250) NOT NULL DEFAULT '', `transaction_subject` varchar(250) NOT NULL DEFAULT '', `shipping_method` varchar(250) NOT NULL DEFAULT '', `custom` varchar(250) NOT NULL DEFAULT '', `protection_eligibility` varchar(250) NOT NULL DEFAULT '', `payer_status` varchar(250) NOT NULL DEFAULT '', `first_name` varchar(250) NOT NULL DEFAULT '', `mc_gross` varchar(250) NOT NULL DEFAULT '', `payment_date` varchar(250) NOT NULL DEFAULT '', `payment_status` varchar(250) NOT NULL DEFAULT '', `quantity` varchar(250) NOT NULL DEFAULT '', `business` varchar(250) NOT NULL DEFAULT '', `item_number` varchar(250) NOT NULL DEFAULT '', `last_name` varchar(250) NOT NULL DEFAULT '', `txn_id` varchar(250) NOT NULL DEFAULT '', `mc_fee` varchar(250) NOT NULL DEFAULT '', `resend` varchar(250) NOT NULL DEFAULT '', `payment_type` varchar(250) NOT NULL DEFAULT '', `notify_version` varchar(250) NOT NULL DEFAULT '', `payer_email` varchar(250) NOT NULL DEFAULT '', `receiver_email` varchar(250) NOT NULL DEFAULT '', `tax` varchar(250) NOT NULL DEFAULT '', `residence_country` varchar(250) NOT NULL DEFAULT '', PRIMARY KEY (`referencia`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- Volcado de datos para la tabla `usuarios` -- INSERT INTO `usuarios` (`referencia`, `nombre`, `apellido`, `pais`, `email`, `password`, `compra`, `cmd`, `handling_amount`, `discount`, `insurance_amount`, `payer_id`, `btn_id`, `ipn_track_id`, `shipping`, `charset`, `payment_gross`, `shipping_discount`, `receipt_id`, `verify_sign`, `item_name`, `txn_type`, `receiver_id`, `payment_fee`, `mc_currency`, `transaction_subject`, `shipping_method`, `custom`, `protection_eligibility`, `payer_status`, `first_name`, `mc_gross`, `payment_date`, `payment_status`, `quantity`, `business`, `item_number`, `last_name`, `txn_id`, `mc_fee`, `resend`, `payment_type`, `notify_version`, `payer_email`, `receiver_email`, `tax`, `residence_country`) VALUES (1, 'Juan Pablo', 'Calderon Preciado', 'Mexico', '00pablo00@gmail.com', 'qwer', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (4, '', '', '', '', 'JoSm78554', '', '_notify-validate', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (5, '', '', '', '', 'CaRa44693', '', '_notify-validate', '0.00', '0.00', '0.00', 'VW8SS7W7K932W', '36098288', 'exWktjmvy66RY76hR5dcqw', '0.00', 'windows-1252', '', '0.00', '1954-3155-6908-0399', 'AoGQy5L5o4sHoV2uyVHdeqxBBgEPAV4HCPg7mELcwWHW28iYcUN4-7Rk', 'The Magic Of Careyes: Digital Edition', 'web_accept', '3YVGX26C4WBX4', '', 'MXN', 'The Magic Of Careyes: Digital Edition', 'Default', '', 'Ineligible', 'unverified', 'Carlos Enrique', '1.00', '15:49:59 Oct 21, 2011 PDT', 'Completed', '1', 'careyes@imcmarketing.com.mx', '', 'Raya Gutierrez', '0D1565922S262980M', '1.00', 'true', 'instant', '3.4', 'charricky@hotmail.com', 'careyes@imcmarketing.com.mx', '0.00', 'MX'), (6, '', '', '', '', 'CaRa45349', '', '_notify-validate', '0.00', '0.00', '0.00', 'ZTBKDERRXW424', '36098288', 'nOaeVStqNIUAxjweHOddEg', '0.00', 'windows-1252', '', '0.00', '', 'AFcWxV21C7fd0v3bYYYRCpSSRl31ApoA3M1JbfOWxELSzXBHT-Rbv4Xk', 'The Magic Of Careyes: Digital Edition', 'web_accept', '3YVGX26C4WBX4', '', 'MXN', 'The Magic Of Careyes: Digital Edition', 'Default', '', 'Ineligible', 'unverified', 'Carlos Enrique', '1.00', '15:27:44 Oct 21, 2011 PDT', 'Completed', '1', 'careyes@imcmarketing.com.mx', '', 'Raya Gutiérrez', '9LX80246US1996252', '1.00', 'true', 'instant', '3.4', 'carlos@imcmarketing.com.mx', 'careyes@imcmarketing.com.mx', '0.00', 'MX'), (7, '', '', '', '', 'JuCa18705', 'Macintosh', '_notify-validate', '0.00', '0.00', '0.00', '5PQFJLX26THVE', '36098288', 'DNO6DUiDYuiq9WyetFCjcQ', '0.00', 'windows-1252', '', '0.00', '0289-8582-7330-5212', 'Ao2Df9kfoWDyg647VdL0L4ODGsL.AjQ2KGrSwuJoVnXymwbSWXQKsZ9r', 'The Magic Of Careyes: Digital Edition', 'web_accept', '3YVGX26C4WBX4', '', 'MXN', 'The Magic Of Careyes: Digital Edition', 'Default', '', 'Ineligible', 'unverified', 'Juan Pablo', '1.00', '18:11:40 Oct 23, 2011 PDT', 'Completed', '1', 'careyes@imcmarketing.com.mx', '', 'Calderon Preciado', '6SN39171AB294903J', '1.00', '', 'instant', '3.4', 'juan@imcmarketing.com.mx', 'careyes@imcmarketing.com.mx', '0.00', 'MX'), (8, '', '', '', '', 'GABU44956', 'Macintosh', '_notify-validate', '0.00', '0.00', '0.00', 'ZMPZHNJFGHUBW', '36098288', '7218f1963cf47', '0.00', 'windows-1252', '30.00', '0.00', '', 'A5ccGDYwQNTfxjWrf0lW2.11bEyDAozdDtqBAwodT7B7NvybpkJbwBIb', 'The Magic Of Careyes: Digital Edition', 'web_accept', '3YVGX26C4WBX4', '1.65', 'USD', 'The Magic Of Careyes: Digital Edition', 'Default', '', 'Ineligible', 'verified', 'GABRIELE', '30.00', '06:55:49 Feb 13, 2012 PST', 'Completed', '1', 'careyes@imcmarketing.com.mx', '', 'BUGATTI', '65765763PG0793201', '1.65', '', 'instant', '3.4', 'gabriele.bugatti@gmail.com', 'careyes@imcmarketing.com.mx', '0.00', 'IT'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `usuariosOLD` -- CREATE TABLE IF NOT EXISTS `usuariosOLD` ( `referencia` bigint(20) NOT NULL AUTO_INCREMENT, `nombre` varchar(250) NOT NULL DEFAULT '', `apellido` varchar(250) NOT NULL DEFAULT '', `pais` varchar(250) NOT NULL DEFAULT '', `email` varchar(250) NOT NULL DEFAULT '', `password` varchar(250) NOT NULL DEFAULT '', `compra` varchar(255) NOT NULL DEFAULT '', `cmd` varchar(255) NOT NULL, `test_ipn` varchar(250) NOT NULL DEFAULT '', `payment_type` varchar(250) NOT NULL DEFAULT '', `payment_date` varchar(250) NOT NULL DEFAULT '', `payment_status` varchar(250) NOT NULL DEFAULT '', `pending_reason` varchar(250) NOT NULL DEFAULT '', `address_status` varchar(250) NOT NULL DEFAULT '', `payer_status` varchar(250) NOT NULL DEFAULT '', `first_name` varchar(250) NOT NULL DEFAULT '', `last_name` varchar(250) NOT NULL DEFAULT '', `payer_email` varchar(250) NOT NULL DEFAULT '', `payer_id` varchar(250) NOT NULL DEFAULT '', `address_name` varchar(250) NOT NULL DEFAULT '', `address_country` varchar(250) NOT NULL DEFAULT '', `address_country_code` varchar(250) NOT NULL DEFAULT '', `address_zip` varchar(250) NOT NULL DEFAULT '', `address_state` varchar(250) NOT NULL DEFAULT '', `address_city` varchar(250) NOT NULL DEFAULT '', `address_street` varchar(250) NOT NULL DEFAULT '', `business` varchar(250) NOT NULL DEFAULT '', `receiver_email` varchar(250) NOT NULL DEFAULT '', `receiver_id` varchar(250) NOT NULL DEFAULT '', `residence_country` varchar(250) NOT NULL DEFAULT '', `item_name` varchar(250) NOT NULL DEFAULT '', `item_number` varchar(250) NOT NULL DEFAULT '', `item_name1` varchar(250) NOT NULL DEFAULT '', `item_number1` varchar(250) NOT NULL DEFAULT '', `quantity` varchar(250) NOT NULL DEFAULT '', `quantity1` varchar(250) NOT NULL DEFAULT '', `shipping` varchar(250) NOT NULL DEFAULT '', `tax` varchar(250) NOT NULL DEFAULT '', `mc_currency` varchar(250) NOT NULL DEFAULT '', `mc_fee` varchar(250) NOT NULL DEFAULT '', `mc_gross` varchar(250) NOT NULL DEFAULT '', `mc_gross_1` varchar(250) NOT NULL DEFAULT '', `mc_handling` varchar(250) NOT NULL DEFAULT '', `mc_handling1` varchar(250) NOT NULL DEFAULT '', `mc_shipping` varchar(250) NOT NULL DEFAULT '', `mc_shipping1` varchar(250) NOT NULL DEFAULT '', `txn_type` varchar(250) NOT NULL DEFAULT '', `txn_id` varchar(250) NOT NULL DEFAULT '', `parent_txn_id` varchar(250) NOT NULL DEFAULT '', `notify_version` varchar(250) NOT NULL DEFAULT '', `auction_buyer_id` varchar(250) NOT NULL DEFAULT '', `auction_closing_date` varchar(250) NOT NULL DEFAULT '', `for_auction` varchar(250) NOT NULL DEFAULT '', `reason_code` varchar(250) NOT NULL DEFAULT '', `receipt_ID` varchar(250) NOT NULL DEFAULT '', `custom` varchar(250) NOT NULL DEFAULT '', `invoice` varchar(250) NOT NULL DEFAULT '', `charset` varchar(250) NOT NULL DEFAULT '', `verify_sign` varchar(250) NOT NULL DEFAULT '', PRIMARY KEY (`referencia`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- Volcado de datos para la tabla `usuariosOLD` -- INSERT INTO `usuariosOLD` (`referencia`, `nombre`, `apellido`, `pais`, `email`, `password`, `compra`, `cmd`, `test_ipn`, `payment_type`, `payment_date`, `payment_status`, `pending_reason`, `address_status`, `payer_status`, `first_name`, `last_name`, `payer_email`, `payer_id`, `address_name`, `address_country`, `address_country_code`, `address_zip`, `address_state`, `address_city`, `address_street`, `business`, `receiver_email`, `receiver_id`, `residence_country`, `item_name`, `item_number`, `item_name1`, `item_number1`, `quantity`, `quantity1`, `shipping`, `tax`, `mc_currency`, `mc_fee`, `mc_gross`, `mc_gross_1`, `mc_handling`, `mc_handling1`, `mc_shipping`, `mc_shipping1`, `txn_type`, `txn_id`, `parent_txn_id`, `notify_version`, `auction_buyer_id`, `auction_closing_date`, `for_auction`, `reason_code`, `receipt_ID`, `custom`, `invoice`, `charset`, `verify_sign`) VALUES (1, 'Juan Pablo', 'Calderon Preciado', 'Mexico', '00pablo00@gmail.com', 'qwer', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (4, '', '', '', '', 'JoSm78554', '', '_notify-validate', '1', 'instant', '19:34:14 Oct 06, 2011 PDT', 'Completed', '', 'confirmed', 'verified', 'John', 'Smith', 'pablogeminis@hotmail.com', 'TESTBUYERID01', 'John Smith', 'United States', 'US', '95131', 'CA', 'San Jose', '123, any street', 'seller@paypalsandbox.com', 'seller@paypalsandbox.com', 'TESTSELLERID1', 'US', 'something', 'AK-1234', '', '', '1', '', '3.04', '2.02', 'USD', '0.44', '12.34', '', '', '', '', '', 'web_accept', '', '', '2.1', '', '', '', '', '', 'xyz123', '', 'windows-1252', 'An5ns1Kso7MWUdW4ErQKJJJ4qi4-AmF4ANiakZHUwXha-W.R1NMZT0th'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;