/*
 Navicat Premium Data Transfer

 Source Server         : demo_1
 Source Server Type    : MySQL
 Source Server Version : 50553 (5.5.53)
 Source Host           : localhost:3306
 Source Schema         : auction_system

 Target Server Type    : MySQL
 Target Server Version : 50553 (5.5.53)
 File Encoding         : 65001

 Date: 19/10/2024 19:07:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bids
-- ----------------------------
DROP TABLE IF EXISTS `bids`;
CREATE TABLE `bids`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NULL DEFAULT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  `bid_amount` decimal(10, 2) NOT NULL,
  `bid_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `item_id`(`item_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of bids
-- ----------------------------
INSERT INTO `bids` VALUES (1, 2, 1, 5.40, '2024-10-16 13:33:40');
INSERT INTO `bids` VALUES (2, 1, 2, 150.00, '2024-10-16 21:33:40');
INSERT INTO `bids` VALUES (3, 2, 3, 200.00, '2024-10-16 21:33:40');
INSERT INTO `bids` VALUES (4, 3, 4, 75.00, '2024-10-16 21:33:40');
INSERT INTO `bids` VALUES (6, 1, 0, 2.40, '2023-10-16 13:33:40');

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `item_id` int(11) NULL DEFAULT NULL,
  `comment_text` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `item_id`(`item_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES (1, 1, 1, 'Great item!', '2024-10-16 21:33:35');
INSERT INTO `comments` VALUES (2, 2, 1, 'Looking forward to using this.', '2024-10-16 21:33:35');
INSERT INTO `comments` VALUES (3, 3, 2, 'Not bad, but can be better.', '2024-10-16 21:33:35');
INSERT INTO `comments` VALUES (4, 4, 2, 'I love this product!', '2024-10-16 21:33:35');
INSERT INTO `comments` VALUES (5, 5, 3, 'Good quality, would recommend.', '2024-10-16 21:33:35');

-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `seller_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `seller_id`(`seller_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES (7, 'Item12', 'Description for Item 12', 1);
INSERT INTO `items` VALUES (2, 'Item2', 'Description for Item 2', 2);
INSERT INTO `items` VALUES (3, 'Item3', 'Description for Item 3', 3);
INSERT INTO `items` VALUES (4, 'Item4', 'Description for Item 4', 4);
INSERT INTO `items` VALUES (5, 'Item5', 'Description for Item 5', 5);
INSERT INTO `items` VALUES (6, '111', '111', 111);
INSERT INTO `items` VALUES (8, 'Item12', 'Description for Item 12', 1);

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  UNIQUE INDEX `email`(`email`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'updatedUser', 'newPass', 'updated@example.com');
INSERT INTO `users` VALUES (2, 'user2', 'password2', 'user2@example.com');
INSERT INTO `users` VALUES (3, 'user3', 'password3', 'user3@example.com');
INSERT INTO `users` VALUES (4, 'user4', 'password4', 'user4@example.com');
INSERT INTO `users` VALUES (5, 'user5', 'password5', 'user5@example.com');
INSERT INTO `users` VALUES (6, 'testUser', 'testPass', 'test@example.com');

SET FOREIGN_KEY_CHECKS = 1;