-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.5.0.6677
-- --------------------------------------------------------


-- Dumping structure for table nigger.nig_cpu
CREATE TABLE IF NOT EXISTS `nig_cpu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_cpu: ~30 rows (approximately)
INSERT INTO `nig_cpu` (`id`, `name`) VALUES
	(19, 'Intel Core i9-10900K'),
	(20, 'AMD Ryzen 9 5900X'),
	(21, 'Intel Core i7-10700K'),
	(22, 'AMD Ryzen 7 5800X'),
	(23, 'Intel Core i5-10600K'),
	(24, 'AMD Ryzen 5 5600X'),
	(25, 'Intel Core i9-11900K'),
	(26, 'AMD Ryzen 9 5950X'),
	(27, 'Intel Core i7-11700K'),
	(28, 'AMD Ryzen 7 5700X'),
	(29, 'Intel Core i5-11400'),
	(30, 'AMD Ryzen 5 5600'),
	(31, 'Intel Core i9-9900K'),
	(32, 'AMD Ryzen 9 3900X'),
	(33, 'Intel Core i7-9700K'),
	(34, 'AMD Ryzen 7 3800X'),
	(35, 'Intel Core i5-9600K'),
	(36, 'AMD Ryzen 5 3600X'),
	(37, 'Intel Core i9-10980XE'),
	(38, 'AMD Ryzen Threadripper 3990X'),
	(39, 'Intel Core i7-9750H'),
	(40, 'AMD Ryzen 7 3700X'),
	(41, 'Intel Core i5-9400F'),
	(42, 'AMD Ryzen 5 3500X'),
	(43, 'Intel Core i9-10850K'),
	(44, 'AMD Ryzen 9 3900XT'),
	(45, 'Intel Core i7-8700K'),
	(46, 'AMD Ryzen 7 2700X'),
	(47, 'Intel Core i5-8400'),
	(48, 'AMD Ryzen 5 2600X');

-- Dumping structure for table nigger.nig_gpu
CREATE TABLE IF NOT EXISTS `nig_gpu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_gpu: ~30 rows (approximately)
INSERT INTO `nig_gpu` (`id`, `name`) VALUES
	(19, 'GTX 1080'),
	(20, 'RTX 2080'),
	(21, 'GTX 1060'),
	(22, 'RX 5700 XT'),
	(23, 'RTX 3070'),
	(24, 'RX 580'),
	(25, 'GTX 1660 Ti'),
	(26, 'RTX 3090'),
	(27, 'GTX 1050 Ti'),
	(28, 'RX 5600 XT'),
	(29, 'GTX 1070'),
	(30, 'RX 590'),
	(31, 'RTX 3060'),
	(32, 'GTX 1660 Super'),
	(33, 'RX 5500 XT'),
	(34, 'GTX 980'),
	(35, 'RX 570'),
	(36, 'GTX 960'),
	(37, 'RX 560'),
	(38, 'GTX 970'),
	(39, 'RTX 2060'),
	(40, 'RX 550'),
	(41, 'GTX 750 Ti'),
	(42, 'GTX 1650 Super'),
	(43, 'RX 480'),
	(44, 'RTX 2080 Ti'),
	(45, 'GTX 780'),
	(46, 'RX 470'),
	(47, 'RTX 3080'),
	(48, 'GTX 770');

