API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 5th, 2016
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 92.09 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  4. SET time_zone = "+00:00";
  5.  
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!40101 SET NAMES utf8mb4 */;
  10.  
  11. --
  12. -- Database: `palestra`
  13. --
  14.  
  15. SET FOREIGN_KEY_CHECKS = 0;
  16.  
  17.  
  18. --
  19. -- Struttura della tabella `abbonamento`
  20. --
  21.  
  22. CREATE TABLE `abbonamento` (
  23. `ID_Abbonamento` int(11) NOT NULL,
  24. `ID_Utente` char(16) NOT NULL,
  25. `Data_Inizio` date NOT NULL,
  26. `Data_Fine` date NOT NULL,
  27. `Prezzo` decimal(5,2) NOT NULL,
  28. `Tipo` enum('Mensile','Bimestrale','Trimestrale','Semestrale','Annuale') DEFAULT 'Mensile',
  29. `Sauna` tinyint(1) DEFAULT '0'
  30. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  31.  
  32. --
  33. -- Inserimento dati per la tabella `abbonamento`
  34. --
  35.  
  36. INSERT INTO `abbonamento` (`ID_Abbonamento`, `ID_Utente`, `Data_Inizio`, `Data_Fine`, `Prezzo`, `Tipo`, `Sauna`) VALUES
  37. (1, 'BGLLDA65T30L407Z', '2002-05-17', '2002-06-17', '40.00', 'Mensile', 0),
  38. (3, 'BGLLDA65T30L407Z', '2002-06-19', '2002-08-19', '70.00', 'Bimestrale', 0),
  39. (4, 'BGLLDA65T30L407Z', '2002-08-25', '2002-11-25', '95.00', 'Trimestrale', 0),
  40. (5, 'BGLLDA65T30L407Z', '2003-12-01', '2004-12-01', '300.00', 'Annuale', 0),
  41. (6, 'BGLLDA65T30L407Z', '2004-12-07', '2005-12-07', '330.00', 'Annuale', 1),
  42. (7, 'BGLLDA65T30L407Z', '2006-01-09', '2007-01-09', '300.00', 'Annuale', 0),
  43. (8, 'BGLLDA65T30L407Z', '2007-01-19', '2007-02-19', '40.00', 'Mensile', 0),
  44. (9, 'BGLLDA65T30L407Z', '2007-02-21', '2007-08-21', '187.00', 'Semestrale', 1),
  45. (10, 'BGLLDA65T30L407Z', '2008-01-13', '2008-04-13', '104.50', 'Trimestrale', 1),
  46. (11, 'BGLLDA65T30L407Z', '2012-09-10', '2012-10-10', '44.00', 'Mensile', 1),
  47. (12, 'BGLLDA65T30L407Z', '2012-10-12', '2013-10-12', '300.00', 'Annuale', 0),
  48. (13, 'GNDPRT77P67C817K', '2009-04-15', '2009-05-15', '40.00', 'Mensile', 0),
  49. (14, 'GNDPRT77P67C817K', '2009-05-18', '2009-08-18', '104.50', 'Trimestrale', 1),
  50. (15, 'GNDPRT77P67C817K', '2009-08-25', '2009-10-25', '70.00', 'Bimestrale', 0),
  51. (16, 'GNDPRT77P67C817K', '2009-11-02', '2010-05-02', '170.00', 'Semestrale', 0),
  52. (17, 'GNDPRT77P67C817K', '2010-08-07', '2010-10-07', '77.00', 'Bimestrale', 1),
  53. (18, 'GNDPRT77P67C817K', '2012-03-27', '2012-04-27', '40.00', 'Mensile', 0),
  54. (19, 'GNDPRT77P67C817K', '2014-06-20', '2014-09-20', '104.50', 'Trimestrale', 1),
  55. (20, 'GNDPRT77P67C817K', '2014-09-21', '2014-10-21', '40.00', 'Mensile', 0),
  56. (21, 'GNDPRT77P67C817K', '2014-10-25', '2014-12-25', '70.00', 'Bimestrale', 0),
  57. (22, 'LRASRM83H63C957B', '2013-07-19', '2013-08-19', '40.00', 'Mensile', 0),
  58. (23, 'LRASRM83H63C957B', '2013-08-20', '2013-09-20', '40.00', 'Mensile', 0),
  59. (24, 'LRASRM83H63C957B', '2013-09-23', '2013-10-23', '40.00', 'Mensile', 0),
  60. (25, 'LRASRM83H63C957B', '2013-10-24', '2013-11-24', '40.00', 'Mensile', 0),
  61. (26, 'LRASRM83H63C957B', '2013-11-26', '2014-01-26', '70.00', 'Bimestrale', 0),
  62. (27, 'HRRPTR91S21A663A', '2004-02-11', '2005-02-11', '300.00', 'Annuale', 0),
  63. (28, 'HRRPTR91S21A663A', '2005-02-16', '2006-02-16', '300.00', 'Annuale', 0),
  64. (29, 'HRRPTR91S21A663A', '2006-02-19', '2007-02-19', '300.00', 'Annuale', 0),
  65. (30, 'HRRPTR91S21A663A', '2007-03-01', '2008-03-01', '300.00', 'Annuale', 0),
  66. (31, 'HRRPTR91S21A663A', '2008-03-08', '2009-03-08', '300.00', 'Annuale', 0),
  67. (32, 'HRRPTR91S21A663A', '2009-03-15', '2009-09-15', '170.00', 'Semestrale', 0),
  68. (33, 'HRRPTR91S21A663A', '2009-10-01', '2010-10-01', '300.00', 'Annuale', 0),
  69. (34, 'HRRPTR91S21A663A', '2010-10-04', '2010-11-04', '40.00', 'Mensile', 0),
  70. (35, 'HRRPTR91S21A663A', '2010-11-09', '2011-11-09', '300.00', 'Annuale', 0),
  71. (36, 'HRRPTR91S21A663A', '2011-11-15', '2012-02-15', '104.50', 'Trimestrale', 1),
  72. (37, 'HRRPTR91S21A663A', '2013-04-22', '2013-05-22', '40.00', 'Mensile', 0),
  73. (38, 'HRRPTR91S21A663A', '2014-05-30', '2015-05-30', '300.00', 'Annuale', 0),
  74. (39, 'GRMSTT32S11H783G', '2014-05-14', '2014-06-14', '40.00', 'Mensile', 0),
  75. (40, 'GRMSTT32S11H783G', '2014-06-17', '2014-07-17', '44.00', 'Mensile', 1),
  76. (41, 'GRMSTT32S11H783G', '2014-07-26', '2014-08-26', '44.00', 'Mensile', 1),
  77. (42, 'GRMSTT32S11H783G', '2014-08-30', '2014-10-30', '77.00', 'Bimestrale', 1),
  78. (43, 'GRMSTT32S11H783G', '2014-11-05', '2014-12-05', '40.00', 'Mensile', 0),
  79. (44, 'GRMSTT32S11H783G', '2015-02-14', '2015-03-14', '44.00', 'Mensile', 1),
  80. (45, 'GRMSTT32S11H783G', '2015-03-21', '2015-06-21', '95.00', 'Trimestrale', 0),
  81. (46, 'GRMSTT32S11H783G', '2015-06-25', '2015-07-25', '40.00', 'Mensile', 0),
  82. (47, 'GRMSTT32S11H783G', '2015-07-30', '2016-01-30', '187.00', 'Semestrale', 1),
  83. (48, 'JJABZV65H15L407I', '2006-05-09', '2006-07-09', '70.00', 'Bimestrale', 0),
  84. (49, 'JJABZV65H15L407I', '2006-07-10', '2006-09-10', '77.00', 'Bimestrale', 1),
  85. (50, 'JJABZV65H15L407I', '2006-09-15', '2006-11-15', '77.00', 'Bimestrale', 1),
  86. (51, 'JJABZV65H15L407I', '2006-11-18', '2006-12-18', '40.00', 'Mensile', 0),
  87. (52, 'JJABZV65H15L407I', '2007-01-09', '2007-03-09', '70.00', 'Bimestrale', 0),
  88. (53, 'JJABZV65H15L407I', '2007-03-11', '2007-04-11', '40.00', 'Mensile', 0),
  89. (54, 'JJABZV65H15L407I', '2007-04-15', '2007-07-15', '95.00', 'Trimestrale', 0),
  90. (55, 'JJABZV65H15L407I', '2007-08-21', '2007-09-21', '40.00', 'Mensile', 0),
  91. (56, 'JJABZV65H15L407I', '2007-09-25', '2007-10-25', '40.00', 'Mensile', 0),
  92. (57, 'JJABZV65H15L407I', '2007-10-28', '2007-11-28', '40.00', 'Mensile', 0),
  93. (58, 'JJABZV65H15L407I', '2007-11-29', '2008-11-29', '300.00', 'Annuale', 0),
  94. (59, 'MRCMDR82A62G224B', '2010-09-01', '2011-09-01', '300.00', 'Annuale', 0),
  95. (60, 'MRCMDR82A62G224B', '2011-09-04', '2012-09-04', '300.00', 'Annuale', 0),
  96. (61, 'MRCMDR82A62G224B', '2012-10-09', '2012-11-09', '40.00', 'Mensile', 0),
  97. (62, 'MRCMDR82A62G224B', '2012-11-15', '2013-11-15', '300.00', 'Annuale', 0),
  98. (63, 'MRCMDR82A62G224B', '2013-12-01', '2014-12-01', '300.00', 'Annuale', 0),
  99. (64, 'MRCMDR82A62G224B', '2015-01-08', '2016-01-08', '300.00', 'Annuale', 0),
  100. (65, 'MRCMDR82A62G224B', '2016-02-01', '2016-08-01', '170.00', 'Semestrale', 0),
  101. (66, 'RMNPWR51R42L407G', '2007-02-13', '2007-03-13', '40.00', 'Mensile', 0),
  102. (67, 'RMNPWR51R42L407G', '2007-03-14', '2007-04-14', '40.00', 'Mensile', 0),
  103. (68, 'RMNPWR51R42L407G', '2007-04-16', '2007-05-16', '40.00', 'Mensile', 0),
  104. (69, 'RMNPWR51R42L407G', '2007-05-19', '2007-06-19', '40.00', 'Mensile', 0),
  105. (70, 'RMNPWR51R42L407G', '2007-06-22', '2007-12-22', '170.00', 'Semestrale', 0),
  106. (71, 'RMNPWR51R42L407G', '2007-12-25', '2008-01-25', '40.00', 'Mensile', 0),
  107. (72, 'RMNPWR51R42L407G', '2008-01-26', '2008-02-26', '40.00', 'Mensile', 0),
  108. (73, 'RMNPWR51R42L407G', '2008-02-28', '2009-02-28', '300.00', 'Annuale', 0),
  109. (74, 'RMNPWR51R42L407G', '2009-03-01', '2010-03-01', '300.00', 'Annuale', 0),
  110. (75, 'RMNPWR51R42L407G', '2010-03-11', '2011-03-11', '300.00', 'Annuale', 0),
  111. (76, 'RMNPWR51R42L407G', '2012-04-07', '2013-04-07', '300.00', 'Annuale', 0),
  112. (78, 'NZETMN96C06G693G', '2012-08-27', '2012-09-27', '40.00', 'Mensile', 0),
  113. (79, 'NZETMN96C06G693G', '2012-09-28', '2012-10-28', '44.00', 'Mensile', 1),
  114. (80, 'NZETMN96C06G693G', '2012-10-29', '2012-11-29', '40.00', 'Mensile', 0),
  115. (81, 'NZETMN96C06G693G', '2012-11-30', '2012-12-30', '40.00', 'Mensile', 0),
  116. (82, 'NZETMN96C06G693G', '2013-01-09', '2013-03-09', '77.00', 'Bimestrale', 1),
  117. (83, 'NZETMN96C06G693G', '2013-03-12', '2013-05-12', '70.00', 'Bimestrale', 0),
  118. (84, 'NZETMN96C06G693G', '2013-05-15', '2013-07-15', '77.00', 'Bimestrale', 1),
  119. (85, 'NZETMN96C06G693G', '2013-07-16', '2013-09-16', '70.00', 'Bimestrale', 0),
  120. (86, 'NZETMN96C06G693G', '2013-09-22', '2013-11-22', '70.00', 'Bimestrale', 0),
  121. (87, 'NZETMN96C06G693G', '2013-11-25', '2014-01-25', '77.00', 'Bimestrale', 1),
  122. (88, 'NZETMN96C06G693G', '2014-01-30', '2015-01-30', '330.00', 'Annuale', 1),
  123. (89, 'NZETMN96C06G693G', '2015-02-05', '2015-08-05', '170.00', 'Semestrale', 0),
  124. (90, 'GVNSRT57B20F205R', '2010-06-19', '2010-12-19', '170.00', 'Semestrale', 0),
  125. (91, 'GVNSRT57B20F205R', '2010-12-22', '2011-06-22', '170.00', 'Semestrale', 0),
  126. (92, 'GVNSRT57B20F205R', '2011-06-25', '2011-12-25', '170.00', 'Semestrale', 0),
  127. (93, 'GVNSRT57B20F205R', '2013-01-20', '2014-01-20', '300.00', 'Annuale', 0),
  128. (94, 'GVNSRT57B20F205R', '2014-02-01', '2015-02-01', '300.00', 'Annuale', 0),
  129. (95, 'GVNSRT57B20F205R', '2014-04-06', '2014-05-06', '40.00', 'Mensile', 0),
  130. (96, 'GVNSRT57B20F205R', '2014-04-08', '2014-06-08', '70.00', 'Bimestrale', 0),
  131. (97, 'GVNSRT57B20F205R', '2014-06-10', '2014-08-10', '70.00', 'Bimestrale', 0),
  132. (98, 'GVNSRT57B20F205R', '2014-08-15', '2014-10-15', '70.00', 'Bimestrale', 0),
  133. (99, 'KVNVCR74E07C743H', '2001-12-01', '2002-12-01', '300.00', 'Annuale', 0),
  134. (100, 'KVNVCR74E07C743H', '2003-01-08', '2004-01-08', '330.00', 'Annuale', 1),
  135. (101, 'KVNVCR74E07C743H', '2004-01-09', '2005-01-09', '330.00', 'Annuale', 1),
  136. (102, 'KVNVCR74E07C743H', '2005-01-10', '2006-01-10', '300.00', 'Annuale', 0),
  137. (103, 'KVNVCR74E07C743H', '2006-01-11', '2007-01-11', '330.00', 'Annuale', 1),
  138. (104, 'KVNVCR74E07C743H', '2007-01-12', '2008-01-12', '300.00', 'Annuale', 0),
  139. (105, 'KVNVCR74E07C743H', '2008-01-13', '2009-01-13', '330.00', 'Annuale', 1),
  140. (106, 'KVNVCR74E07C743H', '2009-01-14', '2010-01-14', '330.00', 'Annuale', 1),
  141. (107, 'KVNVCR74E07C743H', '2010-01-15', '2011-01-15', '330.00', 'Annuale', 1),
  142. (108, 'KVNVCR74E07C743H', '2011-01-16', '2012-01-16', '330.00', 'Annuale', 1),
  143. (109, 'KVNVCR74E07C743H', '2012-01-17', '2013-01-17', '330.00', 'Annuale', 1),
  144. (110, 'KVNVCR74E07C743H', '2013-01-18', '2014-01-18', '300.00', 'Annuale', 0),
  145. (111, 'KVNVCR74E07C743H', '2014-01-19', '2015-01-19', '330.00', 'Annuale', 1),
  146. (112, 'KVNVCR74E07C743H', '2015-01-20', '2016-01-20', '330.00', 'Annuale', 1),
  147. (113, 'KVNVCR74E07C743H', '2016-01-21', '2017-01-21', '300.00', 'Annuale', 0),
  148. (114, 'GCMPTT56D26L928X', '2011-07-14', '2011-08-14', '40.00', 'Mensile', 0),
  149. (115, 'GCMPTT56D26L928X', '2011-08-17', '2011-09-17', '40.00', 'Mensile', 0),
  150. (116, 'GCMPTT56D26L928X', '2011-09-19', '2011-10-19', '40.00', 'Mensile', 0),
  151. (117, 'GCMPTT56D26L928X', '2011-10-25', '2011-11-25', '40.00', 'Mensile', 0),
  152. (118, 'MRCZYT78T05Z613A', '2004-02-07', '2005-02-07', '330.00', 'Annuale', 1),
  153. (119, 'CHRPGN95D58L407B', '2014-08-05', '2014-09-05', '44.00', 'Mensile', 1),
  154. (119, 'MRCZYT78T05Z613A', '2001-07-08', '2001-08-08', '40.00', 'Mensile', 0),
  155. (120, 'CVLFCH87H01B516Q', '2015-01-02', '2015-02-02', '40.00', 'Mensile', 0),
  156. (120, 'MRCZYT78T05Z613A', '2001-08-10', '2001-09-10', '40.00', 'Mensile', 0),
  157. (121, 'CVLFCH87H01B516Q', '2015-02-05', '2015-03-05', '40.00', 'Mensile', 0),
  158. (121, 'MRCZYT78T05Z613A', '2001-09-12', '2001-10-12', '40.00', 'Mensile', 0),
  159. (122, 'CVLFCH87H01B516Q', '2015-03-09', '2015-04-09', '40.00', 'Mensile', 0),
  160. (122, 'MRCZYT78T05Z613A', '2001-10-13', '2001-11-13', '40.00', 'Mensile', 0),
  161. (123, 'CVLFCH87H01B516Q', '2015-04-15', '2015-05-15', '40.00', 'Mensile', 0),
  162. (123, 'MRCZYT78T05Z613A', '2001-11-18', '2001-12-18', '40.00', 'Mensile', 0),
  163. (124, 'MRCZYT78T05Z613A', '2001-12-22', '2002-01-22', '40.00', 'Mensile', 0),
  164. (125, 'CVLFCH87H01B516Q', '2016-05-22', '2017-05-22', '330.00', 'Annuale', 1),
  165. (125, 'MRCZYT78T05Z613A', '2002-04-25', '2002-07-25', '95.00', 'Trimestrale', 0),
  166. (126, 'CVLFCH87H01B516Q', '2016-05-26', '2016-06-26', '40.00', 'Mensile', 0),
  167. (126, 'MRCZYT78T05Z613A', '2002-07-26', '2002-10-26', '95.00', 'Trimestrale', 0),
  168. (127, 'FRNTLD01R13M145T', '2005-05-07', '2005-08-07', '95.00', 'Trimestrale', 0),
  169. (127, 'MRCZYT78T05Z613A', '2002-10-27', '2003-01-27', '104.50', 'Trimestrale', 1),
  170. (128, 'FRNTLD01R13M145T', '2005-08-08', '2005-11-08', '95.00', 'Trimestrale', 0),
  171. (128, 'MRCZYT78T05Z613A', '2003-01-28', '2003-04-28', '95.00', 'Trimestrale', 0),
  172. (129, 'FRNTLD01R13M145T', '2005-11-09', '2006-02-09', '104.50', 'Trimestrale', 1),
  173. (129, 'MRCZYT78T05Z613A', '2003-02-03', '2004-02-03', '300.00', 'Annuale', 0),
  174. (130, 'FRNTLD01R13M145T', '2006-02-11', '2006-05-11', '95.00', 'Trimestrale', 0),
  175. (131, 'FRNTLD01R13M145T', '2006-05-15', '2006-08-15', '95.00', 'Trimestrale', 0),
  176. (132, 'FRNTLD01R13M145T', '2006-06-22', '2006-09-22', '95.00', 'Trimestrale', 0),
  177. (133, 'FRNTLD01R13M145T', '2006-09-26', '2007-09-26', '300.00', 'Annuale', 0),
  178. (134, 'FRNTLD01R13M145T', '2007-10-27', '2008-10-27', '330.00', 'Annuale', 1),
  179. (135, 'FRNTLD01R13M145T', '2008-10-28', '2009-10-28', '300.00', 'Annuale', 0),
  180. (136, 'FRNTLD01R13M145T', '2009-11-01', '2010-11-01', '330.00', 'Annuale', 1),
  181. (137, 'FRNTLD01R13M145T', '2010-11-03', '2011-11-03', '300.00', 'Annuale', 0),
  182. (138, 'FRNTTI76P27H501S', '2016-03-24', '2016-06-24', '95.00', 'Trimestrale', 0),
  183. (138, 'MRCZYT78T05Z613A', '2005-02-15', '2006-02-15', '300.00', 'Annuale', 0),
  184. (139, 'MRCZYT78T05Z613A', '2006-02-16', '2007-02-16', '330.00', 'Annuale', 1),
  185. (140, 'FRNTTI76P27H501S', '2016-06-25', '2016-08-25', '77.00', 'Bimestrale', 1),
  186. (140, 'MRCZYT78T05Z613A', '2007-02-22', '2008-02-22', '300.00', 'Annuale', 0),
  187. (141, 'LCNSLL59C07C540T', '2004-10-26', '2004-11-26', '40.00', 'Mensile', 0),
  188. (141, 'MRCZYT78T05Z613A', '2008-02-23', '2009-02-23', '330.00', 'Annuale', 1),
  189. (142, 'LCNSLL59C07C540T', '2004-11-27', '2005-05-27', '187.00', 'Semestrale', 1),
  190. (142, 'MRCZYT78T05Z613A', '2009-02-24', '2010-02-24', '300.00', 'Annuale', 0),
  191. (143, 'LCNSLL59C07C540T', '2007-09-21', '2007-10-21', '44.00', 'Mensile', 1),
  192. (143, 'MRCZYT78T05Z613A', '2010-02-28', '2011-02-28', '330.00', 'Annuale', 1),
  193. (144, 'LCNSLL59C07C540T', '2007-12-09', '2008-01-09', '44.00', 'Mensile', 1),
  194. (144, 'MRCZYT78T05Z613A', '2011-03-15', '2011-06-15', '95.00', 'Trimestrale', 0),
  195. (145, 'LCNSLL59C07C540T', '2009-06-18', '2009-12-18', '170.00', 'Semestrale', 0),
  196. (145, 'MRCZYT78T05Z613A', '2012-03-22', '2013-03-22', '330.00', 'Annuale', 1),
  197. (146, 'LCNSLL59C07C540T', '2010-10-25', '2010-11-25', '40.00', 'Mensile', 0),
  198. (147, 'LCNSLL59C07C540T', '2011-03-03', '2011-05-03', '70.00', 'Bimestrale', 0),
  199. (148, 'LCNSLL59C07C540T', '2013-01-07', '2013-02-07', '40.00', 'Mensile', 0),
  200. (149, 'LCNSLL59C07C540T', '2014-10-13', '2015-04-13', '170.00', 'Semestrale', 0),
  201. (150, 'LCNSLL59C07C540T', '2015-04-22', '2015-10-22', '187.00', 'Semestrale', 1),
  202. (151, 'LCNSLL59C07C540T', '2015-11-10', '2016-02-10', '104.50', 'Trimestrale', 1),
  203. (152, 'NNGRDJ88E04Z103C', '2010-11-16', '2010-12-16', '44.00', 'Mensile', 1),
  204. (153, 'NNGRDJ88E04Z103C', '2012-04-10', '2012-07-10', '95.00', 'Trimestrale', 0),
  205. (154, 'NNGRDJ88E04Z103C', '2012-10-05', '2013-04-05', '187.00', 'Semestrale', 1),
  206. (155, 'NNGRDJ88E04Z103C', '2013-10-12', '2013-12-12', '77.00', 'Bimestrale', 1),
  207. (156, 'NNGRDJ88E04Z103C', '2014-01-20', '2014-07-20', '187.00', 'Semestrale', 1),
  208. (157, 'NNGRDJ88E04Z103C', '2015-08-02', '2015-10-02', '77.00', 'Bimestrale', 1),
  209. (158, 'NNGRDJ88E04Z103C', '2015-10-03', '2015-12-03', '70.00', 'Bimestrale', 0),
  210. (159, 'NNGRDJ88E04Z103C', '2016-04-29', '2016-06-29', '77.00', 'Bimestrale', 1),
  211. (160, 'TRRFNN84C20Z131G', '2009-07-11', '2009-08-11', '44.00', 'Mensile', 1),
  212. (161, 'TRRFNN84C20Z131G', '2009-09-29', '2009-10-29', '40.00', 'Mensile', 0),
  213. (162, 'TRRFNN84C20Z131G', '2011-04-29', '2011-10-29', '187.00', 'Semestrale', 1),
  214. (163, 'TRRFNN84C20Z131G', '2011-10-30', '2012-10-30', '300.00', 'Annuale', 0),
  215. (164, 'TRRFNN84C20Z131G', '2012-01-22', '2012-04-22', '95.00', 'Trimestrale', 0),
  216. (165, 'TRRFNN84C20Z131G', '2012-06-13', '2012-08-13', '70.00', 'Bimestrale', 0),
  217. (166, 'TRRFNN84C20Z131G', '2012-11-10', '2012-12-10', '44.00', 'Mensile', 1),
  218. (167, 'TRRFNN84C20Z131G', '2014-01-01', '2014-02-01', '44.00', 'Mensile', 1),
  219. (168, 'TRRFNN84C20Z131G', '2014-08-15', '2014-11-15', '104.50', 'Trimestrale', 1),
  220. (169, 'TRRFNN84C20Z131G', '2014-11-21', '2015-11-21', '330.00', 'Annuale', 1),
  221. (170, 'TRRFNN84C20Z131G', '2016-07-08', '2016-09-08', '70.00', 'Bimestrale', 0),
  222. (171, 'CNEJHN77D23F284D', '2010-11-24', '2011-01-24', '70.00', 'Bimestrale', 0),
  223. (172, 'CNEJHN77D23F284D', '2011-08-27', '2012-08-27', '300.00', 'Annuale', 0),
  224. (173, 'CNEJHN77D23F284D', '2012-12-23', '2013-02-23', '77.00', 'Bimestrale', 1),
  225. (174, 'CNEJHN77D23F284D', '2013-03-14', '2013-04-14', '40.00', 'Mensile', 0),
  226. (175, 'CNEJHN77D23F284D', '2013-11-27', '2013-12-27', '40.00', 'Mensile', 0),
  227. (176, 'CNEJHN77D23F284D', '2014-01-26', '2015-01-26', '330.00', 'Annuale', 1),
  228. (177, 'CNEJHN77D23F284D', '2015-02-05', '2015-04-05', '70.00', 'Bimestrale', 0),
  229. (178, 'CNEJHN77D23F284D', '2015-04-28', '2015-07-28', '95.00', 'Trimestrale', 0),
  230. (179, 'CNEJHN77D23F284D', '2015-08-06', '2015-11-06', '95.00', 'Trimestrale', 0),
  231. (180, 'CNEJHN77D23F284D', '2015-12-23', '2016-01-23', '44.00', 'Mensile', 1),
  232. (181, 'CNEJHN77D23F284D', '2016-01-11', '2016-03-11', '70.00', 'Bimestrale', 0),
  233. (182, 'CNEJHN77D23F284D', '2016-03-12', '2016-04-12', '44.00', 'Mensile', 1),
  234. (183, 'CNEJHN77D23F284D', '2016-04-12', '2016-06-12', '77.00', 'Bimestrale', 1),
  235. (184, 'CNEJHN77D23F284D', '2016-06-29', '2017-06-29', '300.00', 'Annuale', 0);
  236.  
  237. --
  238. -- Trigger `abbonamento`
  239. --
  240. DELIMITER $$
  241. CREATE TRIGGER `Abb` BEFORE INSERT ON `abbonamento` FOR EACH ROW BEGIN
  242. IF (NEW.Tipo = "Mensile") THEN
  243. SET NEW.Data_Fine = date_add(New.Data_Inizio, interval 1 month);
  244. SET NEW.Prezzo=40;
  245. ELSEIF (NEW.Tipo = "Bimestrale") THEN
  246. SET NEW.Data_Fine = date_add(New.Data_Inizio, interval 2 month);
  247. SET NEW.Prezzo=70;
  248. ELSEIF (NEW.Tipo = "Trimestrale") THEN
  249. SET NEW.Data_Fine = date_add(New.Data_Inizio, interval 3 month);
  250. SET NEW.Prezzo=95;
  251. ELSEIF (NEW.Tipo = "Semestrale") THEN
  252. SET NEW.Data_Fine = date_add(New.Data_Inizio, interval 6 month);
  253. SET NEW.Prezzo=170;
  254. ELSEIF (NEW.Tipo = "Annuale") THEN
  255. SET NEW.Data_Fine = date_add(New.Data_Inizio, interval 1 year);
  256. SET NEW.Prezzo=300;
  257. END IF;
  258.  
  259. IF (NEW.Sauna = 1) THEN
  260. SET NEW.Prezzo = NEW.Prezzo * 1.1;
  261. END IF;
  262. END
  263. $$
  264. DELIMITER ;
  265.  
  266. -- --------------------------------------------------------
  267.  
  268. --
  269. -- Struttura della tabella `attrezzo`
  270. --
  271.  
  272. CREATE TABLE `attrezzo` (
  273. `ID_Attrezzo` int(3) NOT NULL,
  274. `Nome` varchar(30) NOT NULL,
  275. `Portata_max` decimal(4,1) DEFAULT NULL
  276. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  277.  
  278. --
  279. -- Inserimento dei dati per la tabella `attrezzo`
  280. --
  281.  
  282. INSERT INTO `attrezzo` (`ID_Attrezzo`, `Nome`, `Portata_max`) VALUES
  283. (1, 'Bilanciere', '300.0'),
  284. (2, 'Bilanciere Curvo', '200.0'),
  285. (3, 'Manubrio', '50.0'),
  286. (4, 'Panca Piana', NULL),
  287. (5, 'Panca 30°', NULL),
  288. (6, 'Panca 45°', NULL),
  289. (7, 'Panca 60°', NULL),
  290. (8, 'Panca 90°', NULL),
  291. (9, 'Panca Addominali', NULL),
  292. (10, 'Leg Extension Machine', '120.0'),
  293. (11, 'Leg Press Machine', '500.0'),
  294. (12, 'Standing Leg Curl Machine', '150.0'),
  295. (13, 'Calf Machine', '70.0'),
  296. (14, 'Press Machine', '100.0'),
  297. (15, 'Incline Machine', '120.0'),
  298. (16, 'Cavi', '50.0'),
  299. (17, 'Lat Machine', '100.0'),
  300. (18, 'Pull Down Machine', '200.0'),
  301. (19, 'Row Machine', '200.0'),
  302. (20, 'Abdominal Machine', '100.0'),
  303. (21, 'Adductor Machine', '70.0'),
  304. (22, 'Leg Curl Machine', '120.0'),
  305. (23, 'Hack Squat Machine', '250.0'),
  306. (24, 'Leg Curl Machine', '200.0'),
  307. (25, 'Sbarra', NULL),
  308. (26, 'Pulley Machine', '100.0'),
  309. (27, 'Upper Back Machine', '100.0'),
  310. (28, 'Panca Scott', NULL),
  311. (29, 'M-Station', '70.0');
  312.  
  313. -- --------------------------------------------------------
  314.  
  315. --
  316. -- Struttura della tabella `esercizio`
  317. --
  318.  
  319. CREATE TABLE `esercizio` (
  320. `Nome` varchar(30) NOT NULL,
  321. `Gruppo_Muscolare` enum('pettorali','dorsali','spalle','bicipiti','tricipiti','addominali','gambe','polpacci') NOT NULL
  322. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  323.  
  324. --
  325. -- Inserimento dei dati per la tabella `esercizio`
  326. --
  327.  
  328. INSERT INTO `esercizio` (`Nome`, `Gruppo_Muscolare`) VALUES
  329. ('Abdominal', 'addominali'),
  330. ('Adductor', 'addominali'),
  331. ('Affondi in Movimento', 'gambe'),
  332. ('Affondi Leg Press 45°', 'gambe'),
  333. ('Alzate Laterali', 'spalle'),
  334. ('Alzate su Panca 30°', 'dorsali'),
  335. ('Alzate su Panca 30°', 'spalle'),
  336. ('Calf Rotary', 'polpacci'),
  337. ('Calf su Scalino', 'polpacci'),
  338. ('Cavo Presa Inversa', 'tricipiti'),
  339. ('Croci Panca Orizzontale', 'pettorali'),
  340. ('Crunch', 'addominali'),
  341. ('Crunch Inverso', 'addominali'),
  342. ('Curl Bilanciere Curvo', 'bicipiti'),
  343. ('Curl Concentrato', 'bicipiti'),
  344. ('Curl M-Station', 'bicipiti'),
  345. ('Curl Manubri 60°', 'bicipiti'),
  346. ('Curl Panca Scott', 'bicipiti'),
  347. ('Distensione Schiena', 'dorsali'),
  348. ('Distensioni Gambe', 'gambe'),
  349. ('Estensioni Bilanciere', 'tricipiti'),
  350. ('Hack Squat', 'gambe'),
  351. ('Incline Chest', 'pettorali'),
  352. ('Iperextension', 'dorsali'),
  353. ('Iperextension', 'gambe'),
  354. ('Jumping Jacks', 'gambe'),
  355. ('KickBack', 'tricipiti'),
  356. ('Lat Machine Avanti', 'dorsali'),
  357. ('Lat Machine Avanti', 'bicipiti'),
  358. ('Lat Machine Dietro', 'dorsali'),
  359. ('Lat Machine Dietro', 'bicipiti'),
  360. ('Leg Curl', 'gambe'),
  361. ('Leg Extension', 'gambe'),
  362. ('Leg Press 45°', 'gambe'),
  363. ('Lento Avanti', 'spalle'),
  364. ('Lento Dietro', 'spalle'),
  365. ('Lento Manubri', 'spalle'),
  366. ('M-Station', 'tricipiti'),
  367. ('Manubrio 90°', 'tricipiti'),
  368. ('Manubrio Dietro Testa', 'tricipiti'),
  369. ('Panca Orizzontale', 'pettorali'),
  370. ('Panca Stretta', 'pettorali'),
  371. ('Panca Stretta', 'tricipiti'),
  372. ('Piegamenti sulle Braccia', 'spalle'),
  373. ('Piegamenti sulle Braccia', 'bicipiti'),
  374. ('Plank', 'addominali'),
  375. ('Pull Down', 'dorsali'),
  376. ('Pull Down', 'spalle'),
  377. ('Pull Over', 'dorsali'),
  378. ('Pulley', 'dorsali'),
  379. ('Rematore', 'dorsali'),
  380. ('Rematore Inverso', 'dorsali'),
  381. ('Row', 'dorsali'),
  382. ('Rowing Torso', 'dorsali'),
  383. ('Sbarra', 'dorsali'),
  384. ('Sbarra', 'bicipiti'),
  385. ('Sit Up', 'addominali'),
  386. ('Squat', 'gambe'),
  387. ('Stacchi Da Terra', 'gambe'),
  388. ('Standing Leg Curl', 'gambe'),
  389. ('Tirate al Mento', 'spalle'),
  390. ('Upper Back', 'spalle');
  391.  
  392. -- --------------------------------------------------------
  393.  
  394. --
  395. -- Struttura della tabella `istruttore`
  396. --
  397.  
  398. CREATE TABLE `istruttore` (
  399. `CF` char(16) NOT NULL,
  400. `Nome` varchar(64) NOT NULL,
  401. `Cognome` varchar(64) NOT NULL,
  402. `Sesso` enum('M','F') NOT NULL,
  403. `Data_Nascita` date NOT NULL,
  404. `Certificazione` varchar(50) DEFAULT NULL,
  405. `Stipendio` decimal(7,2) DEFAULT NULL
  406. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  407.  
  408. --
  409. -- Inserimento dei dati per la tabella `istruttore`
  410. --
  411.  
  412. INSERT INTO `istruttore` (`CF`, `Nome`, `Cognome`, `Sesso`, `Data_Nascita`, `Certificazione`, `Stipendio`) VALUES
  413. ('BLLHBR88D22A594H', 'Herbert', 'Ballerina', 'M', '1988-04-22', 'Personal Trainer livello C', '1200.10'),
  414. ('CPTMCC84E07B602T', 'Maccio', 'Capatonda', 'M', '1984-05-07', 'Personal Trainer livello A', '1300.20'),
  415. ('DNNFBB81C23A503W', 'Fabbio', 'Di Ninno', 'M', '1981-03-23', 'Personal Trainer livello B', '1500.00'),
  416. ('PNNNNA82S54G312F', 'Anna', 'Pannocchia', 'F', '1982-11-14', 'Personal Trainer apprendista', '300.00'),
  417. ('PNNPLE65R21L840U', 'Pelo', 'Ponneso', 'M', '1965-10-21', 'Personal Trainer livello A', '1420.50'),
  418. ('RRRSLV79L18H729R', 'Salvo', 'Errori', 'M', '1979-07-18', 'Personal Trainer apprendista', '300.00'),
  419. ('SCMRRT41D22I533B', 'Rupert', 'Sciamenna', 'M', '1941-04-22', 'Personal Trainer livello C', '1200.10'),
  420. ('VDAVIO87P17E378W', 'Ivo', 'Avido', 'M', '1974-09-17', 'Personal Trainer apprendista', '1250.50');
  421.  
  422. -- --------------------------------------------------------
  423.  
  424. --
  425. -- Struttura della tabella `programma`
  426. --
  427.  
  428. CREATE TABLE `programma` (
  429. `Sequenza` int(2) NOT NULL,
  430. `ID_Scheda` int(10) NOT NULL,
  431. `nSerie` int(2) NOT NULL,
  432. `nRipetizioni` int(2) NOT NULL,
  433. `Tempo_Recupero` int(3) DEFAULT NULL,
  434. `Carico` decimal(4,1) DEFAULT '0.0',
  435. `Esercizio` varchar(30) NOT NULL
  436. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  437.  
  438. --
  439. -- Inserimento dei dati per la tabella `programma`
  440. --
  441.  
  442. INSERT INTO `programma` (`Sequenza`, `ID_Scheda`, `nSerie`, `nRipetizioni`, `Tempo_Recupero`, `Carico`, `Esercizio`) VALUES
  443. (1, 1, 1, 12, 120, '0.0', 'Jumping Jacks'),
  444. (1, 2, 1, 8, 30, '0.0', 'Distensioni Schiena'),
  445. (1, 3, 2, 15, 60, '70.0', 'Curl M-Station'),
  446. (1, 3, 4, 4, 15, '50.0', 'Lento Manubri'),
  447. (1, 4, 3, 1, 45, '80.0', 'Panca Orizzontale'),
  448. (1, 5, 3, 2, 45, '0.0', 'Calf su Scalino'),
  449. (1, 6, 2, 5, 30, '27.5', 'Croci Panca Orizzontale'),
  450. (1, 7, 2, 1, 120, '0.0', 'Jumping Jacks'),
  451. (1, 8, 2, 1, 120, '0.0', 'Plank'),
  452. (1, 9, 4, 1, 90, '35.0', 'Alzate su Panca 30°'),
  453. (1, 10, 3, 7, 30, '50.0', 'Alzate su Panca 30°'),
  454. (1, 11, 1, 6, 30, '0.0', 'Piegamenti sulle Braccia'),
  455. (1, 12, 3, 20, 120, '7.5', 'Upper Back'),
  456. (1, 13, 1, 8, 120, '100.0', 'Pulley'),
  457. (1, 14, 2, 2, 30, '95.0', 'Pulley'),
  458. (1, 15, 5, 3, 60, '0.0', 'Piegamenti sulle Braccia'),
  459. (1, 16, 2, 3, 60, '120.0', 'Incline Chest'),
  460. (1, 17, 4, 2, 30, '200.0', 'Row'),
  461. (1, 18, 4, 15, 45, '37.5', 'Rowing Torso'),
  462. (1, 19, 4, 4, 90, '50.0', 'Manubrio Dietro Testa'),
  463. (1, 20, 4, 20, 30, '50.0', 'Croci Panca Orizzontale'),
  464. (1, 21, 4, 10, 60, '50.0', 'Manubrio Dietro Testa'),
  465. (1, 22, 1, 8, 15, '155.0', 'Tirate al Mento'),
  466. (1, 26, 4, 15, 90, '65.0', 'Standing Leg Curl'),
  467. (1, 27, 3, 7, 60, '0.0', 'Distensioni Schiena'),
  468. (1, 28, 5, 1, 30, '47.5', 'Squat'),
  469. (1, 29, 4, 7, 60, '95.0', 'Leg Extension'),
  470. (1, 30, 3, 3, 30, '32.5', 'Rematore Inverso'),
  471. (1, 31, 3, 7, 60, '100.0', 'Abdominal'),
  472. (1, 32, 2, 6, 90, '22.5', 'Lento Manubri'),
  473. (1, 33, 3, 12, 90, '70.0', 'Adductor'),
  474. (1, 34, 3, 5, 120, '40.0', 'Pull Down'),
  475. (1, 35, 1, 8, 60, '42.5', 'Manubrio 90°'),
  476. (1, 36, 2, 5, 45, '42.5', 'M-Station'),
  477. (1, 37, 3, 20, 45, '50.0', 'Curl Manubri 60°'),
  478. (1, 38, 5, 1, 45, '200.0', 'Row'),
  479. (1, 40, 2, 15, 120, '50.0', 'Alzate su Panca 30°'),
  480. (1, 41, 4, 6, 120, '0.0', 'Piegamenti sulle Braccia'),
  481. (1, 42, 2, 8, 30, '70.0', 'Adductor'),
  482. (1, 43, 2, 6, 15, '85.0', 'Hack Squat'),
  483. (1, 44, 1, 1, 120, '25.0', 'Lento Avanti'),
  484. (1, 45, 1, 6, 60, '20.0', 'Panca Orizzontale'),
  485. (1, 46, 4, 1, 120, '37.5', 'Estensioni Bilanciere'),
  486. (1, 47, 1, 3, 120, '50.0', 'Rematore'),
  487. (1, 48, 4, 12, 45, '50.0', 'Alzate Laterali'),
  488. (1, 49, 2, 6, 90, '110.0', 'Pull Down'),
  489. (1, 50, 3, 10, 15, '0.0', 'Distensioni Schiena'),
  490. (1, 52, 3, 4, 60, '100.0', 'Pulley'),
  491. (1, 53, 5, 7, 45, '70.0', 'Calf Rotary'),
  492. (1, 54, 5, 8, 30, '40.0', 'Cavo Presa Inversa'),
  493. (1, 54, 3, 5, 45, '0.0', 'Jumping Jacks'),
  494. (1, 55, 4, 10, 30, '50.0', 'Curl Manubri 60°'),
  495. (1, 56, 2, 20, 45, '0.0', 'Plank'),
  496. (1, 57, 3, 3, 90, '50.0', 'Cavo Presa Inversa'),
  497. (1, 58, 3, 8, 45, '0.0', 'Plank'),
  498. (1, 59, 3, 1, 120, '0.0', 'Plank'),
  499. (1, 60, 5, 10, 120, '0.0', 'Plank'),
  500. (1, 61, 4, 20, 15, '50.0', 'Rematore'),
  501. (1, 62, 1, 3, 90, '12.5', 'Upper Back'),
  502. (1, 63, 5, 6, 60, '37.5', 'Cavo Presa Inversa'),
  503. (1, 64, 2, 1, 60, '200.0', 'Curl Bilanciere Curvo'),
  504. (1, 65, 6, 8, 90, '50.0', 'Manubrio Dietro Testa'),
  505. (1, 66, 4, 20, 30, '105.0', 'Rowing Torso'),
  506. (1, 68, 2, 3, 90, '90.0', 'Curl Bilanciere Curvo'),
  507. (1, 69, 7, 2, 60, '37.5', 'Curl M-Station'),
  508. (1, 70, 8, 8, 45, '70.0', 'M-Station'),
  509. (1, 71, 4, 2, 15, '100.0', 'Upper Back'),
  510. (1, 72, 2, 10, 60, '0.0', 'Crunch Inverso'),
  511. (1, 73, 5, 1, 30, '80.0', 'Estensioni Bilanciere'),
  512. (1, 74, 3, 20, 15, '50.0', 'Pull Over'),
  513. (1, 75, 4, 5, 15, '32.5', 'Curl Manubri 60°'),
  514. (1, 76, 2, 6, 120, '50.0', 'KickBack'),
  515. (1, 77, 5, 1, 45, '12.5', 'Abdominal'),
  516. (1, 78, 1, 1, 90, '65.0', 'Panca Orizzontale'),
  517. (1, 79, 2, 2, 90, '45.0', 'Row'),
  518. (1, 80, 4, 3, 15, '70.0', 'Leg Press 45°'),
  519. (1, 81, 1, 7, 120, '150.0', 'Squat'),
  520. (1, 82, 2, 4, 60, '10.0', 'Curl Manubri 60°'),
  521. (1, 83, 1, 3, 90, '75.0', 'Upper Back'),
  522. (1, 84, 5, 1, 45, '65.0', 'Lento Avanti'),
  523. (1, 85, 1, 2, 30, '300.0', 'Lento Dietro'),
  524. (1, 86, 1, 4, 45, '130.0', 'Hack Squat'),
  525. (1, 87, 2, 8, 120, '50.0', 'Alzate Laterali'),
  526. (1, 88, 5, 12, 60, '50.0', 'Curl Manubri 60°'),
  527. (1, 89, 2, 20, 90, '0.0', 'Plank'),
  528. (1, 90, 3, 12, 45, '125.0', 'Curl Panca Scott'),
  529. (1, 90, 5, 1, 45, '100.0', 'Squat'),
  530. (1, 91, 5, 3, 45, '0.0', 'Jumping Jacks'),
  531. (1, 93, 4, 15, 60, '70.0', 'Pulley'),
  532. (1, 94, 6, 3, 60, '60.0', 'Pull Down'),
  533. (1, 95, 5, 2, 120, '32.5', 'Calf Rotary'),
  534. (1, 96, 3, 10, 30, '65.0', 'Row'),
  535. (1, 97, 4, 3, 15, '50.0', 'Croci Panca Orizzontale'),
  536. (1, 98, 1, 1, 90, '50.0', 'Manubrio Dietro Testa'),
  537. (1, 99, 4, 7, 30, '32.5', 'Rowing Torso'),
  538. (1, 100, 4, 7, 15, '17.5', 'Hack Squat'),
  539. (1, 101, 8, 4, 120, '70.0', 'Calf Rotary'),
  540. (1, 102, 5, 5, 60, '15.0', 'Row'),
  541. (1, 103, 12, 12, 15, '50.0', 'KickBack'),
  542. (1, 104, 1, 7, 30, '27.5', 'Alzate su Panca 30°'),
  543. (1, 105, 5, 20, 60, '100.0', 'Pulley'),
  544. (1, 107, 1, 8, 30, '95.0', 'Upper Back'),
  545. (1, 108, 12, 8, 60, '50.0', 'Alzate Laterali'),
  546. (1, 109, 5, 15, 15, '105.0', 'Stacchi Da Terra'),
  547. (1, 110, 2, 7, 15, '37.5', 'Estensioni Bilanciere'),
  548. (1, 111, 2, 1, 45, '140.0', 'Estensioni Bilanciere'),
  549. (1, 112, 3, 10, 90, '50.0', 'Croci Panca Orizzontale'),
  550. (1, 113, 1, 2, 30, '0.0', 'Calf su Scalino'),
  551. (1, 114, 14, 20, 45, '220.0', 'Lento Avanti'),
  552. (1, 115, 4, 7, 15, '40.0', 'Panca Orizzontale'),
  553. (1, 116, 3, 4, 15, '0.0', 'Plank'),
  554. (1, 117, 5, 2, 15, '5.0', 'Leg Curl'),
  555. (1, 118, 4, 5, 90, '50.0', 'Croci Panca Orizzontale'),
  556. (1, 119, 4, 8, 45, '0.0', 'Plank'),
  557. (1, 119, 2, 15, 45, '160.0', 'Rematore Inverso'),
  558. (1, 120, 3, 1, 60, '27.5', 'Upper Back'),
  559. (1, 121, 1, 8, 90, '125.0', 'Lento Dietro'),
  560. (1, 122, 2, 2, 45, '85.0', 'Lat Machine Dietro'),
  561. (1, 122, 4, 2, 30, '47.5', 'Lento Avanti'),
  562. (1, 123, 4, 2, 120, '50.0', 'Croci Panca Orizzontale'),
  563. (1, 124, 3, 6, 30, '100.0', 'Leg Press 45°'),
  564. (1, 125, 1, 6, 120, '15.0', 'Rematore'),
  565. (1, 126, 2, 15, 30, '125.0', 'Curl Panca Scott'),
  566. (1, 127, 5, 15, 30, '100.0', 'Lat Machine Dietro'),
  567. (1, 128, 8, 12, 90, '55.0', 'M-Station'),
  568. (1, 129, 2, 3, 30, '0.0', 'Piegamenti sulle Braccia'),
  569. (1, 130, 2, 6, 45, '50.0', 'Lento Manubri'),
  570. (1, 132, 1, 20, 90, '100.0', 'Abdominal'),
  571. (1, 132, 3, 10, 15, '50.0', 'Alzate su Panca 30°'),
  572. (1, 133, 1, 4, 30, '7.5', 'Abdominal'),
  573. (1, 134, 5, 8, 30, '70.0', 'Calf Rotary'),
  574. (1, 135, 3, 8, 45, '70.0', 'Curl M-Station'),
  575. (1, 136, 2, 6, 15, '50.0', 'Alzate su Panca 30°'),
  576. (1, 136, 1, 6, 90, '140.0', 'Stacchi Da Terra'),
  577. (1, 137, 2, 2, 90, '155.0', 'Panca Orizzontale'),
  578. (1, 138, 1, 7, 60, '90.0', 'Panca Orizzontale'),
  579. (1, 139, 3, 3, 60, '0.0', 'Distensioni Schiena'),
  580. (1, 140, 1, 8, 90, '50.0', 'Alzate su Panca 30°'),
  581. (1, 141, 5, 1, 15, '0.0', 'Plank'),
  582. (1, 142, 1, 20, 90, '50.0', 'Hack Squat'),
  583. (1, 143, 3, 1, 90, '32.5', 'Alzate Laterali'),
  584. (1, 144, 3, 8, 60, '37.5', 'Rematore Inverso'),
  585. (1, 145, 5, 3, 30, '0.0', 'Jumping Jacks'),
  586. (1, 146, 1, 1, 15, '120.0', 'Panca Orizzontale'),
  587. (1, 147, 3, 6, 30, '65.0', 'Pull Down'),
  588. (1, 148, 1, 7, 15, '35.0', 'Alzate su Panca 30°'),
  589. (1, 149, 5, 6, 45, '35.0', 'Leg Curl'),
  590. (1, 151, 1, 20, 90, '100.0', 'Lat Machine Dietro'),
  591. (1, 152, 5, 20, 45, '50.0', 'Manubrio 90°'),
  592. (1, 153, 2, 20, 15, '0.0', 'Calf su Scalino'),
  593. (1, 155, 2, 5, 60, '12.5', 'Leg Extension'),
  594. (1, 156, 1, 3, 15, '0.0', 'Jumping Jacks'),
  595. (1, 157, 1, 7, 30, '95.0', 'Leg Press 45°'),
  596. (1, 158, 2, 15, 15, '50.0', 'Alzate Laterali'),
  597. (1, 159, 5, 3, 15, '300.0', 'Lento Avanti'),
  598. (1, 160, 1, 12, 15, '20.0', 'Curl Manubri 60°'),
  599. (1, 161, 5, 1, 60, '7.5', 'Panca Orizzontale'),
  600. (1, 162, 2, 10, 60, '0.0', 'Distensioni Gambe'),
  601. (1, 163, 4, 3, 60, '65.0', 'Adductor'),
  602. (1, 164, 1, 3, 45, '40.5', 'Rematore Inverso'),
  603. (1, 165, 1, 15, 90, '0.0', 'Jumping Jacks'),
  604. (1, 167, 5, 10, 90, '45.0', 'Calf Rotary'),
  605. (1, 168, 1, 15, 30, '30.0', 'Rematore'),
  606. (1, 169, 4, 4, 120, '50.0', 'Curl Concentrato'),
  607. (1, 170, 3, 6, 30, '100.0', 'Pulley'),
  608. (1, 171, 5, 12, 45, '0.0', 'Distensioni Gambe'),
  609. (1, 172, 4, 15, 120, '50.0', 'Curl Concentrato'),
  610. (1, 174, 3, 1, 30, '65.0', 'Squat'),
  611. (1, 175, 3, 1, 60, '0.0', 'Sbarra'),
  612. (1, 176, 8, 1, 120, '85.0', 'Upper Back'),
  613. (1, 177, 1, 4, 120, '0.0', 'Distensioni Schiena'),
  614. (1, 178, 4, 12, 90, '50.0', 'Curl Concentrato'),
  615. (1, 179, 2, 8, 15, '70.0', 'Leg Press 45°'),
  616. (1, 180, 5, 6, 45, '35.0', 'Curl Bilanciere Curvo'),
  617. (1, 181, 2, 2, 15, '100.0', 'Leg Press 45°'),
  618. (1, 182, 3, 2, 45, '0.0', 'Calf su Scalino'),
  619. (1, 183, 1, 5, 90, '95.0', 'Hack Squat'),
  620. (1, 184, 5, 2, 120, '170.0', 'Lento Dietro'),
  621. (1, 185, 1, 15, 45, '5.0', 'Alzate Laterali'),
  622. (1, 186, 3, 15, 120, '0.0', 'Piegamenti sulle Braccia'),
  623. (1, 187, 5, 2, 15, '0.0', 'Sbarra'),
  624. (1, 188, 4, 5, 30, '0.0', 'Distensioni Gambe'),
  625. (1, 188, 1, 1, 45, '40.0', 'Lento Avanti'),
  626. (1, 189, 5, 2, 120, '0.0', 'Distensioni Gambe'),
  627. (1, 190, 4, 4, 15, '50.0', 'Manubrio Dietro Testa'),
  628. (1, 191, 3, 7, 45, '100.0', 'Pulley'),
  629. (1, 192, 2, 20, 30, '0.0', 'Distensioni Gambe'),
  630. (1, 194, 1, 1, 45, '35.0', 'Lento Avanti'),
  631. (1, 195, 3, 12, 60, '40.0', 'Rematore'),
  632. (1, 197, 5, 10, 90, '37.5', 'Affondi Leg Press 45°'),
  633. (1, 198, 10, 20, 45, '12.5', 'Stacchi Da Terra'),
  634. (1, 200, 10, 6, 60, '50.0', 'Pull Over'),
  635. (1, 201, 4, 1, 45, '75.0', 'Standing Leg Curl'),
  636. (1, 202, 1, 20, 60, '0.0', 'Distensioni Schiena'),
  637. (1, 204, 9, 2, 90, '0.0', 'Sbarra'),
  638. (1, 205, 8, 4, 60, '12.5', 'Hack Squat'),
  639. (1, 206, 1, 2, 60, '32.5', 'Row'),
  640. (2, 3, 1, 5, 15, '25.0', 'Incline Chest'),
  641. (2, 4, 3, 12, 60, '85.0', 'Pull Down'),
  642. (2, 5, 2, 10, 45, '47.5', 'KickBack'),
  643. (2, 6, 3, 20, 30, '25.0', 'Standing Leg Curl'),
  644. (2, 7, 2, 1, 120, '0.0', 'Piegamenti sulle Braccia'),
  645. (2, 8, 2, 1, 120, '0.0', 'Piegamenti sulle Braccia'),
  646. (2, 9, 5, 20, 90, '120.0', 'Incline Chest'),
  647. (2, 10, 5, 8, 120, '100.0', 'Upper Back'),
  648. (2, 11, 3, 5, 90, '170.0', 'Stacchi Da Terra'),
  649. (2, 12, 2, 6, 45, '0.0', 'Distensioni Schiena'),
  650. (2, 13, 3, 8, 60, '0.0', 'Sbarra'),
  651. (2, 14, 2, 1, 60, '50.0', 'KickBack'),
  652. (2, 15, 1, 15, 120, '12.5', 'Stacchi Da Terra'),
  653. (2, 17, 3, 4, 45, '25.0', 'Lat Machine Dietro'),
  654. (2, 18, 1, 6, 120, '0.0', 'Plank'),
  655. (2, 19, 2, 5, 30, '30.0', 'Curl Panca Scott'),
  656. (2, 20, 5, 6, 90, '50.0', 'Alzate su Panca 30°'),
  657. (2, 21, 2, 15, 90, '50.0', 'Curl Concentrato'),
  658. (2, 22, 6, 8, 45, '65.0', 'Rematore Inverso'),
  659. (2, 26, 2, 3, 60, '50.0', 'Cavo Presa Inversa'),
  660. (2, 27, 5, 6, 15, '50.0', 'Manubrio Dietro Testa'),
  661. (2, 28, 5, 5, 120, '220.0', 'Panca Orizzontale'),
  662. (2, 29, 5, 15, 15, '50.0', 'Lento Manubri'),
  663. (2, 30, 3, 2, 120, '10.0', 'Standing Leg Curl'),
  664. (2, 32, 4, 8, 45, '150.0', 'Standing Leg Curl'),
  665. (2, 33, 3, 8, 90, '0.0', 'Sbarra'),
  666. (2, 34, 5, 1, 60, '20.0', 'Lento Avanti'),
  667. (2, 35, 5, 20, 120, '70.0', 'Adductor'),
  668. (2, 36, 2, 1, 15, '20.0', 'Estensioni Bilanciere'),
  669. (2, 36, 2, 6, 120, '105.0', 'Squat'),
  670. (2, 37, 5, 6, 30, '200.0', 'Stacchi Da Terra'),
  671. (2, 38, 1, 12, 45, '65.0', 'Affondi Leg Press 45°'),
  672. (2, 40, 1, 7, 90, '42.5', 'Calf Rotary'),
  673. (2, 40, 5, 3, 60, '45.0', 'Panca Orizzontale'),
  674. (2, 41, 3, 4, 45, '10.0', 'Squat'),
  675. (2, 42, 5, 7, 30, '0.0', 'Distensioni Gambe'),
  676. (2, 42, 5, 1, 60, '22.0', 'Lento Avanti'),
  677. (2, 43, 5, 2, 30, '70.0', 'M-Station'),
  678. (2, 44, 4, 1, 30, '100.0', 'Rematore Inverso'),
  679. (2, 45, 4, 4, 30, '150.0', 'Rematore Inverso'),
  680. (2, 46, 5, 5, 15, '47.5', 'Tirate al Mento'),
  681. (2, 47, 5, 4, 30, '45.0', 'Panca Stretta'),
  682. (2, 48, 5, 2, 90, '120.0', 'Incline Chest'),
  683. (2, 49, 2, 1, 15, '105.0', 'Squat'),
  684. (2, 50, 5, 5, 60, '50.0', 'Croci Panca Orizzontale'),
  685. (2, 52, 2, 8, 45, '70.0', 'Adductor'),
  686. (2, 53, 3, 3, 15, '0.0', 'Sbarra'),
  687. (2, 54, 4, 1, 15, '50.0', 'Stacchi Da Terra'),
  688. (2, 55, 1, 2, 45, '42.5', 'Manubrio 90°'),
  689. (2, 56, 5, 10, 45, '35.0', 'Pull Over'),
  690. (2, 57, 6, 20, 30, '100.0', 'Upper Back'),
  691. (2, 58, 5, 4, 90, '50.0', 'Manubrio Dietro Testa'),
  692. (2, 60, 4, 12, 30, '0.0', 'Sbarra'),
  693. (2, 61, 1, 15, 45, '150.0', 'Standing Leg Curl'),
  694. (2, 62, 5, 7, 30, '130.0', 'Panca Stretta'),
  695. (2, 63, 3, 10, 45, '40.0', 'Cavo Presa Inversa'),
  696. (2, 64, 5, 7, 15, '0.0', 'Jumping Jacks'),
  697. (2, 65, 2, 6, 30, '0.0', 'Distensioni Schiena'),
  698. (2, 68, 4, 5, 120, '0.0', 'Plank'),
  699. (2, 69, 4, 12, 60, '12.5', 'Curl M-Station'),
  700. (2, 70, 1, 2, 120, '50.0', 'Cavo Presa Inversa'),
  701. (2, 70, 1, 4, 30, '30.0', 'Curl Bilanciere Curvo'),
  702. (2, 71, 4, 15, 30, '0.0', 'Distensioni Schiena'),
  703. (2, 72, 4, 1, 15, '50.0', 'Tirate al Mento'),
  704. (2, 73, 2, 7, 60, '32.5', 'Manubrio Dietro Testa'),
  705. (2, 74, 2, 12, 15, '50.0', 'Curl Concentrato'),
  706. (2, 75, 1, 20, 90, '120.0', 'Lento Dietro'),
  707. (2, 76, 1, 7, 60, '42.5', 'Rematore'),
  708. (2, 77, 3, 8, 60, '0.0', 'Sbarra'),
  709. (2, 78, 5, 15, 60, '240.0', 'Panca Stretta'),
  710. (2, 79, 2, 3, 90, '90.0', 'Hack Squat'),
  711. (2, 80, 5, 1, 90, '120.0', 'Panca Orizzontale'),
  712. (2, 81, 5, 12, 120, '0.0', 'Distensioni Schiena'),
  713. (2, 82, 5, 3, 15, '100.0', 'Abdominal'),
  714. (2, 83, 4, 10, 120, '32.5', 'Lento Manubri'),
  715. (2, 84, 1, 5, 15, '260.0', 'Lento Dietro'),
  716. (2, 85, 4, 3, 90, '70.0', 'Calf Rotary'),
  717. (2, 86, 5, 5, 15, '75.0', 'Leg Press 45°'),
  718. (2, 87, 5, 6, 15, '30.0', 'Rowing Torso'),
  719. (2, 88, 3, 10, 90, '155.0', 'Tirate al Mento'),
  720. (2, 89, 3, 6, 15, '0.0', 'Affondi in Movimento'),
  721. (2, 90, 1, 6, 30, '50.0', 'Croci Panca Orizzontale'),
  722. (2, 91, 1, 20, 15, '50.0', 'KickBack'),
  723. (2, 93, 3, 10, 120, '50.0', 'Pull Down'),
  724. (2, 94, 5, 1, 30, '27.5', 'Lento Avanti'),
  725. (2, 95, 4, 2, 45, '22.5', 'Panca Orizzontale'),
  726. (2, 96, 1, 1, 30, '50.0', 'Squat'),
  727. (2, 97, 1, 20, 30, '50.0', 'Curl Concentrato'),
  728. (2, 98, 4, 10, 15, '50.0', 'Croci Panca Orizzontale'),
  729. (2, 99, 1, 8, 15, '27.5', 'Alzate su Panca 30°'),
  730. (2, 100, 3, 6, 45, '70.0', 'Row'),
  731. (2, 101, 2, 4, 15, '7.5', 'Lat Machine Dietro'),
  732. (2, 102, 3, 7, 60, '7.5', 'Rematore'),
  733. (2, 103, 3, 7, 90, '120.0', 'Estensioni Bilanciere'),
  734. (2, 104, 1, 12, 60, '22.5', 'Curl Concentrato'),
  735. (2, 105, 1, 5, 15, '10.0', 'Lento Manubri'),
  736. (2, 107, 4, 15, 120, '45.0', 'Lat Machine Dietro'),
  737. (2, 108, 4, 6, 30, '15.0', 'Curl Concentrato'),
  738. (2, 109, 2, 1, 30, '15.0', 'Pulley'),
  739. (2, 110, 2, 20, 120, '60.0', 'Calf Rotary'),
  740. (2, 110, 4, 10, 45, '120.0', 'Leg Extension'),
  741. (2, 111, 3, 12, 90, '125.0', 'Pull Down'),
  742. (2, 112, 2, 1, 15, '85.0', 'Lat Machine Dietro'),
  743. (2, 113, 2, 7, 90, '17.5', 'Hack Squat'),
  744. (2, 114, 1, 4, 120, '0.0', 'Calf su Scalino'),
  745. (2, 115, 3, 3, 30, '100.0', 'Leg Press 45°'),
  746. (2, 116, 5, 2, 60, '50.0', 'Row'),
  747. (2, 117, 3, 20, 60, '45.0', 'Manubrio 90°'),
  748. (2, 118, 4, 1, 15, '55.0', 'Rowing Torso'),
  749. (2, 119, 1, 6, 15, '200.0', 'Estensioni Bilanciere'),
  750. (2, 120, 4, 12, 15, '50.0', 'Rematore'),
  751. (2, 121, 4, 1, 15, '50.0', 'Panca Stretta'),
  752. (2, 122, 1, 20, 90, '200.0', 'Curl Panca Scott'),
  753. (2, 123, 2, 20, 120, '37.5', 'Alzate su Panca 30°'),
  754. (2, 124, 3, 7, 90, '0.0', 'Piegamenti sulle Braccia'),
  755. (2, 125, 4, 3, 15, '0.0', 'Crunch Inverso'),
  756. (2, 126, 2, 10, 120, '160.0', 'Panca Stretta'),
  757. (2, 127, 5, 4, 120, '37.5', 'Curl M-Station'),
  758. (2, 128, 1, 4, 30, '50.0', 'Curl Manubri 60°'),
  759. (2, 129, 3, 2, 60, '170.0', 'Stacchi Da Terra'),
  760. (2, 130, 1, 1, 90, '0.0', 'Piegamenti sulle Braccia'),
  761. (2, 132, 2, 2, 60, '150.0', 'Pull Down'),
  762. (2, 133, 3, 8, 120, '50.0', 'KickBack'),
  763. (2, 134, 3, 20, 90, '30.0', 'Rematore'),
  764. (2, 135, 1, 1, 15, '40.0', 'Affondi Leg Press 45°'),
  765. (2, 136, 3, 8, 15, '7.5', 'Manubrio Dietro Testa'),
  766. (2, 137, 3, 1, 120, '50.0', 'Manubrio 90°'),
  767. (2, 138, 5, 8, 15, '40.0', 'Manubrio 90°'),
  768. (2, 139, 4, 2, 45, '45.0', 'Manubrio Dietro Testa'),
  769. (2, 140, 1, 20, 45, '50.0', 'Pull Over'),
  770. (2, 141, 2, 20, 30, '200.0', 'Leg Curl'),
  771. (2, 142, 5, 3, 15, '70.0', 'Curl M-Station'),
  772. (2, 143, 4, 20, 90, '50.0', 'Alzate su Panca 30°'),
  773. (2, 144, 1, 1, 15, '0.0', 'Plank'),
  774. (2, 145, 4, 8, 30, '50.0', 'Rematore'),
  775. (2, 146, 4, 1, 120, '55.0', 'Estensioni Bilanciere'),
  776. (2, 147, 4, 5, 15, '50.0', 'KickBack'),
  777. (2, 148, 3, 20, 45, '32.5', 'Leg Press 45°'),
  778. (2, 149, 1, 6, 45, '260.0', 'Affondi Leg Press 45°'),
  779. (2, 151, 1, 4, 90, '0.0', 'Plank'),
  780. (2, 152, 3, 15, 90, '125.0', 'Row'),
  781. (2, 153, 5, 4, 15, '10.0', 'Affondi Leg Press 45°'),
  782. (2, 155, 5, 15, 60, '65.0', 'Leg Curl'),
  783. (2, 156, 5, 1, 30, '95.0', 'Rowing Torso'),
  784. (2, 157, 3, 8, 60, '75.0', 'Standing Leg Curl'),
  785. (2, 158, 2, 5, 60, '75.0', 'Lento Dietro'),
  786. (2, 159, 4, 5, 120, '80.0', 'Affondi Leg Press 45°'),
  787. (2, 160, 5, 1, 30, '5.0', 'Alzate su Panca 30°'),
  788. (2, 161, 6, 1, 45, '47.5', 'Leg Curl'),
  789. (2, 162, 3, 12, 30, '0.0', 'Plank'),
  790. (2, 163, 2, 20, 120, '50.0', 'Lento Manubri'),
  791. (2, 164, 3, 5, 15, '120.0', 'Leg Curl'),
  792. (2, 165, 1, 10, 30, '7.5', 'Curl Manubri 60°'),
  793. (2, 167, 4, 3, 15, '42.5', 'M-Station'),
  794. (2, 168, 4, 15, 45, '22.5', 'Lento Dietro'),
  795. (2, 169, 5, 4, 15, '50.0', 'Cavo Presa Inversa'),
  796. (2, 170, 1, 1, 120, '40.0', 'Estensioni Bilanciere'),
  797. (2, 171, 2, 6, 30, '35.0', 'Alzate su Panca 30°'),
  798. (2, 172, 2, 4, 120, '50.0', 'Alzate su Panca 30°'),
  799. (2, 174, 1, 2, 30, '50.0', 'Manubrio Dietro Testa'),
  800. (2, 175, 1, 7, 30, '0.0', 'Piegamenti sulle Braccia'),
  801. (2, 176, 2, 8, 30, '100.0', 'Pulley'),
  802. (2, 177, 2, 4, 90, '32.5', 'Lento Avanti'),
  803. (2, 178, 3, 1, 120, '22.5', 'Lento Avanti'),
  804. (2, 179, 1, 15, 90, '100.0', 'Leg Curl'),
  805. (2, 180, 5, 20, 30, '0.0', 'Calf su Scalino'),
  806. (2, 181, 1, 4, 30, '160.0', 'Rowing Torso'),
  807. (2, 182, 4, 3, 30, '150.0', 'Standing Leg Curl'),
  808. (2, 183, 4, 7, 30, '17.5', 'Rowing Torso'),
  809. (2, 184, 5, 15, 30, '220.0', 'Lento Avanti'),
  810. (2, 184, 6, 20, 15, '150.0', 'Standing Leg Curl'),
  811. (2, 185, 1, 12, 90, '140.0', 'Row'),
  812. (2, 187, 1, 4, 60, '100.0', 'Abdominal'),
  813. (2, 189, 4, 2, 15, '160.0', 'Leg Curl'),
  814. (2, 190, 3, 7, 120, '60.0', 'Calf Rotary'),
  815. (2, 191, 1, 12, 60, '7.5', 'Panca Stretta'),
  816. (2, 192, 2, 1, 60, '90.0', 'Panca Orizzontale'),
  817. (2, 194, 1, 3, 45, '50.0', 'Lento Manubri'),
  818. (2, 195, 1, 6, 120, '0.0', 'Jumping Jacks'),
  819. (2, 197, 5, 2, 90, '80.0', 'Lat Machine Dietro'),
  820. (2, 198, 8, 7, 45, '50.0', 'Lento Manubri'),
  821. (2, 200, 3, 2, 45, '50.0', 'Rematore'),
  822. (2, 201, 3, 7, 15, '0.0', 'Piegamenti sulle Braccia'),
  823. (2, 202, 2, 15, 30, '50.0', 'Cavo Presa Inversa'),
  824. (2, 204, 2, 3, 120, '25.0', 'Adductor'),
  825. (2, 205, 3, 15, 90, '100.0', 'Abdominal'),
  826. (2, 206, 3, 7, 30, '0.0', 'Sbarra'),
  827. (3, 3, 1, 6, 30, '100.0', 'Upper Back'),
  828. (3, 4, 1, 12, 90, '100.0', 'Pulley'),
  829. (3, 5, 3, 1, 90, '110.0', 'Leg Extension'),
  830. (3, 6, 1, 8, 30, '50.0', 'Lento Manubri'),
  831. (3, 7, 5, 3, 120, '0.0', 'Plank'),
  832. (3, 8, 5, 3, 120, '0.0', 'Jumping Jacks'),
  833. (3, 9, 5, 7, 120, '32.5', 'Pulley'),
  834. (3, 10, 4, 20, 60, '50.0', 'Lento Manubri'),
  835. (3, 11, 3, 1, 45, '32.5', 'Estensioni Bilanciere'),
  836. (3, 11, 3, 5, 45, '12.5', 'M-Station'),
  837. (3, 12, 2, 1, 60, '35.0', 'Pull Over'),
  838. (3, 13, 5, 20, 120, '300.0', 'Tirate al Mento'),
  839. (3, 14, 6, 20, 120, '60.0', 'Pulley'),
  840. (3, 15, 4, 10, 120, '70.0', 'M-Station'),
  841. (3, 18, 9, 15, 45, '100.0', 'Lat Machine Dietro'),
  842. (3, 19, 5, 12, 60, '50.0', 'Pull Over'),
  843. (3, 20, 4, 12, 30, '50.0', 'Alzate Laterali'),
  844. (3, 21, 1, 2, 45, '0.0', 'Plank'),
  845. (3, 22, 3, 2, 90, '17.5', 'Affondi Leg Press 45°'),
  846. (3, 26, 3, 3, 120, '150.0', 'Standing Leg Curl'),
  847. (3, 27, 3, 10, 45, '0.0', 'Calf su Scalino'),
  848. (3, 28, 3, 12, 30, '100.0', 'Lat Machine Dietro'),
  849. (3, 30, 5, 3, 15, '0.0', 'Piegamenti sulle Braccia'),
  850. (3, 32, 3, 4, 60, '17.5', 'Leg Curl'),
  851. (3, 32, 6, 7, 90, '100.0', 'Pulley'),
  852. (3, 33, 6, 7, 120, '95.0', 'Curl Panca Scott'),
  853. (3, 34, 1, 2, 45, '45.0', 'Adductor'),
  854. (3, 35, 2, 15, 45, '70.0', 'M-Station'),
  855. (3, 36, 3, 12, 120, '0.0', 'Sbarra'),
  856. (3, 37, 2, 1, 90, '50.0', 'Pull Over'),
  857. (3, 38, 3, 2, 90, '220.0', 'Rematore Inverso'),
  858. (3, 40, 2, 4, 120, '0.0', 'Jumping Jacks'),
  859. (3, 41, 2, 6, 120, '45.0', 'Alzate su Panca 30°'),
  860. (3, 42, 2, 2, 15, '25.0', 'Row'),
  861. (3, 43, 2, 6, 60, '35.0', 'Lento Avanti'),
  862. (3, 44, 4, 15, 60, '7.5', 'Pull Down'),
  863. (3, 45, 1, 4, 15, '50.0', 'Manubrio 90°'),
  864. (3, 46, 5, 2, 60, '42.5', 'KickBack'),
  865. (3, 47, 1, 10, 30, '120.0', 'Hack Squat'),
  866. (3, 48, 2, 20, 120, '70.0', 'Curl M-Station'),
  867. (3, 49, 3, 10, 90, '120.0', 'Hack Squat'),
  868. (3, 51, 1, 4, 15, '0.0', 'Sbarra'),
  869. (3, 52, 3, 2, 30, '27.5', 'Curl Panca Scott'),
  870. (3, 53, 3, 4, 60, '50.0', 'Curl Manubri 60°'),
  871. (3, 55, 4, 8, 15, '200.0', 'Curl Panca Scott'),
  872. (3, 56, 2, 1, 120, '100.0', 'Leg Press 45°'),
  873. (3, 57, 2, 7, 45, '0.0', 'Calf su Scalino'),
  874. (3, 57, 1, 12, 90, '0.0', 'Plank'),
  875. (3, 58, 2, 10, 120, '50.0', 'Cavo Presa Inversa'),
  876. (3, 60, 2, 6, 15, '50.0', 'Curl Concentrato'),
  877. (3, 61, 1, 4, 60, '50.0', 'Manubrio Dietro Testa'),
  878. (3, 62, 5, 6, 90, '50.0', 'Croci Panca Orizzontale'),
  879. (3, 64, 2, 12, 30, '0.0', 'Affondi in Movimento'),
  880. (3, 65, 2, 15, 60, '0.0', 'Affondi in Movimento'),
  881. (3, 68, 3, 12, 30, '0.0', 'Plank'),
  882. (3, 69, 3, 5, 30, '50.0', 'Manubrio 90°'),
  883. (3, 69, 5, 10, 30, '50.0', 'Pull Over'),
  884. (3, 70, 3, 20, 90, '10.0', 'Affondi Leg Press 45°'),
  885. (3, 71, 1, 4, 45, '50.0', 'Curl Concentrato'),
  886. (3, 72, 4, 8, 45, '45.0', 'Curl Bilanciere Curvo'),
  887. (3, 74, 2, 5, 120, '0.0', 'Affondi in Movimento'),
  888. (3, 74, 4, 4, 90, '55.0', 'Row'),
  889. (3, 75, 3, 3, 60, '240.0', 'Tirate al Mento'),
  890. (3, 76, 1, 1, 60, '180.0', 'Squat'),
  891. (3, 77, 3, 12, 15, '100.0', 'Estensioni Bilanciere'),
  892. (3, 78, 4, 12, 90, '100.0', 'Pulley'),
  893. (3, 79, 6, 8, 15, '100.0', 'Lat Machine Dietro'),
  894. (3, 80, 5, 15, 60, '40.0', 'Curl Panca Scott'),
  895. (3, 81, 5, 2, 120, '70.0', 'Panca Orizzontale'),
  896. (3, 82, 3, 2, 60, '32.5', 'Rowing Torso'),
  897. (3, 83, 7, 10, 120, '32.5', 'Rematore Inverso'),
  898. (3, 84, 1, 7, 15, '80.0', 'Rowing Torso'),
  899. (3, 85, 2, 1, 90, '125.0', 'Rematore Inverso'),
  900. (3, 86, 2, 3, 45, '120.0', 'Leg Extension'),
  901. (3, 87, 1, 20, 120, '80.0', 'Leg Curl'),
  902. (3, 88, 1, 20, 45, '30.0', 'Lat Machine Dietro'),
  903. (3, 89, 2, 8, 30, '20.0', 'Panca Stretta'),
  904. (3, 90, 6, 20, 90, '90.0', 'Stacchi Da Terra'),
  905. (3, 91, 1, 7, 15, '50.0', 'Lento Manubri'),
  906. (3, 91, 1, 10, 45, '110.0', 'Row'),
  907. (3, 93, 2, 10, 15, '12.5', 'Row'),
  908. (3, 94, 3, 4, 45, '170.0', 'Estensioni Bilanciere'),
  909. (3, 96, 2, 8, 60, '90.0', 'Lat Machine Dietro'),
  910. (3, 97, 5, 4, 30, '260.0', 'Lento Dietro'),
  911. (3, 98, 3, 12, 90, '60.0', 'Adductor'),
  912. (3, 99, 2, 20, 60, '100.0', 'Abdominal'),
  913. (3, 100, 4, 8, 30, '140.0', 'Stacchi Da Terra'),
  914. (3, 102, 5, 5, 45, '20.0', 'Curl Bilanciere Curvo'),
  915. (3, 103, 2, 2, 45, '30.0', 'Hack Squat'),
  916. (3, 104, 5, 2, 60, '50.0', 'Cavo Presa Inversa'),
  917. (3, 105, 5, 1, 90, '50.0', 'Curl Manubri 60°'),
  918. (3, 108, 2, 5, 30, '42.5', 'Tirate al Mento'),
  919. (3, 109, 5, 1, 120, '15.0', 'Estensioni Bilanciere'),
  920. (3, 110, 1, 2, 90, '50.0', 'Rematore'),
  921. (3, 111, 6, 2, 45, '5.0', 'Cavo Presa Inversa'),
  922. (3, 112, 1, 1, 60, '20.0', 'Lento Avanti'),
  923. (3, 113, 6, 2, 60, '0.0', 'Crunch Inverso'),
  924. (3, 114, 1, 1, 60, '20.0', 'Tirate al Mento'),
  925. (3, 115, 1, 5, 120, '0.0', 'Jumping Jacks'),
  926. (3, 116, 5, 20, 45, '47.5', 'KickBack'),
  927. (3, 118, 1, 20, 120, '70.0', 'Adductor'),
  928. (3, 119, 4, 6, 120, '35.0', 'Pull Over'),
  929. (3, 120, 4, 7, 120, '0.0', 'Affondi in Movimento'),
  930. (3, 120, 1, 1, 90, '0.0', 'Sbarra'),
  931. (3, 121, 2, 2, 90, '50.0', 'Pull Over'),
  932. (3, 122, 4, 4, 15, '0.0', 'Crunch Inverso'),
  933. (3, 123, 3, 1, 45, '0.0', 'Crunch Inverso'),
  934. (3, 124, 4, 4, 120, '50.0', 'Cavo Presa Inversa'),
  935. (3, 125, 1, 12, 60, '70.0', 'Calf Rotary'),
  936. (3, 126, 4, 8, 90, '40.0', 'Cavo Presa Inversa'),
  937. (3, 127, 3, 4, 45, '10.0', 'Manubrio 90°'),
  938. (3, 128, 1, 10, 45, '50.0', 'KickBack'),
  939. (3, 129, 2, 12, 30, '0.0', 'Sbarra'),
  940. (3, 130, 5, 4, 45, '27.5', 'Pull Over'),
  941. (3, 132, 4, 12, 60, '22.5', 'Curl Concentrato'),
  942. (3, 133, 3, 1, 90, '25.0', 'Curl Concentrato'),
  943. (3, 134, 2, 1, 30, '60.0', 'Curl Panca Scott'),
  944. (3, 135, 1, 20, 120, '60.0', 'M-Station'),
  945. (3, 136, 1, 2, 15, '50.0', 'Manubrio 90°'),
  946. (3, 137, 3, 6, 120, '50.0', 'Curl Manubri 60°'),
  947. (3, 138, 2, 1, 90, '30.0', 'Lento Avanti'),
  948. (3, 139, 2, 7, 30, '0.0', 'Calf su Scalino'),
  949. (3, 140, 4, 1, 45, '0.0', 'Calf su Scalino'),
  950. (3, 142, 5, 12, 15, '200.0', 'Rowing Torso'),
  951. (3, 143, 4, 2, 30, '0.0', 'Jumping Jacks'),
  952. (3, 144, 4, 1, 30, '70.0', 'Calf Rotary'),
  953. (3, 145, 5, 1, 30, '15.0', 'Estensioni Bilanciere'),
  954. (3, 146, 4, 1, 120, '200.0', 'Squat'),
  955. (3, 147, 2, 1, 90, '70.0', 'Curl M-Station'),
  956. (3, 148, 3, 5, 90, '50.0', 'Alzate su Panca 30°'),
  957. (3, 149, 4, 10, 15, '80.0', 'Stacchi Da Terra'),
  958. (3, 151, 4, 1, 90, '140.0', 'Panca Orizzontale'),
  959. (3, 152, 2, 10, 15, '150.0', 'Standing Leg Curl'),
  960. (3, 153, 3, 3, 15, '0.0', 'Sbarra'),
  961. (3, 156, 2, 5, 60, '100.0', 'Lat Machine Dietro'),
  962. (3, 157, 5, 4, 60, '70.0', 'Estensioni Bilanciere'),
  963. (3, 159, 4, 6, 90, '70.0', 'Adductor'),
  964. (3, 159, 4, 10, 60, '90.0', 'Leg Curl'),
  965. (3, 161, 4, 3, 90, '35.0', 'Croci Panca Orizzontale'),
  966. (3, 162, 5, 5, 60, '20.0', 'Leg Extension'),
  967. (3, 163, 3, 20, 90, '85.0', 'Rowing Torso'),
  968. (3, 164, 1, 8, 30, '47.5', 'Adductor'),
  969. (3, 165, 2, 4, 30, '0.0', 'Affondi in Movimento'),
  970. (3, 167, 4, 10, 15, '15.0', 'Curl Manubri 60°'),
  971. (3, 168, 4, 20, 45, '50.0', 'Manubrio 90°'),
  972. (3, 169, 3, 4, 90, '50.0', 'Alzate Laterali'),
  973. (3, 170, 3, 6, 120, '0.0', 'Plank'),
  974. (3, 171, 2, 12, 15, '45.0', 'Leg Curl'),
  975. (3, 172, 2, 6, 90, '50.0', 'Curl Concentrato'),
  976. (3, 174, 6, 4, 30, '60.0', 'Rowing Torso'),
  977. (3, 175, 5, 6, 60, '17.5', 'Curl Bilanciere Curvo'),
  978. (3, 176, 2, 3, 120, '80.0', 'Panca Stretta'),
  979. (3, 177, 5, 15, 30, '32.5', 'Rowing Torso'),
  980. (3, 178, 5, 20, 15, '50.0', 'Manubrio Dietro Testa'),
  981. (3, 179, 1, 12, 90, '70.0', 'Squat'),
  982. (3, 180, 5, 10, 30, '17.5', 'Stacchi Da Terra'),
  983. (3, 181, 5, 8, 120, '35.0', 'Rematore'),
  984. (3, 182, 2, 20, 15, '0.0', 'Sbarra'),
  985. (3, 183, 5, 3, 60, '50.0', 'Alzate Laterali'),
  986. (3, 184, 1, 7, 60, '42.5', 'Lento Manubri'),
  987. (3, 185, 3, 8, 60, '50.0', 'Manubrio Dietro Testa'),
  988. (3, 187, 4, 20, 90, '50.0', 'Rematore'),
  989. (3, 189, 4, 2, 30, '50.0', 'Curl Concentrato'),
  990. (3, 190, 5, 1, 30, '20.0', 'Abdominal'),
  991. (3, 191, 3, 15, 30, '200.0', 'Rowing Torso'),
  992. (3, 193, 5, 8, 90, '20.0', 'Abdominal'),
  993. (3, 194, 4, 7, 30, '50.0', 'Rematore'),
  994. (3, 195, 1, 8, 45, '0.0', 'Affondi in Movimento'),
  995. (3, 197, 5, 3, 45, '40.0', 'Hack Squat'),
  996. (3, 198, 5, 10, 120, '50.0', 'Alzate su Panca 30°'),
  997. (3, 200, 5, 2, 90, '5.0', 'Calf Rotary'),
  998. (3, 201, 5, 10, 90, '120.0', 'Incline Chest'),
  999. (3, 203, 3, 1, 30, '50.0', 'Alzate su Panca 30°'),
  1000. (3, 204, 2, 1, 120, '75.5', 'Lento Avanti'),
  1001. (3, 205, 5, 2, 545, '50.0', 'Manubrio Dietro Testa'),
  1002. (3, 206, 3, 4, 45, '55.0', 'Leg Press 45°'),
  1003. (4, 3, 3, 1, 45, '120.0', 'Squat'),
  1004. (4, 4, 3, 15, 15, '35.0', 'Curl Panca Scott'),
  1005. (4, 4, 1, 4, 60, '110.0', 'Rowing Torso'),
  1006. (4, 5, 1, 1, 545, '50.0', 'Manubrio Dietro Testa'),
  1007. (4, 6, 1, 4, 15, '0.0', 'Crunch Inverso'),
  1008. (4, 7, 1, 7, 60, '0.0', 'Affondi in Movimento'),
  1009. (4, 8, 1, 7, 60, '0.0', 'Affondi in Movimento'),
  1010. (4, 9, 2, 5, 60, '0.0', 'Crunch Inverso'),
  1011. (4, 10, 5, 12, 30, '27.5', 'Tirate al Mento'),
  1012. (4, 12, 6, 10, 45, '12.5', 'Manubrio Dietro Testa'),
  1013. (4, 13, 3, 2, 60, '50.0', 'KickBack'),
  1014. (4, 14, 1, 1, 120, '5.0', 'Pull Over'),
  1015. (4, 15, 1, 15, 45, '100.0', 'Leg Press 45°'),
  1016. (4, 18, 5, 4, 15, '150.0', 'Affondi Leg Press 45°'),
  1017. (4, 19, 2, 12, 60, '5.0', 'Alzate su Panca 30°'),
  1018. (4, 21, 4, 8, 45, '0.0', 'Distensioni Schiena'),
  1019. (4, 22, 1, 15, 60, '85.0', 'Affondi Leg Press 45°'),
  1020. (4, 22, 5, 3, 60, '250.0', 'Hack Squat'),
  1021. (4, 26, 6, 3, 60, '155.0', 'Pull Down'),
  1022. (4, 32, 8, 1, 30, '50.0', 'Squat'),
  1023. (4, 34, 1, 20, 60, '50.0', 'Abdominal'),
  1024. (4, 35, 4, 5, 60, '200.0', 'Tirate al Mento'),
  1025. (4, 36, 5, 15, 30, '50.0', 'Rematore'),
  1026. (4, 41, 3, 3, 45, '20.0', 'Leg Curl'),
  1027. (4, 42, 4, 15, 90, '35.0', 'Incline Chest'),
  1028. (4, 43, 1, 20, 60, '80.0', 'Hack Squat'),
  1029. (4, 45, 5, 6, 60, '70.0', 'Upper Back'),
  1030. (4, 46, 2, 7, 30, '50.0', 'Pull Over'),
  1031. (4, 47, 1, 10, 30, '42.5', 'Alzate su Panca 30°'),
  1032. (4, 48, 4, 10, 120, '160.0', 'Row'),
  1033. (4, 49, 2, 1, 15, '70.0', 'Panca Orizzontale'),
  1034. (4, 51, 5, 4, 90, '75.0', 'Lento Avanti'),
  1035. (4, 52, 5, 12, 30, '42.5', 'KickBack'),
  1036. (4, 56, 3, 10, 60, '200.0', 'Lento Dietro'),
  1037. (4, 58, 4, 20, 90, '70.0', 'M-Station'),
  1038. (4, 60, 4, 4, 30, '70.0', 'Calf Rotary'),
  1039. (4, 62, 1, 10, 60, '100.0', 'Lat Machine Dietro'),
  1040. (4, 64, 3, 5, 30, '50.0', 'Rematore'),
  1041. (4, 68, 1, 3, 15, '0.0', 'Crunch Inverso'),
  1042. (4, 69, 3, 3, 45, '60.0', 'Curl M-Station'),
  1043. (4, 70, 5, 15, 120, '50.0', 'Pull Over'),
  1044. (4, 71, 1, 3, 60, '37.5', 'Leg Press 45°'),
  1045. (4, 72, 1, 12, 15, '50.0', 'Curl Concentrato'),
  1046. (4, 75, 3, 5, 15, '70.0', 'Adductor'),
  1047. (4, 76, 1, 1, 60, '122.5', 'Lento Avanti'),
  1048. (4, 77, 2, 4, 60, '15.0', 'Lento Dietro'),
  1049. (4, 78, 2, 8, 45, '0.0', 'Piegamenti sulle Braccia'),
  1050. (4, 80, 3, 6, 90, '50.0', 'Alzate su Panca 30°'),
  1051. (4, 81, 5, 1, 120, '50.0', 'Panca Orizzontale'),
  1052. (4, 81, 4, 1, 45, '50.0', 'Pulley'),
  1053. (4, 82, 2, 3, 15, '45.0', 'Pulley'),
  1054. (4, 83, 5, 15, 90, '50.0', 'Croci Panca Orizzontale'),
  1055. (4, 84, 3, 12, 90, '45.0', 'Standing Leg Curl'),
  1056. (4, 85, 4, 8, 120, '0.0', 'Affondi in Movimento'),
  1057. (4, 86, 1, 3, 120, '15.0', 'Curl Panca Scott'),
  1058. (4, 87, 4, 12, 30, '17.5', 'Panca Stretta'),
  1059. (4, 89, 4, 6, 30, '250.0', 'Hack Squat'),
  1060. (4, 90, 5, 3, 60, '45.0', 'Tirate al Mento'),
  1061. (4, 93, 4, 3, 45, '50.0', 'Lento Manubri'),
  1062. (4, 94, 3, 8, 15, '20.0', 'Lento Manubri'),
  1063. (4, 96, 4, 6, 90, '95.0', 'Curl Panca Scott'),
  1064. (4, 97, 2, 20, 90, '100.0', 'Upper Back'),
  1065. (4, 98, 1, 7, 45, '50.0', 'Cavo Presa Inversa'),
  1066. (4, 99, 1, 5, 90, '220.0', 'Affondi Leg Press 45°'),
  1067. (4, 100, 2, 5, 90, '40.0', 'Standing Leg Curl'),
  1068. (4, 102, 3, 15, 45, '70.0', 'Adductor'),
  1069. (4, 104, 5, 20, 120, '50.0', 'Manubrio Dietro Testa'),
  1070. (4, 104, 5, 1, 120, '260.0', 'Tirate al Mento'),
  1071. (4, 106, 1, 15, 90, '47.5', 'Adductor'),
  1072. (4, 109, 3, 6, 30, '140.0', 'Affondi Leg Press 45°'),
  1073. (4, 111, 6, 3, 90, '70.0', 'Calf Rotary'),
  1074. (4, 112, 3, 5, 90, '0.0', 'Calf su Scalino'),
  1075. (4, 113, 3, 20, 60, '0.0', 'Piegamenti sulle Braccia'),
  1076. (4, 118, 3, 7, 60, '70.0', 'Calf Rotary'),
  1077. (4, 119, 3, 1, 90, '105.0', 'Rowing Torso'),
  1078. (4, 121, 5, 12, 120, '0.0', 'Plank'),
  1079. (4, 122, 4, 6, 120, '100.0', 'Pull Down'),
  1080. (4, 123, 2, 3, 90, '15.0', 'Row'),
  1081. (4, 124, 3, 5, 30, '65.0', 'Hack Squat'),
  1082. (4, 125, 3, 15, 120, '37.5', 'Upper Back'),
  1083. (4, 126, 1, 10, 15, '0.0', 'Sbarra'),
  1084. (4, 127, 5, 1, 90, '7.5', 'Manubrio Dietro Testa'),
  1085. (4, 128, 4, 15, 45, '130.0', 'Rematore Inverso'),
  1086. (4, 131, 5, 4, 60, '40.0', 'Incline Chest'),
  1087. (4, 132, 3, 7, 45, '42.5', 'Pull Over'),
  1088. (4, 133, 2, 6, 60, '80.0', 'Leg Extension'),
  1089. (4, 134, 4, 5, 30, '47.5', 'Standing Leg Curl'),
  1090. (4, 135, 4, 1, 45, '50.0', 'Manubrio Dietro Testa'),
  1091. (4, 136, 2, 10, 30, '100.0', 'Upper Back'),
  1092. (4, 137, 5, 2, 120, '17.5', 'Alzate su Panca 30°'),
  1093. (4, 139, 1, 1, 90, '12.5', 'Alzate su Panca 30°'),
  1094. (4, 140, 4, 10, 60, '155.0', 'Rematore Inverso'),
  1095. (4, 142, 2, 10, 90, '200.0', 'Curl Bilanciere Curvo'),
  1096. (4, 143, 5, 4, 90, '17.5', 'Leg Extension'),
  1097. (4, 144, 1, 1, 15, '17.5', 'Affondi Leg Press 45°'),
  1098. (4, 144, 2, 4, 15, '50.0', 'Pull Over'),
  1099. (4, 147, 4, 4, 90, '50.0', 'Manubrio 90°'),
  1100. (4, 148, 5, 7, 90, '10.0', 'Affondi Leg Press 45°'),
  1101. (4, 149, 6, 1, 60, '0.0', 'Jumping Jacks'),
  1102. (4, 151, 4, 4, 45, '50.0', 'Manubrio 90°'),
  1103. (4, 152, 3, 4, 30, '50.0', 'KickBack'),
  1104. (4, 159, 3, 7, 15, '105.0', 'Hack Squat'),
  1105. (4, 161, 1, 20, 90, '100.0', 'Abdominal'),
  1106. (4, 162, 1, 7, 15, '50.0', 'Cavo Presa Inversa'),
  1107. (4, 163, 3, 1, 15, '17.5', 'Estensioni Bilanciere'),
  1108. (4, 164, 4, 4, 90, '75.0', 'Estensioni Bilanciere'),
  1109. (4, 165, 5, 7, 90, '32.5', 'Manubrio 90°'),
  1110. (4, 167, 4, 4, 15, '0.0', 'Affondi in Movimento'),
  1111. (4, 168, 3, 7, 120, '0.0', 'Plank'),
  1112. (4, 169, 2, 20, 90, '10.0', 'Incline Chest'),
  1113. (4, 170, 7, 10, 90, '240.0', 'Hack Squat'),
  1114. (4, 171, 2, 6, 45, '55.0', 'M-Station'),
  1115. (4, 171, 6, 10, 60, '50.0', 'Manubrio Dietro Testa'),
  1116. (4, 173, 3, 15, 30, '0.0', 'Plank'),
  1117. (4, 174, 5, 10, 30, '12.5', 'Incline Chest'),
  1118. (4, 175, 6, 6, 60, '22.5', 'Standing Leg Curl'),
  1119. (4, 176, 2, 1, 15, '95.0', 'Lat Machine Dietro'),
  1120. (4, 177, 3, 7, 60, '100.0', 'Tirate al Mento'),
  1121. (4, 178, 7, 3, 30, '85.0', 'Hack Squat'),
  1122. (4, 179, 2, 15, 45, '40.0', 'Hack Squat'),
  1123. (4, 180, 5, 8, 15, '0.0', 'Jumping Jacks'),
  1124. (4, 181, 4, 12, 45, '60.0', 'Lento Avanti'),
  1125. (4, 182, 3, 8, 30, '25.0', 'M-Station'),
  1126. (4, 183, 3, 15, 30, '12.5', 'Leg Curl'),
  1127. (4, 184, 4, 7, 30, '75.0', 'Affondi Leg Press 45°'),
  1128. (4, 189, 2, 8, 60, '240.0', 'Rematore Inverso'),
  1129. (4, 190, 1, 6, 15, '0.0', 'Affondi in Movimento'),
  1130. (4, 191, 5, 2, 45, '70.0', 'Lento Dietro'),
  1131. (4, 193, 7, 1, 45, '25.0', 'Curl Concentrato'),
  1132. (4, 194, 5, 6, 60, '10.0', 'Curl Concentrato'),
  1133. (4, 195, 5, 8, 30, '55.0', 'Leg Press 45°'),
  1134. (4, 199, 4, 3, 45, '15.0', 'Leg Extension'),
  1135. (4, 203, 6, 4, 90, '100.0', 'Upper Back'),
  1136. (4, 204, 2, 1, 120, '240.0', 'Squat'),
  1137. (4, 206, 2, 1, 120, '60.0', 'Estensioni Bilanciere'),
  1138. (5, 4, 1, 15, 120, '70.0', 'M-Station'),
  1139. (5, 5, 1, 10, 90, '0.0', 'Sbarra'),
  1140. (5, 6, 3, 12, 45, '20.0', 'Row'),
  1141. (5, 9, 5, 7, 120, '0.0', 'Crunch Inverso'),
  1142. (5, 10, 5, 1, 30, '50.0', 'Lento Avanti'),
  1143. (5, 12, 5, 2, 60, '32.5', 'Lento Manubri'),
  1144. (5, 13, 2, 15, 15, '47.5', 'Alzate Laterali'),
  1145. (5, 15, 3, 6, 15, '42.5', 'Rematore'),
  1146. (5, 18, 3, 2, 60, '30.0', 'Pull Over'),
  1147. (5, 19, 1, 15, 60, '125.0', 'Leg Curl'),
  1148. (5, 22, 4, 8, 120, '0.0', 'Affondi in Movimento'),
  1149. (5, 32, 1, 10, 45, '200.0', 'Leg Curl'),
  1150. (5, 34, 5, 15, 120, '50.0', 'Manubrio Dietro Testa'),
  1151. (5, 42, 2, 12, 30, '85.0', 'Abdominal'),
  1152. (5, 43, 3, 10, 120, '160.0', 'Pull Down'),
  1153. (5, 45, 4, 8, 60, '65.0', 'Affondi Leg Press 45°'),
  1154. (5, 47, 3, 2, 90, '0.0', 'Sbarra'),
  1155. (5, 51, 2, 1, 30, '70.0', 'Adductor'),
  1156. (5, 51, 2, 12, 120, '0.0', 'Affondi in Movimento'),
  1157. (5, 52, 3, 6, 60, '10.0', 'Curl Manubri 60°'),
  1158. (5, 58, 2, 5, 90, '30.0', 'Pulley'),
  1159. (5, 60, 5, 6, 90, '155.0', 'Curl Bilanciere Curvo'),
  1160. (5, 62, 3, 12, 120, '30.0', 'Adductor'),
  1161. (5, 64, 1, 5, 60, '50.0', 'Pulley'),
  1162. (5, 69, 2, 1, 45, '70.0', 'Adductor'),
  1163. (5, 70, 3, 10, 545, '50.0', 'Cavo Presa Inversa'),
  1164. (5, 72, 3, 7, 45, '50.0', 'Alzate su Panca 30°'),
  1165. (5, 72, 4, 4, 120, '85.0', 'Upper Back'),
  1166. (5, 75, 2, 12, 30, '50.0', 'Croci Panca Orizzontale'),
  1167. (5, 77, 1, 12, 30, '22.5', 'Leg Press 45°'),
  1168. (5, 78, 5, 20, 90, '15.0', 'Cavo Presa Inversa'),
  1169. (5, 80, 3, 2, 30, '75.0', 'Panca Stretta'),
  1170. (5, 81, 5, 3, 15, '50.0', 'Croci Panca Orizzontale'),
  1171. (5, 82, 1, 10, 90, '50.0', 'Manubrio Dietro Testa'),
  1172. (5, 83, 4, 20, 90, '200.0', 'Curl Bilanciere Curvo'),
  1173. (5, 83, 5, 15, 15, '100.0', 'Lat Machine Dietro'),
  1174. (5, 84, 5, 6, 15, '0.0', 'Sbarra'),
  1175. (5, 85, 1, 1, 120, '35.0', 'Lento Avanti'),
  1176. (5, 87, 5, 1, 45, '100.0', 'Squat'),
  1177. (5, 90, 4, 20, 60, '7.5', 'KickBack'),
  1178. (5, 93, 2, 6, 60, '50.0', 'Cavo Presa Inversa'),
  1179. (5, 94, 1, 3, 90, '50.0', 'KickBack'),
  1180. (5, 96, 5, 15, 120, '40.0', 'Hack Squat'),
  1181. (5, 96, 2, 2, 45, '50.0', 'KickBack'),
  1182. (5, 98, 4, 5, 15, '10.0', 'Curl Panca Scott'),
  1183. (5, 100, 3, 2, 120, '150.0', 'Lento Avanti'),
  1184. (5, 102, 1, 1, 30, '0.0', 'Plank'),
  1185. (5, 104, 5, 4, 120, '17.5', 'Croci Panca Orizzontale'),
  1186. (5, 106, 3, 8, 30, '0.0', 'Distensioni Gambe'),
  1187. (5, 109, 1, 12, 30, '25.0', 'M-Station'),
  1188. (5, 111, 3, 20, 120, '20.0', 'Cavo Presa Inversa'),
  1189. (5, 112, 1, 5, 60, '50.0', 'Lento Manubri'),
  1190. (5, 113, 5, 8, 15, '20.0', 'Curl Concentrato'),
  1191. (5, 119, 6, 4, 60, '27.5', 'Manubrio 90°'),
  1192. (5, 121, 1, 1, 60, '45.0', 'Curl Panca Scott'),
  1193. (5, 122, 3, 5, 45, '120.0', 'Row'),
  1194. (5, 123, 2, 20, 15, '35.0', 'Croci Panca Orizzontale'),
  1195. (5, 123, 1, 10, 15, '27.5', 'Lento Manubri'),
  1196. (5, 124, 2, 6, 90, '50.0', 'Rematore Inverso'),
  1197. (5, 126, 1, 10, 120, '22.5', 'Curl Manubri 60°'),
  1198. (5, 128, 1, 7, 45, '0.0', 'Crunch Inverso'),
  1199. (5, 131, 2, 10, 15, '50.0', 'Upper Back'),
  1200. (5, 132, 5, 2, 60, '35.0', 'Cavo Presa Inversa'),
  1201. (5, 133, 3, 3, 90, '0.0', 'Crunch Inverso'),
  1202. (5, 134, 5, 7, 45, '50.0', 'Pull Over'),
  1203. (5, 135, 4, 15, 90, '50.0', 'Cavo Presa Inversa'),
  1204. (5, 136, 2, 10, 60, '45.0', 'Adductor'),
  1205. (5, 137, 2, 12, 120, '0.0', 'Crunch Inverso'),
  1206. (5, 139, 3, 1, 60, '20.0', 'Estensioni Bilanciere'),
  1207. (5, 140, 4, 20, 15, '50.0', 'KickBack'),
  1208. (5, 143, 3, 15, 120, '70.0', 'M-Station'),
  1209. (5, 144, 5, 7, 90, '0.0', 'Crunch Inverso'),
  1210. (5, 147, 2, 1, 45, '60.0', 'Lento Avanti'),
  1211. (5, 149, 1, 1, 60, '50.0', 'KickBack'),
  1212. (5, 152, 6, 20, 15, '20.0', 'Alzate Laterali'),
  1213. (5, 159, 2, 2, 45, '120.0', 'Squat'),
  1214. (5, 161, 5, 15, 90, '50.0', 'Alzate Laterali'),
  1215. (5, 162, 2, 7, 15, '0.0', 'Distensioni Schiena'),
  1216. (5, 163, 4, 20, 60, '95.0', 'Rowing Torso'),
  1217. (5, 165, 1, 10, 120, '17.5', 'Pull Over'),
  1218. (5, 168, 5, 6, 120, '100.0', 'Lento Dietro'),
  1219. (5, 169, 6, 6, 15, '0.0', 'Crunch Inverso'),
  1220. (5, 169, 1, 1, 120, '90.0', 'Panca Orizzontale'),
  1221. (5, 170, 5, 1, 90, '0.0', 'Jumping Jacks'),
  1222. (5, 171, 5, 8, 30, '70.0', 'Adductor'),
  1223. (5, 173, 3, 1, 30, '60.0', 'Panca Orizzontale'),
  1224. (5, 173, 3, 1, 30, '280.0', 'Squat'),
  1225. (5, 174, 1, 5, 45, '300.0', 'Lento Avanti'),
  1226. (5, 175, 5, 1, 45, '45.0', 'Curl Bilanciere Curvo'),
  1227. (5, 176, 2, 1, 1, '95.0', 'Estensioni Bilanciere'),
  1228. (5, 177, 4, 1, 30, '70.0', 'Squat'),
  1229. (5, 178, 1, 3, 15, '100.0', 'Affondi Leg Press 45°'),
  1230. (5, 180, 2, 8, 45, '35.0', 'Leg Curl'),
  1231. (5, 180, 7, 7, 90, '95.0', 'Tirate al Mento'),
  1232. (5, 182, 2, 3, 60, '100.0', 'Lat Machine Dietro'),
  1233. (5, 183, 2, 1, 45, '27.5', 'Panca Orizzontale'),
  1234. (5, 184, 4, 1, 45, '25.0', 'Estensioni Bilanciere'),
  1235. (5, 189, 2, 7, 120, '50.0', 'Croci Panca Orizzontale'),
  1236. (5, 190, 5, 6, 45, '40.0', 'Pull Down'),
  1237. (5, 191, 3, 3, 60, '50.0', 'Curl Manubri 60°'),
  1238. (5, 193, 2, 1, 45, '80.0', 'Leg Press 45°'),
  1239. (5, 194, 5, 1, 60, '150.0', 'Squat'),
  1240. (5, 196, 2, 2, 15, '70.0', 'Calf Rotary'),
  1241. (5, 199, 1, 7, 15, '5.0', 'Row'),
  1242. (5, 203, 2, 4, 120, '35.0', 'Curl Manubri 60°'),
  1243. (5, 203, 2, 1, 120, '135.0', 'Panca Orizzontale'),
  1244. (6, 4, 2, 8, 60, '50.0', 'Croci Panca Orizzontale'),
  1245. (6, 19, 3, 10, 120, '0.0', 'Calf su Scalino'),
  1246. (6, 19, 3, 6, 45, '35.0', 'Squat'),
  1247. (6, 32, 1, 5, 90, '155.0', 'Squat'),
  1248. (6, 42, 5, 4, 60, '27.5', 'Alzate su Panca 30°'),
  1249. (6, 45, 4, 2, 60, '22.5', 'Pull Down'),
  1250. (6, 51, 5, 1, 90, '200.0', 'Curl Panca Scott'),
  1251. (6, 52, 4, 10, 90, '20.0', 'Calf Rotary'),
  1252. (6, 62, 2, 15, 60, '27.5', 'Croci Panca Orizzontale'),
  1253. (6, 69, 4, 2, 90, '32.5', 'M-Station'),
  1254. (6, 70, 5, 5, 30, '0.0', 'Plank'),
  1255. (6, 75, 5, 12, 15, '70.0', 'Adductor'),
  1256. (6, 78, 2, 6, 15, '95.0', 'Estensioni Bilanciere'),
  1257. (6, 78, 4, 4, 90, '120.0', 'Leg Extension'),
  1258. (6, 80, 5, 20, 60, '50.0', 'Alzate su Panca 30°'),
  1259. (6, 82, 3, 3, 120, '47.5', 'Incline Chest'),
  1260. (6, 83, 3, 6, 60, '60.0', 'Panca Orizzontale'),
  1261. (6, 84, 5, 4, 30, '0.0', 'Piegamenti sulle Braccia'),
  1262. (6, 90, 4, 2, 45, '0.0', 'Distensioni Schiena'),
  1263. (6, 90, 2, 7, 45, '50.0', 'Manubrio Dietro Testa'),
  1264. (6, 93, 3, 20, 90, '0.0', 'Plank'),
  1265. (6, 96, 6, 5, 30, '170.0', 'Rowing Torso'),
  1266. (6, 98, 5, 5, 120, '5.0', 'Row'),
  1267. (6, 100, 2, 7, 30, '40.0', 'Curl M-Station'),
  1268. (6, 106, 1, 5, 120, '37.5', 'Leg Extension'),
  1269. (6, 111, 2, 7, 120, '32.5', 'Rowing Torso'),
  1270. (6, 112, 5, 1, 15, '25.0', 'Leg Extension'),
  1271. (6, 113, 2, 1, 60, '37.5', 'Panca Orizzontale'),
  1272. (6, 122, 1, 5, 45, '42.5', 'M-Station'),
  1273. (6, 124, 3, 8, 90, '0.0', 'Calf su Scalino'),
  1274. (6, 124, 4, 8, 15, '50.0', 'Curl Manubri 60°'),
  1275. (6, 128, 3, 2, 60, '0.0', 'Distensioni Schiena'),
  1276. (6, 131, 2, 10, 1, '50.0', 'Panca Orizzontale'),
  1277. (6, 132, 2, 15, 90, '0.0', 'Jumping Jacks'),
  1278. (6, 134, 3, 8, 90, '220.0', 'Rematore Inverso'),
  1279. (6, 139, 3, 4, 120, '42.5', 'Lat Machine Dietro'),
  1280. (6, 140, 2, 4, 15, '80.0', 'Leg Press 45°'),
  1281. (6, 143, 2, 10, 60, '15.0', 'Calf Rotary'),
  1282. (6, 144, 1, 2, 60, '125.0', 'Row'),
  1283. (6, 149, 1, 8, 15, '0.0', 'Distensioni Schiena'),
  1284. (6, 152, 5, 6, 45, '200.0', 'Tirate al Mento'),
  1285. (6, 159, 1, 1, 45, '75.0', 'Stacchi Da Terra'),
  1286. (6, 162, 5, 8, 120, '160.0', 'Curl Panca Scott'),
  1287. (6, 163, 1, 15, 30, '90.0', 'Rowing Torso'),
  1288. (6, 165, 5, 7, 30, '50.0', 'Cavo Presa Inversa'),
  1289. (6, 168, 5, 15, 90, '10.0', 'Panca Stretta'),
  1290. (6, 170, 4, 12, 60, '40.0', 'Lento Dietro'),
  1291. (6, 171, 3, 3, 15, '150.0', 'Rowing Torso'),
  1292. (6, 174, 1, 6, 60, '55.0', 'Incline Chest'),
  1293. (6, 175, 2, 12, 30, '5.0', 'Lento Manubri'),
  1294. (6, 177, 3, 6, 90, '0.0', 'Plank'),
  1295. (6, 178, 3, 5, 60, '65.0', 'Curl Panca Scott'),
  1296. (6, 180, 1, 10, 120, '0.0', 'Affondi in Movimento'),
  1297. (6, 182, 4, 3, 120, '0.0', 'Distensioni Gambe'),
  1298. (6, 183, 3, 5, 30, '110.0', 'Lento Dietro'),
  1299. (6, 184, 4, 3, 30, '50.0', 'Pull Over'),
  1300. (6, 189, 1, 2, 120, '45.0', 'Incline Chest'),
  1301. (6, 190, 4, 10, 60, '17.5', 'Manubrio Dietro Testa'),
  1302. (6, 191, 1, 10, 30, '50.0', 'Manubrio 90°'),
  1303. (6, 193, 5, 4, 45, '70.0', 'Adductor'),
  1304. (6, 196, 4, 15, 60, '42.5', 'Alzate su Panca 30°'),
  1305. (6, 199, 2, 3, 30, '42.5', 'Lento Dietro'),
  1306. (7, 19, 5, 1, 90, '50.0', 'Alzate Laterali'),
  1307. (7, 51, 1, 2, 30, '0.0', 'Piegamenti sulle Braccia'),
  1308. (7, 52, 1, 12, 90, '100.0', 'Panca Stretta'),
  1309. (7, 62, 3, 8, 45, '45.0', 'Curl Manubri 60°'),
  1310. (7, 69, 4, 6, 30, '50.0', 'Alzate su Panca 30°'),
  1311. (7, 70, 5, 10, 90, '50.0', 'Manubrio 90°'),
  1312. (7, 75, 2, 4, 15, '27.5', 'Manubrio Dietro Testa'),
  1313. (7, 78, 2, 2, 90, '95.0', 'Tirate al Mento'),
  1314. (7, 83, 1, 7, 60, '42.5', 'Affondi Leg Press 45°'),
  1315. (7, 90, 6, 7, 120, '120.0', 'Incline Chest'),
  1316. (7, 93, 7, 1, 120, '40.0', 'Tirate al Mento'),
  1317. (7, 96, 2, 12, 60, '42.5', 'Adductor'),
  1318. (7, 106, 4, 3, 15, '50.0', 'Lento Manubri'),
  1319. (7, 112, 4, 6, 15, '10.0', 'Lento Manubri'),
  1320. (7, 112, 3, 5, 15, '85.0', 'Tirate al Mento'),
  1321. (7, 122, 2, 1, 120, '50.0', 'Lento Manubri'),
  1322. (7, 124, 5, 1, 120, '65.0', 'Panca Orizzontale'),
  1323. (7, 128, 4, 1, 45, '50.0', 'Cavo Presa Inversa'),
  1324. (7, 134, 4, 3, 90, '15.0', 'Row'),
  1325. (7, 140, 4, 5, 120, '50.0', 'Manubrio Dietro Testa'),
  1326. (7, 144, 2, 5, 60, '65.0', 'Curl M-Station'),
  1327. (7, 150, 2, 20, 45, '105.0', 'Panca Stretta'),
  1328. (7, 152, 1, 4, 15, '50.0', 'Alzate Laterali'),
  1329. (7, 159, 5, 2, 60, '50.0', 'Kickback'),
  1330. (7, 162, 5, 6, 90, '200.0', 'Row'),
  1331. (7, 168, 2, 20, 90, '7.5', 'Calf Rotary'),
  1332. (7, 171, 5, 4, 90, '0.0', 'Crunch Inverso'),
  1333. (7, 178, 3, 1, 60, '100.0', 'Lento Avanti'),
  1334. (7, 182, 5, 5, 120, '140.0', 'Lento Dietro'),
  1335. (7, 183, 2, 7, 60, '35.0', 'Lento Manubri'),
  1336. (7, 184, 5, 15, 120, '95.0', 'Leg Curl'),
  1337. (7, 190, 5, 20, 120, '40.0', 'Alzate su Panca 30°'),
  1338. (7, 191, 2, 1, 60, '120.0', 'Squat'),
  1339. (7, 193, 3, 5, 120, '0.0', 'Piegamenti sulle Braccia'),
  1340. (7, 196, 3, 8, 45, '50.0', 'Pull Over'),
  1341. (7, 196, 1, 6, 120, '80.0', 'Standing Leg Curl'),
  1342. (7, 199, 3, 20, 60, '50.0', 'Alzate Laterali'),
  1343. (7, 199, 5, 10, 30, '120.0', 'Estensioni Bilanciere'),
  1344. (8, 52, 2, 4, 90, '80.0', 'Pulley'),
  1345. (8, 62, 2, 15, 15, '0.0', 'Distensioni Gambe'),
  1346. (8, 70, 4, 6, 30, '45.0', 'Incline Chest'),
  1347. (8, 75, 4, 7, 120, '105.0', 'Tirate al Mento'),
  1348. (8, 78, 4, 7, 15, '50.0', 'Alzate su Panca 30°'),
  1349. (8, 90, 5, 4, 90, '70.0', 'Adductor'),
  1350. (8, 124, 3, 6, 45, '22.5', 'Pulley'),
  1351. (8, 134, 5, 1, 90, '95.0', 'Lento Avanti'),
  1352. (8, 140, 5, 20, 30, '50.0', 'Alzate su Panca 30°'),
  1353. (8, 150, 1, 6, 120, '85.0', 'Stacchi Da Terra'),
  1354. (8, 171, 1, 20, 60, '42.5', 'Curl M-Station'),
  1355. (8, 182, 1, 20, 120, '0.0', 'Distensioni Gambe'),
  1356. (8, 190, 2, 1, 120, '40.0', 'Abdominal'),
  1357. (8, 193, 3, 20, 45, '150.0', 'Standing Leg Curl'),
  1358. (8, 196, 4, 5, 60, '50.0', 'Alzate Laterali'),
  1359. (8, 199, 3, 4, 545, '50.0', 'KickBack'),
  1360. (9, 75, 1, 20, 45, '32.5', 'M-Station'),
  1361. (9, 90, 4, 5, 30, '50.0', 'Manubrio Dietro Testa'),
  1362. (9, 124, 5, 1, 120, '30.0', 'Lento Avanti'),
  1363. (9, 134, 1, 12, 60, '50.0', 'KickBack'),
  1364. (9, 140, 1, 10, 90, '32.5', 'Stacchi Da Terra'),
  1365. (9, 150, 1, 10, 90, '155.0', 'Rowing Torso'),
  1366. (9, 171, 3, 5, 30, '50.0', 'Manubrio 90°'),
  1367. (9, 182, 3, 15, 60, '70.0', 'Calf Rotary'),
  1368. (9, 190, 3, 4, 90, '0.0', 'Jumping Jacks'),
  1369. (9, 193, 10, 3, 30, '0.0', 'Distensioni Schiena'),
  1370. (9, 196, 5, 15, 45, '110.0', 'Lento Dietro'),
  1371. (10, 75, 1, 1, 60, '150.0', 'Panca Orizzontale'),
  1372. (10, 150, 2, 3, 120, '47.5', 'Estensioni Bilanciere'),
  1373. (10, 171, 2, 20, 45, '0.0', 'Jumping Jacks'),
  1374. (10, 196, 5, 12, 90, '10.0', 'Alzate su Panca 30°'),
  1375. (11, 75, 3, 8, 15, '90.0', 'Row'),
  1376. (11, 150, 4, 6, 90, '0.0', 'Affondi in Movimento'),
  1377. (12, 75, 5, 4, 120, '42.5', 'Pulley');
  1378.  
  1379. --
  1380. -- Trigger `programma`
  1381. --
  1382. DELIMITER $$
  1383. CREATE TRIGGER `Carico` BEFORE INSERT ON `programma` FOR EACH ROW BEGIN
  1384. DECLARE portata int;
  1385. SELECT max(Portata_Max) FROM esercizio AS E,utilizza as U,attrezzo as A WHERE E.Nome=U.Nome_Es
  1386. AND U.Attrezzo=A.ID_Attrezzo AND E.Nome=New.Esercizio INTO portata;
  1387. IF portata IS NOT NULL THEN
  1388. IF (New.Carico>portata) THEN SET New.Carico=portata;
  1389. END IF;
  1390. ELSE SET New.Carico=0;
  1391. END IF;
  1392. END
  1393. $$
  1394. DELIMITER ;
  1395.  
  1396. -- --------------------------------------------------------
  1397.  
  1398. --
  1399. -- Struttura della tabella `scheda`
  1400. --
  1401.  
  1402. CREATE TABLE `scheda` (
  1403. `ID_Scheda` int(10) NOT NULL,
  1404. `Data_Inizio` date NOT NULL,
  1405. `Data_Fine` date NOT NULL,
  1406. `ID_Utente` char(16) NOT NULL,
  1407. `ID_Ist` char(16) NOT NULL
  1408. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1409.  
  1410. --
  1411. -- Inserimento dei dati per la tabella `scheda`
  1412. --
  1413.  
  1414. INSERT INTO `scheda` (`ID_Scheda`, `Data_Inizio`, `Data_Fine`, `ID_Utente`, `ID_Ist`) VALUES
  1415. (1, '2002-05-17', '2002-06-17', 'BGLLDA65T30L407Z', 'PNNPLE65R21L840U'),
  1416. (2, '2003-04-26', '2003-06-16', 'BGLLDA65T30L407Z', 'VDAVIO87P17E378W'),
  1417. (3, '2003-05-09', '2003-07-24', 'BGLLDA65T30L407Z', 'VDAVIO87P17E378W'),
  1418. (4, '2003-11-20', '2004-03-03', 'BGLLDA65T30L407Z', 'CPTMCC84E07B602T'),
  1419. (5, '2006-05-17', '2006-07-09', 'BGLLDA65T30L407Z', 'CPTMCC84E07B602T'),
  1420. (6, '2006-07-13', '2006-12-09', 'BGLLDA65T30L407Z', 'BLLHBR88D22A594H'),
  1421. (7, '2007-08-08', '2007-11-05', 'BGLLDA65T30L407Z', 'PNNPLE65R21L840U'),
  1422. (8, '2008-03-14', '2007-05-28', 'BGLLDA65T30L407Z', 'DNNFBB81C23A503W'),
  1423. (9, '2008-06-03', '2008-11-01', 'BGLLDA65T30L407Z', 'DNNFBB81C23A503W'),
  1424. (10, '2008-12-17', '2009-02-14', 'BGLLDA65T30L407Z', 'SCMRRT41D22I533B'),
  1425. (11, '2009-06-19', '2009-08-07', 'BGLLDA65T30L407Z', 'PNNPLE65R21L840U'),
  1426. (12, '2009-10-10', '2009-12-13', 'BGLLDA65T30L407Z', 'CPTMCC84E07B602T'),
  1427. (13, '2010-04-21', '2010-05-11', 'BGLLDA65T30L407Z', 'CPTMCC84E07B602T'),
  1428. (14, '2010-06-25', '2010-07-12', 'BGLLDA65T30L407Z', 'DNNFBB81C23A503W'),
  1429. (15, '2010-08-22', '2010-12-24', 'BGLLDA65T30L407Z', 'DNNFBB81C23A503W'),
  1430. (16, '2011-01-28', '2011-04-19', 'BGLLDA65T30L407Z', 'PNNPLE65R21L840U'),
  1431. (17, '2012-05-24', '2012-06-13', 'BGLLDA65T30L407Z', 'VDAVIO87P17E378W'),
  1432. (18, '2012-06-28', '2012-04-17', 'BGLLDA65T30L407Z', 'BLLHBR88D22A594H'),
  1433. (19, '2012-07-16', '2012-03-02', 'BGLLDA65T30L407Z', 'DNNFBB81C23A503W'),
  1434. (20, '2013-01-08', '2013-02-15', 'BGLLDA65T30L407Z', 'PNNPLE65R21L840U'),
  1435. (21, '2013-03-10', '2013-05-06', 'BGLLDA65T30L407Z', 'RRRSLV79L18H729R'),
  1436. (22, '2013-06-01', '2013-08-10', 'BGLLDA65T30L407Z', 'CPTMCC84E07B602T'),
  1437. (26, '2009-09-04', '2009-10-10', 'GNDPRT77P67C817K', 'CPTMCC84E07B602T'),
  1438. (27, '2009-10-31', '2010-12-17', 'GNDPRT77P67C817K', 'DNNFBB81C23A503W'),
  1439. (28, '2010-01-25', '2010-03-25', 'GNDPRT77P67C817K', 'CPTMCC84E07B602T'),
  1440. (29, '2010-04-20', '2010-07-22', 'GNDPRT77P67C817K', 'BLLHBR88D22A594H'),
  1441. (30, '2010-09-09', '2010-10-02', 'GNDPRT77P67C817K', 'PNNPLE65R21L840U'),
  1442. (31, '2010-11-03', '2010-12-11', 'GNDPRT77P67C817K', 'VDAVIO87P17E378W'),
  1443. (32, '2011-01-11', '2011-02-25', 'GNDPRT77P67C817K', 'VDAVIO87P17E378W'),
  1444. (33, '2011-03-02', '2011-04-25', 'GNDPRT77P67C817K', 'VDAVIO87P17E378W'),
  1445. (34, '2011-06-10', '2011-10-29', 'GNDPRT77P67C817K', 'DNNFBB81C23A503W'),
  1446. (35, '2011-11-07', '2011-12-09', 'GNDPRT77P67C817K', 'DNNFBB81C23A503W'),
  1447. (36, '2012-04-02', '2012-06-19', 'GNDPRT77P67C817K', 'PNNPLE65R21L840U'),
  1448. (37, '2012-09-18', '2012-11-27', 'GNDPRT77P67C817K', 'PNNPLE65R21L840U'),
  1449. (38, '2013-02-18', '2013-06-04', 'GNDPRT77P67C817K', 'DNNFBB81C23A503W'),
  1450. (39, '2013-07-13', '2013-08-08', 'GNDPRT77P67C817K', 'BLLHBR88D22A594H'),
  1451. (40, '2013-08-19', '2013-09-21', 'GNDPRT77P67C817K', 'SCMRRT41D22I533B'),
  1452. (41, '2013-10-15', '2013-11-24', 'GNDPRT77P67C817K', 'CPTMCC84E07B602T'),
  1453. (42, '2013-11-25', '2013-12-12', 'GNDPRT77P67C817K', 'SCMRRT41D22I533B'),
  1454. (43, '2014-01-09', '2014-03-19', 'GNDPRT77P67C817K', 'RRRSLV79L18H729R'),
  1455. (44, '2014-04-14', '2014-07-05', 'GNDPRT77P67C817K', 'DNNFBB81C23A503W'),
  1456. (45, '2013-08-12', '2013-09-15', 'LRASRM83H63C957B', 'PNNNNA82S54G312F'),
  1457. (46, '2013-10-03', '2013-11-22', 'LRASRM83H63C957B', 'PNNNNA82S54G312F'),
  1458. (47, '2013-12-26', '2014-01-14', 'LRASRM83H63C957B', 'PNNNNA82S54G312F'),
  1459. (48, '2014-01-21', '2014-02-21', 'LRASRM83H63C957B', 'DNNFBB81C23A503W'),
  1460. (49, '2014-03-06', '2014-04-01', 'LRASRM83H63C957B', 'PNNNNA82S54G312F'),
  1461. (50, '2014-04-04', '2014-05-15', 'LRASRM83H63C957B', 'CPTMCC84E07B602T'),
  1462. (51, '2014-05-25', '2014-08-28', 'LRASRM83H63C957B', 'CPTMCC84E07B602T'),
  1463. (52, '2004-06-06', '2004-07-27', 'HRRPTR91S21A663A', 'DNNFBB81C23A503W'),
  1464. (53, '2004-07-28', '2004-08-18', 'HRRPTR91S21A663A', 'PNNPLE65R21L840U'),
  1465. (54, '2004-09-19', '2004-12-11', 'HRRPTR91S21A663A', 'VDAVIO87P17E378W'),
  1466. (55, '2005-01-28', '2005-05-12', 'HRRPTR91S21A663A', 'VDAVIO87P17E378W'),
  1467. (56, '2006-04-11', '2006-07-17', 'HRRPTR91S21A663A', 'DNNFBB81C23A503W'),
  1468. (57, '2007-10-04', '2007-12-08', 'HRRPTR91S21A663A', 'PNNPLE65R21L840U'),
  1469. (58, '2008-01-03', '2008-04-26', 'HRRPTR91S21A663A', 'BLLHBR88D22A594H'),
  1470. (59, '2008-05-01', '2008-07-25', 'HRRPTR91S21A663A', 'RRRSLV79L18H729R'),
  1471. (60, '2008-08-01', '2008-12-02', 'HRRPTR91S21A663A', 'CPTMCC84E07B602T'),
  1472. (61, '2009-01-15', '2009-02-04', 'HRRPTR91S21A663A', 'DNNFBB81C23A503W'),
  1473. (62, '2009-03-29', '2009-06-01', 'HRRPTR91S21A663A', 'PNNPLE65R21L840U'),
  1474. (63, '2009-06-29', '2009-08-06', 'HRRPTR91S21A663A', 'CPTMCC84E07B602T'),
  1475. (64, '2009-09-03', '2009-10-25', 'HRRPTR91S21A663A', 'PNNPLE65R21L840U'),
  1476. (65, '2009-11-18', '2010-01-19', 'HRRPTR91S21A663A', 'RRRSLV79L18H729R'),
  1477. (66, '2010-02-03', '2010-03-18', 'HRRPTR91S21A663A', 'VDAVIO87P17E378W'),
  1478. (67, '2010-04-14', '2010-06-07', 'HRRPTR91S21A663A', 'VDAVIO87P17E378W'),
  1479. (68, '2010-09-09', '2010-12-01', 'HRRPTR91S21A663A', 'DNNFBB81C23A503W'),
  1480. (69, '2011-02-19', '2011-03-23', 'HRRPTR91S21A663A', 'BLLHBR88D22A594H'),
  1481. (70, '2011-04-02', '2011-06-26', 'HRRPTR91S21A663A', 'SCMRRT41D22I533B'),
  1482. (71, '2011-08-08', '2011-09-20', 'HRRPTR91S21A663A', 'PNNPLE65R21L840U'),
  1483. (72, '2013-08-13', '2013-12-02', 'HRRPTR91S21A663A', 'CPTMCC84E07B602T'),
  1484. (73, '2014-01-25', '2014-03-31', 'HRRPTR91S21A663A', 'DNNFBB81C23A503W'),
  1485. (74, '2014-04-09', '2014-09-15', 'HRRPTR91S21A663A', 'BLLHBR88D22A594H'),
  1486. (75, '2014-10-19', '2014-12-12', 'HRRPTR91S21A663A', 'SCMRRT41D22I533B'),
  1487. (76, '2015-04-19', '2015-08-17', 'HRRPTR91S21A663A', 'DNNFBB81C23A503W'),
  1488. (77, '2014-08-03', '2014-09-20', 'GRMSTT32S11H783G', 'RRRSLV79L18H729R'),
  1489. (78, '2014-10-15', '2014-11-15', 'GRMSTT32S11H783G', 'CPTMCC84E07B602T'),
  1490. (79, '2014-12-29', '2015-01-14', 'GRMSTT32S11H783G', 'PNNPLE65R21L840U'),
  1491. (80, '2015-01-31', '2015-02-15', 'GRMSTT32S11H783G', 'VDAVIO87P17E378W'),
  1492. (81, '2015-03-02', '2015-04-16', 'GRMSTT32S11H783G', 'RRRSLV79L18H729R'),
  1493. (82, '2015-06-06', '2015-08-25', 'GRMSTT32S11H783G', 'PNNPLE65R21L840U'),
  1494. (83, '2015-09-23', '2015-10-09', 'GRMSTT32S11H783G', 'DNNFBB81C23A503W'),
  1495. (84, '2015-11-27', '2015-12-13', 'GRMSTT32S11H783G', 'DNNFBB81C23A503W'),
  1496. (85, '2006-05-19', '2007-09-27', 'JJABZV65H15L407I', 'RRRSLV79L18H729R'),
  1497. (86, '2008-03-18', '2008-08-23', 'JJABZV65H15L407I', 'VDAVIO87P17E378W'),
  1498. (87, '2008-11-25', '2010-08-28', 'JJABZV65H15L407I', 'CPTMCC84E07B602T'),
  1499. (88, '2011-08-23', '2011-10-10', 'JJABZV65H15L407I', 'CPTMCC84E07B602T'),
  1500. (89, '2012-08-10', '2013-03-15', 'JJABZV65H15L407I', 'BLLHBR88D22A594H'),
  1501. (90, '2013-04-26', '2013-12-09', 'JJABZV65H15L407I', 'DNNFBB81C23A503W'),
  1502. (91, '2015-03-10', '2015-04-14', 'JJABZV65H15L407I', 'VDAVIO87P17E378W'),
  1503. (92, '2016-01-03', '2016-02-03', 'JJABZV65H15L407I', 'RRRSLV79L18H729R'),
  1504. (93, '2016-04-28', '2010-04-06', 'JJABZV65H15L407I', 'BLLHBR88D22A594H'),
  1505. (94, '2010-09-29', '2010-04-02', 'MRCMDR82A62G224B', 'PNNNNA82S54G312F'),
  1506. (95, '2011-10-28', '2012-09-19', 'MRCMDR82A62G224B', 'PNNNNA82S54G312F'),
  1507. (96, '2013-04-20', '2013-08-05', 'MRCMDR82A62G224B', 'PNNNNA82S54G312F'),
  1508. (97, '2013-11-08', '2013-12-19', 'MRCMDR82A62G224B', 'BLLHBR88D22A594H'),
  1509. (98, '2014-04-11', '2014-07-30', 'MRCMDR82A62G224B', 'PNNNNA82S54G312F'),
  1510. (99, '2015-09-08', '2017-04-05', 'MRCMDR82A62G224B', 'PNNNNA82S54G312F'),
  1511. (100, '2007-07-06', '2007-08-01', 'RMNPWR51R42L407G', 'RRRSLV79L18H729R'),
  1512. (101, '2007-12-29', '2008-10-17', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1513. (102, '2008-11-04', '2009-06-28', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1514. (103, '2009-09-13', '2010-04-03', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1515. (104, '2010-05-05', '2011-08-23', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1516. (105, '2012-05-19', '2012-10-04', 'RMNPWR51R42L407G', 'SCMRRT41D22I533B'),
  1517. (106, '2012-10-15', '2013-10-07', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1518. (107, '2013-10-23', '2013-11-20', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1519. (108, '2013-11-24', '2014-01-28', 'RMNPWR51R42L407G', 'VDAVIO87P17E378W'),
  1520. (109, '2014-02-03', '2014-10-21', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1521. (110, '2015-06-22', '2015-08-28', 'RMNPWR51R42L407G', 'PNNNNA82S54G312F'),
  1522. (111, '2015-11-27', '2016-02-28', 'RMNPWR51R42L407G', 'CPTMCC84E07B602T'),
  1523. (112, '2016-08-20', '2016-12-18', 'RMNPWR51R42L407G', 'SCMRRT41D22I533B'),
  1524. (113, '2012-10-03', '2012-10-19', 'NZETMN96C06G693G', 'RRRSLV79L18H729R'),
  1525. (114, '2012-11-30', '2013-09-13', 'NZETMN96C06G693G', 'DNNFBB81C23A503W'),
  1526. (115, '2013-12-23', '2015-01-12', 'NZETMN96C06G693G', 'CPTMCC84E07B602T'),
  1527. (116, '2015-04-10', '2016-02-09', 'NZETMN96C06G693G', 'DNNFBB81C23A503W'),
  1528. (117, '2010-09-30', '2010-12-18', 'GVNSRT57B20F205R', 'BLLHBR88D22A594H'),
  1529. (118, '2011-03-24', '2012-01-06', 'GVNSRT57B20F205R', 'CPTMCC84E07B602T'),
  1530. (119, '2012-06-07', '2012-07-24', 'GVNSRT57B20F205R', 'BLLHBR88D22A594H'),
  1531. (120, '2012-08-16', '2013-04-29', 'GVNSRT57B20F205R', 'CPTMCC84E07B602T'),
  1532. (121, '2013-07-20', '2013-12-09', 'GVNSRT57B20F205R', 'SCMRRT41D22I533B'),
  1533. (122, '2014-08-12', '2014-09-20', 'GVNSRT57B20F205R', 'VDAVIO87P17E378W'),
  1534. (123, '2015-04-06', '2015-08-20', 'GVNSRT57B20F205R', 'SCMRRT41D22I533B'),
  1535. (124, '2016-01-08', '2016-02-03', 'GVNSRT57B20F205R', 'PNNPLE65R21L840U'),
  1536. (125, '2002-01-28', '2002-10-08', 'KVNVCR74E07C743H', 'RRRSLV79L18H729R'),
  1537. (126, '2003-02-26', '2013-03-03', 'KVNVCR74E07C743H', 'PNNPLE65R21L840U'),
  1538. (127, '2003-06-02', '2003-12-21', 'KVNVCR74E07C743H', 'PNNPLE65R21L840U'),
  1539. (128, '2004-08-19', '2004-11-30', 'KVNVCR74E07C743H', 'VDAVIO87P17E378W'),
  1540. (129, '2005-01-22', '2006-05-10', 'KVNVCR74E07C743H', 'VDAVIO87P17E378W'),
  1541. (130, '2006-09-29', '2007-04-10', 'KVNVCR74E07C743H', 'PNNPLE65R21L840U'),
  1542. (131, '2007-05-27', '2008-12-02', 'KVNVCR74E07C743H', 'CPTMCC84E07B602T'),
  1543. (132, '2009-04-10', '2010-06-07', 'KVNVCR74E07C743H', 'CPTMCC84E07B602T'),
  1544. (133, '2010-12-25', '2012-03-27', 'KVNVCR74E07C743H', 'VDAVIO87P17E378W'),
  1545. (134, '2012-09-12', '2013-08-17', 'KVNVCR74E07C743H', 'PNNPLE65R21L840U'),
  1546. (135, '2013-08-20', '2014-09-18', 'KVNVCR74E07C743H', 'SCMRRT41D22I533B'),
  1547. (136, '2014-09-20', '2014-11-21', 'KVNVCR74E07C743H', 'PNNPLE65R21L840U'),
  1548. (137, '2015-01-16', '2015-05-22', 'KVNVCR74E07C743H', 'DNNFBB81C23A503W'),
  1549. (138, '2015-07-25', '2015-09-26', 'KVNVCR74E07C743H', 'CPTMCC84E07B602T'),
  1550. (139, '2015-11-17', '2016-10-10', 'KVNVCR74E07C743H', 'SCMRRT41D22I533B'),
  1551. (140, '2012-06-23', '2013-10-23', 'GCMPTT56D26L928X', 'RRRSLV79L18H729R'),
  1552. (141, '2013-11-21', '2013-12-14', 'GCMPTT56D26L928X', 'DNNFBB81C23A503W'),
  1553. (142, '2014-01-24', '2014-10-26', 'GCMPTT56D26L928X', 'PNNPLE65R21L840U'),
  1554. (143, '2014-10-29', '2015-01-02', 'GCMPTT56D26L928X', 'DNNFBB81C23A503W'),
  1555. (144, '2015-01-31', '2016-03-31', 'GCMPTT56D26L928X', 'CPTMCC84E07B602T'),
  1556. (145, '2016-04-27', '2016-10-12', 'GCMPTT56D26L928X', 'SCMRRT41D22I533B'),
  1557. (146, '2003-02-04', '2003-11-07', 'MRCZYT78T05Z613A', 'RRRSLV79L18H729R'),
  1558. (147, '2004-06-23', '2004-10-05', 'MRCZYT78T05Z613A', 'BLLHBR88D22A594H'),
  1559. (148, '2004-10-08', '2006-10-18', 'MRCZYT78T05Z613A', 'VDAVIO87P17E378W'),
  1560. (149, '2006-12-15', '2007-03-27', 'MRCZYT78T05Z613A', 'VDAVIO87P17E378W'),
  1561. (150, '2008-01-31', '2008-02-15', 'MRCZYT78T05Z613A', 'VDAVIO87P17E378W'),
  1562. (151, '2008-10-06', '2009-01-13', 'MRCZYT78T05Z613A', 'PNNPLE65R21L840U'),
  1563. (152, '2009-01-15', '2009-11-11', 'MRCZYT78T05Z613A', 'BLLHBR88D22A594H'),
  1564. (153, '2009-11-15', '2010-01-28', 'MRCZYT78T05Z613A', 'RRRSLV79L18H729R'),
  1565. (154, '2010-11-13', '2010-12-15', 'MRCZYT78T05Z613A', 'CPTMCC84E07B602T'),
  1566. (155, '2011-02-21', '2011-11-23', 'MRCZYT78T05Z613A', 'VDAVIO87P17E378W'),
  1567. (156, '2011-12-20', '2016-03-29', 'MRCZYT78T05Z613A', 'DNNFBB81C23A503W'),
  1568. (157, '2014-09-29', '2014-10-02', 'CHRPGN95D58L407B', 'PNNNNA82S54G312F'),
  1569. (158, '2015-04-12', '2015-12-29', 'CHRPGN95D58L407B', 'PNNNNA82S54G312F'),
  1570. (159, '2016-01-17', '2016-03-17', 'CHRPGN95D58L407B', 'PNNNNA82S54G312F'),
  1571. (160, '2015-01-24', '2016-03-21', 'CVLFCH87H01B516Q', 'DNNFBB81C23A503W'),
  1572. (161, '2016-03-23', '2016-06-28', 'CVLFCH87H01B516Q', 'SCMRRT41D22I533B'),
  1573. (162, '2005-06-07', '2005-07-29', 'FRNTLD01R13M145T', 'CPTMCC84E07B602T'),
  1574. (163, '2005-08-21', '2005-09-24', 'FRNTLD01R13M145T', 'RRRSLV79L18H729R'),
  1575. (164, '2005-10-15', '2006-10-05', 'FRNTLD01R13M145T', 'SCMRRT41D22I533B'),
  1576. (165, '2006-11-30', '2007-01-07', 'FRNTLD01R13M145T', 'RRRSLV79L18H729R'),
  1577. (166, '2007-06-08', '2007-10-02', 'FRNTLD01R13M145T', 'DNNFBB81C23A503W'),
  1578. (167, '2008-10-24', '2011-10-14', 'FRNTLD01R13M145T', 'DNNFBB81C23A503W'),
  1579. (168, '2012-04-19', '2013-05-27', 'FRNTLD01R13M145T', 'DNNFBB81C23A503W'),
  1580. (169, '2013-06-01', '2015-09-02', 'FRNTLD01R13M145T', 'DNNFBB81C23A503W'),
  1581. (170, '2015-10-20', '2016-08-15', 'FRNTLD01R13M145T', 'SCMRRT41D22I533B'),
  1582. (171, '2016-03-21', '2016-05-15', 'FRNTTI76P27H501S', 'CPTMCC84E07B602T'),
  1583. (172, '2016-05-16', '2017-01-13', 'FRNTTI76P27H501S', 'RRRSLV79L18H729R'),
  1584. (173, '2003-04-11', '2003-06-20', 'LCNSLL59C07C540T', 'VDAVIO87P17E378W'),
  1585. (174, '2003-11-04', '2004-05-27', 'LCNSLL59C07C540T', 'DNNFBB81C23A503W'),
  1586. (175, '2004-12-05', '2005-06-25', 'LCNSLL59C07C540T', 'RRRSLV79L18H729R'),
  1587. (176, '2005-07-04', '2005-11-27', 'LCNSLL59C07C540T', 'BLLHBR88D22A594H'),
  1588. (177, '2006-04-06', '2006-05-09', 'LCNSLL59C07C540T', 'DNNFBB81C23A503W'),
  1589. (178, '2006-11-03', '2007-05-20', 'LCNSLL59C07C540T', 'RRRSLV79L18H729R'),
  1590. (179, '2006-05-21', '2007-04-29', 'LCNSLL59C07C540T', 'VDAVIO87P17E378W'),
  1591. (180, '2007-05-19', '2008-01-29', 'LCNSLL59C07C540T', 'SCMRRT41D22I533B'),
  1592. (181, '2008-01-10', '2011-03-05', 'LCNSLL59C07C540T', 'BLLHBR88D22A594H'),
  1593. (182, '2011-05-04', '2013-10-17', 'LCNSLL59C07C540T', 'DNNFBB81C23A503W'),
  1594. (183, '2014-01-17', '2015-05-09', 'LCNSLL59C07C540T', 'DNNFBB81C23A503W'),
  1595. (184, '2015-08-26', '2016-01-10', 'LCNSLL59C07C540T', 'BLLHBR88D22A594H'),
  1596. (185, '2016-02-21', '2016-12-14', 'LCNSLL59C07C540T', 'VDAVIO87P17E378W'),
  1597. (186, '2010-10-11', '2011-05-14', 'NNGRDJ88E04Z103C', 'DNNFBB81C23A503W'),
  1598. (187, '2011-06-15', '2012-01-29', 'NNGRDJ88E04Z103C', 'PNNPLE65R21L840U'),
  1599. (188, '2012-02-27', '2013-01-16', 'NNGRDJ88E04Z103C', 'CPTMCC84E07B602T'),
  1600. (189, '2013-02-15', '2014-04-07', 'NNGRDJ88E04Z103C', 'DNNFBB81C23A503W'),
  1601. (190, '2014-04-23', '2015-04-05', 'NNGRDJ88E04Z103C', 'DNNFBB81C23A503W'),
  1602. (191, '2015-06-13', '2015-09-17', 'NNGRDJ88E04Z103C', 'DNNFBB81C23A503W'),
  1603. (192, '2015-11-14', '2016-03-24', 'NNGRDJ88E04Z103C', 'DNNFBB81C23A503W'),
  1604. (193, '2008-08-29', '2008-11-20', 'TRRFNN84C20Z131G', 'VDAVIO87P17E378W'),
  1605. (194, '2009-01-01', '2011-07-07', 'TRRFNN84C20Z131G', 'SCMRRT41D22I533B'),
  1606. (195, '2011-11-24', '2012-01-19', 'TRRFNN84C20Z131G', 'VDAVIO87P17E378W'),
  1607. (196, '2012-02-25', '2012-12-10', 'TRRFNN84C20Z131G', 'PNNPLE65R21L840U'),
  1608. (197, '2013-04-09', '2013-07-09', 'TRRFNN84C20Z131G', 'RRRSLV79L18H729R'),
  1609. (198, '2013-07-13', '2013-12-12', 'TRRFNN84C20Z131G', 'PNNPLE65R21L840U'),
  1610. (199, '2014-01-25', '2015-11-27', 'TRRFNN84C20Z131G', 'VDAVIO87P17E378W'),
  1611. (200, '2015-12-10', '2016-06-13', 'TRRFNN84C20Z131G', 'DNNFBB81C23A503W'),
  1612. (201, '2016-06-21', '2016-12-06', 'TRRFNN84C20Z131G', 'DNNFBB81C23A503W'),
  1613. (202, '2010-10-16', '2013-01-30', 'CNEJHN77D23F284D', 'PNNPLE65R21L840U'),
  1614. (203, '2013-02-22', '2013-08-05', 'CNEJHN77D23F284D', 'VDAVIO87P17E378W'),
  1615. (204, '2013-11-13', '2014-07-26', 'CNEJHN77D23F284D', 'DNNFBB81C23A503W'),
  1616. (205, '2014-08-01', '2015-04-13', 'CNEJHN77D23F284D', 'CPTMCC84E07B602T'),
  1617. (206, '2015-10-26', '2016-12-02', 'CNEJHN77D23F284D', 'PNNPLE65R21L840U');
  1618.  
  1619. -- --------------------------------------------------------
  1620.  
  1621. --
  1622. -- Struttura della tabella `utente`
  1623. --
  1624.  
  1625. CREATE TABLE `utente` (
  1626. `CF` char(16) NOT NULL,
  1627. `Nome` varchar(64) NOT NULL,
  1628. `Cognome` varchar(64) NOT NULL,
  1629. `Sesso` enum('M','F') DEFAULT NULL,
  1630. `Data_Nascita` date NOT NULL,
  1631. `Data_Iscrizione` date NOT NULL,
  1632. `Altezza` int(3) DEFAULT NULL,
  1633. `Peso` decimal(4,1) DEFAULT NULL
  1634. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1635.  
  1636. --
  1637. -- Inserimento dei dati per la tabella `utente`
  1638. --
  1639.  
  1640. INSERT INTO `utente` (`CF`, `Nome`, `Cognome`, `Sesso`, `Data_Nascita`, `Data_Iscrizione`, `Altezza`, `Peso`) VALUES
  1641. ('BGLLDA65T30L407Z', 'Aldo', 'Baglio', 'M', '1965-12-30', '2002-05-17', 175, '77.5'),
  1642. ('CHRPGN95D58L407B', 'Chiara', 'Pinguino', 'F', '1995-04-18', '2014-08-05', 173, '49.0'),
  1643. ('CNEJHN77D23F284D', 'John', 'Cena', 'M', '1977-04-23', '2010-10-10', 185, '114.1'),
  1644. ('CVLFCH87H01B516Q', 'Cavallo', 'Falchi', 'M', '1987-06-01', '2015-01-02', 182, '54.9'),
  1645. ('FRNTLD01R13M145T', 'Francesco', 'Toldo', 'M', '1901-10-13', '2005-05-07', 168, '85.0'),
  1646. ('FRNTTI76P27H501S', 'Francesco', 'Totti', 'M', '1976-09-27', '2016-03-18', 180, '82.3'),
  1647. ('GCMPTT56D26L928X', 'Giacomo', 'Poretti', 'M', '1956-04-26', '2011-07-14', 193, '88.0'),
  1648. ('GNDPRT77P67C817K', 'Guendalina', 'Porte', 'F', '1977-09-27', '2009-04-15', 184, '61.9'),
  1649. ('GRMSTT32S11H783G', 'Germano', 'Sbatte', 'M', '1976-11-16', '2014-05-14', 187, '82.0'),
  1650. ('GVNSRT57B20F205R', 'Giovanni', 'Storti', 'M', '1957-02-20', '2010-06-19', 178, '80.0'),
  1651. ('HRRPTR91S21A663A', 'Harry', 'Potter', 'M', '1991-11-21', '2004-02-11', 169, '77.0'),
  1652. ('JJABZV65H15L407I', 'Ajeje', 'Brazov', 'M', '1965-06-15', '2006-05-09', 170, '74.0'),
  1653. ('KVNVCR74E07C743H', 'Kevin', 'Velociraptor', 'M', '1974-05-07', '2001-12-01', 185, '81.5'),
  1654. ('LCNSLL59C07C540T', 'Luciano', 'Spalletti', 'M', '1959-03-07', '2003-03-03', 184, '78.6'),
  1655. ('LRASRM83H63C957B', 'Laura', 'Stormo', 'F', '1983-06-23', '2013-07-19', 155, '66.3'),
  1656. ('MRCMDR82A62G224B', 'Marcella', 'Mandria', 'F', '1982-01-22', '2010-09-01', 164, '65.4'),
  1657. ('MRCZYT78T05Z613A', 'Marcelo', 'Zalayeta', 'M', '1978-12-05', '2001-07-08', 175, '92.0'),
  1658. ('NNGRDJ88E04Z103C', 'Radja', 'Nainggolan', 'M', '1988-05-04', '2010-10-10', 176, '65.5'),
  1659. ('NZETMN96C06G693G', 'Enzio', 'Termin', 'M', '1996-03-06', '2012-08-27', 167, '75.0'),
  1660. ('RMNPWR51R42L407G', 'Romina', 'Power', 'F', '1951-10-02', '2007-02-13', 186, '57.0'),
  1661. ('TRRFNN84C20Z131G', 'Fernando', 'Torres', 'M', '1984-03-20', '2008-08-08', 186, '78.8');
  1662.  
  1663. -- --------------------------------------------------------
  1664.  
  1665. --
  1666. -- Struttura della tabella `utilizza`
  1667. --
  1668.  
  1669. CREATE TABLE `utilizza` (
  1670. `Attrezzo` int(3) NOT NULL,
  1671. `Nome_Es` varchar(30) NOT NULL
  1672. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1673.  
  1674. --
  1675. -- Inserimento dei dati per la tabella `utilizza`
  1676. --
  1677.  
  1678. INSERT INTO `utilizza` (`Attrezzo`, `Nome_Es`) VALUES
  1679. (1, 'Lento Avanti'),
  1680. (1, 'Lento Dietro'),
  1681. (1, 'Panca Orizzontale'),
  1682. (1, 'Panca Stretta'),
  1683. (1, 'Rematore Inverso'),
  1684. (1, 'Squat'),
  1685. (1, 'Stacchi Da Terra'),
  1686. (1, 'Tirate al Mento'),
  1687. (2, 'Curl Bilanciere Curvo'),
  1688. (2, 'Curl Panca Scott'),
  1689. (2, 'Estensioni Bilanciere'),
  1690. (3, 'Alzate Laterali'),
  1691. (3, 'Alzate su Panca 30°'),
  1692. (3, 'Croci Panca Orizzontale'),
  1693. (3, 'Curl Concentrato'),
  1694. (3, 'Curl Manubri 60°'),
  1695. (3, 'KickBack'),
  1696. (3, 'Lento Manubri'),
  1697. (3, 'Manubrio 90°'),
  1698. (3, 'Manubrio Dietro Testa'),
  1699. (3, 'Pull Over'),
  1700. (3, 'Rematore'),
  1701. (4, 'Croci Panca Orizzontale'),
  1702. (4, 'Estensioni Bilanciere'),
  1703. (4, 'Panca Orizzontale'),
  1704. (4, 'Panca Stretta'),
  1705. (4, 'Pull Over'),
  1706. (4, 'Rematore'),
  1707. (5, 'Alzate su Panca 30°'),
  1708. (6, 'Crunch Inverso'),
  1709. (7, 'Curl Manubri 60°'),
  1710. (8, 'Manubrio 90°'),
  1711. (10, 'Leg Extension'),
  1712. (11, 'Affondi Leg Press 45°'),
  1713. (12, 'Standing Leg Curl'),
  1714. (13, 'Calf Rotary'),
  1715. (14, 'Leg Press 45°'),
  1716. (15, 'Incline Chest'),
  1717. (16, 'Cavo Presa Inversa'),
  1718. (17, 'Lat Machine Avanti'),
  1719. (17, 'Lat Machine Dietro'),
  1720. (18, 'Pull Down'),
  1721. (19, 'Row'),
  1722. (19, 'Rowing Torso'),
  1723. (20, 'Abdominal'),
  1724. (21, 'Adductor'),
  1725. (23, 'Hack Squat'),
  1726. (24, 'Leg Curl'),
  1727. (25, 'Sbarra'),
  1728. (26, 'Pulley'),
  1729. (27, 'Upper Back'),
  1730. (28, 'Curl Panca Scott'),
  1731. (29, 'Curl M-Station'),
  1732. (29, 'M-Station');
  1733.  
  1734. --
  1735. -- Indici per le tabelle `abbonamento`
  1736. --
  1737. ALTER TABLE `abbonamento`
  1738. ADD PRIMARY KEY (`ID_Abbonamento`,`ID_Utente`),
  1739. ADD KEY `ID_Utente` (`ID_Utente`);
  1740.  
  1741. --
  1742. -- Indici per le tabelle `attrezzo`
  1743. --
  1744. ALTER TABLE `attrezzo`
  1745. ADD PRIMARY KEY (`ID_Attrezzo`);
  1746.  
  1747. --
  1748. -- Indici per le tabelle `esercizio`
  1749. --
  1750. ALTER TABLE `esercizio`
  1751. ADD PRIMARY KEY (`Nome`,`Gruppo_Muscolare`);
  1752.  
  1753. --
  1754. -- Indici per le tabelle `istruttore`
  1755. --
  1756. ALTER TABLE `istruttore`
  1757. ADD PRIMARY KEY (`CF`);
  1758.  
  1759. --
  1760. -- Indici per le tabelle `programma`
  1761. --
  1762. ALTER TABLE `programma`
  1763. ADD PRIMARY KEY (`Sequenza`,`ID_Scheda`,`Esercizio`),
  1764. ADD KEY `ID_Scheda` (`ID_Scheda`),
  1765. ADD KEY `Esercizio` (`Esercizio`);
  1766.  
  1767. --
  1768. -- Indici per le tabelle `scheda`
  1769. --
  1770. ALTER TABLE `scheda`
  1771. ADD PRIMARY KEY (`ID_Scheda`,`ID_Utente`,`ID_Ist`),
  1772. ADD KEY `ID_Utente` (`ID_Utente`),
  1773. ADD KEY `ID_Ist` (`ID_Ist`);
  1774.  
  1775. --
  1776. -- Indici per le tabelle `utente`
  1777. --
  1778. ALTER TABLE `utente`
  1779. ADD PRIMARY KEY (`CF`);
  1780.  
  1781. --
  1782. -- Indici per le tabelle `utilizza`
  1783. --
  1784. ALTER TABLE `utilizza`
  1785. ADD PRIMARY KEY (`Attrezzo`,`Nome_Es`),
  1786. ADD KEY `Nome_Es` (`Nome_Es`);
  1787.  
  1788. --
  1789. -- AUTO_INCREMENT per le tabelle scaricate
  1790. --
  1791.  
  1792. --
  1793. -- AUTO_INCREMENT per la tabella `abbonamento`
  1794. --
  1795. ALTER TABLE `abbonamento`
  1796. MODIFY `ID_Abbonamento` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185;
  1797. --
  1798. -- AUTO_INCREMENT per la tabella `programma`
  1799. --
  1800. ALTER TABLE `programma`
  1801. MODIFY `ID_Scheda` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=207;
  1802. --
  1803. -- AUTO_INCREMENT per la tabella `scheda`
  1804. --
  1805. ALTER TABLE `scheda`
  1806. MODIFY `ID_Scheda` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=207;
  1807. --
  1808. -- AUTO_INCREMENT per la tabella `utilizza`
  1809. --
  1810. ALTER TABLE `utilizza`
  1811. MODIFY `Attrezzo` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
  1812. --
  1813. -- Limiti per le tabelle scaricate
  1814. --
  1815.  
  1816. --
  1817. -- Limiti per la tabella `abbonamento`
  1818. --
  1819. ALTER TABLE `abbonamento`
  1820. ADD CONSTRAINT `abbonamento_ibfk_1` FOREIGN KEY (`ID_Utente`) REFERENCES `utente` (`CF`) ON DELETE CASCADE;
  1821.  
  1822. --
  1823. -- Limiti per la tabella `programma`
  1824. --
  1825. ALTER TABLE `programma`
  1826. ADD CONSTRAINT `programma_ibfk_1` FOREIGN KEY (`ID_Scheda`) REFERENCES `scheda` (`ID_Scheda`) ON DELETE CASCADE,
  1827. ADD CONSTRAINT `programma_ibfk_2` FOREIGN KEY (`Esercizio`) REFERENCES `esercizio` (`Nome`) ON DELETE CASCADE;
  1828.  
  1829. --
  1830. -- Limiti per la tabella `scheda`
  1831. --
  1832. ALTER TABLE `scheda`
  1833. ADD CONSTRAINT `scheda_ibfk_1` FOREIGN KEY (`ID_Utente`) REFERENCES `utente` (`CF`) ON DELETE CASCADE,
  1834. ADD CONSTRAINT `scheda_ibfk_2` FOREIGN KEY (`ID_Ist`) REFERENCES `istruttore` (`CF`);
  1835.  
  1836. --
  1837. -- Limiti per la tabella `utilizza`
  1838. --
  1839. ALTER TABLE `utilizza`
  1840. ADD CONSTRAINT `utilizza_ibfk_1` FOREIGN KEY (`Attrezzo`) REFERENCES `attrezzo` (`ID_Attrezzo`) ON DELETE CASCADE,
  1841. ADD CONSTRAINT `utilizza_ibfk_2` FOREIGN KEY (`Nome_Es`) REFERENCES `esercizio` (`Nome`) ON DELETE CASCADE;
  1842.  
  1843. SET FOREIGN_KEY_CHECKS = 1;
  1844.  
  1845. --
  1846. -- Query 1: Trovare il nome e cognome degli utenti nati a Treviso
  1847. --
  1848. SELECT Nome, Cognome
  1849. FROM utente
  1850. WHERE CF LIKE '%L407%';
  1851.  
  1852. --
  1853. -- Query 2: Trovare il nome e cognome degli istruttori che seguono piu` di 12 persone e il relativo numero di persone da essi seguite.
  1854. --
  1855. SELECT I.Nome, I.Cognome, COUNT(DISTINCT ID_Utente) AS 'Conta'
  1856. FROM scheda AS S, istruttore AS I
  1857. WHERE S.ID_Ist=I.CF
  1858. GROUP BY ID_Ist
  1859. HAVING COUNT(DISTINCT ID_Utente)>12;
  1860.  
  1861. --
  1862. -- Query 3: Trovare l'importo medio(arrotondato al centesimo) degli abbonamenti compresi di sauna sottoscritti da ogni utente negli ultimi 2 anni.
  1863. --
  1864. SELECT U.Nome, U.Cognome, ROUND(AVG(A.Prezzo),2) AS 'Importo Medio'
  1865. FROM abbonamento AS A, utente AS U
  1866. WHERE U.CF=A.ID_Utente AND A.Data_Inizio>date_sub(curdate(), interval 2 year) AND A.Sauna=1
  1867. GROUP BY U.CF;
  1868.  
  1869. --
  1870. -- Query 4: Trovare nome e cognome degli utenti donna che non hanno mai usato attrezzi o non hanno mai sollevato più del proprio peso.
  1871. --
  1872. SELECT DISTINCT U.Nome, U.Cognome
  1873. FROM utente AS U, scheda as S, programma AS P, esercizio AS E, utilizza as UT
  1874. WHERE U.Sesso = 'F' AND U.CF = S.ID_Utente AND S.ID_Scheda = P.ID_Scheda
  1875. AND E.Nome = P.Esercizio AND UT.Nome_Es = E.Nome
  1876. AND (P.Carico < U.Peso OR E.Nome NOT IN (SELECT UT.Nome_Es FROM utilizza));
  1877.  
  1878. --
  1879. -- Query 5: Trovare la lista dei massimali (ovvero esercizi che prevedono su programma soltanto una ripetizione)
  1880. -- degli esercizi Panca Orizzontale, Squat, Estensioni Bilanciere e Lento Avanti degli utenti iscritti da più di 5 anni.
  1881. --
  1882. SELECT U.Nome, U.Cognome, MAX(IF(P1.Esercizio="Panca Orizzontale",P1.Carico,0)) AS MaxPanca_Orizzontale, MAX(IF(P1.Esercizio="Squat",P1.Carico,0)) AS MaxSquat, MAX(IF(P1.Esercizio="Estensioni Bilanciere",P1.Carico,0)) AS MaxEstensioni_Bilanciere, MAX(IF(P1.Esercizio="Lento Avanti",P1.Carico,0)) AS MaxLento_Avanti
  1883. FROM utente AS U
  1884. LEFT JOIN scheda AS S1 ON U.CF=S1.ID_Utente
  1885. LEFT JOIN programma AS P1 ON S1.ID_Scheda=P1.ID_Scheda
  1886. AND P1.nRipetizioni=1
  1887. WHERE Data_Iscrizione < date_sub(curdate(), INTERVAL 5 YEAR)
  1888. GROUP BY U.Nome, U.Cognome;
  1889.  
  1890. --
  1891. -- Query 6: Trovare nome, cognome, stipendio e certificazione degli istruttori che hanno creato almeno una scheda che contiene programmi che non usano attrezzi
  1892. -- e nome e cognome degli utenti che li svolgono e ID_Scheda delle schede in cui i programmi sono contenuti.
  1893. --
  1894. SELECT DISTINCT I.Nome AS NomeIstruttore, I.Cognome AS CognomeIstruttore, I.Stipendio, I.Certificazione, U.Nome AS NomeUtente, U.Cognome AS CognomeUtente, S.ID_Scheda
  1895. FROM scheda AS S, istruttore AS I, utente AS U
  1896. WHERE S.ID_Ist=I.CF AND U.CF=S.ID_Utente
  1897. AND S.ID_Scheda NOT IN(SELECT DISTINCT S.ID_Scheda FROM programma AS P, scheda AS S WHERE P.ID_Scheda=S.ID_Scheda AND P.Esercizio IN(SELECT DISTINCT Nome_Es FROM utilizza))
  1898. ORDER BY S.ID_Scheda;
  1899.  
  1900. --
  1901. --
  1902. -- Procedura: Creare una procedura che ci permetta di aumentare o diminuire il carico di un determinato esercizio effettuato in un dato programma di una data scheda
  1903. --
  1904.  
  1905. CREATE PROCEDURE varcarico (IN seq int(2), IN sc int(10), IN es varchar(30), IN variazione decimal(4,1))
  1906. UPDATE programma
  1907. SET programma.Carico = programma.Carico + variazione
  1908. WHERE programma.Sequenza = seq AND programma.ID_Scheda = sc AND programma.Esercizio = es;
  1909.  
  1910. -- Chiamata: CALL varcarico('example_#Sequenza', 'example_ID_Scheda', 'example_Esercizio', +/-n)
  1911. -- Chiamata esempio: CALL varcarico('12', '75', 'Pulley', -3.5);
  1912.  
  1913.  
  1914. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1915. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1916. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!