-- 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

START TRANSACTION;



--
-- 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 `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 `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 `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 `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 `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 `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 `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 `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 `contributions`
--
ALTER TABLE `contributions`
  MODIFY `id_contribution` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- 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 `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 `welfare`
--
ALTER TABLE `welfare`
  MODIFY `id_welfare` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

