

CREATE TABLE `clients` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(22) NOT NULL,
  `url` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `stateOrCountry` varchar(255) NOT NULL,
  `contact` enum('phone','email') NOT NULL,
  `websiteService` set('SITE DESIGN','SITE REDESIGN','ONLINE STORE','MARKETING','MAINTENANCE') NOT NULL,
  `programmingService` set('HTML/DHTML','CGI/PERL/C/C++','JAVA','ASP','XML') NOT NULL,
  `databaseService` set('ACCESS','SQL','SYBASE','ORACLE') NOT NULL,
  `multimediaService` set('FLASH','QUICKTIME','MEDIA PLAYER','REAL') NOT NULL,
  `corporateDesignService` set('MARKETING','LOGOS','PACKAGING','ANNUAL REPORTS') NOT NULL,
  `otherService` varchar(255) NOT NULL,
  `comments` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO clients VALUES("1","test name","company x","testname@companyx.com","6195559999","companyx.com","los angeles","ca","email","SITE DESIGN,SITE REDESIGN,MARKETING","CGI/PERL/C/C++,JAVA","SQL,ORACLE","QUICKTIME","LOGOS","","Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris non sapien ac urna fringilla malesuada non sed ante. Sed quis ornare velit. Duis cursus tristique sagittis. Aenean pharetra turpis ligula, eu mattis nunc venenatis mattis. Morbi tempor, felis sit amet tempor tincidunt, odio enim viverra leo, vitae mollis odio ex vel eros. Donec et lectus est. Sed posuere at leo ac rhoncus. Cras suscipit, risus eget luctus suscipit, ligula libero maximus lectus, sit amet porttitor quam est cursus ante. Sed vulputate, ligula vitae suscipit sodales, leo justo ornare arcu, ac volutpat sapien lectus eu lacus. Praesent pulvinar massa in nisi suscipit mattis. Fusce posuere justo sem, quis laoreet ligula pellentesque non. Cras imperdiet arcu ut dui auctor commodo.

");



CREATE TABLE `locmeasures` (
  `userid` int(5) NOT NULL,
  `height` int(10) NOT NULL,
  `weight` varchar(255) NOT NULL,
  `bodytype` int(5) NOT NULL,
  `activity` int(5) NOT NULL,
  `dayofassess` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO locmeasures VALUES("1","72","235","2","5","2014-06-05");
INSERT INTO locmeasures VALUES("2","72","200","2","2","2014-07-19");
INSERT INTO locmeasures VALUES("3","70","190","2","3","2014-07-20");



CREATE TABLE `locperformance` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userid` int(5) NOT NULL,
  `exercise` varchar(255) NOT NULL,
  `target` varchar(255) NOT NULL,
  `dateofperformance` date NOT NULL,
  `completed` enum('no','yes') NOT NULL,
  `coachid` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO locperformance VALUES("1","1","100 Sit Ups","Abdomen","2014-06-27","yes","2");
INSERT INTO locperformance VALUES("2","1","Walk Briskly 2 miles","Cardio","2014-06-28","no","2");
INSERT INTO locperformance VALUES("3","1","25 Pushups","Arms","2014-06-29","no","4");
INSERT INTO locperformance VALUES("4","1","10 Pullups","Chest and Arms","2014-06-28","no","4");
INSERT INTO locperformance VALUES("5","3","pull ups","back","2014-07-22","no","7");
INSERT INTO locperformance VALUES("6","3","no carbs after lunch","nutrition","2014-07-22","no","7");
INSERT INTO locperformance VALUES("7","3","push ups","Chest ","2014-07-22","no","7");
INSERT INTO locperformance VALUES("8","1","15 Crunches","Cardio","2014-07-23","no","2");
INSERT INTO locperformance VALUES("9","3","Air Squats","Legs","2014-07-31","no","7");
INSERT INTO locperformance VALUES("10","3","Air Squats","Legs","2014-07-31","no","7");



CREATE TABLE `locprofile` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `memberid` int(5) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `gender` enum('male','female') NOT NULL,
  `coachid` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO locprofile VALUES("1","1","Kris Secor","kdsecor@gmail.com","1970-08-13","male","2");
INSERT INTO locprofile VALUES("2","2","John Smith","ksecor@colemand.edu","1970-08-13","male","0");
INSERT INTO locprofile VALUES("3","3","Michael Mascia","mrmascia@gmail.com","1981-05-16","male","7");



CREATE TABLE `locuseractions` (
  `userid` int(5) NOT NULL,
  `food` text NOT NULL,
  `calories` int(255) NOT NULL,
  `fat` decimal(5,2) NOT NULL,
  `carbs` decimal(5,2) NOT NULL,
  `protein` decimal(5,2) NOT NULL,
  `activitydate` datetime /* mariadb-5.3 */ NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO locuseractions VALUES("1","Egg McMuffin","210","3.00","10.00","4.00","2014-07-01 00:00:00");
INSERT INTO locuseractions VALUES("1","hamburger","260","12.00","12.00","12.00","2014-07-01 00:00:00");
INSERT INTO locuseractions VALUES("1","hamburger","260","12.00","12.00","12.00","2014-07-01 00:00:00");
INSERT INTO locuseractions VALUES("1","Ice Cream","400","12.00","12.00","3.00","2014-07-01 00:00:00");

