636 lines
11 KiB
Plaintext
Executable File
636 lines
11 KiB
Plaintext
Executable File
|
|
|
|
|
|
DECLARE (destination);
|
|
|
|
DECLARE cursor_alloav3 CURSOR FOR dballoaGov210712
|
|
SELECT ALL destination FROM MAP
|
|
WHERE ID = 0
|
|
ALTER TABLE destination
|
|
ADD destination VARCHAR (20)
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @destination
|
|
FETCH curseur_alloa INTO ID
|
|
INSERT INTO DESTINATION ('destination')
|
|
VALUES ('uuiddestination', 'uuidregion')
|
|
END
|
|
CLOSE cursor_alloaV3
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (destination);
|
|
|
|
DECLARE cursor_alloav3 CURSOR FOR dballoaGov210712
|
|
SELECT ALL destination FROM vMAP
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @DESTINATION
|
|
INSERT INTO DESTINATION ('destination')
|
|
VALUES ('uuiddestination', 'uuidregion')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (pays);
|
|
|
|
DECLARE cursor_alloav3 CURSOR FOR dballoaGov210712
|
|
SELECT ALL pays FROM MAP
|
|
WHERE ID = 0
|
|
ALTER TABLE pays
|
|
MODIFY pays VARCHAR
|
|
BEGIN
|
|
|
|
OPEN cursor_alloaV3
|
|
|
|
FETCH cursor_alloaV3 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @PAYS
|
|
FETCH curseur_alloa INTO ID
|
|
INSERT INTO PAYS ('pays')
|
|
VALUES ('uuidpays')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (pays VARCHAR (50));
|
|
|
|
DECLARE cursor_dballoaGov210712 CURSOR FOR dballoaGov210712
|
|
SELECT ALL pays FROM vMAP
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @PAYS
|
|
INSERT INTO PAYS ('pays')
|
|
VALUES ('uuidpays')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (ville VARCHAR (20));
|
|
|
|
DECLARE cursor_alloav3 CURSOR FOR dballoaGov210712
|
|
SELECT ALL pays FROM MAP
|
|
WHERE ID = 0
|
|
ALTER TABLE ville
|
|
MODIFY ville VARCHAR (20)
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @ville
|
|
INSERT INTO ville ('ville')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuidville', 'uuidregion')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (ville VARCHAR (20));
|
|
|
|
DECLARE cursor_dballoaGov210712 CURSOR FOR dballoaGov210712
|
|
SELECT ALL ville FROM vMAP
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @ville
|
|
INSERT INTO ville ('ville')
|
|
VALUES ('uuidville', uuidregion)
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (demande_de_devis VARCHAR (50));
|
|
|
|
DECLARE cursor_alloav3 CURSOR FOR dballoaGov210712
|
|
SELECT ALL demande_de_devis from activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @demande_de_devis VARCHAR (50)
|
|
INSERT INTO demande_de_devis ('demande_de_devis')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuiddemande', 'uuidcomposant')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
|
|
DECLARE (demande_de_devis VARCHAR (50));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL demande_de_devis from vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @demande_de_devis
|
|
INSERT INTO demande_de_devis ('demande_de_devis')
|
|
VALUES ('uuiddmande', 'uuidcomposant')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
DECLARE (dossier VARCHAR (50));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL dossier FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @dossier
|
|
INSERT INTO dossier ('dossier')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuiddossier', 'uuidclients')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (dossier VARCHAR (50));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL dossier from vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @dossier VARCHAR (50)
|
|
INSERT INTO ('dossier')
|
|
VALUES ('uuiddossier', 'uuidclients')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (encaissement_decaissement INTEGER (50));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL encaissement_decaissement FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH_ID = 0
|
|
BEGIN
|
|
PRINT @dossier VARCHAR (50)
|
|
INSERT INTO ('encaissement_decaissement')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuid', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (encaissement_decaissement INTEGER (50));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL encaissement_decaissement FROM vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @encaissement_decaissement
|
|
INSERT INTO ('encaissement_decaissement')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuid', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
DECLARE (facture_avoir INTEGER (20));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL facture_avoir FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @facture_avoir
|
|
INSERT INTO ('fature_avoir')
|
|
VALUES ('uuidfacture_avoir', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (facture_avoir INTEGER (20));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL facture_avoir FROM vactive
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @facture_avoir
|
|
INSERT INTO ('facture_avoir')
|
|
VALUES ('uuidfacture_avoir', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
DECLARE (ligne_dossier VARCHAR (40));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL facture_avoir FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @ligne_dossier
|
|
INSERT INTO ('ligne_dossier')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuidligne_dossier', 'uuidfournisseurs', 'uuiddevise', 'uuidtva', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE (ligne_dossier VARCHAR (40));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL ligne_dossier FROM vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @ligne_dossier
|
|
INSERT INTO ('ligne_dossier')
|
|
VALUES ('uuidligne_dossier', 'uuidfournisseur', 'uuiddevise', 'uuidtva', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
DECLARE (message_demande VARCHAR (40));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL message_demande FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @message_demande
|
|
INSERT INTO ('message_demande')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuidmessage_demande', 'uuiddemande')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
|
|
DECLARE (message_demande VARCHAR (40));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL message_demande FROM vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @message_demande
|
|
INSERT INTO ('message_demande')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuidmessage_demande', 'uuiddemande')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
DECLARE (monprojet VARCHAR (50));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL monprojet FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @monprojet
|
|
INSERT INTO ('monprojet')
|
|
FETCH cursor_alloa INTO ID
|
|
VALUES ('uuidblogprojet', 'uuiduserweb')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (monprojet VARCHAR (50));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL monprojet FROM vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712 INTO
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @monprojet
|
|
INSERT INTO ('monprojet')
|
|
FETCH cursor_alloav3 INTO ID
|
|
VALUES ('uuidblogprojet', 'uuiduserweb')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
DECLARE (passager VARCHAR (20));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL passager FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @passager
|
|
INSERT INTO ('passager')
|
|
FETCH cursor alloav3
|
|
VALUES ('uuidpassager', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (passager VARCHAR (20));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL passager FROM vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @passager
|
|
INSERT INTO ('passager')
|
|
FETCH cursor dballoaGov210712
|
|
VALUES ('pass_uuid', 'uuiddossier')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
|
|
DECLARE (tchat_client_staff VARCHAR (20));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL ('tchat_client_staff') FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @tchat_client_staff
|
|
INSERT INTO ('tchat_client_staff')
|
|
FETCH cursor alloav3
|
|
VALUES ('uuiddemande','uuidclient')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (tchat_client_staff VARCHAR (20));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL ('tchat_client_staff') FROM vactiv
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @tchat_client_staff
|
|
INSERT INTO ('tchat_client_staff')
|
|
FETCH cursor_dballoaGov210712
|
|
VALUE ('uuiddemande', 'uuidclient')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
|
|
DECLARE (tchat_demande VARCHAR (20));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL ('tchat_demande') FROM activate
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_alloav3
|
|
|
|
FETCH cursor_alloav3
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @tchat_demande
|
|
INSERT INTO ('tchat_demande')
|
|
FETCH cursor_alloav3
|
|
VALUES ('uuidclient', 'uuiddemande')
|
|
END
|
|
CLOSE cursor_alloav3
|
|
|
|
|
|
|
|
DECLARE (tchat_demande VARCHAR (20));
|
|
|
|
DECLARE cursor_dballoaGov210712 cursor FOR dballoaGov210712
|
|
SELECT ALL ('tchat_demande')
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @tchat_demande
|
|
INSERT INTO ('tchat_demande')
|
|
FETCH cursor_dballoaGov210712
|
|
VALUES ('uuidclient', 'uuiddemande')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
DECLARE (userweb VARCHAR (20));
|
|
|
|
DECLARE cursor_alloav3 cursor FOR dballoaGov210712
|
|
SELECT ALL ('userweb')
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @userweb
|
|
INSERT INTO ('userweb')
|
|
FETCH cursor_dballoaGov210712
|
|
VALUES ('userw_uuid')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|
|
DECLARE ('userweb' VARCHAR (20));
|
|
|
|
DECLARE cursor_dballoaGov210712 FOR dballoaGov210712
|
|
SELECT ALL ('userweb')
|
|
WHERE ID = 0
|
|
BEGIN
|
|
|
|
OPEN cursor_dballoaGov210712
|
|
|
|
FETCH cursor_dballoaGov210712
|
|
|
|
WHILE @@FETCH ID = 0
|
|
BEGIN
|
|
PRINT @userweb
|
|
INSERT INTO ('userweb')
|
|
FETCH cursor_dballoaGov210712
|
|
VALUES ('userw_uuid')
|
|
END
|
|
CLOSE cursor_dballoaGov210712
|
|
|
|
|