-- --------------------------------------------------------
-- Hôte:                         127.0.0.1
-- Version du serveur:           10.4.14-MariaDB - mariadb.org binary distribution
-- SE du serveur:                Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Listage de la structure de la table notaires. acheteurs
CREATE TABLE IF NOT EXISTS `acheteurs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_client` int(11) DEFAULT NULL,
  `id_dossier` int(11) DEFAULT NULL,
  `signe` int(11) NOT NULL DEFAULT 0,
  `date_signe` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.acheteurs : ~7 rows (environ)
INSERT INTO `acheteurs` (`id`, `id_client`, `id_dossier`, `signe`, `date_signe`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(11, 1, 3, 0, '2021-02-11', NULL, '2021-02-11 15:13:15', '2021-02-11 15:13:15'),
	(12, 2, 3, 0, '2021-02-11', NULL, '2021-02-11 15:15:07', '2021-02-11 15:15:07'),
	(13, 2, 4, 0, NULL, NULL, '2021-02-17 15:35:26', '2021-02-17 15:35:26'),
	(14, 1, 4, 0, NULL, NULL, '2021-02-17 15:35:26', '2021-02-17 15:35:26'),
	(15, 2, 5, 0, NULL, NULL, '2021-02-19 09:28:44', '2021-02-19 09:28:44'),
	(16, 1, 5, 0, NULL, NULL, '2021-02-19 09:28:44', '2021-02-19 09:28:44'),
	(17, 5, 6, 0, NULL, NULL, '2021-03-18 17:11:27', '2021-03-18 17:11:27');

-- Listage de la structure de la table notaires. cat_proprietes
CREATE TABLE IF NOT EXISTS `cat_proprietes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `Cat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.cat_proprietes : ~7 rows (environ)
INSERT INTO `cat_proprietes` (`id`, `Cat`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(31, 'xaxa', '2021-03-06 10:19:02', '2021-03-06 10:18:44', '2021-03-06 10:19:02'),
	(32, 'test', '2021-03-06 10:19:02', '2021-03-06 10:18:57', '2021-03-06 10:19:02'),
	(33, 'xaxa', '2021-03-06 10:19:58', '2021-03-06 10:19:54', '2021-03-06 10:19:58'),
	(34, 'ssss', '2021-03-06 10:22:14', '2021-03-06 10:22:05', '2021-03-06 10:22:14'),
	(35, 'xaxaeee', NULL, '2021-03-06 10:22:49', '2021-03-06 10:25:59'),
	(36, 'xaxa', '2021-03-06 10:22:59', '2021-03-06 10:22:53', '2021-03-06 10:22:59'),
	(37, 'xaxaeee111', NULL, '2021-03-06 10:26:06', '2021-03-06 10:29:11');

-- Listage de la structure de la table notaires. charges
CREATE TABLE IF NOT EXISTS `charges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_dossier` int(11) DEFAULT NULL,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mode_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_cheque` int(11) DEFAULT NULL,
  `montant` int(11) DEFAULT NULL,
  `date_charge` date DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.charges : ~1 rows (environ)
INSERT INTO `charges` (`id`, `id_dossier`, `designation`, `mode_reg`, `num_cheque`, `montant`, `date_charge`, `remarque`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, NULL, 'test', 'Espèces', NULL, 13213, '2021-03-22', NULL, NULL, '2021-03-22 14:11:19', '2021-03-22 14:11:19');

-- Listage de la structure de la table notaires. comptes
CREATE TABLE IF NOT EXISTS `comptes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `munCompt` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nomCompt` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.comptes : ~11 rows (environ)
INSERT INTO `comptes` (`id`, `munCompt`, `deleted_at`, `created_at`, `updated_at`, `nomCompt`) VALUES
	(14, 'test', NULL, '2021-03-06 10:25:38', '2021-03-06 10:25:38', 'test1'),
	(15, 'test', '2021-03-06 10:25:49', '2021-03-06 10:25:44', '2021-03-06 10:25:49', NULL),
	(16, 'test2', NULL, '2021-03-18 13:21:22', '2021-03-18 13:21:22', NULL),
	(17, '1321', '2021-03-18 13:48:18', '2021-03-18 13:23:58', '2021-03-18 13:48:18', NULL),
	(18, '12313', '2021-03-18 13:48:23', '2021-03-18 13:24:47', '2021-03-18 13:48:23', NULL),
	(19, '12313000', '2021-03-18 13:48:27', '2021-03-18 13:27:03', '2021-03-18 13:48:27', NULL),
	(20, '1321', '2021-03-18 13:48:32', '2021-03-18 13:28:01', '2021-03-18 13:48:32', '12312'),
	(21, '1231', NULL, '2021-03-18 13:36:35', '2021-03-18 13:36:35', NULL),
	(22, '1232', NULL, '2021-03-18 13:37:09', '2021-03-18 13:37:09', NULL),
	(23, '123456789123456789123456', NULL, '2021-03-18 14:10:27', '2021-03-18 14:10:27', 'cih'),
	(24, '123456789123456789123456', NULL, '2021-03-18 14:29:06', '2021-03-18 14:29:06', 'CIH');

-- Listage de la structure de la table notaires. conservation_foncieres
CREATE TABLE IF NOT EXISTS `conservation_foncieres` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `conservationFonciere` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.conservation_foncieres : ~6 rows (environ)
INSERT INTO `conservation_foncieres` (`id`, `conservationFonciere`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'conv 1', '2021-03-08 13:51:20', NULL, '2021-03-08 13:51:20'),
	(2, 'xaxa', '2021-03-08 13:51:41', '2021-03-05 15:16:31', '2021-03-08 13:51:41'),
	(3, 'ded', '2021-03-08 13:51:47', '2021-03-05 15:16:49', '2021-03-08 13:51:47'),
	(4, '1230', '2021-03-08 13:51:53', '2021-03-05 15:18:30', '2021-03-08 13:51:53'),
	(5, 'test1', '2021-03-08 13:51:58', '2021-03-06 10:44:32', '2021-03-08 13:51:58'),
	(6, '123', NULL, '2021-03-08 13:52:10', '2021-03-08 13:52:10');

-- Listage de la structure de la table notaires. detail_devis
CREATE TABLE IF NOT EXISTS `detail_devis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_devis` int(11) DEFAULT NULL,
  `id_produit` int(11) DEFAULT NULL,
  `remise` int(11) DEFAULT NULL,
  `prix` double DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.detail_devis : ~0 rows (environ)

-- Listage de la structure de la table notaires. devis
CREATE TABLE IF NOT EXISTS `devis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_dossier` int(11) DEFAULT NULL,
  `id_client` int(11) DEFAULT NULL,
  `montant` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_devis` date DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.devis : ~1 rows (environ)
INSERT INTO `devis` (`id`, `id_dossier`, `id_client`, `montant`, `date_devis`, `remarque`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 5, 1, '14141', '2021-03-05', NULL, NULL, '2021-03-05 14:09:04', '2021-03-05 14:09:04');

-- Listage de la structure de la table notaires. dossiers
CREATE TABLE IF NOT EXISTS `dossiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_propriete` int(11) DEFAULT NULL,
  `id_etape` int(11) DEFAULT NULL,
  `num_dossier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_affaire` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_repertoire` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_dossier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nature_doperation` int(11) DEFAULT NULL,
  `hypotheque` tinyint(4) NOT NULL DEFAULT 0,
  `mainlevee` tinyint(4) NOT NULL DEFAULT 0,
  `credit` tinyint(4) NOT NULL DEFAULT 0,
  `qfiscale` tinyint(4) NOT NULL DEFAULT 0,
  `nom_banque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tva` double(8,2) DEFAULT NULL,
  `montant_global_acte` double(8,2) DEFAULT NULL,
  `montant_quittance_partielle` double(8,2) DEFAULT NULL,
  `montant_vue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `montant_nonvue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_compt` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.dossiers : ~6 rows (environ)
INSERT INTO `dossiers` (`id`, `id_propriete`, `id_etape`, `num_dossier`, `num_affaire`, `num_repertoire`, `date_dossier`, `nature_doperation`, `hypotheque`, `mainlevee`, `credit`, `qfiscale`, `nom_banque`, `tva`, `montant_global_acte`, `montant_quittance_partielle`, `montant_vue`, `montant_nonvue`, `remarque`, `deleted_at`, `created_at`, `updated_at`, `id_compt`) VALUES
	(1, 17, NULL, '0000', '0202', '111', '2021-02-06', 1, 0, 0, 0, 0, NULL, 123.00, 23021.00, 122.00, '221', '1414141', NULL, '2021-02-17 15:30:56', '2021-02-06 10:59:36', '2021-02-17 15:30:56', NULL),
	(2, 17, NULL, '132', '02', '123', '2021-02-06', 1, 0, 1, 0, 0, NULL, 123.00, 123.00, 122.00, '221', '1414141', NULL, '2021-02-17 15:31:00', '2021-02-06 11:59:13', '2021-02-17 15:31:00', NULL),
	(3, 17, NULL, '123', '202', '123', '2021-02-09', 1, 0, 0, 0, 0, NULL, 123.00, 999999.99, 999999.99, '80000', '200', NULL, '2021-02-17 15:31:04', '2021-02-09 22:02:45', '2021-02-17 15:31:04', NULL),
	(4, 20, NULL, 'test', '12312', '123', '2021-02-18', 1, 0, 0, 0, 0, NULL, 121321.00, 123.00, 14141.00, '221', '1414141', NULL, NULL, '2021-02-17 15:35:26', '2021-02-17 15:35:26', NULL),
	(5, 23, NULL, 'qq123321', '12312', 'sss', '2021-02-19', 1, 0, 0, 0, 0, NULL, 14141.00, 14141.00, 122.00, '123', '1414141', NULL, NULL, '2021-02-19 09:28:44', '2021-02-19 09:28:44', NULL),
	(6, 23, 1, '1414', '34', '434', '2021-03-18', 13, 0, 0, 1, 0, NULL, NULL, 434.00, 343.00, '343', '343', NULL, NULL, '2021-03-18 17:11:27', '2021-03-18 17:11:27', NULL);

-- Listage de la structure de la table notaires. etapes
CREATE TABLE IF NOT EXISTS `etapes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.etapes : ~4 rows (environ)
INSERT INTO `etapes` (`id`, `nom`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'test123', NULL, '2021-03-06 12:02:32', '2021-03-08 16:23:53'),
	(2, 'test1', NULL, '2021-03-08 15:50:27', '2021-03-08 15:50:27'),
	(3, '123', '2021-03-08 16:33:47', '2021-03-08 15:52:13', '2021-03-08 16:33:47'),
	(4, NULL, '2021-03-08 16:39:14', '2021-03-08 16:39:03', '2021-03-08 16:39:14');

-- Listage de la structure de la table notaires. factures
CREATE TABLE IF NOT EXISTS `factures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_devis` int(11) DEFAULT NULL,
  `num_facture` int(11) DEFAULT NULL,
  `date_facture` date DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.factures : ~1 rows (environ)
INSERT INTO `factures` (`id`, `id_devis`, `num_facture`, `date_facture`, `remarque`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 1, 1231, '2021-03-05', NULL, NULL, '2021-03-05 14:09:17', '2021-03-05 14:09:17');

-- Listage de la structure de la table notaires. fichiers
CREATE TABLE IF NOT EXISTS `fichiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_typefichier` int(11) DEFAULT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_dossier` int(11) DEFAULT NULL,
  `id_client` int(11) DEFAULT NULL,
  `id_charge` int(11) DEFAULT NULL,
  `id_proprite` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.fichiers : ~4 rows (environ)
INSERT INTO `fichiers` (`id`, `id_typefichier`, `file`, `file_name`, `id_dossier`, `id_client`, `id_charge`, `id_proprite`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(34, 1, '602e22e478a28edit.svg', 'edit.svg', NULL, NULL, NULL, 23, NULL, '2021-02-18 08:18:44', '2021-02-18 08:18:44'),
	(35, 1, '602e22e479bd0delete (2).svg', 'delete (2).svg', NULL, NULL, NULL, 23, NULL, '2021-02-18 08:18:44', '2021-02-18 08:18:44'),
	(36, 1, '602e22e47aa12delete (1).svg', 'delete (1).svg', NULL, NULL, NULL, 23, NULL, '2021-02-18 08:18:44', '2021-02-18 08:18:44'),
	(37, 7, 'dossier-joints-14148641616087487.reg', 'FLRegKey.reg', 6, NULL, NULL, NULL, NULL, '2021-03-18 17:11:27', '2021-03-18 17:11:27');

-- Listage de la structure de la table notaires. migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.migrations : ~24 rows (environ)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(45, '2014_10_12_000000_create_users_table', 1),
	(46, '2014_10_12_100000_create_password_resets_table', 1),
	(47, '2020_03_31_091522_create_admins_table', 1),
	(48, '2020_12_15_214126_create_proprietes_table', 1),
	(49, '2020_12_16_132617_create_cat_proprietes_table', 1),
	(50, '2020_12_16_135805_create_conservation_foncieres_table', 1),
	(51, '2020_12_20_162349_create_dossiers_table', 1),
	(52, '2020_12_20_170311_create_nature_operations_table', 1),
	(53, '2020_12_23_135311_create_fichiers_table', 1),
	(54, '2020_12_23_141055_create_type_fichier_table', 1),
	(55, '2020_12_24_094015_create_reglements_table', 1),
	(56, '2020_12_24_094654_create_proprietaires_table', 1),
	(57, '2020_12_29_142811_create_comptes_table', 1),
	(58, '2020_12_29_143921_create_etapes_table', 1),
	(59, '2020_12_29_163233_create_acheteurs_table', 1),
	(60, '2020_12_30_082035_create_vendeurs_table', 1),
	(61, '2021_01_30_105856_create_produits_table', 1),
	(62, '2021_01_30_125216_create_charges_table', 1),
	(63, '2021_02_02_185630_create_devis_table', 1),
	(64, '2021_02_02_185651_create_detail_devis_table', 1),
	(65, '2021_02_04_143336_create_user_reglements_table', 1),
	(66, '2021_02_06_114231_create_factures_table', 1),
	(67, '2021_03_12_154638_create_role_preiorites_table', 2),
	(68, '2021_03_13_105820_create_roles_table', 2);

-- Listage de la structure de la table notaires. nature_operations
CREATE TABLE IF NOT EXISTS `nature_operations` (
  `id_operation` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nature_doperation` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_operation`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.nature_operations : ~13 rows (environ)
INSERT INTO `nature_operations` (`id_operation`, `nature_doperation`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'naturessss2', '2021-03-06 10:27:58', '2021-02-17 10:50:19', '2021-03-06 10:27:58'),
	(2, 'nature2123241', '2021-03-05 14:40:43', '2021-03-05 14:40:25', '2021-03-05 14:40:43'),
	(3, 'nature2123241', '2021-03-05 16:44:25', '2021-03-05 14:40:54', '2021-03-05 16:44:25'),
	(4, 'nature2123', '2021-03-05 14:41:10', '2021-03-05 14:41:05', '2021-03-05 14:41:10'),
	(5, 'nature2123241', '2021-03-05 16:44:18', '2021-03-05 16:24:09', '2021-03-05 16:44:18'),
	(6, 'naturessss', '2021-03-06 10:04:21', '2021-03-06 08:31:58', '2021-03-06 10:04:21'),
	(7, 'sss', '2021-03-06 09:59:49', '2021-03-06 09:36:25', '2021-03-06 09:59:49'),
	(8, 'sss', '2021-03-06 10:00:51', '2021-03-06 09:37:17', '2021-03-06 10:00:51'),
	(9, 'naturessxx', '2021-03-06 10:04:16', '2021-03-06 09:38:28', '2021-03-06 10:04:16'),
	(10, 'naturessss2', '2021-03-06 10:23:04', '2021-03-06 10:10:21', '2021-03-06 10:23:04'),
	(11, 'nature', '2021-03-06 11:03:45', '2021-03-06 10:28:04', '2021-03-06 11:03:45'),
	(12, 'nature2123241', '2021-03-08 13:46:56', '2021-03-08 13:46:52', '2021-03-08 13:46:56'),
	(13, '123', NULL, '2021-03-08 13:47:03', '2021-03-08 13:47:03');

-- Listage de la structure de la table notaires. produits
CREATE TABLE IF NOT EXISTS `produits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remise` int(11) DEFAULT NULL,
  `prix` double DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.produits : ~2 rows (environ)
INSERT INTO `produits` (`id`, `designation`, `remise`, `prix`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'test', 10, 1000, NULL, '2021-03-05 15:04:35', '2021-03-05 15:04:35'),
	(2, 'test', 2, 0, NULL, '2021-03-08 09:19:04', '2021-03-08 09:19:04');

-- Listage de la structure de la table notaires. proprietaires
CREATE TABLE IF NOT EXISTS `proprietaires` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_cli` int(11) NOT NULL,
  `id_propriete` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.proprietaires : ~0 rows (environ)

-- Listage de la structure de la table notaires. proprietes
CREATE TABLE IF NOT EXISTS `proprietes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `categorie` int(11) NOT NULL,
  `denomination` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titreFoncier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conservationFonciere` int(11) DEFAULT NULL,
  `originePropriete` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `super` double(8,2) NOT NULL DEFAULT 0.00,
  `unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ville` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.proprietes : ~24 rows (environ)
INSERT INTO `proprietes` (`id`, `categorie`, `denomination`, `titreFoncier`, `conservationFonciere`, `originePropriete`, `adr`, `super`, `unit`, `complement`, `ville`, `desc`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 1, 'test 1', '12355613', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 444.00, 'mètre carré', 'test', 'casablanca', 'desc test1', '2021-02-17 13:51:59', '2021-02-06 10:56:08', '2021-02-17 13:51:59'),
	(2, 1, 'test 3', '12151', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 444.00, 'mètre carré', 'test', 'casablanca', 'desc test 2', '2021-02-06 10:57:46', '2021-02-06 10:56:11', '2021-02-06 10:57:46'),
	(3, 1, 'YHconsulting', '00000', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 22.00, 'mètre carré', 'test', 'casablanca', 'desc test 3', '2021-02-06 10:57:39', '2021-02-06 10:57:23', '2021-02-06 10:57:39'),
	(4, 1, 'YHconsulting', '1414', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 14144.00, 'mètre carré', '14414', 'casablanca', NULL, '2021-02-17 13:52:05', '2021-02-17 11:41:20', '2021-02-17 13:52:05'),
	(5, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1232.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 13:52:10', '2021-02-17 13:27:56', '2021-02-17 13:52:10'),
	(6, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 13213.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 13:52:16', '2021-02-17 13:30:33', '2021-02-17 13:52:16'),
	(7, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 13213.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 13:52:26', '2021-02-17 13:31:07', '2021-02-17 13:52:26'),
	(8, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1213.00, 'mètre carré', '3121', 'casablanca', NULL, '2021-02-17 13:52:31', '2021-02-17 13:37:43', '2021-02-17 13:52:31'),
	(9, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1231.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 13:52:37', '2021-02-17 13:39:40', '2021-02-17 13:52:37'),
	(10, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 13212.00, 'mètre carré', '321231', 'casablanca', NULL, '2021-02-17 13:51:54', '2021-02-17 13:45:09', '2021-02-17 13:51:54'),
	(11, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 321.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 13:51:46', '2021-02-17 13:47:47', '2021-02-17 13:51:46'),
	(12, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1000.00, 'hectare', 'test', 'casablanca', NULL, '2021-02-17 14:02:58', '2021-02-17 13:57:22', '2021-02-17 14:02:58'),
	(13, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1000.00, 'hectare', 'test', 'casablanca', NULL, '2021-02-17 14:02:53', '2021-02-17 13:57:24', '2021-02-17 14:02:53'),
	(14, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 13213.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 14:02:49', '2021-02-17 13:59:30', '2021-02-17 14:02:49'),
	(15, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 13213.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 14:02:44', '2021-02-17 14:00:25', '2021-02-17 14:02:44'),
	(16, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 12312.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 14:02:39', '2021-02-17 14:01:23', '2021-02-17 14:02:39'),
	(17, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 100.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 15:29:23', '2021-02-17 14:04:43', '2021-02-17 15:29:23'),
	(18, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 100.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 15:29:17', '2021-02-17 14:05:13', '2021-02-17 15:29:17'),
	(19, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1321.00, 'mètre carré', 'test', 'casablanca', NULL, '2021-02-17 15:29:12', '2021-02-17 15:26:50', '2021-02-17 15:29:12'),
	(20, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 132132.00, 'mètre carré', 'test', 'casablanca', 'desc test 1', NULL, '2021-02-17 15:33:31', '2021-02-17 15:33:31'),
	(21, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 12312.00, 'mètre carré', 'test', 'casablanca', 'desc test 2', NULL, '2021-02-17 16:25:03', '2021-02-17 16:25:03'),
	(22, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1231.00, 'mètre carré', 'test', 'casablanca', 'desc test 4', NULL, '2021-02-18 08:18:09', '2021-02-18 08:18:09'),
	(23, 1, 'YHconsulting', 'test', 1, 'defailt.png', 'hay el oroude villa des roses nr 63', 1231.00, 'mètre carré', 'test', 'casablanca', 'desc test 5', NULL, '2021-02-18 08:18:44', '2021-03-05 10:43:59'),
	(24, 35, 'YHconsulting', '123', 6, 'defailt.png', 'hay el oroude villa des roses nr 63', 21321.00, 'mètre carré', 'jj', 'casablanca', NULL, NULL, '2021-03-22 13:00:59', '2021-03-22 13:00:59');

-- Listage de la structure de la table notaires. reglements
CREATE TABLE IF NOT EXISTS `reglements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mode_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reg` double DEFAULT NULL,
  `cheque_effect_n` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_dos` int(11) DEFAULT NULL,
  `num_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_echeance` date DEFAULT NULL,
  `valid` tinyint(4) NOT NULL DEFAULT 0,
  `id_compt` int(11) DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.reglements : ~17 rows (environ)
INSERT INTO `reglements` (`id`, `mode_reg`, `type_reg`, `reg`, `cheque_effect_n`, `id_dos`, `num_reg`, `date_echeance`, `valid`, `id_compt`, `remarque`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(28, 'Espèces', 'Partial', 231321, NULL, 5, NULL, '2021-02-19', 0, 1, NULL, NULL, '2021-02-19 09:29:04', '2021-02-19 09:29:04'),
	(30, 'Espèces', 'Partial', 12310, NULL, 5, NULL, '2021-02-19', 1, 1, NULL, '2021-03-18 12:14:40', '2021-02-19 11:11:11', '2021-03-18 12:14:40'),
	(31, 'Espèces', 'Partial', 13213, NULL, 5, NULL, '2021-02-19', 1, 1, NULL, '2021-03-18 12:14:44', '2021-02-19 15:14:14', '2021-03-18 12:14:44'),
	(32, 'Espèces', 'Partial', 12313, NULL, 4, NULL, '2021-02-19', 1, 1, NULL, '2021-03-18 12:14:36', '2021-02-19 15:15:09', '2021-03-18 12:14:36'),
	(33, 'Cheque', 'Solder', 123132, NULL, 4, '12312', '2021-02-19', 1, 1, NULL, '2021-03-18 12:14:48', '2021-02-19 15:26:13', '2021-03-18 12:14:48'),
	(34, 'Espèces', 'Partial', 1414, NULL, 5, NULL, '2021-03-05', 0, 1, NULL, '2021-03-18 12:14:08', '2021-03-05 08:39:29', '2021-03-18 12:14:08'),
	(35, 'Espèces', 'Partial', 14141, NULL, 5, NULL, '2021-03-18', 1, 14, NULL, NULL, '2021-03-18 13:29:20', '2021-03-18 14:02:52'),
	(36, 'Espèces', 'Partial', 123132, NULL, 5, NULL, '2021-03-18', 0, 14, NULL, NULL, '2021-03-18 15:56:23', '2021-03-18 15:56:23'),
	(37, 'Espèces', 'Partial', 123, NULL, 5, NULL, '2021-03-18', 0, 23, NULL, NULL, '2021-03-18 16:25:40', '2021-03-18 16:25:40'),
	(38, 'Espèces', 'Partial', 123, NULL, 5, NULL, '2021-03-18', 0, 16, NULL, NULL, '2021-03-18 16:25:58', '2021-03-19 10:24:01'),
	(39, 'Espèces', 'Partial', 123, NULL, 5, NULL, '2021-03-18', 0, 24, NULL, NULL, '2021-03-18 16:26:14', '2021-03-19 10:02:24'),
	(40, 'Espèces', 'Partial', 14141, NULL, 6, NULL, '2021-03-18', 0, 14, NULL, '2021-03-19 10:05:30', '2021-03-18 17:14:01', '2021-03-19 10:05:30'),
	(41, 'Espèces', 'Partial', 1213, NULL, 6, NULL, '2021-03-19', 0, 16, NULL, '2021-03-19 09:59:17', '2021-03-19 08:23:12', '2021-03-19 09:59:17'),
	(42, 'Espèces', 'Partial', 1231321, NULL, 5, NULL, '2021-03-19', 0, 24, NULL, '2021-03-19 09:59:12', '2021-03-19 09:39:40', '2021-03-19 09:59:12'),
	(43, 'Espèces', 'Partial', 31213, NULL, 5, NULL, '2021-03-19', 0, 23, NULL, '2021-03-19 10:05:23', '2021-03-19 10:05:17', '2021-03-19 10:05:23'),
	(44, 'Espèces', 'Partial', 2113213, NULL, 5, NULL, '2021-03-19', 0, 23, NULL, '2021-03-19 10:05:58', '2021-03-19 10:05:48', '2021-03-19 10:05:58'),
	(45, 'Espèces', 'Partial', 21321, NULL, 5, NULL, '2021-03-19', 0, 14, NULL, NULL, '2021-03-19 10:06:15', '2021-03-19 10:24:16');

-- Listage de la structure de la table notaires. roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `desc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.roles : ~0 rows (environ)

-- Listage de la structure de la table notaires. role_preiorites
CREATE TABLE IF NOT EXISTS `role_preiorites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `addclient` int(11) NOT NULL DEFAULT 0,
  `seeclient` int(11) NOT NULL DEFAULT 0,
  `addpropr` int(11) NOT NULL DEFAULT 0,
  `seepropr` int(11) NOT NULL DEFAULT 0,
  `adddossier` int(11) NOT NULL DEFAULT 0,
  `seedossier` int(11) NOT NULL DEFAULT 0,
  `addcharge` int(11) NOT NULL DEFAULT 0,
  `seecharge` int(11) NOT NULL DEFAULT 0,
  `addregl` int(11) NOT NULL DEFAULT 0,
  `seeregl` int(11) NOT NULL DEFAULT 0,
  `addprod` int(11) NOT NULL DEFAULT 0,
  `seeprod` int(11) NOT NULL DEFAULT 0,
  `adddevis` int(11) NOT NULL DEFAULT 0,
  `seedevis` int(11) NOT NULL DEFAULT 0,
  `addfacture` int(11) NOT NULL DEFAULT 0,
  `seefacture` int(11) NOT NULL DEFAULT 0,
  `parameter` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.role_preiorites : ~2 rows (environ)
INSERT INTO `role_preiorites` (`id`, `id_user`, `addclient`, `seeclient`, `addpropr`, `seepropr`, `adddossier`, `seedossier`, `addcharge`, `seecharge`, `addregl`, `seeregl`, `addprod`, `seeprod`, `adddevis`, `seedevis`, `addfacture`, `seefacture`, `parameter`, `created_at`, `updated_at`, `role`) VALUES
	(8, 25, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2021-03-20 12:37:08', '2021-03-22 15:08:45', 1),
	(9, 26, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 0, 0, '2021-03-20 11:41:54', '2021-03-20 11:41:54', 3);

-- Listage de la structure de la table notaires. type_fichier
CREATE TABLE IF NOT EXISTS `type_fichier` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.type_fichier : ~7 rows (environ)
INSERT INTO `type_fichier` (`id`, `nom`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'type 1', '2021-03-12 11:07:14', NULL, '2021-03-12 11:07:14'),
	(2, 'type2x', '2021-03-12 11:05:14', '2021-03-08 17:06:59', '2021-03-12 11:05:14'),
	(3, 'type3', '2021-03-12 11:07:09', '2021-03-12 10:26:34', '2021-03-12 11:07:09'),
	(4, 'type 12', '2021-03-12 11:05:37', '2021-03-12 10:51:50', '2021-03-12 11:05:37'),
	(5, 'type', '2021-03-12 11:08:14', '2021-03-12 11:07:19', '2021-03-12 11:08:14'),
	(6, 'types', '2021-03-12 11:07:31', '2021-03-12 11:07:26', '2021-03-12 11:07:31'),
	(7, 'types', NULL, '2021-03-12 11:08:20', '2021-03-12 11:08:28');

-- Listage de la structure de la table notaires. user_reglements
CREATE TABLE IF NOT EXISTS `user_reglements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_acheteur` int(11) DEFAULT NULL,
  `id_vendeur` int(11) DEFAULT NULL,
  `id_reg` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.user_reglements : ~19 rows (environ)
INSERT INTO `user_reglements` (`id`, `id_acheteur`, `id_vendeur`, `id_reg`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(24, 4, NULL, 27, '2021-02-19 11:54:44', '2021-02-19 09:16:38', '2021-02-19 09:16:38'),
	(25, 4, NULL, 28, '2021-02-19 11:54:39', '2021-02-19 09:29:05', '2021-02-19 09:29:05'),
	(26, 4, NULL, 29, '2021-02-19 10:54:55', '2021-02-19 09:58:37', '2021-02-19 10:54:55'),
	(27, 4, NULL, 30, '2021-03-18 12:14:40', '2021-02-19 11:11:11', '2021-03-18 12:14:40'),
	(28, 4, NULL, 31, '2021-03-18 12:14:44', '2021-02-19 15:14:14', '2021-03-18 12:14:44'),
	(29, NULL, 2, 32, '2021-03-18 12:14:36', '2021-02-19 15:15:10', '2021-03-18 12:14:36'),
	(30, 4, NULL, 33, '2021-03-18 12:14:48', '2021-02-19 15:26:14', '2021-03-18 12:14:48'),
	(31, 5, NULL, 34, '2021-03-18 12:14:08', '2021-03-05 08:39:29', '2021-03-18 12:14:08'),
	(32, 2, NULL, 35, NULL, '2021-03-18 13:29:20', '2021-03-18 13:29:20'),
	(33, 2, NULL, 36, NULL, '2021-03-18 15:56:23', '2021-03-18 15:56:23'),
	(34, 2, NULL, 37, NULL, '2021-03-18 16:25:40', '2021-03-18 16:25:40'),
	(35, 2, NULL, 38, NULL, '2021-03-18 16:25:58', '2021-03-18 16:25:58'),
	(36, NULL, 4, 39, NULL, '2021-03-18 16:26:14', '2021-03-18 16:26:14'),
	(37, 5, NULL, 40, '2021-03-19 10:05:30', '2021-03-18 17:14:01', '2021-03-19 10:05:30'),
	(38, 5, NULL, 41, '2021-03-19 09:59:17', '2021-03-19 08:23:12', '2021-03-19 09:59:17'),
	(39, 1, NULL, 42, '2021-03-19 09:59:12', '2021-03-19 09:39:40', '2021-03-19 09:59:12'),
	(40, 2, NULL, 43, '2021-03-19 10:05:23', '2021-03-19 10:05:17', '2021-03-19 10:05:23'),
	(41, 2, NULL, 44, '2021-03-19 10:05:58', '2021-03-19 10:05:48', '2021-03-19 10:05:58'),
	(42, NULL, 4, 45, NULL, '2021-03-19 10:06:15', '2021-03-19 10:06:15');

-- Listage de la structure de la table notaires. vendeurs
CREATE TABLE IF NOT EXISTS `vendeurs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_client` int(11) DEFAULT NULL,
  `id_dossier` int(11) DEFAULT NULL,
  `signe` int(11) NOT NULL DEFAULT 0,
  `date_signe` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.vendeurs : ~7 rows (environ)
INSERT INTO `vendeurs` (`id`, `id_client`, `id_dossier`, `signe`, `date_signe`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(11, 4, 3, 0, '2021-02-11', NULL, '2021-02-11 15:16:39', '2021-02-11 15:16:39'),
	(12, 3, 3, 0, '2021-02-11', NULL, '2021-02-11 15:19:13', '2021-02-11 15:19:13'),
	(13, 2, 4, 0, NULL, NULL, '2021-02-17 15:35:26', '2021-02-17 15:35:26'),
	(14, 1, 4, 0, NULL, NULL, '2021-02-17 15:35:26', '2021-02-17 15:35:26'),
	(15, 4, 5, 0, NULL, NULL, '2021-02-19 09:28:44', '2021-02-19 09:28:44'),
	(16, 3, 5, 0, NULL, NULL, '2021-02-19 09:28:44', '2021-02-19 09:28:44'),
	(17, 4, 6, 0, NULL, NULL, '2021-03-18 17:11:27', '2021-03-18 17:11:27');