-- Dumping structure for table nigger.nig_motherboard
CREATE TABLE IF NOT EXISTS `nig_motherboard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_motherboard: ~30 rows (approximately)
INSERT INTO `nig_motherboard` (`id`, `name`) VALUES
	(19, 'ASUS ROG Strix Z590-E Gaming'),
	(20, 'MSI MPG B550 Gaming Edge WiFi'),
	(21, 'GIGABYTE Z490 AORUS Master'),
	(22, 'ASRock B450M Steel Legend'),
	(23, 'MSI MAG X570 TOMAHAWK WiFi'),
	(24, 'ASUS TUF Gaming B460-PLUS'),
	(25, 'MSI MPG Z390 GAMING PRO CARBON AC'),
	(26, 'ASRock B550 Phantom Gaming 4'),
	(27, 'GIGABYTE B450 AORUS Elite'),
	(28, 'ASUS Prime X570-P'),
	(29, 'ASRock X570 Taichi'),
	(30, 'MSI MPG B450 Gaming Pro Carbon AC'),
	(31, 'GIGABYTE Z390 AORUS PRO WIFI'),
	(32, 'ASUS ROG Crosshair VIII Hero'),
	(33, 'MSI MAG B550 TOMAHAWK'),
	(34, 'ASRock Z490 Extreme4'),
	(35, 'GIGABYTE B550 AORUS Elite'),
	(36, 'ASUS Prime B450M-A/CSM'),
	(37, 'MSI MEG X570 ACE'),
	(38, 'ASRock X570 Steel Legend'),
	(39, 'GIGABYTE B450M DS3H'),
	(40, 'ASUS ROG Strix B450-F Gaming'),
	(41, 'MSI MAG B550M Mortar WiFi'),
	(42, 'GIGABYTE Z390 Gaming X'),
	(43, 'ASRock B550M Pro4'),
	(44, 'ASUS TUF Gaming X570-Plus (Wi-Fi 6)'),
	(45, 'MSI B450 TOMAHAWK MAX'),
	(46, 'GIGABYTE Z590 UD AC'),
	(47, 'ASRock B450 Pro4'),
	(48, 'ASUS Prime Z390-A');

-- Dumping structure for table nigger.nig_pcs
CREATE TABLE IF NOT EXISTS `nig_pcs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `pc_name` varchar(255) DEFAULT NULL,
  `cpu_id` int(11) DEFAULT NULL,
  `gpu_id` int(11) DEFAULT NULL,
  `ram_id` int(11) DEFAULT NULL,
  `storage_id` int(11) DEFAULT NULL,
  `motherboard_id` int(11) DEFAULT NULL,
  `power_supply_id` int(11) DEFAULT NULL,
  `pc_case_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `cpu_id` (`cpu_id`),
  KEY `gpu_id` (`gpu_id`),
  KEY `ram_id` (`ram_id`),
  KEY `storage_id` (`storage_id`),
  KEY `motherboard_id` (`motherboard_id`),
  KEY `power_supply_id` (`power_supply_id`),
  KEY `pc_case_id` (`pc_case_id`),
  CONSTRAINT `nig_pcs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nig_login` (`id`),
  CONSTRAINT `nig_pcs_ibfk_2` FOREIGN KEY (`cpu_id`) REFERENCES `nig_cpu` (`id`),
  CONSTRAINT `nig_pcs_ibfk_3` FOREIGN KEY (`gpu_id`) REFERENCES `nig_gpu` (`id`),
  CONSTRAINT `nig_pcs_ibfk_4` FOREIGN KEY (`ram_id`) REFERENCES `nig_ram` (`id`),
  CONSTRAINT `nig_pcs_ibfk_5` FOREIGN KEY (`storage_id`) REFERENCES `nig_storage` (`id`),
  CONSTRAINT `nig_pcs_ibfk_6` FOREIGN KEY (`motherboard_id`) REFERENCES `nig_motherboard` (`id`),
  CONSTRAINT `nig_pcs_ibfk_7` FOREIGN KEY (`power_supply_id`) REFERENCES `nig_power_supply` (`id`),
  CONSTRAINT `nig_pcs_ibfk_8` FOREIGN KEY (`pc_case_id`) REFERENCES `nig_pc_case` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_pcs: ~0 rows (approximately)
INSERT INTO `nig_pcs` (`id`, `user_id`, `pc_name`, `cpu_id`, `gpu_id`, `ram_id`, `storage_id`, `motherboard_id`, `power_supply_id`, `pc_case_id`) VALUES
	(29, 1, 'adad', 38, 26, 33, 34, 44, 41, 42);

-- Dumping structure for table nigger.nig_pc_case
CREATE TABLE IF NOT EXISTS `nig_pc_case` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_pc_case: ~30 rows (approximately)
INSERT INTO `nig_pc_case` (`id`, `name`) VALUES
	(19, 'NZXT H510i'),
	(20, 'Corsair Crystal 570X RGB'),
	(21, 'Fractal Design Meshify C'),
	(22, 'Phanteks Eclipse P400A'),
	(23, 'Cooler Master MasterBox Q300L'),
	(24, 'NZXT H710i'),
	(25, 'Lian Li O11 Dynamic'),
	(26, 'Thermaltake View 71 TG RGB'),
	(27, 'be quiet! Dark Base 700'),
	(28, 'Corsair iCUE 4000X RGB'),
	(29, 'NZXT H510 Elite'),
	(30, 'Fractal Design Define R6'),
	(31, 'Phanteks Enthoo Pro II'),
	(32, 'Cooler Master Cosmos C700M'),
	(33, 'NZXT H210i'),
	(34, 'Lian Li PC-O11DW'),
	(35, 'Thermaltake Core P3'),
	(36, 'be quiet! Pure Base 500DX'),
	(37, 'Corsair Obsidian 500D RGB SE'),
	(38, 'NZXT H200i'),
	(39, 'Fractal Design Define 7'),
	(40, 'Phanteks Eclipse P600S'),
	(41, 'Cooler Master MasterCase H500P Mesh'),
	(42, 'NZXT H510i Elite'),
	(43, 'Lian Li PC-O11 Dynamic XL'),
	(44, 'Thermaltake Level 20 GT'),
	(45, 'be quiet! Dark Base Pro 900 Rev. 2'),
	(46, 'Corsair 5000D Airflow'),
	(47, 'NZXT H510 Compact ATX Mid-Tower'),
	(48, 'Fractal Design Meshify S2');

-- Dumping structure for table nigger.nig_power_supply
CREATE TABLE IF NOT EXISTS `nig_power_supply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_power_supply: ~30 rows (approximately)
INSERT INTO `nig_power_supply` (`id`, `name`) VALUES
	(20, 'EVGA SuperNOVA 750 G3'),
	(21, 'Corsair RM750x'),
	(22, 'Seasonic Focus GX-750'),
	(23, 'Thermaltake Toughpower Grand RGB 750W'),
	(24, 'be quiet! Straight Power 11 750W'),
	(25, 'NZXT C750'),
	(26, 'Cooler Master MWE Gold 750W'),
	(27, 'SilverStone Strider Gold S 750W'),
	(28, 'Antec Earthwatts Gold Pro 750W'),
	(29, 'GIGABYTE P750GM'),
	(30, 'EVGA SuperNOVA 850 G3'),
	(31, 'Corsair RM850x'),
	(32, 'Seasonic Focus GX-850'),
	(33, 'Thermaltake Toughpower Grand RGB 850W'),
	(34, 'be quiet! Straight Power 11 850W'),
	(35, 'NZXT C850'),
	(36, 'Cooler Master MWE Gold 850W'),
	(37, 'SilverStone Strider Gold S 850W'),
	(38, 'Antec Earthwatts Gold Pro 850W'),
	(39, 'GIGABYTE P850GM'),
	(40, 'EVGA SuperNOVA 1000 G3'),
	(41, 'Corsair RM1000x'),
	(42, 'Seasonic Prime Ultra 1000W'),
	(43, 'Thermaltake Toughpower Grand RGB 1000W'),
	(44, 'be quiet! Straight Power 11 1000W'),
	(45, 'NZXT C1000'),
	(46, 'Cooler Master MWE Gold 1000W'),
	(47, 'SilverStone Strider Gold S 1000W'),
	(48, 'Antec Earthwatts Gold Pro 1000W'),
	(49, 'GIGABYTE P1000GM');

