text: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  --
  -- Database: `searchAndDeploy`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `items`
  --
  
  CREATE TABLE `items` (
    `partId` int(11) NOT NULL,
    `partName` varchar(255) NOT NULL,
    `location` varchar(255) NOT NULL,
    `xCoordinate` int(11) NOT NULL,
    `yCoordinate` int(11) NOT NULL,
    `tags` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `items`
  --
  ALTER TABLE `items`
    ADD PRIMARY KEY (`partId`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `items`
  --
  ALTER TABLE `items`
    MODIFY `partId` int(11) NOT NULL AUTO_INCREMENT;
  