Username: Password: \connect - pimengest CREATE SEQUENCE "refrdv_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; CREATE SEQUENCE "object_uid_seq" start 9573 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"object_uid_seq"'); CREATE SEQUENCE "rapprochement_uid_seq" start 1338 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"rapprochement_uid_seq"'); CREATE SEQUENCE "devis_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; CREATE SEQUENCE "rdvstate_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; CREATE TABLE "pga_reports" ( "reportname" character varying(64), "reportsource" text, "reportbody" text, "reportprocs" text, "reportoptions" text ); REVOKE ALL on "pga_reports" from PUBLIC; GRANT ALL on "pga_reports" to PUBLIC; CREATE TABLE "pga_schema" ( "schemaname" character varying(64), "schematables" text, "schemalinks" text ); REVOKE ALL on "pga_schema" from PUBLIC; GRANT ALL on "pga_schema" to PUBLIC; CREATE TABLE "pga_layout" ( "tablename" character varying(64), "nrcols" int2, "colnames" text, "colwidth" text ); REVOKE ALL on "pga_layout" from PUBLIC; GRANT ALL on "pga_layout" to PUBLIC; CREATE TABLE "reglement" ( "factures" oid, "client" oid, "datepaye" date, "montant" float8, "uid" int4, "rapproche" int4, "devise" oid, "nocheque" text, "groupe_ecriture" oid ); CREATE TABLE "factures" ( "client" oid, "id" text, "dateemission" date, "dateecheance" date, "montantht" float8, "montanttc" float8, "regle" float8, "du" float8, "description" text, "uid" int4, "abstract" text, "envoye" int4, "devise" oid, "groupe_ecriture" oid ); CREATE TABLE "structtable" ( "champ" text, "denom" text, "editable" int4, "rang" int4, "isoid" bool, "type" text, "defaut" text, "uid" int4, "disp" text ); CREATE TABLE "structconstantes" ( ) inherits ("structtable"); CREATE TABLE "structintervenant" ( ) inherits ("structtable"); CREATE TABLE "structreglement" ( ) inherits ("structtable"); CREATE TABLE "structfactures" ( ) inherits ("structtable"); CREATE TABLE "structachat" ( ) inherits ("structtable"); CREATE TABLE "structcharges" ( ) inherits ("structtable"); CREATE TABLE "typepaiement" ( "nom" text, "uid" int4 ); CREATE TABLE "structtypepaiement" ( ) inherits ("structtable"); CREATE TABLE "achat" ( "fournisseur" oid, "factures" text, "datepaye" date, "montantht" float8, "montanttc" float8, "libelle" text, "typepaiement" oid, "uid" int4, "nocheque" text, "abstract" text, "paye" int4, "rapproche" int4, "devise" oid, "groupe_ecriture" oid ); CREATE TABLE "structuserid" ( ) inherits ("structtable"); CREATE TABLE "structsalaire" ( ) inherits ("structtable"); CREATE TABLE "typesalaire" ( "no" int4, "nom" text, "uid" int4 ); CREATE TABLE "structtypesalaire" ( ) inherits ("structtable"); CREATE TABLE "salaire" ( "intervenant" oid, "net" float8, "brut" float8, "mois" int4, "typesalaire" oid, "comment" text, "uid" int4, "annee" int4, "paye" int4, "devise" oid, "groupe_ecriture" oid, "typepaiement" oid, "nocheque" text ); CREATE TABLE "structtypeactivite" ( ) inherits ("structtable"); CREATE TABLE "devis" ( "uid" int4 DEFAULT nextval('devis_uid_seq'::text) NOT NULL, "client" oid, "id" text, "dateemission" date, "dateecheance" date, "montantht" float8, "montanttc" float8, "abstract" text, "description" text, "envoye" int4, "accepte" int4, "factures" oid, "fichier" text, "devise" oid ); CREATE TABLE "structdevis" ( ) inherits ("structtable"); CREATE TABLE "charges" ( "organisme" oid, "cheque" text, "datepaye" date, "montant" float8, "libelle" text, "uid" int4, "abstract" text, "paye" int4, "rapproche" int4, "devise" oid, "groupe_ecriture" oid ); CREATE TABLE "ch_sociales" ( "organisme" oid, "cheque" text, "datepaye" date, "montant" float8, "libelle" text, "uid" int4, "abstract" text, "paye" int4, "rapproche" int4, "devise" oid ); CREATE TABLE "structch_sociales" ( ) inherits ("structtable"); CREATE TABLE "refrdv" ( "uid" int4 DEFAULT nextval('refrdv_uid_seq'::text) NOT NULL, "rendezvous" oid, "personne" oid, "intervenant" oid ); CREATE TABLE "structrefrdv" ( ) inherits ("structtable"); CREATE TABLE "pga_queries" ( "queryname" character varying(64), "querytype" character, "querycommand" text, "querytables" text, "querylinks" text, "queryresults" text, "querycomments" text ); REVOKE ALL on "pga_queries" from PUBLIC; GRANT ALL on "pga_queries" to PUBLIC; CREATE TABLE "pga_forms" ( "formname" character varying(64), "formsource" text ); REVOKE ALL on "pga_forms" from PUBLIC; GRANT ALL on "pga_forms" to PUBLIC; CREATE TABLE "rdvstate" ( "state" text, "uid" int4 DEFAULT nextval('rdvstate_uid_seq'::text) NOT NULL ); CREATE TABLE "structrdvstate" ( ) inherits ("structtable"); CREATE TABLE "formule" ( "uid" int4 DEFAULT nextid(), "contenu" text ); CREATE TABLE "structformule" ( ) inherits ("structtable"); CREATE TABLE "relance" ( "uid" int4, "client" oid, "daterelance" date, "intervenant" oid, "object" text, "civilite" text, "texte" text, "formule" oid ); CREATE TABLE "structrelance" ( ) inherits ("structtable"); CREATE TABLE "agenda" ( "uid" int4, "tsp_start" timestamp, "duree" interval, "typeactivite" oid, "comment" text, "statut" int4, "intervenant" oid ); CREATE TABLE "jhomme" ( "prix" float8, "factures" oid, "date" date, "client" oid ) inherits ("agenda"); CREATE TABLE "rendezvous" ( "personne" oid, "objet" text ) inherits ("agenda"); CREATE TABLE "structrendezvous" ( ) inherits ("structtable"); CREATE TABLE "structjhomme" ( ) inherits ("structtable"); CREATE TABLE "structagenda" ( ) inherits ("structtable"); CREATE TABLE "typeactivite" ( "uid" int4 DEFAULT nextid(), "nom" text, "prixdefaut" float8, "reftable" text ); CREATE TABLE "structpersonne" ( ) inherits ("structtable"); CREATE TABLE "personne" ( "adr1" text, "adr2" text, "cp" text, "ville" text, "tel" text, "fax" text, "nom" text, "uid" int4, "email" text, "compte" oid ); CREATE TABLE "structsociete" ( ) inherits ("structtable"); CREATE TABLE "societe" ( "categorie" text, "siret" text, "uetva" text, "typesociete" oid, "capital" text, "url" text ) inherits ("personne"); CREATE TABLE "structclient" ( ) inherits ("structtable"); CREATE TABLE "client" ( "prixjh" float8 ) inherits ("societe"); CREATE TABLE "fournisseur" ( ) inherits ("societe"); CREATE TABLE "structfournisseur" ( ) inherits ("structtable"); CREATE TABLE "organisme" ( "categorie" text ) inherits ("personne"); CREATE TABLE "structorganisme" ( ) inherits ("structtable"); CREATE TABLE "contact" ( "prenom" text, "telmobile" text, "sujet" text, "commentaire" text, "mail" text, "web" text, "societe" oid, "fonction" oid ) inherits ("personne"); CREATE TABLE "structcontact" ( ) inherits ("structtable"); CREATE TABLE "lettre" ( "uid" int4, "personne" oid, "dateenvoi" date, "intervenant" oid, "object" text, "civilite" text, "texte" text, "formule" oid ); CREATE TABLE "structlettre" ( ) inherits ("structtable"); CREATE TABLE "intervenant" ( "prenom" text, "datenaissance" date, "telmobile" text, "nosecu" text, "dateentree" date, "datesortie" date ) inherits ("personne"); CREATE TABLE "rights" ( "uid" int4, "structtable" oid, "intervenant" oid, "read" int4, "write" int4 ); CREATE TABLE "structrights" ( ) inherits ("structtable"); CREATE TABLE "structstructtable" ( ) inherits ("structtable"); CREATE TABLE "maboite" ( "logo" text, "headerdoc" text, "footerdoc" text ) inherits ("societe"); CREATE TABLE "structmaboite" ( ) inherits ("structtable"); CREATE TABLE "typesociete" ( "nom" text, "nomlong" text, "uid" int4 ); CREATE TABLE "structtypesociete" ( ) inherits ("structtable"); CREATE TABLE "statut" ( "nom" text, "uid" int4 ); CREATE TABLE "structstatut" ( ) inherits ("structtable"); CREATE TABLE "userid" ( "id" text, "pwd" text, "personne" oid, "statut" int4, "uid" int4 ); CREATE TABLE "banque" ( "code_banque" text, "code_guichet" text ) inherits ("societe"); CREATE TABLE "structbanque" ( "champ" text, "denom" text, "editable" int4, "rang" int4, "isoid" bool, "type" text, "defaut" text, "uid" int4, "disp" text ); CREATE TABLE "compte_banque" ( "uid" int4, "rib" text, "nocompte" text, "libelle" text, "nomcompte" text, "banque" oid, "compte" oid ); CREATE TABLE "structcompte_banque" ( ) inherits ("structtable"); CREATE TABLE "mouvement_banque" ( "devise" oid, "f" text, "x" text, "libelle" text, "montant_franc" float8, "montant_euro" float8, "date" date, "date_valeur" date, "uid" int4, "compte_banque" oid ); CREATE TABLE "structmouvement_banque" ( ) inherits ("structtable"); CREATE TABLE "devise" ( "nom" text, "abbrev" text, "nbeuros" float8, "uid" int4 ); CREATE TABLE "structdevise" ( ) inherits ("structtable"); CREATE TABLE "tmprapproch" ( "uid" int4, "mouvement_banque" oid, "achat" oid, "charges" oid, "ch_sociales" oid, "reglement" oid, "salaire" oid ); CREATE TABLE "object" ( "uid" int4 DEFAULT nextval('object_uid_seq'::text) NOT NULL, "authcrea" oid, "authmodif" oid, "datecrea" date, "datemodif" date ); CREATE TABLE "structobject" ( ) inherits ("structtable"); CREATE TABLE "compte" ( "id" text, "intitule" text, "credit" float8, "debit" float8, "solde" float8 ) inherits ("object"); CREATE TABLE "structcompte" ( ) inherits ("structtable"); CREATE TABLE "ecriture" ( "action" text, "compte" oid, "valeur" float8, "intitule" text, "date" date, "groupe_ecriture" oid, "exercice" int4, CONSTRAINT "ecriture_action" CHECK ((("action" = 'credite'::text) OR ("action" = 'debite'::text))) ) inherits ("object"); CREATE TABLE "structecriture" ( ) inherits ("structtable"); CREATE TABLE "brouillard" ( "action" text, "compte" oid, "valeur" float8, "intitule" text, "date" date, "groupe_ecriture" oid, "exercice" int4, CONSTRAINT "brouillard_action" CHECK ((("action" = 'credite'::text) OR ("action" = 'debite'::text))) ) inherits ("object"); CREATE TABLE "structbrouillard" ( ) inherits ("structtable"); CREATE TABLE "groupe_ecriture" ( "libelle" text, "valide" int4, "exercice" int4 ) inherits ("object"); CREATE TABLE "structgroupe_ecriture" ( ) inherits ("structtable"); CREATE TABLE "rapprochement" ( "uid" int4 DEFAULT nextval('rapprochement_uid_seq'::text) NOT NULL, "mouvement_banque" oid, "ecriture" oid ); CREATE TABLE "structrapprochement" ( ) inherits ("structtable"); CREATE TABLE "typeaction" ( "nom" text ) inherits ("object"); CREATE TABLE "action_crm" ( "intervenant" oid, "contact" oid, "typeaction" oid, "date" timestamp, "reaction" int4, "commentaire" text, "todo_act" int4 ) inherits ("object"); CREATE TABLE "structtypeaction" ( ) inherits ("structtable"); CREATE TABLE "structaction_crm" ( ) inherits ("structtable"); CREATE TABLE "fonction" ( "nom" text ) inherits ("object"); CREATE TABLE "structfonction" ( ) inherits ("structtable"); CREATE TABLE "reaction" ( "nom" text ) inherits ("object"); CREATE TABLE "structreaction" ( ) inherits ("structtable"); CREATE TABLE "todo_act" ( "nom" text ) inherits ("object"); CREATE TABLE "structtodo_act" ( ) inherits ("structtable"); CREATE TABLE "img_chq" ( "image" text, "groupe_ecriture" oid ) inherits ("object"); CREATE TABLE "structimg_chq" ( ) inherits ("structtable"); \connect - postgres CREATE FUNCTION "modif_gecr" ( ) RETURNS opaque AS 'begin IF OLD.libelle != NEW.libelle THEN IF OLD.valide=1 THEN update ecriture set intitule=NEW.libelle,datemodif=''now'' where groupe_ecriture=OLD.uid; END IF; IF OLD.valide=0 THEN update brouillard set intitule=NEW.libelle,datemodif=''now'' where groupe_ecriture=OLD.uid; END IF; END IF; IF OLD.valide != NEW.valide THEN IF OLD.valide=1 THEN RAISE NOTICE ''Chgt de validation. % -> %'',OLD.valide,NEW.valide; insert into brouillard select * from ecriture where groupe_ecriture=OLD.uid; update brouillard set intitule=NEW.libelle,datemodif=''now'' where groupe_ecriture=OLD.uid; delete from ecriture where groupe_ecriture=OLD.uid; END IF; IF OLD.valide=0 THEN RAISE NOTICE ''Chgt de validation. % -> %'',OLD.valide,NEW.valide; insert into ecriture select * from brouillard where groupe_ecriture=OLD.uid; update ecriture set intitule=NEW.libelle,datemodif=''now'' where groupe_ecriture=OLD.uid; delete from brouillard where groupe_ecriture=OLD.uid; END IF; END IF; NEW.datemodif=''now''; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "create_compte_organisme" ( ) RETURNS opaque AS ' DECLARE tt integer; begin tt:=nextval(''object_uid_seq''::text); insert into compte (id,intitule,credit,debit,uid) values (''401'' || NEW.nom,NEW.nom,0,0,tt); NEW.compte=tt; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "destroy_gecr" ( ) RETURNS opaque AS ' begin update groupe_ecriture set valide=0 where uid = OLD.uid; insert into brouillard select * from ecriture where groupe_ecriture = OLD.uid ; delete from ecriture where groupe_ecriture = OLD.uid ; update brouillard set datemodif=''now'' where groupe_ecriture = OLD.uid ; return OLD; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "modif_compte" ( ) RETURNS opaque AS 'declare source record; dest record; begin select * into source from compte where uid=NEW.compte; IF NOT FOUND THEN RAISE EXCEPTION ''compte for % uid = % not found'', NEW.action,NEW.compte; END IF; RAISE NOTICE ''code compte source : %'', source.uid; IF NEW.action=''credite'' THEN update compte set datemodif=''now'',credit=credit+NEW.valeur where uid=source.uid; END IF; IF NEW.action=''debite'' THEN update compte set datemodif=''now'',debit=debit+NEW.valeur where uid=source.uid; END IF; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "create_compte_client" ( ) RETURNS opaque AS ' DECLARE tt integer; begin tt:=nextval(''object_uid_seq''::text); insert into compte (id,intitule,credit,debit,uid) values (''411'' || NEW.nom,NEW.nom,0,0,tt); NEW.compte:=tt; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "create_compte_fournisseur" ( ) RETURNS opaque AS ' DECLARE tt integer; begin tt:=nextval(''object_uid_seq''::text); insert into compte (id,intitule,credit,debit,uid) values (''401'' || NEW.nom,NEW.nom,0,0,tt); NEW.compte=tt; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "compute_solde" ( ) RETURNS opaque AS ' begin NEW.solde=NEW.debit-NEW.credit; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE FUNCTION "erase_ecriture" ( ) RETURNS opaque AS ' declare source record; dest record; begin RAISE NOTICE ''Suppression ecriture''; select * into source from compte where uid=OLD.compte; IF NOT FOUND THEN RAISE EXCEPTION ''compte for % uid = % not found'', OLD.action,OLD.compte; END IF; --RAISE NOTICE ''code compte source : %'', source.uid; IF OLD.action=''credite'' THEN update compte set credit=credit-OLD.valeur where uid=source.uid; END IF; IF OLD.action=''debite'' THEN update compte set debit=debit-OLD.valeur where uid=source.uid; END IF; RETURN OLD; end; ' LANGUAGE 'plpgsql'; \connect - pimengest INSERT INTO "constantes" ("tva","salairenet","defaultjh","uid") VALUES (0.206,10000,3500,359722); INSERT INTO "pga_reports" ("reportname","reportsource","reportbody","reportprocs","reportoptions") VALUES ('totaux','factures','set PgAcVar(report,tablename) "factures" ; set PgAcVar(report,y_rpthdr) 27 ; set PgAcVar(report,y_pghdr) 73 ; set PgAcVar(report,y_detail) 103 ; set PgAcVar(report,y_pgfoo) 132 ; set PgAcVar(report,y_rptfoo) 162 ; .pgaw:ReportBuilder.c create text 8 43 -font -Adobe-Helvetica-Bold-R-Normal--*-120-*-*-*-*-*-* -anchor nw -text {client} -tags {t_l mov ro} ; .pgaw:ReportBuilder.c create text 10 78 -font -Adobe-Helvetica-Medium-R-Normal-*-*-120-*-*-*-*-* -anchor nw -text {client} -tags {f-client t_f rg_detail mov ro} ; .pgaw:ReportBuilder.c create text 55 43 -font -Adobe-Helvetica-Bold-R-Normal--*-120-*-*-*-*-*-* -anchor nw -text {montantht} -tags {t_l mov ro} ; .pgaw:ReportBuilder.c create text 53 78 -font -Adobe-Helvetica-Medium-R-Normal-*-*-120-*-*-*-*-* -anchor nw -text {montantht} -tags {f-montantht t_f rg_detail mov ro} ; .pgaw:ReportBuilder.c create text 135 42 -font -Adobe-Helvetica-Bold-R-Normal--*-120-*-*-*-*-*-* -anchor nw -text {montanttc} -tags {t_l mov ro} ; .pgaw:ReportBuilder.c create text 139 79 -font -Adobe-Helvetica-Medium-R-Normal-*-*-120-*-*-*-*-* -anchor nw -text {montanttc} -tags {f-montanttc t_f rg_detail mov ro} ; .pgaw:ReportBuilder.c create text 216 42 -font -Adobe-Helvetica-Bold-R-Normal--*-120-*-*-*-*-*-* -anchor nw -text {regle} -tags {t_l mov ro} ; .pgaw:ReportBuilder.c create text 215 80 -font -Adobe-Helvetica-Medium-R-Normal-*-*-120-*-*-*-*-* -anchor nw -text {regle} -tags {f-regle t_f rg_detail mov ro} ; .pgaw:ReportBuilder.c create text 312 40 -font -Adobe-Helvetica-Bold-R-Normal--*-120-*-*-*-*-*-* -anchor ne -text {du} -tags {t_l mov ro} ; .pgaw:ReportBuilder.c create text 296 80 -font -Adobe-Helvetica-Medium-R-Normal-*-*-120-*-*-*-*-* -anchor nw -text {du} -tags {f-du t_f rg_detail mov ro}',NULL,NULL); INSERT INTO "pga_schema" ("schemaname","schematables","schemalinks") VALUES ('gestionR1','client 55.0 96.0 factures 398.0 26.0 contact 427.0 273.0 intervenant 89.0 271.0 jhomme 303.0 191.0 reglement 228.0 16.0 fournisseur 507.0 273.0 constantes 582.0 273.0','{factures client client oid} {jhomme factures factures oid} {jhomme client client oid} {jhomme intervenant intervenant oid} {reglement factures factures oid} {reglement client client oid}'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('factures',9,'client_oid id dateemission dateecheance montantht montanttc regle du {description}','48 54 74 83 58 70 66 64 383'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('par nom',3,'Nom adresse1 adresse2','150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('reglement',4,'fact_oid cli_oid datepaye montant','49 47 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('essaiVisu',3,'societe du description','150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('corres',4,'champ id edition nomtable','150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('intervenant',9,'nom prenom datenaissance adresse cp ville {telmobile} {telfixe} {email}','150 150 150 150 150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('contact',13,'societe adr1 adr2 cp ville tel temmobile fax nom prenom sujet commentaire {internet}','150 150 150 46 150 98 103 150 150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structfactures',5,'champ denom editable rang {isoid}','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structcontact',5,'champ denom editable rang {isoid}','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structreglement',5,'champ denom editable rang {isoid}','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('client',8,'nom adr1 adr2 cp ville tel fax {prixjh}','150 150 150 150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structclient',5,'champ denom editable rang isoid','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structintervenant',5,'champ denom editable rang {isoid}','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('constantes',3,'tva salairenet {defaultjh}','150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('jhomme',5,'date prix factures client intervenant','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structjhomme',5,'champ denom editable rang isoid','150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('',3,'societe montantht description','150 150 476'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('totaux',6,'Du Regle {Total HT} {Total TTC} TVA {TVA \340 payer}','53 64 54 61 113 106'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('nolayoutneeded',4,'nom regle du description','150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('totauxMois',3,'sum date_part date_part','150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('total99',2,'sum sum','150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('total2000',2,'sum sum','150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structsalaire',7,'champ denom editable rang isoid type defaut','150 150 150 150 150 150 150'); INSERT INTO "pga_layout" ("tablename","nrcols","colnames","colwidth") VALUES ('structtable',7,'champ denom editable rang isoid type defaut','150 150 150 150 150 150 150'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('contact','Contacts',1,1,'f','CRM',NULL,350567,'nom,prenom,societe'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Intervenants',1,1,'f','R. H.',NULL,350572,'nom,prenom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('relance','Relances Client',1,1,'f','CRM',NULL,350589,'object'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('lettre','Lettre',1,1,'f','CRM',NULL,350591,'personne,object'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('action_crm','Actions CRM',1,14,'f','CRM',NULL,358457,'todo_act,contact'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('salaire','Salaires',1,1,'f','R. H.',NULL,350582,'intervenant,mois,annee'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('img_chq','Img. Ch\350que',1,14,'f','Config',NULL,359420,'image'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('reglement','Reglements',0,1,'f','Compta',NULL,350571,'montant,client,datepaye'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ch_sociales','Ch. Sociales',0,1,'f','Compta',NULL,350583,''); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('constantes','Constantes',0,1,'f','Config',NULL,350573,''); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rendezvous','Rendez-vous',1,1,'f','R. H.','',350580,''); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('refrdv','ref RdV',0,1,'f','Compta','',350586,''); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rights','Droits',1,1,'f','Config',NULL,350756,''); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('jhomme','Jour.hommes',1,1,'f','R. H.',NULL,350581,'tsp_start'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typepaiement','Type de Paiement',1,1,'f','Config',NULL,350576,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('achat','Achats',1,1,'f','G. Comm.',NULL,350584,'abstract,fournisseur'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fournisseur','Fournisseurs',1,1,'f','G. Comm.',NULL,350574,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devis','Devis',1,1,'f','G. Comm.',NULL,350569,'client,abstract'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('factures','Factures',1,1,'f','G. Comm.',NULL,350570,'client,abstract'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('client','Clients',1,1,'f','G. Comm.',NULL,350579,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('agenda','Agenda',1,1,'f','G. Comm.','',350590,'tsp_start,typeactivite'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('maboite','Ma Socit',1,1,'f','Config',NULL,351939,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesociete','Type de Societe',1,1,'f','Config',NULL,351956,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('statut','Type Statut',1,1,'f','Config',NULL,351963,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rdvstate','Etat RdV',1,1,'f','Config',NULL,350568,'state'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('organisme','Organismes',1,1,'f','Config',NULL,350575,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('userid','Login/Pwd',1,1,'f','Config',NULL,350577,'personne,statut'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesalaire','Type Salaires',1,1,'f','Config',NULL,350578,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typeactivite','Activite',1,1,'f','Config',NULL,350587,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('formule','Formules',1,1,'f','Config',NULL,350588,'contenu'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('reaction','Reaction',1,14,'f','Config',NULL,358801,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fonction','Fonction',1,14,'f','Config',NULL,358459,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typeaction','Type Action',1,14,'f','Config',NULL,358456,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('todo_act','Todo_Act',1,14,'f','Config',NULL,358803,'nom'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('banque','Banque',1,1,'f','Compta',NULL,351966,'nom,code_banque,code_guichet'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('mouvement_banque','Mouvements',1,1,'f','Compta',NULL,351984,'montant_euro,libelle'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devises',1,1,'f','Compta',NULL,351989,'abbrev'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rapprochement','Rapprochements',1,1,'f','Compta',NULL,352316,'mouvement_banque,ecriture'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte_banque','Cptes Banque',1,1,'f','Compta',NULL,351973,'nocompte,banque'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('charges','Charges',1,1,'f','Compta',NULL,350585,'organisme,libelle,montant'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Comptes',1,14,'f','Compta',NULL,357911,'id,intitule'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('brouillard','Brouillard',1,14,'f','Compta',NULL,357913,'compte,action,valeur'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Mvt Compta.',1,14,'f','Compta',NULL,357914,'libelle'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ecriture','Ecritures',1,14,'f','Compta',NULL,357912,'compte,action,valeur'); INSERT INTO "structtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('societe','Societe',1,1,'f','CRM',NULL,350592,'nom'); INSERT INTO "structconstantes" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tva','TVA',1,1,'f',NULL,NULL,NULL,NULL); INSERT INTO "structconstantes" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('salairenet','Salaire net',1,1,'f',NULL,NULL,NULL,NULL); INSERT INTO "structconstantes" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('defaultjh','Prix jh (defaut)',1,1,'f',NULL,NULL,NULL,NULL); INSERT INTO "structconstantes" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,9,'f','int4',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',358162,'compte'); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('prenom','Prenom',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('telmobile','Tel (mobile)',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','E-mail',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datenaissance','Date de naissance',1,8,'f','date',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nosecu','No de Secu',1,9,'f','text',NULL,NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('dateentree','Date Entree',1,10,'f','date','',NULL,NULL); INSERT INTO "structintervenant" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datesortie','Date Sortie',1,11,'f','date','',NULL,NULL); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montant','Montant',1,3,'f','float8',NULL,NULL,NULL); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,9,'f','uid',NULL,NULL,NULL); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datepaye','Date de versement',1,2,'f','date','join(''/'',$con->getdate());',NULL,NULL); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nocheque','No Cheque',1,15,'f','text','',357915,NULL); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('client','Client',1,0,'t','oid',NULL,NULL,'client'); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('factures','Facture',1,1,'t','oid',NULL,NULL,'factures'); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Ecritures',1,1,'f','oid','',357938,'groupe_ecriture'); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,4,'f','oid','',352927,'devise'); INSERT INTO "structreglement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rapproche','Rapproche',1,4,'f','bool','',352315,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Ecritures',1,12,'t','oid','',357936,'groupe_ecriture'); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('client','Client',1,1,'f','oid','',0,'client'); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,4,'f','oid','',352916,'devise'); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montantht','HT',1,2,'f','float8','',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('regle','R\351gl\351',0,7,'t','float8','',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('dateemission','Date d''\351mission',1,0,'f','date','join(''/'',$con->getdate());',0,''); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('du','D\373',0,8,'t','float8','',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montanttc','TTC',1,3,'f','float8','',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('dateecheance','Ech\351ance',1,6,'f','date','join(''/'',$con->getdate());',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('id','No Facture',1,0,'f','text','$con->nextId();',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('abstract','R\351sum\351',1,9,'f','text','',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('description','Description',1,10,'f','textA','',0,NULL); INSERT INTO "structfactures" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('envoye','Envoy\351e ?',1,11,'f','bool','',0,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Ecritures',1,11,'t','oid','',357937,'groupe_ecriture'); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('paye','Pay\351 ?',1,9,'f','bool','',NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fournisseur','Fournisseur',1,1,'f','oid','',0,'fournisseur'); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typepaiement','Type Paiement',1,6,'f','oid','',0,'typepaiement'); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,6,'f','oid','',352918,'devise'); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montantht','Montant HT',1,4,'f','float8',NULL,NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montanttc','Montant TTC',1,5,'f','float8',NULL,NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nocheque','No de ch\350que',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('libelle','Libell\351',1,8,'f','textA',NULL,NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datepaye','Date',1,0,'f','date','join(''/'',$con->getdate());',0,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('factures','Facture',1,3,'f','text','',NULL,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rapproche','Rapproche',1,10,'f','bool','',352312,NULL); INSERT INTO "structachat" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('abstract','R\351sum\351',1,2,'f','text','',0,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cheque','No ch\350que',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,1,'f','oid','',352919,'devise'); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datepaye','Date',1,5,'f','date','join(''/'',$con->getdate());',NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montant','Montant',1,3,'f','float8','',NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('paye','Pay\351 ?',1,7,'f','bool','',NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('abstract','R\351sum\351',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('libelle','Libell\351',1,6,'f','textA',NULL,NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','bool',NULL,NULL,NULL); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Ecritures',1,1,'t','oid','',358066,'groupe_ecriture'); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('organisme','Organisme',1,1,'f','oid',NULL,NULL,'organisme'); INSERT INTO "structcharges" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rapproche','Rapproche',1,8,'f','bool','',352313,NULL); INSERT INTO "typepaiement" ("nom","uid") VALUES ('Ch\350que',312402); INSERT INTO "typepaiement" ("nom","uid") VALUES ('Carte Bleue',312403); INSERT INTO "typepaiement" ("nom","uid") VALUES ('Virement',312404); INSERT INTO "typepaiement" ("nom","uid") VALUES ('Especes',350168); INSERT INTO "typepaiement" ("nom","uid") VALUES ('TIP',359407); INSERT INTO "structtypepaiement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','uid',NULL,NULL,NULL); INSERT INTO "structtypepaiement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Type Paiement',1,0,'f','text','',NULL,''); INSERT INTO "structuserid" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('id','Login',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structuserid" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('pwd','Password',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structuserid" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('statut','Etat',1,3,'f','oid',NULL,NULL,'statut'); INSERT INTO "structuserid" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,9,'f','int4',NULL,NULL,NULL); INSERT INTO "structuserid" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('personne','Client',1,2,'f','oid','',NULL,'personne'); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesalaire','Type Salaire',1,6,'f','oid','',0,'typesalaire'); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('comment','Commentaire',1,7,'f','textA','',0,''); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('paye','Vers\351 ?',1,8,'f','bool','',0,''); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typepaiement','Type Paiement',1,14,'f','oid','0',359416,''); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nocheque','Cheque No',1,14,'f','text','0',359417,NULL); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Salari\351',1,1,'f','oid','',0,'intervenant'); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Ecritures',1,10,'t','oid','',358153,'groupe_ecriture'); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,4,'f','oid','',352921,'devise'); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('net','Montant net',1,2,'f','float8','',0,''); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('brut','Montant brut',1,3,'f','float8','',0,''); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('mois','Mois',1,4,'f','mois','$con->getdate(''mois'')',0,''); INSERT INTO "structsalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('annee','Annee',1,5,'f','annee','$con->getdate(''annee'')',0,''); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (0,'Salaire',25320); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (1,'Prime',25321); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (2,'Prime D\351placement',25322); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (3,'Avance sur Benef',25400); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (1,'Prime Cong\351s',352584); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (0,'Dividende',357764); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (5,'Abondement',358260); INSERT INTO "typesalaire" ("no","nom","uid") VALUES (5,'Abondement',358355); INSERT INTO "structtypesalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structtypesalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('no','no',1,1,'f','int4',NULL,NULL,NULL); INSERT INTO "structtypesalaire" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Type',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structtypeactivite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Activit\351',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structtypeactivite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('prixdefaut','Prix D\351faut',1,1,'f','float8',NULL,NULL,NULL); INSERT INTO "structtypeactivite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('factures','Facture',1,12,'t','oid','',NULL,'factures'); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('abstract','R\351sum\351',1,8,'f','text',NULL,NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montanttc','Montant TTC',1,3,'f','float8',NULL,NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('client','Client',1,1,'f','oid','',0,'client'); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('description','Description',1,9,'f','textA',NULL,NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,4,'f','oid','',352917,'devise'); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('envoye','Envoy\351 ?',1,10,'f','bool','',NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('id','No Devis',1,0,'f','text','$con->nextIdDevis();',NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fichier','Fichier',1,13,'f','file','',NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montantht','Montant HT',1,2,'f','float8','',NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('accepte','Accept\351 ?',1,11,'f','bool','0',NULL,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('dateecheance','Ech\351ance',1,5,'f','date','join(''/'',$con->getdate());',0,NULL); INSERT INTO "structdevis" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('dateemission','Date d''\351mission',1,6,'f','date','join(''/'',$con->getdate());',0,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cheque','No ch\350que',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datepaye','Date',1,5,'f','date','join(''/'',$con->getdate());',NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montant','Montant',1,3,'f','float8','',NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('abstract','R\351sum\351',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('libelle','Libell\351',1,6,'f','textA',NULL,NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','bool',NULL,NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('paye','Pay\351 ?',1,7,'f','bool','',NULL,NULL); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('organisme','Organisme',1,1,'t','oid',NULL,NULL,'organisme'); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,1,'f','oid','',352920,'devise'); INSERT INTO "structch_sociales" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rapproche','Rapproche',1,8,'f','bool','',352314,NULL); INSERT INTO "structrefrdv" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','uid',0,99,NULL,'int4','',NULL,NULL); INSERT INTO "structrefrdv" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','intervenant(s)',1,2,NULL,'oids','',NULL,NULL); INSERT INTO "structrefrdv" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('personne','Contact',1,1,NULL,'oid','',NULL,'personne'); INSERT INTO "structrefrdv" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rendezvous','rendezvous',0,3,NULL,'oid','',NULL,'rendezvous'); INSERT INTO "rdvstate" ("state","uid") VALUES ('Report\351',350207); INSERT INTO "rdvstate" ("state","uid") VALUES ('Annul\351',350208); INSERT INTO "rdvstate" ("state","uid") VALUES ('Pass\351',350209); INSERT INTO "rdvstate" ("state","uid") VALUES ('Ok',350210); INSERT INTO "structrdvstate" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',NULL,NULL); INSERT INTO "structrdvstate" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('state','Etat RdV',1,0,'f','text','',NULL,NULL); INSERT INTO "formule" ("uid","contenu") VALUES (350362,'En vous remerciant de votre compr\351hension, je vous prie de recevoir, monsieur, mes salutations respectueuses.'); INSERT INTO "formule" ("uid","contenu") VALUES (350363,'Sinc\350rement,'); INSERT INTO "formule" ("uid","contenu") VALUES (350364,'Cordialement,'); INSERT INTO "formule" ("uid","contenu") VALUES (350520,'Dans cette attente, nous vous prions de bien vouloir agr\351er, Monsieur, l''expression de nos sentiments distingu\351s.'); INSERT INTO "formule" ("uid","contenu") VALUES (350522,'En vous souhaitant bonne reception, nous vous prions de bien vouloir agr\351er, Monsieur, l''expression de nos sentiments distingu\351s.'); INSERT INTO "formule" ("uid","contenu") VALUES (351931,'En vous remerciant de votre compr\351hension, je vous prie de recevoir, mademoiselle, mes salutations respectueuses.'); INSERT INTO "formule" ("uid","contenu") VALUES (351932,'En vous remerciant de votre compr\351hension, je vous prie de recevoir, madame, monsieur, mes salutations respectueuses.'); INSERT INTO "formule" ("uid","contenu") VALUES (358073,'En vous souhaitant bonne reception, nous vous prions de bien vouloir agr\351er, Madame, Monsieur, l''expression de nos sentiments distingu\351s.'); INSERT INTO "formule" ("uid","contenu") VALUES (358891,'En vous remerciant de votre compr\351hension, je vous prie de recevoir, madame, mes salutations respectueuses.'); INSERT INTO "structformule" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('contenu','Contenu',1,0,'f','text','',NULL,NULL); INSERT INTO "structformule" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','oid','',NULL,'uid'); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',NULL,NULL); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('object','Objet',1,3,'f','text','',NULL,NULL); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('daterelance','Date',1,1,'f','date','join(''/'',$con->getdate());',NULL,NULL); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('civilite','Civilite',1,4,'f','text','',NULL,NULL); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('texte','Contenu',1,5,'f','textA','',NULL,NULL); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('client','Client',1,0,'f','oid','',NULL,'client'); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Expediteur',1,2,'f','oid','',NULL,'intervenant'); INSERT INTO "structrelance" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('formule','Formule',1,6,'f','oid','',NULL,'formule'); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('duree','Dur\351e',1,1,'f','duree','',NULL,NULL); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typeactivite','Activit\351',1,2,'f','oid','',NULL,'typeactivite'); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('personne','Personne',1,0,'f','oid','',NULL,'personne'); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tsp_start','D\351but',1,0,'f','timestamp','',NULL,NULL); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('comment','Commentaire',1,3,'f','text','',NULL,NULL); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Intervenant',1,5,'f','oids','',NULL,NULL); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('statut','Statut',1,4,'f','bool','0',NULL,NULL); INSERT INTO "structrendezvous" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('objet','Objet',1,0,'f','text','',NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('factures','Facture',1,4,'t','oid',NULL,NULL,'factures'); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tsp_start','D\351but',1,0,'f','timestamp','',NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('comment','Commentaire',1,3,'f','text','',NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('statut','Statut',1,4,'f','bool','',NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('client','Client',1,0,'t','oid',NULL,NULL,'client'); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('duree','Dur\351e',1,1,'f','duree','',NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('date','Date',0,1,'f','date','',NULL,NULL); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typeactivite','Activit\351',1,5,'t','oid',NULL,NULL,'typeactivite'); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Intervenant',1,0,'f','oid','',NULL,'intervenant'); INSERT INTO "structjhomme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('prix','Prix',1,3,'f','float8','3500',NULL,NULL); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4',NULL,NULL,NULL); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tsp_start','D\351but',1,0,'f','timestamp','',NULL,NULL); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('comment','Commentaire',1,3,'f','text','',NULL,NULL); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('statut','Statut',1,4,'f','bool','',NULL,NULL); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('duree','Dur\351e',1,1,'f','duree','',NULL,NULL); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typeactivite','Activit\351',1,2,'f','oid','',NULL,'typeactivite'); INSERT INTO "structagenda" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Intervenant',1,5,'f','oid','',NULL,'intervenant'); INSERT INTO "typeactivite" ("uid","nom","prixdefaut","reftable") VALUES (350462,'Rendez-Vous',0,'rendezvous'); INSERT INTO "typeactivite" ("uid","nom","prixdefaut","reftable") VALUES (350041,'D\351veloppement',3500,'jhomme'); INSERT INTO "typeactivite" ("uid","nom","prixdefaut","reftable") VALUES (350042,'Chef de projet',4500,'jhomme'); INSERT INTO "typeactivite" ("uid","nom","prixdefaut","reftable") VALUES (350043,'Vacances',0,'jhomme'); INSERT INTO "typeactivite" ("uid","nom","prixdefaut","reftable") VALUES (350214,'Conseil',4000,'jhomme'); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,1,'f','text','',351940,NULL); INSERT INTO "structpersonne" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',357904,'compte'); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,1,'f','text','',351947,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('categorie','Secteur',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('siret','No de SIRET',1,8,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uetva','UE / TVA',1,9,'f','text',NULL,NULL,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('capital','Capital',1,1,'f','text','',351949,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('url','URL',1,7,'f','text','',358447,NULL); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesociete','Type Soc.',1,1,'f','oid','',351948,'typesociete'); INSERT INTO "structsociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',357908,'compte'); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('categorie','Secteur',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('siret','No de SIRET',1,8,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uetva','UE / TVA',1,9,'f','text',NULL,NULL,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,1,'f','text','',351944,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('capital','Capital',1,1,'f','text','',351946,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('url','URL',1,7,'f','text','',358448,NULL); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesociete','Type Soc.',1,1,'f','oid','',351945,'typesociete'); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',357907,'compte'); INSERT INTO "structclient" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('prixjh','Prix j.h',0,7,'f','float8','3500',NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','Adresse 1',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','Adresse 2',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,9,'f','uid',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('categorie','Secteur',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('siret','No de SIRET',1,8,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uetva','UE / TVA',1,9,'f','text',NULL,NULL,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,1,'f','text','',351950,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('capital','Capital',1,1,'f','text','',351952,NULL); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesociete','Type Soc.',1,1,'f','oid','',351951,'typesociete'); INSERT INTO "structfournisseur" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'t','oid','',357909,'compte'); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('TSA 41120','CEDEX 19','75924','PARIS','','','CCIP',358077,NULL,NULL,''); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('Recette des impots XX\350me P\350re Lachaise','Hotel des Finances 6 rue Paganini','75972','Paris CEDEX 20',NULL,NULL,'TVA',350104,NULL,211,NULL); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('56-60 rue de la Glaci\350re','CEDEX 13','75640','PARIS',NULL,NULL,'FAFIEC',358899,NULL,7492,NULL); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES (NULL,NULL,NULL,NULL,NULL,NULL,'AVOID IPSIE',350076,NULL,49,NULL); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('18 rue T. Bellini','CEDEX','92813','Puteaux','0146845404',NULL,'IONIS - IPSIE',352309,NULL,49,'Mme Picard'); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('26 rue St Petersbourg','CEDEX 08','75800','PARIS','','','INPIE',358887,NULL,7481,''); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('Centre de Traitement des Paiements du r\351gime d''Assurance Chomage','TSA 390005','75688','PARIS CEDEX 14',NULL,NULL,'GARP',350504,NULL,51,'NA:298174G;CP:94663'); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('','','','','','','ASSEDIC',350075,NULL,45,''); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('154 rue Anatole France','Cedex','92599','LEVALLOIS PERRET','01 41 05 25 25','01 41 05 23 04','CRICA',24947,NULL,46,'Retraite'); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('1, quai de la Corse','CEDEX 04','75181','PARIS','01 44 41 54 54',NULL,'Greffe Tribunal de Commerce',354361,NULL,54,NULL); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('TSA 21109','75924','PARIS CEDEX 19','','','','Groupe CRI',350506,NULL,52,''); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('TSA 50037','CEDEX 09','94945','CRETEIL','','','Retraites Unies',352365,NULL,53,''); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('','','','','','','Tr\351sor Public',24958,NULL,47,''); INSERT INTO "organisme" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie") VALUES ('3 rue Franklin','','93100','Montreuil Sous Bois','01 49 20 10 10(28 79) ','01 48 57 02 02','URSSAF',25069,NULL,48,'Securit\351 Sociale'); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('categorie','Secteur',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'t','oid','',357910,'compte'); INSERT INTO "structorganisme" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,8,'f','text',NULL,359411,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('telmobile','GSM',1,10,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('sujet','Sujet',1,10,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('commentaire','Commentaire',1,11,'f','textA',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('mail','Email',1,12,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('web','Site',1,12,'f','text',NULL,NULL,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,4,'f','text','',358586,NULL); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('societe','Societe',1,1,'f','oid','$societe',NULL,'societe'); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fonction','Fonction',1,4,'f','oid','',358460,'fonction'); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,4,'f','oid','',358575,'compte'); INSERT INTO "structcontact" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('prenom','Prenom',1,0,'f','text','',NULL,NULL); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',NULL,NULL); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('object','Objet',1,3,'f','text','',NULL,NULL); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('civilite','Civilite',1,4,'f','text','',NULL,NULL); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('texte','Contenu',1,5,'f','textA','',NULL,NULL); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('dateenvoi','Date',1,1,'f','date','join(''/'',$con->getdate());',NULL,NULL); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Expediteur',1,2,'f','oid','',NULL,'intervenant'); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('formule','Formule',1,6,'f','oid','',NULL,'formule'); INSERT INTO "structlettre" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('personne','Personne',1,0,'f','oid','',NULL,'personne'); INSERT INTO "structrights" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Intervenant',1,5,'f','oid','',NULL,'intervenant'); INSERT INTO "structrights" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('structtable','Table',1,1,'f','oid','',NULL,'structtable'); INSERT INTO "structrights" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('read','Lecture',1,7,'f','bool','',NULL,NULL); INSERT INTO "structrights" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('write','Ecriture',1,8,'f','bool','',NULL,NULL); INSERT INTO "structrights" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('denom','',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('editable','',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rang','',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('isoid','',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('type','',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('defaut','',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structstructtable" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,0,'f','int4',NULL,NULL,NULL); INSERT INTO "maboite" ("adr1","adr2","cp","ville","tel","fax","nom","uid","email","compte","categorie","siret","uetva","typesociete","capital","url","logo","headerdoc","footerdoc") VALUES ('7 bis, rue de Lesseps',NULL,'75020','PARIS','01 43 56 05 00','01 43 56 05 50','PimenTech',352226,'info@pimentech.net',NULL,'Informatique','423 014 729',NULL,351996,'26~800~Euros~',NULL,'maboite/994153507.pdf','Service et developpement informatique',NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('categorie','Secteur',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('siret','No de SIRET',1,8,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uetva','UE / TVA',1,9,'f','text',NULL,NULL,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('logo','Logo',1,1,'f','file','',351936,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('headerdoc','Entte',1,2,'f','text','',351937,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('footerdoc','Pied de page',1,3,'f','text','',351938,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,1,'f','text','',351941,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('capital','Capital',1,1,'f','text','',351943,NULL); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesociete','Type Soc.',1,1,'f','oid','',351942,'typesociete'); INSERT INTO "structmaboite" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',357906,'compte'); INSERT INTO "typesociete" ("nom","nomlong","uid") VALUES ('BQ','Banque',351994); INSERT INTO "typesociete" ("nom","nomlong","uid") VALUES ('SA','Soci\351t\351 anonyme',351995); INSERT INTO "typesociete" ("nom","nomlong","uid") VALUES ('SARL','Soci\351t\351 anonyme \340 responsabilit\351 limit\351',351996); INSERT INTO "typesociete" ("nom","nomlong","uid") VALUES ('SAS','Soci\351t\351 Anonyme Simplifi\351e',358115); INSERT INTO "structtypesociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Abrev.',1,1,'f','text','',351953,NULL); INSERT INTO "structtypesociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nomlong','Nom Long',1,1,'f','text','',351954,NULL); INSERT INTO "structtypesociete" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',351955,NULL); INSERT INTO "statut" ("nom","uid") VALUES ('client',351959); INSERT INTO "statut" ("nom","uid") VALUES ('admin',351960); INSERT INTO "statut" ("nom","uid") VALUES ('intervenant',351961); INSERT INTO "statut" ("nom","uid") VALUES ('comptable',351962); INSERT INTO "structstatut" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Type',1,1,'f','text','',351957,NULL); INSERT INTO "structstatut" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',351958,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,0,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr1','adresse',1,1,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('adr2','adresse',1,2,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('cp','C.P.',1,3,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ville','Ville',1,4,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('tel','T\351l.',1,5,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('fax','Fax',1,6,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,8,'f','uid',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('email','Email',1,1,'f','text','',351947,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('categorie','Secteur',1,7,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('siret','No de SIRET',1,8,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uetva','UE / TVA',1,9,'f','text',NULL,NULL,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('capital','Capital',1,1,'f','text','',351949,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('code_banque','Banque',1,1,'f','text','',351964,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('code_guichet','Guichet',1,1,'f','text','',351965,NULL); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typesociete','Type Soc.',1,1,'f','oid','',351948,'typesociete'); INSERT INTO "structbanque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'t','oid','',357905,'compte'); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',351967,NULL); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('rib','RIB',1,1,'f','text','',351968,NULL); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nocompte','No Compte',1,1,'f','text','',351969,NULL); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',358205,'compte'); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('libelle','Libell',1,0,'f','text','',351970,NULL); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nomcompte','Compte',1,1,'f','text','',351971,NULL); INSERT INTO "structcompte_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('banque','Banque',1,1,'f','oid','',351972,'banque'); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte_banque','Compte',1,3,'f','oid','',351983,'compte_banque'); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('devise','Devise',1,1,'f','oid','',351975,'devise'); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('date','Date',1,0,'f','date','',351981,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montant_euro','Montant (EUR)',1,3,'f','float8','',351980,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('montant_franc','Montant (FR)',1,2,'f','float8','',351979,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('date_valeur','Date Valeur',1,5,'f','date','',351982,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('libelle','Libelle',1,3,'f','text','',351978,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',351974,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('F','F',1,4,'f','text','',351976,NULL); INSERT INTO "structmouvement_banque" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('X','X',1,5,'f','text','',351977,NULL); INSERT INTO "devise" ("nom","abbrev","nbeuros","uid") VALUES ('Euro','EUR',1,352083); INSERT INTO "devise" ("nom","abbrev","nbeuros","uid") VALUES ('Deutsch Mark','DM',0.5112918,352936); INSERT INTO "devise" ("nom","abbrev","nbeuros","uid") VALUES ('Franc fran\347ais','FRF',0.15244902,352084); INSERT INTO "structdevise" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Nom',1,1,'f','text','',351986,NULL); INSERT INTO "structdevise" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','oid','',351985,'uid'); INSERT INTO "structdevise" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nbeuros','Valeur EUR',1,1,'f','float8','',351988,NULL); INSERT INTO "structdevise" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('abbrev','Symbole',1,0,'f','text','',351987,NULL); INSERT INTO "structobject" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structobject" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','',357884,NULL); INSERT INTO "structobject" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','',357885,NULL); INSERT INTO "structobject" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structobject" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (89,0,0,'02/01/2002','02/01/2002','101000','CAPITAL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (293,0,0,'02/01/2002','07/09/2002','651000','REDEVANC. CONCESS. BREV. LICENC,..',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (277,0,0,'02/01/2002','12/16/2002','624000','TRANSP. BIENS & TRANSP. COLL. PERS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (283,0,0,'02/01/2002','01/13/2003','631000','IMPOTS TAXES & VERS. SUR REMUNER.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (286,0,0,'02/01/2002','03/08/2002','637000','AUTRES IMPOTS TAXES ET VERS. ASS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (263,0,0,'02/01/2002','03/22/2002','608000','FRAIS ACCESSOIRES D ACHAT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (323,0,0,'02/01/2002','02/01/2002','707000','VENTES DE MARCHANDISES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (324,0,0,'02/01/2002','02/01/2002','708000','PRODUITS DES ACTIVITES ANNEXES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (325,0,0,'02/01/2002','02/01/2002','709000','RABAIS REMISES RIST. ACCORD. A ETS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (326,0,0,'02/01/2002','02/01/2002','713000','VARIAT. STOCKS (EN-COURS PRODUCT.)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (327,0,0,'02/01/2002','02/01/2002','721000','IMMOBILISATIONS INCORPORELLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (328,0,0,'02/01/2002','02/01/2002','722000','IMMOBILISATIONS CORPORELLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (329,0,0,'02/01/2002','02/01/2002','731000','PROD. NETS PART. SUR OP. EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (330,0,0,'02/01/2002','02/01/2002','739000','PROD. NETS PART. SUR OP. TERMINEES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (331,0,0,'02/01/2002','02/01/2002','751000','REDEV. POUR CONCES. BREV. LIC....',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (332,0,0,'02/01/2002','02/01/2002','752000','REV. IMMEUB. NON AFFECT. ACT. PROF',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (322,0,0,'02/01/2002','04/19/2003','706000','PRESTATIONS DE SERVICES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (333,0,0,'02/01/2002','02/01/2002','753000','JETONS PRESENCE ET REMUN. ADMINIST',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (334,0,0,'02/01/2002','02/01/2002','754000','RISTOURNES PERCUES COOPERATIVES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (335,0,0,'02/01/2002','02/01/2002','755000','QUOTES-PARTS RESULT. OP. EN COMMUN',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (336,0,0,'02/01/2002','02/01/2002','758000','PRODUITS DIVERS GESTION COURANTE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (337,0,0,'02/01/2002','02/01/2002','761000','PRODUITS DE PARTICIPATIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (338,0,0,'02/01/2002','02/01/2002','762000','PRODUITS AUTRES IMMOB. FINANC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (339,0,0,'02/01/2002','02/01/2002','763000','REVENUS DES AUTRES CREANCES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (340,0,0,'02/01/2002','02/01/2002','764000','REVENUS VALEURS MOBIL. PLACEMENT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (341,0,0,'02/01/2002','02/01/2002','765000','ESCOMPTES OBTENUS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (342,0,0,'02/01/2002','02/01/2002','766000','GAINS DE CHANGE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (343,0,0,'02/01/2002','02/01/2002','767000','PROD. NETS SUR CESS. VALEURS MOB.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (344,0,0,'02/01/2002','02/01/2002','768000','AUTRES PRODUITS FINANCIERS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (345,0,0,'02/01/2002','02/01/2002','771000','PRODUITS EXCEPT. SUR OPER. GESTION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (346,0,0,'02/01/2002','02/01/2002','772000','PRODUITS SUR EXERCICES ANTERIEURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (347,0,0,'02/01/2002','02/01/2002','775000','PRODUITS CESSIONS ELEMENTS D ACTIF',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (348,0,0,'02/01/2002','02/01/2002','777000','Q-P SUBV. INVEST. AU RESULT. EXERC',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (349,0,0,'02/01/2002','02/01/2002','778000','AUTRES PRODUITS EXCEPTIONNELS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (350,0,0,'02/01/2002','02/01/2002','781000','REPRISES SUR AMORTISS. & PROVIS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (351,0,0,'02/01/2002','02/01/2002','786000','REPRISES SUR PROVISIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (352,0,0,'02/01/2002','02/01/2002','787000','REPRISES SUR PROVISIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (353,0,0,'02/01/2002','02/01/2002','791000','TRANSFERTS DE CHARGES D EXPLOIT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (354,0,0,'02/01/2002','02/01/2002','796000','TRANSFERTS DE CHARGES FINANC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (355,0,0,'02/01/2002','02/01/2002','797000','TRANSFERTS DE CHARGES EXCEPT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (258,0,0,'02/01/2002','02/01/2002','603000','VARIATION DES STOCKS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (264,0,0,'02/01/2002','02/01/2002','690000','PARTICIP. SAL. / IMPOTS SUR BEN.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (265,0,0,'02/01/2002','02/01/2002','611000','SOUS-TRAITANCE GENERALE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (266,0,0,'02/01/2002','02/01/2002','612000','REDEVANCES DE CREDIT-BAIL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (267,0,0,'02/01/2002','02/01/2002','613000','LOCATIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (268,0,0,'02/01/2002','02/01/2002','614000','CHARGES LOCATIVES & DE COPROPRIETE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (269,0,0,'02/01/2002','02/01/2002','615000','ENTRETIEN ET REPARATIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (276,0,0,'02/01/2002','11/13/2002','623000','PUBLICITE PUBLICAT. RELAT. PUBLIQ.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (271,0,0,'02/01/2002','02/01/2002','617000','ETUDES ET RECHERCHES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (272,0,0,'02/01/2002','02/01/2002','618000','DIVERS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (273,0,0,'02/01/2002','02/01/2002','619000','RABAIS REMISES RIST. SUR SERV. EXT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (274,0,0,'02/01/2002','02/01/2002','621000','PERSONNEL EXTERIEUR A L ENTREPRISE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (282,0,0,'02/01/2002','02/01/2002','629000','RABAIS REMISES RIST. SUR SERV. EXT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (290,0,0,'02/01/2002','02/01/2002','647200','VERS. AUX COMITES D ETS & D ETAB.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (291,0,0,'02/01/2002','02/01/2002','646000','COTIS. SOCIAL. PERSON. EXPLOITANT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (284,0,0,'02/01/2002','09/11/2002','633000','IMPOTS TAXES & VERS. SUR REMUNER.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (294,0,0,'02/01/2002','02/01/2002','653000','JETONS DE PRESENCE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (295,0,0,'02/01/2002','02/01/2002','654000','PERTES SUR CREANCES IRRECOUVRAB.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (296,0,0,'02/01/2002','02/01/2002','655000','QUOTE-PARTS RESULT. OPER. EN COMM.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (297,0,0,'02/01/2002','02/01/2002','658000','CHARGES DIVERSES GESTION COURANTE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (298,0,0,'02/01/2002','02/01/2002','661000','CHARGES D INTERETS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (299,0,0,'02/01/2002','02/01/2002','664000','PERTES CREANCES LIEES A PARTICIP.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (300,0,0,'02/01/2002','02/01/2002','665000','ESCOMPTES ACCORDES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (301,0,0,'02/01/2002','02/01/2002','666000','PERTES DE CHANGE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (302,0,0,'02/01/2002','02/01/2002','667000','CHARG. NETTES SUR CESS. VAL. MOBIL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (281,0,0,'02/01/2002','01/27/2003','628000','DIVERS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (305,0,0,'02/01/2002','02/01/2002','672000','CHARGES SUR EXERCICES ANTERIEURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (306,0,0,'02/01/2002','02/01/2002','675000','VAL. COMPT. DES ELEM. ACTIF CEDES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (307,0,0,'02/01/2002','02/01/2002','678000','AUTRES CHARGES EXCEPTIONNELLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (308,0,0,'02/01/2002','02/01/2002','681000','DOTATIONS AUX AMORT. & AUX PROVIS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (309,0,0,'02/01/2002','02/01/2002','686000','DOTAT. AUX AMORT. ET AUX PROVIS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (310,0,0,'02/01/2002','02/01/2002','687000','DOTAT. AUX AMORT. ET PROVISIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (311,0,0,'02/01/2002','02/01/2002','691000','PARTICIPATIONS DES SALARIES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (312,0,0,'02/01/2002','02/01/2002','695000','IMPOTS SUR LES BENEFICES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (313,0,0,'02/01/2002','02/01/2002','696000','SUPPLEMENT D IMPOTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (314,0,0,'02/01/2002','02/01/2002','697000','IMPOSITION FORF. ANUELLE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (315,0,0,'02/01/2002','02/01/2002','698000','INTEGRATION FISCALE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (316,0,0,'02/01/2002','02/01/2002','699000','PRODUITS REP. EN ARR. DES DEFICITS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (317,0,0,'02/01/2002','02/01/2002','701000','VENTES DE PRODUITS FINIS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (318,0,0,'02/01/2002','02/01/2002','702000','VENTES DE PRODUITS INTERMEDIAIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (319,0,0,'02/01/2002','02/01/2002','703000','VENTES DE PRODUITS RESIDUELS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (320,0,0,'02/01/2002','02/01/2002','704000','TRAVAUX',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (321,0,0,'02/01/2002','02/01/2002','705000','ETUDES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (190,0,0,'02/01/2002','02/01/2002','409000','FOURNISSEURS DEBITEURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (191,0,0,'02/01/2002','02/01/2002','410000','CLIENTS ET COMPTES RATTACHES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (192,0,0,'02/01/2002','02/01/2002','413000','CLIENTS EFFETS A RECEVOIR',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (193,0,0,'02/01/2002','02/01/2002','416000','CLIENTS DOUTEUX OU LITIGIEUX',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (194,0,0,'02/01/2002','02/01/2002','417000','CREANC. SUR TRAV. NON ENCORE FACT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (195,0,0,'02/01/2002','02/01/2002','418000','CLIENTS PRODUITS NON ENCORE FACT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (196,0,0,'02/01/2002','02/01/2002','419000','CLIENTS CREDITEURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (197,0,0,'02/01/2002','02/01/2002','419800','RABAIS REMISES RIST. A ACCORDER',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (198,0,0,'02/01/2002','02/01/2002','421000','PERSONNEL REMUNERATIONS DUES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (199,0,0,'02/01/2002','02/01/2002','422000','COMITES D ENTREPRISE, D ETABLIS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (200,0,0,'02/01/2002','02/01/2002','424000','PARTICIP. DES SALAR. AUX RESULTATS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (201,0,0,'02/01/2002','02/01/2002','425000','PERSONNEL AVANCES ET ACOMPTES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (202,0,0,'02/01/2002','02/01/2002','426000','PERSONNEL DEPOTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (203,0,0,'02/01/2002','02/01/2002','428000','PERS. CHARG. A PAY. & PROD. A REC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (204,0,0,'02/01/2002','02/01/2002','431000','SECURITE SOCIALE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (205,0,0,'02/01/2002','02/01/2002','437000','AUTRES ORGANISMES SOCIAUX',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (206,0,0,'02/01/2002','02/01/2002','438000','ORG. SOC. CHARG. A PAY. & PROD.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (207,0,0,'02/01/2002','02/01/2002','441000','ETATS SUBVENTIONS A RECEVOIR',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (208,0,0,'02/01/2002','02/01/2002','442000','ETAT IMP. & TAX. RECOUV. SUR TIERS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (209,0,0,'02/01/2002','02/01/2002','443000','OPERATIONS PART. AVEC L ETAT,...',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (210,0,0,'02/01/2002','02/01/2002','444000','ETAT IMPOTS SUR LES BENEFICES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (213,0,0,'02/01/2002','02/01/2002','446000','TITRES SUR TVA',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (214,0,0,'02/01/2002','02/01/2002','447000','AUTRES IMPOTS, TAX. ET VERS. ASSIM',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (215,0,0,'02/01/2002','02/01/2002','448000','ETAT CHARG. A PAY. & PROD. A RECEV',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (216,0,0,'02/01/2002','02/01/2002','451000','GROUPE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (217,0,0,'02/01/2002','02/01/2002','455000','ASSOCIES COMPTES COURANTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (218,0,0,'02/01/2002','02/01/2002','456000','ASSOCIES OPERATIONS SUR LE CAPITAL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (219,0,0,'02/01/2002','02/01/2002','457000','ASSOCIES DIVIDENDES A PAYER',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (220,0,0,'02/01/2002','02/01/2002','458000','ASSOC. OPERAT. EN COMMUN ET EN GIE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (221,0,0,'02/01/2002','02/01/2002','462000','CREANCES SUR CESSIONS D IMMOBILIS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (222,0,0,'02/01/2002','02/01/2002','464000','DETTES SUR ACQUIS. VALEURS MOBI.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (223,0,0,'02/01/2002','02/01/2002','465000','CREANC. SUR CESSIONS VALEURS MOB.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (224,0,0,'02/01/2002','02/01/2002','467000','AUTRES COMPTES DEBIT. OU CREDIT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (225,0,0,'02/01/2002','02/01/2002','468000','DIVERS CHARG. A PAY. & PROD. A REC',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (226,0,0,'02/01/2002','02/01/2002','471000','COMPTES D ATTENTE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (227,0,0,'02/01/2002','02/01/2002','476000','DIFFERENCES DE CONVERSION ACTIF',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (228,0,0,'02/01/2002','02/01/2002','477000','DIFFERENCES DE CONVERSION PASSIF',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (229,0,0,'02/01/2002','02/01/2002','478000','AUTRES COMPTES TRANSITOIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (230,0,0,'02/01/2002','02/01/2002','481000','CHARG. A REPART. SUR PLUS. EXERC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (231,0,0,'02/01/2002','02/01/2002','486000','CHARGES CONSTATEES D AVANCE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (232,0,0,'02/01/2002','02/01/2002','487000','PRODUITS CONSTATES D AVANCE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (233,0,0,'02/01/2002','02/01/2002','488000','CPTES REPART. PERIO. CHARG. & PROD',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (234,0,0,'02/01/2002','02/01/2002','491000','PROVIS. POUR DEPREC. CPTES CLIENTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (235,0,0,'02/01/2002','02/01/2002','495000','PROV. POUR DEPREC. CPTES GRPE ASS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (236,0,0,'02/01/2002','02/01/2002','496000','PROVIS. POUR DEPREC. CPTES DEBIT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (237,0,0,'02/01/2002','02/01/2002','501000','PARTS DANS DES ENTREPRISES LIEES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (238,0,0,'02/01/2002','02/01/2002','502000','ACTIONS PROPRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (239,0,0,'02/01/2002','02/01/2002','503000','ACTIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (240,0,0,'02/01/2002','02/01/2002','504000','AUTRES TITRES CONFERANT DROIT PROP',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (241,0,0,'02/01/2002','02/01/2002','505000','OBLIG. & BONS EMIS PAR LA SOCIETE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (242,0,0,'02/01/2002','02/01/2002','506000','OBLIGATIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (243,0,0,'02/01/2002','02/01/2002','507000','BONS TRESOR & BONS CAISSE A CT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (244,0,0,'02/01/2002','02/01/2002','508000','AUTRES VALEURS MOB. ET CREANC. ASS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (245,0,0,'02/01/2002','02/01/2002','509000','VERS. A EFFECT. SUR VALEURS MOBIL.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (246,0,0,'02/01/2002','02/01/2002','511000','VALEURS A L ENCAISSEMENT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (248,0,0,'02/01/2002','02/01/2002','514000','CHEQUES POSTAUX',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (249,0,0,'02/01/2002','02/01/2002','515000','CAISSES DU TRESOR ET ETS PUBLICS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (250,0,0,'02/01/2002','02/01/2002','516000','AGENTS DE CHANGE STE DE BOURSE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (251,0,0,'02/01/2002','02/01/2002','517000','AUTRES ORGANISMES FINANCIERS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (252,0,0,'02/01/2002','02/01/2002','518000','INTERETS EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (253,0,0,'02/01/2002','02/01/2002','519000','CONCOURS BANCAIRES COURANTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (254,0,0,'02/01/2002','02/01/2002','531000','CAISSE SIEGE SOCIAL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (255,0,0,'02/01/2002','02/01/2002','590000','PROVIS. POUR DEPREC. VALEURS MOB.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (125,0,0,'02/01/2002','02/01/2002','186000','BIENS PREST. SERV. ECH. (CHARGES)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (126,0,0,'02/01/2002','02/01/2002','187000','BIENS PREST. SERV. ECH. (PRODUITS)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (127,0,0,'02/01/2002','02/01/2002','188000','COMPTES DE LIAISON STES EN PARTIC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (128,0,0,'02/01/2002','02/01/2002','201000','FRAIS D ETABLISSEMENT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (129,0,0,'02/01/2002','02/01/2002','203000','FRAIS RECHERCHE ET DEVELOPPEMENT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (130,0,0,'02/01/2002','02/01/2002','205000','CONCESSIONS ET DROITS SIMILAIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (131,0,0,'02/01/2002','02/01/2002','206000','DROIT AU BAIL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (132,0,0,'02/01/2002','02/01/2002','207000','FONDS COMMERCIAL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (133,0,0,'02/01/2002','02/01/2002','208000','AUTRES IMMOBILISATIONS INCORPOR.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (134,0,0,'02/01/2002','02/01/2002','211000','TERRAINS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (135,0,0,'02/01/2002','02/01/2002','212000','AGENCEMENTS AMENAGEMENTS TERRAINS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (136,0,0,'02/01/2002','02/01/2002','213000','CONSTRUCTIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (137,0,0,'02/01/2002','02/01/2002','214000','CONSTRUCTIONS SUR SOL D AUTRUI',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (138,0,0,'02/01/2002','02/01/2002','215000','INSTALL. TECH. MAT. OUTIL. INDUS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (139,0,0,'02/01/2002','02/01/2002','218000','AUTRES IMMOBILISATIONS CORPORELLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (140,0,0,'02/01/2002','02/01/2002','231000','IMMOBILISAT. CORPORELLES EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (141,0,0,'02/01/2002','02/01/2002','232000','IMMOB. INCORPORELLES EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (142,0,0,'02/01/2002','02/01/2002','237000','AVANC. ACOMPT. VERSES SUR IMM. INC',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (143,0,0,'02/01/2002','02/01/2002','238000','AVANC. ACOMP. VERSES CDES IMM. COR',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (144,0,0,'02/01/2002','02/01/2002','261000','TITRES DE PARTICIPATION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (145,0,0,'02/01/2002','02/01/2002','266000','AUTRES FORMES DE PARTICIPATION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (146,0,0,'02/01/2002','02/01/2002','267000','CREANCES RATTACHEES A PARTICIPAT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (147,0,0,'02/01/2002','02/01/2002','268000','CREANCES RATT. A STE EN PART.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (148,0,0,'02/01/2002','02/01/2002','269000','VERS. REST. A EFFECT. SUR T.P.N.L.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (149,0,0,'02/01/2002','02/01/2002','271000','TITRES IMMOBILISES (DROIT PROP.)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (150,0,0,'02/01/2002','02/01/2002','272000','TITRES IMMOBILISES (DROIT CREANCE)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (151,0,0,'02/01/2002','02/01/2002','274000','PRETS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (152,0,0,'02/01/2002','02/01/2002','275000','DEPOTS ET CAUTIONNEMENTS VERSES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (153,0,0,'02/01/2002','02/01/2002','276000','AUTRES CREANCES IMMOBILISEES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (154,0,0,'02/01/2002','02/01/2002','277000','ACTIONS OU PARTS PROPRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (155,0,0,'02/01/2002','02/01/2002','279000','VERSEM. A EFFECT. SUR T.I.N.L.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (156,0,0,'02/01/2002','02/01/2002','280000','AMORTISS. IMMOBILISATIONS INCORP.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (157,0,0,'02/01/2002','02/01/2002','281000','AMORTISS. IMMOBILISATIONS CORPOR.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (158,0,0,'02/01/2002','02/01/2002','282000','AMORTISS. IMMOBIL. EN CONCESSION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (159,0,0,'02/01/2002','02/01/2002','290000','PROVIS. DEPRECIATION IMMOB. INCORP',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (160,0,0,'02/01/2002','02/01/2002','291000','PROVIS. DEPRECIATION IMMOB. CORPOR',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (161,0,0,'02/01/2002','02/01/2002','292000','PROVIS. DEPRECIAT. IMMOB. CONCESS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (162,0,0,'02/01/2002','02/01/2002','293000','PROVIS. DEPRECIAT. IMMOB. EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (163,0,0,'02/01/2002','02/01/2002','296000','PROV. DEPREC. PART ET CREANC. PART',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (164,0,0,'02/01/2002','02/01/2002','297000','PROVIS. DEPRECIATION AUTRES IMMOB.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (165,0,0,'02/01/2002','02/01/2002','311000','MATIERE (OU GROUPE) A',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (166,0,0,'02/01/2002','02/01/2002','312000','MATIERE (OU GROUPE) B',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (167,0,0,'02/01/2002','02/01/2002','317000','FOURNITURES A, B, C...',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (168,0,0,'02/01/2002','02/01/2002','321000','MATIERES CONSOMMABLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (169,0,0,'02/01/2002','02/01/2002','322000','FOURNITURES CONSOMMABLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (170,0,0,'02/01/2002','02/01/2002','326000','EMBALLAGES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (171,0,0,'02/01/2002','02/01/2002','331000','PRODUITS EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (172,0,0,'02/01/2002','02/01/2002','335000','TRAVAUX EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (173,0,0,'02/01/2002','02/01/2002','341000','ETUDES EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (174,0,0,'02/01/2002','02/01/2002','345000','PRESTATIONS DE SERVICES EN COURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (175,0,0,'02/01/2002','02/01/2002','351000','PRODUITS INTERMEDIAIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (176,0,0,'02/01/2002','02/01/2002','355000','PRODUITS FINIS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (177,0,0,'02/01/2002','02/01/2002','358000','PROD. RESIDUELS (OU MAT. RECUP.)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (178,0,0,'02/01/2002','02/01/2002','371000','MARCHANDISE (OU GROUPE) A',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (179,0,0,'02/01/2002','02/01/2002','372000','MARCHANDISE (OU GROUPE) B',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (180,0,0,'02/01/2002','02/01/2002','391000','PROVIS. POUR DEPRECIAT. MAT. PREM.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (181,0,0,'02/01/2002','02/01/2002','393000','PROV. DEPREC. EN-COURS PROD. BIENS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (182,0,0,'02/01/2002','02/01/2002','394000','PROV. DEPREC. EN-COURS PROD. SERV.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (183,0,0,'02/01/2002','02/01/2002','395000','PROV. POUR DEPREC. STOCKS DE PROD.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (184,0,0,'02/01/2002','02/01/2002','397000','PROV. POUR DEPREC. STOCKS MARCHAN.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (185,0,0,'02/01/2002','02/01/2002','401000','FOURNISSEURS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (186,0,0,'02/01/2002','02/01/2002','403000','FOURNISSEURS - EFFETS A PAYER',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (187,0,0,'02/01/2002','02/01/2002','404000','FOURNISSEURS D IMMOBILISATIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (188,0,0,'02/01/2002','02/01/2002','405000','FOURNIS. D IMMOB. EFFETS A PAYER',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (189,0,0,'02/01/2002','02/01/2002','408000','FOURNIS. FACTURES NON PARVENUES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (261,0,0,'02/01/2002','04/25/2002','606000','ACHATS NON STOCKES DE MAT. PREM.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (288,0,0,'02/01/2002','01/13/2003','644000','REMUNERATION TRAVAIL DE L EXPLOIT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (90,0,0,'02/01/2002','02/01/2002','104000','PRIMES LIEES AU CAPITAL SOCIAL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (91,0,0,'02/01/2002','02/01/2002','105000','ECARTS DE REEVALUATION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (92,0,0,'02/01/2002','02/01/2002','106000','RESERVES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (93,0,0,'02/01/2002','02/01/2002','108000','COMPTE DE L EXPLOITANT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (94,0,0,'02/01/2002','02/01/2002','109000','ACTIONN. CAPITAL SOUSC. NON APPELE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (95,0,0,'02/01/2002','02/01/2002','110000','REPORT A NOUVEAU (SOLDE CREDITEUR)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (96,0,0,'02/01/2002','02/01/2002','120000','RESULTAT DE L EXERCICE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (97,0,0,'02/01/2002','02/01/2002','131000','SUBVENTIONS D EQUIPEMENT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (98,0,0,'02/01/2002','02/01/2002','138000','AUTRES SUBVENTIONS D INVESTIS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (99,0,0,'02/01/2002','02/01/2002','139000','SUBV. INVES. INSC. AU CPTE RESULT.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (100,0,0,'02/01/2002','02/01/2002','142000','PROVIS. REGLEM. RELATIV. AUX IMMO.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (101,0,0,'02/01/2002','02/01/2002','143000','PROVIS. REGLEMENT. RELATIV. STOCKS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (102,0,0,'02/01/2002','02/01/2002','144000','PROVIS. REGLEM. RELAT. ELEM. ACTIF',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (103,0,0,'02/01/2002','02/01/2002','145000','AMORTISSEMENTS DEROGATOIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (104,0,0,'02/01/2002','02/01/2002','146000','PROVISION SPECIALE DE REEVALUATION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (105,0,0,'02/01/2002','02/01/2002','147000','PLUS-VALUES REINVESTIES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (106,0,0,'02/01/2002','02/01/2002','148000','AUTRES PROVISIONS REGLEMENTEES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (107,0,0,'02/01/2002','02/01/2002','151000','PROVISIONS POUR RISQUES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (108,0,0,'02/01/2002','02/01/2002','153000','PROVIS. PENSIONS ET OBLIG. SIMIL.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (109,0,0,'02/01/2002','02/01/2002','155000','PROVISIONS POUR IMPOTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (110,0,0,'02/01/2002','02/01/2002','156000','PROVIS. RENOUV. IMMO (ETS CONCESS)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (111,0,0,'02/01/2002','02/01/2002','157000','PROV. CHARG. A REPART. SUR EXERC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (112,0,0,'02/01/2002','02/01/2002','158000','AUTRES PROVISIONS POUR CHARGES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (113,0,0,'02/01/2002','02/01/2002','161000','EMPRUNTS OBLIGATOIRES CONVERTIBLES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (114,0,0,'02/01/2002','02/01/2002','163000','AUTRES EMPRUNTS OBLIGATAIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (115,0,0,'02/01/2002','02/01/2002','164000','EMPRUNTS AUPRES ETABLIS. DE CREDIT',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (116,0,0,'02/01/2002','02/01/2002','165000','DEPOTS ET CAUTIONNEMENTS RECUS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (117,0,0,'02/01/2002','02/01/2002','166000','PARTICIP. SALARIES AUX RESULT. ETS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (118,0,0,'02/01/2002','02/01/2002','167000','EMPR. DETTES ASSORT. CONDIT. PART.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (119,0,0,'02/01/2002','02/01/2002','168000','AUTRES EMPR. ET DETTES ASSIMILEES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (120,0,0,'02/01/2002','02/01/2002','169000','PRIMES REMBOURSEMENT OBLIGATIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (121,0,0,'02/01/2002','02/01/2002','171000','DETTES RATTACH. A PARTIC. (GROUPE)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (122,0,0,'02/01/2002','02/01/2002','174000','DETTES RATT. A PART. (HORS GROUPE)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (123,0,0,'02/01/2002','02/01/2002','178000','DETTES RATTACH. A STES EN PARTIC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (124,0,0,'02/01/2002','02/01/2002','181000','COMPTE DE LIAISON ETABLISSEMENTS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (304,0,0,'02/01/2002','11/18/2002','671000','CHARG. EXCEPT. SUR OPERAT. GESTION',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (247,0,0,'02/01/2002','07/10/2002','512000','BANQUES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (260,0,0,'02/01/2002','10/11/2002','605000','ACHATS MATERIEL EQUIPEM. TRAVAUX',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (262,0,0,'02/01/2002','01/09/2003','607000','ACHATS DE MARCHANDISES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (303,0,0,'02/01/2002','12/03/2002','668000','AUTRES CHARGES FINANCIERES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (259,0,0,'02/01/2002','01/31/2003','604000','ACHATS ETUDES ET PRESTAT. SERVICES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (257,0,0,'02/01/2002','02/18/2002','602000','ACHATS STOCKES AUTRES APPROV.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (270,0,0,'02/01/2002','07/30/2002','616000','PRIMES D ASSURANCE',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (275,0,0,'02/01/2002','11/25/2002','622000','REMUNERAT. D INTERM. ET HONORAIRES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (292,0,0,'02/01/2002','10/07/2002','648000','AUTRES CHARGES DE PERSONNEL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (289,0,0,'02/01/2002','01/13/2003','645000','CHARGES DE SECUR. SOC. ET PREVOY.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (280,0,0,'02/01/2002','04/19/2003','627000','SERVICES BANCAIRES ET ASSIMILES',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (285,0,0,'02/01/2002','04/19/2003','635000','AUTRES IMPOTS TAXES & VERS. ASS.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (279,0,0,'02/01/2002','04/19/2003','626000','FRAIS POSTAUX ET TELECOMMUNIC.',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (278,0,0,'02/01/2002','04/19/2003','625000','DEPLACEM. MISSIONS ET RECEPTIONS',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (287,0,0,'02/01/2002','04/19/2003','641000','REMUNERATIONS DU PERSONNEL',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (256,0,0,'02/01/2002','04/19/2003','601000','ACHATS STOCKES MAT. PREM. (FOURN.)',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (212,0,0,'02/01/2002','04/19/2003','445TCA','TCA',0,0,0); INSERT INTO "compte" ("uid","authcrea","authmodif","datecrea","datemodif","id","intitule","credit","debit","solde") VALUES (211,0,0,'02/01/2002','04/19/2003','445510','TVA A DECAISSER',0,0,0); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,98,'f','oid','',357882,'personne'); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,97,'f','oid','',357883,'personne'); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intitule','Intitule',1,1,'f','text','',357887,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',357881,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,96,'f','date','',357884,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,95,'f','date','',357885,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('id','No',1,0,'f','text','',357886,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('credit','Credit',1,2,'f','float8','',357888,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('debit','Debit',1,3,'f','float8','',357889,NULL); INSERT INTO "structcompte" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('solde','Solde',1,4,'f','float8','',357890,NULL); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('exercice','Exercice',1,8,'f','annee','',358058,NULL); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,98,'f','oid','',357882,'personne'); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,97,'f','oid','',357883,'personne'); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intitule','Intitule',1,1,'f','text','',357894,''); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',357881,NULL); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,2,'f','oid','',357891,'compte'); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Groupe',1,3,'f','oid','',357896,'groupe_ecriture'); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,96,'f','date','',357884,NULL); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('action','Action',1,4,'f','text','',357892,''); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,95,'f','date','',357885,NULL); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('valeur','Valeur',1,5,'f','float8','',357893,''); INSERT INTO "structecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('date','Date',1,0,'f','date','',357895,''); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','',357884,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','',357885,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('action','Action',1,1,'f','text','',357898,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('valeur','Valeur',1,1,'f','float8','',357899,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intitule','Intitule',1,1,'f','text','',357900,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('date','Date',1,1,'f','date','',357901,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('exercice','Exercice',1,8,'f','annee','',358059,NULL); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('compte','Compte',1,1,'f','oid','',357897,'compte'); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Groupe',1,1,'f','oid','',357902,'groupe_ecriture'); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structbrouillard" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,99,'f','int4','',357881,NULL); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('libelle','Titre',1,1,'f','text','',357903,''); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,0,'f','date','',357884,''); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('valide','Valide',1,2,'f','bool','',357952,''); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,3,'f','date','',357885,''); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,4,'f','oid','',357882,'personne'); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,5,'f','oid','',357883,'personne'); INSERT INTO "structgroupe_ecriture" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('exercice','Exercice',1,3,'f','annee','',357953,''); INSERT INTO "structrapprochement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',358142,NULL); INSERT INTO "structrapprochement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('mouvement_banque','Mouvement',1,1,'f','oid','',358143,'mouvement_banque'); INSERT INTO "structrapprochement" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('ecriture','Ecritures',1,1,'f','oid','',358144,'ecriture'); INSERT INTO "typeaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358476,358202,0,'05/07/2002','05/07/2002','Tel'); INSERT INTO "typeaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358477,358202,0,'05/07/2002','05/07/2002','Mail'); INSERT INTO "typeaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358478,358202,0,'05/07/2002','05/07/2002','RDV'); INSERT INTO "typeaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358479,358202,0,'05/07/2002','05/07/2002','Envoi courrier'); INSERT INTO "typeaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358827,24527,24527,'06/27/2002','06/27/2002','T\342che'); INSERT INTO "typeaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358828,24527,24527,'06/27/2002','06/27/2002','D\351veloppement'); INSERT INTO "structtypeaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structtypeaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structtypeaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Action',1,0,'f','text','',358449,NULL); INSERT INTO "structtypeaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "structtypeaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','join(''/'',$con->getdate());',357884,NULL); INSERT INTO "structtypeaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','join(''/'',$con->getdate());',357885,NULL); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('reaction','Reaction',1,3,'f','oid','',358454,'reaction'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('todo_act','A Faire',1,14,'f','oid','0',358804,'todo_act'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('typeaction','Action',1,1,'f','oid','',358452,'typeaction'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('intervenant','Intervenant',1,0,'f','oid','$pimuser',358450,'intervenant'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('contact','Contact',1,1,'f','oid','$contact',358451,'contact'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('commentaire','Commentaire',1,4,'f','textA','',358455,NULL); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('date','Date',1,0,'f','timestamp','',358453,''); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','join(''/'',$con->getdate());',357884,NULL); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',99,1,'f','int4','',357881,''); INSERT INTO "structaction_crm" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','join(''/'',$con->getdate());',357885,NULL); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358483,0,0,'05/07/2002','05/07/2002','Directeur / PDG'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358484,0,0,'05/07/2002','05/07/2002','DI / DSI'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358485,0,0,'05/07/2002','05/07/2002','Secretaire'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358486,0,0,'05/07/2002','05/07/2002','Commercial'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358487,0,0,'05/07/2002','05/07/2002','Chef de Projet'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358488,0,0,'05/07/2002','05/07/2002','Developpeur'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358700,0,0,'06/10/2002','06/10/2002','Comptable'); INSERT INTO "fonction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358726,0,0,'06/12/2002','06/12/2002','webmaster'); INSERT INTO "structfonction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structfonction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','',357884,NULL); INSERT INTO "structfonction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','',357885,NULL); INSERT INTO "structfonction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Fonction',1,0,'f','text','',358458,NULL); INSERT INTO "structfonction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structfonction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7297,NULL,NULL,NULL,NULL,'PLUTOT POSITIF'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7298,NULL,NULL,NULL,NULL,'POSITIF'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7299,NULL,NULL,NULL,NULL,'TRES POSITIF'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7301,NULL,NULL,NULL,NULL,'PLUTOT NEGATIF'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7302,NULL,NULL,NULL,NULL,'TRES NEGATIF'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358819,24527,24527,'06/26/2002','06/26/2002','INDIFFERENT'); INSERT INTO "reaction" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7300,NULL,24527,NULL,'06/26/2002','NEGATIF'); INSERT INTO "structreaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structreaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','',357884,NULL); INSERT INTO "structreaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','',357885,NULL); INSERT INTO "structreaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Reaction',1,0,'f','text','',358800,NULL); INSERT INTO "structreaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structreaction" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7303,NULL,NULL,NULL,NULL,'A RAPPELER'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7304,NULL,NULL,NULL,NULL,'FIN DES CONTACTS'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (7305,NULL,NULL,NULL,NULL,'EN ATTENTE'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358816,0,0,'06/26/2002','06/26/2002','MAIL'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358817,0,0,'06/26/2002','06/26/2002','FAX'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (358818,24527,24527,'06/26/2002','06/26/2002','COURRIER'); INSERT INTO "todo_act" ("uid","authcrea","authmodif","datecrea","datemodif","nom") VALUES (359174,24527,24527,'09/26/2002','09/26/2002','DONE.'); INSERT INTO "structtodo_act" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structtodo_act" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','',357884,NULL); INSERT INTO "structtodo_act" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','',357885,NULL); INSERT INTO "structtodo_act" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('nom','Todo_Act',1,0,'f','text','',358802,NULL); INSERT INTO "structtodo_act" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structtodo_act" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('uid','pg_id',0,1,'f','int4','',357881,NULL); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datecrea','Creation',1,1,'f','date','',357884,NULL); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('datemodif','Last Modif.',1,1,'f','date','',357885,NULL); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authcrea','Auteur',1,1,'f','oid','',357882,'personne'); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('authmodif','Modifieur',1,1,'f','oid','',357883,'personne'); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('image','Image',1,1,'f','file','',359418,NULL); INSERT INTO "structimg_chq" ("champ","denom","editable","rang","isoid","type","defaut","uid","disp") VALUES ('groupe_ecriture','Ecritures',1,1,'f','oid','',359419,'groupe_ecriture'); CREATE UNIQUE INDEX "devis_uid_key" on "devis" using btree ( "uid" "int4_ops" ); CREATE UNIQUE INDEX "rdvstate_uid_key" on "rdvstate" using btree ( "uid" "int4_ops" ); CREATE INDEX "maboite_uid_idx" on "maboite" using btree ( "uid" "int4_ops" ); CREATE UNIQUE INDEX "refrdv_uid_key" on "refrdv" using btree ( "uid" "int4_ops" ); CREATE INDEX "typesociete_uid_idx" on "typesociete" using btree ( "uid" "int4_ops" ); CREATE INDEX "statut_uid_idx" on "statut" using btree ( "uid" "int4_ops" ); CREATE INDEX "banque_uid_idx" on "banque" using btree ( "uid" "int4_ops" ); CREATE INDEX "compte_banque_uid_idx" on "compte_banque" using btree ( "uid" "int4_ops" ); CREATE INDEX "mouvement_banque_uid_idx" on "mouvement_banque" using btree ( "uid" "int4_ops" ); CREATE INDEX "devise_uid_idx" on "devise" using btree ( "uid" "int4_ops" ); CREATE INDEX "intervenant_uid_idx" on "intervenant" using btree ( "uid" "int4_ops" ); CREATE INDEX "contact_uid_idx" on "contact" using btree ( "uid" "int4_ops" ); CREATE INDEX "rdvstate_uid_idx" on "rdvstate" using btree ( "uid" "int4_ops" ); CREATE INDEX "devis_uid_idx" on "devis" using btree ( "uid" "int4_ops" ); CREATE INDEX "factures_uid_idx" on "factures" using btree ( "uid" "int4_ops" ); CREATE INDEX "reglement_uid_idx" on "reglement" using btree ( "uid" "int4_ops" ); CREATE INDEX "constantes_uid_idx" on "constantes" using btree ( "uid" "int4_ops" ); CREATE INDEX "fournisseur_uid_idx" on "fournisseur" using btree ( "uid" "int4_ops" ); CREATE INDEX "organisme_uid_idx" on "organisme" using btree ( "uid" "int4_ops" ); CREATE INDEX "typepaiement_uid_idx" on "typepaiement" using btree ( "uid" "int4_ops" ); CREATE INDEX "userid_uid_idx" on "userid" using btree ( "uid" "int4_ops" ); CREATE INDEX "typesalaire_uid_idx" on "typesalaire" using btree ( "uid" "int4_ops" ); CREATE INDEX "client_uid_idx" on "client" using btree ( "uid" "int4_ops" ); CREATE INDEX "rendezvous_uid_idx" on "rendezvous" using btree ( "uid" "int4_ops" ); CREATE INDEX "jhomme_uid_idx" on "jhomme" using btree ( "uid" "int4_ops" ); CREATE INDEX "salaire_uid_idx" on "salaire" using btree ( "uid" "int4_ops" ); CREATE INDEX "ch_sociales_uid_idx" on "ch_sociales" using btree ( "uid" "int4_ops" ); CREATE INDEX "achat_uid_idx" on "achat" using btree ( "uid" "int4_ops" ); CREATE INDEX "charges_uid_idx" on "charges" using btree ( "uid" "int4_ops" ); CREATE INDEX "refrdv_uid_idx" on "refrdv" using btree ( "uid" "int4_ops" ); CREATE INDEX "typeactivite_uid_idx" on "typeactivite" using btree ( "uid" "int4_ops" ); CREATE INDEX "formule_uid_idx" on "formule" using btree ( "uid" "int4_ops" ); CREATE INDEX "relance_uid_idx" on "relance" using btree ( "uid" "int4_ops" ); CREATE INDEX "agenda_uid_idx" on "agenda" using btree ( "uid" "int4_ops" ); CREATE INDEX "lettre_uid_idx" on "lettre" using btree ( "uid" "int4_ops" ); CREATE INDEX "societe_uid_idx" on "societe" using btree ( "uid" "int4_ops" ); CREATE INDEX "rights_uid_idx" on "rights" using btree ( "uid" "int4_ops" ); CREATE UNIQUE INDEX "object_uid_key" on "object" using btree ( "uid" "int4_ops" ); CREATE INDEX "factures_client_idx" on "factures" using btree ( "client" "oid_ops" ); CREATE INDEX "groupe_ecritures_uid" on "groupe_ecriture" using btree ( "uid" "int4_ops" ); CREATE INDEX "ecriture_uid" on "ecriture" using btree ( "uid" "int4_ops" ); CREATE UNIQUE INDEX "rapprochement_uid_key" on "rapprochement" using btree ( "uid" "int4_ops" ); CREATE TRIGGER "trigger_create_compte_client" BEFORE INSERT ON "client" FOR EACH ROW EXECUTE PROCEDURE "create_compte_client" (); CREATE TRIGGER "trigger_create_compte_fournisse" BEFORE INSERT ON "fournisseur" FOR EACH ROW EXECUTE PROCEDURE "create_compte_fournisseur" (); CREATE TRIGGER "trigger_create_compte_organisme" BEFORE INSERT ON "organisme" FOR EACH ROW EXECUTE PROCEDURE "create_compte_organisme" (); CREATE TRIGGER "trigger_compute_solde" BEFORE INSERT OR UPDATE ON "compte" FOR EACH ROW EXECUTE PROCEDURE "compute_solde" (); CREATE TRIGGER "trigger_modif_compte" AFTER INSERT ON "ecriture" FOR EACH ROW EXECUTE PROCEDURE "modif_compte" (); CREATE TRIGGER "trigger_erase_ecriture" BEFORE DELETE ON "ecriture" FOR EACH ROW EXECUTE PROCEDURE "erase_ecriture" (); CREATE TRIGGER "trigger_modif_gecr" BEFORE UPDATE ON "groupe_ecriture" FOR EACH ROW EXECUTE PROCEDURE "modif_gecr" ();