-- Création de la première table : scc_status_jungnability
CREATE TABLE IF NOT EXISTS `scc_status_jungnability` (
  `id_n` int(11) NOT NULL AUTO_INCREMENT,
  `name_v` varchar(255) NOT NULL,
  PRIMARY KEY (`id_n`),
  UNIQUE KEY `name_v` (`name_v`)
);

INSERT INTO `scc_status_jungnability` (`id_n`, `name_v`) VALUES
(3, 'FAUX CONTACT'),
(2, 'KO'),
(1, 'OK'),;

-- Création de la seconde table : scc_status_argumentation
CREATE TABLE scc_status_argumentation (
    id_n INT AUTO_INCREMENT PRIMARY KEY,
    status_jungnability_id INT NOT NULL,
    name_v VARCHAR(255) NOT NULL,
    
    -- Définition de la clé étrangère pour lier à scc_status_jungnability
    FOREIGN KEY (status_jungnability_id) 
        REFERENCES scc_status_jungnability(id_n)
        ON DELETE CASCADE -- Optionnel: Supprime les arguments si le statut parent est supprimé
        ON UPDATE CASCADE -- Optionnel: Met à jour si l'ID du statut parent change
);

INSERT INTO `scc_status_argumentation` (`id_n`, `status_jungnability_id`, `name_v`) VALUES
(1, 1, 'ARGUMENTE AVEC ACCORD REABO'),
(2, 1, 'REFUS REABO'),
(3, 1, 'ARGUMENTE'),
(4, 2, 'NON APPLICABLE/ INJOIGNABLE'),
(5, 3, 'NON APPLICABLE');

-- Création de la troisième table : scc_motif_refusal
CREATE TABLE scc_motif_refusal (
    id_n INT AUTO_INCREMENT PRIMARY KEY,
    name_v VARCHAR(255) NOT NULL UNIQUE
);

INSERT INTO scc_motif_refusal (name_v) VALUES 
('Aucun'),
('VOYAGE'),
('PROBLEME FINANCIER'),
('PROBLEME DE SANTE'),
('DEMENAGEMENT EN COURS'),
('PROBLEME DE TV'),
('ANOMALIE TECHNIQUE SUR LES EQPT CANAL +'),
('MECONTENT/INSATISFAIT');

-- Création de la table scc_status_renewal
CREATE TABLE scc_status_renewal (
    id_n INT AUTO_INCREMENT PRIMARY KEY,
    name_v VARCHAR(255) NOT NULL UNIQUE
);

-- Insertion des données
INSERT INTO scc_status_renewal (name_v) VALUES 
('OK'),
('KO'),
('EN COURS');

-- Création de la table scc_status_subscriber
CREATE TABLE IF NOT EXISTS `scc_status_subscriber` (
  `id_n` int(11) NOT NULL AUTO_INCREMENT,
  `name_v` varchar(255) NOT NULL,
  PRIMARY KEY (`id_n`),
  UNIQUE KEY `name_v` (`name_v`)
);

-- Insertion de l'état AKWABA
INSERT INTO scc_status_subscriber (name_v) VALUES ('AKWABA');

INSERT INTO scc_status_subscriber (name_v) VALUES 
('M+1'),
('M+2'),
('M+3'),
('M+4'),
('M+5'),
('M+6'),
('M+7'),
('M+8'),
('M+9'),
('M+10'),
('M+11'),
('M+12'),
('M+13'),
('M+14'),
('M+15'),
('M+16'),
('M+17'),
('M+18'),
('M+19'),
('M+20'),
('M+21'),
('M+22'),
('M+23'),
('M+24'),
('M+25'),
('M+26'),
('M+27'),
('M+28'),
('M+29'),
('M+30'),
('M+31'),
('M+32'),
('M+33'),
('M+34'),
('M+35'),
('M+36'),
('M+37'),
('M+38'),
('M+39'),
('M+40'),
('M+41'),
('M+42'),
('M+43'),
('M+44'),
('M+45'),
('M+46'),
('M+47'),
('M+48'),
('M+49'),
('M+50'),
('M+51'),
('M+52'),
('M+53'),
('M+54'),
('M+55'),
('M+56'),
('M+57'),
('M+58'),
('M+59'),
('M+60'),
('M+61'),
('M+62'),
('M+63'),
('M+64'),
('M+65'),
('M+66'),
('M+67'),
('M+68'),
('M+69'),
('M+70'),
('M+71'),
('M+72'),
('M+73'),
('M+74'),
('M+75'),
('M+76'),
('M+77'),
('M+78'),
('M+79'),
('M+80'),
('M+81'),
('M+82'),
('M+83'),
('M+84'),
('M+85'),
('M+86'),
('M+87'),
('M+88'),
('M+89'),
('M+90'),
('M+91'),
('M+92'),
('M+93'),
('M+94'),
('M+95'),
('M+96'),
('M+97'),
('M+98'),
('M+99'),
('M+100');


