Commit 88757ef

@@ -0,0 +1,594 @@
+#TABLE ZEXERCISE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCATEGORY INTEGER, ZTYPE INTEGER, ZINCREMENTWEIGHT INTEGER, ZSTARTINGWEIGHT INTEGER );
+|| SELECT * FROM ZEXERCISE;
+|| [169, 2, 1, 0, 4, nil, 498]
+|| [170, 2, 1, 0, 2, nil, 500]
+|| [171, 2, 1, 0, 3, nil, 496]
+|| [172, 2, 1, 1, 6, nil, 494]
+|| [173, 2, 1, 0, 5, nil, 497]
+|| [174, 2, 1, 1, 7, nil, 499]
+|| [175, 2, 1, 0, 1, nil, 495]
+
+#TABLE ZEXERCISESETS ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDELOADED INTEGER, ZEXERCISETYPE INTEGER, ZMODE INTEGER, ZSET1 INTEGER, ZSET2 INTEGER, ZSET3 INTEGER, ZSET4 INTEGER, ZSET5 INTEGER, ZSUCCESS INTEGER, ZWARMUP INTEGER, ZWEIGHT INTEGER, ZWORKOUT INTEGER, Z_FOK_WORKOUT INTEGER );
+|| SELECT * FROM ZEXERCISESETS;
+|| [13, 3, 2, nil, 2, 0, 5, 5, 5, 5, 5, 1, nil, 58, 5, 3072]
+|| [14, 3, 2, nil, 1, 0, 5, 5, 5, 5, 5, 1, nil, 57, 5, 2048]
+|| [15, 3, 2, nil, 3, 0, 5, 5, 5, 5, 5, 1, nil, 56, 5, 4096]
+|| [16, 3, 1, nil, 6, 5, 10, 10, 10, -3, -3, 1, nil, 68, 5, 5120]
+|| [29, 3, 2, nil, 1, 0, 5, 5, 5, 5, 5, 1, nil, 126, 9, 2048]
+|| [30, 3, 2, nil, 4, 0, 5, 5, 5, 5, 5, 1, nil, 127, 9, 3072]
+|| [31, 3, 2, nil, 5, 3, 5, -3, -3, -3, -3, 1, nil, 129, 9, 4096]
+|| [32, 3, 2, nil, 7, 5, 10, 6, 5, -3, -3, 0, nil, 128, 9, 5120]
+|| [33, 3, 1, nil, 1, 0, 5, 5, 5, 5, 5, 1, nil, 184, 10, 2048]
+|| [34, 3, 2, nil, 3, 0, 5, 5, 5, 5, 5, 1, nil, 190, 10, 4096]
+|| [35, 3, 1, nil, 2, 0, 5, 5, 5, 5, 5, 1, nil, 182, 10, 3072]
+|| [36, 3, 2, nil, 6, 1, 5, 5, 5, -3, -3, 1, nil, 185, 10, 5120]
+|| [45, 3, 1, nil, 1, 0, 5, 5, 5, 5, 5, 1, nil, 259, 13, 2048]
+|| [46, 3, 1, nil, 4, 0, 5, 5, 5, 5, 5, 1, nil, 263, 13, 3072]
+|| [47, 3, 1, nil, 5, 3, 5, -3, -3, -3, -3, 1, nil, 266, 13, 4096]
+|| [48, 3, 1, nil, 7, 5, 10, 7, 4, -3, -3, 0, nil, 268, 13, 5120]
+|| [53, 3, 2, nil, 1, 0, 5, 5, 5, 5, 5, 1, 19, 318, 15, 2048]
+|| [54, 3, 2, nil, 3, 0, 5, 5, 5, 5, 5, 1, nil, 319, 15, 4096]
+|| [55, 3, 2, nil, 6, 1, 5, 5, 5, -3, -3, 1, nil, 317, 15, 5120]
+|| [56, 3, 3, nil, 2, 0, 5, 5, 5, 5, 5, 1, 18, 320, 15, 3072]
+|| [65, 3, 3, nil, 5, 3, 5, -3, -3, -3, -3, 1, 25, 373, 18, 4096]
+|| [66, 3, 2, nil, 7, 5, 10, 8, 6, -3, -3, 0, nil, 370, 18, 5120]
+|| [67, 3, 3, nil, 4, 0, 5, 5, 5, 5, 5, 1, 24, 372, 18, 3072]
+|| [68, 3, 3, nil, 1, 0, 5, 5, 5, 5, 5, 1, 23, 371, 18, 2048]
+|| [69, 3, 3, nil, 2, 0, 5, 5, 5, 5, 5, 1, 27, 404, 19, 3072]
+|| [70, 3, 3, nil, 3, 0, 5, 5, 5, 5, 5, 1, 28, 405, 19, 4096]
+|| [71, 3, 3, nil, 1, 0, 5, 5, 5, 5, 5, 1, 26, 403, 19, 2048]
+|| [72, 3, 2, nil, 6, 1, 5, 5, 5, -3, -3, 1, nil, 406, 19, 5120]
+|| [73, 3, 3, nil, 1, 0, 5, 5, 5, 5, 5, 1, 29, 439, 20, 2048]
+|| [74, 3, 2, 1, 7, 5, 10, 8, 6, -3, -3, 0, nil, 441, 20, 5120]
+|| [75, 3, 3, nil, 4, 0, 5, 5, 5, 5, 5, 1, 30, 438, 20, 3072]
+|| [76, 3, 3, nil, 5, 3, 5, -3, -3, -3, -3, 1, 31, 440, 20, 4096]
+|| [77, 3, 3, nil, 2, 0, 5, 5, 5, 5, 5, 1, 33, 470, 21, 3072]
+|| [78, 3, 3, nil, 1, 0, 5, 5, 5, 5, 5, 1, 32, 468, 21, 2048]
+|| [79, 3, 2, nil, 6, 1, 5, 5, 5, -3, -3, 1, nil, 469, 21, 5120]
+|| [80, 3, 3, nil, 3, 0, 5, 5, 5, 5, 5, 1, 34, 471, 21, 4096]
+
+#TABLE ZPLATE ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZQUANTITY INTEGER, ZTYPE INTEGER, ZWEIGHT INTEGER );
+|| SELECT * FROM ZPLATE;
+|| [1, 4, 1, 4, 0, 15]
+|| [2, 4, 1, 4, 0, 6]
+|| [3, 4, 1, 8, 0, 13]
+|| [4, 4, 1, 4, 0, 2]
+|| [5, 4, 1, 4, 0, 10]
+|| [6, 4, 1, 8, 0, 5]
+|| [7, 4, 1, 4, 0, 7]
+|| [8, 4, 1, 4, 0, 3]
+|| [9, 4, 1, 4, 0, 11]
+|| [10, 4, 1, 4, 0, 1]
+
+#TABLE ZWEIGHT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSTOREDUNIT INTEGER, ZUNIT INTEGER, ZSTOREDVAL FLOAT, ZVAL FLOAT );
+|| SELECT * FROM ZWEIGHT;
+|| [1, 6, 1, 0, 1, 0.0, 5.0]
+|| [2, 6, 1, 0, 2, 0.0, 25.0]
+|| [3, 6, 1, 0, 1, 0.0, 1.25]
+|| [4, 6, 1, 0, 2, 0.0, 45.0]
+|| [5, 6, 1, 0, 2, 0.0, 45.0]
+|| [6, 6, 1, 0, 1, 0.0, 2.5]
+|| [7, 6, 1, 0, 2, 0.0, 5.0]
+|| [8, 6, 1, 0, 2, 0.0, 95.0]
+|| [9, 6, 1, 0, 2, 0.0, 45.0]
+|| [10, 6, 1, 0, 1, 0.0, 10.0]
+|| [11, 6, 1, 0, 2, 0.0, 2.5]
+|| [12, 6, 1, 0, 2, 0.0, 0.0]
+|| [13, 6, 1, 0, 1, 0.0, 20.0]
+|| [14, 6, 1, 0, 2, 0.0, 45.0]
+|| [15, 6, 1, 0, 2, 0.0, 10.0]
+|| [16, 6, 1, 0, 2, 0.0, 65.0]
+|| [17, 6, 1, 0, 2, 0.0, 0.0]
+|| [18, 6, 1, 0, 2, 0.0, 45.0]
+|| [19, 6, 1, 0, 2, 0.0, 45.0]
+|| [20, 6, 1, 0, 2, 0.0, 65.0]
+|| [21, 6, 1, 0, 2, 0.0, 45.0]
+|| [22, 6, 1, 0, 2, 0.0, 95.0]
+|| [23, 6, 1, 0, 2, 0.0, 0.0]
+|| [24, 6, 1, 0, 2, 0.0, 45.0]
+|| [25, 6, 1, 0, 2, 0.0, 45.0]
+|| [26, 6, 1, 0, 2, 0.0, 65.0]
+|| [27, 6, 1, 0, 2, 0.0, 0.0]
+|| [28, 6, 1, 0, 2, 0.0, 45.0]
+|| [29, 6, 1, 0, 2, 0.0, 45.0]
+|| [30, 6, 1, 0, 2, 0.0, 65.0]
+|| [31, 6, 1, 0, 2, 0.0, 45.0]
+|| [32, 6, 1, 0, 2, 0.0, 45.0]
+|| [33, 6, 1, 0, 2, 0.0, 65.0]
+|| [34, 6, 1, 0, 2, 0.0, 45.0]
+|| [35, 6, 1, 0, 2, 0.0, 65.0]
+|| [36, 6, 1, 0, 2, 0.0, 45.0]
+|| [37, 6, 1, 0, 2, 0.0, 65.0]
+|| [38, 6, 1, 0, 2, 0.0, 45.0]
+|| [39, 6, 1, 0, 2, 0.0, 45.0]
+|| [40, 6, 1, 0, 2, 0.0, 45.0]
+|| [41, 6, 1, 0, 2, 0.0, 65.0]
+|| [42, 6, 1, 0, 2, 0.0, 45.0]
+|| [43, 6, 1, 0, 2, 0.0, 45.0]
+|| [44, 6, 1, 0, 2, 0.0, 45.0]
+|| [45, 6, 1, 0, 2, 0.0, 65.0]
+|| [46, 6, 1, 0, 2, 0.0, 0.0]
+|| [47, 6, 1, 0, 2, 0.0, 45.0]
+|| [48, 6, 1, 0, 2, 0.0, 45.0]
+|| [49, 6, 1, 0, 2, 0.0, 65.0]
+|| [50, 6, 1, 0, 2, 0.0, 45.0]
+|| [51, 6, 1, 0, 2, 0.0, 45.0]
+|| [52, 6, 1, 0, 2, 0.0, 0.0]
+|| [53, 6, 1, 0, 2, 0.0, 65.0]
+|| [54, 6, 1, 0, 2, 0.0, 95.0]
+|| [55, 6, 1, 0, 2, 0.0, 45.0]
+|| [56, 6, 1, 0, 2, 0.0, 65.0]
+|| [57, 6, 1, 0, 2, 0.0, 45.0]
+|| [58, 6, 1, 0, 2, 0.0, 45.0]
+|| [59, 6, 1, 0, 2, 0.0, 50.0]
+|| [60, 6, 1, 0, 2, 0.0, 70.0]
+|| [61, 6, 1, 0, 2, 0.0, 50.0]
+|| [62, 6, 1, 0, 2, 0.0, 70.0]
+|| [63, 6, 1, 0, 2, 0.0, 50.0]
+|| [64, 6, 1, 0, 2, 0.0, 50.0]
+|| [65, 6, 1, 0, 2, 0.0, 50.0]
+|| [66, 6, 1, 0, 2, 0.0, 50.0]
+|| [67, 6, 1, 0, 2, 0.0, 50.0]
+|| [68, 6, 1, 0, 2, 0.0, 0.0]
+|| [69, 6, 1, 0, 2, 0.0, 50.0]
+|| [70, 6, 1, 0, 2, 0.0, 70.0]
+|| [71, 6, 1, 0, 2, 0.0, 50.0]
+|| [72, 6, 1, 0, 2, 0.0, 50.0]
+|| [73, 6, 1, 0, 2, 0.0, 70.0]
+|| [74, 6, 1, 0, 2, 0.0, 50.0]
+|| [75, 6, 1, 0, 2, 0.0, 50.0]
+|| [76, 6, 1, 0, 2, 0.0, 70.0]
+|| [77, 6, 1, 0, 2, 0.0, 50.0]
+|| [78, 6, 1, 0, 2, 0.0, 50.0]
+|| [79, 6, 1, 0, 2, 0.0, 0.0]
+|| [80, 6, 1, 0, 2, 0.0, 45.0]
+|| [81, 6, 1, 0, 2, 0.0, 45.0]
+|| [82, 6, 1, 0, 2, 0.0, 95.0]
+|| [83, 6, 1, 0, 2, 0.0, 95.0]
+|| [84, 6, 1, 0, 2, 0.0, 50.0]
+|| [85, 6, 1, 0, 2, 0.0, 0.0]
+|| [86, 6, 1, 0, 2, 0.0, 95.0]
+|| [87, 6, 1, 0, 2, 0.0, 0.0]
+|| [88, 6, 1, 0, 2, 0.0, 95.0]
+|| [89, 6, 1, 0, 2, 0.0, 45.0]
+|| [90, 6, 1, 0, 2, 0.0, 45.0]
+|| [91, 6, 1, 0, 2, 0.0, 45.0]
+|| [92, 6, 1, 0, 2, 0.0, 45.0]
+|| [93, 6, 1, 0, 2, 0.0, 0.0]
+|| [94, 6, 1, 0, 2, 0.0, 50.0]
+|| [95, 6, 1, 0, 2, 0.0, 65.0]
+|| [96, 6, 1, 0, 2, 0.0, 0.0]
+|| [97, 6, 1, 0, 2, 0.0, 45.0]
+|| [98, 6, 1, 0, 2, 0.0, 95.0]
+|| [99, 6, 1, 0, 2, 0.0, 0.0]
+|| [100, 6, 1, 0, 2, 0.0, 0.0]
+|| [101, 6, 1, 0, 2, 0.0, 95.0]
+|| [102, 6, 1, 0, 2, 0.0, 45.0]
+|| [103, 6, 1, 0, 2, 0.0, 45.0]
+|| [104, 6, 1, 0, 2, 0.0, 45.0]
+|| [105, 6, 1, 0, 2, 0.0, 65.0]
+|| [106, 6, 1, 0, 2, 0.0, 0.0]
+|| [107, 6, 1, 0, 2, 0.0, 50.0]
+|| [108, 6, 1, 0, 2, 0.0, 95.0]
+|| [109, 6, 1, 0, 2, 0.0, 65.0]
+|| [110, 6, 1, 0, 2, 0.0, 0.0]
+|| [111, 6, 1, 0, 2, 0.0, 45.0]
+|| [112, 6, 1, 0, 2, 0.0, 0.0]
+|| [113, 6, 1, 0, 2, 0.0, 45.0]
+|| [114, 6, 1, 0, 2, 0.0, 45.0]
+|| [115, 6, 1, 0, 2, 0.0, 95.0]
+|| [116, 6, 1, 0, 2, 0.0, 50.0]
+|| [117, 6, 1, 0, 2, 0.0, 45.0]
+|| [118, 6, 1, 0, 2, 0.0, 0.0]
+|| [119, 6, 1, 0, 2, 0.0, 45.0]
+|| [120, 6, 1, 0, 2, 0.0, 65.0]
+|| [121, 6, 1, 0, 2, 0.0, 0.0]
+|| [122, 6, 1, 0, 2, 0.0, 95.0]
+|| [123, 6, 1, 0, 2, 0.0, 45.0]
+|| [124, 6, 1, 0, 2, 0.0, 0.0]
+|| [125, 6, 1, 0, 2, 0.0, 45.0]
+|| [126, 6, 1, 0, 2, 0.0, 50.0]
+|| [127, 6, 1, 0, 2, 0.0, 45.0]
+|| [128, 6, 1, 0, 2, 0.0, 0.0]
+|| [129, 6, 1, 0, 2, 0.0, 95.0]
+|| [130, 6, 1, 0, 2, 0.0, 55.0]
+|| [131, 6, 1, 0, 2, 0.0, 55.0]
+|| [132, 6, 1, 0, 2, 0.0, 50.0]
+|| [133, 6, 1, 0, 2, 0.0, 50.0]
+|| [134, 6, 1, 0, 2, 0.0, 105.0]
+|| [135, 6, 1, 0, 2, 0.0, 105.0]
+|| [136, 6, 1, 0, 2, 0.0, 105.0]
+|| [137, 6, 1, 0, 2, 0.0, 55.0]
+|| [138, 6, 1, 0, 2, 0.0, 55.0]
+|| [139, 6, 1, 0, 2, 0.0, 50.0]
+|| [140, 6, 1, 0, 2, 0.0, 105.0]
+|| [141, 6, 1, 0, 2, 0.0, 55.0]
+|| [142, 6, 1, 0, 2, 0.0, 55.0]
+|| [143, 6, 1, 0, 2, 0.0, 50.0]
+|| [144, 6, 1, 0, 2, 0.0, 55.0]
+|| [145, 6, 1, 0, 2, 0.0, 105.0]
+|| [146, 6, 1, 0, 2, 0.0, 50.0]
+|| [147, 6, 1, 0, 2, 0.0, 50.0]
+|| [148, 6, 1, 0, 2, 0.0, 55.0]
+|| [149, 6, 1, 0, 2, 0.0, 50.0]
+|| [150, 6, 1, 0, 2, 0.0, 105.0]
+|| [151, 6, 1, 0, 2, 0.0, 50.0]
+|| [152, 6, 1, 0, 2, 0.0, 105.0]
+|| [153, 6, 1, 0, 2, 0.0, 50.0]
+|| [154, 6, 1, 0, 2, 0.0, 105.0]
+|| [155, 6, 1, 0, 2, 0.0, 55.0]
+|| [156, 6, 1, 0, 2, 0.0, 55.0]
+|| [157, 6, 1, 0, 2, 0.0, 50.0]
+|| [158, 6, 1, 0, 2, 0.0, 55.0]
+|| [159, 6, 1, 0, 2, 0.0, 105.0]
+|| [160, 6, 1, 0, 2, 0.0, 95.0]
+|| [161, 6, 1, 0, 2, 0.0, 65.0]
+|| [162, 6, 1, 0, 2, 0.0, 0.0]
+|| [163, 6, 1, 0, 2, 0.0, 45.0]
+|| [164, 6, 1, 0, 2, 0.0, 0.0]
+|| [165, 6, 1, 0, 2, 0.0, 45.0]
+|| [166, 6, 1, 0, 2, 0.0, 45.0]
+|| [167, 6, 1, 0, 2, 0.0, 70.0]
+|| [168, 6, 1, 0, 2, 0.0, 50.0]
+|| [169, 6, 1, 0, 2, 0.0, 55.0]
+|| [170, 6, 1, 0, 2, 0.0, 5.0]
+|| [171, 6, 1, 0, 2, 0.0, 5.0]
+|| [172, 6, 1, 0, 2, 0.0, 70.0]
+|| [173, 6, 1, 0, 2, 0.0, 55.0]
+|| [174, 6, 1, 0, 2, 0.0, 50.0]
+|| [175, 6, 1, 0, 2, 0.0, 95.0]
+|| [176, 6, 1, 0, 2, 0.0, 65.0]
+|| [177, 6, 1, 0, 2, 0.0, 0.0]
+|| [178, 6, 1, 0, 2, 0.0, 45.0]
+|| [179, 6, 1, 0, 2, 0.0, 45.0]
+|| [180, 6, 1, 0, 2, 0.0, 0.0]
+|| [181, 6, 1, 0, 2, 0.0, 45.0]
+|| [182, 6, 1, 0, 2, 0.0, 50.0]
+|| [183, 6, 1, 0, 2, 0.0, 55.0]
+|| [184, 6, 1, 0, 2, 0.0, 55.0]
+|| [185, 6, 1, 0, 2, 0.0, 5.0]
+|| [186, 6, 1, 0, 2, 0.0, 55.0]
+|| [187, 6, 1, 0, 2, 0.0, 60.0]
+|| [188, 6, 1, 0, 2, 0.0, 60.0]
+|| [189, 6, 1, 0, 2, 0.0, 60.0]
+|| [190, 6, 1, 0, 2, 0.0, 70.0]
+|| [191, 6, 1, 0, 2, 0.0, 60.0]
+|| [192, 6, 1, 0, 2, 0.0, 55.0]
+|| [193, 6, 1, 0, 2, 0.0, 75.0]
+|| [194, 6, 1, 0, 2, 0.0, 55.0]
+|| [195, 6, 1, 0, 2, 0.0, 75.0]
+|| [196, 6, 1, 0, 2, 0.0, 75.0]
+|| [197, 6, 1, 0, 2, 0.0, 55.0]
+|| [198, 6, 1, 0, 2, 0.0, 60.0]
+|| [199, 6, 1, 0, 2, 0.0, 60.0]
+|| [200, 6, 1, 0, 2, 0.0, 45.0]
+|| [201, 6, 1, 0, 2, 0.0, 0.0]
+|| [202, 6, 1, 0, 2, 0.0, 45.0]
+|| [203, 6, 1, 0, 2, 0.0, 45.0]
+|| [204, 6, 1, 0, 2, 0.0, 95.0]
+|| [205, 6, 1, 0, 2, 0.0, 0.0]
+|| [206, 6, 1, 0, 2, 0.0, 65.0]
+|| [207, 6, 1, 0, 2, 0.0, 105.0]
+|| [208, 6, 1, 0, 2, 0.0, 50.0]
+|| [209, 6, 1, 0, 2, 0.0, 60.0]
+|| [210, 6, 1, 0, 2, 0.0, 0.0]
+|| [211, 6, 1, 0, 2, 0.0, 0.0]
+|| [212, 6, 1, 0, 2, 0.0, 95.0]
+|| [213, 6, 1, 0, 2, 0.0, 45.0]
+|| [214, 6, 1, 0, 2, 0.0, 65.0]
+|| [215, 6, 1, 0, 2, 0.0, 0.0]
+|| [216, 6, 1, 0, 2, 0.0, 45.0]
+|| [217, 6, 1, 0, 2, 0.0, 45.0]
+|| [218, 6, 1, 0, 2, 0.0, 60.0]
+|| [219, 6, 1, 0, 2, 0.0, 0.0]
+|| [220, 6, 1, 0, 2, 0.0, 50.0]
+|| [221, 6, 1, 0, 2, 0.0, 105.0]
+|| [222, 6, 1, 0, 2, 0.0, 65.0]
+|| [223, 6, 1, 0, 2, 0.0, 55.0]
+|| [224, 6, 1, 0, 2, 0.0, 65.0]
+|| [225, 6, 1, 0, 2, 0.0, 55.0]
+|| [226, 6, 1, 0, 2, 0.0, 65.0]
+|| [227, 6, 1, 0, 2, 0.0, 10.0]
+|| [228, 6, 1, 0, 2, 0.0, 65.0]
+|| [229, 6, 1, 0, 2, 0.0, 75.0]
+|| [230, 6, 1, 0, 2, 0.0, 55.0]
+|| [231, 6, 1, 0, 2, 0.0, 70.0]
+|| [232, 6, 1, 0, 2, 0.0, 65.0]
+|| [233, 6, 1, 0, 2, 0.0, 10.0]
+|| [234, 6, 1, 0, 2, 0.0, 70.0]
+|| [235, 6, 1, 0, 2, 0.0, 55.0]
+|| [236, 6, 1, 0, 2, 0.0, 60.0]
+|| [237, 6, 1, 0, 2, 0.0, 75.0]
+|| [238, 6, 1, 0, 2, 0.0, 60.0]
+|| [239, 6, 1, 0, 2, 0.0, 70.0]
+|| [240, 6, 1, 0, 2, 0.0, 60.0]
+|| [241, 6, 1, 0, 2, 0.0, 0.0]
+|| [242, 6, 1, 0, 2, 0.0, 45.0]
+|| [243, 6, 1, 0, 2, 0.0, 45.0]
+|| [244, 6, 1, 0, 2, 0.0, 45.0]
+|| [245, 6, 1, 0, 2, 0.0, 95.0]
+|| [246, 6, 1, 0, 2, 0.0, 65.0]
+|| [247, 6, 1, 0, 2, 0.0, 0.0]
+|| [248, 6, 1, 0, 2, 0.0, 70.0]
+|| [249, 6, 1, 0, 2, 0.0, 60.0]
+|| [250, 6, 1, 0, 2, 0.0, 10.0]
+|| [251, 6, 1, 0, 2, 0.0, 65.0]
+|| [252, 6, 1, 0, 2, 0.0, 55.0]
+|| [253, 6, 1, 0, 2, 0.0, 75.0]
+|| [254, 6, 1, 0, 2, 0.0, 55.0]
+|| [255, 6, 1, 0, 2, 0.0, 75.0]
+|| [256, 6, 1, 0, 2, 0.0, 65.0]
+|| [257, 6, 1, 0, 2, 0.0, 10.0]
+|| [258, 6, 1, 0, 2, 0.0, 55.0]
+|| [259, 6, 1, 0, 2, 0.0, 60.0]
+|| [260, 6, 1, 0, 2, 0.0, 115.0]
+|| [261, 6, 1, 0, 2, 0.0, 65.0]
+|| [262, 6, 1, 0, 2, 0.0, 115.0]
+|| [263, 6, 1, 0, 2, 0.0, 50.0]
+|| [264, 6, 1, 0, 2, 0.0, 65.0]
+|| [265, 6, 1, 0, 2, 0.0, 55.0]
+|| [266, 6, 1, 0, 2, 0.0, 105.0]
+|| [267, 6, 1, 0, 2, 0.0, 115.0]
+|| [268, 6, 1, 0, 2, 0.0, 0.0]
+|| [269, 6, 1, 0, 2, 0.0, 65.0]
+|| [270, 6, 1, 0, 2, 0.0, 55.0]
+|| [271, 6, 1, 0, 2, 0.0, 60.0]
+|| [272, 6, 1, 0, 2, 0.0, 55.0]
+|| [273, 6, 1, 0, 2, 0.0, 50.0]
+|| [274, 6, 1, 0, 2, 0.0, 105.0]
+|| [275, 6, 1, 0, 2, 0.0, 0.0]
+|| [276, 6, 1, 0, 2, 0.0, 65.0]
+|| [277, 6, 1, 0, 2, 0.0, 115.0]
+|| [278, 6, 1, 0, 2, 0.0, 50.0]
+|| [279, 6, 1, 0, 2, 0.0, 60.0]
+|| [280, 6, 1, 0, 2, 0.0, 0.0]
+|| [281, 6, 1, 0, 2, 0.0, 115.0]
+|| [282, 6, 1, 0, 2, 0.0, 105.0]
+|| [283, 6, 1, 0, 2, 0.0, 65.0]
+|| [284, 6, 1, 0, 2, 0.0, 55.0]
+|| [285, 6, 1, 0, 2, 0.0, 0.0]
+|| [286, 6, 1, 0, 2, 0.0, 65.0]
+|| [287, 6, 1, 0, 2, 0.0, 45.0]
+|| [288, 6, 1, 0, 2, 0.0, 0.0]
+|| [289, 6, 1, 0, 2, 0.0, 95.0]
+|| [290, 6, 1, 0, 2, 0.0, 45.0]
+|| [291, 6, 1, 0, 2, 0.0, 45.0]
+|| [292, 6, 1, 0, 2, 0.0, 50.0]
+|| [293, 6, 1, 0, 2, 0.0, 105.0]
+|| [294, 6, 1, 0, 2, 0.0, 55.0]
+|| [295, 6, 1, 0, 2, 0.0, 65.0]
+|| [296, 6, 1, 0, 2, 0.0, 115.0]
+|| [297, 6, 1, 0, 2, 0.0, 60.0]
+|| [298, 6, 1, 0, 2, 0.0, 0.0]
+|| [299, 6, 1, 0, 2, 0.0, 45.0]
+|| [300, 6, 1, 0, 2, 0.0, 95.0]
+|| [301, 6, 1, 0, 2, 0.0, 65.0]
+|| [302, 6, 1, 0, 2, 0.0, 0.0]
+|| [303, 6, 1, 0, 2, 0.0, 45.0]
+|| [304, 6, 1, 0, 2, 0.0, 45.0]
+|| [305, 6, 1, 0, 2, 0.0, 0.0]
+|| [306, 6, 1, 0, 2, 0.0, 55.0]
+|| [307, 6, 1, 0, 2, 0.0, 65.0]
+|| [308, 6, 1, 0, 2, 0.0, 10.0]
+|| [309, 6, 1, 0, 2, 0.0, 75.0]
+|| [310, 6, 1, 0, 2, 0.0, 65.0]
+|| [311, 6, 1, 0, 2, 0.0, 0.0]
+|| [312, 6, 1, 0, 2, 0.0, 45.0]
+|| [313, 6, 1, 0, 2, 0.0, 95.0]
+|| [314, 6, 1, 0, 2, 0.0, 0.0]
+|| [315, 6, 1, 0, 2, 0.0, 45.0]
+|| [316, 6, 1, 0, 2, 0.0, 45.0]
+|| [317, 6, 1, 0, 2, 0.0, 10.0]
+|| [318, 6, 1, 0, 2, 0.0, 65.0]
+|| [319, 6, 1, 0, 2, 0.0, 75.0]
+|| [320, 6, 1, 0, 2, 0.0, 55.0]
+|| [321, 6, 1, 0, 2, 0.0, 70.0]
+|| [322, 6, 1, 0, 2, 0.0, 70.0]
+|| [323, 6, 1, 0, 2, 0.0, 60.0]
+|| [324, 6, 1, 0, 2, 0.0, 70.0]
+|| [325, 6, 1, 0, 2, 0.0, 70.0]
+|| [326, 6, 1, 0, 2, 0.0, 80.0]
+|| [327, 6, 1, 0, 2, 0.0, 60.0]
+|| [328, 6, 1, 0, 2, 0.0, 80.0]
+|| [329, 6, 1, 0, 2, 0.0, 80.0]
+|| [330, 6, 1, 0, 2, 0.0, 60.0]
+|| [331, 6, 1, 0, 2, 0.0, 70.0]
+|| [332, 6, 1, 0, 2, 0.0, 70.0]
+|| [333, 6, 1, 0, 2, 0.0, 60.0]
+|| [334, 6, 1, 0, 2, 0.0, 45.0]
+|| [335, 6, 1, 0, 2, 0.0, 95.0]
+|| [336, 6, 1, 0, 2, 0.0, 65.0]
+|| [337, 6, 1, 0, 2, 0.0, 0.0]
+|| [338, 6, 1, 0, 2, 0.0, 45.0]
+|| [339, 6, 1, 0, 2, 0.0, 0.0]
+|| [340, 6, 1, 0, 2, 0.0, 45.0]
+|| [341, 6, 1, 0, 2, 0.0, 10.0]
+|| [342, 6, 1, 0, 2, 0.0, 65.0]
+|| [343, 6, 1, 0, 2, 0.0, 80.0]
+|| [344, 6, 1, 0, 2, 0.0, 75.0]
+|| [345, 6, 1, 0, 2, 0.0, 70.0]
+|| [346, 6, 1, 0, 2, 0.0, 55.0]
+|| [347, 6, 1, 0, 2, 0.0, 60.0]
+|| [348, 6, 1, 0, 2, 0.0, 65.0]
+|| [349, 6, 1, 0, 2, 0.0, 95.0]
+|| [350, 6, 1, 0, 2, 0.0, 0.0]
+|| [351, 6, 1, 0, 2, 0.0, 45.0]
+|| [352, 6, 1, 0, 2, 0.0, 0.0]
+|| [353, 6, 1, 0, 2, 0.0, 45.0]
+|| [354, 6, 1, 0, 2, 0.0, 45.0]
+|| [355, 6, 1, 0, 2, 0.0, 115.0]
+|| [356, 6, 1, 0, 2, 0.0, 70.0]
+|| [357, 6, 1, 0, 2, 0.0, 55.0]
+|| [358, 6, 1, 0, 2, 0.0, 0.0]
+|| [359, 6, 1, 0, 2, 0.0, 70.0]
+|| [360, 6, 1, 0, 2, 0.0, 115.0]
+|| [361, 6, 1, 0, 2, 0.0, 55.0]
+|| [362, 6, 1, 0, 2, 0.0, 0.0]
+|| [363, 6, 1, 0, 2, 0.0, 65.0]
+|| [364, 6, 1, 0, 2, 0.0, 45.0]
+|| [365, 6, 1, 0, 2, 0.0, 45.0]
+|| [366, 6, 1, 0, 2, 0.0, 95.0]
+|| [367, 6, 1, 0, 2, 0.0, 0.0]
+|| [368, 6, 1, 0, 2, 0.0, 45.0]
+|| [369, 6, 1, 0, 2, 0.0, 0.0]
+|| [370, 6, 1, 0, 2, 0.0, 0.0]
+|| [371, 6, 1, 0, 2, 0.0, 70.0]
+|| [372, 6, 1, 0, 2, 0.0, 55.0]
+|| [373, 6, 1, 0, 2, 0.0, 115.0]
+|| [374, 6, 1, 0, 2, 0.0, 75.0]
+|| [375, 6, 1, 0, 2, 0.0, 75.0]
+|| [376, 6, 1, 0, 2, 0.0, 75.0]
+|| [377, 6, 1, 0, 2, 0.0, 60.0]
+|| [378, 6, 1, 0, 2, 0.0, 75.0]
+|| [379, 6, 1, 0, 2, 0.0, 60.0]
+|| [380, 6, 1, 0, 2, 0.0, 60.0]
+|| [381, 6, 1, 0, 2, 0.0, 75.0]
+|| [382, 6, 1, 0, 2, 0.0, 60.0]
+|| [383, 6, 1, 0, 2, 0.0, 75.0]
+|| [384, 6, 1, 0, 2, 0.0, 60.0]
+|| [385, 6, 1, 0, 2, 0.0, 125.0]
+|| [386, 6, 1, 0, 2, 0.0, 125.0]
+|| [387, 6, 1, 0, 2, 0.0, 125.0]
+|| [388, 6, 1, 0, 2, 0.0, 75.0]
+|| [389, 6, 1, 0, 2, 0.0, 0.0]
+|| [390, 6, 1, 0, 2, 0.0, 45.0]
+|| [391, 6, 1, 0, 2, 0.0, 65.0]
+|| [392, 6, 1, 0, 2, 0.0, 0.0]
+|| [393, 6, 1, 0, 2, 0.0, 45.0]
+|| [394, 6, 1, 0, 2, 0.0, 45.0]
+|| [395, 6, 1, 0, 2, 0.0, 95.0]
+|| [396, 6, 1, 0, 2, 0.0, 45.0]
+|| [397, 6, 1, 0, 2, 0.0, 45.0]
+|| [398, 6, 1, 0, 2, 0.0, 0.0]
+|| [399, 6, 1, 0, 2, 0.0, 45.0]
+|| [400, 6, 1, 0, 2, 0.0, 95.0]
+|| [401, 6, 1, 0, 2, 0.0, 65.0]
+|| [402, 6, 1, 0, 2, 0.0, 0.0]
+|| [403, 6, 1, 0, 2, 0.0, 75.0]
+|| [404, 6, 1, 0, 2, 0.0, 60.0]
+|| [405, 6, 1, 0, 2, 0.0, 80.0]
+|| [406, 6, 1, 0, 2, 0.0, 15.0]
+|| [407, 6, 1, 0, 2, 0.0, 80.0]
+|| [408, 6, 1, 0, 2, 0.0, 80.0]
+|| [409, 6, 1, 0, 2, 0.0, 80.0]
+|| [410, 6, 1, 0, 2, 0.0, 65.0]
+|| [411, 6, 1, 0, 2, 0.0, 80.0]
+|| [412, 6, 1, 0, 2, 0.0, 65.0]
+|| [413, 6, 1, 0, 2, 0.0, 80.0]
+|| [414, 6, 1, 0, 2, 0.0, 65.0]
+|| [415, 6, 1, 0, 2, 0.0, 65.0]
+|| [416, 6, 1, 0, 2, 0.0, 80.0]
+|| [417, 6, 1, 0, 2, 0.0, 80.0]
+|| [418, 6, 1, 0, 2, 0.0, 85.0]
+|| [419, 6, 1, 0, 2, 0.0, 85.0]
+|| [420, 6, 1, 0, 2, 0.0, 85.0]
+|| [421, 6, 1, 0, 2, 0.0, 65.0]
+|| [422, 6, 1, 0, 2, 0.0, 80.0]
+|| [423, 6, 1, 0, 2, 0.0, 65.0]
+|| [424, 6, 1, 0, 2, 0.0, 45.0]
+|| [425, 6, 1, 0, 2, 0.0, 95.0]
+|| [426, 6, 1, 0, 2, 0.0, 65.0]
+|| [427, 6, 1, 0, 2, 0.0, 0.0]
+|| [428, 6, 1, 0, 2, 0.0, 45.0]
+|| [429, 6, 1, 0, 2, 0.0, 45.0]
+|| [430, 6, 1, 0, 2, 0.0, 0.0]
+|| [431, 6, 1, 0, 2, 0.0, 0.0]
+|| [432, 6, 1, 0, 2, 0.0, 45.0]
+|| [433, 6, 1, 0, 2, 0.0, 95.0]
+|| [434, 6, 1, 0, 2, 0.0, 65.0]
+|| [435, 6, 1, 0, 2, 0.0, 45.0]
+|| [436, 6, 1, 0, 2, 0.0, 45.0]
+|| [437, 6, 1, 0, 2, 0.0, 0.0]
+|| [438, 6, 1, 0, 2, 0.0, 60.0]
+|| [439, 6, 1, 0, 2, 0.0, 80.0]
+|| [440, 6, 1, 0, 2, 0.0, 125.0]
+|| [441, 6, 1, 0, 2, 0.0, 0.0]
+|| [442, 6, 1, 0, 2, 0.0, 85.0]
+|| [443, 6, 1, 0, 2, 0.0, 85.0]
+|| [444, 6, 1, 0, 2, 0.0, 65.0]
+|| [445, 6, 1, 0, 2, 0.0, 85.0]
+|| [446, 6, 1, 0, 2, 0.0, 85.0]
+|| [447, 6, 1, 0, 2, 0.0, 65.0]
+|| [448, 6, 1, 0, 2, 0.0, 65.0]
+|| [449, 6, 1, 0, 2, 0.0, 85.0]
+|| [450, 6, 1, 0, 2, 0.0, 85.0]
+|| [451, 6, 1, 0, 2, 0.0, 65.0]
+|| [452, 6, 1, 0, 2, 0.0, 85.0]
+|| [453, 6, 1, 0, 2, 0.0, 135.0]
+|| [454, 6, 1, 0, 2, 0.0, 85.0]
+|| [455, 6, 1, 0, 2, 0.0, 65.0]
+|| [456, 6, 1, 0, 2, 0.0, 85.0]
+|| [457, 6, 1, 0, 2, 0.0, 65.0]
+|| [458, 6, 1, 0, 2, 0.0, 135.0]
+|| [459, 6, 1, 0, 2, 0.0, 135.0]
+|| [460, 6, 1, 0, 2, 0.0, 65.0]
+|| [461, 6, 1, 0, 2, 0.0, 95.0]
+|| [462, 6, 1, 0, 2, 0.0, 65.0]
+|| [463, 6, 1, 0, 2, 0.0, 0.0]
+|| [464, 6, 1, 0, 2, 0.0, 45.0]
+|| [465, 6, 1, 0, 2, 0.0, 0.0]
+|| [466, 6, 1, 0, 2, 0.0, 45.0]
+|| [467, 6, 1, 0, 2, 0.0, 45.0]
+|| [468, 6, 1, 0, 2, 0.0, 85.0]
+|| [469, 6, 1, 0, 2, 0.0, 20.0]
+|| [470, 6, 1, 0, 2, 0.0, 65.0]
+|| [471, 6, 1, 0, 2, 0.0, 85.0]
+|| [472, 6, 1, 0, 2, 0.0, 90.0]
+|| [473, 6, 1, 0, 2, 0.0, 90.0]
+|| [474, 6, 1, 0, 2, 0.0, 70.0]
+|| [475, 6, 1, 0, 2, 0.0, 90.0]
+|| [476, 6, 1, 0, 2, 0.0, 90.0]
+|| [477, 6, 1, 0, 2, 0.0, 70.0]
+|| [478, 6, 1, 0, 2, 0.0, 90.0]
+|| [479, 6, 1, 0, 2, 0.0, 70.0]
+|| [480, 6, 1, 0, 2, 0.0, 70.0]
+|| [481, 6, 1, 0, 2, 0.0, 90.0]
+|| [482, 6, 1, 0, 2, 0.0, 90.0]
+|| [483, 6, 1, 0, 2, 0.0, 90.0]
+|| [484, 6, 1, 0, 2, 0.0, 90.0]
+|| [485, 6, 1, 0, 2, 0.0, 90.0]
+|| [486, 6, 1, 0, 2, 0.0, 70.0]
+|| [487, 6, 1, 0, 2, 0.0, 95.0]
+|| [488, 6, 1, 0, 2, 0.0, 45.0]
+|| [489, 6, 1, 0, 2, 0.0, 65.0]
+|| [490, 6, 1, 0, 2, 0.0, 0.0]
+|| [491, 6, 1, 0, 2, 0.0, 45.0]
+|| [492, 6, 1, 0, 2, 0.0, 0.0]
+|| [493, 6, 1, 0, 2, 0.0, 45.0]
+|| [494, 6, 1, 0, 2, 0.0, 0.0]
+|| [495, 6, 1, 0, 2, 0.0, 45.0]
+|| [496, 6, 1, 0, 2, 0.0, 65.0]
+|| [497, 6, 1, 0, 2, 0.0, 95.0]
+|| [498, 6, 1, 0, 2, 0.0, 45.0]
+|| [499, 6, 1, 0, 2, 0.0, 0.0]
+|| [500, 6, 1, 0, 2, 0.0, 45.0]
+|| [501, 6, 1, 0, 2, 0.0, 0.0]
+|| [502, 6, 1, 0, 2, 0.0, 90.0]
+|| [503, 6, 1, 0, 2, 0.0, 135.0]
+|| [504, 6, 1, 0, 2, 0.0, 65.0]
+|| [505, 6, 1, 0, 2, 0.0, 0.0]
+|| [506, 6, 1, 0, 2, 0.0, 65.0]
+|| [507, 6, 1, 0, 2, 0.0, 135.0]
+|| [508, 6, 1, 0, 2, 0.0, 90.0]
+
+
+#TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER);
+|| SELECT * FROM Z_PRIMARYKEY;
+|| [1, "BaseWorkout", 0, 21]
+|| [2, "Exercise", 0, 175]
+|| [3, "ExerciseSets", 0, 80]
+|| [4, "Plate", 0, 10]
+|| [5, "Warmup", 0, 34]
+|| [6, "Weight", 0, 508]
+
+#TABLE ZBASEWORKOUT ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZONGOING INTEGER, ZTEMPORARY INTEGER, ZTYPE INTEGER, ZDATE TIMESTAMP, ZBODYWEIGHT VARCHAR, ZLOGDATE VARCHAR, ZNOTE VARCHAR, ZINFO BLOB );
+|| SELECT * FROM ZBASEWORKOUT;
+|| [5, 1, 4, nil, 0, 1, 452264525.977147, "160LB", "May 2, 2015", nil, nil]
+|| [9, 1, 2, nil, 0, 2, 452436850.911099, "160LB", "May 4, 2015", nil, nil]
+|| [10, 1, 2, nil, 0, 1, 452609689.385812, "160LB", "May 6, 2015", nil, nil]
+|| [13, 1, 1, nil, 0, 2, 452782971.26366, "160LB", "May 8, 2015", nil, nil]
+|| [15, 1, 4, nil, 0, 1, 452957751.342435, "163.5LB", "May 10, 2015", nil, nil]
+|| [18, 1, 3, nil, 0, 2, 453127706.174001, "164LB", "May 12, 2015", nil, nil]
+|| [19, 1, 3, nil, 0, 1, 453300411.208719, "163LB", "May 14, 2015", nil, nil]
+|| [20, 1, 3, nil, 0, 2, 453475090.654825, "162.5LB", "May 16, 2015", nil, nil]
+|| [21, 1, 3, nil, 0, 1, 453732853.702099, "165LB", "May 19, 2015", nil, nil]