1 |
|
2 |
create table llx_bank_url |
3 |
( |
4 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
5 |
fk_bank integer, |
6 |
url_id integer, |
7 |
url varchar(255), |
8 |
label varchar(255) |
9 |
); |
10 |
|
11 |
create table llx_actioncomm |
12 |
( |
13 |
id integer AUTO_INCREMENT PRIMARY KEY, |
14 |
datea datetime, |
15 |
fk_action integer, |
16 |
label varchar(50), |
17 |
fk_soc integer, |
18 |
fk_contact integer default 0, |
19 |
fk_user_action integer, |
20 |
fk_user_author integer, |
21 |
priority smallint, |
22 |
percent smallint, |
23 |
note text, |
24 |
propalrowid integer, |
25 |
fk_facture integer |
26 |
); |
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
create table llx_societe |
33 |
( |
34 |
idp integer AUTO_INCREMENT PRIMARY KEY, |
35 |
id varchar(32), |
36 |
active smallint default 0, |
37 |
parent integer default 0, |
38 |
tms timestamp, |
39 |
datec datetime, |
40 |
datea datetime, |
41 |
nom varchar(60), |
42 |
address varchar(255), |
43 |
cp varchar(10), |
44 |
ville varchar(50), |
45 |
fk_pays integer default 0, |
46 |
tel varchar(20), |
47 |
fax varchar(20), |
48 |
url varchar(255), |
49 |
fk_secteur integer default 0, |
50 |
fk_effectif integer default 0, |
51 |
fk_typent integer default 0, |
52 |
siren varchar(9), |
53 |
description text, |
54 |
fk_stcomm smallint default 0, |
55 |
note text, |
56 |
services integer default 0, |
57 |
prefix_comm varchar(5), |
58 |
client smallint default 0, |
59 |
fournisseur smallint default 0, |
60 |
|
61 |
UNIQUE INDEX(prefix_comm) |
62 |
); |
63 |
|
64 |
|
65 |
create table llx_socstatutlog |
66 |
( |
67 |
id integer AUTO_INCREMENT PRIMARY KEY, |
68 |
datel datetime, |
69 |
fk_soc integer, |
70 |
fk_statut integer, |
71 |
author varchar(30) |
72 |
); |
73 |
|
74 |
create table llx_socpeople |
75 |
( |
76 |
idp integer AUTO_INCREMENT PRIMARY KEY, |
77 |
datec datetime, |
78 |
fk_soc integer, |
79 |
name varchar(50), |
80 |
firstname varchar(50), |
81 |
address varchar(255), |
82 |
poste varchar(80), |
83 |
phone varchar(30), |
84 |
phone_perso varchar(30), |
85 |
phone_mobile varchar(30), |
86 |
fax varchar(30), |
87 |
email varchar(255), |
88 |
jabberid varchar(255), |
89 |
fk_user integer default 0, |
90 |
note text |
91 |
); |
92 |
|
93 |
create table llx_transaction_bplc |
94 |
( |
95 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
96 |
tms timestamp, |
97 |
ipclient varchar(20), |
98 |
num_transaction varchar(10), |
99 |
date_transaction varchar(10), |
100 |
heure_transaction varchar(10), |
101 |
num_autorisation varchar(10), |
102 |
cle_acceptation varchar(5), |
103 |
code_retour integer, |
104 |
ref_commande integer |
105 |
|
106 |
); |
107 |
|
108 |
create table llx_user_rights |
109 |
( |
110 |
fk_user integer NOT NULL, |
111 |
fk_id integer NOT NULL, |
112 |
UNIQUE(fk_user,fk_id) |
113 |
); |
114 |
|
115 |
|
116 |
create table llx_todocomm |
117 |
( |
118 |
id integer AUTO_INCREMENT PRIMARY KEY, |
119 |
datea datetime, |
120 |
label varchar(50), |
121 |
fk_user_action integer, |
122 |
fk_user_author integer, |
123 |
fk_soc integer, |
124 |
fk_contact integer, |
125 |
|
126 |
note text |
127 |
); |
128 |
|
129 |
|
130 |
create table llx_adherent |
131 |
( |
132 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
133 |
tms timestamp, |
134 |
statut smallint NOT NULL DEFAULT 0, |
135 |
public smallint NOT NULL DEFAULT 0, |
136 |
fk_adherent_type smallint, |
137 |
morphy enum('mor','phy') NOT NULL, |
138 |
datevalid datetime, |
139 |
datec datetime, |
140 |
prenom varchar(50), |
141 |
nom varchar(50), |
142 |
societe varchar(50), |
143 |
adresse text, |
144 |
cp varchar(30), |
145 |
ville varchar(50), |
146 |
pays varchar(50), |
147 |
email varchar(255), |
148 |
login varchar(50) NOT NULL, |
149 |
pass varchar(50), |
150 |
naiss date, |
151 |
photo varchar(255), |
152 |
fk_user_author integer NOT NULL, |
153 |
fk_user_mod integer NOT NULL, |
154 |
fk_user_valid integer NOT NULL, |
155 |
datefin datetime NOT NULL, |
156 |
note text, |
157 |
|
158 |
UNIQUE INDEX(login) |
159 |
); |
160 |
|
161 |
create table llx_don |
162 |
( |
163 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
164 |
tms timestamp, |
165 |
fk_statut smallint NOT NULL DEFAULT 0, |
166 |
datec datetime, |
167 |
datedon datetime, |
168 |
amount real default 0, |
169 |
fk_paiement integer, |
170 |
prenom varchar(50), |
171 |
nom varchar(50), |
172 |
societe varchar(50), |
173 |
adresse text, |
174 |
cp varchar(30), |
175 |
ville varchar(50), |
176 |
pays varchar(50), |
177 |
email varchar(255), |
178 |
public smallint NOT NULL DEFAULT 1, |
179 |
fk_don_projet integer NOT NULL, |
180 |
fk_user_author integer NOT NULL, |
181 |
fk_user_valid integer NOT NULL, |
182 |
note text |
183 |
); |
184 |
|
185 |
create table llx_facture_fourn |
186 |
( |
187 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
188 |
facnumber varchar(50) NOT NULL, |
189 |
fk_soc integer NOT NULL, |
190 |
datec datetime, |
191 |
datef date, |
192 |
libelle varchar(255), |
193 |
paye smallint default 0 NOT NULL, |
194 |
amount real default 0 NOT NULL, |
195 |
remise real default 0, |
196 |
tva real default 0, |
197 |
total real default 0, |
198 |
total_ht real default 0, |
199 |
total_tva real default 0, |
200 |
total_ttc real default 0, |
201 |
|
202 |
fk_statut smallint default 0 NOT NULL, |
203 |
|
204 |
fk_user_author integer, |
205 |
fk_user_valid integer, |
206 |
|
207 |
note text, |
208 |
|
209 |
UNIQUE INDEX (facnumber) |
210 |
); |
211 |
|
212 |
create table llx_notify |
213 |
( |
214 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
215 |
tms timestamp, |
216 |
daten datetime, |
217 |
fk_action integer NOT NULL, |
218 |
fk_contact integer NOT NULL, |
219 |
objet_type enum('ficheinter','facture','propale'), |
220 |
objet_id integer NOT NULL |
221 |
); |
222 |
|
223 |
create table llx_livre_to_auteur |
224 |
( |
225 |
fk_livre integer NOT NULL, |
226 |
fk_auteur integer NOT NULL |
227 |
); |
228 |
|
229 |
alter table llx_livre_to_auteur add unique key (fk_livre, fk_auteur); |
230 |
|
231 |
create table llx_contrat |
232 |
( |
233 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
234 |
tms timestamp, |
235 |
enservice smallint default 0, |
236 |
mise_en_service datetime, |
237 |
fin_validite datetime, |
238 |
date_cloture datetime, |
239 |
fk_soc integer NOT NULL, |
240 |
fk_product integer NOT NULL, |
241 |
fk_facture integer NOT NULL default 0, |
242 |
fk_user_author integer NOT NULL, |
243 |
fk_user_mise_en_service integer NOT NULL, |
244 |
fk_user_cloture integer NOT NULL |
245 |
); |
246 |
|
247 |
|
248 |
create table llx_fichinter |
249 |
( |
250 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
251 |
fk_soc integer NOT NULL, |
252 |
fk_projet integer default 0, |
253 |
ref varchar(30) NOT NULL, |
254 |
datec datetime, |
255 |
date_valid datetime, |
256 |
datei date, |
257 |
fk_user_author integer, |
258 |
fk_user_valid integer, |
259 |
fk_statut smallint default 0, |
260 |
duree real, |
261 |
note text, |
262 |
|
263 |
UNIQUE INDEX (ref) |
264 |
); |
265 |
|
266 |
create table llx_action_def |
267 |
( |
268 |
rowid integer NOT NULL PRIMARY KEY, |
269 |
tms timestamp, |
270 |
titre varchar(255) NOT NULL, |
271 |
description text, |
272 |
objet_type enum('ficheinter','facture','propale') |
273 |
); |
274 |
|
275 |
create table llx_soc_events |
276 |
( |
277 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
278 |
fk_soc int NOT NULL, |
279 |
dateb datetime NOT NULL, |
280 |
datee datetime NOT NULL, |
281 |
title varchar(100) NOT NULL, |
282 |
url varchar(255), |
283 |
description text |
284 |
); |
285 |
|
286 |
create table llx_const |
287 |
( |
288 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
289 |
name varchar(255), |
290 |
value text, |
291 |
type enum('yesno','texte','chaine'), |
292 |
visible tinyint DEFAULT 1 NOT NULL, |
293 |
note text, |
294 |
|
295 |
UNIQUE INDEX(name) |
296 |
); |
297 |
|
298 |
create table llx_compta |
299 |
( |
300 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
301 |
datec datetime, |
302 |
datev date, |
303 |
amount real NOT NULL default 0, |
304 |
label varchar(255), |
305 |
fk_compta_account integer, |
306 |
fk_user_author integer, |
307 |
fk_user_valid integer, |
308 |
valid tinyint default 0, |
309 |
note text |
310 |
|
311 |
); |
312 |
|
313 |
create table llx_compta_account |
314 |
( |
315 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
316 |
datec datetime, |
317 |
number varchar(12), |
318 |
label varchar(255), |
319 |
fk_user_author integer, |
320 |
note text |
321 |
|
322 |
); |
323 |
|
324 |
create table llx_notify_def |
325 |
( |
326 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
327 |
tms timestamp, |
328 |
datec date, |
329 |
fk_action integer NOT NULL, |
330 |
fk_soc integer NOT NULL, |
331 |
fk_contact integer NOT NULL |
332 |
); |
333 |
|
334 |
create table llx_bank_account |
335 |
( |
336 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
337 |
datec datetime, |
338 |
tms timestamp, |
339 |
label varchar(30), |
340 |
bank varchar(255), |
341 |
code_banque varchar(7), |
342 |
code_guichet varchar(6), |
343 |
number varchar(255), |
344 |
cle_rib varchar(5), |
345 |
bic varchar(10), |
346 |
iban_prefix varchar(5), |
347 |
domiciliation varchar(50), |
348 |
courant smallint default 0 not null, |
349 |
clos smallint default 0 not null |
350 |
); |
351 |
|
352 |
|
353 |
|
354 |
create table llx_cond_reglement |
355 |
( |
356 |
rowid integer PRIMARY KEY, |
357 |
sortorder smallint, |
358 |
actif tinyint default 1, |
359 |
libelle varchar(255), |
360 |
libelle_facture text, |
361 |
fdm tinyint, |
362 |
nbjour smallint |
363 |
); |
364 |
|
365 |
create table llx_propal_model_pdf |
366 |
( |
367 |
nom varchar(50) PRIMARY KEY, |
368 |
libelle varchar(255), |
369 |
description text |
370 |
); |
371 |
|
372 |
create table llx_entrepot |
373 |
( |
374 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
375 |
datec datetime, |
376 |
tms timestamp, |
377 |
label varchar(255), |
378 |
description text, |
379 |
statut tinyint default 1, |
380 |
fk_user_author integer |
381 |
); |
382 |
|
383 |
|
384 |
create table llx_user |
385 |
( |
386 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
387 |
datec datetime, |
388 |
tms timestamp, |
389 |
login varchar(8), |
390 |
pass varchar(32), |
391 |
name varchar(50), |
392 |
firstname varchar(50), |
393 |
code varchar(4), |
394 |
email varchar(255), |
395 |
admin smallint default 0, |
396 |
webcal_login varchar(25), |
397 |
module_comm smallint default 1, |
398 |
module_compta smallint default 1, |
399 |
fk_societe integer default 0, |
400 |
fk_socpeople integer default 0, |
401 |
note text, |
402 |
|
403 |
UNIQUE INDEX(login) |
404 |
); |
405 |
|
406 |
create table llx_rights_def |
407 |
( |
408 |
id integer PRIMARY KEY, |
409 |
libelle varchar(255), |
410 |
module varchar(12), |
411 |
type enum('r','w','m','d','a'), |
412 |
bydefault tinyint default 0 |
413 |
); |
414 |
|
415 |
|
416 |
create table llx_facture_tva_sum |
417 |
( |
418 |
fk_facture integer NOT NULL, |
419 |
amount real NOT NULL, |
420 |
tva_tx real NOT NULL, |
421 |
|
422 |
KEY(fk_facture) |
423 |
); |
424 |
|
425 |
create table llx_deplacement |
426 |
( |
427 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
428 |
datec datetime NOT NULL, |
429 |
tms timestamp, |
430 |
dated datetime, |
431 |
fk_user integer NOT NULL, |
432 |
fk_user_author integer, |
433 |
type smallint NOT NULL, |
434 |
km smallint, |
435 |
fk_soc integer, |
436 |
note text |
437 |
); |
438 |
|
439 |
create table llx_voyage |
440 |
( |
441 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
442 |
datec datetime, |
443 |
|
444 |
dateo date, |
445 |
date_depart datetime, |
446 |
date_arrivee datetime, |
447 |
amount real NOT NULL default 0, |
448 |
reduction real NOT NULL default 0, |
449 |
depart varchar(255), |
450 |
arrivee varchar(255), |
451 |
fk_type smallint, |
452 |
fk_reduc integer, |
453 |
distance integer, |
454 |
dossier varchar(50), |
455 |
note text |
456 |
); |
457 |
|
458 |
|
459 |
|
460 |
create table llx_product_price |
461 |
( |
462 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
463 |
tms timestamp, |
464 |
fk_product integer NOT NULL, |
465 |
date_price datetime NOT NULL, |
466 |
price double, |
467 |
tva_tx double default 19.6, |
468 |
fk_user_author integer, |
469 |
envente tinyint default 1 |
470 |
); |
471 |
|
472 |
|
473 |
create table llx_appro |
474 |
( |
475 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
476 |
datec datetime, |
477 |
tms timestamp, |
478 |
fk_product integer NOT NULL, |
479 |
quantity smallint unsigned NOT NULL, |
480 |
price real, |
481 |
fk_user_author integer |
482 |
); |
483 |
|
484 |
|
485 |
create table llx_voyage_reduc |
486 |
( |
487 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
488 |
datec datetime, |
489 |
datev date, |
490 |
date_debut date, |
491 |
date_fin date, |
492 |
amount real NOT NULL default 0, |
493 |
label varchar(255), |
494 |
numero varchar(255), |
495 |
fk_type smallint, |
496 |
note text |
497 |
); |
498 |
|
499 |
create table c_paiement |
500 |
( |
501 |
id integer PRIMARY KEY, |
502 |
libelle varchar(30), |
503 |
type smallint |
504 |
); |
505 |
|
506 |
|
507 |
|
508 |
|
509 |
create table llx_tva |
510 |
( |
511 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
512 |
tms timestamp, |
513 |
datep date, |
514 |
datev date, |
515 |
amount real NOT NULL default 0, |
516 |
label varchar(255), |
517 |
note text |
518 |
); |
519 |
|
520 |
create table llx_domain |
521 |
( |
522 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
523 |
datec datetime, |
524 |
label varchar(255), |
525 |
note text |
526 |
); |
527 |
|
528 |
|
529 |
create table c_actioncomm |
530 |
( |
531 |
id integer PRIMARY KEY, |
532 |
libelle varchar(30), |
533 |
todo tinyint |
534 |
); |
535 |
|
536 |
create table llx_boxes |
537 |
( |
538 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
539 |
box_id integer NOT NULL, |
540 |
position smallint NOT NULL |
541 |
|
542 |
); |
543 |
|
544 |
create table llx_bank |
545 |
( |
546 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
547 |
datec datetime, |
548 |
datev date, |
549 |
dateo date, |
550 |
amount real NOT NULL default 0, |
551 |
label varchar(255), |
552 |
fk_account integer, |
553 |
fk_user_author integer, |
554 |
fk_user_rappro integer, |
555 |
fk_type varchar(4), |
556 |
num_releve varchar(50), |
557 |
num_chq int, |
558 |
rappro tinyint default 0, |
559 |
note text, |
560 |
|
561 |
|
562 |
author varchar(40) |
563 |
); |
564 |
|
565 |
create table llx_co_pr |
566 |
( |
567 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
568 |
fk_commande integer, |
569 |
fk_propale integer |
570 |
); |
571 |
|
572 |
create table llx_bank_categ |
573 |
( |
574 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
575 |
label varchar(255) |
576 |
); |
577 |
|
578 |
create table c_effectif |
579 |
( |
580 |
id integer PRIMARY KEY, |
581 |
libelle varchar(30) |
582 |
); |
583 |
|
584 |
|
585 |
create table llx_commande |
586 |
( |
587 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
588 |
tms timestamp, |
589 |
fk_soc integer, |
590 |
fk_soc_contact integer, |
591 |
fk_projet integer default 0, |
592 |
ref varchar(30) NOT NULL, |
593 |
date_creation datetime, |
594 |
date_valid datetime, |
595 |
date_cloture datetime, |
596 |
date_commande date, |
597 |
fk_user_author integer, |
598 |
fk_user_valid integer, |
599 |
fk_user_cloture integer, |
600 |
source smallint NOT NULL, |
601 |
fk_statut smallint default 0, |
602 |
amount_ht real default 0, |
603 |
remise_percent real default 0, |
604 |
remise real default 0, |
605 |
tva real default 0, |
606 |
total_ht real default 0, |
607 |
total_ttc real default 0, |
608 |
note text, |
609 |
model_pdf varchar(50), |
610 |
facture tinyint default 0, |
611 |
UNIQUE INDEX (ref) |
612 |
); |
613 |
|
614 |
create table c_pays |
615 |
( |
616 |
id integer PRIMARY KEY, |
617 |
libelle varchar(25), |
618 |
code char(2) NOT NULL |
619 |
); |
620 |
|
621 |
|
622 |
|
623 |
create table llx_adherent_options |
624 |
( |
625 |
optid integer AUTO_INCREMENT PRIMARY KEY, |
626 |
tms timestamp, |
627 |
adhid integer NOT NULL, |
628 |
|
629 |
UNIQUE INDEX(adhid) |
630 |
); |
631 |
|
632 |
create table c_chargesociales |
633 |
( |
634 |
id integer PRIMARY KEY, |
635 |
libelle varchar(80), |
636 |
deductible smallint NOT NULL default 0 |
637 |
); |
638 |
|
639 |
|
640 |
|
641 |
|
642 |
create table llx_bank_class |
643 |
( |
644 |
lineid integer not null, |
645 |
fk_categ integer not null, |
646 |
|
647 |
INDEX(lineid) |
648 |
); |
649 |
|
650 |
create table llx_album |
651 |
( |
652 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
653 |
osc_id integer NOT NULL, |
654 |
tms timestamp, |
655 |
ref varchar(12), |
656 |
title varchar(64), |
657 |
annee smallint(64), |
658 |
description text, |
659 |
collectif tinyint, |
660 |
fk_user_author integer |
661 |
); |
662 |
|
663 |
|
664 |
create table c_typent |
665 |
( |
666 |
id integer PRIMARY KEY, |
667 |
libelle varchar(30) |
668 |
); |
669 |
|
670 |
create table llx_co_fa |
671 |
( |
672 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
673 |
fk_commande integer NOT NULL, |
674 |
fk_facture integer NOT NULL, |
675 |
|
676 |
key(fk_commande), |
677 |
key(fk_facture) |
678 |
); |
679 |
|
680 |
create table llx_projet |
681 |
( |
682 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
683 |
fk_soc integer NOT NULL, |
684 |
fk_statut smallint NOT NULL, |
685 |
tms timestamp, |
686 |
dateo date, |
687 |
ref varchar(50), |
688 |
title varchar(255), |
689 |
fk_user_resp integer, |
690 |
fk_user_creat integer, |
691 |
note text, |
692 |
|
693 |
UNIQUE INDEX(ref) |
694 |
|
695 |
); |
696 |
|
697 |
create table c_stcomm |
698 |
( |
699 |
id integer PRIMARY KEY, |
700 |
libelle varchar(30) |
701 |
); |
702 |
|
703 |
|
704 |
create table llx_groupart |
705 |
( |
706 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
707 |
osc_id integer NOT NULL, |
708 |
tms timestamp, |
709 |
nom varchar(64), |
710 |
groupart enum("artiste","groupe") NOT NULL, |
711 |
fk_user_author integer |
712 |
); |
713 |
|
714 |
|
715 |
create table llx_boxes_def |
716 |
( |
717 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
718 |
name varchar(255) NOT NULL, |
719 |
file varchar(255) NOT NULL, |
720 |
note text |
721 |
); |
722 |
|
723 |
create table llx_facture_rec |
724 |
( |
725 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
726 |
titre varchar(50) NOT NULL, |
727 |
fk_soc integer NOT NULL, |
728 |
datec datetime, |
729 |
|
730 |
amount real default 0 NOT NULL, |
731 |
remise real default 0, |
732 |
remise_percent real default 0, |
733 |
tva real default 0, |
734 |
total real default 0, |
735 |
total_ttc real default 0, |
736 |
|
737 |
fk_user_author integer, |
738 |
fk_projet integer, |
739 |
fk_cond_reglement integer, |
740 |
|
741 |
note text, |
742 |
|
743 |
INDEX fksoc (fk_soc) |
744 |
); |
745 |
|
746 |
create table llx_chargesociales |
747 |
( |
748 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
749 |
date_ech datetime NOT NULL, |
750 |
date_pai datetime, |
751 |
libelle varchar(80), |
752 |
fk_type integer, |
753 |
amount real default 0 NOT NULL, |
754 |
paye smallint default 0 NOT NULL, |
755 |
periode date |
756 |
); |
757 |
|
758 |
|
759 |
|
760 |
|
761 |
create table c_propalst |
762 |
( |
763 |
id smallint PRIMARY KEY, |
764 |
label varchar(30) |
765 |
); |
766 |
|
767 |
|
768 |
create table llx_bookmark |
769 |
( |
770 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
771 |
fk_soc integer, |
772 |
fk_user integer, |
773 |
dateb datetime |
774 |
); |
775 |
|
776 |
create table llx_fa_pr |
777 |
( |
778 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
779 |
fk_facture integer, |
780 |
fk_propal integer |
781 |
); |
782 |
|
783 |
create table llx_facture |
784 |
( |
785 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
786 |
facnumber varchar(50) NOT NULL, |
787 |
fk_soc integer NOT NULL, |
788 |
datec datetime, |
789 |
datef date, |
790 |
paye smallint default 0 NOT NULL, |
791 |
amount real default 0 NOT NULL, |
792 |
remise real default 0, |
793 |
remise_percent real default 0, |
794 |
tva real default 0, |
795 |
total real default 0, |
796 |
total_ttc real default 0, |
797 |
fk_statut smallint default 0 NOT NULL, |
798 |
author varchar(50), |
799 |
fk_user integer, |
800 |
fk_user_author integer, |
801 |
fk_user_valid integer, |
802 |
fk_projet integer, |
803 |
fk_cond_reglement integer, |
804 |
date_lim_reglement date, |
805 |
note text, |
806 |
|
807 |
UNIQUE INDEX (facnumber), |
808 |
INDEX fksoc (fk_soc) |
809 |
); |
810 |
|
811 |
create table llx_facturedet |
812 |
( |
813 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
814 |
fk_facture integer NOT NULL, |
815 |
fk_product integer NOT NULL default 0, |
816 |
description text, |
817 |
tva_taux real default 19.6, |
818 |
qty real, |
819 |
remise_percent real default 0, |
820 |
remise real default 0, |
821 |
subprice real, |
822 |
price real |
823 |
); |
824 |
|
825 |
create table llx_paiement |
826 |
( |
827 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
828 |
fk_facture integer, |
829 |
datec datetime, |
830 |
datep datetime, |
831 |
amount real default 0, |
832 |
author varchar(50), |
833 |
fk_paiement integer NOT NULL, |
834 |
num_paiement varchar(50), |
835 |
note text |
836 |
); |
837 |
|
838 |
create table llx_pointmort |
839 |
( |
840 |
month datetime, |
841 |
amount real |
842 |
); |
843 |
|
844 |
|
845 |
create table llx_product |
846 |
( |
847 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
848 |
datec datetime, |
849 |
tms timestamp, |
850 |
ref varchar(15) UNIQUE, |
851 |
label varchar(255), |
852 |
description text, |
853 |
price double, |
854 |
tva_tx double default 19.6, |
855 |
fk_user_author integer, |
856 |
envente tinyint default 1, |
857 |
nbvente integer default 0, |
858 |
fk_product_type integer default 0, |
859 |
duration varchar(6), |
860 |
stock_propale integer default 0, |
861 |
stock_commande integer default 0, |
862 |
seuil_stock_alerte integer default 0 |
863 |
|
864 |
); |
865 |
|
866 |
|
867 |
|
868 |
|
869 |
create table llx_propal |
870 |
( |
871 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
872 |
fk_soc integer, |
873 |
fk_soc_contact integer, |
874 |
fk_projet integer default 0, |
875 |
ref varchar(30) NOT NULL, |
876 |
datec datetime, |
877 |
fin_validite datetime, |
878 |
date_valid datetime, |
879 |
date_cloture datetime, |
880 |
datep date, |
881 |
fk_user_author integer, |
882 |
fk_user_valid integer, |
883 |
fk_user_cloture integer, |
884 |
fk_statut smallint default 0, |
885 |
price real default 0, |
886 |
remise_percent real default 0, |
887 |
remise real default 0, |
888 |
tva real default 0, |
889 |
total real default 0, |
890 |
note text, |
891 |
model_pdf varchar(50), |
892 |
UNIQUE INDEX (ref) |
893 |
); |
894 |
|
895 |
create table llx_soc_recontact |
896 |
( |
897 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
898 |
fk_soc integer, |
899 |
datere datetime, |
900 |
author varchar(15) |
901 |
); |
902 |
|
903 |
create table llx_ventes |
904 |
( |
905 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
906 |
fk_soc integer NOT NULL, |
907 |
fk_product integer NOT NULL, |
908 |
dated datetime, |
909 |
datef datetime, |
910 |
price real, |
911 |
author varchar(30), |
912 |
active smallint DEFAULT 0 NOT NULL, |
913 |
note varchar(255) |
914 |
); |
915 |
|
916 |
create table llx_propaldet |
917 |
( |
918 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
919 |
fk_propal integer, |
920 |
fk_product integer, |
921 |
description text, |
922 |
tva_tx real default 19.6, |
923 |
qty real, |
924 |
remise_percent real default 0, |
925 |
remise real default 0, |
926 |
subprice real, |
927 |
price real |
928 |
); |
929 |
|
930 |
create table llx_don_projet |
931 |
( |
932 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
933 |
tms timestamp, |
934 |
datec datetime, |
935 |
libelle varchar(255), |
936 |
fk_user_author integer NOT NULL, |
937 |
note text |
938 |
); |
939 |
|
940 |
create table llx_stock_mouvement |
941 |
( |
942 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
943 |
tms timestamp, |
944 |
datem datetime, |
945 |
fk_product integer NOT NULL, |
946 |
fk_entrepot integer NOT NULL, |
947 |
value integer, |
948 |
type_mouvement smallint, |
949 |
fk_user_author integer, |
950 |
|
951 |
key(fk_product), |
952 |
key(fk_entrepot) |
953 |
); |
954 |
|
955 |
|
956 |
create table llx_product_stock |
957 |
( |
958 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
959 |
tms timestamp, |
960 |
fk_product integer NOT NULL, |
961 |
fk_entrepot integer NOT NULL, |
962 |
reel integer, |
963 |
|
964 |
key(fk_product), |
965 |
key(fk_entrepot) |
966 |
); |
967 |
|
968 |
|
969 |
create table llx_product_fournisseur |
970 |
( |
971 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
972 |
datec datetime, |
973 |
tms timestamp, |
974 |
fk_product integer, |
975 |
fk_soc integer, |
976 |
ref_fourn varchar(30), |
977 |
fk_user_author integer, |
978 |
|
979 |
key(fk_product), |
980 |
key(fk_soc) |
981 |
); |
982 |
|
983 |
|
984 |
create table llx_cotisation |
985 |
( |
986 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
987 |
tms timestamp, |
988 |
datec datetime, |
989 |
fk_adherent integer, |
990 |
dateadh datetime, |
991 |
cotisation real, |
992 |
note text |
993 |
); |
994 |
|
995 |
create table llx_commandedet |
996 |
( |
997 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
998 |
fk_commande integer, |
999 |
fk_product integer, |
1000 |
label varchar(255), |
1001 |
description text, |
1002 |
tva_tx real default 19.6, |
1003 |
qty real, |
1004 |
remise_percent real default 0, |
1005 |
remise real default 0, |
1006 |
subprice real, |
1007 |
price real |
1008 |
); |
1009 |
|
1010 |
create table llx_adherent_type |
1011 |
( |
1012 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1013 |
tms timestamp, |
1014 |
statut smallint NOT NULL DEFAULT 0, |
1015 |
libelle varchar(50), |
1016 |
cotisation enum('yes','no') NOT NULL DEFAULT 'yes', |
1017 |
vote enum('yes','no') NOT NULL DEFAULT 'yes', |
1018 |
note text, |
1019 |
mail_valid text |
1020 |
); |
1021 |
|
1022 |
create table llx_facturedet_rec |
1023 |
( |
1024 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1025 |
fk_facture integer NOT NULL, |
1026 |
fk_product integer, |
1027 |
description text, |
1028 |
tva_taux real default 19.6, |
1029 |
qty real, |
1030 |
remise_percent real default 0, |
1031 |
remise real default 0, |
1032 |
subprice real, |
1033 |
price real |
1034 |
); |
1035 |
|
1036 |
create table llx_adherent_options_label |
1037 |
( |
1038 |
name varchar(64) PRIMARY KEY, |
1039 |
tms timestamp, |
1040 |
label varchar(255) NOT NULL |
1041 |
); |
1042 |
|
1043 |
create table llx_expedition_methode |
1044 |
( |
1045 |
rowid integer PRIMARY KEY, |
1046 |
tms timestamp, |
1047 |
code varchar(30) NOT NULL, |
1048 |
libelle varchar(50) NOT NULL, |
1049 |
description text, |
1050 |
statut tinyint default 0 |
1051 |
); |
1052 |
|
1053 |
create table llx_birthday_alert |
1054 |
( |
1055 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1056 |
date_alert date, |
1057 |
fk_contact integer, |
1058 |
fk_user integer |
1059 |
); |
1060 |
|
1061 |
create table llx_expedition |
1062 |
( |
1063 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1064 |
tms timestamp, |
1065 |
ref varchar(30) NOT NULL, |
1066 |
fk_commande integer, |
1067 |
date_creation datetime, |
1068 |
date_valid datetime, |
1069 |
date_expedition date, |
1070 |
fk_user_author integer, |
1071 |
fk_user_valid integer, |
1072 |
fk_entrepot integer, |
1073 |
fk_expedition_methode integer, |
1074 |
fk_statut smallint default 0, |
1075 |
note text, |
1076 |
model_pdf varchar(50), |
1077 |
|
1078 |
UNIQUE INDEX (ref), |
1079 |
key(fk_expedition_methode), |
1080 |
key(fk_commande) |
1081 |
); |
1082 |
|
1083 |
create table llx_expeditiondet |
1084 |
( |
1085 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1086 |
fk_expedition integer not null, |
1087 |
fk_commande_ligne integer not null, |
1088 |
qty real, |
1089 |
|
1090 |
key(fk_expedition), |
1091 |
key(fk_commande_ligne) |
1092 |
); |
1093 |
|
1094 |
create table llx_sqltables |
1095 |
( |
1096 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1097 |
name varchar(255), |
1098 |
loaded tinyint(1) |
1099 |
); |
1100 |
|
1101 |
|
1102 |
create table llx_concert |
1103 |
( |
1104 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1105 |
tms timestamp, |
1106 |
date_concert datetime NOT NULL, |
1107 |
description text, |
1108 |
collectif tinyint DEFAULT 0 NOT NULL, |
1109 |
fk_groupart integer, |
1110 |
fk_lieu_concert integer, |
1111 |
fk_user_author integer |
1112 |
); |
1113 |
|
1114 |
|
1115 |
create table llx_album_to_groupart |
1116 |
( |
1117 |
fk_album integer NOT NULL, |
1118 |
fk_groupart integer NOT NULL |
1119 |
); |
1120 |
|
1121 |
alter table llx_album_to_groupart add unique key (fk_album, fk_groupart); |
1122 |
|
1123 |
create table llx_lieu_concert |
1124 |
( |
1125 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1126 |
tms timestamp, |
1127 |
nom varchar(64) NOT NULL, |
1128 |
description text, |
1129 |
ville varchar(64) NOT NULL, |
1130 |
fk_user_author integer |
1131 |
); |
1132 |
|
1133 |
|
1134 |
create table llx_livre |
1135 |
( |
1136 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1137 |
oscid integer NOT NULL, |
1138 |
tms timestamp, |
1139 |
status tinyint, |
1140 |
date_ajout datetime, |
1141 |
ref varchar(12), |
1142 |
title varchar(64), |
1143 |
annee smallint(64), |
1144 |
description text, |
1145 |
prix decimal(15,4), |
1146 |
fk_editeur integer, |
1147 |
fk_user_author integer, |
1148 |
frais_de_port tinyint default 1, |
1149 |
|
1150 |
UNIQUE(ref) |
1151 |
); |
1152 |
|
1153 |
|
1154 |
create table llx_auteur |
1155 |
( |
1156 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1157 |
oscid integer NOT NULL, |
1158 |
tms timestamp, |
1159 |
nom varchar(255), |
1160 |
fk_user_author integer |
1161 |
); |
1162 |
|
1163 |
create table llx_editeur |
1164 |
( |
1165 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1166 |
oscid integer NOT NULL, |
1167 |
tms timestamp, |
1168 |
nom varchar(255), |
1169 |
fk_user_author integer |
1170 |
); |
1171 |
|
1172 |
|
1173 |
create table llx_newsletter |
1174 |
( |
1175 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1176 |
datec datetime, |
1177 |
tms timestamp, |
1178 |
email_subject varchar(32) NOT NULL, |
1179 |
email_from_name varchar(255) NOT NULL, |
1180 |
email_from_email varchar(255) NOT NULL, |
1181 |
email_replyto varchar(255) NOT NULL, |
1182 |
email_body text, |
1183 |
target smallint, |
1184 |
sql_target text, |
1185 |
status smallint NOT NULL DEFAULT 0, |
1186 |
date_send_request datetime, |
1187 |
date_send_begin datetime, |
1188 |
date_send_end datetime, |
1189 |
nbsent integer, |
1190 |
nberror integer, |
1191 |
fk_user_author integer, |
1192 |
fk_user_valid integer, |
1193 |
fk_user_modif integer |
1194 |
); |
1195 |
|
1196 |
|
1197 |
create table llx_facture_fourn_det |
1198 |
( |
1199 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1200 |
fk_facture_fourn integer NOT NULL, |
1201 |
fk_product integer NULL, |
1202 |
description text, |
1203 |
pu_ht real default 0, |
1204 |
qty smallint default 1, |
1205 |
total_ht real default 0, |
1206 |
tva_taux real default 0, |
1207 |
tva real default 0, |
1208 |
total_ttc real default 0 |
1209 |
|
1210 |
); |
1211 |
|
1212 |
create table llx_paiementfourn |
1213 |
( |
1214 |
rowid integer AUTO_INCREMENT PRIMARY KEY, |
1215 |
tms timestamp, |
1216 |
datec datetime, |
1217 |
fk_facture_fourn integer, |
1218 |
datep datetime, |
1219 |
amount real default 0, |
1220 |
fk_user_author integer, |
1221 |
fk_paiement integer NOT NULL, |
1222 |
num_paiement varchar(50), |
1223 |
note text |
1224 |
); |
1225 |
|
1226 |
insert into llx_cond_reglement values (1,1,1, "A réception","Réception de facture",0,0); |
1227 |
insert into llx_cond_reglement values (2,2,1, "30 jours","Réglement à 30 jours",0,30); |
1228 |
insert into llx_cond_reglement values (3,3,1, "30 jours fin de mois","Réglement à 30 jours fin de mois",1,30); |
1229 |
insert into llx_cond_reglement values (4,4,1, "60 jours","Réglement à 60 jours",0,60); |
1230 |
insert into llx_cond_reglement values (5,5,1, "60 jours fin de mois","Réglement à 60 jours fin de mois",1,60); |
1231 |
|
1232 |
|
1233 |
insert into llx_sqltables (name, loaded) values ('llx_album',0); |
1234 |
|
1235 |
delete from llx_action_def; |
1236 |
insert into llx_action_def (rowid,titre,description,objet_type) VALUES (1,'Validation fiche intervention','Déclenché lors de la validation d\'une fiche d\'intervention','ficheinter'); |
1237 |
insert into llx_action_def (rowid,titre,description,objet_type) VALUES (2,'Validation facture','Déclenché lors de la validation d\'une facture','facture'); |
1238 |
|
1239 |
delete from llx_boxes_def; |
1240 |
|
1241 |
delete from llx_boxes; |
1242 |
insert into llx_const(name, value, type, note) values ('MAIN_MONNAIE','euros','chaine','Monnaie'); |
1243 |
insert into llx_const(name, value, type, note) values ('MAIN_NOT_INSTALLED','1','chaine','Test d\'installation'); |
1244 |
|
1245 |
insert into llx_const(name, value, type, note) values ('MAIN_START_YEAR','2003','chaine','Année de départ'); |
1246 |
|
1247 |
INSERT INTO llx_const (name, value, type, note) VALUES ('MAIN_THEME','yellow','chaine','Thème par défaut'); |
1248 |
INSERT INTO llx_const (name, value, type, note) VALUES ('MAIN_TITLE','Dolibarr','chaine','Titre des pages'); |
1249 |
|
1250 |
|
1251 |
insert into llx_const(name, value, type) values ('DONS_FORM','fsfe.fr.php','chaine'); |
1252 |
|
1253 |
|
1254 |
|
1255 |
insert into llx_const(name, value, type, note) values ('MAIN_SEARCHFORM_SOCIETE','1','yesno','Affichage du formulaire de recherche des sociétés dans la barre de gauche'); |
1256 |
insert into llx_const(name, value, type, note) values ('MAIN_SEARCHFORM_CONTACT','1','yesno','Affichage du formulaire de recherche des contacts dans la barre de gauche'); |
1257 |
|
1258 |
insert into llx_const(name, value, type, note) values ('COMPTA_ONLINE_PAYMENT_BPLC','1','yesno','Système de gestion de la banque populaire de Lorraine'); |
1259 |
|
1260 |
insert into llx_const(name, value, type, note) values ('COMPTA_BANK_FACTURES','1','yesno','Menu factures dans la partie bank'); |
1261 |
|
1262 |
|
1263 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_RESIL','Votre adhesion sur %SERVEUR% vient d\'etre resilie.\r\nNous esperons vous revoir tres bientot','texte','Mail de Resiliation'); |
1264 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_VALID','MAIN\r\nVotre adhesion vient d\'etre validee. \r\nVoici le rappel de vos coordonnees (toute information erronee entrainera la non validation de votre inscription) :\r\n\r\n%INFO%\r\n\r\nVous pouvez a tout moment, grace a votre login et mot de passe, modifier vos coordonnees a l\'adresse suivante : \r\n%SERVEUR%public/adherents/','texte','Mail de validation'); |
1265 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_EDIT','Voici le rappel des coordonnees que vous avez modifiees (toute information erronee entrainera la non validation de votre inscription) :\r\n\r\n%INFO%\r\n\r\nVous pouvez a tout moment, grace a votre login et mot de passe, modifier vos coordonnees a l\'adresse suivante :\r\n%SERVEUR%public/adherents/','texte','Mail d\'edition'); |
1266 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_NEW','Merci de votre inscription. Votre adhesion devrait etre rapidement validee.\r\nVoici le rappel des coordonnees que vous avez rentrees (toute information erronee entrainera la non validation de votre inscription) :\r\n\r\n%INFO%\r\n\r\nVous pouvez a tout moment, grace a votre login et mot de passe, modifier vos coordonnees a l\'adresse suivante :\r\n%SERVEUR%public/adherents/','texte','Mail de nouvel inscription'); |
1267 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_COTIS','Bonjour %PRENOM%,\r\nMerci de votre inscription.\r\nCet email confirme que votre cotisation a ete recue et enregistree.\r\n\r\nVous pouvez a tout moment, grace a votre login et mot de passe, modifier vos coordonnees a l\'adresse suivante :\r\n%SERVEUR%public/adherents/','texte','Mail de validation de cotisation'); |
1268 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_VALID_SUBJECT','Votre adhésion a ete validée sur %SERVEUR%','chaine','sujet du mail de validation'); |
1269 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_RESIL_SUBJECT','Resiliation de votre adhesion sur %SERVEUR%','chaine','sujet du mail de resiliation'); |
1270 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_COTIS_SUBJECT','Recu de votre cotisation','chaine','sujet du mail de validation de cotisation'); |
1271 |
INSERT INTO llx_const (name, value, type, note) VALUES ('SIZE_LISTE_LIMIT','20','chaine','Taille des listes'); |
1272 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_NEW_SUBJECT','Bienvenue sur %SERVEUR%','chaine','Sujet du mail de nouvelle adhesion'); |
1273 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_EDIT_SUBJECT','Votre fiche a ete editee sur %SERVEUR%','chaine','Sujet du mail d\'edition'); |
1274 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_USE_MAILMAN','0','yesno','Utilisation de Mailman'); |
1275 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAILMAN_UNSUB_URL','http://%SERVER%/cgi-bin/mailman/admin/%LISTE%/members?adminpw=%ADMINPW%&user=%EMAIL%','chaine','Url de desinscription aux listes mailman'); |
1276 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAILMAN_URL','http://%SERVER%/cgi-bin/mailman/admin/%LISTE%/members?adminpw=%ADMINPW%&send_welcome_msg_to_this_batch=1&subscribees=%EMAIL%','chaine','url pour les inscriptions mailman'); |
1277 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAILMAN_LISTS','test-test,test-test2','chaine','Listes auxquelles inscrire les nouveaux adherents'); |
1278 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_MAILMAN_ADMINPW','','string','Mot de passe Admin des liste mailman',0); |
1279 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_MAILMAN_SERVER','lists.domain.com','string','Serveur hebergeant les interfaces d\'Admin des listes mailman',0); |
1280 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_MAILMAN_LISTS_COTISANT','','string','Liste(s) auxquelles les nouveaux cotisants sont inscris automatiquement',0); |
1281 |
|
1282 |
INSERT INTO llx_const (name, value, type, note) VALUES ('MAIN_DEBUG','1','yesno','Debug ..'); |
1283 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_USE_GLASNOST','0','yesno','utilisation de glasnost ?'); |
1284 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_GLASNOST_SERVEUR','glasnost.j1b.org','chaine','serveur glasnost'); |
1285 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_GLASNOST_USER','user','chaine','Administrateur glasnost'); |
1286 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_GLASNOST_PASS','password','chaine','password de l\'administrateur'); |
1287 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_USE_GLASNOST_AUTO','0','yesno','inscription automatique a glasnost ?'); |
1288 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_USE_SPIP','0','yesno','Utilisation de SPIP ?'); |
1289 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_USE_SPIP_AUTO','0','yesno','Utilisation de SPIP automatiquement'); |
1290 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_SPIP_USER','user','chaine','user spip'); |
1291 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_SPIP_PASS','pass','chaine','Pass de connection'); |
1292 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_SPIP_SERVEUR','localhost','chaine','serveur spip'); |
1293 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_SPIP_DB','spip','chaine','db spip'); |
1294 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_TEXT_NEW_ADH','','texte','Texte d\'entete du formaulaire d\'adhesion en ligne',0); |
1295 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_CARD_HEADER_TEXT','%ANNEE%','string','Texte imprime sur le haut de la carte adherent',0); |
1296 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_CARD_FOOTER_TEXT','Association FreeLUG http://www.freelug.org/','string','Texte imprime sur le bas de la carte adherent',0); |
1297 |
insert into llx_const(name, value, type, note, visible) values ('ADHERENT_CARD_TEXT','%TYPE% n° %ID%\r\n%PRENOM% %NOM%\r\n<%EMAIL%>\r\n%ADRESSE%\r\n%CP% %VILLE%\r\n%PAYS%','texte','Texte imprime sur la carte adherent',0); |
1298 |
INSERT INTO llx_const(name, value, type) VALUES ('DB_NAME_OSC','catalog','chaine'); |
1299 |
INSERT INTO llx_const(name, value, type) VALUES ('OSC_LANGUAGE_ID','1','chaine'); |
1300 |
INSERT INTO llx_const(name, value, type) VALUES ('OSC_CATALOG_URL','http://osc.lafrere.lan/','chaine'); |
1301 |
INSERT INTO llx_const (name, value, type, note) VALUES ('MAIN_MAIL_FROM','adherents@domain.com','chaine','From des mails'); |
1302 |
INSERT INTO llx_const (name, value, type, note) VALUES ('ADHERENT_MAIL_FROM','adherents@domain.com','chaine','From des mails adherents'); |
1303 |
INSERT INTO llx_const (name, value, type, note) VALUES ('MAIN_MENU_BARRETOP','default.php','chaine','Module commande'); |
1304 |
|
1305 |
|
1306 |
delete from c_chargesociales; |
1307 |
insert into c_chargesociales (id,libelle,deductible) values ( 1, 'Allocations familiales',1); |
1308 |
insert into c_chargesociales (id,libelle,deductible) values ( 2, 'GSG Deductible',1); |
1309 |
insert into c_chargesociales (id,libelle,deductible) values ( 3, 'GSG/CRDS NON Deductible',0); |
1310 |
|
1311 |
|
1312 |
delete from c_actioncomm; |
1313 |
insert into c_actioncomm (id,libelle) values ( 0, '-'); |
1314 |
insert into c_actioncomm (id,libelle) values ( 1, 'Appel Téléphonique'); |
1315 |
insert into c_actioncomm (id,libelle) values ( 2, 'Envoi Fax'); |
1316 |
insert into c_actioncomm (id,libelle) values ( 3, 'Envoi propal par mail'); |
1317 |
insert into c_actioncomm (id,libelle) values ( 4, 'Envoi d\'un email'); |
1318 |
insert into c_actioncomm (id,libelle) values ( 5, 'Rendez-vous'); |
1319 |
insert into c_actioncomm (id,libelle) values ( 9, 'Envoi Facture'); |
1320 |
insert into c_actioncomm (id,libelle) values (10, 'Relance effectuée'); |
1321 |
insert into c_actioncomm (id,libelle) values (11, 'Clôture'); |
1322 |
|
1323 |
delete from c_stcomm; |
1324 |
insert into c_stcomm (id,libelle) values (-1, 'NE PAS CONTACTER'); |
1325 |
insert into c_stcomm (id,libelle) values ( 0, 'Jamais contacté'); |
1326 |
insert into c_stcomm (id,libelle) values ( 1, 'A contacter'); |
1327 |
insert into c_stcomm (id,libelle) values ( 2, 'Contact en cours'); |
1328 |
insert into c_stcomm (id,libelle) values ( 3, 'Contactée'); |
1329 |
|
1330 |
delete from c_typent; |
1331 |
insert into c_typent (id,libelle) values ( 0, 'Indifférent'); |
1332 |
insert into c_typent (id,libelle) values ( 1, 'Start-up'); |
1333 |
insert into c_typent (id,libelle) values ( 2, 'Grand groupe'); |
1334 |
insert into c_typent (id,libelle) values ( 3, 'PME/PMI'); |
1335 |
insert into c_typent (id,libelle) values ( 4, 'Administration'); |
1336 |
insert into c_typent (id,libelle) values (100, 'Autres'); |
1337 |
|
1338 |
delete from c_pays; |
1339 |
insert into c_pays (id,libelle,code) values (0, 'France', 'FR'); |
1340 |
insert into c_pays (id,libelle,code) values (2, 'Belgique', 'BE'); |
1341 |
insert into c_pays (id,libelle,code) values (3, 'Italie', 'IT'); |
1342 |
insert into c_pays (id,libelle,code) values (4, 'Espagne', 'ES'); |
1343 |
insert into c_pays (id,libelle,code) values (5, 'Allemagne', 'DE'); |
1344 |
insert into c_pays (id,libelle,code) values (6, 'Suisse', 'CH'); |
1345 |
insert into c_pays (id,libelle,code) values (7, 'Royaume uni', 'GB'); |
1346 |
insert into c_pays (id,libelle,code) values (8, 'Irlande', 'IE'); |
1347 |
insert into c_pays (id,libelle,code) values (9, 'Chine', 'CN'); |
1348 |
insert into c_pays (id,libelle,code) values (10, 'Tunisie', 'TN'); |
1349 |
insert into c_pays (id,libelle,code) values (11, 'Etats Unis', 'US'); |
1350 |
insert into c_pays (id,libelle,code) values (12, 'Maroc', 'MA'); |
1351 |
insert into c_pays (id,libelle,code) values (13, 'Algérie', 'DZ'); |
1352 |
insert into c_pays (id,libelle,code) values (14, 'Canada', 'CA'); |
1353 |
insert into c_pays (id,libelle,code) values (15, 'Togo', 'TG'); |
1354 |
insert into c_pays (id,libelle,code) values (16, 'Gabon', 'GA'); |
1355 |
insert into c_pays (id,libelle,code) values (17, 'Pays Bas', 'NL'); |
1356 |
insert into c_pays (id,libelle,code) values (18, 'Hongrie', 'HU'); |
1357 |
insert into c_pays (id,libelle,code) values (19, 'Russie', 'RU'); |
1358 |
insert into c_pays (id,libelle,code) values (20, 'Suède', 'SE'); |
1359 |
insert into c_pays (id,libelle,code) values (21, 'Côte d\'Ivoire', 'CI'); |
1360 |
insert into c_pays (id,libelle,code) values (23, 'Sénégal', 'SN'); |
1361 |
insert into c_pays (id,libelle,code) values (24, 'Argentine', 'AR'); |
1362 |
insert into c_pays (id,libelle,code) values (25, 'Cameroun', 'CM'); |
1363 |
|
1364 |
delete from c_effectif; |
1365 |
insert into c_effectif (id,libelle) values (0, 'Non spécifié'); |
1366 |
insert into c_effectif (id,libelle) values (1, '1 - 5'); |
1367 |
insert into c_effectif (id,libelle) values (2, '6 - 10'); |
1368 |
insert into c_effectif (id,libelle) values (3, '11 - 50'); |
1369 |
insert into c_effectif (id,libelle) values (4, '51 - 100'); |
1370 |
insert into c_effectif (id,libelle) values (5, '100 - 500'); |
1371 |
insert into c_effectif (id,libelle) values (6, '> 500'); |
1372 |
|
1373 |
delete from c_paiement; |
1374 |
insert into c_paiement (id,libelle,type) values (0, '-', 3); |
1375 |
insert into c_paiement (id,libelle,type) values (1, 'TIP', 1); |
1376 |
insert into c_paiement (id,libelle,type) values (2, 'Virement', 2); |
1377 |
insert into c_paiement (id,libelle,type) values (3, 'Prélèvement', 1); |
1378 |
insert into c_paiement (id,libelle,type) values (4, 'Liquide', 0); |
1379 |
insert into c_paiement (id,libelle,type) values (5, 'Paiement en ligne', 0); |
1380 |
insert into c_paiement (id,libelle,type) values (6, 'CB', 1); |
1381 |
insert into c_paiement (id,libelle,type) values (7, 'Chèque', 2); |
1382 |
|
1383 |
delete from c_propalst; |
1384 |
insert into c_propalst (id,label) values (0, 'Brouillon'); |
1385 |
insert into c_propalst (id,label) values (1, 'Ouverte'); |
1386 |
insert into c_propalst (id,label) values (2, 'Signée'); |
1387 |
insert into c_propalst (id,label) values (3, 'Non Signée'); |
1388 |
insert into c_propalst (id,label) values (4, 'Facturée'); |
1389 |
|
1390 |
|
1391 |
insert into llx_user (name,firstname,code,login,pass,module_comm,module_compta,admin) |
1392 |
values ('Admin','Admin','ADM','admin','admin',1,1,1); |