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

--
-- Table structure for table `rec_admin`
--

CREATE TABLE `rec_admin` (
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rec_comments`
--

CREATE TABLE `rec_comments` (
  `id` int(5) NOT NULL,
  `userid` int(5) NOT NULL,
  `comment` text NOT NULL,
  `recipeid` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rec_ipaddress`
--

CREATE TABLE `rec_ipaddress` (
  `userid` int(5) NOT NULL,
  `commentid` int(5) NOT NULL,
  `ipaddress` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rec_recipes`
--

CREATE TABLE `rec_recipes` (
  `id` int(5) NOT NULL,
  `recipetitle` varchar(255) NOT NULL,
  `recipedescription` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rec_users`
--

CREATE TABLE `rec_users` (
  `id` int(5) NOT NULL,
  `username` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rec_comments`
--
ALTER TABLE `rec_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rec_recipes`
--
ALTER TABLE `rec_recipes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rec_users`
--
ALTER TABLE `rec_users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rec_comments`
--
ALTER TABLE `rec_comments`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `rec_recipes`
--
ALTER TABLE `rec_recipes`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `rec_users`
--
ALTER TABLE `rec_users`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;