-- Création de la table scc_recharging_point
CREATE TABLE IF NOT EXISTS `scc_recharging_point` (
  `id_n` int(11) NOT NULL AUTO_INCREMENT,
  `name_v` varchar(255) NOT NULL,
  PRIMARY KEY (`id_n`),
  UNIQUE KEY `name_v` (`name_v`)
);

INSERT INTO `scc_recharging_point` (`id_n`, `name_v`) VALUES
(3882, 'KID INFO 2FU SERVICES'),
(4053, 'KID INFO 2S GROUP CI SARL'),
(3856, 'KID INFO 2SI COMMUNICATION'),
(3825, 'KID INFO 3D MEDIA'),
(4236, 'KID INFO A2I'),
(3984, 'KID INFO AARON SERVICES'),
(4007, 'KID INFO ABADAI SERVICE'),
(4308, 'KID INFO ABI SERVICE'),
(4088, 'KID INFO ABIDJAN SERVICES'),
(3813, 'KID INFO ABM'),
(3855, 'KID INFO ABODA KOUAKOU NARCIS'),
(4056, 'KID INFO ADADE MULTISERVICES'),
(3996, 'KID INFO ADJILA SERVICES'),
(4051, 'KID INFO ADJY BUSINESS'),
(4097, 'KID INFO AFYMA'),
(3798, 'KID INFO AGBAN'),
(4246, 'KID INFO AHIMOU SERVICE'),
(3967, 'KID INFO AIC-MULTISERVICES'),
(3837, 'KID INFO AICHA SERVICE-SICOGI'),
(3830, 'KID INFO AICHA SERVICES'),
(3923, 'KID INFO AIME TON PROCHAIN'),
(4123, 'KID INFO AKPANE OLIVE MICHELINE'),
(3946, 'KID INFO ALI SERVICE'),
(4221, 'KID INFO ANGON EFFOUA PARFAIT'),
(4048, 'KID INFO ANOPTIC'),
(4184, 'KID INFO ANOTHER VIEW'),
(3903, 'KID INFO AS DISTRIBUTION'),
(4087, 'KID INFO ASPRIMA SERVICES'),
(3986, 'KID INFO ASSI JEANINE SERVICES'),
(3867, 'KID INFO ASTRID MULTISERVICES'),
(3930, 'KID INFO ATS DIOM'),
(3799, 'KID INFO ATTECOUBE'),
(4069, 'KID INFO AUTO PNEU'),
(4003, 'KID INFO AUTO-ECOLE BETHLEHEM'),
(4047, 'KID INFO AVE MARIA'),
(4006, 'KID INFO AXEL STORE'),
(3826, 'KID INFO AYEFI SERVICES'),
(4004, 'KID INFO AYESTY SERVICE'),
(4307, 'KID INFO BALLE DENIS MARC'),
(4180, 'KID INFO BANCO 1'),
(3841, 'KID INFO BCLASS'),
(4013, 'KID INFO BDAKE COMMUNICATION'),
(3858, 'KID INFO BEAUTES PLURIELLES'),
(3927, 'KID INFO BENIS SERVICE'),
(4018, 'KID INFO BERACA ASSURANCE'),
(3933, 'KID INFO BERGEROL SERVICES'),
(4289, 'KID INFO BERTHE ELHADJI LAMBERTINI'),
(4002, 'KID INFO BETHEL INFO'),
(3968, 'KID INFO BETHEL LAVERIE'),
(3957, 'KID INFO BEYO TRANSACTION'),
(3900, 'KID INFO BGI SERVICE'),
(4045, 'KID INFO BIG SARL'),
(4030, 'KID INFO BM SERVICES'),
(3955, 'KID INFO BOGNI SERVICE'),
(4035, 'KID INFO BOKOIN SERVICES'),
(3845, 'KID INFO BONI MONNAN MARINA'),
(4120, 'KID INFO BOUTIQUE ELECTROMENAGER'),
(3890, 'KID INFO CANAAN SERVICES'),
(3809, 'KID INFO CASH IVOIRE COMPLEXE'),
(4025, 'KID INFO CASH MONEY'),
(3987, 'KID INFO CBC'),
(4095, 'KID INFO CCGIM'),
(4093, 'KID INFO CENTER BUISNESS'),
(3951, 'KID INFO CHANDELIER DIST'),
(3895, 'KID INFO CHRIS SERVICE'),
(3924, 'KID INFO COMINI COMMUNICATION'),
(3851, 'KID INFO COMPAGNIE BLAISE'),
(3816, 'KID INFO COSMOTECH SICOGI'),
(3940, 'KID INFO COSMOTECH SIDECI'),
(4197, 'KID INFO COULIBALY SERVICE'),
(4314, 'KID INFO COULIBALY VAZOUMANA'),
(3810, 'KID INFO CSTP ANDOKOUA'),
(3869, 'KID INFO DAAC SERVICES'),
(3950, 'KID INFO DARCHE'),
(4111, 'KID INFO DGS'),
(3857, 'KID INFO DIA SERVICES ET COMM'),
(3990, 'KID INFO DIALLO YOUSSOUF'),
(3828, 'KID INFO DIKO 2'),
(3815, 'KID INFO DILL DE MERVEAILLES'),
(4039, 'KID INFO DIOM''S PRESTATION'),
(4100, 'KID INFO DIVINE GRACE'),
(4086, 'KID INFO DIVINE PRESTATION'),
(3844, 'KID INFO DJE KOUASSI FABRICE'),
(4057, 'KID INFO DJIGUI BUSINESS'),
(4076, 'KID INFO DJIVA MULTISERVICES'),
(3859, 'KID INFO DJO MATTERSON'),
(3897, 'KID INFO DK SERVICES'),
(4105, 'KID INFO DMN BUSINESS'),
(3915, 'KID INFO DOLIVERA'),
(3850, 'KID INFO DON MONNEY'),
(3898, 'KID INFO DOUAGOUE ERIC-ANICET'),
(4178, 'KID INFO DOUM SERVICE'),
(4038, 'KID INFO DOUMBIA SERVICES'),
(4041, 'KID INFO DRABO.COM'),
(3947, 'KID INFO EAM YOP DISTRIBUTION'),
(3966, 'KID INFO EBD DISTRIBUTION'),
(3941, 'KID INFO ECKO BOSS'),
(4052, 'KID INFO ECLAT NIANGON SUD'),
(4089, 'KID INFO EDN ENTREPRISE'),
(4021, 'KID INFO EDS'),
(3918, 'KID INFO EDS ET SERVICES (SORO)'),
(3982, 'KID INFO EDSL AZITO'),
(3876, 'KID INFO EES'),
(4042, 'KID INFO EL SHADDAI DISTRIBUTION'),
(4026, 'KID INFO ELITE SERVICES'),
(3887, 'KID INFO ELLIE SERVICES'),
(3998, 'KID INFO EMMANUELLA MULTI-SERVICES'),
(4092, 'KID INFO ENBTP'),
(3846, 'KID INFO EPI COMMUNICATION'),
(3909, 'KID INFO ESPACE MONEY'),
(4044, 'KID INFO ETABLISSEMENT PREGNON'),
(4124, 'KID INFO ETOILE MGG'),
(3983, 'KID INFO ETS AMANI (ACF)'),
(3954, 'KID INFO ETS BAMA'),
(3886, 'KID INFO ETS BBA DIEU MERCI'),
(4077, 'KID INFO ETS BLE'),
(4068, 'KID INFO ETS BOGA'),
(4022, 'KID INFO ETS CISSE BANGALY'),
(4119, 'KID INFO ETS D.A.A'),
(3922, 'KID INFO ETS DEM'),
(4116, 'KID INFO ETS DIAMBRA'),
(3879, 'KID INFO ETS DIVINE ET BROU'),
(4106, 'KID INFO ETS DJATOU'),
(3892, 'KID INFO ETS DOKE'),
(3807, 'KID INFO ETS DOMOA'),
(4118, 'KID INFO ETS EBY'),
(3958, 'KID INFO ETS ELIEL'),
(4063, 'KID INFO ETS ENJAILLEMENTS'),
(4122, 'KID INFO ETS IVOIRE COM SERVICES'),
(4085, 'KID INFO ETS JAMIS'),
(4064, 'KID INFO ETS JAMIS SELMER'),
(4081, 'KID INFO ETS JULES FERRY'),
(4001, 'KID INFO ETS KADY BAMBA'),
(4046, 'KID INFO ETS KOUAKOU'),
(3866, 'KID INFO ETS KS SARL'),
(4050, 'KID INFO ETS LA ROSE'),
(3888, 'KID INFO ETS MANNE PRECIEUSE'),
(3884, 'KID INFO ETS MARINA SCHEKINA'),
(3904, 'KID INFO ETS MENNEY'),
(3991, 'KID INFO ETS MIRA'),
(3893, 'KID INFO ETS NJD'),
(3812, 'KID INFO ETS NKO'),
(4103, 'KID INFO ETS OLIVIER MONEY'),
(4005, 'KID INFO ETS PATY DISTRIBUTION'),
(3906, 'KID INFO ETS RABE DAVID'),
(4117, 'KID INFO ETS SUCCESS ET GLOIRE'),
(3865, 'KID INFO ETS TAIWO ET FRERES'),
(4049, 'KID INFO ETS TCHUMUN'),
(4127, 'KID INFO ETS TOURE'),
(4084, 'KID INFO ETS WATMEDHI'),
(4020, 'KID INFO ETS YAO'),
(4073, 'KID INFO ETS ZKCM'),
(3974, 'KID INFO EVOLUTION BUSINESS'),
(4060, 'KID INFO EXCAUSE SERVICE'),
(3802, 'KID INFO EXCELLENCE'),
(3880, 'KID INFO FLY EASY SARL'),
(3842, 'KID INFO FOLLY GPE TOIT RGE'),
(3836, 'KID INFO FOLLY''S COMPLEXE'),
(3831, 'KID INFO FOLLY''S GROUP CAMP MILITAIRE'),
(3835, 'KID INFO FOLLY''S KOWEIT'),
(3834, 'KID INFO FOLLY''S SAGUIDIBA'),
(4054, 'KID INFO FR@SERVICE'),
(3860, 'KID INFO G.A.A'),
(4243, 'KID INFO GAD SERVICE'),
(4209, 'KID INFO GBATO SERVICE'),
(3878, 'KID INFO GLEGBI COTE D''IVOIRE'),
(3965, 'KID INFO GLOBAL SERVICE'),
(3911, 'KID INFO GLOIRE MULTISERVICES'),
(3875, 'KID INFO GOD GIVE 2'),
(3921, 'KID INFO GOD GRACE MONEY'),
(3899, 'KID INFO GOLD SERVICES'),
(3972, 'KID INFO GOLY SERVICE'),
(4024, 'KID INFO GRACE DIVINE'),
(3891, 'KID INFO GRANDE ROUTE MULTISVC'),
(4017, 'KID INFO GRANDTY''S'),
(3913, 'KID INFO GROUP G SERVICES'),
(3833, 'KID INFO GROUP ZONGO'),
(3843, 'KID INFO GROUP ZONGO SIPOREX'),
(3997, 'KID INFO GROUPE KADJA'),
(4037, 'KID INFO GROUPE KAGNAN'),
(3819, 'KID INFO GROUPE SECOND ADAM'),
(3988, 'KID INFO GT PROTECK'),
(4290, 'KID INFO HAMED SERVICE'),
(3861, 'KID INFO HAMED SERVICES'),
(3943, 'KID INFO HM SERVICES'),
(3963, 'KID INFO HOP 2'),
(4055, 'KID INFO HTM'),
(3926, 'KID INFO I.TECH BUSINESS'),
(4059, 'KID INFO IBOO TV (EX BURONET CI)'),
(3980, 'KID INFO IBP AZITO'),
(3839, 'KID INFO IDSAT 2'),
(3838, 'KID INFO IDSAT SIDECI'),
(4230, 'KID INFO ILBOUDO DIANE'),
(4112, 'KID INFO IMMA ET BRYAN GROUP'),
(3944, 'KID INFO IMPRIM PLUS'),
(4121, 'KID INFO IMPRIMERIE LIGNON'),
(4014, 'KID INFO INCHALLAH COMMUNICATION'),
(4062, 'KID INFO IRIE MULTI SERVICE'),
(3853, 'KID INFO ISDIA TECHNOLOGIQUE'),
(4000, 'KID INFO ISRAEL PRESSING'),
(3929, 'KID INFO IVOIR ELECTRONIQUE'),
(4109, 'KID INFO IVOIRE HYDROCARBURE'),
(3937, 'KID INFO IVOIRE PRESTATION'),
(3914, 'KID INFO JCS'),
(4319, 'KID INFO JOHNSON SERVICE'),
(4058, 'KID INFO JUMEAUX MULTISERVICES'),
(3852, 'KID INFO K-GROUP SARL'),
(3910, 'KID INFO K3 DISTRIBUTION'),
(4009, 'KID INFO KADY SAMASSI'),
(4061, 'KID INFO KAM SERVICE'),
(4114, 'KID INFO KANGNIVI AHYTE JULIEN'),
(4113, 'KID INFO KANTE DEVELOPPEMENT'),
(3854, 'KID INFO KANYS DISTRIBUTION'),
(3862, 'KID INFO KB GROUP INVEST'),
(3976, 'KID INFO KBS.COM'),
(3863, 'KID INFO KBT COMMUNICATION'),
(3840, 'KID INFO KENY VISION'),
(3874, 'KID INFO KENY VISION BEL AIR'),
(3979, 'KID INFO KGS GROUP'),
(3994, 'KID INFO KGYS SERVICES'),
(4016, 'KID INFO KHOA'),
(3948, 'KID INFO KKB DISTRIBUTION'),
(4168, 'KID INFO KOBENAN KOUASSI ARMEL'),
(3848, 'KID INFO KOFFI KOUAME ARSENE'),
(4182, 'KID INFO KOFFI SERGO ARNAUD'),
(4079, 'KID INFO KOGNON SERVICE'),
(4248, 'KID INFO KONAN SERVICE'),
(3919, 'KID INFO KONE VAZOU'),
(4229, 'KID INFO KOUADIO SERVICE'),
(3901, 'KID INFO KOUAKOU OI KOUAKOU FREDDY'),
(3902, 'KID INFO KOUAKOU RECHARGE'),
(3877, 'KID INFO KOUAME NGUESSAN'),
(3873, 'KID INFO KOUAME YAO FRANCOIS'),
(3896, 'KID INFO KTV'),
(3928, 'KID INFO LA GLOIRE DE DIEU'),
(3883, 'KID INFO LA MAIN DE DIEU'),
(4012, 'KID INFO LA MERVELLE DISTRIBUTION'),
(4082, 'KID INFO LAM''S SERVICES'),
(3818, 'KID INFO LATIFAH YEGNON SERVICES'),
(4185, 'KID INFO LE BON BUDGET'),
(4036, 'KID INFO LE SUCCES.COM'),
(4282, 'KID INFO LEBA ERIC SERVICE'),
(3847, 'KID INFO LEGBATA SARL-U'),
(3992, 'KID INFO LEXOR CORPORATE'),
(3817, 'KID INFO LIBRAIRIE ADORATION'),
(3804, 'KID INFO LOGBOU JEAN SERGE'),
(3912, 'KID INFO LONCHAMP'),
(3961, 'KID INFO LOUP BENJAMIN SERVICES'),
(3995, 'KID INFO LS YOUAN'),
(4108, 'KID INFO LUMARC SERVICE'),
(4101, 'KID INFO M.E.N.A SERVICES'),
(3881, 'KID INFO MAEVA 2 KEIHONON DIST'),
(4107, 'KID INFO MAGIC BTP'),
(4096, 'KID INFO MARC ESPOIR'),
(3806, 'KID INFO MARCELLE & CO'),
(4033, 'KID INFO MARCIAL TRANSFERT.COM'),
(3934, 'KID INFO MARIE MULTISERVICES'),
(4080, 'KID INFO MARKER EVA'),
(4015, 'KID INFO MART ET EVE'),
(4110, 'KID INFO MATELOT CASH MONEY'),
(3908, 'KID INFO MC GROUP SARL'),
(4074, 'KID INFO MELO DISTRIBUTION'),
(4104, 'KID INFO MERVEILLE SERVICE'),
(4098, 'KID INFO MESSAG'),
(3989, 'KID INFO MIENMEAU FINANCE ET SERVICES'),
(4040, 'KID INFO MIENSA'),
(3827, 'KID INFO MIKLA'),
(4078, 'KID INFO MIMI COMMUNICATION'),
(3956, 'KID INFO MOCTAR BUSINESS'),
(3938, 'KID INFO MONBOYE'),
(4126, 'KID INFO MPS RUE PRINCESSE'),
(4066, 'KID INFO MPS SELMER'),
(4070, 'KID INFO MPSL'),
(4256, 'KID INFO MZ BAMBA MAMADOU'),
(4217, 'KID INFO MZ DJA KOUAME'),
(4200, 'KID INFO MZ GNANGUI'),
(4255, 'KID INFO MZ HIEN OLLO'),
(4219, 'KID INFO MZ YAO LAZARE'),
(4215, 'KID INFO N''DRI SERVICE'),
(4115, 'KID INFO N''DYA SERVICE'),
(3971, 'KID INFO NAMI SERVICES'),
(3864, 'KID INFO NASSUA GROUPE'),
(4125, 'KID INFO NGUESSAN AKE PAUL'),
(3931, 'KID INFO NIANGON ENTPB'),
(3820, 'KID INFO NOA SERVICE'),
(3999, 'KID INFO NT CORPORATION'),
(4071, 'KID INFO O''NEL'),
(4094, 'KID INFO OASIS PRESTIGE CENTER'),
(4034, 'KID INFO OAT.COM'),
(3823, 'KID INFO OBM GROUP'),
(3905, 'KID INFO OMNIPRESENCE COMMUNICATION'),
(3889, 'KID INFO OPM SARL'),
(3822, 'KID INFO OPRAH CAMP MILITAIRE'),
(3832, 'KID INFO OPRAH MULTISERVICES'),
(4090, 'KID INFO OUATT BUSINESS CENTER'),
(4181, 'KID INFO OUATT SERVICES'),
(3985, 'KID INFO OUATTARA MEH'),
(4285, 'KID INFO OUATTARA SOULEYMANE'),
(3952, 'KID INFO OUATTARA YACOUBA SERVICES'),
(4008, 'KID INFO OYMA BUSINESS'),
(3978, 'KID INFO PAJNUMERIC'),
(4072, 'KID INFO PRESSING SCHEKINAEL'),
(3803, 'KID INFO PRESTIGE'),
(4028, 'KID INFO PRONTIC'),
(4029, 'KID INFO PROSPERITE BUSINESS'),
(3977, 'KID INFO PS ELIAKIM'),
(3871, 'KID INFO RAHAB SERVICE'),
(4152, 'KID INFO REX ABOU ADEMOLA'),
(4318, 'KID INFO REX ADEBAYOR'),
(4306, 'KID INFO REX AGBE ETS'),
(4277, 'KID INFO REX AHOU EDITH'),
(4193, 'KID INFO REX AKA DENIS'),
(4164, 'KID INFO REX AKRE MOREL'),
(4167, 'KID INFO REX ALLOUKOU DANHO'),
(4210, 'KID INFO REX ASSANVO PIERRE'),
(4242, 'KID INFO REX ASSI ADON ALEX'),
(4303, 'KID INFO REX ASSIEANGE FERNANDEZ'),
(4313, 'KID INFO REX ASSOUMOU NDRI'),
(4263, 'KID INFO REX BABA'),
(4270, 'KID INFO REX BAHIET MOHAMED'),
(4309, 'KID INFO REX BAKAYOKO SOUALIO'),
(4245, 'KID INFO REX BAMBA BAKARY'),
(4186, 'KID INFO REX BAMBA LASSANA'),
(4173, 'KID INFO REX BAZEMO JONAS'),
(4198, 'KID INFO REX BETHEL LAVERIE'),
(4155, 'KID INFO REX BKE SERVICES'),
(4325, 'KID INFO REX BOKOIN SERVICES'),
(4154, 'KID INFO REX BOTO BOKA'),
(4231, 'KID INFO REX BRUNO GOBREDI'),
(4158, 'KID INFO REX CAUMYLAND'),
(4293, 'KID INFO REX CHALLA JOSE'),
(4267, 'KID INFO REX CHEICK ISMAEL'),
(4129, 'KID INFO REX COULIBALY MANH'),
(4171, 'KID INFO REX COULIBALY MOUSSA'),
(4216, 'KID INFO REX COULIBALY NAOMI'),
(4305, 'KID INFO REX DAKPA SERVICE'),
(4238, 'KID INFO REX DAMONOKO BORIS'),
(4169, 'KID INFO REX DAOUDA KONE'),
(4130, 'KID INFO REX DEGRI AUGUSTE'),
(4202, 'KID INFO REX DIABATE ABDOUL'),
(4174, 'KID INFO REX DIALLO SOULEYMANE'),
(4241, 'KID INFO REX DIARRA COMMUNICATION'),
(4264, 'KID INFO REX DIARRA LANDRY'),
(4272, 'KID INFO REX DIE GONDO'),
(4331, 'KID INFO REX DIEUDONNE'),
(4139, 'KID INFO REX DJIGUENDE MOUSSA'),
(4274, 'KID INFO REX DJIMAN ALIDUHU'),
(4281, 'KID INFO REX DOSSA JUNIOR'),
(4320, 'KID INFO REX DOSSO'),
(4324, 'KID INFO REX DOSSO MEDIABA'),
(4131, 'KID INFO REX DRO VAH ANGE'),
(4260, 'KID INFO REX EBENEZER BUSINESS'),
(4321, 'KID INFO REX EDI DOFFOU'),
(4266, 'KID INFO REX EESS'),
(4269, 'KID INFO REX EKRA FABRICE'),
(4196, 'KID INFO REX ESSOH MAURIEL'),
(4295, 'KID INFO REX ESTERIN'),
(4140, 'KID INFO REX ETABLISSEMENT DJEGNA'),
(4214, 'KID INFO REX ETHAN BODOUIN'),
(4244, 'KID INFO REX ETS GUELLASSEH'),
(4292, 'KID INFO REX FLORA YAO'),
(4271, 'KID INFO REX FRANCOISE ADOH'),
(4151, 'KID INFO REX GAD SERVICE 1'),
(4328, 'KID INFO REX GAMENE HAMED'),
(4297, 'KID INFO REX GBEHE FIDEL'),
(4310, 'KID INFO REX GBOBIA HENRI'),
(4286, 'KID INFO REX GEUGBEU RICHMOND'),
(4273, 'KID INFO REX GNAGBO BRICE'),
(4252, 'KID INFO REX GOHOUN OSSOKO'),
(4330, 'KID INFO REX GORE MIREILLE'),
(4233, 'KID INFO REX GOURI FULGENCE'),
(4253, 'KID INFO REX GOUZOU KOKO'),
(4205, 'KID INFO REX GOZIE SORO'),
(4163, 'KID INFO REX GRE WILFRIED'),
(4208, 'KID INFO REX HEAVEN SERVICE'),
(4311, 'KID INFO REX IRIWA'),
(4254, 'KID INFO REX JOSEPH CALICE'),
(4224, 'KID INFO REX JULIEN KONGNIVI'),
(4268, 'KID INFO REX KABLAN'),
(4257, 'KID INFO REX KADJANE AKA JEAN'),
(4211, 'KID INFO REX KANTE'),
(4259, 'KID INFO REX KASSI PHILIPPE'),
(4149, 'KID INFO REX KEKE MAZO ANNE'),
(4280, 'KID INFO REX KESSIE TOILY'),
(4258, 'KID INFO REX KK PAUL ALAIN'),
(4179, 'KID INFO REX KOBENAN PASCAL'),
(4296, 'KID INFO REX KODOU LANDRY'),
(4146, 'KID INFO REX KOFFI BI OSCAR'),
(4201, 'KID INFO REX KOMENAN HASSANE'),
(4157, 'KID INFO REX KONAN HERMANN'),
(4261, 'KID INFO REX KONAN VALERA'),
(4327, 'KID INFO REX KONE AWA'),
(4145, 'KID INFO REX KONE N''GANON'),
(4323, 'KID INFO REX KONE SEKOU'),
(4279, 'KID INFO REX KORIA JONAS'),
(4136, 'KID INFO REX KOTE FASHION'),
(4204, 'KID INFO REX KOUADIO AGOH'),
(4312, 'KID INFO REX KOUADIO KOUAME'),
(4137, 'KID INFO REX KOUAKOU EMMANUEL'),
(4153, 'KID INFO REX KOUAKOU SERGE'),
(4189, 'KID INFO REX KOUAKOU YAO'),
(4218, 'KID INFO REX KOUAME BLAISE'),
(4283, 'KID INFO REX KOUAME LANDRY'),
(4176, 'KID INFO REX KOUASSI EMMANUEL'),
(4170, 'KID INFO REX KOUMARE SIAKA'),
(4141, 'KID INFO REX KOUTCHELE LAMINOU'),
(4159, 'KID INFO REX LA TORIDE'),
(4304, 'KID INFO REX LOU LANDRY'),
(4288, 'KID INFO REX MARCEL KOUASSI N''GUESSAN'),
(4284, 'KID INFO REX MELAINE SERVICES'),
(4191, 'KID INFO REX MELEDJE RAOUL'),
(4132, 'KID INFO REX MMD'),
(4147, 'KID INFO REX MOUMOUNI OUATTARA'),
(4294, 'KID INFO REX MOUSSA DOUMBIA'),
(4301, 'KID INFO REX NALO HASSANE'),
(4133, 'KID INFO REX NASSUA GROUPE'),
(4329, 'KID INFO REX NGOUAN CHARLES'),
(4239, 'KID INFO REX NOAH MULTISERVICE'),
(4188, 'KID INFO REX NOBA PEA ANGE'),
(4247, 'KID INFO REX OLIVIER TAPE'),
(4316, 'KID INFO REX OPI OURA'),
(4207, 'KID INFO REX OUATTARA ADAMA'),
(4190, 'KID INFO REX OUEHI JONAS'),
(4138, 'KID INFO REX OUGUESS'),
(4326, 'KID INFO REX OUMAR MAIGA'),
(4199, 'KID INFO REX PHILLIPE CEDRIC NGUESSAN'),
(4161, 'KID INFO REX SAN GEL'),
(4232, 'KID INFO REX SEFON OMAR'),
(4213, 'KID INFO REX SEKA BUSINESS'),
(4172, 'KID INFO REX SEKA GERMAIN'),
(4143, 'KID INFO REX SEKA PATERNE'),
(4302, 'KID INFO REX SHALOM INFO'),
(4262, 'KID INFO REX SILUE KOGNON'),
(4160, 'KID INFO REX SL SERVICE'),
(4226, 'KID INFO REX SMR'),
(4227, 'KID INFO REX SOFINTEC'),
(4175, 'KID INFO REX SORO DAOUDA'),
(4134, 'KID INFO REX SOUMAHILA LAWANI'),
(4300, 'KID INFO REX SOUMAHORO ABOUBACAR'),
(4162, 'KID INFO REX SOUMAHORO IB'),
(4183, 'KID INFO REX STAND AFRIQUIA'),
(4228, 'KID INFO REX STAND KOWEIT'),
(4265, 'KID INFO REX STAND PALAIS'),
(4298, 'KID INFO REX TA DIOMANDE BAKARY'),
(4249, 'KID INFO REX TA DOUDOU SEGUY'),
(4220, 'KID INFO REX TA EUVRARD'),
(4250, 'KID INFO REX TA KOFFI HERVE'),
(4291, 'KID INFO REX TA KRA KOBENAN'),
(4251, 'KID INFO REX TA NGUESSAN ROGER'),
(4225, 'KID INFO REX TA YAO ETIENNE'),
(4237, 'KID INFO REX TALL KALID'),
(4166, 'KID INFO REX TANO DE PAUL'),
(4148, 'KID INFO REX TANOH DIDIER'),
(4187, 'KID INFO REX TANOH KOFFI'),
(4144, 'KID INFO REX TENAN COULIBALY'),
(4206, 'KID INFO REX TERA LA BASSE'),
(4212, 'KID INFO REX TIEMELE KOUADIO'),
(4156, 'KID INFO REX TMA MULTISERVICE'),
(4177, 'KID INFO REX TOURE MOHAMED'),
(4299, 'KID INFO REX TOURE SICOGI'),
(4165, 'KID INFO REX TRAORE OUMAR'),
(4203, 'KID INFO REX TUEGNAN'),
(4195, 'KID INFO REX VANGAH MAURICE'),
(4275, 'KID INFO REX YAMA STORE'),
(4276, 'KID INFO REX YANICK OLLIA'),
(4142, 'KID INFO REX YAO AHOU NATALIE'),
(4194, 'KID INFO REX YAO AMENAN'),
(4192, 'KID INFO REX YOBOUE NIANKE'),
(4150, 'KID INFO REX YOLO ULRICH'),
(4287, 'KID INFO REX YONEBA RICHVIE'),
(4135, 'KID INFO REX ZOZO LIKPIA'),
(4083, 'KID INFO RK SERVICES'),
(3969, 'KID INFO ROBUS FINANCES'),
(4011, 'KID INFO ROYA CHALLENGE FINANCE'),
(3916, 'KID INFO SAGA DISTRIBUTION'),
(3970, 'KID INFO SANGARE COMMUNICATION'),
(3808, 'KID INFO SANTAL DISTRIBUTION'),
(3894, 'KID INFO SATI'),
(3964, 'KID INFO SCHADO CHRIST'),
(3939, 'KID INFO SCIRIT'),
(3885, 'KID INFO SERVICES KANGA'),
(3942, 'KID INFO SHILOH ENTREPRISE'),
(3872, 'KID INFO SIKA IVOIRE'),
(3907, 'KID INFO SJK ENTREPRISE'),
(4065, 'KID INFO SK SERVICES'),
(3824, 'KID INFO SMS'),
(3821, 'KID INFO SMS NIANGON'),
(3993, 'KID INFO SNACO DISTRIBUTION'),
(4019, 'KID INFO SOFINTEC'),
(3959, 'KID INFO SONAN COMMUNICATION'),
(4128, 'KID INFO SORO DISTRIBUTION'),
(4091, 'KID INFO SOURALEY'),
(4240, 'KID INFO STAR PRESSING'),
(3805, 'KID INFO STATION'),
(3953, 'KID INFO STRAMO'),
(3945, 'KID INFO SUCCES ASSURANCE'),
(3925, 'KID INFO TF SERVICE'),
(4223, 'KID INFO TH ACHIE CLAUDE'),
(4317, 'KID INFO TH COULIBALY DJENEBA'),
(4234, 'KID INFO TH KOKO VINCENT'),
(4235, 'KID INFO TH KOUAME KOFFI'),
(4222, 'KID INFO TH KOUASSI KOUAKOU'),
(4315, 'KID INFO TH PALE PRIVAT'),
(4075, 'KID INFO THIN ET FRERES'),
(3981, 'KID INFO TOP SERVICE'),
(4031, 'KID INFO TOULO ENOCK'),
(4023, 'KID INFO TOUT EST GRÂCE'),
(4043, 'KID INFO TOUT EST GRÂCE COMMUNICATION'),
(4278, 'KID INFO TRAORE SERVICE'),
(4332, 'KID INFO VAD BINOME'),
(4333, 'KID INFO VAD MOBILE'),
(4102, 'KID INFO VCS'),
(3849, 'KID INFO VCS 2'),
(3868, 'KID INFO VICTOIRE DISTRIBUTION'),
(4067, 'KID INFO VISION+ SELMER'),
(3801, 'KID INFO VISION+NUMERIQUE'),
(4322, 'KID INFO WILLY BAYALLA'),
(3935, 'KID INFO YAD CONCEPTION'),
(3973, 'KID INFO YAGNIGUE DISTRIBUTION'),
(4099, 'KID INFO YAHVE SHALOM SERVICE'),
(4010, 'KID INFO YAK SERVICES BUSINESS CENTER'),
(3936, 'KID INFO YANN MULTISERVICES'),
(3949, 'KID INFO YATANA ABOBODOUME'),
(3814, 'KID INFO YATANA BUSINESS'),
(3811, 'KID INFO YEKIN-BA YOP'),
(3975, 'KID INFO YEKOB'),
(3917, 'KID INFO YEO MARIAM MONTENNE'),
(3932, 'KID INFO YEO SOULEYMANE'),
(3960, 'KID INFO YEO.COM'),
(4027, 'KID INFO YKF (GRACE DIVINE)'),
(3800, 'KID INFO YOP FICGAYO'),
(3870, 'KID INFO YOUL COMM ET FRERES'),
(3920, 'KID INFO YVES MULTISERVIES'),
(3962, 'KID INFO ZAGEN DISTRIBUTION'),
(3829, 'KID INFO ZONGO BANCO 2'),
(4032, 'KID INFO ZTA COMMUNICATION'),
(4337, 'MOOV CIV'),
(4336, 'MTN CI'),
(4335, 'ORANGE CIV'),
(4334, 'WAVE CIV');


