-- phpMyAdmin SQL Dump
-- version 5.2.1
-- [Link]
--
-- Host: [Link]
-- Generation Time: Mar 04, 2025 at 05:19 PM
-- Server version: 10.11.10-MariaDB
-- PHP Version: 7.2.34
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `u650672385_PhoneMate`
--
-- --------------------------------------------------------
--
-- Table structure for table `items`
--
CREATE TABLE `items` (
`item_id` int(11) NOT NULL,
`item_category` varchar(255) NOT NULL,
`item_brand` varchar(255) NOT NULL,
`item_number` varchar(50) NOT NULL,
`item_description` text NOT NULL,
`item_image` varchar(255) NOT NULL,
`item_price` int(11) NOT NULL,
`item_quantity` int(11) NOT NULL,
`more_quantity` int(10) NOT NULL DEFAULT 0,
`item_sold` int(11) NOT NULL,
`agreement_date` date NOT NULL,
`item_profit` int(3) NOT NULL DEFAULT 0,
`item_status` varchar(30) NOT NULL DEFAULT 'review',
`fk_item_tracking_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `items`
--
INSERT INTO `items` (`item_id`, `item_category`, `item_brand`, `item_number`,
`item_description`, `item_image`, `item_price`, `item_quantity`, `more_quantity`,
`item_sold`, `agreement_date`, `item_profit`, `item_status`, `fk_item_tracking_id`)
VALUES
(1, 'Hand-free', 'Samsung', 'm8 95 c-pro', 'Genuine Handfrees, good sound level, no
distortion, integrated mice, overall longer life span',
'1wallpaperflare.com_wallpaper (5).jpg', 131, 300, 0, 0, '2026-02-19', 5,
'processed', 1),
(2, 'Hand-free', 'Audionic', 'Audionic Special z-100', 'Experience crystal-clear
sound with the Audionic Special Z-100 Handsfree. Designed for comfort and
performance, this handsfree delivers rich audio quality with deep bass and crisp
highs, making it perfect for music, calls, and gaming. The ergonomic design ensures
a secure fit, while the in-line mic and control buttons let you manage calls and
media effortlessly. Built with durable materials, the Z-100 is a reliable companion
for everyday use.', '2elevated-view-black-earphone-coffee-cup-white-
[Link]', 200, 500000, 0, 0, '2026-02-28', 10, 'processed', 1),
(3, 'Hand-free', 'Samsung', 'yu-09 9876', 'Unlock immersive sound with the Audionic
YU-09 9876 Handsfree, designed to complement your Samsung devices. This handsfree
delivers dynamic audio with rich bass, sharp mids, and clear highs for an
outstanding listening experience. Its ergonomic design ensures a snug, comfortable
fit, while the built-in mic and control buttons make managing calls and music a
breeze. Crafted with durable materials, it\\\'s built to last — perfect for
everyday use.', '[Link]', 390, 19000, 0, 0, '2026-02-28', 10, 'processed', 1),
(4, 'Hand-free', 'Huawei', 'mini g-pro', 'Experience powerful sound in a compact
design with the Audionic Mini G-Pro Handsfree, perfectly optimized for Huawei
devices. Whether you\\\'re enjoying music, taking calls, or gaming, this handsfree
delivers crystal-clear audio with deep bass and balanced tones. Its lightweight,
ergonomic fit ensures all-day comfort, while the in-line mic and controls make
switching between tracks and calls effortless.', '4sound-wave-icon-near-earphone-
[Link]', 200, 1000, 0, 0, '2026-02-01', 10, 'processed', 1),
(5, 'Data Cable', 'Samsung', 'c-11', 'Stay connected and powered up with the
Audionic Data Cable, designed for fast and reliable charging and data transfer for
Samsung devices. Built with high-quality materials, this cable ensures durability
and efficient performance, whether you’re syncing files or charging on the go. The
sleek, tangle-free design makes it perfect for everyday use.', '5pexels-pixabay-
[Link]', 50, 1000, 0, 0, '2026-02-28', 10, 'processed', 1),
(6, 'Data Cable', 'Audionic', 'l-11', '**Audionic Data Cable — Fast &
Reliable** \\r\\nCharge and sync your devices with confidence using the **Audionic
Data Cable**. Designed for durability and speed, this cable ensures fast charging
and stable data transfer, making it a must-have for everyday use. Its sturdy build
and flexible design prevent wear and tear, while universal compatibility makes it
perfect for a wide range of devices.', '[Link]',
70, 6900, 0, 0, '2026-02-28', 10, 'processed', 1),
(7, 'Data Cable', 'Huawei', 'iphone-smart 111', 'Experience seamless charging and
data transfer with the Audionic iPhone-Smart 111 DC, designed specifically for
Huawei devices. This high-performance cable ensures fast, reliable power delivery
and smooth syncing, all in a durable, tangle-free design. Perfect for everyday use,
it combines strength and efficiency to keep your devices powered up and
connected.', '[Link]', 90, 50000, 0, 0, '2026-02-28', 10,
'processed', 1),
(8, 'Power Bank', 'Samsung', 'pb-098', 'Stay charged on the go with the Audionic
Samsung Power Bank. Designed for convenience and reliability, this compact power
bank delivers fast, efficient charging for your Samsung devices. With a sleek,
lightweight design and high-capacity battery, it’s perfect for travel, work, or
daily use, ensuring your devices stay powered whenever you need them.', '8pexels-
[Link]', 230, 80000, 0, 0, '2026-02-28', 10, 'processed', 1),
(9, 'Power Bank', 'Audionic', 'pb-z-long-67', 'Stay powered anytime, anywhere with
the Audionic Power Bank. Designed for fast and efficient charging, this portable
powerhouse keeps your devices running throughout the day. Its sleek, lightweight
design makes it easy to carry, while the high-capacity battery ensures multiple
charges for your smartphone, tablet, or other gadgets. Perfect for travel, work, or
emergencies!\\r\\n', '[Link]', 150, 600, 0, 0, '2026-02-28', 10,
'processed', 1),
(10, 'Head Phone', 'Samsung', 'c99', 'Enjoy rich, high-quality audio with Audionic
Headphones for Samsung. Designed for crystal-clear sound and deep bass, these
headphones deliver an exceptional listening experience for music, calls, and
gaming. The cushioned ear cups and adjustable headband provide all-day comfort,
while the durable build ensures long-lasting performance. Perfect for Samsung
devices, they offer seamless connectivity and powerful sound on the go.',
'[Link]', 200, 3999, 0, 0, '2026-02-28', 10,
'processed', 1),
(11, 'Head Phone', 'Audionic', 'g88', 'Experience powerful, crystal-clear audio
with Audionic Headphones. Designed for music lovers and gamers alike, these
headphones deliver deep bass, balanced mids, and crisp highs for an immersive sound
experience. With soft, cushioned ear cups and an adjustable headband, they provide
lasting comfort for extended listening sessions. Built with durable materials,
they’re perfect for everyday use at home, work, or on the go.', '11pexels-parag-
[Link]', 150, 30000, 0, 0, '2026-02-28', 10, 'processed', 1),
(12, 'Head Phone', 'Huawei', 'h01', 'Enjoy high-definition audio with Audionic
Headphones for Huawei. Engineered for rich sound quality, these headphones deliver
deep bass and clear vocals, enhancing your music, calls, and gaming experience. The
lightweight design, cushioned ear cups, and adjustable headband ensure all-day
comfort, while the sturdy build guarantees lasting durability. Perfect for Huawei
devices, they offer seamless connectivity and exceptional performance.', '12pexels-
[Link]', 400, 3000, 0, 0, '2026-02-28', 10, 'processed', 1),
(13, 'Smart Watch', 'Samsung', 'new-gen 99', 'Stay connected and in control with
the Audionic Smartwatch for Samsung. Designed for seamless compatibility, this
sleek smartwatch tracks your fitness, monitors health metrics, and keeps you
updated with notifications — all from your wrist. With a vibrant display, long
battery life, and customizable features, it\\\'s the perfect companion for your
Samsung device, balancing style and practicality effortlessly.', '13pexels-
[Link]', 2000, 2000, 0, 0, '2026-02-28', 10, 'processed', 1),
(14, 'Smart Watch', 'Audionic', 'new SmartW 100', 'Stay connected and track your
health with the Audionic Smartwatch. Designed for style and functionality, this
sleek smartwatch offers fitness tracking, heart rate monitoring, and smart
notifications right on your wrist. With a vibrant display, long battery life, and
customizable features, it’s the perfect companion for your active lifestyle —
whether at work, the gym, or on the go.', '[Link]',
3000, 500, 0, 0, '2026-02-28', 10, 'processed', 1),
(15, 'Smart Watch', 'Huawei', 'yen 788', 'Stay ahead with the Huawei Smartwatch,
designed to blend elegance with advanced technology. Track your fitness, monitor
your heart rate, and receive smart notifications, all on a vibrant, easy-to-read
display. With a sleek design, long battery life, and customizable watch faces, it’s
the perfect companion for your daily routine, workouts, and everything in
between.', '[Link]', 5000, 5000, 0, 0, '2026-
02-28', 10, 'processed', 1),
(16, 'Hand-free', 'Huawei', 'pro plus', 'its a good quality handfree ',
'[Link]', 3200, 50, 0, 0, '2025-03-30', 5, 'processed', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `items`
--
ALTER TABLE `items`
ADD PRIMARY KEY (`item_id`),
ADD KEY `fk_items_item_tracking_id` (`fk_item_tracking_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `items`
--
ALTER TABLE `items`
ADD CONSTRAINT `fk_items_item_tracking_id` FOREIGN KEY (`fk_item_tracking_id`)
REFERENCES `item_tracking` (`item_tracking_id`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;