-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
-- Client: mysql.prosysteme.fr
-- Généré le: Lun 17 Mars 2014 à 08:28
-- Version du serveur: 5.5.35-log
-- Version de PHP: 5.3.27

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 données: `prosystemefr7`
--

-- --------------------------------------------------------

--
-- Structure de la table `hmiqh_akeebasubs_subscriptions`
--

CREATE TABLE IF NOT EXISTS `hmiqh_akeebasubs_subscriptions` (
  `akeebasubs_subscription_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `akeebasubs_level_id` bigint(20) unsigned NOT NULL,
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `notes` text,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `processor` varchar(255) NOT NULL,
  `processor_key` varchar(255) NOT NULL,
  `state` enum('N','P','C','X') NOT NULL DEFAULT 'X',
  `net_amount` float NOT NULL,
  `tax_amount` float NOT NULL,
  `gross_amount` float NOT NULL,
  `recurring_amount` float DEFAULT '0',
  `tax_percent` float DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `params` text,
  `akeebasubs_coupon_id` bigint(20) DEFAULT NULL,
  `akeebasubs_upgrade_id` bigint(20) DEFAULT NULL,
  `akeebasubs_affiliate_id` bigint(20) DEFAULT NULL,
  `affiliate_comission` float NOT NULL DEFAULT '0',
  `akeebasubs_invoice_id` bigint(20) DEFAULT NULL,
  `prediscount_amount` float DEFAULT NULL,
  `discount_amount` float NOT NULL DEFAULT '0',
  `contact_flag` tinyint(1) NOT NULL DEFAULT '0',
  `first_contact` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `second_contact` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `after_contact` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`akeebasubs_subscription_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;

--
-- Contenu de la table `hmiqh_akeebasubs_subscriptions`
--

INSERT INTO `hmiqh_akeebasubs_subscriptions` (`akeebasubs_subscription_id`, `user_id`, `akeebasubs_level_id`, `publish_up`, `publish_down`, `notes`, `enabled`, `processor`, `processor_key`, `state`, `net_amount`, `tax_amount`, `gross_amount`, `recurring_amount`, `tax_percent`, `created_on`, `params`, `akeebasubs_coupon_id`, `akeebasubs_upgrade_id`, `akeebasubs_affiliate_id`, `affiliate_comission`, `akeebasubs_invoice_id`, `prediscount_amount`, `discount_amount`, `contact_flag`, `first_contact`, `second_contact`, `after_contact`) VALUES
(1, 814, 1, '2014-01-22 15:26:05', '2014-01-23 15:26:05', '', 0, 'hikashop', 'fcda2d204829f4b3afdabab2aa370c8c', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-22 15:26:05', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 814, 1, '2014-01-23 14:26:05', '2014-01-24 14:26:05', '', 0, 'hikashop', '007658d4ce3117619b9506f16a42e340', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 16:48:58', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 814, 1, '2014-01-24 13:26:05', '2014-01-25 13:26:05', '', 0, 'hikashop', '7f911576275f33f96884ce93beede000', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 17:10:59', '{}', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 814, 1, '2014-01-25 12:26:05', '2014-01-26 12:26:05', '', 0, 'hikashop', 'fac13271cf07121bc789a751c5a541f8', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 17:55:42', '{}', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 814, 1, '2014-01-26 11:26:05', '2014-01-27 11:26:05', '', 0, 'hikashop', '9475f4b164e6e96bb80fbf172c4548c1', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 18:16:18', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 814, 1, '2014-01-27 10:26:05', '2014-01-28 10:26:05', '', 0, 'hikashop', '7702001515a0e303d3547beed6fef8e5', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 18:23:17', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 814, 1, '2014-01-28 09:26:05', '2014-01-29 09:26:05', '', 0, 'hikashop', '8310071a0ee6a489e5454302cda8ce77', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 18:26:45', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 814, 1, '2014-01-29 08:26:05', '2014-01-30 08:26:05', '', 0, 'hikashop', 'a9d42eaab1b6959df9dedc466c97882a', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 18:38:18', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 814, 1, '2014-01-30 07:26:05', '2014-01-31 07:26:05', '', 0, 'hikashop', 'f71fd4b0319b85bb1d19eb668c5ef33d', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 18:59:50', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 814, 1, '2014-01-31 06:26:05', '2014-02-01 06:26:05', '', 0, 'hikashop', '9d809fc1b4f000cb2b095bcca0a0a63c', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-23 19:05:10', '{}', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 814, 1, '2014-02-01 05:26:05', '2014-02-02 05:26:05', '', 0, 'hikashop', '219492ce3efb4286843cb52f76fcc3b7', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-24 09:54:51', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 814, 1, '2014-02-02 04:26:05', '2014-02-03 04:26:05', '', 0, 'hikashop', 'a75f2ca672e80925184c2d43ad385c35', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-24 10:34:40', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 814, 1, '2014-02-03 03:26:05', '2014-02-04 03:26:05', '', 0, 'hikashop', '0dc4d2e82d219bf75d1defa4fb885ad5', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-24 10:55:58', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 814, 1, '2014-02-04 02:26:05', '2014-02-05 02:26:05', '', 0, 'hikashop', 'f3da5e4934f715503f287b7d50c8141a', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-27 11:51:36', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 814, 1, '2014-02-05 01:26:05', '2014-02-06 01:26:05', '', 0, 'hikashop', '6c80bc2545cc22fe3a7e457793ca61f3', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-27 11:51:44', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 814, 1, '2014-02-06 00:26:05', '2014-02-07 00:26:05', '', 0, 'hikashop', 'ccf1a5857688b6ecb16dd3eb9a70666f', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 08:32:55', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 814, 1, '2014-02-06 23:26:05', '2014-02-07 23:26:05', '', 0, 'hikashop', 'e7f2148cdb561523af10522c6913869f', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 09:24:24', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 814, 1, '2014-02-07 22:26:05', '2014-02-08 22:26:05', '', 0, 'hikashop', '882ac21e864a07b233a7885210ed48c5', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 09:45:46', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 814, 1, '2014-02-08 21:26:05', '2014-02-09 21:26:05', '', 0, 'hikashop', 'c34239bae0b4532b17dade235e92eaba', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 09:52:58', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 814, 1, '2014-02-09 20:26:05', '2014-02-10 20:26:05', '', 0, 'hikashop', '79b2e6b8bdc4f05747a4e162c3f75523', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 12:44:50', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 814, 1, '2014-02-10 19:26:05', '2014-02-11 19:26:05', '', 0, 'hikashop', '20ae2ede6c707351c6b3cdea135dd872', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 12:59:14', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 814, 1, '2014-02-11 18:26:05', '2014-02-12 18:26:05', '', 0, 'hikashop', 'c854bcfe6ed648c5321939afd55fd87b', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 13:25:44', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 814, 1, '2014-02-12 17:26:05', '2014-02-13 17:26:05', '', 0, 'hikashop', 'd7af16d29f8be4f410d98c772d276eb4', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 14:11:15', '{}', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 814, 1, '2014-02-13 16:26:05', '2014-02-14 16:26:05', '', 0, 'hikashop', '9728c885405da4ad5a00857b8bbb4b7e', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 14:13:56', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 814, 1, '2014-02-14 15:26:05', '2014-02-15 15:26:05', '', 0, 'hikashop', '3a14572a1e2d86af76034f8171d525df', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 14:23:50', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 814, 1, '2014-02-15 14:26:05', '2014-02-16 14:26:05', '', 0, 'hikashop', 'c7d362b35a2e657bd104bcf6522311f2', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 14:48:48', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 814, 1, '2014-02-16 13:26:05', '2014-02-17 13:26:05', '', 0, 'hikashop', '09137d45413ec162ff42c84c4698a4ff', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 15:47:56', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 814, 1, '2014-02-17 12:26:05', '2014-02-18 12:26:05', '', 0, 'hikashop', 'd77c0503a36427591bc57dcdb7d69405', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 15:52:22', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 814, 1, '2014-02-18 11:26:05', '2014-02-19 11:26:05', '', 0, 'hikashop', '6623b68cbef112493265451f984d958a', 'C', 1, 0.2, 1.2, 0, 20, '2014-01-28 21:20:32', '', NULL, NULL, NULL, 0, NULL, 1.2, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 814, 1, '2014-02-19 10:26:05', '2014-02-20 10:26:05', '', 0, 'hikashop', 'c0db351b8dc2035c7ca343bdfb529961', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-01-29 07:11:57', '', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 814, 1, '2014-02-20 09:26:05', '2014-02-21 09:26:05', '', 0, 'hikashop', 'e52655ea7a0fd926ef45ad8433c844b0', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-01-29 19:53:31', '', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 814, 1, '2014-02-21 08:26:05', '2014-02-22 08:26:05', '', 0, 'hikashop', 'a228ca3d0933c62738797c28ec7e2754', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-01-29 19:56:31', '', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 814, 1, '2014-02-22 07:26:05', '2014-02-23 07:26:05', '', 0, 'hikashop', '1c6b0a13722ad3d954359a72107aafbe', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-01-29 20:04:50', '', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 814, 1, '2014-02-23 06:26:05', '2014-02-24 06:26:05', '', 0, 'hikashop', '546358e4bf06d4cb06188da1f8505ad2', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-01-30 14:29:05', '', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 814, 1, '2014-02-24 05:26:05', '2014-02-25 05:26:05', '', 0, 'hikashop', '6a90068901bc4aad0b89ccee941e100d', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-02-01 14:12:47', '', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 814, 1, '2014-02-25 04:26:05', '2014-02-26 04:26:05', '', 0, 'hikashop', '9f9c81700081af20c71a3200ba5f1feb', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-02-01 14:22:48', '{}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, 814, 1, '2014-02-26 03:26:05', '2014-02-27 03:26:05', '', 0, 'hikashop', 'f66859ac4f2378885406adba2f429e1b', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-02-18 11:08:28', '{}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 814, 1, '2014-03-05 00:00:00', '2014-03-06 00:00:00', '', 0, 'hikashop', 'f52033b05fe765a1108c2b6f4cda898d', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-03-05 18:57:11', '{"subcustom":[]}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 814, 1, '2014-03-09 00:00:00', '2014-03-10 00:00:00', '', 0, 'hikashop', '4914d0ffea53f971d3d8e80064ebb899', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-03-09 00:00:00', '{"subcustom":[]}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, 814, 1, '2014-03-11 00:00:00', '2014-03-12 00:00:00', '', 0, 'hikashop', 'b4b05be7ba92ac83c2d3f231c8824309', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-03-11 00:00:00', '{"subcustom":[]}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 814, 1, '2014-03-11 23:00:00', '2014-03-12 23:00:00', '', 0, 'hikashop', '4db37160a771b126dbfdf562a574d5f5', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-03-13 13:26:36', '{}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 814, 1, '2014-03-12 22:00:00', '2014-03-13 22:00:00', '', 0, 'hikashop', '64c550b1b614cf17886ff594513ae7dd', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-03-14 08:19:56', '{}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 814, 1, '2014-03-13 21:00:00', '2014-03-14 21:00:00', '', 0, 'hikashop', 'a4be7968c7cfa42ec8fa595f98009922', 'C', 0.5, 0.1, 0.6, 0, 20, '2014-03-17 07:16:25', '{}', NULL, NULL, NULL, 0, NULL, 0.6, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

/*!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 */;