--
-- Table structure for table `demo_table`
--

DROP TABLE IF EXISTS `demo_table`;
CREATE TABLE IF NOT EXISTS `demo_table` (
  `customer_id` int(20) NOT NULL AUTO_INCREMENT,
  `item_purchased` varchar(120) NOT NULL DEFAULT '',
  `quantity_purchased` varchar(50) NOT NULL DEFAULT '0',
  `delivered` varchar(5) NOT NULL DEFAULT 'No',
  PRIMARY KEY (`customer_id`),
  KEY `composite_idx` (`item_purchased`,`quantity_purchased`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `demo_table`
--

INSERT INTO `demo_table` (`customer_id`, `item_purchased`, `quantity_purchased`, `delivered`) VALUES
(1, 'iPhone X', '2', 'Yes'),
(2, 'iPhone 11', '3', 'No'),
(3, 'iPhone XS', '4', 'Yes'),
(4, 'iPhone 6', '2', 'Yes'),
(5, 'iPhone 6s', '6', 'No'),
(6, 'iPad Pro', '5', 'Yes'),
(7, 'Lenovo P-Series 1', '2', 'Yes'),
(8, 'Lenovo P-Series 2', '2', 'Yes'),
(9, 'Lenovo P-Series 3', '44', 'Yes'),
(10, 'Lenovo P-Series 4', '24', 'No'),
(11, 'Lenovo P-Series 5', '224', 'Yes'),
(12, 'HUAWEI Pura 70 Ultra 4GB', '1', 'Yes'),
(13, 'HUAWEI Pura 70 Ultra 8GB', '1', 'Yes'),
(14, 'HUAWEI Pura 70 Ultra 16GB', '1', 'Yes'),
(15, 'HUAWEI Pura 70 Ultra 32GB', '2', 'No'),
(16, 'HUAWEI Pura 70 Ultra 64GB', '2', 'Yes'),
(17, 'Pixel 8 Pro 4GB', '1', 'Yes'),
(18, 'Pixel 8 Pro 8GB', '1', 'Yes'),
(19, 'Pixel 8 Pro 16GB', '1', 'Yes'),
(20, 'Pixel 8 Pro 32GB', '1', 'Yes'),
(21, 'Pixel 8 Pro 64GB', '1', 'Yes'),
(22, 'Xiaomi Redmi 12 256GB', '4', 'Yes'),
(23, 'Xiaomi Redmi 12 32GB', '2', 'Yes'),
(24, 'Xiaomi Redmi 12 64GB', '2', 'Yes'),
(25, 'Xiaomi Redmi 12 128GB', '2', 'Yes'),
(26, 'Xiaomi Redmi 13 256GBGo Noir', '1', 'Yes'),
(27, 'Xiaomi Redmi A2 32GB', '2', 'Yes'),
(28, 'Xiaomi Redmi A2 64GB', '2', 'Yes'),
(29, 'Samsung Galaxy A15 32GB', '2', 'Yes'),
(30, 'Samsung Galaxy A15 64GB', '2', 'Yes'),
(31, 'Samsung Galaxy A15 128GB', '2', 'Yes');
COMMIT;

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
CREATE TABLE IF NOT EXISTS `people` (
  `first_name` varchar(60) NOT NULL DEFAULT '',
  `last_name` varchar(60) NOT NULL DEFAULT '',
  `birthday` varchar(60) NOT NULL DEFAULT '',
  KEY `composite_idx` (`first_name`,`last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `people`
--

INSERT INTO `people` (`first_name`, `last_name`, `birthday`) VALUES
('Jack', 'Surnamey', '1997-01-01'),
('Josh', 'Surnamey', '1998-01-01'),
('Fiona', 'Examply', '1994-02-17'),
('Dana', 'Examploy', '1964-09-07'),
('Samuel', 'Surexamply', '1977-12-19'),
('Lucas', 'Exampli', '1992-04-07'),
('James', 'Surnamey', '1992-05-19'),
('Pakit', 'Surnamo', '1993-01-02'),
('Sam', 'Bexamply', '2000-05-19'),
('King', 'Exampli', '2000-05-19'),
('John', 'Examply', '1995-01-01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `people`
--
ALTER TABLE `people` ADD FULLTEXT KEY `first_name` (`first_name`);
ALTER TABLE `people` ADD FULLTEXT KEY `ft_idx` (`first_name`);
COMMIT;