CREATE TABLE IF NOT EXISTS `crm_tickets_sup_infos_tab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_number_v` varchar(255) NOT NULL,
  `jungnability_id_n` int(11) NOT NULL,
  `argumentation_id_n` int(11) DEFAULT NULL,
  `motif_refusal_id_n` int(11) DEFAULT NULL,
  `renewal_id_n` int(11) NOT NULL,
  `status_subscriber_id_n` int(11) NOT NULL,
  `recharging_point_id` int(11) NOT NULL,
  `start_datetime_d` date DEFAULT NULL,
  `end_datetime_d` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ticket_number_v` (`ticket_number_v`)
);


INSERT INTO `menu_details_tab` (`topmenu_id_n`, `parent_menu_id`, `menu_name_v`, `menu_desc_v`, `page_link_v`, `language_id_n`, `menu_order_n`, `char_field_1`, `char_field_2`, `char_field_3`, `char_field_4`, `char_field_5`, `backup_level_n`, `status_n`) VALUES (114, 22, 'Point rechargement', 'Point rechargement', 'scc_adm_recharging_point.php', 0, 9, 'products/scc/', '1+2+3', NULL, NULL, NULL, NULL, 0),
(115, 22, 'Statut abonné', 'Statut abonné', 'scc_adm_status_subscriber.php', 0, 9, 'products/scc/', '1+2+3', NULL, NULL, NULL, NULL, 0);

**********fin insertion table ********

*********page modifié et ajouter ***********

new:get_argumentation_dtls.php