-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `clothes_app`
--

-- --------------------------------------------------------

--
-- Table structure for table `accoar`
--

CREATE TABLE `accoar` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `surname` varchar(100) NOT NULL,
  `iban` varchar(100) NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `bank` varchar(100) NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accoar`
--

INSERT INTO `accoar` (`id`, `name`, `surname`, `iban`, `total_price`, `quantity`, `payment_method`, `bank`, `payment_date`) VALUES
(1, 'kk', 'kk', '999990', 300.00, 3, 'الدفع عبر التحويل البنكي', 'بنك القاهرة', '2025-05-15 21:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `bank_transfers`
--

CREATE TABLE `bank_transfers` (
  `id` int(11) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `iban` varchar(100) NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `total_items` int(11) NOT NULL,
  `payment_method` varchar(150) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bank_transfers`
--

INSERT INTO `bank_transfers` (`id`, `full_name`, `iban`, `total_price`, `total_items`, `payment_method`, `created_at`) VALUES
(7, 'khaled guma', '345324564356789999999999999', 200.00, 4, 'تحويل إلى Ziraat Bankası', '2025-05-04 17:11:11'),
(8, 'khaled guma', '345324564356789999999999999', 200.00, 4, 'تحويل إلى Ziraat Bankası', '2025-05-04 17:11:12'),
(9, 'khgjf', '76765432', 40.00, 2, 'تحويل إلى Ziraat Bankası', '2025-05-06 22:32:34'),
(10, 'kk', '000000000000000000', 66.00, 2, 'تحويل إلى Ziraat Bankası', '2025-05-13 18:26:05'),
(11, 'kh', '000', 20.00, 1, 'تحويل إلى Ziraat Bankası', '2025-05-14 07:51:42'),
(12, 'hhh', '12', 120.00, 6, 'تحويل إلى Ziraat Bankası', '2025-05-16 10:50:30'),
(13, 'khaled', '111111', 40.00, 2, 'تحويل إلى Ziraat Bankası', '2025-05-16 11:11:49'),
(14, 'kk', '00', 20.00, 1, 'تحويل إلى Ziraat Bankası', '2025-05-17 18:08:06');

-- --------------------------------------------------------

--
-- Table structure for table `store_payment`
--

CREATE TABLE `store_payment` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `surname` varchar(100) NOT NULL,
  `iban` varchar(100) NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `bank` varchar(100) NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users_table`
--

CREATE TABLE `users_table` (
  `user_id` int(11) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `user_email` varchar(100) NOT NULL,
  `user_password` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users_table`
--

INSERT INTO `users_table` (`user_id`, `user_name`, `user_email`, `user_password`) VALUES
(10, 'halid El cuma', 'haledcuma@gmail.com', '25f9e794323b453885f5181f1b624d0b'),
(11, 'khaled', 'khaled@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b'),
(12, 'k', 'lk@gmail.com', 'dcddb75469b4b4875094e14561e573d8');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accoar`
--
ALTER TABLE `accoar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bank_transfers`
--
ALTER TABLE `bank_transfers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `store_payment`
--
ALTER TABLE `store_payment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_table`
--
ALTER TABLE `users_table`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accoar`
--
ALTER TABLE `accoar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bank_transfers`
--
ALTER TABLE `bank_transfers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `store_payment`
--
ALTER TABLE `store_payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `users_table`
--
ALTER TABLE `users_table`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

