/[dolibarr]/dolibarr/mysql/mysql.sql
ViewVC logotype

Contents of /dolibarr/mysql/mysql.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.33 - (show annotations) (download)
Sat Jan 24 12:16:36 2004 UTC (20 years, 4 months ago) by rodolphe
Branch: MAIN
Changes since 1.32: +205 -184 lines
Ajout de la table birthday et suppression de tous les commentaires suite au bug de phpmyadmin

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);

savannah-hackers-public@gnu.org
ViewVC Help
Powered by ViewVC 1.1.26