-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Hôte : localhost:3306 -- Généré le : mer. 01 mai 2024 à 02:25 -- Version du serveur : 10.6.17-MariaDB -- Version de PHP : 8.1.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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 utf8mb4 */; -- -- Base de données : `speedma1_newS2` -- -- -------------------------------------------------------- -- -- Structure de la table `all_contributions` -- CREATE TABLE `all_contributions` ( `id_all` int(11) NOT NULL, `id_contribution` int(11) NOT NULL, `nme_contribution` varchar(30) NOT NULL, `id_member` int(11) NOT NULL, `id_employe` int(11) NOT NULL, `loanmonth_c` varchar(30) NOT NULL DEFAULT '0', `interest_c` varchar(30) NOT NULL DEFAULT '0', `totalloan_c` varchar(30) NOT NULL DEFAULT '0', `arrears` int(30) NOT NULL, `date_all` varchar(30) NOT NULL, `date_enre` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `all_contributions` -- INSERT INTO `all_contributions` (`id_all`, `id_contribution`, `nme_contribution`, `id_member`, `id_employe`, `loanmonth_c`, `interest_c`, `totalloan_c`, `arrears`, `date_all`, `date_enre`) VALUES (5, 1, ' T7T95WBZZL', 9, 5, '0', '0', '0', 0, '', '2024-03-22'), (7, 1, ' IDLXACQLXD', 4, 2, '8333.3333333333', '1.5', '93087', 0, '', '2024-03-23'), (8, 1, ' ZM3QB6QN06', 7, 2, '0', '0', '0', 0, '', '2024-03-23'), (9, 1, ' X0Z15L4E05', 10, 2, '0', '0', '0', 0, '', '2024-03-23'), (10, 1, ' 6QXVDAC5H6', 11, 2, '0', '0', '0', 0, '', '2024-03-23'), (11, 1, ' CJN7AV68HA', 12, 2, '0', '0', '0', 0, '', '2024-03-23'), (12, 1, ' 37LYHQ2GRZ', 8, 2, '0', '0', '0', 0, '', '2024-03-23'), (13, 1, ' UQJWJPPLT7', 3, 0, '0', '0', '0', 0, '', '2024-04-20'); -- -------------------------------------------------------- -- -- Structure de la table `associations` -- CREATE TABLE `associations` ( `id_association` int(11) NOT NULL, `nom_association` varchar(100) NOT NULL, `state_association` varchar(30) NOT NULL DEFAULT 'ACTIVE', `date_association` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `associations` -- INSERT INTO `associations` (`id_association`, `nom_association`, `state_association`, `date_association`) VALUES (1, 'EBHSA', 'ACTIVE', '2024-03-07'), (3, 'True Friends', 'ACTIVE', '2024-03-07'); -- -------------------------------------------------------- -- -- Structure de la table `banks` -- CREATE TABLE `banks` ( `id_bank` int(11) NOT NULL, `id_employe` int(11) NOT NULL, `nom_bank` varchar(200) NOT NULL, `date_bank` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `banks` -- INSERT INTO `banks` (`id_bank`, `id_employe`, `nom_bank`, `date_bank`) VALUES (2, 2, 'Mpesa', '2024-03-13'), (3, 2, 'Mwikure Sacco', '2024-03-13'), (5, 2, 'Bingwa sacco', '2024-03-16'); -- -------------------------------------------------------- -- -- Structure de la table `bank_shift` -- CREATE TABLE `bank_shift` ( `id_bs` int(11) NOT NULL, `insurance_bs` varchar(30) NOT NULL, `share_bs` int(30) NOT NULL, `interest_bs` varchar(30) NOT NULL, `regfee_bs` int(30) NOT NULL, `loanrep_bs` int(30) NOT NULL, `arrears_bs` int(30) NOT NULL, `id_membre` int(11) NOT NULL, `id_employe` int(11) NOT NULL, `month_bs` varchar(30) NOT NULL, `year_bs` int(10) NOT NULL, `date_bs` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `bank_shift` -- INSERT INTO `bank_shift` (`id_bs`, `insurance_bs`, `share_bs`, `interest_bs`, `regfee_bs`, `loanrep_bs`, `arrears_bs`, `id_membre`, `id_employe`, `month_bs`, `year_bs`, `date_bs`) VALUES (63, '200', 15000, '0', 50, 0, 0, 3, 5, 'March', 2024, '2024-03-30'), (64, '150', 5000, '1500', 50, 8463, 0, 4, 5, 'March', 2024, '2024-03-30'), (65, '150', 6000, '0', 50, 0, 0, 7, 5, 'March', 2024, '2024-03-30'), (66, '500', 3000, '0', 50, 0, 0, 10, 5, 'March', 2024, '2024-03-30'), (67, '150', 15000, '0', 50, 0, 0, 11, 5, 'March', 2024, '2024-03-30'), (68, '200', 8000, '0', 50, 0, 0, 12, 5, 'March', 2024, '2024-03-30'), (69, '250', 6000, '0', 150, 0, 0, 8, 5, 'March', 2024, '2024-03-30'), (70, '50', 1000, '0', 200, 0, 0, 9, 5, 'March', 2024, '2024-03-30'); -- -------------------------------------------------------- -- -- Structure de la table `beneficiaries` -- CREATE TABLE `beneficiaries` ( `id_ben` int(11) NOT NULL, `id_member` int(11) NOT NULL, `id_relationship` int(30) NOT NULL, `nom_ben` varchar(100) NOT NULL, `username_ben` varchar(70) NOT NULL, `phone_ben` varchar(30) NOT NULL, `share_ben` int(5) NOT NULL, `id_nme_ben` varchar(30) NOT NULL, `state_ben` varchar(30) NOT NULL DEFAULT 'ACTIVE', `email_ben` varchar(100) NOT NULL, `password_ben` varchar(80) NOT NULL, `date_ben` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `beneficiaries` -- INSERT INTO `beneficiaries` (`id_ben`, `id_member`, `id_relationship`, `nom_ben`, `username_ben`, `phone_ben`, `share_ben`, `id_nme_ben`, `state_ben`, `email_ben`, `password_ben`, `date_ben`) VALUES (1, 3, 1, 'ISHIMWE Sykar', 'Skylar', '71617532', 70, '58964', 'ACTIVE', 'skylar@gmail.com', 'a57e1b863aad5a6ae24d32d1400e2c6b', '2024-03-08'), (2, 8, 3, 'Lili', 'lili', '57373838', 56, '63736383', 'ACTIVE', 'lili@gmail.com', '7e37f3bec527ab24ed02d92d3addc4bb', '2024-03-16'), (3, 9, 1, 'GHNQNS', 'GIB', '02Y38U29', 50, '1236', 'ACTIVE', 'QWRG', '25df35de87aa441b88f22a6c2a830a17', '2024-03-20'), (4, 3, 3, 'ISHIMWE Sykar', 'exe', '+2577214577112', 30, '5896465', 'ACTIVE', 'skylar2@gmail.com', '42f60e735d6bb474387b289659b512e5', '2024-03-22'); -- -------------------------------------------------------- -- -- Structure de la table `bsb` -- CREATE TABLE `bsb` ( `phone_membre` int(11) NOT NULL, `Id_nme_membre` varchar(200) NOT NULL, `name_membre` varchar(100) NOT NULL, `username_membre` int(30) NOT NULL, `id_employe` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `bsb` -- INSERT INTO `bsb` (`phone_membre`, `Id_nme_membre`, `name_membre`, `username_membre`, `id_employe`) VALUES (27985079, '27985079', 'Agnes Kyalo', 27985079, 2), (25258141, '25258141', 'Ann Muraya', 25258141, 2), (23549236, '23549236', 'Anthony Kariuki', 23549236, 2), (30881353, '30881353', 'Caroline Wanja', 30881353, 2), (9322889, '9322889', 'Daniel M. Kanyi', 9322889, 2), (13249524, '13249524', 'Esther John', 13249524, 2), (36463169, '36463169', 'Ian Gichora', 36463169, 2), (24365369, '24365369', 'Ibrahim Ombati', 24365369, 2), (24422027, '24422027', 'Jacob Egesa', 24422027, 2), (23534948, '23534948', 'James Kariuki', 23534948, 2), (31289801, '31289801', 'Janet KIrimi', 31289801, 2), (11607241, '11607241', 'Andrew Muthomi Kirimi', 11607241, 2), (23990591, '23990591', 'Lizbeth Gatwiri', 23990591, 2), (8979249, '8979249', 'Lucy Karonji', 8979249, 2), (24607514, '24607514', 'Nicholas Nyakundi', 24607514, 2), (23576121, '23576121', 'Noah Langat', 23576121, 2), (23379432, '23379432', 'Pauline Muriuki', 23379432, 2), (28248771, '28248771', 'Purity Kirere', 28248771, 2), (13452461, '13452461', 'Regina Karonji', 13452461, 2); -- -------------------------------------------------------- -- -- Structure de la table `contributions` -- CREATE TABLE `contributions` ( `id_contribution` int(11) NOT NULL, `nme_fee` varchar(30) NOT NULL, `id_employe` int(11) NOT NULL, `project_fee` int(30) NOT NULL, `saving_fee` int(30) NOT NULL, `share_fee` int(30) NOT NULL, `registration_fee` int(30) NOT NULL, `welfare_fee` int(30) NOT NULL, `month_fee` varchar(30) NOT NULL, `year_fee` int(30) NOT NULL, `date_save_fee` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `contributions` -- INSERT INTO `contributions` (`id_contribution`, `nme_fee`, `id_employe`, `project_fee`, `saving_fee`, `share_fee`, `registration_fee`, `welfare_fee`, `month_fee`, `year_fee`, `date_save_fee`) VALUES (7, ' LJBAZ8GNPL', 2, 50000, 12000, 15000, 1000, 15000, 'March', 2024, '2024-04-25'), (9, ' JTMR1Q8IEY', 2, 18000, 18000, 18000, 1800, 18000, 'May', 2024, '2024-04-27'), (10, ' O2309I5142', 2, 15000, 15000, 15000, 1500, 15000, 'April', 2024, '2024-04-27'), (11, ' 697I22LQ98', 2, 25000, 25000, 25000, 25000, 25000, 'June', 2024, '2024-04-29'); -- -------------------------------------------------------- -- -- Structure de la table `employes` -- CREATE TABLE `employes` ( `id_employe` int(11) NOT NULL, `id_association` int(11) NOT NULL, `email_employe` varchar(100) NOT NULL, `full_name` varchar(100) NOT NULL, `employeuserName` varchar(70) NOT NULL, `tel_employe` varchar(30) NOT NULL, `state_employe` varchar(30) NOT NULL DEFAULT 'ACTIVE', `password_employe` varchar(80) NOT NULL, `date_employe` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `employes` -- INSERT INTO `employes` (`id_employe`, `id_association`, `email_employe`, `full_name`, `employeuserName`, `tel_employe`, `state_employe`, `password_employe`, `date_employe`) VALUES (2, 1, 'joselyne@gmail.com', 'IRAKOZE Joselyne', 'jose', '9876543210', 'ACTIVE', 'e388c1c5df4933fa01f6da9f92595589', '2024-03-08'), (3, 1, 'IbrahimOmbati@gmail.com', 'Ibrahim Ombati', 'Ibrahim', '77889966', 'ACTIVE', '71f22cde790e93efe5d7cb77bbc8eae1', '2024-03-09'), (4, 1, 'EstherJohn@gmail.com', 'Esther John', 'Esther', '0704201905', 'ACTIVE', '2b1d226f59ef0b094ccb49ba1b095394', '2024-03-15'), (6, 1, 'iangichora07@gmail.com', 'Ian Gichora', 'ian', '555555', 'ACTIVE', '5b1b68a9abf4d2cd155c81a9225fd158', '2024-04-22'); -- -------------------------------------------------------- -- -- Structure de la table `excel_data` -- CREATE TABLE `excel_data` ( `id` int(11) NOT NULL, `name` int(11) NOT NULL, `email` int(11) NOT NULL, `phone` int(11) NOT NULL, `city` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Structure de la table `loans` -- CREATE TABLE `loans` ( `id_loan` int(11) NOT NULL, `amount_loan` int(30) NOT NULL, `topup` int(30) NOT NULL, `form_fee` int(30) NOT NULL, `period` int(10) NOT NULL, `interest` varchar(11) NOT NULL, `interest_amount` varchar(30) NOT NULL, `total_loan` int(11) NOT NULL, `loan_month` int(30) NOT NULL, `month_debut` varchar(30) NOT NULL, `year_debut` int(10) NOT NULL, `month_fin` varchar(30) NOT NULL, `year_fin` int(10) NOT NULL, `state_loan` varchar(30) NOT NULL DEFAULT 'UNPAID', `date_asking` date NOT NULL DEFAULT current_timestamp(), `id_membre` int(11) NOT NULL, `id_employe` int(11) NOT NULL DEFAULT 0, `state_answer` varchar(30) DEFAULT NULL, `comment` text DEFAULT NULL, `account_nume` varchar(30) NOT NULL, `id_bank` int(11) NOT NULL, `loan_paid` int(30) NOT NULL DEFAULT 0, `date_answer` varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `loans` -- INSERT INTO `loans` (`id_loan`, `amount_loan`, `topup`, `form_fee`, `period`, `interest`, `interest_amount`, `total_loan`, `loan_month`, `month_debut`, `year_debut`, `month_fin`, `year_fin`, `state_loan`, `date_asking`, `id_membre`, `id_employe`, `state_answer`, `comment`, `account_nume`, `id_bank`, `loan_paid`, `date_answer`) VALUES (11, 15000, 0, 0, 3, '1.5', '225', 15225, 5075, 'April', 2024, 'July', 2024, 'UNPAID', '2024-04-19', 3, 2, 'Accepted', 'ok', '8459652', 2, 0, '2024-04-20'); -- -------------------------------------------------------- -- -- Structure de la table `membres` -- CREATE TABLE `membres` ( `id_membre` int(11) NOT NULL, `name_membre` varchar(90) NOT NULL, `username_membre` varchar(70) NOT NULL, `Id_nme_membre` varchar(30) NOT NULL, `phone_membre` varchar(30) NOT NULL, `email_membre` varchar(100) NOT NULL, `id_employe` int(11) NOT NULL, `state_membre` varchar(30) NOT NULL DEFAULT 'ACTIVE', `password_membre` varchar(80) NOT NULL, `date_membre` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `membres` -- INSERT INTO `membres` (`id_membre`, `name_membre`, `username_membre`, `Id_nme_membre`, `phone_membre`, `email_membre`, `id_employe`, `state_membre`, `password_membre`, `date_membre`) VALUES (3, 'Agnes kaari', '22897742', '22897742', '79376593', 'Agnes@gmail.com', 2, 'ACTIVE', 'd8947eedcd158f139dc3e3895ed7e463', '2024-03-08'), (51, 'Agnes Kyalo', '27985079', '27985079', '', '', 2, 'ACTIVE', 'a47f80d4c2bd1bc8da7c5aec69df66cd', '2024-04-29'), (52, 'Ann Muraya', '25258141', '25258141', '', '', 2, 'ACTIVE', '7b47564ae8157ebdaae9152123e8ab76', '2024-04-29'), (53, 'Anthony Kariuki', '23549236', '23549236', '', '', 2, 'ACTIVE', 'd0cf96214f8b2f42cc0f421e83409572', '2024-04-29'), (54, 'Caroline Wanja', '30881353', '30881353', '', '', 2, 'ACTIVE', 'b788d453fda617373f74e1c220909475', '2024-04-29'), (55, 'Daniel M. Kanyi', '9322889', '9322889', '', '', 2, 'ACTIVE', '2cb1ecc874e72584c474ca6af0042075', '2024-04-29'), (56, 'Esther John', '13249524', '13249524', '', '', 2, 'ACTIVE', '93cb9cadad2c6190e9082484cb922bb9', '2024-04-29'), (57, 'Ian Gichora', '36463169', '36463169', '', '', 2, 'ACTIVE', '941b273e74fe139b36ce4dd6e5ebcc0c', '2024-04-29'), (58, 'Ibrahim Ombati', '24365369', '24365369', '', '', 2, 'ACTIVE', '8de23f253bfc07e6548c3d2822d3eaeb', '2024-04-29'), (59, 'Jacob Egesa', '24422027', '24422027', '', '', 2, 'ACTIVE', 'e585ab58d9115b11e373a6e8b49dc47a', '2024-04-29'), (60, 'James Kariuki', '23534948', '23534948', '', '', 2, 'ACTIVE', '1305f0b62aafeadf4a15f4e2ec9ddb98', '2024-04-29'), (61, 'Janet KIrimi', '31289801', '31289801', '', '', 2, 'ACTIVE', '412f9266c1c50945b41fac8166785716', '2024-04-29'), (62, 'Andrew Muthomi Kirimi', '11607241', '11607241', '', '', 2, 'ACTIVE', '6820aeaccb212a0f63b8dc168935824f', '2024-04-29'), (63, 'Lizbeth Gatwiri', '23990591', '23990591', '', '', 2, 'ACTIVE', 'c8247cb30475b76ad36bd427ea28e404', '2024-04-29'), (64, 'Lucy Karonji', '8979249', '8979249', '', '', 2, 'ACTIVE', 'fe4c3c7ee302ec11ff67f1cd29e72197', '2024-04-29'), (65, 'Nicholas Nyakundi', '24607514', '24607514', '', '', 2, 'ACTIVE', '5cd6d749eae27968a9fabfd9bda28c17', '2024-04-29'), (66, 'Noah Langat', '23576121', '23576121', '', '', 2, 'ACTIVE', '28643271679b0687e4de41b8853fa8e6', '2024-04-29'), (67, 'Pauline Muriuki', '23379432', '23379432', '', '', 2, 'ACTIVE', '354967e1b2777796df4b376bc14cc64f', '2024-04-29'), (68, 'Purity Kirere', '28248771', '28248771', '', '', 2, 'ACTIVE', '66b46bdf6e0b2e9dfeaf0e7d6dc99111', '2024-04-29'), (69, 'Regina Karonji', '13452461', '13452461', '', '', 2, 'ACTIVE', '7c76c831ac056ba1ba84bbcd77a6e923', '2024-04-29'); -- -------------------------------------------------------- -- -- Structure de la table `news` -- CREATE TABLE `news` ( `nme` int(11) NOT NULL, `name` varchar(80) NOT NULL, `id_nme` int(11) NOT NULL, `amount` varchar(20) NOT NULL, `paid_amount` varchar(20) NOT NULL, `balance` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Structure de la table `period_interest` -- CREATE TABLE `period_interest` ( `id_per_in` int(11) NOT NULL, `period` int(10) NOT NULL, `interest` float NOT NULL, `nume_per_in` varchar(30) NOT NULL, `id_employe` int(11) NOT NULL, `date_per_in` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `period_interest` -- INSERT INTO `period_interest` (`id_per_in`, `period`, `interest`, `nume_per_in`, `id_employe`, `date_per_in`) VALUES (1, 6, 1.25, ' WMXPPEBLQB', 2, '2024-03-12'), (3, 3, 1.5, '4.5', 2, '2024-03-12'), (4, 9, 1.25, ' LHHTX5232T', 2, '2024-03-12'), (5, 1, 1.5, ' 23CJYBAFBN', 5, '2024-03-20'), (7, 12, 1.5, ' B6U2ILPD67', 5, '2024-03-22'), (8, 3, 10, ' 1VGW2RUMFO', 2, '2024-04-20'), (9, 12, 50, ' ORDB36D5N7', 2, '2024-04-20'); -- -------------------------------------------------------- -- -- Structure de la table `project` -- CREATE TABLE `project` ( `id_project` int(11) NOT NULL, `nme_project` varchar(30) NOT NULL, `id_member` int(11) NOT NULL, `id_contribution` int(11) NOT NULL, `amount_project` varchar(30) NOT NULL, `date_project` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `project` -- INSERT INTO `project` (`id_project`, `nme_project`, `id_member`, `id_contribution`, `amount_project`, `date_project`) VALUES (5, ' 0JVZAWGR55', 3, 1, '1000', '2024-04-25'), (6, ' ZEK7LFMGW9', 3, 1, '14000', '2024-04-23'), (7, ' 3XB2GP3LMM', 3, 1, '0', '2024-04-25'), (8, ' QRYACTLETD', 12, 1, '15000', '2024-04-25'), (9, ' DBC5486FEE', 3, 7, '50000', '2024-04-25'), (10, ' W4TV0KMZ37', 3, 9, '18000', '2024-04-27'), (11, ' BM0138IC5X', 3, 10, '15000', '2024-04-27'), (12, ' 8N58DIG3DC', 3, 11, '25000', '2024-04-29'); -- -------------------------------------------------------- -- -- Structure de la table `relationship` -- CREATE TABLE `relationship` ( `id_relationship` int(11) NOT NULL, `id_employe` int(11) NOT NULL, `nom_relationship` varchar(70) NOT NULL, `date_relationship` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `relationship` -- INSERT INTO `relationship` (`id_relationship`, `id_employe`, `nom_relationship`, `date_relationship`) VALUES (1, 2, 'Brother', '2024-03-08'), (3, 2, 'Sister', '2024-03-12'); -- -------------------------------------------------------- -- -- Structure de la table `salaries` -- CREATE TABLE `salaries` ( `id_salary` int(11) NOT NULL, `id_member` int(11) NOT NULL, `amount_salary` int(30) NOT NULL, `rest_salary` int(30) NOT NULL, `month_salary` varchar(30) NOT NULL, `year_salary` int(11) NOT NULL, `number_salary` varchar(70) NOT NULL, `date_salary` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Structure de la table `saving` -- CREATE TABLE `saving` ( `id_saving` int(11) NOT NULL, `nme_saving` varchar(30) NOT NULL, `id_member` int(11) NOT NULL, `id_contribution` int(11) NOT NULL, `amount_saving` varchar(30) NOT NULL, `date_saving` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `saving` -- INSERT INTO `saving` (`id_saving`, `nme_saving`, `id_member`, `id_contribution`, `amount_saving`, `date_saving`) VALUES (7, ' ZEK7LFMGW9', 3, 1, '0', '2024-04-25'), (8, ' 3XB2GP3LMM', 3, 1, '15000', '2024-04-25'), (9, ' QRYACTLETD', 12, 1, '5000', '2024-04-25'), (10, ' DBC5486FEE', 3, 7, '12000', '2024-04-25'), (11, ' W4TV0KMZ37', 3, 9, '18000', '2024-04-27'), (12, ' BM0138IC5X', 3, 10, '15000', '2024-04-27'), (13, ' 8N58DIG3DC', 3, 11, '25000', '2024-04-29'); -- -------------------------------------------------------- -- -- Structure de la table `share` -- CREATE TABLE `share` ( `id_share` int(11) NOT NULL, `nme_share` varchar(30) NOT NULL, `id_member` int(11) NOT NULL, `id_contribution` int(11) NOT NULL, `amount_share` varchar(30) NOT NULL, `date_share` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `share` -- INSERT INTO `share` (`id_share`, `nme_share`, `id_member`, `id_contribution`, `amount_share`, `date_share`) VALUES (5, ' ZEK7LFMGW9', 3, 1, '15000', '2024-04-25'), (6, ' 3XB2GP3LMM', 3, 1, '0', '2024-04-25'), (7, ' QRYACTLETD', 12, 1, '12000', '2024-04-25'), (8, ' DBC5486FEE', 3, 7, '15000', '2024-04-25'), (9, ' W4TV0KMZ37', 3, 9, '18000', '2024-04-27'), (10, ' BM0138IC5X', 3, 10, '15000', '2024-04-27'), (11, ' 8N58DIG3DC', 3, 11, '25000', '2024-04-29'); -- -------------------------------------------------------- -- -- Structure de la table `state_association` -- CREATE TABLE `state_association` ( `id_state_asso` int(11) NOT NULL, `state_association` varchar(30) NOT NULL, `id_association` int(11) NOT NULL, `id_admin` int(11) NOT NULL, `date_state_asso` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `state_association` -- INSERT INTO `state_association` (`id_state_asso`, `state_association`, `id_association`, `id_admin`, `date_state_asso`) VALUES (1, 'INACTIVE', 1, 4, '2024-03-09'), (2, 'ACTIVE', 1, 4, '2024-03-09'), (3, 'INACTIVE', 1, 4, '2024-03-09'), (4, 'ACTIVE', 1, 4, '2024-03-09'); -- -------------------------------------------------------- -- -- Structure de la table `state_employes` -- CREATE TABLE `state_employes` ( `id_state_em` int(11) NOT NULL, `id_employe` int(11) NOT NULL, `id_changer` int(11) NOT NULL, `state_em` varchar(30) NOT NULL, `date_state_em` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Structure de la table `state_membre` -- CREATE TABLE `state_membre` ( `id_state` int(11) NOT NULL, `id_membre` int(11) NOT NULL, `id_employe` int(11) NOT NULL, `change_state` varchar(30) NOT NULL, `date_state` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Déchargement des données de la table `state_membre` -- INSERT INTO `state_membre` (`id_state`, `id_membre`, `id_employe`, `change_state`, `date_state`) VALUES (1, 3, 2, 'ACTIVE', '2024-03-09'), (2, 3, 2, 'ACTIVE', '2024-03-09'), (3, 3, 2, 'INACTIVE', '2024-03-09'), (4, 3, 2, 'ACTIVE', '2024-03-09'), (5, 3, 2, 'INACTIVE', '2024-03-09'), (6, 3, 2, 'ACTIVE', '2024-03-09'), (7, 4, 2, 'INACTIVE', '2024-03-16'), (8, 4, 2, 'ACTIVE', '2024-03-16'), (9, 4, 2, 'INACTIVE', '2024-03-22'), (10, 4, 2, 'ACTIVE', '2024-03-22'), (11, 12, 2, 'INACTIVE', '2024-04-19'); -- -------------------------------------------------------- -- -- Structure de la table `students` -- CREATE TABLE `students` ( `id_student` int(11) NOT NULL, `fullname` varchar(30) NOT NULL, `email` varchar(30) NOT NULL, `phone` varchar(30) NOT NULL, `course` int(30) NOT NULL, `date_student` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `students` -- INSERT INTO `students` (`id_student`, `fullname`, `email`, `phone`, `course`, `date_student`) VALUES (87, '12', 'MERCY WANGARI GACHOGU', 'STORES', 550, '2024-03-23'), (88, '147', 'DANIEL MWANGI MURIITHI', 'SOCIETY GENERAL', 550, '2024-03-23'), (89, '39', 'PATRICK MUNENE GACHOKI', 'GETUYA', 850, '2024-03-23'), (90, '15', 'SAMSON MURIITHI MURIUKI', 'SOCIETY GENERAL', 1050, '2024-03-23'), (91, '36', 'JOSEPH MURIUKI WANJOHI', 'MITONDO', 1050, '2024-03-23'), (92, '53', 'PATRICK KARANI KAGUNA', 'KARIAINI', 1050, '2024-03-23'), (93, '69', 'BENSON MURIITHI CHOMBA', 'IHARA', 1050, '2024-03-23'), (94, '95', 'PURITY WANJIKU KABUGI', 'GATHAMBI', 1050, '2024-03-23'), (95, '146', 'MURIMI IRUNGU', 'SOCIETY GENERAL', 1051, '2024-03-23'), (96, '143', 'GERSHON KABUI KAMAU', 'SOCIETY GENERAL', 1800, '2024-03-23'), (97, '0139', 'VIRGINIA NYAWIRA WANJOHI', 'STORES', 2000, '2024-03-23'), (98, '126', 'PAUL KARIMI MWANGI', 'SOCIETY GENERAL', 2000, '2024-03-23'), (99, '99', 'BONIFACE MUTHII MBOGO', 'MITONDO', 2000, '2024-03-23'), (100, '48', 'STEPHEN MWAI GIKUNJU', 'GATHAMBI', 2050, '2024-03-23'), (101, '114', 'GRACE WANJIKU MURIUKI', 'NURSERY', 2830, '2024-03-23'), (102, '124', 'STEPHEN MURIMI WAIGWA', 'STORES', 3000, '2024-03-23'), (103, '148', 'JOHN KINYUA NDUGUTO', 'SOCIETY GENERAL', 3275, '2024-03-23'), (104, '140', 'VINCENT MANEGENE WANJIRU', 'KIAMBWE', 3930, '2024-03-23'), (105, '80', 'CHRISTOPHER MAINA MURIUKI', 'NURSERY', 4000, '2024-03-23'), (106, '30', 'SAMUEL MURIUKI KINYUA', 'KARIAINI', 4096, '2024-03-23'), (107, '82', 'STEPHEN MUTUKU MURIMI', 'RIAKIANIA', 4300, '2024-03-23'), (108, '106', 'BENARD KINYUA WAITHANJI', 'NURSERY', 4542, '2024-03-23'), (109, '108', 'ELIZABETH GAKENIA WANJIRU', 'STORES', 4570, '2024-03-23'), (110, '85', 'CHRISTOPHER MUTHII MURIMI', 'GATHAMBI', 4600, '2024-03-23'), (111, '107', 'RICADER NJOKI MUTUGI', 'STORES', 4770, '2024-03-23'), (112, '19', 'ALBERT MURIITHI KIMINJU', 'SOCIETY GENERAL', 4856, '2024-03-23'), (113, '130', 'MICHAEL GUCURA MUGO', 'GETUYA', 4970, '2024-03-23'), (114, '56', 'PETER MUTHII CHOMBA', 'SOCIETY GENERAL', 5431, '2024-03-23'), (115, '07', 'BONIFACE MURIITHI KAMAU', 'SOCIETY GENERAL', 5592, '2024-03-23'), (116, '151', 'JOHN MAINA MWAI', 'KIARAGANA', 5887, '2024-03-23'), (117, '31', 'TERESIAH WANGARI KABUITU', 'SOCIETY GENERAL', 5906, '2024-03-23'), (118, '149', 'GEOFREY MUGO MURIITHI', 'KCM 108A', 6000, '2024-03-23'), (119, '58', 'JAMES MURIUKI NGIRATI', 'MITONDO', 6016, '2024-03-23'), (120, '84', 'LYDIAH WANJIRA KARANI', 'STORES', 7000, '2024-03-23'), (121, '144', 'HELLEN WAMBUI WACHIRA', 'STORES', 7329, '2024-03-23'), (122, '98', 'JOSEPH WILSTONE KAGWIMA MUGWER', 'KIAMBWE', 7803, '2024-03-23'), (123, '113', 'EUNICE WAMBURA KINYUA', 'STORES', 8000, '2024-03-23'), (124, '86', 'KENNEDY NYANGE GACHOKI', 'SOCIETY GENERAL', 8500, '2024-03-23'), (125, '65', 'TIMOTHY MWANGI KIOI', 'SOCIETY GENERAL', 8650, '2024-03-23'), (126, '78', 'JOSPHAT MWAI RUITA', 'IHARA', 8865, '2024-03-23'), (127, '21', 'JOHN MURIITHI KINYUA', 'SOCIETY GENERAL', 8990, '2024-03-23'), (128, '83', 'EUNICE WANJIRU MAINA', 'STORES', 10388, '2024-03-23'), (129, '152', 'MARGARET WANJIKU NGIGI', 'SOCIETY GENERAL', 11491, '2024-03-23'), (130, '20', 'DANIEL WANJOHI MACHANGIA', 'SOCIETY GENERAL', 11944, '2024-03-23'), (131, '89', 'ISAIAH KIBUCHI MUNENE', 'SOCIETY GENERAL', 12076, '2024-03-23'), (132, '11', 'MISHECK MUNENE MURAGE', 'STORES', 12826, '2024-03-23'), (133, '27', 'HILARY MUTUGI MURAGE', 'RIAKIANIA', 15450, '2024-03-23'), (134, '09', 'PETER KINYUA MATHENGE', 'SOCIETY GENERAL', 17156, '2024-03-23'), (135, '111', 'NAHASHON MURIITHI MURIUKI', 'SOCIETY GENERAL', 20000, '2024-03-23'), (136, '', '', '', 283140, '2024-03-23'); -- -------------------------------------------------------- -- -- Structure de la table `tbladmin` -- CREATE TABLE `tbladmin` ( `ID` int(11) NOT NULL, `AdminName` varchar(120) DEFAULT NULL, `AdminuserName` varchar(20) NOT NULL, `MobileNumber` varchar(30) NOT NULL, `Email` varchar(120) NOT NULL, `Password` varchar(120) DEFAULT NULL, `AdminRegdate` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `tbladmin` -- INSERT INTO `tbladmin` (`ID`, `AdminName`, `AdminuserName`, `MobileNumber`, `Email`, `Password`, `AdminRegdate`) VALUES (4, 'IRAKOZE Joselyne', 'Joselyne', '+25772145771', 'irakozejoselyne2710@gmail.com', '75847568a9a7222ca6b5a9c160a2e644', '2024-03-06 22:03:38'); -- -------------------------------------------------------- -- -- Structure de la table `welfare` -- CREATE TABLE `welfare` ( `id_welfare` int(11) NOT NULL, `nme_welfare` varchar(30) NOT NULL, `id_member` int(11) NOT NULL, `id_contribution` int(11) NOT NULL, `amount_welfare` varchar(30) NOT NULL, `date_welfare` date NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Déchargement des données de la table `welfare` -- INSERT INTO `welfare` (`id_welfare`, `nme_welfare`, `id_member`, `id_contribution`, `amount_welfare`, `date_welfare`) VALUES (6, ' P9REOBPAX2', 3, 1, '15000', '2024-04-25'), (7, ' ZEK7LFMGW9', 3, 1, '0', '2024-04-25'), (8, ' 3XB2GP3LMM', 3, 1, '0', '2024-04-25'), (9, ' QRYACTLETD', 12, 1, '1000', '2024-04-25'), (10, ' DBC5486FEE', 3, 7, '15000', '2024-04-25'), (11, ' W4TV0KMZ37', 3, 9, '18000', '2024-04-27'), (12, ' BM0138IC5X', 3, 10, '15000', '2024-04-27'), (13, ' 8N58DIG3DC', 3, 11, '25000', '2024-04-29'); -- -- Index pour les tables déchargées -- -- -- Index pour la table `all_contributions` -- ALTER TABLE `all_contributions` ADD PRIMARY KEY (`id_all`), ADD KEY `id_member` (`id_member`), ADD KEY `id_employe` (`id_employe`), ADD KEY `id_contribution` (`id_contribution`); -- -- Index pour la table `associations` -- ALTER TABLE `associations` ADD PRIMARY KEY (`id_association`); -- -- Index pour la table `banks` -- ALTER TABLE `banks` ADD PRIMARY KEY (`id_bank`); -- -- Index pour la table `bank_shift` -- ALTER TABLE `bank_shift` ADD PRIMARY KEY (`id_bs`), ADD KEY `id_membre` (`id_membre`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `beneficiaries` -- ALTER TABLE `beneficiaries` ADD PRIMARY KEY (`id_ben`), ADD KEY `id_member` (`id_member`), ADD KEY `id_relationship` (`id_relationship`); -- -- Index pour la table `bsb` -- ALTER TABLE `bsb` ADD KEY `id_membre` (`phone_membre`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `contributions` -- ALTER TABLE `contributions` ADD PRIMARY KEY (`id_contribution`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `employes` -- ALTER TABLE `employes` ADD PRIMARY KEY (`id_employe`), ADD KEY `id_association` (`id_association`); -- -- Index pour la table `excel_data` -- ALTER TABLE `excel_data` ADD PRIMARY KEY (`id`); -- -- Index pour la table `loans` -- ALTER TABLE `loans` ADD PRIMARY KEY (`id_loan`), ADD KEY `id_all` (`id_membre`), ADD KEY `id_employe` (`id_employe`), ADD KEY `id_bank` (`id_bank`); -- -- Index pour la table `membres` -- ALTER TABLE `membres` ADD PRIMARY KEY (`id_membre`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `period_interest` -- ALTER TABLE `period_interest` ADD PRIMARY KEY (`id_per_in`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `project` -- ALTER TABLE `project` ADD PRIMARY KEY (`id_project`), ADD KEY `id_member` (`id_member`), ADD KEY `id_contribution` (`id_contribution`); -- -- Index pour la table `relationship` -- ALTER TABLE `relationship` ADD PRIMARY KEY (`id_relationship`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `salaries` -- ALTER TABLE `salaries` ADD PRIMARY KEY (`id_salary`), ADD KEY `id_member` (`id_member`); -- -- Index pour la table `saving` -- ALTER TABLE `saving` ADD PRIMARY KEY (`id_saving`), ADD KEY `id_member` (`id_member`), ADD KEY `id_contribution` (`id_contribution`); -- -- Index pour la table `share` -- ALTER TABLE `share` ADD PRIMARY KEY (`id_share`), ADD KEY `id_member` (`id_member`), ADD KEY `id_contribution` (`id_contribution`); -- -- Index pour la table `state_association` -- ALTER TABLE `state_association` ADD PRIMARY KEY (`id_state_asso`), ADD KEY `id_employe` (`id_association`), ADD KEY `id_admin` (`id_admin`); -- -- Index pour la table `state_employes` -- ALTER TABLE `state_employes` ADD PRIMARY KEY (`id_state_em`), ADD KEY `id_employe` (`id_employe`), ADD KEY `id_changer` (`id_changer`); -- -- Index pour la table `state_membre` -- ALTER TABLE `state_membre` ADD PRIMARY KEY (`id_state`), ADD KEY `id_membre` (`id_membre`), ADD KEY `id_employe` (`id_employe`); -- -- Index pour la table `students` -- ALTER TABLE `students` ADD PRIMARY KEY (`id_student`); -- -- Index pour la table `tbladmin` -- ALTER TABLE `tbladmin` ADD PRIMARY KEY (`ID`); -- -- Index pour la table `welfare` -- ALTER TABLE `welfare` ADD PRIMARY KEY (`id_welfare`), ADD KEY `id_member` (`id_member`); -- -- AUTO_INCREMENT pour les tables déchargées -- -- -- AUTO_INCREMENT pour la table `all_contributions` -- ALTER TABLE `all_contributions` MODIFY `id_all` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT pour la table `associations` -- ALTER TABLE `associations` MODIFY `id_association` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT pour la table `banks` -- ALTER TABLE `banks` MODIFY `id_bank` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT pour la table `bank_shift` -- ALTER TABLE `bank_shift` MODIFY `id_bs` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71; -- -- AUTO_INCREMENT pour la table `beneficiaries` -- ALTER TABLE `beneficiaries` MODIFY `id_ben` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT pour la table `contributions` -- ALTER TABLE `contributions` MODIFY `id_contribution` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT pour la table `employes` -- ALTER TABLE `employes` MODIFY `id_employe` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT pour la table `excel_data` -- ALTER TABLE `excel_data` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `loans` -- ALTER TABLE `loans` MODIFY `id_loan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT pour la table `membres` -- ALTER TABLE `membres` MODIFY `id_membre` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70; -- -- AUTO_INCREMENT pour la table `period_interest` -- ALTER TABLE `period_interest` MODIFY `id_per_in` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT pour la table `project` -- ALTER TABLE `project` MODIFY `id_project` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT pour la table `relationship` -- ALTER TABLE `relationship` MODIFY `id_relationship` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT pour la table `salaries` -- ALTER TABLE `salaries` MODIFY `id_salary` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `saving` -- ALTER TABLE `saving` MODIFY `id_saving` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT pour la table `share` -- ALTER TABLE `share` MODIFY `id_share` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT pour la table `state_association` -- ALTER TABLE `state_association` MODIFY `id_state_asso` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT pour la table `state_employes` -- ALTER TABLE `state_employes` MODIFY `id_state_em` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `state_membre` -- ALTER TABLE `state_membre` MODIFY `id_state` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT pour la table `students` -- ALTER TABLE `students` MODIFY `id_student` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137; -- -- AUTO_INCREMENT pour la table `tbladmin` -- ALTER TABLE `tbladmin` MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT pour la table `welfare` -- ALTER TABLE `welfare` MODIFY `id_welfare` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; COMMIT; /*!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 */;