-- Dumping structure for table nigger.nig_ram
CREATE TABLE IF NOT EXISTS `nig_ram` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_ram: ~30 rows (approximately)
INSERT INTO `nig_ram` (`id`, `name`) VALUES
	(19, 'Corsair Vengeance LPX 16GB DDR4-3200'),
	(20, 'G.SKILL Ripjaws V 16GB DDR4-3600'),
	(21, 'Crucial Ballistix 16GB DDR4-3200'),
	(22, 'ADATA XPG GAMMIX D10 16GB DDR4-3000'),
	(23, 'Kingston HyperX Fury 16GB DDR4-2666'),
	(24, 'Team T-FORCE VULCAN Z 16GB DDR4-3000'),
	(25, 'Patriot Viper Steel 16GB DDR4-3200'),
	(26, 'Corsair Dominator RGB 32GB DDR4-3200'),
	(27, 'G.SKILL Trident Z RGB 32GB DDR4-3600'),
	(28, 'Crucial Ballistix RGB 32GB DDR4-3200'),
	(29, 'ADATA XPG SPECTRIX D41 32GB DDR4-3200'),
	(30, 'Kingston HyperX Predator RGB 32GB DDR4-3200'),
	(31, 'Team T-FORCE NIGHT HAWK RGB 32GB DDR4-3200'),
	(32, 'Patriot Viper Steel RGB 32GB DDR4-3600'),
	(33, 'Corsair Vengeance LPX 64GB DDR4-3200'),
	(34, 'G.SKILL Ripjaws V 64GB DDR4-3600'),
	(35, 'Crucial Ballistix 64GB DDR4-3200'),
	(36, 'ADATA XPG GAMMIX D10 64GB DDR4-3000'),
	(37, 'Kingston HyperX Fury 64GB DDR4-2666'),
	(38, 'Team T-FORCE VULCAN Z 64GB DDR4-3000'),
	(39, 'Patriot Viper Steel 64GB DDR4-3200'),
	(40, 'Corsair Dominator RGB 128GB DDR4-3200'),
	(41, 'G.SKILL Trident Z RGB 128GB DDR4-3600'),
	(42, 'Crucial Ballistix RGB 128GB DDR4-3200'),
	(43, 'ADATA XPG SPECTRIX D41 128GB DDR4-3200'),
	(44, 'Kingston HyperX Predator RGB 128GB DDR4-3200'),
	(45, 'Team T-FORCE NIGHT HAWK RGB 128GB DDR4-3200'),
	(46, 'Patriot Viper Steel RGB 128GB DDR4-3600'),
	(47, 'Corsair Vengeance LPX 32GB DDR4-3200'),
	(48, 'G.SKILL Ripjaws V 32GB DDR4-3600');

