Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 27th, 2012  |  syntax: None  |  size: 11.52 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. INSERT INTO ENTREPRISE VALUES('1','Les Croustilles YumYum','40 rue du moulin,warwick','1955');
  2. INSERT INTO ENTREPRISE VALUES('2','Les Entreprises Cascade','12 rue marie-victorin,Kingsey Falls','1969');
  3. INSERT INTO ENTREPRISE VALUES('3','Les Solutions M.G.','34 rue St-louis, Warwick','2010');
  4. INSERT INTO ENTREPRISE VALUES('4','Controletech','228 rue Omer, St-Christophe d Artabaska','2001');
  5. INSERT INTO ENTREPRISE VALUES('5','Conceptromec','234 bouvard industriel, Magog','1999');
  6. INSERT INTO ENTREPRISE VALUES('6','Entreprise pas fiable','3 rue Meilleur, St-Rosare','1888');
  7. INSERT INTO ENTREPRISE VALUES('7','Le centre du pneu','3 rue Hotel de ville, Warwick','2001');
  8.  
  9. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('1','USPS','582,97');
  10. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('2','CANADA POST','533,17');
  11. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('3','CANADA POST','132,92');
  12. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('4','USPS','990,11');
  13. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('5','CANADA POST','172,79');
  14. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('6','CN','245,28');
  15. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('7','TRANSPORT INC','398,89');
  16. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('8','PUROLATOR','931,77');
  17. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('9','DICOM','835,72');
  18. INSERT INTO INTERMEDIAIRE (CODEINTER,NOMINTER,COUTLIVR) VALUES ('10','PUROLATOR','010,16');
  19.  
  20. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('4','5','1-332-936-6733','Piper Montgomery','fermentum risus,');
  21. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('5','1','1-774-704-5605','Barbara Norton','lacinia at, iaculis quis, pede.');
  22. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('2','6','1-157-414-1579','Clare Tanner','lectus pede et risus. Quisque libero lacus, varius');
  23. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('1','3','1-640-796-3914','Melinda Mcpherson','nonummy');
  24. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('3','1','1-505-746-2154','Azalia Finley','erat. Sed nunc est,');
  25. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('5','7','1-676-540-5541','Charity Knapp','mus. Proin');
  26. INSERT INTO CONTACT (CODECONTACT,CODEENT,TELCONTACT,NOMCONTACT,DESCRIPTION) VALUES ('5','2','1-613-176-2313','Margaret Jensen','ligula consectetuer rhoncus. Nullam velit');
  27.  
  28.  
  29. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('1','3','10','1','2001-07-18');
  30. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('2','5','8','1','2011-12-30');
  31. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('3','9','7','1','2012-02-22');
  32. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('4','1','8','5','2003-02-01');
  33. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('5','5','6','3','2006-01-20');
  34. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('6','10','7','3','2006-03-17');
  35. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('7','1','5','1','2009-03-30');
  36. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('8','9','1','4','2005-12-04');
  37. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('9','10','4','5','2002-10-14');
  38. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('10','2','5','4','2006-07-14');
  39. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('11','2','7','4','2007-11-15');
  40. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('12','3','2','3','2008-07-03');
  41. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('13','3','1','2','2003-02-15');
  42. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('14','4','1','5','2006-12-17');
  43. INSERT INTO COTECLIENT (NUMCOTE,CODEENT,CODECLIENT,COTECLIENT,DATECONTACT) VALUES ('15','4','6','3','2006-09-15');
  44.  
  45. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('1','1','1','3','5');
  46. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('2','2','2','1','2');
  47. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('3','3','3','2','10');
  48. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('4','4','4','3','9');
  49. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('5','5','5','3','20');
  50. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('6','6','6','3','5');
  51. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('7','7','7','1','9');
  52. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('8','8','8','4','24');
  53. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('9','9','9','1','6');
  54. INSERT INTO COTEFOURN (NUMCOTE,CODEENT,CODEFOURNISSEUR,SATISFACTION,DELAISLIVRAISON) VALUES ('10','10','10','1','4');
  55.  
  56. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('1','1','295718038046','6091039');
  57. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('2','2','11986834563','4776573');
  58. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('3','3','517310612539','4417293');
  59. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('4','4','295624374936','9263852');
  60. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('5','5','690428429584','2635120');
  61. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('6','6','162899646897','3537797');
  62. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('7','7','850783124661','8057169');
  63. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('8','8','304237817852','1291873');
  64. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('9','9','945855570101','3353454');
  65. INSERT INTO ENTMANUF (CODEENTMANUF,CODEENT,TOTEXPORT,TOTVENTE) VALUES ('10','10','646796603493','1536941');
  66.  
  67.  
  68. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('1','1','2','47');
  69. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('2','2','3','42');
  70. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('3','3','1','44');
  71. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('4','4','19','47');
  72. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('5','5','27','30');
  73. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('6','6','28','31');
  74. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('7','7','41','17');
  75. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('8','8','24','49');
  76. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('9','9','7','25');
  77. INSERT INTO SECALIM (CODESECTEUR,CODEENT,NBINTOX,NBJOURVIANDEENTR) VALUES ('10','10','32','1');
  78.  
  79.  
  80. INSERT INTO SECTEUR (CODESECTEUR,NOMSECTEUR) VALUES ('1','METALURGIE');
  81. INSERT INTO SECTEUR (CODESECTEUR,NOMSECTEUR) VALUES ('2','ALIMENTATION');
  82. INSERT INTO SECTEUR (CODESECTEUR,NOMSECTEUR) VALUES ('3','ALIMENTATION');
  83. INSERT INTO SECTEUR (CODESECTEUR,NOMSECTEUR) VALUES ('4','PAPIER');
  84.  
  85.  
  86. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('1','1','7175','335');
  87. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('2','2','6102','506');
  88. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('3','3','3955','428');
  89. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('4','4','6041','588');
  90. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('5','5','880','697');
  91. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('6','6','4469','127');
  92. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('7','7','5169','667');
  93. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('8','8','2269','331');
  94. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('9','9','5958','345');
  95. INSERT INTO SECTPAP (CODESECTEUR,CODEENT,QUANTPAPIER,QUANTPAPIERRECYCLE) VALUES ('10','10','716','243');
  96.  
  97.  
  98. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('6','2','9','1','504,64','2001-04-17','2012-03-18','tellus.');
  99. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('2','8','10','5','307,67','2010-05-14','2012-10-14','dolor,');
  100. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('5','5','9','2','460,76','2004-12-21','2013-03-08','facilisis');
  101. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('8','3','10','6','256,61','2002-11-17','2012-06-28','a');
  102. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('4','3','8','3','712,57','2009-12-25','2011-05-31','semper');
  103. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('3','3','5','1','497,46','2005-01-18','2012-11-21','Mauris');
  104. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('3','5','7','2','086,65','2003-01-23','2012-09-13','erat');
  105. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('8','9','2','6','086,34','2003-01-26','2011-11-12','vitae');
  106. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('4','7','8','9','717,46','2010-07-03','2013-03-21','laoreet');
  107. INSERT INTO TRANSACT (CODEFOURNISSEUR,NUMTRANS,CODECLIENT,CODEINTER,TOTTRANSACTION,DATECOMM,DATELIVR,TYPEPROD) VALUES ('9','9','9','5','082,75','2002-04-29','2011-05-04','erat');
  108.  
  109. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('6','8');
  110. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('3','4');
  111. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('10','6');
  112. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('7','5');
  113. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('5','3');
  114. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('4','4');
  115. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('2','3');
  116. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('6','4');
  117. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('1','2');
  118. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('7','9');
  119. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('5','7');
  120. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('8','9');
  121. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('1','6');
  122. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('5','7');
  123. INSERT INTO ENTSECT (CODEENTMANUF,CODESECTEUR) VALUES ('4','3');
create a new version of this paste RAW Paste Data