-- MySQL dump 10.4 -- -- Host: localhost Database: admintmsi -- ------------------------------------------------------ -- Server version 5.0.0-alpha-max-debug-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT, CHARACTER_SET_CLIENT=utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */; -- -- Current Database: admintmsi -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ admintmsi; USE admintmsi; -- -- Table structure for table `diag_cpt_application` -- DROP TABLE IF EXISTS diag_cpt_application; CREATE TABLE diag_cpt_application ( code_cptappli decimal(5,0) NOT NULL default '0', no_diag bigint(20) unsigned default NULL, valeur_cptappli decimal(5,0) NOT NULL default '0', KEY pk_DIAG_cpt_application (no_diag,code_cptappli), CONSTRAINT `0_345` FOREIGN KEY (`no_diag`) REFERENCES `diag_identite_diag` (`no_diag`) ON DELETE CASCADE ); -- -- Dumping data for table `diag_cpt_application` -- /*!40000 ALTER TABLE diag_cpt_application DISABLE KEYS */; LOCK TABLES diag_cpt_application WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_cpt_application ENABLE KEYS */; -- -- Table structure for table `diag_cpt_vie` -- DROP TABLE IF EXISTS diag_cpt_vie; CREATE TABLE diag_cpt_vie ( code_cptvie decimal(5,0) NOT NULL default '0', no_diag bigint(20) unsigned default NULL, valeur_cptvie decimal(5,0) NOT NULL default '0', KEY pk_DIAG_cpt_vie (no_diag,code_cptvie), CONSTRAINT `0_349` FOREIGN KEY (`no_diag`) REFERENCES `diag_identite_diag` (`no_diag`) ON DELETE CASCADE ); -- -- Dumping data for table `diag_cpt_vie` -- /*!40000 ALTER TABLE diag_cpt_vie DISABLE KEYS */; LOCK TABLES diag_cpt_vie WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_cpt_vie ENABLE KEYS */; -- -- Table structure for table `diag_defaut` -- DROP TABLE IF EXISTS diag_defaut; CREATE TABLE diag_defaut ( code_defaut decimal(5,0) NOT NULL default '0', no_diag bigint(20) unsigned default NULL, criticite_defaut decimal(1,0) default NULL, date_defaut datetime default NULL, KEY pk_DIAG_defaut (no_diag,code_defaut), CONSTRAINT `0_353` FOREIGN KEY (`no_diag`) REFERENCES `diag_identite_diag` (`no_diag`) ON DELETE CASCADE ); -- -- Dumping data for table `diag_defaut` -- /*!40000 ALTER TABLE diag_defaut DISABLE KEYS */; LOCK TABLES diag_defaut WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_defaut ENABLE KEYS */; -- -- Table structure for table `diag_descr_cat` -- DROP TABLE IF EXISTS diag_descr_cat; CREATE TABLE diag_descr_cat ( catalogue char(3) default NULL, produit varchar(50) default NULL ); -- -- Dumping data for table `diag_descr_cat` -- /*!40000 ALTER TABLE diag_descr_cat DISABLE KEYS */; LOCK TABLES diag_descr_cat WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_descr_cat ENABLE KEYS */; -- -- Table structure for table `diag_descr_cptappli` -- DROP TABLE IF EXISTS diag_descr_cptappli; CREATE TABLE diag_descr_cptappli ( code_cptappli decimal(5,0) NOT NULL default '0', lib_cptappli varchar(50) default NULL, type_appli varchar(50) default NULL, KEY pk_DIAG_DESCR_CPTAPPLI (code_cptappli) ); -- -- Dumping data for table `diag_descr_cptappli` -- /*!40000 ALTER TABLE diag_descr_cptappli DISABLE KEYS */; LOCK TABLES diag_descr_cptappli WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_descr_cptappli ENABLE KEYS */; -- -- Table structure for table `diag_descr_cptvie` -- DROP TABLE IF EXISTS diag_descr_cptvie; CREATE TABLE diag_descr_cptvie ( code_cptvie decimal(5,0) NOT NULL default '0', lib_cptvie varchar(50) default NULL, KEY pk_DIAG_DESCR_CPTvie (code_cptvie) ); -- -- Dumping data for table `diag_descr_cptvie` -- /*!40000 ALTER TABLE diag_descr_cptvie DISABLE KEYS */; LOCK TABLES diag_descr_cptvie WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_descr_cptvie ENABLE KEYS */; -- -- Table structure for table `diag_descr_defaut` -- DROP TABLE IF EXISTS diag_descr_defaut; CREATE TABLE diag_descr_defaut ( code_defaut decimal(5,0) NOT NULL default '0', lib_defaut varchar(50) default NULL, KEY pk_DIAG_DESCR_defaut (code_defaut) ); -- -- Dumping data for table `diag_descr_defaut` -- /*!40000 ALTER TABLE diag_descr_defaut DISABLE KEYS */; LOCK TABLES diag_descr_defaut WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_descr_defaut ENABLE KEYS */; -- -- Table structure for table `diag_identite_diag` -- DROP TABLE IF EXISTS diag_identite_diag; CREATE TABLE diag_identite_diag ( no_diag bigint(20) unsigned NOT NULL, date_debut datetime default NULL, date_fin datetime NOT NULL default '0000-00-00 00:00:00', tpe_id decimal(5,0) NOT NULL default '0', catalogue char(3) default NULL, texte varchar(50) default NULL, taille_ram decimal(11,0) default NULL, taille_flash decimal(11,0) default NULL, og_portable char(1) default NULL, og_printer char(1) default NULL, og_radio char(1) default NULL, og_buzzer char(1) default NULL, og_com0 char(1) default NULL, og_com1 char(1) default NULL, og_com2 char(1) default NULL, og_com3 char(1) default NULL, og_usbm char(1) default NULL, og_usbe char(1) default NULL, og_ethernet char(1) default NULL, og_b11 char(1) default NULL, og_b12 char(1) default NULL, og_b13 char(1) default NULL, og_b14 char(1) default NULL, og_b15 char(1) default NULL, or_iso1 char(1) default NULL, or_iso2 char(1) default NULL, or_iso3 char(1) default NULL, or_cam1 char(1) default NULL, or_cam2 char(1) default NULL, or_sam1 char(1) default NULL, or_sam2 char(1) default NULL, or_sam3 char(1) default NULL, or_sam4 char(1) default NULL, or_b9 char(1) default NULL, or_b10 char(1) default NULL, or_b11 char(1) default NULL, or_b12 char(1) default NULL, or_b13 char(1) default NULL, or_b14 char(1) default NULL, or_b15 char(1) default NULL, om_b0 char(1) default NULL, om_b1 char(1) default NULL, om_b2 char(1) default NULL, om_b3 char(1) default NULL, om_b4 char(1) default NULL, om_b5 char(1) default NULL, om_b6 char(1) default NULL, om_b7 char(1) default NULL, modem_country_mode decimal(5,0) default NULL, od_b0 char(1) default NULL, od_b1 char(1) default NULL, od_b2 char(1) default NULL, od_b3 char(1) default NULL, od_b4 char(1) default NULL, od_b5 char(1) default NULL, od_b6 char(1) default NULL, od_b7 char(1) default NULL, version_interface varchar(4) default NULL, oe_b0 char(1) default NULL, oe_b1 char(1) default NULL, oe_b2 char(1) default NULL, oe_b3 char(1) default NULL, oe_b4 char(1) default NULL, oe_b5 char(1) default NULL, oe_b6 char(1) default NULL, oe_b7 char(1) default NULL, carte_extension char(1) default NULL, ref_produit varchar(12) default NULL, version_thunder varchar(4) default NULL, version_booster varchar(4) default NULL, date_fabrication datetime default NULL, perso_materiel varchar(4) default NULL, perso_logiciel varchar(4) default NULL, zone_tid varchar(40) default NULL, UNIQUE KEY index_no_index (no_diag), UNIQUE KEY pk_diag_identite_diag (date_fin,tpe_id) ); -- -- Dumping data for table `diag_identite_diag` -- /*!40000 ALTER TABLE diag_identite_diag DISABLE KEYS */; LOCK TABLES diag_identite_diag WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_identite_diag ENABLE KEYS */; -- -- Table structure for table `diag_logiciel` -- DROP TABLE IF EXISTS diag_logiciel; CREATE TABLE diag_logiciel ( nom_logiciel varchar(15) NOT NULL default '', no_diag bigint(20) unsigned default NULL, code varchar(4) default NULL, no_audit bigint(20) unsigned default NULL, UNIQUE KEY pk_audit_diag_logiciel (nom_logiciel,no_audit,no_diag), KEY ind_diag_logiciel_nodiag (no_diag), KEY ind_diag_logiciel_noaudit (no_audit), CONSTRAINT `0_333` FOREIGN KEY (`no_audit`) REFERENCES `tbl_audit` (`AUDID`) ON DELETE CASCADE, CONSTRAINT `0_335` FOREIGN KEY (`no_diag`) REFERENCES `diag_identite_diag` (`no_diag`) ON DELETE CASCADE ); -- -- Dumping data for table `diag_logiciel` -- /*!40000 ALTER TABLE diag_logiciel DISABLE KEYS */; LOCK TABLES diag_logiciel WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE diag_logiciel ENABLE KEYS */; -- -- Table structure for table `pbcatcol` -- DROP TABLE IF EXISTS pbcatcol; CREATE TABLE pbcatcol ( pbc_tnam varchar(65) NOT NULL default '', pbc_tid int(11) default NULL, pbc_ownr varchar(65) NOT NULL default '', pbc_cnam varchar(65) NOT NULL default '', pbc_cid smallint(6) default NULL, pbc_labl varchar(254) default NULL, pbc_lpos smallint(6) default NULL, pbc_hdr varchar(254) default NULL, pbc_hpos smallint(6) default NULL, pbc_jtfy smallint(6) default NULL, pbc_mask varchar(31) default NULL, pbc_case smallint(6) default NULL, pbc_hght smallint(6) default NULL, pbc_wdth smallint(6) default NULL, pbc_ptrn varchar(31) default NULL, pbc_bmap char(1) default NULL, pbc_init varchar(254) default NULL, pbc_cmnt varchar(254) default NULL, pbc_edit varchar(31) default NULL, pbc_tag varchar(254) default NULL, UNIQUE KEY pbcatc_x (pbc_tnam,pbc_ownr,pbc_cnam) ); -- -- Dumping data for table `pbcatcol` -- /*!40000 ALTER TABLE pbcatcol DISABLE KEYS */; LOCK TABLES pbcatcol WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE pbcatcol ENABLE KEYS */; -- -- Table structure for table `pbcatedt` -- DROP TABLE IF EXISTS pbcatedt; CREATE TABLE pbcatedt ( pbe_name varchar(30) NOT NULL default '', pbe_edit varchar(254) default NULL, pbe_type smallint(6) default NULL, pbe_cntr int(11) default NULL, pbe_seqn smallint(6) NOT NULL default '0', pbe_flag int(11) default NULL, pbe_work varchar(32) default NULL, UNIQUE KEY pbcate_x (pbe_name,pbe_seqn) ); -- -- Dumping data for table `pbcatedt` -- /*!40000 ALTER TABLE pbcatedt DISABLE KEYS */; LOCK TABLES pbcatedt WRITE; INSERT INTO pbcatedt VALUES ('###,###.00','###,###.00',90,1,1,32,'10'),('#####','#####',90,1,1,32,'10'),('###-##-####','###-##-####',90,1,1,32,'00'),('MM/DD/YY','MM/DD/YY',90,1,1,32,'20'),('DD/MM/YY','DD/MM/YY',90,1,1,32,'20'),('MM/DD/YYYY','MM/DD/YYYY',90,1,1,32,'20'),('DD/MM/YYYY','DD/MM/YYYY',90,1,1,32,'20'),('DD/MMM/YY','DD/MMM/YY',90,1,1,32,'20'),('JJJ/YY','JJJ/YY',90,1,1,32,'20'),('JJJ/YYYY','JJJ/YYYY',90,1,1,32,'20'),('HH:MM:SS','HH:MM:SS',90,1,1,32,'30'),('HH:MM:SS:FFF','HH:MM:SS:FFF',90,1,1,32,'30'),('HH:MM:SS:FFFFFF','HH:MM:SS:FFFFFF',90,1,1,32,'30'),('MM/DD/YY HH:MM:SS','MM/DD/YY HH:MM:SS',90,1,1,32,'40'),('DD/MM/YY HH:MM:SS','DD/MM/YY HH:MM:SS',90,1,1,32,'40'),('MM/DD/YYYY HH:MM:SS','MM/DD/YYYY HH:MM:SS',90,1,1,32,'40'),('DD/MM/YYYY HH:MM:SS','DD/MM/YYYY HH:MM:SS',90,1,1,32,'40'),('DD/MMM/YY HH:MM:SS','DD/MMM/YY HH:MM:SS',90,1,1,32,'40'),('JJJ/YY HH:MM:SS','JJJ/YY HH:MM:SS',90,1,1,32,'40'),('JJJ/YYYY HH:MM:SS','JJJ/YYYY HH:MM:SS',90,1,1,32,'40'),('DD/MM/YY HH:MM:SS:FFFFFF','DD/MM/YY HH:MM:SS:FFFFFF',90,1,1,32,'40'); UNLOCK TABLES; /*!40000 ALTER TABLE pbcatedt ENABLE KEYS */; -- -- Table structure for table `pbcatfmt` -- DROP TABLE IF EXISTS pbcatfmt; CREATE TABLE pbcatfmt ( pbf_name varchar(30) NOT NULL default '', pbf_frmt varchar(254) default NULL, pbf_type smallint(6) default NULL, pbf_cntr int(11) default NULL, UNIQUE KEY pbcatf_x (pbf_name) ); -- -- Dumping data for table `pbcatfmt` -- /*!40000 ALTER TABLE pbcatfmt DISABLE KEYS */; LOCK TABLES pbcatfmt WRITE; INSERT INTO pbcatfmt VALUES ('[General]','[General]',81,0),('0','0',81,0),('0.00','0.00',81,0),('#,##0','#,##0',81,0),('#,##0.00','#,##0.00',81,0),('$#,##0;($#,##0)','$#,##0;($#,##0)',81,0),('$#,##0;[RED]($#,##0)','$#,##0;[RED]($#,##0)',81,0),('$#,##0.00;($#,##0.00)','$#,##0.00;($#,##0.00)',81,0),('$#,##0.00;[RED]($#,##0.00)','$#,##0.00;[RED]($#,##0.00)',81,0),('0%','0%',81,0),('0.00%','0.00%',81,0),('0.00E+00','0.00E+00',81,0),('m/d/yy','m/d/yy',84,0),('d-mmm-yy','d-mmm-yy',84,0),('d-mmm','d-mmm',84,0),('mmm-yy','mmm-yy',84,0),('h:mm AM/PM','h:mm AM/PM',84,0),('h:mm:ss AM/PM','h:mm:ss AM/PM',84,0),('h:mm:ss','h:mm:ss',84,0),('m/d/yy h:mm','m/d/yy h:mm',84,0); UNLOCK TABLES; /*!40000 ALTER TABLE pbcatfmt ENABLE KEYS */; -- -- Table structure for table `pbcattbl` -- DROP TABLE IF EXISTS pbcattbl; CREATE TABLE pbcattbl ( pbt_tnam varchar(65) NOT NULL default '', pbt_tid int(11) default NULL, pbt_ownr varchar(65) NOT NULL default '', pbd_fhgt smallint(6) default NULL, pbd_fwgt smallint(6) default NULL, pbd_fitl char(1) default NULL, pbd_funl char(1) default NULL, pbd_fchr smallint(6) default NULL, pbd_fptc smallint(6) default NULL, pbd_ffce varchar(18) default NULL, pbh_fhgt smallint(6) default NULL, pbh_fwgt smallint(6) default NULL, pbh_fitl char(1) default NULL, pbh_funl char(1) default NULL, pbh_fchr smallint(6) default NULL, pbh_fptc smallint(6) default NULL, pbh_ffce varchar(18) default NULL, pbl_fhgt smallint(6) default NULL, pbl_fwgt smallint(6) default NULL, pbl_fitl char(1) default NULL, pbl_funl char(1) default NULL, pbl_fchr smallint(6) default NULL, pbl_fptc smallint(6) default NULL, pbl_ffce varchar(18) default NULL, pbt_cmnt varchar(254) default NULL, UNIQUE KEY pbcatt_x (pbt_tnam,pbt_ownr) ); -- -- Dumping data for table `pbcattbl` -- /*!40000 ALTER TABLE pbcattbl DISABLE KEYS */; LOCK TABLES pbcattbl WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE pbcattbl ENABLE KEYS */; -- -- Table structure for table `pbcatvld` -- DROP TABLE IF EXISTS pbcatvld; CREATE TABLE pbcatvld ( pbv_name varchar(30) NOT NULL default '', pbv_vald varchar(254) default NULL, pbv_type smallint(6) default NULL, pbv_cntr int(11) default NULL, pbv_msg varchar(254) default NULL, UNIQUE KEY pbcatv_x (pbv_name) ); -- -- Dumping data for table `pbcatvld` -- /*!40000 ALTER TABLE pbcatvld DISABLE KEYS */; LOCK TABLES pbcatvld WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE pbcatvld ENABLE KEYS */; -- -- Table structure for table `seq_merchant` -- DROP TABLE IF EXISTS seq_merchant; CREATE TABLE seq_merchant ( seq mediumint(8) unsigned NOT NULL default '0' ); -- -- Dumping data for table `seq_merchant` -- /*!40000 ALTER TABLE seq_merchant DISABLE KEYS */; LOCK TABLES seq_merchant WRITE; INSERT INTO seq_merchant VALUES (0); UNLOCK TABLES; /*!40000 ALTER TABLE seq_merchant ENABLE KEYS */; -- -- Table structure for table `tbl_action` -- DROP TABLE IF EXISTS tbl_action; CREATE TABLE tbl_action ( ACTNUMBER decimal(5,0) NOT NULL default '0', ACTLABEL varchar(60) default NULL, actdisplay decimal(2,0) default NULL, UNIQUE KEY PK_TBL_ACTION (ACTNUMBER) ); -- -- Dumping data for table `tbl_action` -- /*!40000 ALTER TABLE tbl_action DISABLE KEYS */; LOCK TABLES tbl_action WRITE; INSERT INTO tbl_action VALUES ("1",'Login',"0"),("2",'Logout',"0"),("3",'Echec de login',"0"),("10",'Dongle absent',"0"),("11",'Expiration du dongle dans (jours)',"0"),("12",'Date d utilisation échue',"0"),("50",'COM:Perte porteuse',"0"),("51",'COM:Pas de réponse du TPE',"0"),("52",'COM:Refus de communication du TPE',"0"),("100",'TC:Perte porteuse',"1"),("101",'TC:Pas de réponse du TPE',"1"),("102",'TC:Refus communication du TPE',"1"),("103",'TC:Message d identification TPE inconnu',"1"),("104",'TC:Type TPE inconnu',"1"),("105",'TC:Mode d appel non autorisé',"1"),("106",'TC:Numéro de session inconnu',"1"),("107",'TC:Liste des logiciels affectés incohérente',"1"),("108",'TC:Liste sans système',"1"),("109",'TC:TPE sans affectation Logiciel',"1"),("110",'TC:Présence composant système (EFT10)',"1"),("111",'TC:Nombre d applications trop important',"1"),("112",'TC:Nombre de composants système trop important',"1"),("113",'TC:Chargement application impossible (mémoire insuffisante)',"1"),("114",'TC:Chargement système impossible (mémoire insuffisante)',"1"),("115",'TC:Refus d un segment par le TPE',"1"),("116",'TC:Autres errreurs',"1"),("117",'TC:Réalisé',"1"),("118",'TC:Détection de reprise',"1"),("119",'TC:Test de migration réussi',"1"),("120",'TC:Test de migration échoué',"1"),("125",'TC:Erreur Tentative Migration Logiciel Multi-Commerce',"1"),("126",'TL:Ajout de logiciel',"1"),("127",'TL:Retrait de logiciel',"1"),("150",'TD:Perte porteuse',"0"),("151",'TD:Pas de réponse du TPE',"0"),("152",'TD:Refus de communication du TPE',"0"),("153",'TD:Message d identification TPE inconnu',"0"),("155",'TD:Appel non autorisé',"0"),("166",'TD:Autres erreurs',"0"),("167",'TD:Réalisé',"0"),("200",'TP:Perte porteuse',"0"),("201",'TP:Pas de réponse du TPE',"0"),("202",'TP:Refus communication du TPE',"0"),("203",'TP:Message d identification TPE inconnu',"0"),("205",'TP:Mode d appel non autorisé',"0"),("206",'TP:Conflit nommage fichier',"0"),("215",'TP:Refus d un fichier de paramètres',"0"),("216",'TP:Autres erreurs',"0"),("217",'TP:Réalisé',"0"),("300",'Mode d appel non autorisé',"0"),("301",'TPE sans affectation logiciel',"0"),("401",'Expiration de reprise',"0"),("402",'Numéro de session inconnu',"0"),("500",'Affect. Logiciel à TPE',"0"),("501",'Affect. Param. à TPE',"0"),("502",'Affect. Broadcast à TPE',"0"),("503",'Affect. Logiciel à commerçant',"0"),("504",'Affect. Param. à commerçant',"0"),("505",'Affect. Broadcast à commerçant',"0"),("506",'Affect. Logiciel à groupe',"0"),("507",'Affect. param. à groupe',"0"),("508",'Affect. Broadcast à groupe',"0"),("600",'Ajout logiciel',"0"),("601",'Modification logiciel',"0"),("602",'Suppression logiciel',"0"),("603",'Erreur substituant',"0"),("605",'Ajout catalogue',"0"),("606",'Modification catalogue',"0"),("610",'Ajout param.',"0"),("611",'Modification param.',"0"),("612",'Suppression param.',"0"),("620",'Ajout broadcast',"0"),("621",'Modification broadcast',"0"),("622",'Suppression broadcast',"0"),("630",'Ajout TPE',"0"),("631",'Modification TPE',"0"),("632",'Suppression d un TPE',"0"),("633",'Ajout TPE - données d activation',"0"),("640",'Ajout commerçant',"0"),("641",'Modification commerçant',"0"),("642",'Suppression commerçant',"0"),("700",'Ajout groupe logiciel',"0"),("701",'Modification groupe logiciel',"0"),("702",'Suppression groupe logiciel',"0"),("710",'Ajout groupe param.',"0"),("711",'Modification groupe parametre',"0"),("712",'Suppression groupe parametre',"0"),("720",'Ajout groupe broadcast',"0"),("721",'Modification groupe broadcast',"0"),("722",'Suppression groupe broadcast',"0"),("730",'Modification profil',"0"),("740",'Ajout utilisateur',"0"),("741",'Modification utilisateur',"0"),("742",'Suppression utilisateur',"0"),("750",'Ajout opérateur',"0"),("751",'Modification opérateur',"0"),("752",'Suppression opérateur',"0"),("760",'Ajout mainteneur',"0"),("761",'Modification mainteneur',"0"),("762",'Suppression mainteneur',"0"),("770",'Ajout regroupement système',"0"),("771",'Modification regr système',"0"),("772",'Suppression regr système',"0"),("773",'Contenu regroupement système',"0"),("780",'Ajout famille',"0"),("781",'Modification famille',"0"),("782",'Suppression famille',"0"),("783",'Regroupements syst. de famille',"0"),("784",'Logiciels de famille',"0"),("790",'Modif. niveau critère type gpe',"0"),("800",'Modif. niveau critère param',"0"),("810",'Modification planning',"0"),("820",'Ajout ligne',"0"),("821",'Modification ligne',"0"),("822",'Suppression ligne',"0"),("830",'Ajout code produit',"0"),("831",'Modification code produit',"0"),("832",'Suppression code produit',"0"),("2000",'Fichier Activation incorrect',"0"),("2001",'Archivage Fichier Activation incorrect',"0"),("5000",'Identification invalide',"0"),("5001",'Terminal inconnu',"0"),("5002",'Pas d activité',"0"),("5003",'Pas de porteuse',"0"),("5004",'refus de communication',"0"),("5005",'nom de fichier invalide',"0"),("5006",'Autres erreurs',"0"),("5054",'TD:activité inconnue',"0"),("5055",'TD:Nom de fichier invalide',"0"),("5056",'TD:erreur lecture fichier',"0"),("5057",'TD:erreur connexion FTP',"0"),("5058",'TD:time out connexion FTP',"0"),("5059",'TD:signature invalide',"0"),("5060",'TD:erreur stockage sur TPE',"0"),("5061",'TD:ACTIVITY.INF invalide',"0"),("5062",'TD:RUNNING.LST invalide',"0"),("5063",'TD:mémoire disponible invalide',"0"),("5104",'TP:activité inconnue',"0"),("5105",'TP:Nom de fichier invalide',"0"),("5106",'TP:erreur lecture fichier',"0"),("5107",'TP:absence fichier de paramètre',"0"),("5108",'TP:paramètres déjà mis à jour',"0"),("5109",'TP:erreur connexion FTP',"0"),("5110",'TP:time out connexion FTP',"0"),("5111",'TP:signature invalide',"0"),("5112",'TP:erreur stockage sur TPE',"0"),("5113",'TP:ACTIVITY.INF invalide',"0"),("5114",'TP:RUNNING.LST invalide',"0"),("5115",'TP:mémoire disponible invalide',"0"),("5154",'TC:activité inconnue',"1"),("5156",'TC:Nom de fichier invalide',"1"),("5157",'TC:Erreur lecture fichier',"1"),("5160",'TC:rien à charger',"1"),("5161",'TC:erreur connexion FTP',"1"),("5162",'TC:time out connexion FTP',"1"),("5163",'TC:signature invalide',"1"),("5164",'TC:erreur stockage sur TPE',"1"),("5165",'TC:ACTIVITY.INF invalide',"1"),("5166",'TC:RUNNING.LST invalide',"1"),("5167",'TC:mémoire disponible invalide',"1"),("5200",'Activité refusée',"0"),("5201",'Activité en erreur',"0"),("5202",'Réalisé',"0"),("5250",'TC: Paramètres de la trame identification IORP invalides',"1"),("5251",'TC: Nom de logiciel invalide',"1"),("5252",'TC: Module incompatible avec le TPE',"1"),("5253",'TC: pas assez d entrées libres lors de la création sur TPE',"1"),("5254",'TC: Pas assez d espace libre sur TPE. GC nécessaire',"1"),("5255",'TC: Acquittement négatif suite à une requête IO',"1"),("5256",'TC: Echec requête IO',"1"),("5257",'TC: Opération sur fichier du TPE invalide ou échouée',"1"),("5258",'TC: Chargement annulé par l utilisateur',"1"),("5259",'TC: Modules supprimés sur TPE',"1"),("5260",'TC: Erreur TPE occupé',"1"); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_action ENABLE KEYS */; -- -- Table structure for table `tbl_audit` -- DROP TABLE IF EXISTS tbl_audit; CREATE TABLE tbl_audit ( AUDID bigint(20) unsigned NOT NULL, ACTNUMBER decimal(5,0) NOT NULL default '0', AUDDATE datetime NOT NULL default '0000-00-00 00:00:00', AUDWHO varchar(30) default NULL, AUDWHAT varchar(60) default NULL, AUDOLDDATA text, AUDNEWDATA text, UNIQUE KEY PK_TBL_AUDIT (AUDID), KEY TBL_AUDIT_ACTION_FK (ACTNUMBER), CONSTRAINT `0_225` FOREIGN KEY (`ACTNUMBER`) REFERENCES `tbl_action` (`ACTNUMBER`) ); -- -- Dumping data for table `tbl_audit` -- /*!40000 ALTER TABLE tbl_audit DISABLE KEYS */; LOCK TABLES tbl_audit WRITE; INSERT INTO tbl_audit VALUES (1,"50",'2004-06-15 10:00:33','','','',''),(2,"102",'2004-06-15 10:12:48',', 123456789,','UPDCOMPO.LST','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(3,"5160",'2004-06-15 10:28:27',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(4,"5160",'2004-06-15 10:36:16',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(5,"5160",'2004-06-15 10:45:57',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(6,"50",'2004-06-15 11:56:13','','','',''),(7,"102",'2004-06-15 12:03:54',', 123456789,','RUNNING.LST','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(8,"102",'2004-06-15 12:35:28',', 123456789,','ACTIVITY.INF','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224'),(9,"51",'2004-06-15 13:32:20','','','',''),(10,"105",'2004-06-15 13:41:51','','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(11,"105",'2004-06-15 13:43:52','','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(12,"105",'2004-06-15 13:46:02','','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(13,"5163",'2004-06-15 15:07:38',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(14,"5163",'2004-06-15 15:11:10',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(15,"5163",'2004-06-15 15:28:09',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(16,"116",'2004-06-15 15:35:32',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(17,"116",'2004-06-15 15:40:56',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(18,"116",'2004-06-15 15:43:11',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(19,"105",'2004-06-16 15:29:00','','','tms-srv - RTC - 001','M300101SAGEM_MO020311 0000000000001224 # '),(20,"5160",'2004-06-16 15:29:39',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(21,"105",'2004-06-16 15:31:21','','','tms-srv - RTC - 001','M300101SAGEM_MO020311 0000000000001224 # '),(22,"5160",'2004-06-16 15:31:48',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(23,"5160",'2004-06-16 15:36:35',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(24,"5160",'2004-06-16 15:36:55',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(25,"116",'2004-06-16 15:54:17',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(26,"102",'2004-06-16 15:54:18',', 123456789,','38080207.BIN','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(27,"116",'2004-06-16 16:16:08',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(28,"116",'2004-06-16 16:17:09',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(29,"116",'2004-06-16 16:23:14',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(30,"5163",'2004-06-16 16:23:29',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(31,"116",'2004-06-16 16:37:47',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(32,"102",'2004-06-16 16:38:22',', 123456789,','38080207.BIN','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(33,"5160",'2004-06-16 16:42:48',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(34,"5160",'2004-06-16 16:45:01',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(35,"5160",'2004-06-16 16:53:20',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(36,"5160",'2004-06-16 16:58:22',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(37,"5160",'2004-06-16 17:01:38',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(38,"116",'2004-06-16 17:06:11',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(39,"5163",'2004-06-16 17:06:30',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(40,"102",'2004-06-16 17:15:56',', 123456789,','RUNNING.LST','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(41,"5160",'2004-06-16 17:24:18',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(42,"102",'2004-06-16 17:41:42',', 123456789,','38080207.BIN','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(43,"117",'2004-06-16 17:53:04',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(44,"5003",'2004-06-16 17:56:59','','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224'),(45,"117",'2004-06-17 14:23:38',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(46,"5160",'2004-06-17 14:57:10',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(47,"116",'2004-06-17 14:59:35',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(48,"5163",'2004-06-17 14:59:37',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(49,"116",'2004-06-17 15:18:51',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(50,"5163",'2004-06-17 15:19:08',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(51,"50",'2004-06-17 15:43:11','','','',''),(52,"116",'2004-06-17 15:49:31',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(53,"5163",'2004-06-17 15:49:48',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(54,"5160",'2004-06-18 10:50:28',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(55,"5160",'2004-06-18 10:52:29',', 123456789,','','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(56,"102",'2004-06-18 10:53:30',', 123456789,','38080207.BIN','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(57,"102",'2004-06-18 10:56:38',', 123456789,','38080207.BIN','tms-srv - RTC - 001','M300101SAGEM_MO020311234567890000000000001224 # '),(58,"117",'2004-06-18 10:57:52',', 123456789,','','tms-srv - RTC - 002','M300101SAGEM_MO020311234567890000000000000660 # '),(59,"3",'2004-06-18 12:02:47','admintmsadmin',NULL,NULL,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_audit ENABLE KEYS */; -- -- Table structure for table `tbl_broadcast` -- DROP TABLE IF EXISTS tbl_broadcast; CREATE TABLE tbl_broadcast ( BROMESSID mediumint(8) unsigned NOT NULL, BROMESSNAME varchar(30) NOT NULL default '', BROMESSFROM char(1) NOT NULL default '', BROMESSDEST char(1) NOT NULL default '', BROMESSCONTENT text NOT NULL, BROMESSDATE datetime default NULL, BROMESSHOUR datetime default NULL, BROMESSFREQ decimal(5,0) default NULL, BROMESSNB decimal(5,0) default NULL, BROMESSCOMMENT varchar(250) default NULL, UNIQUE KEY PK_TBL_BROADCAST (BROMESSID) ); -- -- Dumping data for table `tbl_broadcast` -- /*!40000 ALTER TABLE tbl_broadcast DISABLE KEYS */; LOCK TABLES tbl_broadcast WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_broadcast ENABLE KEYS */; -- -- Table structure for table `tbl_broadcastgrp` -- DROP TABLE IF EXISTS tbl_broadcastgrp; CREATE TABLE tbl_broadcastgrp ( BROADGRPID mediumint(8) unsigned NOT NULL, CRITNAME varchar(30) NOT NULL default '', BROADGRPNAME varchar(30) NOT NULL default '', BROADFILTER varchar(30) default NULL, BROADGRPPARENTID decimal(5,0) default NULL, BROADGRPCOMMENT varchar(250) default NULL, BROADGRPFROM char(1) NOT NULL default '', UNIQUE KEY PK_TBL_BROADCASTGRP (BROADGRPID), KEY TBL_CRIT_BROADCASTGRP_FK (CRITNAME), CONSTRAINT `0_189` FOREIGN KEY (`CRITNAME`) REFERENCES `tbl_criterium` (`CRITNAME`) ); -- -- Dumping data for table `tbl_broadcastgrp` -- /*!40000 ALTER TABLE tbl_broadcastgrp DISABLE KEYS */; LOCK TABLES tbl_broadcastgrp WRITE; INSERT INTO tbl_broadcastgrp VALUES (1,'[None]','All operators','*',"0",'Group for all operators broadcast messages','O'),(2,'[None]','All field service providers','*',"0",'Group for all field service providers broadcast messages','F'),(3,'[None]','All Others','*',"0",'Group for all other broadcast messages','X'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_broadcastgrp ENABLE KEYS */; -- -- Table structure for table `tbl_bw_list` -- DROP TABLE IF EXISTS tbl_bw_list; CREATE TABLE tbl_bw_list ( nameradical varchar(7) default NULL, nameversion varchar(4) default NULL, bwtypelist char(1) default NULL, bwdependant varchar(11) default NULL, bwcomment varchar(250) default NULL, KEY TBL_BW_LIST_LOG_TYPE (nameradical,nameversion,bwtypelist) ); -- -- Dumping data for table `tbl_bw_list` -- /*!40000 ALTER TABLE tbl_bw_list DISABLE KEYS */; LOCK TABLES tbl_bw_list WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_bw_list ENABLE KEYS */; -- -- Table structure for table `tbl_catalog` -- DROP TABLE IF EXISTS tbl_catalog; CREATE TABLE tbl_catalog ( SOFTNAME varchar(11) NOT NULL default '', TPEPRODUCTNAME varchar(30) NOT NULL default '', SEGSOFTNAME varchar(30) NOT NULL default '', SEGCRC tinyblob NOT NULL, SEGCOMPRESSED char(1) NOT NULL default '', SEGIDNAME varchar(30) default NULL, SEGLOADADDRESS decimal(10,0) NOT NULL default '0', SEGTYPE decimal(3,0) default NULL, SEGSOFTSIZE decimal(10,0) default NULL, SEGDATASIZE decimal(10,0) default NULL, SEGFILESIZE decimal(10,0) default NULL, SEGFILELENGTH decimal(10,0) default NULL, UNIQUE KEY PK_TBL_CATALOG (SOFTNAME,TPEPRODUCTNAME), KEY LIEN_523_FK (SOFTNAME), KEY LIEN_524_FK (TPEPRODUCTNAME), CONSTRAINT `0_227` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`), CONSTRAINT `0_229` FOREIGN KEY (`TPEPRODUCTNAME`) REFERENCES `tbl_tpeproductcode` (`TPEPRODUCTNAME`) ); -- -- Dumping data for table `tbl_catalog` -- /*!40000 ALTER TABLE tbl_catalog DISABLE KEYS */; LOCK TABLES tbl_catalog WRITE; INSERT INTO tbl_catalog VALUES ('0650207','M30','30650207.bin','C312','N','30650207.ADF',"0","0","65536","57344","0","119468"),('8080207','M30','38080207.bin','B001','N','38080207.ADF',"0","0","151552","20480","0","160052"),('8130107','M30','38080207.bin','B001','N','38080207.ADF',"0","0","151552","20480","0","160052"),('8130110','M30','38130110.sgn','FA64','Y','38130110.adf',"0","0","164832","65536","0","113256"); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_catalog ENABLE KEYS */; -- -- Table structure for table `tbl_category` -- DROP TABLE IF EXISTS tbl_category; CREATE TABLE tbl_category ( CATEGCOD decimal(10,0) NOT NULL default '0', CATEGNAME varchar(250) NOT NULL default '', UNIQUE KEY PK_TBL_CATEGORY (CATEGCOD) ); -- -- Dumping data for table `tbl_category` -- /*!40000 ALTER TABLE tbl_category DISABLE KEYS */; LOCK TABLES tbl_category WRITE; INSERT INTO tbl_category VALUES ("0742",'Veterinary services'),("0763",'Agricultural cooperatives'),("0780",'Landscaping and horticultural services'),("1520",'General contractors-residential buildings'),("1711",'Heating, plumbing, air conditioning contractors'),("1731",'Electrical contractors'),("1740",'Masonry, stonework, tile setting, plastering, insulation contractors'),("1750",'Carpentry'),("1761",'Roofing and siding, sheet metal work'),("1771",'Concrete work'),("1799",'Special trade contractors, not elsewhere classified'),("4011",'Railroads'),("4111",'Local and suburban commuter passenger transportation, including ferries'),("4119",'Ambulance services'),("4121",'Taxicabs limousines'),("4131",'Bus lines, charters, tour buses'),("4214",'Motor freight carriers, trucking-local and long distance, moving and storage companies, local delivery'),("4215",'Courier services - air, ground, freight'),("4225",'Public warehousing - farm products, refrigerated goods, storage'),("4411",'Steamships, cruise Lines'),("4457",'Boat rentals, boat leases'),("4468",'Marinas, marine service-supplies'),("4511",'Airlines, air carriers'),("4582",'Airports, flying fields, airport terminals'),("4722",'Travel agencies'),("4761",'Telemarketing : travel related services, vitamins'),("4784",'Tolls, bridge fees'),("4789",'Transportation services, not elsewhere classified'),("4812",'Telecommunication equipement including telephone sales'),("4814",'Telecommunication service including local and long distance calls, credit card calls through use of magnetic stripe reading telephones, fax service'),("4821",'Telegraph services'),("4829",'Wire transfer, money orders'),("4899",'Cable services'),("4900",'Utilities - electric, gas, water, sanitary'),("5211",'Lumber, building materials stores'),("5231",'Glass, paint, wallpaper stores'),("5251",'Hardware stores'),("5261",'Nurseries, lawn, garden supply stores'),("5271",'Mobile home dealers'),("5310",'Discount stores'),("5311",'Departement stores'),("5331",'Variety stores'),("5399",'Miscellaneous general merchandise stores'),("5411",'Grocery stores, supermarkets'),("5422",'Freezer, locker meat provisioners'),("5441",'Candy, nut, confectionery stores'),("5451",'Dairy products stores'),("5462",'Bakeries'),("5499",'Miscellaneous food stores-speciality, markets, convenience'),("5511",'Automobile and truck dealers-(new and used)-sales, service, parts'),("5521",'Automobile and truck dealers-(used only) sales'),("5531",'Auto stores, home supply stores'),("5532",'Automotive tire stores'),("5533",'Automotive parts, accessories stores'),("5541",'Service stations'),("5542",'Automated gasoline dispensers'),("5551",'Boat dealers'),("5561",'Recreational and utility trailers, camper dealers'),("5571",'Motorcycle dealers'),("5592",'Motor home dealers'),("5598",'Snowmobile dealers'),("5599",'Miscellaneous automotive dealers, not elsewhere classified'),("5611",'Men\'s and boy clothing and accessory stores'),("5621",'Women\'s ready to wear stores'),("5631",'Women\'s accessory and specialty stores'),("5641",'Children\'s and infants\'wear stores'),("5651",'Family clothing stores'),("5655",'Sports apparel, riding apparel stores'),("5661",'Shoe stores'),("5681",'Furriers, fur shops'),("5691",'Men\'s and women\'s clothing stores'),("5697",'Tailors, seamstresses, mending, alterations'),("5698",'Wig and toupee stores'),("5699",'Miscellaneous apparel and accessory stores'),("5712",'Furniture, home furnishings and equipment stores, except appliance'),("5713",'Floor covering, rug and carpet stores'),("5714",'Drapery, window coverings, upholstery'),("5718",'Fireplace, fireplace screens and accessories stores'),("5719",'Miscellaneous home furnishing speciality stores'),("5722",'Household appliance stores'),("5732",'Radio, television and stereo stores'),("5733",'Music stores, musical instruments, piano, sheet music'),("5734",'Computer software stores'),("5735",'Record stores'),("5811",'Caterers'),("5812",'Eating places, restaurants'),("5813",'Drinking places (alcoholic beverages)-bars, taverns, nightclubs, cocktail lounges, discotheques'),("5814",'Fast food restaurants'),("5912",'Drug stores, pharmacies'),("5921",'Package stores, beer, wine, liquor'),("5931",'Used merchandise stores, second hand stores'),("5932",'Antique shops'),("5933",'Pawn shops'),("5935",'Wrecking and salvage yards'),("5937",'Antique reproduction stores'),("5940",'Bicycle shops-sales and service'),("5941",'Sporting goods stores'),("5942",'Book stores'),("5943",'Stationery, office and school supply stores'),("5944",'Jewelry, watches, clocks and silverware stores'),("5945",'Hobby, toy and games stores'),("5946",'Camera and photographic supply stores'),("5947",'Gift, card, novelty and souvenir stores'),("5948",'Luggage and leather goods stores'),("5949",'Sewing, needlework, fabric and piece goods stores'),("5950",'Glassware and crystal stores'),("5961",'Mail order houses including catalog order stores, book and record clubs'),("5963",'Direct selling establishments, door-to-door sales'),("5970",'Artist supply and craft stores'),("5971",'Art dealers and galleries'),("5972",'Stamp and coin stores - philatelic and numismatic supplies'),("5973",'Religious goods stores'),("5974",'Rubber stamp stores'),("5975",'Hearing aid sales, service, supply stores'),("5976",'Orthopedic goods-artifical limb stores'),("5977",'Cosmetic stores'),("5978",'typewriter stores - sales, service, rentals'),("5983",'Fuel dealers-Fuel oil, wood, coal, liquified petroleum'),("5992",'Florists'),("5993",'Cigar stores and stands'),("5994",'News dealers and newsstands'),("5995",'Pet shops, pet food and supplies'),("5996",'Swimming pools - sales and supplies'),("5997",'Elecrtic razor stores - sales and service'),("5998",'Tent and awning stores'),("5999",'Miscellaneous and speciality retail stores'),("6010",'Financial institutions-manual cash disbursements'),("6011",'financial institutions-automated cash disbursements'),("6012",'Financial institutions-Merchandise and services'),("6051",'Non financial institutions-foreign currency, money orders (not wire transfer), scrip travelers checks,postage stamps, and quasi cash'),("6211",'Securities - brokers and dealers'),("6300",'Insurance-sales and underwriting'),("6381",'Insurance premiums'),("6399",'Insurance, not elsewhere classified'),("6611",'Overpayments, reclamation'),("6760",'Savings bonds'),("7011",'Lodging-hotels, motels, resorts'),("7032",'Sporting and recreational camps, boy\'s and girl\'s camps'),("7033",'Trailer parks and campgrounds'),("7210",'Laundry, cleaning and garment services'),("7211",'Laundry services-Family and commercial'),("7216",'Dry cleaners'),("7217",'Carpet and upholstery cleaning'),("7221",'Photographic studios'),("7230",'Beauty shops, barber shops'),("7251",'Shoe repair shops, shoe shine parlors, hat cleaning shops'),("7261",'Funeral service and crematories'),("7273",'Dating and escort services'),("7276",'Tax preparation service'),("7277",'Counseling service - marriage, personal'),("7278",'Buying and shopping services, clubs'),("7279",'Counseling service - debt'),("7280",'Hospital patient personal funds withdrawal account'),("7295",'Babysitting services'),("7296",'Clothing rental - costumes, uniforms'),("7297",'Massage parlors'),("7298",'Health and beauty spas'),("7299",'Miscellaneous personal services, not elsewhere classified'),("7311",'Advertising services'),("7321",'Consumer credit reporting agencies'),("7322",'Debt collection agencies'),("7332",'Blueprinting and photocopying services'),("7333",'Commercial photography, art and graphics'),("7338",'Quick copy and reproduction services'),("7339",'Stenographic services'),("7341",'Window cleaning services'),("7342",'Exterminating and disinfecting services'),("7349",'Cleaning and maintenance, janitorial services'),("7361",'Employment agencies, temporary help services'),("7372",'Computer and data processing services'),("7389",'Telemarketing other than travel related services'),("7392",'Management, consulting, public relations services'),("7393",'Detective agencies, protective agencies, and security services including armored cars, guard dogs'),("7394",'Equipement rental and leasing services, tool rental, Furniture rental, appliance rental'),("7395",'Photorefinishing laboratories, photo developing'),("7399",'Business services, not elsewhere classified'),("7512",'Automobile rental and leasing'),("7513",'Truck and utility trailer rental'),("7519",'Motor home and recreational vehicle rental'),("7523",'Automobile parking lots and garages'),("7531",'Automotive body repair shops'),("7534",'Tire retreading and repair shops'),("7535",'Automotive paint shops'),("7538",'Automotive repair shops (non-dealer)'),("7542",'Car washes'),("7549",'Towing services'),("7622",'Radio, television and stereo repair shops'),("7623",'Air conditioning and refrigeration repair shops'),("7629",'Electrical and small apppliance repair shops'),("7631",'Watch, clock and jewelry repair shops'),("7641",'Reupholstery and furniture repair, furniture refinishing'),("7692",'Welding'),("7699",'Miscellaneous repair shops and related services'),("7832",'Motion picture theaters'),("7833",'Motion picture theaters (quick payment service)'),("7841",'Video rental stores'),("7911",'Dance halls, studios, and schools'),("7922",'Theatrical producers (except motion pictures), ticket agencies'),("7929",'Bands, orchestras, entertainers'),("7932",'Billiard and pool establishments'),("7933",'Bowling alleys'),("7941",'Commercial sports, professional sports clubs, athletic fields, sports promoters'),("7991",'Tourist attractions and exhibits'),("7992",'Golf courses-public'),("7993",'Video amusement game supplies'),("7994",'Video game arcades and establishments'),("7995",'Betting (including lottery tickets, casino gaming chips, off track betting, and wagers at race traks)'),("7996",'Amusement parks, circuses, carnivals, fortune tellers'),("7997",'Membership clubs (sporte, recreation, athletic), country clubs, private golf course'),("7998",'Aquariums, seaquariums dolphinariums'),("7999",'Amusement and recreation services, (including swimming pools,miniature golf and driving ranges, ski slopes, sport and games instruction, and boat rentals)'),("8011",'Doctors'),("8021",'Dentists, orthodontists'),("8031",'Osteopathic physicians'),("8041",'Chiropractors'),("8042",'Optometrists, ophthalmologists'),("8043",'Opticians'),("8044",'Optical goods and eyeglasses'),("8049",'Chiropodists, podiatrists'),("8050",'Nursing and personal care facilities'),("8062",'Hospitals'),("8071",'Medical and dental laboratories'),("8099",'Medical services, health practitioners, not elsewhere classified'),("8111",'Legal services, attorneys'),("8211",'Elementary and secondary schools'),("8220",'Colleges, universities, professional schools and junior colleges'),("8241",'Correspondence schools'),("8244",'Business and secretarial schools'),("8249",'Vocational and trade schools'),("8299",'Schools and educational services, not elsewhere classified'),("8351",'Child care services'),("8398",'Charitable and social service organizations'),("8641",'Civic, social and fraternal associations'),("8651",'Political organizations'),("8661",'Religious organizations'),("8675",'Automobile associations'),("8699",'Membership organizations; not elsewhere classified'),("8911",'Engineering, architectural and surveying services'),("8931",'Accounting, auditing and bookkeeping services'),("8999",'Professional services, not elsewhere classified'),("9211",'Court costs, including alimony and child support'),("9222",'Fines'),("9223",'Bail and bond payments'),("9311",'Tax payments'),("9399",'Government services, not elsewhere classified'),("9401",'Food stamps'),("9411",'Government loan payments'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_category ENABLE KEYS */; -- -- Table structure for table `tbl_context` -- DROP TABLE IF EXISTS tbl_context; CREATE TABLE tbl_context ( COMSESSIONID mediumint(8) unsigned NOT NULL, COMSESSIONNB decimal(5,0) NOT NULL default '0', TPEID mediumint(8) unsigned NOT NULL default '0', COMSOFTNAME varchar(30) default NULL, COMSOFTTYPE decimal(3,0) default NULL, COMSOFTDOWNLOADED char(1) default NULL, COMSOFTTODOWNLOAD char(1) default NULL, COMCURFRAME decimal(10,0) default NULL, COMDOWNLOADADDRESS decimal(10,0) default NULL, COMIDSEGNAME text, COMSOFTSEGNAME text, COMSEGCOMPRESSED char(1) default NULL, UNIQUE KEY PK_TBL_CONTEXT (COMSESSIONID), KEY TBL_TPE_CONTEXT_FK (TPEID), CONSTRAINT `0_231` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_context` -- /*!40000 ALTER TABLE tbl_context DISABLE KEYS */; LOCK TABLES tbl_context WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_context ENABLE KEYS */; -- -- Table structure for table `tbl_criterium` -- DROP TABLE IF EXISTS tbl_criterium; CREATE TABLE tbl_criterium ( CRITNAME varchar(30) NOT NULL default '', CRITCOD char(1) NOT NULL default '', UNIQUE KEY PK_TBL_CRITERIUM (CRITNAME) ); -- -- Dumping data for table `tbl_criterium` -- /*!40000 ALTER TABLE tbl_criterium DISABLE KEYS */; LOCK TABLES tbl_criterium WRITE; INSERT INTO tbl_criterium VALUES ('Field service provider','F'),('Merchant category','C'),('Merchant trading name','M'),('Merchant ZIP Code','Z'),('Operator','O'),('[None]','N'),('[Undefined]','N'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_criterium ENABLE KEYS */; -- -- Table structure for table `tbl_diag` -- DROP TABLE IF EXISTS tbl_diag; CREATE TABLE tbl_diag ( DIAGDATE datetime NOT NULL default '0000-00-00 00:00:00', TPEID mediumint(8) unsigned NOT NULL default '0', DIAGMEM1 mediumblob, DIAGMEM2 longblob, DIAGMEM1BEGIN decimal(10,0) default NULL, DIAGMEM2BEGIN decimal(10,0) default NULL, DIAGTYPE decimal(1,0) default NULL, DIAGMEM1LENGTH decimal(10,0) default NULL, DIAGMEM2LENGTH decimal(10,0) default NULL, FLAG char(1) default NULL, KEY TBL_DIAG_ID_DATE (TPEID,DIAGDATE), CONSTRAINT `0_233` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_diag` -- /*!40000 ALTER TABLE tbl_diag DISABLE KEYS */; LOCK TABLES tbl_diag WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_diag ENABLE KEYS */; -- -- Table structure for table `tbl_diag_eft30` -- DROP TABLE IF EXISTS tbl_diag_eft30; CREATE TABLE tbl_diag_eft30 ( diagdate date NOT NULL default '0000-00-00', tpeid decimal(5,0) NOT NULL default '0', diagfilename varchar(40) default NULL, diagmem longblob, diagtype decimal(1,0) default NULL, diagmemlength decimal(10,0) default NULL, flag decimal(1,0) default '0', KEY tbl_diag_eft30_id_date (tpeid,diagdate) ); -- -- Dumping data for table `tbl_diag_eft30` -- /*!40000 ALTER TABLE tbl_diag_eft30 DISABLE KEYS */; LOCK TABLES tbl_diag_eft30 WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_diag_eft30 ENABLE KEYS */; -- -- Table structure for table `tbl_family` -- DROP TABLE IF EXISTS tbl_family; CREATE TABLE tbl_family ( FAMID mediumint(8) unsigned NOT NULL, FAMNAME varchar(30) NOT NULL default '', FAMCOMMENT varchar(250) default NULL, UNIQUE KEY PK_TBL_FAMILY (FAMID) ); -- -- Dumping data for table `tbl_family` -- /*!40000 ALTER TABLE tbl_family DISABLE KEYS */; LOCK TABLES tbl_family WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_family ENABLE KEYS */; -- -- Table structure for table `tbl_fieldserviceprovider` -- DROP TABLE IF EXISTS tbl_fieldserviceprovider; CREATE TABLE tbl_fieldserviceprovider ( FSPID mediumint(8) unsigned NOT NULL, FSPCOMMENT varchar(250) default NULL, FSPNAME varchar(30) NOT NULL default '', FSPADDRESS varchar(30) default NULL, FSPZIPCODE varchar(10) default NULL, FSPTOWN varchar(30) default NULL, FSPSTATE varchar(30) default NULL, FSPCOUNTRY varchar(30) default NULL, FSPPHONE varchar(21) default NULL, FSPFAX varchar(21) default NULL, FSPMOBILE varchar(21) default NULL, FSPEMAIL varchar(30) default NULL, FSPCONTACT varchar(30) default NULL, UNIQUE KEY PK_TBL_FIELDSERVICEPROVIDER (FSPID) ); -- -- Dumping data for table `tbl_fieldserviceprovider` -- /*!40000 ALTER TABLE tbl_fieldserviceprovider DISABLE KEYS */; LOCK TABLES tbl_fieldserviceprovider WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_fieldserviceprovider ENABLE KEYS */; -- -- Table structure for table `tbl_grouptype` -- DROP TABLE IF EXISTS tbl_grouptype; CREATE TABLE tbl_grouptype ( GRPTYPENAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_GROUPTYPE (GRPTYPENAME) ); -- -- Dumping data for table `tbl_grouptype` -- /*!40000 ALTER TABLE tbl_grouptype DISABLE KEYS */; LOCK TABLES tbl_grouptype WRITE; INSERT INTO tbl_grouptype VALUES ('FSP broadcast group'),('Oper broadcast group'),('Other broadcast group'),('Param group'),('Soft group'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grouptype ENABLE KEYS */; -- -- Table structure for table `tbl_grp_broadcast` -- DROP TABLE IF EXISTS tbl_grp_broadcast; CREATE TABLE tbl_grp_broadcast ( BROMESSID mediumint(8) unsigned NOT NULL default '0', BROADGRPID mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY PK_TBL_GRP_BROADCAST (BROMESSID,BROADGRPID), KEY LIEN_509_FK (BROMESSID), KEY LIEN_510_FK (BROADGRPID), CONSTRAINT `0_235` FOREIGN KEY (`BROMESSID`) REFERENCES `tbl_broadcast` (`BROMESSID`), CONSTRAINT `0_237` FOREIGN KEY (`BROADGRPID`) REFERENCES `tbl_broadcastgrp` (`BROADGRPID`) ); -- -- Dumping data for table `tbl_grp_broadcast` -- /*!40000 ALTER TABLE tbl_grp_broadcast DISABLE KEYS */; LOCK TABLES tbl_grp_broadcast WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grp_broadcast ENABLE KEYS */; -- -- Table structure for table `tbl_grp_param` -- DROP TABLE IF EXISTS tbl_grp_param; CREATE TABLE tbl_grp_param ( PARAMTMS varchar(30) NOT NULL default '', PARAMGRPID mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY PK_TBL_GRP_PARAM (PARAMTMS,PARAMGRPID), KEY LIEN_484_FK (PARAMTMS), KEY LIEN_485_FK (PARAMGRPID), CONSTRAINT `0_239` FOREIGN KEY (`PARAMTMS`) REFERENCES `tbl_param` (`PARAMTMS`), CONSTRAINT `0_241` FOREIGN KEY (`PARAMGRPID`) REFERENCES `tbl_paramgrp` (`PARAMGRPID`) ); -- -- Dumping data for table `tbl_grp_param` -- /*!40000 ALTER TABLE tbl_grp_param DISABLE KEYS */; LOCK TABLES tbl_grp_param WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grp_param ENABLE KEYS */; -- -- Table structure for table `tbl_grp_soft` -- DROP TABLE IF EXISTS tbl_grp_soft; CREATE TABLE tbl_grp_soft ( SOFTGRPID mediumint(8) unsigned NOT NULL default '0', SOFTNAME varchar(11) NOT NULL default '', LOADMODE char(1) default NULL, GRPSOFTPRIORITY decimal(3,0) default NULL, UNIQUE KEY PK_TBL_GRP_SOFT (SOFTGRPID,SOFTNAME), KEY LIEN_488_FK (SOFTNAME), KEY LIEN_489_FK (SOFTGRPID), CONSTRAINT `0_243` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`), CONSTRAINT `0_245` FOREIGN KEY (`SOFTGRPID`) REFERENCES `tbl_softgrp` (`SOFTGRPID`) ); -- -- Dumping data for table `tbl_grp_soft` -- /*!40000 ALTER TABLE tbl_grp_soft DISABLE KEYS */; LOCK TABLES tbl_grp_soft WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grp_soft ENABLE KEYS */; -- -- Table structure for table `tbl_grpsys` -- DROP TABLE IF EXISTS tbl_grpsys; CREATE TABLE tbl_grpsys ( SYSGRPID mediumint(8) unsigned NOT NULL, SYSGRPNAME varchar(30) NOT NULL default '', SYSGRPCOMMENT varchar(250) default NULL, UNIQUE KEY PK_TBL_GRPSYS (SYSGRPID) ); -- -- Dumping data for table `tbl_grpsys` -- /*!40000 ALTER TABLE tbl_grpsys DISABLE KEYS */; LOCK TABLES tbl_grpsys WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grpsys ENABLE KEYS */; -- -- Table structure for table `tbl_grpsys_fam` -- DROP TABLE IF EXISTS tbl_grpsys_fam; CREATE TABLE tbl_grpsys_fam ( SYSGRPID mediumint(8) unsigned NOT NULL default '0', FAMID mediumint(8) unsigned NOT NULL default '0', GRPSYSFAMPRIORITY decimal(3,0) default NULL, UNIQUE KEY PK_TBL_GRPSYS_FAM (SYSGRPID,FAMID), KEY LIEN_496_FK (SYSGRPID), KEY LIEN_497_FK (FAMID), CONSTRAINT `0_247` FOREIGN KEY (`SYSGRPID`) REFERENCES `tbl_grpsys` (`SYSGRPID`), CONSTRAINT `0_249` FOREIGN KEY (`FAMID`) REFERENCES `tbl_family` (`FAMID`) ); -- -- Dumping data for table `tbl_grpsys_fam` -- /*!40000 ALTER TABLE tbl_grpsys_fam DISABLE KEYS */; LOCK TABLES tbl_grpsys_fam WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grpsys_fam ENABLE KEYS */; -- -- Table structure for table `tbl_grptype_critlvl` -- DROP TABLE IF EXISTS tbl_grptype_critlvl; CREATE TABLE tbl_grptype_critlvl ( GRPTYPENAME varchar(30) NOT NULL default '', GRPCRITLVL decimal(1,0) NOT NULL default '0', CRITNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_GRPTYPE_CRITLVL (GRPTYPENAME,GRPCRITLVL), KEY LIEN_511_FK (GRPTYPENAME), KEY LIEN_512_FK (CRITNAME), CONSTRAINT `0_251` FOREIGN KEY (`GRPTYPENAME`) REFERENCES `tbl_grouptype` (`GRPTYPENAME`), CONSTRAINT `0_253` FOREIGN KEY (`CRITNAME`) REFERENCES `tbl_criterium` (`CRITNAME`) ); -- -- Dumping data for table `tbl_grptype_critlvl` -- /*!40000 ALTER TABLE tbl_grptype_critlvl DISABLE KEYS */; LOCK TABLES tbl_grptype_critlvl WRITE; INSERT INTO tbl_grptype_critlvl VALUES ('FSP broadcast group',"2",'[Undefined]'),('FSP broadcast group',"3",'[Undefined]'),('Oper broadcast group',"2",'[Undefined]'),('Oper broadcast group',"3",'[Undefined]'),('Other broadcast group',"2",'[Undefined]'),('Other broadcast group',"3",'[Undefined]'),('Param group',"2",'[Undefined]'),('Param group',"3",'[Undefined]'),('Soft group',"2",'[Undefined]'),('Soft group',"3",'[Undefined]'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_grptype_critlvl ENABLE KEYS */; -- -- Table structure for table `tbl_lines` -- DROP TABLE IF EXISTS tbl_lines; CREATE TABLE tbl_lines ( LINID mediumint(8) unsigned NOT NULL, LINPHONENUMBER varchar(37) NOT NULL default '', LINPLANMODEMNUM decimal(10,0) default NULL, UNIQUE KEY PK_TBL_LINES (LINID) ); -- -- Dumping data for table `tbl_lines` -- /*!40000 ALTER TABLE tbl_lines DISABLE KEYS */; LOCK TABLES tbl_lines WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_lines ENABLE KEYS */; -- -- Table structure for table `tbl_loadbroadcast` -- DROP TABLE IF EXISTS tbl_loadbroadcast; CREATE TABLE tbl_loadbroadcast ( LOADBROADCASTNAME varchar(30) NOT NULL default '', LOADBROADCASTDATE datetime NOT NULL default '0000-00-00 00:00:00', TPEID mediumint(8) unsigned default NULL, LOADBROADCASTISSUER char(1) NOT NULL default '', KEY TBL_LOADBROADCAST_IX (LOADBROADCASTNAME,LOADBROADCASTDATE), KEY TBL_LOAD_BROADCAST_FK (TPEID), CONSTRAINT `0_255` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_loadbroadcast` -- /*!40000 ALTER TABLE tbl_loadbroadcast DISABLE KEYS */; LOCK TABLES tbl_loadbroadcast WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_loadbroadcast ENABLE KEYS */; -- -- Table structure for table `tbl_loadparam` -- DROP TABLE IF EXISTS tbl_loadparam; CREATE TABLE tbl_loadparam ( LOADPARAMTMS varchar(30) NOT NULL default '', LOADPARAMDATE datetime NOT NULL default '0000-00-00 00:00:00', TPEID mediumint(8) unsigned default NULL, LOADPARAMTPE varchar(30) default NULL, LOADPARAMSOFT varchar(10) default NULL, KEY TBL_LOADPARAM_IX (LOADPARAMTMS,LOADPARAMDATE), KEY TBL_LOAD_PARAM_FK (TPEID), CONSTRAINT `0_257` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_loadparam` -- /*!40000 ALTER TABLE tbl_loadparam DISABLE KEYS */; LOCK TABLES tbl_loadparam WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_loadparam ENABLE KEYS */; -- -- Table structure for table `tbl_loadsoft` -- DROP TABLE IF EXISTS tbl_loadsoft; CREATE TABLE tbl_loadsoft ( LOADSOFTNAME varchar(11) NOT NULL default '', LOADSOFTDATE datetime NOT NULL default '0000-00-00 00:00:00', TPEID mediumint(8) unsigned NOT NULL default '0', LOADMESS varchar(250) default NULL, loadmode char(1) default NULL, loadduration decimal(5,0) default NULL, KEY TBL_LOAD_SOF_FK (TPEID), KEY TBL_LOADSOFT_IX (LOADSOFTNAME,LOADSOFTDATE), CONSTRAINT `0_259` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_loadsoft` -- /*!40000 ALTER TABLE tbl_loadsoft DISABLE KEYS */; LOCK TABLES tbl_loadsoft WRITE; INSERT INTO tbl_loadsoft VALUES ('8080207','2004-06-15 14:25:31',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"72"),('8080207','2004-06-15 14:40:04',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"73"),('8080207','2004-06-15 14:48:21',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"73"),('8080207','2004-06-15 14:56:57',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"73"),('8080207','2004-06-15 15:05:00',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"73"),('8080207','2004-06-15 15:09:22',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"72"),('8080207','2004-06-15 15:26:31',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"73"),('8080207','2004-06-16 16:21:31',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"77"),('8080207','2004-06-16 16:26:21',1,'M300101SAGEM_MO020311234567890000000000000660 #','A',"140"),('8080207','2004-06-16 17:04:37',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"73"),('8080207','2004-06-16 17:50:09',1,'M300101SAGEM_MO020311234567890000000000000660 #','A',"117"),('8080207','2004-06-16 17:53:59',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"121"),('8080207','2004-06-17 14:20:30',1,'M300101SAGEM_MO020311234567890000000000000660 #','A',"137"),('8080207','2004-06-17 14:57:30',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"71"),('8080207','2004-06-17 15:16:53',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"75"),('8080207','2004-06-17 15:47:32',1,'M300101SAGEM_MO020311234567890000000000001224 #','A',"76"),('8080207','2004-06-18 10:54:29',1,'M300101SAGEM_MO020311234567890000000000000660 #','A',"117"); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_loadsoft ENABLE KEYS */; -- -- Table structure for table `tbl_mer_broadcast` -- DROP TABLE IF EXISTS tbl_mer_broadcast; CREATE TABLE tbl_mer_broadcast ( BROMESSID mediumint(8) unsigned NOT NULL default '0', MERID mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY PK_TBL_MER_BROADCAST (BROMESSID,MERID), KEY LIEN_584_FK (BROMESSID), KEY LIEN_585_FK (MERID), CONSTRAINT `0_261` FOREIGN KEY (`BROMESSID`) REFERENCES `tbl_broadcast` (`BROMESSID`), CONSTRAINT `0_263` FOREIGN KEY (`MERID`) REFERENCES `tbl_merchant` (`MERID`) ); -- -- Dumping data for table `tbl_mer_broadcast` -- /*!40000 ALTER TABLE tbl_mer_broadcast DISABLE KEYS */; LOCK TABLES tbl_mer_broadcast WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_mer_broadcast ENABLE KEYS */; -- -- Table structure for table `tbl_mer_crit` -- DROP TABLE IF EXISTS tbl_mer_crit; CREATE TABLE tbl_mer_crit ( MERID mediumint(8) unsigned NOT NULL default '0', CRITNAME varchar(30) NOT NULL default '', VALMERCHANTCRITERIUM varchar(30) default NULL, UNIQUE KEY PK_TBL_MER_CRIT (MERID,CRITNAME), KEY LIEN_515_FK (MERID), KEY LIEN_516_FK (CRITNAME), CONSTRAINT `0_265` FOREIGN KEY (`MERID`) REFERENCES `tbl_merchant` (`MERID`), CONSTRAINT `0_267` FOREIGN KEY (`CRITNAME`) REFERENCES `tbl_criterium` (`CRITNAME`) ); -- -- Dumping data for table `tbl_mer_crit` -- /*!40000 ALTER TABLE tbl_mer_crit DISABLE KEYS */; LOCK TABLES tbl_mer_crit WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_mer_crit ENABLE KEYS */; -- -- Table structure for table `tbl_mer_param` -- DROP TABLE IF EXISTS tbl_mer_param; CREATE TABLE tbl_mer_param ( MERID mediumint(8) unsigned NOT NULL default '0', PARAMTMS varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_MER_PARAM (MERID,PARAMTMS), KEY LIEN_486_FK (MERID), KEY LIEN_487_FK (PARAMTMS), CONSTRAINT `0_269` FOREIGN KEY (`MERID`) REFERENCES `tbl_merchant` (`MERID`), CONSTRAINT `0_271` FOREIGN KEY (`PARAMTMS`) REFERENCES `tbl_param` (`PARAMTMS`) ); -- -- Dumping data for table `tbl_mer_param` -- /*!40000 ALTER TABLE tbl_mer_param DISABLE KEYS */; LOCK TABLES tbl_mer_param WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_mer_param ENABLE KEYS */; -- -- Table structure for table `tbl_mer_soft` -- DROP TABLE IF EXISTS tbl_mer_soft; CREATE TABLE tbl_mer_soft ( MERID mediumint(8) unsigned NOT NULL default '0', SOFTNAME varchar(11) NOT NULL default '', LOADMODE char(1) default NULL, MERSOFTPRIORITY decimal(3,0) default NULL, UNIQUE KEY PK_TBL_MER_SOFT (MERID,SOFTNAME), KEY LIEN_490_FK (MERID), KEY LIEN_491_FK (SOFTNAME), CONSTRAINT `0_273` FOREIGN KEY (`MERID`) REFERENCES `tbl_merchant` (`MERID`), CONSTRAINT `0_275` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`) ); -- -- Dumping data for table `tbl_mer_soft` -- /*!40000 ALTER TABLE tbl_mer_soft DISABLE KEYS */; LOCK TABLES tbl_mer_soft WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_mer_soft ENABLE KEYS */; -- -- Table structure for table `tbl_merchant` -- DROP TABLE IF EXISTS tbl_merchant; CREATE TABLE tbl_merchant ( MERID mediumint(8) unsigned NOT NULL default '0', MERNUM varchar(10) NOT NULL default '', CATEGCOD decimal(10,0) default NULL, FAMID mediumint(8) unsigned default NULL, FSPID mediumint(8) unsigned default NULL, OPID mediumint(8) unsigned default NULL, MERCYCLDOWNLOAD char(1) default NULL, MERCOMMENT varchar(250) default NULL, MERNAME varchar(30) NOT NULL default '', MERADDRESS varchar(30) default NULL, MERZIPCODE varchar(10) default NULL, MERTOWN varchar(30) default NULL, MERSTATE varchar(30) default NULL, MERCOUNTRY varchar(30) default NULL, MERPHONE varchar(21) default NULL, MERFAX varchar(21) default NULL, MERMOBILE varchar(21) default NULL, MEREMAIL varchar(30) default NULL, MERCONTACT varchar(30) default NULL, UNIQUE KEY PK_TBL_MERCHANT (MERID), KEY TBL_MER_CAT_FK (CATEGCOD), KEY TBL_MER_FAM_FK (FAMID), KEY TBL_MER_FSP_FK (FSPID), KEY TBL_MER_OPER_FK (OPID), CONSTRAINT `0_199` FOREIGN KEY (`FAMID`) REFERENCES `tbl_family` (`FAMID`), CONSTRAINT `0_201` FOREIGN KEY (`CATEGCOD`) REFERENCES `tbl_category` (`CATEGCOD`), CONSTRAINT `0_203` FOREIGN KEY (`FSPID`) REFERENCES `tbl_fieldserviceprovider` (`FSPID`), CONSTRAINT `0_205` FOREIGN KEY (`OPID`) REFERENCES `tbl_operator` (`OPID`) ); -- -- Dumping data for table `tbl_merchant` -- /*!40000 ALTER TABLE tbl_merchant DISABLE KEYS */; LOCK TABLES tbl_merchant WRITE; INSERT INTO tbl_merchant VALUES (0,'0',NULL,NULL,NULL,NULL,'N',NULL,'default',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'123456789',NULL,NULL,NULL,NULL,'N',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_merchant ENABLE KEYS */; -- -- Table structure for table `tbl_modem` -- DROP TABLE IF EXISTS tbl_modem; CREATE TABLE tbl_modem ( MODEMNUM bigint(20) unsigned NOT NULL, LINID mediumint(8) unsigned default NULL, MODNAME varchar(250) default NULL, UNIQUE KEY PK_TBL_MODEM (MODEMNUM), KEY TBL_LINES_MODEM_FK (LINID), CONSTRAINT `0_195` FOREIGN KEY (`LINID`) REFERENCES `tbl_lines` (`LINID`) ); -- -- Dumping data for table `tbl_modem` -- /*!40000 ALTER TABLE tbl_modem DISABLE KEYS */; LOCK TABLES tbl_modem WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_modem ENABLE KEYS */; -- -- Table structure for table `tbl_object` -- DROP TABLE IF EXISTS tbl_object; CREATE TABLE tbl_object ( OBJNAME varchar(30) NOT NULL default '', OBJTYPNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_OBJECT (OBJNAME), KEY TBL_OBJECT_OBJTYPE_FK (OBJTYPNAME), CONSTRAINT `0_197` FOREIGN KEY (`OBJTYPNAME`) REFERENCES `tbl_objtype` (`OBJTYPNAME`) ); -- -- Dumping data for table `tbl_object` -- /*!40000 ALTER TABLE tbl_object DISABLE KEYS */; LOCK TABLES tbl_object WRITE; INSERT INTO tbl_object VALUES ('Audit','C'),('Monitoring','C'),('Broadcast details','CAMSE'),('Broadcast group details','CAMSE'),('Family details','CAMSE'),('Field service provider details','CAMSE'),('Merchant details','CAMSE'),('Operator details','CAMSE'),('Parameter details','CAMSE'),('Parameter group details','CAMSE'),('Software details','CAMSE'),('Software group details','CAMSE'),('System set details','CAMSE'),('Terminal details','CAMSE'),('Broadcast groups list','CE'),('Broadcast list','CE'),('Families list','CE'),('Field service provider list','CE'),('Merchants list','CE'),('Operators list','CE'),('Parameter groups list','CE'),('Parameters list','CE'),('Software groups list','CE'),('Software list','CE'),('System set list','CE'),('Terminal dump','CE'),('Terminal list','CE'),('Reports','E'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_object ENABLE KEYS */; -- -- Table structure for table `tbl_objtype` -- DROP TABLE IF EXISTS tbl_objtype; CREATE TABLE tbl_objtype ( OBJTYPNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_OBJTYPE (OBJTYPNAME) ); -- -- Dumping data for table `tbl_objtype` -- /*!40000 ALTER TABLE tbl_objtype DISABLE KEYS */; LOCK TABLES tbl_objtype WRITE; INSERT INTO tbl_objtype VALUES ('A'),('AMS'),('C'),('CAME'),('CAMSE'),('CE'),('CME'),('E'),('M'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_objtype ENABLE KEYS */; -- -- Table structure for table `tbl_objtype_right` -- DROP TABLE IF EXISTS tbl_objtype_right; CREATE TABLE tbl_objtype_right ( OBJTYPNAME varchar(30) NOT NULL default '', RGTNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_OBJTYPE_RIGHT (OBJTYPNAME,RGTNAME), KEY LIEN_474_FK (OBJTYPNAME), KEY LIEN_475_FK (RGTNAME), CONSTRAINT `0_277` FOREIGN KEY (`OBJTYPNAME`) REFERENCES `tbl_objtype` (`OBJTYPNAME`), CONSTRAINT `0_279` FOREIGN KEY (`RGTNAME`) REFERENCES `tbl_right` (`RGTNAME`) ); -- -- Dumping data for table `tbl_objtype_right` -- /*!40000 ALTER TABLE tbl_objtype_right DISABLE KEYS */; LOCK TABLES tbl_objtype_right WRITE; INSERT INTO tbl_objtype_right VALUES ('A','Add'),('AMS','Add'),('AMS','Delete'),('AMS','Modify'),('C','Display'),('CAME','Add'),('CAME','Display'),('CAME','Modify'),('CAME','Print'),('CAMSE','Add'),('CAMSE','Delete'),('CAMSE','Display'),('CAMSE','Modify'),('CAMSE','Print'),('CE','Display'),('CE','Print'),('CME','Display'),('CME','Modify'),('CME','Print'),('E','Print'),('M','Modify'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_objtype_right ENABLE KEYS */; -- -- Table structure for table `tbl_operator` -- DROP TABLE IF EXISTS tbl_operator; CREATE TABLE tbl_operator ( OPID mediumint(8) unsigned NOT NULL, OPNUM varchar(10) NOT NULL default '', OPCYCLDOWNLOAD char(1) default NULL, OPCOMMENT varchar(250) default NULL, OPNAME varchar(30) NOT NULL default '', OPADDRESS varchar(30) default NULL, OPZIPCODE varchar(10) default NULL, OPTOWN varchar(30) default NULL, OPSTATE varchar(30) default NULL, OPCOUNTRY varchar(30) default NULL, OPPHONE varchar(21) default NULL, OPMOBILE varchar(21) default NULL, OPEMAIL varchar(30) default NULL, OPFAX varchar(21) default NULL, OPCONTACT varchar(30) default NULL, UNIQUE KEY PK_TBL_OPERATOR (OPID) ); -- -- Dumping data for table `tbl_operator` -- /*!40000 ALTER TABLE tbl_operator DISABLE KEYS */; LOCK TABLES tbl_operator WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_operator ENABLE KEYS */; -- -- Table structure for table `tbl_param` -- DROP TABLE IF EXISTS tbl_param; CREATE TABLE tbl_param ( PARAMTMS varchar(30) NOT NULL default '', PARAMTPE varchar(6) NOT NULL default '', PARAMCOMMENT varchar(250) default NULL, PARAMTERMFILE char(1) default NULL, UNIQUE KEY PK_TBL_PARAM (PARAMTMS) ); -- -- Dumping data for table `tbl_param` -- /*!40000 ALTER TABLE tbl_param DISABLE KEYS */; LOCK TABLES tbl_param WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_param ENABLE KEYS */; -- -- Table structure for table `tbl_paramgrp` -- DROP TABLE IF EXISTS tbl_paramgrp; CREATE TABLE tbl_paramgrp ( PARAMGRPID mediumint(8) unsigned NOT NULL, CRITNAME varchar(30) NOT NULL default '', SOFTNAME varchar(11) NOT NULL default '', PARAMGRPNAME varchar(30) NOT NULL default '', PARAMFILTER varchar(30) default NULL, PARAMGRPCOMMENT varchar(250) default NULL, PARAMGRPPARENTID decimal(5,0) default NULL, UNIQUE KEY PK_TBL_PARAMGRP (PARAMGRPID), KEY TBL_CRIT_PARAMGRP_FK (CRITNAME), KEY TBL_PARAMGRP_SOFT_FK (SOFTNAME), CONSTRAINT `0_219` FOREIGN KEY (`CRITNAME`) REFERENCES `tbl_criterium` (`CRITNAME`), CONSTRAINT `0_221` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`) ); -- -- Dumping data for table `tbl_paramgrp` -- /*!40000 ALTER TABLE tbl_paramgrp DISABLE KEYS */; LOCK TABLES tbl_paramgrp WRITE; INSERT INTO tbl_paramgrp VALUES (1,'[None]','','All','*','Group for all terminal parameters',"0"); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_paramgrp ENABLE KEYS */; -- -- Table structure for table `tbl_planning` -- DROP TABLE IF EXISTS tbl_planning; CREATE TABLE tbl_planning ( PLANTYPE varchar(30) NOT NULL default '', PLANLABEL varchar(30) default NULL, PLANBEGIN datetime default NULL, PLANEND datetime default NULL, PLANWEBEGIN datetime default NULL, PLANWEEND datetime default NULL, PLANWE1 char(1) default NULL, UNIQUE KEY PK_TBL_PLANNING (PLANTYPE) ); -- -- Dumping data for table `tbl_planning` -- /*!40000 ALTER TABLE tbl_planning DISABLE KEYS */; LOCK TABLES tbl_planning WRITE; INSERT INTO tbl_planning VALUES ('D','Day','2000-00-08 00:00:00','2000-00-18 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',''),('DW','Day + WE','2000-00-08 00:00:00','2000-00-18 00:00:00','0000-00-00 00:00:00','2059-00-23 00:00:00','6'),('N','Night','2000-00-22 00:00:00','2000-00-06 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',''),('NW','Night + WE','2000-00-22 00:00:00','2000-00-06 00:00:00','0000-00-00 00:00:00','2059-00-23 00:00:00','6'),('W','WE','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','2059-00-23 00:00:00','6'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_planning ENABLE KEYS */; -- -- Table structure for table `tbl_profile` -- DROP TABLE IF EXISTS tbl_profile; CREATE TABLE tbl_profile ( PROFNAME varchar(30) NOT NULL default '', PROFADMIN char(1) default NULL, UNIQUE KEY PK_TBL_PROFILE (PROFNAME) ); -- -- Dumping data for table `tbl_profile` -- /*!40000 ALTER TABLE tbl_profile DISABLE KEYS */; LOCK TABLES tbl_profile WRITE; INSERT INTO tbl_profile VALUES ('Application supplier','N'),('Field service provider','N'),('Operator','N'),('TMS Administrator','Y'),('TMS Manager','N'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_profile ENABLE KEYS */; -- -- Table structure for table `tbl_profile_object_right` -- DROP TABLE IF EXISTS tbl_profile_object_right; CREATE TABLE tbl_profile_object_right ( PROFNAME varchar(30) NOT NULL default '', OBJNAME varchar(30) NOT NULL default '', RGTNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_PROFILE_OBJECT_RIGHT (PROFNAME,OBJNAME,RGTNAME), KEY LIEN_471_FK (PROFNAME), KEY LIEN_472_FK (OBJNAME), KEY LIEN_473_FK (RGTNAME), CONSTRAINT `0_281` FOREIGN KEY (`PROFNAME`) REFERENCES `tbl_profile` (`PROFNAME`), CONSTRAINT `0_283` FOREIGN KEY (`OBJNAME`) REFERENCES `tbl_object` (`OBJNAME`), CONSTRAINT `0_285` FOREIGN KEY (`RGTNAME`) REFERENCES `tbl_right` (`RGTNAME`) ); -- -- Dumping data for table `tbl_profile_object_right` -- /*!40000 ALTER TABLE tbl_profile_object_right DISABLE KEYS */; LOCK TABLES tbl_profile_object_right WRITE; INSERT INTO tbl_profile_object_right VALUES ('Application supplier','Software details','Add'),('Application supplier','Software details','Display'),('Application supplier','Software details','Modify'),('Application supplier','Software details','Print'),('Application supplier','Software list','Display'),('Application supplier','Software list','Print'),('Field service provider','Broadcast details','Add'),('Field service provider','Broadcast details','Delete'),('Field service provider','Broadcast details','Display'),('Field service provider','Broadcast details','Modify'),('Field service provider','Broadcast details','Print'),('Field service provider','Broadcast list','Display'),('Field service provider','Broadcast list','Print'),('Field service provider','Field service provider details','Display'),('Field service provider','Field service provider details','Modify'),('Field service provider','Field service provider details','Print'),('Field service provider','Field service provider list','Display'),('Field service provider','Field service provider list','Print'),('Field service provider','Monitoring','Display'),('Field service provider','Reports','Print'),('Field service provider','Software details','Display'),('Field service provider','Software details','Print'),('Field service provider','Software list','Display'),('Field service provider','Software list','Print'),('Field service provider','Terminal details','Display'),('Field service provider','Terminal details','Print'),('Field service provider','Terminal dump','Display'),('Field service provider','Terminal dump','Print'),('Field service provider','Terminal list','Display'),('Field service provider','Terminal list','Print'),('Operator','Merchant details','Add'),('Operator','Merchant details','Display'),('Operator','Merchant details','Modify'),('Operator','Merchant details','Print'),('Operator','Merchants list','Display'),('Operator','Merchants list','Print'),('Operator','Operator details','Display'),('Operator','Operator details','Modify'),('Operator','Operator details','Print'),('Operator','Operators list','Display'),('Operator','Operators list','Print'),('Operator','Parameter details','Add'),('Operator','Reports','Print'),('TMS Manager','Audit','Display'),('TMS Manager','Broadcast details','Add'),('TMS Manager','Broadcast details','Delete'),('TMS Manager','Broadcast details','Display'),('TMS Manager','Broadcast details','Modify'),('TMS Manager','Broadcast details','Print'),('TMS Manager','Broadcast group details','Add'),('TMS Manager','Broadcast group details','Delete'),('TMS Manager','Broadcast group details','Display'),('TMS Manager','Broadcast group details','Modify'),('TMS Manager','Broadcast group details','Print'),('TMS Manager','Broadcast groups list','Display'),('TMS Manager','Broadcast groups list','Print'),('TMS Manager','Broadcast list','Display'),('TMS Manager','Broadcast list','Print'),('TMS Manager','Families list','Display'),('TMS Manager','Families list','Print'),('TMS Manager','Family details','Add'),('TMS Manager','Family details','Delete'),('TMS Manager','Family details','Display'),('TMS Manager','Family details','Modify'),('TMS Manager','Family details','Print'),('TMS Manager','Field service provider details','Add'),('TMS Manager','Field service provider details','Delete'),('TMS Manager','Field service provider details','Display'),('TMS Manager','Field service provider details','Modify'),('TMS Manager','Field service provider details','Print'),('TMS Manager','Field service provider list','Display'),('TMS Manager','Field service provider list','Print'),('TMS Manager','Merchant details','Add'),('TMS Manager','Merchant details','Delete'),('TMS Manager','Merchant details','Display'),('TMS Manager','Merchant details','Modify'),('TMS Manager','Merchant details','Print'),('TMS Manager','Merchants list','Display'),('TMS Manager','Merchants list','Print'),('TMS Manager','Monitoring','Display'),('TMS Manager','Operator details','Add'),('TMS Manager','Operator details','Delete'),('TMS Manager','Operator details','Display'),('TMS Manager','Operator details','Modify'),('TMS Manager','Operator details','Print'),('TMS Manager','Operators list','Display'),('TMS Manager','Operators list','Print'),('TMS Manager','Parameter details','Add'),('TMS Manager','Parameter details','Delete'),('TMS Manager','Parameter details','Display'),('TMS Manager','Parameter details','Modify'),('TMS Manager','Parameter details','Print'),('TMS Manager','Parameter group details','Add'),('TMS Manager','Parameter group details','Delete'),('TMS Manager','Parameter group details','Display'),('TMS Manager','Parameter group details','Modify'),('TMS Manager','Parameter group details','Print'),('TMS Manager','Parameter groups list','Display'),('TMS Manager','Parameter groups list','Print'),('TMS Manager','Parameters list','Display'),('TMS Manager','Parameters list','Print'),('TMS Manager','Reports','Print'),('TMS Manager','Software details','Add'),('TMS Manager','Software details','Delete'),('TMS Manager','Software details','Display'),('TMS Manager','Software details','Modify'),('TMS Manager','Software details','Print'),('TMS Manager','Software group details','Add'),('TMS Manager','Software group details','Delete'),('TMS Manager','Software group details','Display'),('TMS Manager','Software group details','Modify'),('TMS Manager','Software group details','Print'),('TMS Manager','Software groups list','Display'),('TMS Manager','Software groups list','Print'),('TMS Manager','Software list','Display'),('TMS Manager','Software list','Print'),('TMS Manager','System set details','Add'),('TMS Manager','System set details','Delete'),('TMS Manager','System set details','Display'),('TMS Manager','System set details','Modify'),('TMS Manager','System set details','Print'),('TMS Manager','System set list','Display'),('TMS Manager','System set list','Print'),('TMS Manager','Terminal details','Add'),('TMS Manager','Terminal details','Display'),('TMS Manager','Terminal details','Modify'),('TMS Manager','Terminal details','Print'),('TMS Manager','Terminal dump','Display'),('TMS Manager','Terminal dump','Print'),('TMS Manager','Terminal list','Display'),('TMS Manager','Terminal list','Print'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_profile_object_right ENABLE KEYS */; -- -- Table structure for table `tbl_reason` -- DROP TABLE IF EXISTS tbl_reason; CREATE TABLE tbl_reason ( REPLACEREASONID mediumint(8) unsigned NOT NULL, REPLACEREASON varchar(30) default NULL, UNIQUE KEY PK_TBL_REASON (REPLACEREASONID) ); -- -- Dumping data for table `tbl_reason` -- /*!40000 ALTER TABLE tbl_reason DISABLE KEYS */; LOCK TABLES tbl_reason WRITE; INSERT INTO tbl_reason VALUES (100,'Printing Pb'),(101,'Slow printing'),(102,'Paper Jam'),(103,'Missing printed lines'),(104,'Compacted printing'),(105,'Impossible paper introduction'),(110,'Power Supply Pb'),(111,'Broken wires'),(112,'Power Supply connector broken'),(113,'Fuse Out of Order'),(114,'Male connector Out of Order'),(115,'Female connector Out of Order'),(116,'Bad contact jack connector'),(117,'Power supply out of order'),(120,'Cells Pb'),(121,'Cell pack worn (>3 years)'),(122,'element in short circuit'),(123,'bad contact to cells'),(124,'Flat cells'),(125,'Broken wires to cells'),(130,'Display Pb'),(131,'Black spots'),(132,'Glitches, Hieroglyphs'),(133,'No display'),(134,'Point line missing'),(140,'Keyboard Pb'),(141,'Merchant Membrane'),(142,'pin pad Membrane'),(143,'Torn key'),(144,'Keyboard Circuit'),(145,'Pin pad'),(146,'Keyboard disable (crypto)'),(150,'Reader Pb'),(151,'Chip reader incident'),(152,'Magnetic reader incident'),(153,'No card detection'),(154,'ICAM2'),(160,'Wakeup on base Pb, tension on'),(170,'Program loss'),(171,'Total loss'),(172,'System loss'),(173,'Manager loss'),(174,'application loss'),(175,'Parameter loss'),(176,'Driver loss'),(180,'EFT HF Pb'),(181,'Impossible apairage'),(182,'HF link Pb'),(183,'Out of radio cover mesage'),(184,'broken antena'),(185,'unscrewed antena'),(190,'Modem Pb'),(191,'No link'),(192,'V32bis jam'),(193,'HF jam'),(200,'Soft version Pb'),(210,'Hard out of order'),(211,'Hard out of order after fall'),(212,'Hard out of order after thunde'),(220,'Cover Pb'),(221,'Upper display cover unsticked'),(222,'Broken cover'),(230,'Miscelaneous'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_reason ENABLE KEYS */; -- -- Table structure for table `tbl_report` -- DROP TABLE IF EXISTS tbl_report; CREATE TABLE tbl_report ( RAPNUM mediumint(8) unsigned NOT NULL, RAPFSPNAME varchar(50) default NULL, RAPOPNUM varchar(50) default NULL, RAPTID varchar(16) default NULL, RAPMERNUM varchar(10) default NULL, RAPMERNAME varchar(30) default NULL, RAPPRODUCTCODE varchar(30) default NULL, RAPLASTCALLTYPEOK varchar(30) default NULL, RAPLASTCALLDATEOK datetime default NULL, RAPCALLTYPE varchar(30) default NULL, RAPCOMOK datetime default NULL, RAPCOMKO datetime default NULL, RAPCOMKOREASON varchar(60) default NULL, RAPFUTURELOADDATE datetime default NULL, RAPFUTUREMAINTDATE datetime default NULL, RAPENTITY varchar(60) default NULL, KEY TBL_REPORT_FK (RAPNUM) ); -- -- Dumping data for table `tbl_report` -- /*!40000 ALTER TABLE tbl_report DISABLE KEYS */; LOCK TABLES tbl_report WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_report ENABLE KEYS */; -- -- Table structure for table `tbl_right` -- DROP TABLE IF EXISTS tbl_right; CREATE TABLE tbl_right ( RGTNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_RIGHT (RGTNAME) ); -- -- Dumping data for table `tbl_right` -- /*!40000 ALTER TABLE tbl_right DISABLE KEYS */; LOCK TABLES tbl_right WRITE; INSERT INTO tbl_right VALUES ('Add'),('Delete'),('Display'),('Modify'),('Print'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_right ENABLE KEYS */; -- -- Table structure for table `tbl_soft_family` -- DROP TABLE IF EXISTS tbl_soft_family; CREATE TABLE tbl_soft_family ( FAMID mediumint(8) unsigned NOT NULL default '0', SOFTNAME varchar(11) NOT NULL default '', SOFTFAMPRIORITY decimal(3,0) default NULL, LOADMODE char(1) default NULL, UNIQUE KEY PK_TBL_SOFT_FAMILY (FAMID,SOFTNAME), KEY LIEN_480_FK (FAMID), KEY LIEN_481_FK (SOFTNAME), CONSTRAINT `0_287` FOREIGN KEY (`FAMID`) REFERENCES `tbl_family` (`FAMID`), CONSTRAINT `0_289` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`) ); -- -- Dumping data for table `tbl_soft_family` -- /*!40000 ALTER TABLE tbl_soft_family DISABLE KEYS */; LOCK TABLES tbl_soft_family WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_soft_family ENABLE KEYS */; -- -- Table structure for table `tbl_soft_grpsys` -- DROP TABLE IF EXISTS tbl_soft_grpsys; CREATE TABLE tbl_soft_grpsys ( SYSGRPID mediumint(8) unsigned NOT NULL default '0', SOFTNAME varchar(11) NOT NULL default '', GRPSYSPRIORITY decimal(3,0) default NULL, LOADMODE char(1) default NULL, UNIQUE KEY PK_TBL_SOFT_GRPSYS (SYSGRPID,SOFTNAME), KEY LIEN_492_FK (SOFTNAME), KEY LIEN_495_FK (SYSGRPID), CONSTRAINT `0_291` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`), CONSTRAINT `0_293` FOREIGN KEY (`SYSGRPID`) REFERENCES `tbl_grpsys` (`SYSGRPID`) ); -- -- Dumping data for table `tbl_soft_grpsys` -- /*!40000 ALTER TABLE tbl_soft_grpsys DISABLE KEYS */; LOCK TABLES tbl_soft_grpsys WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_soft_grpsys ENABLE KEYS */; -- -- Table structure for table `tbl_soft_param` -- DROP TABLE IF EXISTS tbl_soft_param; CREATE TABLE tbl_soft_param ( PARAMTMS varchar(30) NOT NULL default '', SOFTNAME varchar(11) NOT NULL default '', UNIQUE KEY PK_TBL_SOFT_PARAM (PARAMTMS,SOFTNAME), KEY LIEN_478_FK (PARAMTMS), KEY LIEN_479_FK (SOFTNAME), CONSTRAINT `0_295` FOREIGN KEY (`PARAMTMS`) REFERENCES `tbl_param` (`PARAMTMS`), CONSTRAINT `0_297` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`) ); -- -- Dumping data for table `tbl_soft_param` -- /*!40000 ALTER TABLE tbl_soft_param DISABLE KEYS */; LOCK TABLES tbl_soft_param WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_soft_param ENABLE KEYS */; -- -- Table structure for table `tbl_softgrp` -- DROP TABLE IF EXISTS tbl_softgrp; CREATE TABLE tbl_softgrp ( SOFTGRPID mediumint(8) unsigned NOT NULL, CRITNAME varchar(30) NOT NULL default '', FAMID mediumint(8) unsigned default NULL, SOFTGRPNAME varchar(30) NOT NULL default '', SOFTGRPFILTER varchar(30) default NULL, SOFTGRPCOMMENT varchar(250) default NULL, SOFTGRPPARENTID decimal(5,0) default NULL, UNIQUE KEY PK_TBL_SOFTGRP (SOFTGRPID), KEY TBL_CRIT_SOFTGRP_FK (CRITNAME), KEY TBL_GRP_FAM_FK (FAMID), CONSTRAINT `0_191` FOREIGN KEY (`FAMID`) REFERENCES `tbl_family` (`FAMID`), CONSTRAINT `0_193` FOREIGN KEY (`CRITNAME`) REFERENCES `tbl_criterium` (`CRITNAME`) ); -- -- Dumping data for table `tbl_softgrp` -- /*!40000 ALTER TABLE tbl_softgrp DISABLE KEYS */; LOCK TABLES tbl_softgrp WRITE; INSERT INTO tbl_softgrp VALUES (1,'[None]',NULL,'All','*','Group for all sofwares',"0"); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_softgrp ENABLE KEYS */; -- -- Table structure for table `tbl_softtype` -- DROP TABLE IF EXISTS tbl_softtype; CREATE TABLE tbl_softtype ( SOFTTYPNUM decimal(3,0) NOT NULL default '0', SOFTTYPCOMMENT varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_SOFTTYPE (SOFTTYPNUM) ); -- -- Dumping data for table `tbl_softtype` -- /*!40000 ALTER TABLE tbl_softtype DISABLE KEYS */; LOCK TABLES tbl_softtype WRITE; INSERT INTO tbl_softtype VALUES ("0",'System'),("1",'System component'),("2",'Application manager'),("3",'Application'),("4",'Application'),("5",'Application'),("6",'Application'),("7",'Application'),("8",'Application'),("9",'Application'),("10",'Application'),("11",'Application'),("12",'Application'),("13",'Application'),("14",'Application'),("15",'Application'),("16",'Application'),("17",'Application'),("18",'Application'),("19",'Application'),("20",'Application'),("21",'Application'),("22",'Application'),("23",'Application'),("24",'Application'),("25",'Application'),("26",'Application'),("27",'Application'),("28",'Application'),("29",'Application'),("30",'Application'),("31",'Application'),("32",'Application'),("33",'Application'),("34",'Application'),("35",'Application'),("36",'Application'),("37",'Application'),("38",'Application'),("39",'Application'),("40",'Application'),("41",'Application'),("42",'Application'),("43",'Application'),("44",'Application'),("45",'Application'),("46",'Application'),("47",'Application'),("48",'Application'),("49",'Application'),("50",'Application'),("51",'Application'),("52",'Application'),("53",'Application'),("54",'Application'),("55",'Application'),("56",'Application'),("57",'Application'),("58",'Application'),("59",'Application'),("60",'Application'),("61",'Application'),("62",'Application'),("63",'Application'),("64",'Application'),("65",'Application'),("66",'Application'),("67",'Application'),("68",'Application'),("69",'Application'),("70",'Application'),("71",'Application'),("72",'Application'),("73",'Application'),("74",'Application'),("75",'Application'),("76",'Application'),("77",'Application'),("78",'Application'),("79",'Application'),("80",'Application'),("81",'Application'),("82",'Application'),("83",'Application'),("84",'Application'),("85",'Application'),("86",'Application'),("87",'Application'),("88",'Application'),("89",'Application'),("90",'Application'),("91",'Application'),("92",'Application'),("93",'Application'),("94",'Application'),("95",'Application'),("96",'Application'),("97",'Application'),("98",'Application'),("99",'Application'),("100",'Application'),("101",'Application'),("102",'Application'),("103",'Application'),("104",'Application'),("105",'Application'),("106",'Application'),("107",'Application'),("108",'Application'),("109",'Application'),("110",'Application'),("111",'Application'),("112",'Application'),("113",'Application'),("114",'Application'),("115",'Application'),("116",'Application'),("117",'Application'),("118",'Application'),("119",'Application'),("120",'Application'),("121",'Application'),("122",'Application'),("123",'Application'),("124",'Application'),("125",'Application'),("126",'Application'),("127",'Application'),("128",'Application'),("129",'Application'),("130",'Application'),("131",'Application'),("132",'Application'),("133",'Application'),("134",'Application'),("135",'Application'),("136",'Application'),("137",'Application'),("138",'Application'),("139",'Application'),("140",'Application'),("141",'Application'),("142",'Application'),("143",'Application'),("144",'Application'),("145",'Application'),("146",'Application'),("147",'Application'),("148",'Application'),("149",'Application'),("150",'Application'),("151",'Application'),("152",'Application'),("153",'Application'),("154",'Application'),("155",'Application'),("156",'Application'),("157",'Application'),("158",'Application'),("159",'Application'),("160",'Application'),("161",'Application'),("162",'Application'),("163",'Application'),("164",'Application'),("165",'Application'),("166",'Application'),("167",'Application'),("168",'Application'),("169",'Application'),("170",'Application'),("171",'Application'),("172",'Application'),("173",'Application'),("174",'Application'),("175",'Application'),("176",'Application'),("177",'Application'),("178",'Application'),("179",'Application'),("180",'Application'),("181",'Application'),("182",'Application'),("183",'Application'),("184",'Application'),("185",'Application'),("186",'Application'),("187",'Application'),("188",'Application'),("189",'Application'),("190",'Application'),("191",'Application'),("192",'Application'),("193",'Application'),("194",'Application'),("195",'Application'),("196",'Application'),("197",'Application'),("198",'Application'),("199",'Application'),("200",'Application'),("201",'Application'),("202",'Application'),("203",'Application'),("204",'Application'),("205",'Application'),("206",'Application'),("207",'Application'),("208",'Application'),("209",'Application'),("210",'Application'),("211",'Application'),("212",'Application'),("213",'Application'),("214",'Application'),("215",'Application'),("216",'Application'),("217",'Application'),("218",'Application'),("219",'Application'),("220",'Application'),("221",'Application'),("222",'Application'),("223",'Application'),("224",'Application'),("225",'Application'),("226",'Application'),("227",'Application'),("228",'Application'),("229",'Application'),("230",'Application'),("231",'Application'),("232",'Application'),("233",'Application'),("234",'Application'),("235",'Application'),("236",'Application'),("237",'Application'),("238",'Application'),("239",'Application'),("240",'Application'),("241",'Application'),("242",'Application'),("243",'Application'),("244",'Application'),("245",'Application'),("246",'Application'),("247",'Application'),("248",'Application'),("249",'Application'),("250",'Application'),("251",'Application'),("252",'Application'),("253",'Application'),("254",'Application'),("255",'Application'),("256",'driver'),("257",'driver'),("258",'driver'),("259",'driver'),("260",'driver'),("261",'driver'),("262",'driver'),("263",'driver'),("264",'driver'),("265",'driver'),("266",'driver'),("267",'driver'),("268",'driver'),("269",'driver'),("270",'driver'),("271",'driver'),("272",'driver'),("273",'driver'),("274",'driver'),("275",'driver'),("276",'driver'),("277",'driver'),("278",'driver'),("279",'driver'),("280",'driver'),("281",'driver'),("282",'driver'),("283",'driver'),("284",'driver'),("285",'driver'),("286",'driver'),("287",'driver'),("288",'driver'),("289",'driver'),("290",'driver'),("291",'driver'),("292",'driver'),("293",'driver'),("294",'driver'),("295",'driver'),("296",'driver'),("297",'driver'),("298",'driver'),("299",'driver'),("300",'driver'),("301",'driver'),("302",'driver'),("303",'driver'),("304",'driver'),("305",'driver'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_softtype ENABLE KEYS */; -- -- Table structure for table `tbl_software` -- DROP TABLE IF EXISTS tbl_software; CREATE TABLE tbl_software ( SOFTNAME varchar(11) NOT NULL default '', SOFTTYPNUM decimal(3,0) NOT NULL default '0', SOFTSUBSTITUTE char(1) NOT NULL default '', SOFTDIFENABLE char(1) default NULL, SOFTSUBSTNAME varchar(11) default NULL, SOFTSHORTCOMMENT varchar(25) default NULL, SOFTCOMMENT varchar(250) default NULL, UNIQUE KEY PK_TBL_SOFTWARE (SOFTNAME), KEY TBL_TYPE_SOFT_FK (SOFTTYPNUM), CONSTRAINT `0_217` FOREIGN KEY (`SOFTTYPNUM`) REFERENCES `tbl_softtype` (`SOFTTYPNUM`) ); -- -- Dumping data for table `tbl_software` -- /*!40000 ALTER TABLE tbl_software DISABLE KEYS */; LOCK TABLES tbl_software WRITE; INSERT INTO tbl_software VALUES ('0650207',"225",'N','Y',NULL,'Module EMV',' CB EMV'),('8080207',"225",'N','Y',NULL,' CB EMV',' CB EMV'),('8130107',"229",'N','Y',NULL,'Derni?re version 813','Derni?re version du logiciel 8130110'),('8130110',"305",'N','Y',NULL,'CBEMV V5.2','CBEMV V5.2'),('',"0",'G','N','','',''),('[None]',"0",'U','N','','',''); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_software ENABLE KEYS */; -- -- Table structure for table `tbl_tpe` -- DROP TABLE IF EXISTS tbl_tpe; CREATE TABLE tbl_tpe ( tpeid mediumint(8) unsigned NOT NULL, tpetid varchar(16) default NULL, tpeordernum varchar(10) default NULL, tpeowner char(1) NOT NULL default '', merid mediumint(8) unsigned NOT NULL default '0', tpeproductname varchar(30) default NULL, famid mediumint(8) unsigned default NULL, replacereasonid mediumint(8) unsigned default NULL, plantype varchar(30) default NULL, tpeinactive char(1) default NULL, tpememory decimal(10,0) default NULL, tpereplacedtpe varchar(30) default NULL, tpegenoptions tinyblob, tpereaderoptions tinyblob, tpemodemoptions tinyblob, tpemodemcountry tinyblob, tpedisplayoptions tinyblob, tpemaintpref1 varchar(4) default NULL, tpemaintpref2 varchar(4) default NULL, tpeloadpref1 varchar(4) default NULL, tpeloadpref2 varchar(4) default NULL, tpelastteleparam datetime default NULL, tpelasttelemaint datetime default NULL, tpelastdiagnostic datetime default NULL, tpedelivery datetime default NULL, tpefirstcall datetime default NULL, tpemaintfrequency decimal(5,0) default NULL, tpemaintnumber decimal(5,0) default NULL, tpeuploadfrequency decimal(5,0) default NULL, tpeuploadnumber decimal(5,0) default NULL, syslanguage char(1) default NULL, sysformatdate char(1) default NULL, tpeshortcomment varchar(20) default NULL, tpecomment varchar(250) default NULL, tpefullsysparam char(1) default NULL, tpetidcom tinyblob, tpemercom varchar(90) default NULL, tpemaintflag char(1) default NULL, tpeloadflag char(1) default NULL, tpeflashmemory decimal(10,0) default NULL, datefirstactivation datetime default NULL, datelastactivation datetime default NULL, securitylevel char(2) default NULL, countrycode varchar(36) default NULL, motif_tensionb char(1) default NULL, motif_tensionh char(1) default NULL, motif_treillis char(1) default NULL, motif_temperatureh char(1) default NULL, motif_temperatureb char(1) default NULL, motif_membraneclavier char(1) default NULL, motif_capotinf char(1) default NULL, motif_capotsup char(1) default NULL, tpeimageparktest char(1) default NULL, UNIQUE KEY PK_TBL_TPE (tpeid), KEY TBL_MER_TPE_FK (merid), KEY TBL_PRDCODE_TPE_FK (tpeproductname), KEY TBL_TPE_FAM_FK (famid), KEY TBL_TPE_PLANNING_FK (plantype), KEY TBL_TPE_REASON_FK (replacereasonid), CONSTRAINT `0_207` FOREIGN KEY (`famid`) REFERENCES `tbl_family` (`FAMID`), CONSTRAINT `0_209` FOREIGN KEY (`tpeproductname`) REFERENCES `tbl_tpeproductcode` (`TPEPRODUCTNAME`), CONSTRAINT `0_211` FOREIGN KEY (`plantype`) REFERENCES `tbl_planning` (`PLANTYPE`), CONSTRAINT `0_213` FOREIGN KEY (`merid`) REFERENCES `tbl_merchant` (`MERID`), CONSTRAINT `0_215` FOREIGN KEY (`replacereasonid`) REFERENCES `tbl_reason` (`REPLACEREASONID`) ); -- -- Dumping data for table `tbl_tpe` -- /*!40000 ALTER TABLE tbl_tpe DISABLE KEYS */; LOCK TABLES tbl_tpe WRITE; INSERT INTO tbl_tpe VALUES (1,NULL,NULL,'N',5,'M30',NULL,NULL,'N','O',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2004-06-18 10:57:57','2004-06-11 14:04:59','2004-06-11 14:28:38','2004-06-02 00:00:00','2004-06-11 17:36:00',"1","3","3","3",'0','0','Test TPE',NULL,'Y','0000000000000020','123456789','N','N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpe ENABLE KEYS */; -- -- Table structure for table `tbl_tpe_broadcast` -- DROP TABLE IF EXISTS tbl_tpe_broadcast; CREATE TABLE tbl_tpe_broadcast ( BROMESSID mediumint(8) unsigned NOT NULL default '0', TPEID mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY PK_TBL_TPE_BROADCAST (BROMESSID,TPEID), KEY LIEN_563_FK (BROMESSID), KEY LIEN_564_FK (TPEID), CONSTRAINT `0_299` FOREIGN KEY (`BROMESSID`) REFERENCES `tbl_broadcast` (`BROMESSID`), CONSTRAINT `0_301` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_tpe_broadcast` -- /*!40000 ALTER TABLE tbl_tpe_broadcast DISABLE KEYS */; LOCK TABLES tbl_tpe_broadcast WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpe_broadcast ENABLE KEYS */; -- -- Table structure for table `tbl_tpe_param` -- DROP TABLE IF EXISTS tbl_tpe_param; CREATE TABLE tbl_tpe_param ( PARAMTMS varchar(30) NOT NULL default '', TPEID mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY PK_TBL_TPE_PARAM (PARAMTMS,TPEID), KEY LIEN_498_FK (PARAMTMS), KEY LIEN_499_FK (TPEID), CONSTRAINT `0_309` FOREIGN KEY (`PARAMTMS`) REFERENCES `tbl_param` (`PARAMTMS`), CONSTRAINT `0_311` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_tpe_param` -- /*!40000 ALTER TABLE tbl_tpe_param DISABLE KEYS */; LOCK TABLES tbl_tpe_param WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpe_param ENABLE KEYS */; -- -- Table structure for table `tbl_tpe_soft` -- DROP TABLE IF EXISTS tbl_tpe_soft; CREATE TABLE tbl_tpe_soft ( SOFTNAME varchar(11) NOT NULL default '', LOADMODE char(1) default NULL, TPEID mediumint(8) unsigned NOT NULL default '0', TPESOFTPRIORITY decimal(3,0) default NULL, UNIQUE KEY PK_TBL_TPE_SOFT (SOFTNAME,TPEID), KEY LIEN_482_FK (TPEID), KEY LIEN_483_FK (SOFTNAME), CONSTRAINT `0_315` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`), CONSTRAINT `0_317` FOREIGN KEY (`SOFTNAME`) REFERENCES `tbl_software` (`SOFTNAME`) ); -- -- Dumping data for table `tbl_tpe_soft` -- /*!40000 ALTER TABLE tbl_tpe_soft DISABLE KEYS */; LOCK TABLES tbl_tpe_soft WRITE; INSERT INTO tbl_tpe_soft VALUES ('8080207','A',1,"1"); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpe_soft ENABLE KEYS */; -- -- Table structure for table `tbl_tpebroadcast` -- DROP TABLE IF EXISTS tbl_tpebroadcast; CREATE TABLE tbl_tpebroadcast ( TPEBROADCASTDATE datetime default NULL, TPEID mediumint(8) unsigned default NULL, TPEBROADCASTNAME varchar(30) default NULL, TPEBROADCASTFROM char(1) default NULL, TPEBROADCASTTRANSMITTED char(1) default NULL, KEY TBL_TPEBROADCAST_IX (TPEBROADCASTNAME,TPEBROADCASTDATE), KEY TBL_TPE_BROADCAST_FK (TPEID), CONSTRAINT `0_325` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_tpebroadcast` -- /*!40000 ALTER TABLE tbl_tpebroadcast DISABLE KEYS */; LOCK TABLES tbl_tpebroadcast WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpebroadcast ENABLE KEYS */; -- -- Table structure for table `tbl_tpelines` -- DROP TABLE IF EXISTS tbl_tpelines; CREATE TABLE tbl_tpelines ( TPEID mediumint(8) unsigned NOT NULL default '0', TELTYPE char(1) NOT NULL default '', TELORDER decimal(1,0) NOT NULL default '0', LINID mediumint(8) unsigned default NULL, UNIQUE KEY PK_TBL_TPELINES (TPEID,TELTYPE,TELORDER), KEY TBL_LINES_TPELINES_FK (LINID), KEY TBL_TPE_TPELINES_FK (TPEID), CONSTRAINT `0_303` FOREIGN KEY (`LINID`) REFERENCES `tbl_lines` (`LINID`) ); -- -- Dumping data for table `tbl_tpelines` -- /*!40000 ALTER TABLE tbl_tpelines DISABLE KEYS */; LOCK TABLES tbl_tpelines WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpelines ENABLE KEYS */; -- -- Table structure for table `tbl_tpemodem` -- DROP TABLE IF EXISTS tbl_tpemodem; CREATE TABLE tbl_tpemodem ( MODEMNUM bigint(20) unsigned NOT NULL default '0', TPEID mediumint(8) unsigned NOT NULL default '0', CALLTYPE char(1) NOT NULL default '', CALLSTARTDATE datetime default NULL, CALLENDDATE datetime default NULL, UNIQUE KEY PK_TBL_TPEMODEM (MODEMNUM,TPEID,CALLTYPE), KEY TBL_MODEM_TPEMODEM_FK (MODEMNUM), KEY TBL_TPE_TPEMODEM_FK (TPEID), CONSTRAINT `0_305` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`), CONSTRAINT `0_307` FOREIGN KEY (`MODEMNUM`) REFERENCES `tbl_modem` (`MODEMNUM`) ); -- -- Dumping data for table `tbl_tpemodem` -- /*!40000 ALTER TABLE tbl_tpemodem DISABLE KEYS */; LOCK TABLES tbl_tpemodem WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpemodem ENABLE KEYS */; -- -- Table structure for table `tbl_tpeparam` -- DROP TABLE IF EXISTS tbl_tpeparam; CREATE TABLE tbl_tpeparam ( TPEPARAMDATE datetime default NULL, TPEID mediumint(8) unsigned default NULL, TPEPARAMTMS varchar(30) default NULL, TPEPARAMTPE varchar(30) default NULL, TPESOFTNAME varchar(11) default NULL, TPEPARAMTRANSMITTED char(1) default NULL, KEY TBL_TPEPARAM_IX (TPESOFTNAME,TPEPARAMDATE), KEY TBL_TPE_PARAM_FK (TPEID), CONSTRAINT `0_327` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_tpeparam` -- /*!40000 ALTER TABLE tbl_tpeparam DISABLE KEYS */; LOCK TABLES tbl_tpeparam WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpeparam ENABLE KEYS */; -- -- Table structure for table `tbl_tpeproductcode` -- DROP TABLE IF EXISTS tbl_tpeproductcode; CREATE TABLE tbl_tpeproductcode ( TPEPRODUCTNAME varchar(30) NOT NULL default '', TPETYPENAME varchar(30) NOT NULL default '', TPEPRODUCTCOMMENT varchar(250) default NULL, UNIQUE KEY PK_TBL_TPEPRODUCTCODE (TPEPRODUCTNAME), KEY TBL_PRODUCT_TPETYPE_FK (TPETYPENAME), CONSTRAINT `0_223` FOREIGN KEY (`TPETYPENAME`) REFERENCES `tbl_tpetype` (`TPETYPENAME`) ); -- -- Dumping data for table `tbl_tpeproductcode` -- /*!40000 ALTER TABLE tbl_tpeproductcode DISABLE KEYS */; LOCK TABLES tbl_tpeproductcode WRITE; INSERT INTO tbl_tpeproductcode VALUES ('CA2','EFT20','Borne Moneo'),('CE1','EFT10','EFT10 ROM 32K'),('CE2','EFT10','EFT10 ROM 128K'),('CE3','EFT10','EFT10 portable'),('CE4','EFT10',' '),('CE5','EFT10',' '),('CE6','EFT10',' '),('CE7','EFT10',''),('CE8','EFT10',''),('CE9','EFT10',''),('CF3','EFT20','EFT20 portable'),('CF4','EFT10','EFT10 modem ROCKWELL'),('CF5','EFT10',''),('CF7','EFT10','EFT10 graphic 8 lines modem ROCKWELL'),('CF8','EFT10','EFT10 portable graphic 8 lines'),('CF9','EFT10','EFT10 3 SAM modem ROCKWELL'),('CG2','EFT20','EFT20 HF socle'),('CG3','EFT20','EFT20 HF terminal'),('CG5','EFT10','MPC30 + Modem'),('CG6','EFT20','EFT10S'),('CG7','EFT20','EFT10S Crypto'),('CG9','EFT20','EFT10 F 3 SAM CAM2 crypto EMV modem ROCKWELL'),('CN3','EFT20','EFT20S V32bis'),('CN6','EFT20','EFT10S V32bis'),('CR3','EFT20','EFT20S V22bis Radio'),('G90','G900','Gamme 900 SAGEM'),('M30','EFT30','EFT30 stationnary'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpeproductcode ENABLE KEYS */; -- -- Table structure for table `tbl_tpesoft` -- DROP TABLE IF EXISTS tbl_tpesoft; CREATE TABLE tbl_tpesoft ( TPESOFTNAME varchar(11) NOT NULL default '', TPESOFTDATE datetime NOT NULL default '0000-00-00 00:00:00', TPEID mediumint(8) unsigned NOT NULL default '0', TPESOFTCRC tinyblob, TPESOFTTYPE decimal(3,0) default NULL, TPESOFTSIZE decimal(10,0) default NULL, TPESOFTFILECOUNTER decimal(3,0) default NULL, TPESOFTFILELENGTH decimal(10,0) default NULL, KEY TBL_TPESOFT_IX (TPESOFTNAME,TPESOFTDATE), KEY TBL_TPE_TPESOFT_FK (TPEID), CONSTRAINT `0_313` FOREIGN KEY (`TPEID`) REFERENCES `tbl_tpe` (`tpeid`) ); -- -- Dumping data for table `tbl_tpesoft` -- /*!40000 ALTER TABLE tbl_tpesoft DISABLE KEYS */; LOCK TABLES tbl_tpesoft WRITE; INSERT INTO tbl_tpesoft VALUES ('0650211','2004-06-18 10:57:49',1,NULL,NULL,NULL,NULL,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpesoft ENABLE KEYS */; -- -- Table structure for table `tbl_tpetype` -- DROP TABLE IF EXISTS tbl_tpetype; CREATE TABLE tbl_tpetype ( TPETYPENAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_TPETYPE (TPETYPENAME) ); -- -- Dumping data for table `tbl_tpetype` -- /*!40000 ALTER TABLE tbl_tpetype DISABLE KEYS */; LOCK TABLES tbl_tpetype WRITE; INSERT INTO tbl_tpetype VALUES (' (TPETYPENAME); '),(' FIELDS TERMINATED BY \'\r\n'),(' IGNORE 9 LINES'),(' INFILE \'../../TMS_DATABA'),(' INTO TABLE ADMINTMSI.TBL'),(' LINES TERMINATED BY \'\r\n\''),('/* BEGIN DATA */'),('EFT10'),('EFT20'),('EFT30'),('G900'),('Load Data'),('Quit'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_tpetype ENABLE KEYS */; -- -- Table structure for table `tbl_user` -- DROP TABLE IF EXISTS tbl_user; CREATE TABLE tbl_user ( USRID bigint(20) unsigned NOT NULL, PROFNAME varchar(30) NOT NULL default '', FSPID mediumint(8) unsigned default NULL, OPID mediumint(8) unsigned default NULL, USRNAME varchar(30) NOT NULL default '', USRPASSWD varchar(10) NOT NULL default '', USRACCESSNB decimal(5,0) default NULL, USRLASTACCESS datetime default NULL, USRADDRESS varchar(30) default NULL, USRZIPCODE varchar(10) default NULL, USRTOWN varchar(30) default NULL, USRSTATE varchar(30) default NULL, USRCOUNTRY varchar(30) default NULL, USRPHONE varchar(21) default NULL, USRFAX varchar(21) default NULL, USRMOBILE varchar(21) default NULL, USREMAIL varchar(30) default NULL, USRCOMMENT varchar(250) default NULL, UNIQUE KEY PK_TBL_USER (USRID), KEY TBL_USER_FSP_FK (FSPID), KEY TBL_USER_OPERATOR_FK (OPID), KEY TBL_USER_PROFILE_FK (PROFNAME), CONSTRAINT `0_319` FOREIGN KEY (`PROFNAME`) REFERENCES `tbl_profile` (`PROFNAME`), CONSTRAINT `0_321` FOREIGN KEY (`FSPID`) REFERENCES `tbl_fieldserviceprovider` (`FSPID`), CONSTRAINT `0_323` FOREIGN KEY (`OPID`) REFERENCES `tbl_operator` (`OPID`) ); -- -- Dumping data for table `tbl_user` -- /*!40000 ALTER TABLE tbl_user DISABLE KEYS */; LOCK TABLES tbl_user WRITE; INSERT INTO tbl_user VALUES (1,'TMS Administrator',NULL,NULL,'ADMIN','admintms',"0",'0000-00-00 00:00:00','','','','','','','','','',''); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_user ENABLE KEYS */; -- -- Table structure for table `tbl_version` -- DROP TABLE IF EXISTS tbl_version; CREATE TABLE tbl_version ( VERNAME varchar(30) NOT NULL default '', UNIQUE KEY PK_TBL_VERSION (VERNAME) ); -- -- Dumping data for table `tbl_version` -- /*!40000 ALTER TABLE tbl_version DISABLE KEYS */; LOCK TABLES tbl_version WRITE; INSERT INTO tbl_version VALUES ('04.02'); UNLOCK TABLES; /*!40000 ALTER TABLE tbl_version ENABLE KEYS */; -- -- Table structure for table `tbltmp_broadcastlist` -- DROP TABLE IF EXISTS tbltmp_broadcastlist; CREATE TABLE tbltmp_broadcastlist ( BROMESSID mediumint(8) unsigned NOT NULL default '0', BROMESSNAME varchar(30) NOT NULL default '', BROMESSFROM char(1) NOT NULL default '', BROMESSDEST char(1) NOT NULL default '', BROMESSCONTENT text NOT NULL, BROMESSDATE datetime default NULL, BROMESSHOUR datetime default NULL, BROMESSFREQ decimal(5,0) default NULL, BROMESSNB decimal(5,0) default NULL, BROMESSCOMMENT varchar(250) default NULL, PRIORITY decimal(1,0) default NULL ); -- -- Dumping data for table `tbltmp_broadcastlist` -- /*!40000 ALTER TABLE tbltmp_broadcastlist DISABLE KEYS */; LOCK TABLES tbltmp_broadcastlist WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbltmp_broadcastlist ENABLE KEYS */; -- -- Table structure for table `tbltmp_paramlist` -- DROP TABLE IF EXISTS tbltmp_paramlist; CREATE TABLE tbltmp_paramlist ( PARAMTMS varchar(30) NOT NULL default '', PARAMTPE varchar(30) NOT NULL default '', SOFTNAME varchar(11) NOT NULL default '' ); -- -- Dumping data for table `tbltmp_paramlist` -- /*!40000 ALTER TABLE tbltmp_paramlist DISABLE KEYS */; LOCK TABLES tbltmp_paramlist WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbltmp_paramlist ENABLE KEYS */; -- -- Table structure for table `tbltmp_softlist` -- DROP TABLE IF EXISTS tbltmp_softlist; CREATE TABLE tbltmp_softlist ( PRIORITY1 decimal(3,0) NOT NULL default '0', PRIORITY2 decimal(3,0) NOT NULL default '0', SOFTTYPE decimal(3,0) default NULL, LOADMODE char(1) default NULL, LOADADDRESS decimal(10,0) default NULL, SOFTNAME varchar(11) NOT NULL default '', SEGIDNAME varchar(30) default NULL, SEGSOFTNAME varchar(30) default NULL, COMPRESSED char(1) default NULL ); -- -- Dumping data for table `tbltmp_softlist` -- /*!40000 ALTER TABLE tbltmp_softlist DISABLE KEYS */; LOCK TABLES tbltmp_softlist WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE tbltmp_softlist ENABLE KEYS */; -- -- Table structure for table `tbltmp_tpe` -- DROP TABLE IF EXISTS tbltmp_tpe; CREATE TABLE tbltmp_tpe ( TPEID decimal(5,0) NOT NULL default '0', TPEINACTIVE char(1) default NULL ); -- -- Dumping data for table `tbltmp_tpe` -- /*!40000 ALTER TABLE tbltmp_tpe DISABLE KEYS */; LOCK TABLES tbltmp_tpe WRITE; INSERT INTO tbltmp_tpe VALUES ("1",'O'); UNLOCK TABLES; /*!40000 ALTER TABLE tbltmp_tpe ENABLE KEYS */; -- -- Table structure for table `test1` -- DROP TABLE IF EXISTS test1; CREATE TABLE test1 ( indexe1 int(11) default NULL ); -- -- Dumping data for table `test1` -- /*!40000 ALTER TABLE test1 DISABLE KEYS */; LOCK TABLES test1 WRITE; INSERT INTO test1 VALUES (1),(6); UNLOCK TABLES; /*!40000 ALTER TABLE test1 ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;