projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Prevents joins in merge.php.
[platal.git]
/
modules
/
fusionax
/
Adresses.sql
diff --git
a/modules/fusionax/Adresses.sql
b/modules/fusionax/Adresses.sql
index
077b876
..
b72f851
100644
(file)
--- a/
modules/fusionax/Adresses.sql
+++ b/
modules/fusionax/Adresses.sql
@@
-17,8
+17,12
@@
CREATE TABLE IF NOT EXISTS fusionax_adresses (
tel VARCHAR(30) NOT NULL,
fax VARCHAR(30) NOT NULL,
Code_etab BIGINT(10) DEFAULT NULL,
tel VARCHAR(30) NOT NULL,
fax VARCHAR(30) NOT NULL,
Code_etab BIGINT(10) DEFAULT NULL,
+ pid INT(11) UNSIGNED DEFAULT NULL,
+ jobid INT(6) UNSIGNED DEFAULT NULL,
text TEXT DEFAULT NULL,
text TEXT DEFAULT NULL,
- PRIMARY KEY (ax_id, Type_adr)
+ PRIMARY KEY (ax_id, Type_adr),
+ INDEX (pid),
+ INDEX (jobid)
) ENGINE=InnoDB, CHARSET=utf8;
LOAD DATA LOCAL INFILE '{?}Adresses.txt' INTO TABLE `fusionax_adresses` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
) ENGINE=InnoDB, CHARSET=utf8;
LOAD DATA LOCAL INFILE '{?}Adresses.txt' INTO TABLE `fusionax_adresses` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'