SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `Lernpfade`
--

-- --------------------------------------------------------

--
-- Table structure for table `CRUD`
--

CREATE TABLE `CRUD` (
  `ID` int(4) NOT NULL,
  `vorname` varchar(48) NOT NULL,
  `nachname` varchar(48) NOT NULL,
  `bemerkungen` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `CRUD`
--
ALTER TABLE `CRUD`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `CRUD`
--
ALTER TABLE `CRUD`
  MODIFY `ID` int(4) NOT NULL AUTO_INCREMENT;
COMMIT;