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

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

--
-- Estrutura da tabela `activity`
--

CREATE TABLE IF NOT EXISTS `activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `icon` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=266 ;

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

--
-- Estrutura da tabela `activity_com`
--

CREATE TABLE IF NOT EXISTS `activity_com` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(255) NOT NULL,
  `activity_att` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;

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

--
-- Estrutura da tabela `address_book`
--

CREATE TABLE IF NOT EXISTS `address_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `birthday` varchar(30) NOT NULL,
  `birthday_year` varchar(10) NOT NULL,
  `company` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `note` text NOT NULL,
  `date` varchar(255) NOT NULL,
  `last_email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

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

--
-- Estrutura da tabela `backup_log`
--

CREATE TABLE IF NOT EXISTS `backup_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `server` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

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

--
-- Estrutura da tabela `calendar`
--

CREATE TABLE IF NOT EXISTS `calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idA` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(255) NOT NULL,
  `date_for` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `time` varchar(60) NOT NULL,
  `length` varchar(255) NOT NULL,
  `type_event` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=93 ;

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

--
-- Estrutura da tabela `calls`
--

CREATE TABLE IF NOT EXISTS `calls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_contact` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `interlocutors` text NOT NULL,
  `files` text NOT NULL,
  `answer_by` varchar(255) NOT NULL,
  `uCall` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=341 ;

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

--
-- Estrutura da tabela `chat_group`
--

CREATE TABLE IF NOT EXISTS `chat_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users` text NOT NULL,
  `date` varchar(255) NOT NULL,
  `super_user` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

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

--
-- Estrutura da tabela `chat_msg`
--

CREATE TABLE IF NOT EXISTS `chat_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fromMsg` varchar(255) NOT NULL,
  `toMsg` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `date` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=127 ;

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

--
-- Estrutura da tabela `chat_notread`
--

CREATE TABLE IF NOT EXISTS `chat_notread` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `whoMsg` int(11) NOT NULL,
  `fromMsg` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `sound` varchar(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=157 ;

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

--
-- Estrutura da tabela `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type_id` int(11) NOT NULL,
  `tel` varchar(60) NOT NULL,
  `fax` varchar(60) NOT NULL,
  `date_ajout` varchar(255) NOT NULL,
  `enseigne` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `activity` varchar(255) NOT NULL,
  `adresse` text NOT NULL,
  `adresse_2` text NOT NULL,
  `adresse_3` text NOT NULL,
  `code_postale` varchar(60) NOT NULL,
  `ville` varchar(255) NOT NULL,
  `pays` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `siteweb` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `effectif` int(11) NOT NULL,
  `forme_juridique` varchar(255) NOT NULL,
  `capital_social` varchar(255) NOT NULL,
  `chiffre_affaire` varchar(255) NOT NULL,
  `source` varchar(255) NOT NULL,
  `potentiel` varchar(255) NOT NULL,
  `rcs` varchar(255) NOT NULL,
  `siret` varchar(255) NOT NULL,
  `ape` varchar(255) NOT NULL,
  `tva` varchar(255) NOT NULL,
  `adresse_livraison` text NOT NULL,
  `adresse_livraison_2` text NOT NULL,
  `adresse_livraison_3` text NOT NULL,
  `adresse_facturation` text NOT NULL,
  `adresse_facturation_2` text NOT NULL,
  `adresse_facturation_3` text NOT NULL,
  `code_postal_livraison` varchar(255) NOT NULL,
  `code_postal_facturation` varchar(255) NOT NULL,
  `ville_livraison` varchar(255) NOT NULL,
  `ville_facturation` varchar(255) NOT NULL,
  `pays_livraison` varchar(255) NOT NULL,
  `pays_facturation` varchar(255) NOT NULL,
  `representant` int(11) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'normal',
  `cache_lat` varchar(255) NOT NULL,
  `cache_lng` varchar(255) NOT NULL,
  `newsletter` varchar(255) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=756 ;

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

--
-- Estrutura da tabela `functions`
--

CREATE TABLE IF NOT EXISTS `functions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `typeFunction` varchar(2255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ;

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

--
-- Estrutura da tabela `interlocutor`
--

CREATE TABLE IF NOT EXISTS `interlocutor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_contact` int(11) NOT NULL,
  `civility` varchar(60) NOT NULL,
  `name` varchar(255) NOT NULL,
  `function` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `second_email` varchar(255) NOT NULL,
  `adress` text NOT NULL,
  `code_postal` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'normal',
  `newsletter` varchar(255) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=130 ;

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

--
-- Estrutura da tabela `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `last_co` varchar(255) NOT NULL,
  `avatar_name` varchar(255) NOT NULL DEFAULT 'avatar.jpg',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

--
-- Extraindo dados da tabela `login`
--

INSERT INTO `login` (`id`, `username`, `password`, `email`, `type`, `name`, `status`, `last_co`, `avatar_name`) VALUES (NULL, 'Admin', 'e6c83b282aeb2e022844595721cc00bbda47cb24537c1779f9bb84f04039e1676e6ba8573e588da1052510e3aa0a32a9e55879ae22b0c2d62136fc0a3e85f8bb', 'admin@admin.com', 'administrator', 'Admin', '0', '', 'avatar.jpg');
-- --------------------------------------------------------

--
-- Estrutura da tabela `mail_users`
--

CREATE TABLE IF NOT EXISTS `mail_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` varchar(255) NOT NULL,
  `name_account` varchar(255) NOT NULL,
  `imap_srv` varchar(255) NOT NULL,
  `imap_port` varchar(255) NOT NULL,
  `imap_user` varchar(255) NOT NULL,
  `imap_password` varchar(255) NOT NULL,
  `protocol` varchar(255) NOT NULL,
  `ext` varchar(255) NOT NULL,
  `default_box` varchar(255) NOT NULL DEFAULT 'INBOX',
  `smtp_srv` varchar(255) NOT NULL,
  `smtp_port` varchar(255) NOT NULL,
  `smtp_user` varchar(255) NOT NULL,
  `smtp_password` varchar(255) NOT NULL,
  `smtp_ext` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

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

--
-- Estrutura da tabela `notes`
--

CREATE TABLE IF NOT EXISTS `notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_contact` int(11) NOT NULL,
  `id_author` int(11) NOT NULL,
  `date` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `forTo` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

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

--
-- Estrutura da tabela `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` varchar(255) NOT NULL,
  `calendar_hours` varchar(255) NOT NULL,
  `calendar_days` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Estrutura da tabela `table_cols`
--

CREATE TABLE IF NOT EXISTS `table_cols` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cols` text NOT NULL,
  `type` varchar(255) NOT NULL,
  `id_user` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

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

--
-- Estrutura da tabela `tasks`
--

CREATE TABLE IF NOT EXISTS `tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `summary` varchar(40) NOT NULL,
  `date` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `priority` varchar(255) NOT NULL,
  `assigned` varchar(255) NOT NULL,
  `deadline` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;

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