Bonjour, et merci pour ces précisions.
Apres vérification de vos infos et de mes remontées, il se trouve que nous parlons bien de la même chose ...
Si mon fichier final avait accepté d’être joint nous aurions une base de travail commune.
En dehors de la première ligne (ALTER TABLE) que j'ai ajouté afin de palier a mes soucis, j'ai bien utilisé toute la fin du fichier fournit a partir du 26/04/2011.
La traçabilité des fiches semblent bien fonctionner ... donc pas d'inquiétude pour moi a ce niveau.
Merci pour les scripts de création des tables manquantes, je les aient ajoutées de suite dans mon fichier et mises en place. Anticipons une lacune de mon cerveau pour la prochaine maj
Avec tout cela il me manque encore la table smi_tramail, mon fichier et quasiment a jour
Code : Tout sélectionner
##
## Structure de la table `smi_replcli`
##
CREATE TABLE IF NOT EXISTS `smi_replcli` (
`replcli_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`replcli_modele` int(10) unsigned NOT NULL,
`replcli_idori` int(10) unsigned NOT NULL,
`replcli_iddest` int(10) unsigned NOT NULL,
`replcli_lastdate` date NOT NULL DEFAULT '0000-00-00',
`replcli_lasthour` time NOT NULL DEFAULT '00:00:00',
PRIMARY KEY (`replcli_id`),
KEY `replcli_idori` (`replcli_idori`),
KEY `replcli_iddest` (`replcli_iddest`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Réplications clients';
##
## Contenu de la table `smi_replcli`
##
##
## Structure de la table `smi_replclic`
##
CREATE TABLE IF NOT EXISTS `smi_replclic` (
`replclic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`replclic_modele` int(10) unsigned NOT NULL,
`replclic_idori` int(10) unsigned NOT NULL,
`replclic_iddest` int(10) unsigned NOT NULL,
`replclic_lastdate` date NOT NULL DEFAULT '0000-00-00',
`replclic_lasthour` time NOT NULL DEFAULT '00:00:00',
PRIMARY KEY (`replclic_id`),
KEY `replclic_idori` (`replclic_idori`),
KEY `replclic_iddest` (`replclic_iddest`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Replications contacts clients';
##
## Contenu de la table `smi_replclic`
##
##
## Structure de la table `smi_ta`
##
ALTER TABLE `smi_dosta` ADD `dosta_depl` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `dosta_img` ;
RENAME TABLE `smi_dosta` TO `smi_ta` ;
ALTER TABLE `smi_ta` COMMENT = 'Types actions' ;
ALTER TABLE `smi_ta` CHANGE `dosta_id` `ta_id` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `smi_ta` CHANGE `dosta_code` `ta_code` VARCHAR( 5 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
ALTER TABLE `smi_ta` CHANGE `dosta_desc` `ta_desc` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
ALTER TABLE `smi_ta` CHANGE `dosta_img` `ta_img` VARCHAR( 200 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
ALTER TABLE `smi_ta` CHANGE `dosta_depl` `ta_depl` TINYINT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `smi_ta` CHANGE `dosta_delok` `ta_delok` TINYINT( 1 ) NOT NULL DEFAULT '1' ;
ALTER TABLE `smi_ta` ADD `ta_doss` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `ta_depl` ;
ALTER TABLE `smi_ta` ADD `ta_tra` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `ta_doss` ;
ALTER TABLE `smi_ta` ADD `ta_univ` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `ta_tra` ;
ALTER TABLE `smi_ta` DROP INDEX `dosta_code` ;
ALTER TABLE `smi_ta` ADD INDEX `ta_code` ( `ta_code` ) ;
ALTER TABLE `smi_ta` DROP INDEX `dosta_img` ;
ALTER TABLE `smi_ta` ADD INDEX `ta_img` ( `ta_img` ) ;
ALTER TABLE `smi_ta` ADD INDEX ( `ta_doss` ) ;
ALTER TABLE `smi_ta` ADD INDEX ( `ta_tra` ) ;
ALTER TABLE `smi_ta` ADD INDEX ( `ta_univ` ) ;
UPDATE `smi_ta` SET `ta_doss` = '1',`ta_tra` = '0';
INSERT INTO `smi_ta` VALUES(NULL, 'CRE', 'CREATION', '../icones/glaze/run.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'CREA', 'CREATION AFFECTATION', '../icones/aspneticons/user8_(add)_16x16.gif', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'CRER', 'CREATION RENDEZ-VOUS', '../icones/glaze/filenew.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MOD', 'MODIFICATION', '../icones/glaze/package_develop.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODA', 'MODIFICATION AFFECTATION', '../icones/aspneticons/user8_(edit)_16x16.gif', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODR', 'MODIFICATION RENDEZ-VOUS', '../icones/glaze/file_temporary.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'AJOC', 'AJOUT CONTRAT', '../icones/glaze/empty.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODC', 'MODIFICATION CONTRAT', '../icones/glaze/editcopy.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'SUPC', 'SUPPRESSION CONTRAT', '../icones/glaze/editcopy.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'EEI', 'ENVOI EMAIL (INTERNE)', '../icones/glaze/message.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'EEE', 'ENVOI EMAIL (EXTERNE)', '../icones/glaze/message.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODCA', 'MODIFICATION CATEGORIE', '../icones/glaze/bookmark_folder.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODMA', 'MODIFICATION MATERIEL', '../icones/glaze/editcopy.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODPB', 'MODIFICATION PROBLEME', '../icones/glaze/document.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODTE', 'MODIFICATION TRAVAIL EFFECTUE', '../icones/glaze/exec_wine.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODST', 'MODIFICATION STATUT', '../icones/glaze/mail_replylist.png', 0, 0, 1, 1, 0);
##
## Structure de la table `smi_dosd`
##
ALTER TABLE `smi_dosd` CHANGE `dosd_codedosta` `dosd_codeta` VARCHAR( 5 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
##
## Structure de la table `smi_tra`
##
DROP TABLE IF EXISTS `smi_tra`;
CREATE TABLE IF NOT EXISTS `smi_tra` (
`tra_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tra_codeutil` varchar(20) NOT NULL,
`tra_date` date NOT NULL DEFAULT '0000-00-00',
`tra_heure` time NOT NULL DEFAULT '00:00:00',
`tra_codeta` varchar(5) NOT NULL,
`tra_titre` varchar(100) NOT NULL,
`tra_desc` text NOT NULL,
`tra_typrat` tinyint(1) NOT NULL,
`tra_coderat` varchar(20) NOT NULL,
PRIMARY KEY (`tra_id`),
KEY `tra_codeutil` (`tra_codeutil`),
KEY `tra_date` (`tra_date`),
KEY `tra_codeta` (`tra_codeta`),
KEY `tra_typrat` (`tra_typrat`),
KEY `tra_coderat` (`tra_coderat`),
KEY `tra_heure` (`tra_heure`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Traçabilité';
##
## Structure de la table `smi_tramail`
##
DROP TABLE IF EXISTS `smi_tramail`;
CREATE TABLE IF NOT EXISTS `smi_tramail` (
`tramail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tramail_traid` int(10) unsigned NOT NULL,
`tramail_maildest` text COLLATE latin1_general_ci NOT NULL,
`tramail_mailexp` text CHARACTER SET latin1 NOT NULL,
`tramail_mailcc` text CHARACTER SET latin1,
`tramail_mailbcc` text CHARACTER SET latin1,
`tramail_mailurg` tinyint(4) NOT NULL,
`tramail_mailsujet` text CHARACTER SET latin1 NOT NULL,
`tramail_mailtxt` text CHARACTER SET latin1 NOT NULL,
`tramail_statut` tinyint(1) NOT NULL,
PRIMARY KEY (`tramail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Mail envoyés en interne';
## ------- 01/07/2011 ---------
##
## Structure de la table `smi_ta`
##
INSERT INTO `smi_ta` VALUES(NULL, 'MODUR', 'MODIFICATION URGENCE', '../icones/glaze/queue.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODCM', 'MODIFICATION CODE MANUEL', '../icones/glaze/gettext.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODLI', 'MODIFICATION LIEU', '../icones/glaze/package_network.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODTR', 'MODIFICATION TECHNICIEN RESP.', '../icones/nuvola/kuser.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODCP', 'CLIENT PREVENU', '../icones/nuvola/edu_languages.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'INTCL', 'INTERVENTION CLOSE', '../icones/nuvola/lock.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODDE', 'MODIFICATION DEMANDEUR', '../icones/EmotiKons/phone.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODGA', 'MODIFICATION GARANTIE', '../icones/glaze/filenew.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODFG', 'MODIFICATION FACTURE GARANTIE', '../icones/glaze/binary.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODAC', 'MODIFICATION ACOMPTE','../icones/EmotiKons/money.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODFO', 'MODIFICATION FORFAIT','../icones/nuvola/ooo_calc.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODSI', 'MODIFICATION SITE INTERVENTION','../icones/nuvola/gohome.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'IMPPD', 'IMPRESSION PDF','../icones/nuvola/pdf.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'IMPMA', 'IMPRESSION & MAIL','../icones/nuvola/print_class.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODPR', 'MODIFICATION PROPRIETAIRE','../icones/glaze/lockoverlay.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODTY', 'MODIFICATION TYPE','../icones/aspneticons/sort_by_quantity_16x16.gif', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODAD', 'MODIFICATION ADRESSE POSTALE','../icones/aspneticons/mail1_16x16.gif', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODTE', 'MODIFICATION COORDONNEES TEL','../icones/EmotiKons/mobile_phone2.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODEM', 'MODIFICATION COORDONNEES EMAIL','../icones/EmotiKons/email.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODDV', 'MODIFICATION DEVIS','../icones/fugue/money-coin.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODCT', 'MODIFICATION CONTACT PRINCIPAL','../icones/fugue/users.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODDJ', 'MODIFICATION DONNEES JURIDIQUES','../icones/fugue/hammer.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODNA', 'MODIFICATION NOTES ADMINISTRATION','../icones/fugue/applications.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODNT', 'MODIFICATION NOTES TECHNICIENS','../icones/fugue/applications-blue.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODRC', 'MODIFICATION RISQUE COMPTABLE','../icones/fugue/chart--exclamation.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODPC', 'MODIFICATION MOYEN PREV. CLIENT','../icones/fugue/direction.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODMF', 'MODIFICATION MODE FACTURATION','../icones/fugue/bin.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODCC', 'MODIFICATION CODE COMPTABILITE','../icones/fugue/book-open.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODNO', 'MODIFICATION NOTES','../icones/fugue/sort--pencil.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODMC', 'MODIFICATION MODE ACTIF','../icones/fugue/start-half.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODFO', 'MODIFICATION FONCTION','../icones/fugue/user--arrow.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODCD', 'MODIFICATION CODE','../icones/fugue/wrench.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODTM', 'MODIFICATION TYPES MESSAGES','../icones/fugue/mail--exclamation.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODTD', 'MODIFICATION TEXTE DETAIL','../icones/fugue/sort-rating.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODHO', 'MODIFICATION HORAIRES','../icones/fugue/clock--arrow.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MODSW', 'MODIFICATION SITE WEB','../icones/fugue/globe-green.png', 0, 0, 1, 1, 0);
##
## Structure de la table `smi_cli`
##
ALTER TABLE `smi_cli` ADD `cli_ccpta` VARCHAR( 15 ) NULL AFTER `cli_notat` ;
ALTER TABLE `smi_cli` ADD INDEX ( `cli_ccpta` ) ;
ALTER TABLE `smi_cli` ADD `cli_ccptasp` VARCHAR( 15 ) NULL AFTER `cli_ccpta` ;
ALTER TABLE `smi_cli` ADD INDEX ( `cli_ccptasp` ) ;
##
## Structure de la table `smi_scli`
##
ALTER TABLE `smi_scli` ADD `scli_ccpta` VARCHAR( 15 ) NULL ;
ALTER TABLE `smi_scli` ADD INDEX ( `scli_ccpta` ) ;
ALTER TABLE `smi_scli` ADD `scli_code` VARCHAR( 20 ) NULL AFTER `scli_codecli` ;
ALTER TABLE `smi_scli` ADD INDEX ( `scli_code` ) ;
##
## Structure de la table `smi_stsp`
##
DROP TABLE IF EXISTS `smi_stsp`;
CREATE TABLE IF NOT EXISTS `smi_stsp` (
`stsp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`stsp_codest` varchar(10) NOT NULL,
`stsp_codesp` varchar(5) NOT NULL,
`stsp_niveau` tinyint(1) NOT NULL,
PRIMARY KEY (`stsp_id`),
KEY `stsp_codest` (`stsp_codest`),
KEY `stsp_codesp` (`stsp_codesp`),
KEY `stsp_niveau` (`stsp_niveau`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spécialités par Technicien';
## ------- 11/10/2011 ---------
##
## Structure de la table `smi_rdv`
##
DROP TABLE IF EXISTS `smi_rdv`;
CREATE TABLE IF NOT EXISTS `smi_rdv` (
`rdv_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rdv_datecrea` date NOT NULL DEFAULT '0000-00-00',
`rdv_codecrea` varchar(20) NOT NULL,
`rdv_datemod` date NOT NULL DEFAULT '0000-00-00',
`rdv_codemod` varchar(20) NOT NULL,
`rdv_typrat` smallint(2) NOT NULL DEFAULT '0',
`rdv_coderat` varchar(20) NOT NULL,
`rdv_date` date NOT NULL DEFAULT '0000-00-00',
`rdv_codelieu` varchar(5) NOT NULL,
`rdv_heure` time NOT NULL DEFAULT '00:00:00',
`rdv_dureem` int(5) NOT NULL DEFAULT '0',
`rdv_nivurg` tinyint(1) NOT NULL DEFAULT '0',
`rdv_heurereel` time NOT NULL DEFAULT '00:00:00',
`rdv_tpsreelm` int(5) NOT NULL DEFAULT '0',
`rdv_honore` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`rdv_id`),
KEY `rdv_date` (`rdv_date`),
KEY `rdv_honore` (`rdv_honore`),
KEY `rdv_typrat` (`rdv_typrat`),
KEY `rdv_coderat` (`rdv_coderat`),
KEY `rdv_heure` (`rdv_heure`),
KEY `rdv_dureem` (`rdv_dureem`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Multi rendez-vous';
##
## Structure de la table `smi_pevt`
##
ALTER TABLE `smi_pevt` ADD `pevt_idrdv` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `pevt_coderat` ;
ALTER TABLE `smi_pevt` ADD INDEX ( `pevt_idrdv` );
##
## Structure de la table `smi_ta`
##
INSERT INTO `smi_ta` VALUES(NULL, 'SUPR', 'SUPPRESSION RDV', '../icones/glaze/editdelete.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'INTFP', 'INTERVENTION FIN PREVUE', '../icones/fugue/alarm-clock--exclamation.png', 0, 0, 1, 1, 0);
## ------- 06/11/2011 ---------
##
## Structure de la table `smi_ta`
##
INSERT INTO `smi_ta` VALUES(NULL, 'CREP', 'CREATION EVENEMENT PLANNING', '../icones/fugue/clock--plus.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'SUEP', 'SUPPRESSION EVENEMENT PLANNING', '../icones/fugue/clock--minus.png', 0, 0, 1, 1, 0);
INSERT INTO `smi_ta` VALUES(NULL, 'MOEP', 'MODIFICATION EVENEMENT PLANNING', '../icones/fugue/clock--pencil.png', 0, 0, 1, 1, 0);
## ------- 09/11/2011 ---------
##
## Structure de la table `smi_inth`
##
ALTER TABLE `smi_inth` ADD `inth_idrdv` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `inth_codeint` ;
ALTER TABLE `smi_inth` ADD INDEX ( `inth_idrdv` ) ;
##
## Structure de la table `smi_rdv`
##
ALTER TABLE `smi_rdv` DROP `rdv_heurereel` ;
ALTER TABLE `smi_rdv` DROP `rdv_tpsreelm` ;
## ------- 25/11/2011 ---------
##
## Structure de la table `smi_dep`
##
INSERT INTO `smi_dep` VALUES (NULL, '980', 'MONACO', 'MC', 'FR');
##
## Structure de la table `smi_villes`
##
INSERT INTO `smi_villes` VALUES (NULL, '98000', 'MONACO', '980', 'MC', 'FR');
## ------- 18/12/2011 ---------
##
## Structure de la table `smi_sig`
##
CREATE TABLE IF NOT EXISTS `smi_sig` (
`sig_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sig_typrat` tinyint(1) NOT NULL DEFAULT '1',
`sig_coderat` varchar(20) NOT NULL,
`sig_idhisto` int(10) unsigned NOT NULL,
`sig_date` date NOT NULL DEFAULT '0000-00-00',
`sig_heure` time NOT NULL DEFAULT '00:00:00',
`sig_nom` varchar(50) NOT NULL,
`sig_matricule` varchar(50) NOT NULL,
`sig_signature` text NOT NULL,
PRIMARY KEY (`sig_id`),
KEY `sig_typrat` (`sig_typrat`),
KEY `sig_coderat` (`sig_coderat`),
KEY `sig_idhisto` (`sig_idhisto`),
KEY `sig_heure` (`sig_heure`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Signatures';
ALTER TABLE `smi_droitsm` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `smi_droitsmd` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `smi_droitst` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `smi_replcli` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `smi_replclic` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
ALTER TABLE `smi_replm` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
#ALTER TABLE `smi_tramail` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
##
## Structure de la table `smi_ta`
##
INSERT INTO `smi_ta` VALUES (NULL , 'SIG', 'SIGNATURE', '../icones/glaze/txt.png', '0', '0', '1', '1', '0');
## ------- 24/12/2011 ---------
##
## Structure de la table `smi_inth`
##
ALTER TABLE `smi_inth` ADD `inth_fait` TEXT NULL DEFAULT NULL AFTER `inth_offert`;
## ------- 26/12/2011 ---------
##
## Structure de la table `smi_rpbm`
##
ALTER TABLE `smi_rpbm` CHANGE `rpbm_idsite` `rpbm_idsite` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `smi_rpbm` ADD `rpbm_idinth` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `rpbm_codeint` ;
ALTER TABLE `smi_rpbm` ADD INDEX ( `rpbm_idinth` ) ;