-- Dumping structure for table nigger.nig_storage
CREATE TABLE IF NOT EXISTS `nig_storage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nigger.nig_storage: ~30 rows (approximately)
INSERT INTO `nig_storage` (`id`, `name`) VALUES
	(19, 'Samsung 970 EVO 500GB NVMe M.2'),
	(20, 'Crucial MX500 1TB SATA SSD'),
	(21, 'Western Digital Blue 2TB HDD'),
	(22, 'Seagate Barracuda 4TB HDD'),
	(23, 'Intel 660p 1TB NVMe M.2'),
	(24, 'Kingston A2000 250GB NVMe M.2'),
	(25, 'ADATA SU800 512GB SATA SSD'),
	(26, 'Samsung 860 EVO 1TB SATA SSD'),
	(27, 'Corsair MP510 1TB NVMe M.2'),
	(28, 'Crucial P1 1TB NVMe M.2'),
	(29, 'Western Digital Black 6TB HDD'),
	(30, 'Seagate FireCuda 2TB SSHD'),
	(31, 'Intel 665p 2TB NVMe M.2'),
	(32, 'Kingston KC600 256GB SATA SSD'),
	(33, 'ADATA XPG SX8200 Pro 2TB NVMe M.2'),
	(34, 'Samsung 970 EVO Plus 2TB NVMe M.2'),
	(35, 'Crucial P5 500GB NVMe M.2'),
	(36, 'Western Digital Red 8TB NAS HDD'),
	(37, 'Seagate IronWolf 10TB NAS HDD'),
	(38, 'Intel Optane 905P 960GB U.2'),
	(39, 'Kingston UV500 240GB SATA SSD'),
	(40, 'ADATA SU650 120GB SATA SSD'),
	(41, 'Samsung T5 1TB Portable SSD'),
	(42, 'Crucial BX500 480GB SATA SSD'),
	(43, 'Western Digital My Passport 4TB Portable HDD'),
	(44, 'Seagate Backup Plus Hub 8TB External HDD'),
	(45, 'Intel Optane H10 512GB NVMe M.2'),
	(46, 'Kingston KC2500 1TB NVMe M.2'),
	(47, 'ADATA XPG GAMMIX S50 Lite 1TB NVMe M.2'),
	(48, 'Samsung 870 QVO 2TB SATA SSD');

