projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Trims corps before inserting them.
[platal.git]
/
modules
/
fusionax
/
Anciens.sql
diff --git
a/modules/fusionax/Anciens.sql
b/modules/fusionax/Anciens.sql
index
af12e11
..
c6d84d6
100644
(file)
--- a/
modules/fusionax/Anciens.sql
+++ b/
modules/fusionax/Anciens.sql
@@
-35,6
+35,7
@@
SET
-- Mel_publiable is not certain yet :/
ALTER TABLE fusionax_anciens ADD INDEX (ax_id);
-- Mel_publiable is not certain yet :/
ALTER TABLE fusionax_anciens ADD INDEX (ax_id);
+UPDATE fusionax_anciens SET corps_sortie = TRIM(corps_sortie), grade = TRIM(grade);
-- Correspondances entre fiches X.org et fiches AX
DROP TABLE IF EXISTS `fusionax_import`;
-- Correspondances entre fiches X.org et fiches AX
DROP TABLE IF EXISTS `fusionax_import`;