 -- --------------------------------------------------------
 
 --
--- Table structure for table `supercategories`
---
-
-CREATE TABLE `supercategories` (
+-- Table structure for table `super_item_categories`
+--
+
+DROP TABLE IF EXISTS `super_item_categories`;
+CREATE TABLE `super_item_categories` (
   `superCategoryId` int(11) NOT NULL,
   `superCategoryName` varchar(45) NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `supercategories`
---
-
-INSERT INTO `supercategories` (`superCategoryId`, `superCategoryName`) VALUES
+) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `super_item_categories`
+--
+
+INSERT INTO `super_item_categories` (`superCategoryId`, `superCategoryName`) VALUES
 (1, 'Collectables & Antiques'),
 (2, 'Home & Garden'),
 (3, 'Sporting Goods'),

--
-- Database: `auctionsystem`
--
DROP DATABASE IF EXISTS `auctionsystem`;
CREATE DATABASE IF NOT EXISTS `auctionsystem` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `auctionsystem`;
-- --------------------------------------------------------

--
-- Table structure for table `auctions`
--

-- DROP TABLE IF EXISTS `auctions`;
CREATE TABLE IF NOT EXISTS `auctions` (
  `auctionId` int(11) NOT NULL,
  `itemId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `bidId` int(11) DEFAULT NULL,
  `quantity` int(11) unsigned NOT NULL DEFAULT '1',
  `startPrice` decimal(10,2) unsigned NOT NULL,
  `reservePrice` decimal(10,2) unsigned NOT NULL,

-- Table structure for table `feedbacks`
--

DROP TABLE IF EXISTS `feedbacks`;
CREATE TABLE `feedbacks` (
  `feedbackId` int(11) NOT NULL,
  `auctionId` int(11) NOT NULL,
  `receiverId` int(11) NOT NULL,
