-- phpMyAdmin SQL Dump
-- version 3.4.3.2
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le : Mer 10 Août 2011 à 07:59
-- Version du serveur: 5.1.52
-- Version 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 données: `ckaioun_debtdomain`
--

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

--
-- Structure de la table `dd_archive`
--

CREATE TABLE IF NOT EXISTS `dd_archive` (
  `id` int(10) NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `debtor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `tenor` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `notes` int(8) NOT NULL,
  `files` int(8) NOT NULL,
  `links` int(8) NOT NULL,
  `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `datemod` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `datearchive` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Structure de la table `dd_currencyrates`
--

CREATE TABLE IF NOT EXISTS `dd_currencyrates` (
  `currency` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`currency`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `dd_currencyrates`
--

INSERT INTO `dd_currencyrates` (`currency`, `rate`) VALUES
('USD', 1.4267),
('JPY', 110.24),
('BGN', 1.9558),
('CZK', 24.22),
('DKK', 7.4497),
('GBP', 0.8731),
('HUF', 274.7),
('LTL', 3.4528),
('LVL', 0.7092),
('PLN', 4.0956),
('RON', 4.2625),
('SEK', 9.2127),
('CHF', 1.0594),
('NOK', 7.8295),
('HRK', 7.455),
('RUB', 42.378),
('TRY', 2.5164),
('AUD', 1.399),
('BRL', 2.3138),
('CAD', 1.4143),
('CNY', 9.1745),
('HKD', 11.1401),
('IDR', 12251.9),
('ILS', 5.0838),
('INR', 64.501),
('KRW', 1555.96),
('MXN', 17.7385),
('MYR', 4.3193),
('NZD', 1.7329),
('PHP', 60.611),
('SGD', 1.7329),
('THB', 42.725),
('ZAR', 10.371),
('EUR', 1);

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

--
-- Structure de la table `dd_deals`
--

CREATE TABLE IF NOT EXISTS `dd_deals` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `debtor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `tenor` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `notes` int(8) NOT NULL,
  `files` int(8) NOT NULL,
  `links` int(8) NOT NULL,
  `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `datemod` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Contenu de la table `dd_deals`
--

INSERT INTO `dd_deals` (`id`, `title`, `debtor`, `country`, `value`, `currency`, `tenor`, `status`, `notes`, `files`, `links`, `user`, `datemod`, `date`) VALUES
(3, 'rice agrentina iran', 'saman Bank', 'Iran', '5000000', 'EUR', '360d - 1x12', 'Market Sounding', 0, 0, 0, 'charles.kaioun', '10082011', '2011-08-07 18:55:59');

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

--
-- Structure de la table `dd_dealsdetails`
--

CREATE TABLE IF NOT EXISTS `dd_dealsdetails` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `c2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c3` int(20) NOT NULL,
  `c4` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c5t1` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c5` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `c6` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `c7` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c8` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `c9` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c10` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c11` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c12` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c13` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c14` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `c15` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `c16` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c17` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c18` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c19` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `c20` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c21` decimal(10,3) NOT NULL,
  `c21t1` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c21t2` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c21t3` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c22` decimal(10,3) NOT NULL,
  `c23` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c24` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c25` decimal(10,3) NOT NULL,
  `c26` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c27` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c28` decimal(10,3) NOT NULL,
  `c29` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c30` int(3) NOT NULL,
  `c31` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c32` decimal(10,3) NOT NULL,
  `c33` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c34` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c35` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c36` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c37` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `c38` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c39` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c40` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c41` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `c42` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c43` decimal(10,3) NOT NULL,
  `c44` decimal(10,3) NOT NULL,
  `c44t1` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c44t2` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c44t3` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c45` decimal(10,3) NOT NULL,
  `c46` varchar(46) COLLATE utf8_unicode_ci NOT NULL,
  `c47` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c48` decimal(10,3) NOT NULL,
  `c49` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c50` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c51` decimal(10,3) NOT NULL,
  `c52` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c53` int(3) NOT NULL,
  `c54` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c55` decimal(10,3) NOT NULL,
  `c56` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c57` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c58` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c59` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `c60` decimal(10,3) NOT NULL,
  `c61` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c62` decimal(10,3) NOT NULL,
  `c63` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c64` int(3) NOT NULL,
  `c65` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c66` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c67` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c68` decimal(10,3) NOT NULL,
  `c69` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c70` decimal(10,3) NOT NULL,
  `c71` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c72` int(10) NOT NULL,
  `c73` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c74` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c81` int(1) NOT NULL,
  `c82` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c83` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c84` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `c85` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `c86` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c87` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `c88` int(1) NOT NULL,
  `c89` int(1) NOT NULL,
  `c90` int(1) NOT NULL,
  `c91` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `c92` int(1) NOT NULL,
  `c93` int(1) NOT NULL,
  `c94` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c101` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `c102` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `c103` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c104` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c105` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `c106` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c107` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `c108` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `c201` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c202` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c203` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c204` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c205` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c206` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c207` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c208` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c209` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c210` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `c211` decimal(10,3) NOT NULL,
  `c212` decimal(10,3) NOT NULL,
  `c213` decimal(10,3) NOT NULL,
  `c214` decimal(10,3) NOT NULL,
  `c215` decimal(10,3) NOT NULL,
  `c216` decimal(10,3) NOT NULL,
  `c217` decimal(10,3) NOT NULL,
  `c218` decimal(10,3) NOT NULL,
  `c219` decimal(10,3) NOT NULL,
  `c220` decimal(10,3) NOT NULL,
  `c221` decimal(10,3) NOT NULL,
  `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `estimatedprofit` decimal(20,3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Contenu de la table `dd_dealsdetails`
--

INSERT INTO `dd_dealsdetails` (`id`, `c2`, `c3`, `c4`, `c5t1`, `c5`, `c6`, `c7`, `c8`, `c9`, `c10`, `c11`, `c12`, `c13`, `c14`, `c15`, `c16`, `c17`, `c18`, `c19`, `c20`, `c21`, `c21t1`, `c21t2`, `c21t3`, `c22`, `c23`, `c24`, `c25`, `c26`, `c27`, `c28`, `c29`, `c30`, `c31`, `c32`, `c33`, `c34`, `c35`, `c36`, `c37`, `c38`, `c39`, `c40`, `c41`, `c42`, `c43`, `c44`, `c44t1`, `c44t2`, `c44t3`, `c45`, `c46`, `c47`, `c48`, `c49`, `c50`, `c51`, `c52`, `c53`, `c54`, `c55`, `c56`, `c57`, `c58`, `c59`, `c60`, `c61`, `c62`, `c63`, `c64`, `c65`, `c66`, `c67`, `c68`, `c69`, `c70`, `c71`, `c72`, `c73`, `c74`, `c81`, `c82`, `c83`, `c84`, `c85`, `c86`, `c87`, `c88`, `c89`, `c90`, `c91`, `c92`, `c93`, `c94`, `c101`, `c102`, `c103`, `c104`, `c105`, `c106`, `c107`, `c108`, `c201`, `c202`, `c203`, `c204`, `c205`, `c206`, `c207`, `c208`, `c209`, `c210`, `c211`, `c212`, `c213`, `c214`, `c215`, `c216`, `c217`, `c218`, `c219`, `c220`, `c221`, `user`, `estimatedprofit`) VALUES
(1, 'Italy', 315000, 'EUR', 'DF sro', 'Loan Agreement', 'C', '', '', 'Book', 'RLA', 'Cologne Team 2', '', '', '', 'Reggiani Mecchine Spa, Grassobio, Italy', 'contract', '02/12/2011', 'no', 'open', '', 0.000, '', '', '', 315000.000, 'at discounting or cancellation', '', 0.000, '', 'No', 0.000, '', 0, '', 15000.000, 'EUR', 'yes', '', '', '', '', '', '', '', '', 0.000, 0.000, '', '', '', 0.000, '', '', 0.000, '', '', 0.000, '', 0, '', 0.000, '', '', '', '', 0.000, '', 0.000, '', 0, '', 'TFA Trade Finance Advisors', '', 0.000, '', 0.000, '', 0, '', '', 0, '', '', '', '', '', '', 0, 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 'charles.kaioun', 15000.000),
(2, 'Bangladesh', 515000, 'EUR', 'DF sro', 'Letter of Credit', 'C', '', '', 'Book', 'RLA', 'Cologne Team 2', '', '', '', 'Reggiani Mecchine Spa, Grassobio, Italy', 'contract', '12/12/2011', 'no', 'open', '', 1.500, '% flat', '', '12/08/2011', 515000.000, 'at discounting or cancellation', 'Matching LIBOR +', 7.000, 'sd', 'No', 0.000, '', 15, 'Calendar', 0.000, '', 'yes', '', '', '', '', '', '', '', '', 0.000, 0.000, '', '', '', 0.000, '', '', 0.000, '', '', 0.000, '', 0, '', 0.000, '', '', '', '', 0.000, '', 0.000, '', 0, '', 'TFA Trade Finance Advisors', '', 0.000, '', 0.000, '', 0, '', '', 0, '', '', '', '', '', '', 0, 2, 1, '', 0, 5, '', '', '', 'TFA Trade Finance Advisors', 'wie per Vertrag mit TFA', '', '', '', '', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 'charles.kaioun', 21113.270),
(3, 'Iran', 5000000, 'EUR', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0.000, '', '', '', 0.000, '', '', 0.000, '', '', 0.000, '', 0, '', 0.000, '', '', '', '', '', '', '', '', '', '', 0.000, 0.000, '', '', '', 0.000, '', '', 0.000, '', '', 0.000, '', 0, '', 0.000, '', '', '', '', 0.000, '', 0.000, '', 0, '', '', '', 0.000, '', 0.000, '', 0, '', '', 1, '', '', '', '', '', '', 0, 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 'x', 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 'charles.kaioun', 0.000);

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

--
-- Structure de la table `dd_files`
--

CREATE TABLE IF NOT EXISTS `dd_files` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `refid` int(8) NOT NULL,
  `mainfolder` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `subfolder` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `filedesc` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `dd_liborrates`
--

CREATE TABLE IF NOT EXISTS `dd_liborrates` (
  `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `rate` decimal(10,5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Structure de la table `dd_links`
--

CREATE TABLE IF NOT EXISTS `dd_links` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `refid` int(8) NOT NULL,
  `folder` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `desc` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `dd_members`
--

CREATE TABLE IF NOT EXISTS `dd_members` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `login` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `pass` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `rights` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `office` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `online` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `heure` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `sessid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Contenu de la table `dd_members`
--

INSERT INTO `dd_members` (`id`, `email`, `login`, `pass`, `rights`, `office`, `online`, `date`, `heure`, `sessid`) VALUES
(1, 'salesdesk@dfag.de', 'charles.kaioun', '05a671c66aefea124cc08b76ea6d30bb', 'admin', 'Cologne T2', 'oui', '10082011', '0638', '6266793d985c78bcae1515b3bb43ebba'),
(2, 'rene-laurent.alciator@dfag.de', 'rene-laurent.alciator', '3a8a833abef478d5696fb3a952817135', 'teammanager', 'Cologne T2', 'oui', '07072011', '1517', 'fb53ca503d7b21fc55d8e5729edcca0c'),
(3, 'christiane.thoenes@dfag.de', 'christiane.thoenes', '5127e2dacf24a3e83606e9e309fc6ae8', 'teammanager', 'Cologne T1', 'non', '12072011', '0644', 'f2e2c3c6aa1db1d39ff3b3c2217039ed'),
(5, 'arnd.peterhoff@dfag.de', 'arnd.peterhoff', 'e8f9ecf5f692eba6600ee253f86f273c', 'trader', 'Cologne T2', 'oui', '19072011', '0209', 'f75755bb14b4e772770eaa01b415cb50'),
(6, 'ulrich.wippermann@dfag.de', 'ulrich.wippermann', 'd1623ce7a2f0cf7152c1610c06ea7185', 'vorstand', 'Cologne T2', 'oui', '17072011', '0221', 'b95b2a6f9e2e93fd1807265b37ca669b'),
(7, 'wenli.wang@dfag.de', 'wenli.wang', 'e08392bb89dedb8ed6fb298f8e729c15', 'trader', 'Cologne T2', 'oui', '20072011', '0721', 'dd5e2b7cfbbf76bc03411fd4dc01fa56'),
(8, 'jochen.franke@dfag.de', 'jochen.franke', '7603e07539216b364cdb015f67872c66', 'vorstand', '', 'non', '21072011', '1005', '3e264580cc266659ea1e2442a5cc1bd6'),
(9, 'eric.baillavoine@dfag.de', 'eric.baillavoine', '9cad80c7cac15cae7a45caac817b7cd5', 'trader', 'Paris', '', '', '', '');

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

--
-- Structure de la table `dd_notes`
--

CREATE TABLE IF NOT EXISTS `dd_notes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `refid` int(10) NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Contenu de la table `dd_notes`
--

INSERT INTO `dd_notes` (`id`, `refid`, `note`, `title`, `date`) VALUES
(1, 2, 'Discounting L/C regarding the prefinancing deal REF 1', 'infos', '2011-08-04 11:06:55');

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

--
-- Structure de la table `dd_publish`
--

CREATE TABLE IF NOT EXISTS `dd_publish` (
  `id` int(10) NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `debtor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `tenor` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `notes` int(8) NOT NULL,
  `files` int(8) NOT NULL,
  `links` int(8) NOT NULL,
  `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `datemod` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `datepublished` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `dd_publish`
--

INSERT INTO `dd_publish` (`id`, `title`, `debtor`, `country`, `value`, `currency`, `tenor`, `status`, `notes`, `files`, `links`, `user`, `datemod`, `date`, `datepublished`) VALUES
(1, 'reggiani 315k prefinancing', 'Reggiani Macchine Spa', 'Italy', '315000', 'EUR', '3m - 1x3', 'Newly unreflisted', 0, 0, 0, 'charles.kaioun', '10082011', '2011-08-04 05:24:45', '2011-08-10 09:34:01');

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

--
-- Structure de la table `dd_refliste`
--

CREATE TABLE IF NOT EXISTS `dd_refliste` (
  `id` int(10) NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `debtor` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `tenor` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `notes` int(8) NOT NULL,
  `files` int(8) NOT NULL,
  `links` int(8) NOT NULL,
  `user` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `datemod` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `dateclosed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `dd_refliste`
--

INSERT INTO `dd_refliste` (`id`, `title`, `debtor`, `country`, `value`, `currency`, `tenor`, `status`, `notes`, `files`, `links`, `user`, `datemod`, `date`, `dateclosed`) VALUES
(2, 'reggiani 515k discounting', 'Reggiani Macchine Spa', 'Bangladesh', '515000', 'EUR', '3m - 1x3', 'RefListe', 0, 0, 0, 'charles.kaioun', '08082011', '2011-08-04 05:29:31', '2011-08-08 12:30:34');

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