· 9 years ago · Mar 13, 2017, 10:00 AM
1-- phpMyAdmin SQL Dump
2-- version 2.11.8.1deb5+lenny9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Mar 13, 2017 at 10:58 AM
7-- Server version: 5.0.51
8-- PHP Version: 5.2.6-1+lenny16
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Database: `kitPublication`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Table structure for table `sys_dmail_maillog`
26--
27
28CREATE TABLE IF NOT EXISTS `sys_dmail_maillog` (
29 `uid` int(11) unsigned NOT NULL auto_increment,
30 `mid` int(11) unsigned NOT NULL default '0',
31 `rid` int(11) unsigned NOT NULL default '0',
32 `email` varchar(255) NOT NULL default '',
33 `rtbl` char(1) NOT NULL default '',
34 `tstamp` int(11) unsigned NOT NULL default '0',
35 `url` tinyblob NOT NULL,
36 `size` int(11) unsigned NOT NULL default '0',
37 `parsetime` int(11) unsigned NOT NULL default '0',
38 `response_type` tinyint(4) NOT NULL default '0',
39 `html_sent` tinyint(4) NOT NULL default '0',
40 `url_id` tinyint(4) NOT NULL default '0',
41 `return_content` mediumblob NOT NULL,
42 `return_code` smallint(6) NOT NULL default '0',
43 PRIMARY KEY (`uid`),
44 KEY `rid` (`rid`,`rtbl`,`mid`,`response_type`,`uid`),
45 KEY `mid` (`mid`,`response_type`,`rtbl`,`rid`)
46) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
47
48--
49-- Dumping data for table `sys_dmail_maillog`
50--
51
52INSERT INTO `sys_dmail_maillog` (`uid`, `mid`, `rid`, `email`, `rtbl`, `tstamp`, `url`, `size`, `parsetime`, `response_type`, `html_sent`, `url_id`, `return_content`, `return_code`) VALUES
53(1, 5, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316767678, '', 1, 1, 0, 0, 0, '', 0),
54(2, 5, 57, 'laurent.deguilhem@gmail.com', 'f', 1316767678, '', 1, 1, 0, 0, 0, '', 0),
55(3, 6, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316778422, '', 1, 1, 0, 0, 0, '', 0),
56(4, 6, 57, 'laurent.deguilhem@gmail.com', 'f', 1316778422, '', 1, 1, 0, 0, 0, '', 0),
57(5, 7, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316778783, '', 1, 2, 0, 0, 0, '', 0),
58(6, 7, 57, 'laurent.deguilhem@gmail.com', 'f', 1316778783, '', 1, 1, 0, 0, 0, '', 0),
59(7, 8, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316780223, '', 1, 2, 0, 0, 0, '', 0),
60(8, 8, 57, 'laurent.deguilhem@gmail.com', 'f', 1316780223, '', 1, 1, 0, 0, 0, '', 0),
61(9, 10, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316780462, '', 147189, 206, 0, 1, 0, '', 0),
62(10, 10, 57, 'laurent.deguilhem@gmail.com', 'f', 1316780462, '', 1, 1, 0, 0, 0, '', 0),
63(11, 11, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316780522, '', 147189, 261, 0, 1, 0, '', 0),
64(12, 12, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316780583, '', 147189, 268, 0, 1, 0, '', 0),
65(13, 14, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316780822, '', 147181, 154, 0, 1, 0, '', 0),
66(14, 14, 57, 'laurent.deguilhem@gmail.com', 'f', 1316780823, '', 147181, 128, 0, 1, 0, '', 0),
67(15, 15, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316783463, '', 147181, 178, 0, 1, 0, '', 0),
68(16, 15, 57, 'laurent.deguilhem@gmail.com', 'f', 1316783463, '', 147181, 197, 0, 1, 0, '', 0),
69(17, 13, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316783822, '', 147181, 239, 0, 1, 0, '', 0),
70(18, 13, 58, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316783822, '', 147181, 136, 0, 1, 0, '', 0),
71(19, 16, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316960403, '', 147190, 185, 0, 1, 0, '', 0),
72(20, 16, 58, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316960403, '', 147190, 150, 0, 1, 0, '', 0),
73(21, 17, 56, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316960462, '', 147181, 234, 0, 1, 0, '', 0),
74(22, 17, 58, 'laurent.deguilhem@cantal.chambagri.fr', 'f', 1316960462, '', 147181, 147, 0, 1, 0, '', 0),
75(23, 18, 1, 'liste.groupe-web.k@apca.chambagri.fr', 'P', 1318314962, '', 378910, 309, 0, 1, 0, '', 0),
76(24, 18, 2, 'luc.delgado@aveyron.chambagri.fr', 'P', 1318314963, '', 378910, 194, 0, 1, 0, '', 0),
77(25, 19, 1, 'laurent.deguilhem@cantal.chambagri.fr', 'P', 1318315322, '', 378910, 347, 0, 1, 0, '', 0),
78(26, 19, 2, 'laurent.deguilhem@gmail.com', 'P', 1318315322, '', 378910, 272, 0, 1, 0, '', 0),
79(27, 19, 3, 'scnapelynck@alpes-maritimes.chambagri.fr', 'P', 1318315322, '', 378910, 186, 0, 1, 0, '', 0),
80(28, 19, 4, 'rlemaire@ahp.chambagri.fr', 'P', 1318315323, '', 378910, 205, 0, 1, 0, '', 0),
81(29, 19, 5, 'frederic.guimier@sarthe.chambagri.fr', 'P', 1318315323, '', 378910, 217, 0, 1, 0, '', 0),
82(30, 19, 6, 'c.noel@cher.chambagri.fr', 'P', 1318315323, '', 378910, 191, 0, 1, 0, '', 0),
83(31, 19, 7, 'David.JUIN@poitou-charentes.chambagri.fr', 'P', 1318315323, '', 378910, 157, 0, 1, 0, '', 0),
84(32, 19, 8, 'eveline.brisset@dordogne.chambagri.fr', 'P', 1318315323, '', 378910, 205, 0, 1, 0, '', 0),
85(33, 19, 9, 'luc.delgado@aveyron.chambagri.fr', 'P', 1318315324, '', 378910, 203, 0, 1, 0, '', 0);