1 |
<?php |
2 |
//$Id: bible.import.inc.php 4598 2015-04-19 20:48:30Z tbenita $ |
3 |
//gen openMairie le 19/04/2015 22:31 |
4 |
|
5 |
$import= "Insertion dans la table bible voir rec/import_utilisateur.inc"; |
6 |
$table= DB_PREFIXE."bible"; |
7 |
$id='bible'; // numerotation automatique |
8 |
$verrou=1;// =0 pas de mise a jour de la base / =1 mise a jour |
9 |
$fic_rejet=1; // =0 pas de fichier pour relance / =1 fichier relance traitement |
10 |
$ligne1=1;// = 1 : 1ere ligne contient nom des champs / o sinon |
11 |
/** |
12 |
* |
13 |
*/ |
14 |
$fields = array( |
15 |
"bible" => array( |
16 |
"notnull" => "1", |
17 |
"type" => "int", |
18 |
"len" => "11", |
19 |
), |
20 |
"libelle" => array( |
21 |
"notnull" => "1", |
22 |
"type" => "string", |
23 |
"len" => "60", |
24 |
), |
25 |
"evenement" => array( |
26 |
"notnull" => "", |
27 |
"type" => "int", |
28 |
"len" => "11", |
29 |
"fkey" => array( |
30 |
"foreign_table_name" => "evenement", |
31 |
"foreign_column_name" => "evenement", |
32 |
"sql_exist" => "select * from ".DB_PREFIXE."evenement where evenement = '", |
33 |
), |
34 |
), |
35 |
"contenu" => array( |
36 |
"notnull" => "1", |
37 |
"type" => "blob", |
38 |
"len" => "-5", |
39 |
), |
40 |
"complement" => array( |
41 |
"notnull" => "", |
42 |
"type" => "int", |
43 |
"len" => "11", |
44 |
), |
45 |
"automatique" => array( |
46 |
"notnull" => "1", |
47 |
"type" => "string", |
48 |
"len" => "3", |
49 |
), |
50 |
"dossier_autorisation_type" => array( |
51 |
"notnull" => "", |
52 |
"type" => "int", |
53 |
"len" => "11", |
54 |
"fkey" => array( |
55 |
"foreign_table_name" => "dossier_autorisation_type", |
56 |
"foreign_column_name" => "dossier_autorisation_type", |
57 |
"sql_exist" => "select * from ".DB_PREFIXE."dossier_autorisation_type where dossier_autorisation_type = '", |
58 |
), |
59 |
), |
60 |
"om_collectivite" => array( |
61 |
"notnull" => "1", |
62 |
"type" => "int", |
63 |
"len" => "11", |
64 |
"fkey" => array( |
65 |
"foreign_table_name" => "om_collectivite", |
66 |
"foreign_column_name" => "om_collectivite", |
67 |
"sql_exist" => "select * from ".DB_PREFIXE."om_collectivite where om_collectivite = '", |
68 |
), |
69 |
), |
70 |
); |
71 |
?> |