CREATE DATABASE `emc`;

USE `emc`;

CREATE TABLE `gcode` (
  `gcid` int(11) NOT NULL auto_increment,
  `category` varchar(50) NOT NULL default '',
  `partname` varchar(50) NOT NULL default '',
  `gcode` mediumtext NOT NULL,
  PRIMARY KEY  (`gcid`)
) ENGINE=MyISAM ;

INSERT INTO `gcode` VALUES (1,'mill','mill test','\nG17 G21 G40 G61 G91\nG0 Z0.0 F400\nG90\nG0 X0 Y0 F400\nG91\nG0 Z-5.0\nG1 Z-3.0 F400\nG1 X0.0 Y55\nG2 X10.0 Y10.0 I10.0 J0\nG1 X80 Y0.0\nG2 X10.0 Y-10 I0 J-10\nG1 X0.0 Y-55\nG2 X-10 Y-10 I-10 J0\nG1 X-80 Y0.0\nG2 X-10 Y10.0 I0 J10.0\nG1 Z-3.0 F400\nG1 X0.0 Y55\nG2 X10.0 Y10.0 I10.0 J0\nG1 X80 Y0.0\nG2 X10.0 Y-10 I0 J-10\nG1 X0.0 Y-55\nG2 X-10 Y-10 I-10 J0\nG1 X-80 Y0.0\nG2 X-10 Y10.0 I0 J10.0\nG1 Z-3.0 F400\nG1 X0.0 Y55\nG2 X10.0 Y10.0 I10.0 J0\nG1 X80 Y0.0\nG2 X10.0 Y-10 I0 J-10\nG1 X0.0 Y-55\nG2 X-10 Y-10 I-10 J0\nG1 X-80 Y0.0\nG2 X-10 Y10.0 I0 J10.0\nG1 Z9.0\nG0 Z5.0\nG90\nG0 X0.0 Y0.0 F400\nG91\nM30\n');