Alguem me pode ajudar a actualizar o dump mysql
ficheiro:
# MySQL dump 7.1 # # Host: localhost Database: workout #-------------------------------------------------------- # Server version 3.22.32 # # Table structure for table 'activation' # CREATE TABLE activation ( userid int(11) DEFAULT '0' NOT NULL, code varchar(100) DEFAULT '' NOT NULL, record date DEFAULT '0000-00-00' NOT NULL ); # # Table structure for table 'comments' # CREATE TABLE comments ( id int(11) DEFAULT '0' NOT NULL auto_increment, user tinyint(4) DEFAULT '0' NOT NULL, record date DEFAULT '0000-00-00' NOT NULL, comments text, PRIMARY KEY (id), KEY user (user,record) ); # # Table structure for table 'measurements' # CREATE TABLE measurements ( id int(11) DEFAULT '0' NOT NULL auto_increment, user tinyint(4) DEFAULT '0' NOT NULL, record date DEFAULT '0000-00-00' NOT NULL, muscle_group int(11) DEFAULT '0' NOT NULL, measurement float(10,2) DEFAULT '0.00' NOT NULL, unit char(5) DEFAULT '' NOT NULL, PRIMARY KEY (id), KEY user (user,record) ); # # Table structure for table 'routine' # CREATE TABLE routine ( id int(4) DEFAULT '0' NOT NULL auto_increment, day_number tinyint(4) DEFAULT '0' NOT NULL, exercises char(50) DEFAULT '' NOT NULL, user tinyint(4), routine varchar(20), PRIMARY KEY (id), KEY id (id) ); # # Table structure for table 'users' # CREATE TABLE users ( id int(4) DEFAULT '0' NOT NULL auto_increment, user varchar(15) DEFAULT '' NOT NULL, num_of_days tinyint(4) DEFAULT '0' NOT NULL, password varchar(100) DEFAULT '' NOT NULL, admin tinyint(4) DEFAULT '0' NOT NULL, active tinyint(4) DEFAULT '0' NOT NULL, email varchar(75) DEFAULT '' NOT NULL, PRIMARY KEY (id) ); # # Table structure for table 'weight' # CREATE TABLE weight ( id int(11) DEFAULT '0' NOT NULL auto_increment, record date DEFAULT '0000-00-00' NOT NULL, weight float(10,2) DEFAULT '0.00' NOT NULL, user tinyint(4) DEFAULT '1' NOT NULL, KEY user (user), PRIMARY KEY (id), KEY record (record) ); # # Table structure for table 'workouts' # CREATE TABLE workouts ( id int(4) DEFAULT '0' NOT NULL auto_increment, record date DEFAULT '0000-00-00' NOT NULL, exercise tinyint(4) DEFAULT '0' NOT NULL, set_number tinyint(4) DEFAULT '0' NOT NULL, reps tinyint(4) DEFAULT '0' NOT NULL, weight float(10,2) DEFAULT '0.00' NOT NULL, day_number tinyint(4) DEFAULT '0' NOT NULL, user tinyint(4) DEFAULT '1' NOT NULL, PRIMARY KEY (id), KEY record (record), KEY user (user) ); # # Table structure for table muscle_group # CREATE TABLE muscle_group ( id tinyint(4) DEFAULT '0' NOT NULL auto_increment, name char(50) NOT NULL, PRIMARY KEY (id), KEY id (id) ); # # Table structure for table exercise_links # CREATE TABLE exercise_links ( exercise_id int(11) DEFAULT '0' NOT NULL, link varchar(75) NOT NULL, KEY exercise_id (exercise_id) ); # # Dumping data for table muscle_group # INSERT INTO muscle_group (id, name) VALUES (1, 'Chest'); INSERT INTO muscle_group (id, name) VALUES (2, 'Lats'); INSERT INTO muscle_group (id, name) VALUES (3, 'Shoulders'); INSERT INTO muscle_group (id, name) VALUES (4, 'Lower Back'); INSERT INTO muscle_group (id, name) VALUES (5, 'Biceps'); INSERT INTO muscle_group (id, name) VALUES (6, 'Triceps'); INSERT INTO muscle_group (id, name) VALUES (7, 'Quadriceps'); INSERT INTO muscle_group (id, name) VALUES (8, 'Calfs'); # # Table structure for table exercises # CREATE TABLE exercises ( id tinyint(4) DEFAULT '0' NOT NULL auto_increment, muscle_group tinyint(4) DEFAULT '0' NOT NULL, name char(50) NOT NULL, PRIMARY KEY (id) ); # # Dumping data for table exercises # INSERT INTO exercises (id, muscle_group, name) VALUES (1, 1, 'Flat Bench'); INSERT INTO exercises (id, muscle_group, name) VALUES (2, 1, 'Incline Bench'); INSERT INTO exercises (id, muscle_group, name) VALUES (3, 1, 'Decline Bench'); INSERT INTO exercises (id, muscle_group, name) VALUES (4, 7, 'Leg Extension'); INSERT INTO exercises (id, muscle_group, name) VALUES (5, 7, 'Leg Curl'); INSERT INTO exercises (id, muscle_group, name) VALUES (6, 7, 'Leg Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (7, 8, 'Calf Raise'); INSERT INTO exercises (id, muscle_group, name) VALUES (8, 4, 'Lower Back Ext'); INSERT INTO exercises (id, muscle_group, name) VALUES (9, 2, 'Lat Pulldown'); INSERT INTO exercises (id, muscle_group, name) VALUES (10, 2, 'Scap Retraction'); INSERT INTO exercises (id, muscle_group, name) VALUES (11, 5, 'Standing Curl'); INSERT INTO exercises (id, muscle_group, name) VALUES (12, 5, 'Reverse Curl'); INSERT INTO exercises (id, muscle_group, name) VALUES (13, 6, 'Pushdown'); INSERT INTO exercises (id, muscle_group, name) VALUES (14, 6, 'French Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (15, 1, 'Chest Fly'); INSERT INTO exercises (id, muscle_group, name) VALUES (16, 3, 'Shoulder Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (17, 3, 'Rear Deltoid Row'); INSERT INTO exercises (id, muscle_group, name) VALUES (18, 3, 'Lateral Shoulder Raise'); INSERT INTO exercises (id, muscle_group, name) VALUES (19, 3, 'Pull Up'); INSERT INTO exercises (id, muscle_group, name) VALUES (20, 5, 'Preacher Curl'); INSERT INTO exercises (id, muscle_group, name) VALUES (21, 7, 'Squat'); INSERT INTO exercises (id, muscle_group, name) VALUES (22, 6, 'Rope French Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (23, 2, 'Hammer Lat Pulldown'); INSERT INTO exercises (id, muscle_group, name) VALUES (24, 3, 'Upright Row'); INSERT INTO exercises (id, muscle_group, name) VALUES (25, 1, 'Barbell Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (26, 3, 'Shrugs'); INSERT INTO exercises (id, muscle_group, name) VALUES (27, 7, 'Hack Squat'); INSERT INTO exercises (id, muscle_group, name) VALUES (28, 4, 'Dead Lift'); INSERT INTO exercises (id, muscle_group, name) VALUES (29, 1, 'iso wide chest'); INSERT INTO exercises (id, muscle_group, name) VALUES (30, 1, 'Chest Fly / Ball'); INSERT INTO exercises (id, muscle_group, name) VALUES (31, 1, 'Split Stance Alternating D.B. Pushing Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (32, 2, 'Single arm/leg bent-over D.B. row'); INSERT INTO exercises (id, muscle_group, name) VALUES (33, 7, 'Standing alternating lateral lunge'); INSERT INTO exercises (id, muscle_group, name) VALUES (34, 1, 'Supine alternating D.B. chest press / Ball'); INSERT INTO exercises (id, muscle_group, name) VALUES (35, 7, 'Standing alternating lunge'); INSERT INTO exercises (id, muscle_group, name) VALUES (36, 6, 'Standing straight arm high cable row'); INSERT INTO exercises (id, muscle_group, name) VALUES (37, 1, 'Split stance alternating cable row'); INSERT INTO exercises (id, muscle_group, name) VALUES (38, 1, 'Incline D.B. pushing press / Ball'); INSERT INTO exercises (id, muscle_group, name) VALUES (39, 4, 'Standing D.B. romanian style deadlift'); INSERT INTO exercises (id, muscle_group, name) VALUES (40, 2, 'Seated high cable row'); INSERT INTO exercises (id, muscle_group, name) VALUES (41, 6, 'Machine Pushdown'); INSERT INTO exercises (id, muscle_group, name) VALUES (43, 5, 'Hammer Curls'); INSERT INTO exercises (id, muscle_group, name) VALUES (44, 6, 'Dumbell Extention'); INSERT INTO exercises (id, muscle_group, name) VALUES (45, 7, 'Standing D.B. Squat'); INSERT INTO exercises (id, muscle_group, name) VALUES (46, 4, 'Seated High Cable Row'); INSERT INTO exercises (id, muscle_group, name) VALUES (47, 1, 'Incline D.B. Pushing Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (48, 1, 'Split Stance Alternating Cable Row'); INSERT INTO exercises (id, muscle_group, name) VALUES (49, 1, 'Split Stance Cable Chest Fly'); INSERT INTO exercises (id, muscle_group, name) VALUES (50, 6, 'Kick Backs'); INSERT INTO exercises (id, muscle_group, name) VALUES (51, 5, 'Seated Curls'); INSERT INTO exercises (id, muscle_group, name) VALUES (52, 8, 'Calf Press'); INSERT INTO exercises (id, muscle_group, name) VALUES (53, 6, 'Cable Kick Backs');
