-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : mar. 30 août 2022 à 14:04
-- Version du serveur : 10.4.24-MariaDB
-- Version de PHP : 8.1.6

START TRANSACTION;



--
-- Base de données : `followers`
--

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

--
-- Structure de la table `add_funds`
--

CREATE TABLE `add_funds` (
  `id` int(11) NOT NULL,
  `id_Tickets` int(4) NOT NULL,
  `amount` int(11) NOT NULL,
  `date` date NOT NULL,
  `id_user` int(11) NOT NULL,
  `Method` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `add_funds`
--

INSERT INTO `add_funds` (`id`, `id_Tickets`, `amount`, `date`, `id_user`, `Method`) VALUES
(4633, 8524, 20, '2022-08-19', 56, 'Credit carte'),
(4634, 6838, 20, '2022-08-19', 56, 'Credit carte'),
(4635, 315, 20, '2022-08-19', 56, 'Credit carte'),
(4636, 6334, 40, '2022-08-19', 56, 'Credit carte'),
(4637, 9805, 20, '2022-08-19', 56, 'Credit carte'),
(4685, 6658, 0, '2022-08-19', 56, 'Credit carte'),
(4686, 4040, 20, '2022-08-21', 52, 'Credit carte'),
(4687, 4869, 20, '2022-08-21', 52, 'Credit carte'),
(4688, 6062, 290, '2022-08-21', 57, 'Credit carte'),
(4689, 226, 20, '2022-08-21', 57, 'Credit carte'),
(4690, 1267, 10700000, '2022-08-23', 58, 'Credit carte'),
(4691, 3898, 10, '2022-08-23', 58, 'Credit carte'),
(4692, 8962, 100000, '2022-08-23', 58, 'Credit carte'),
(4693, 325, 500, '2022-08-24', 59, 'Credit carte'),
(4694, 4896, 50000, '2022-08-24', 59, 'Credit carte'),
(4695, 6428, 1, '2022-08-24', 59, 'Credit carte'),
(4696, 7774, 100, '2022-08-24', 59, 'Credit carte'),
(4697, 6578, 10, '2022-08-24', 59, 'Credit carte'),
(4698, 5433, 10, '2022-08-24', 59, 'Credit carte'),
(4699, 6386, 170, '2022-08-24', 59, 'Credit carte'),
(4700, 3878, 10, '2022-08-24', 59, 'Credit carte'),
(4701, 7842, 10, '2022-08-24', 59, 'Credit carte'),
(4702, 6975, 10, '2022-08-24', 59, 'Credit carte'),
(4703, 6695, 10000, '2022-08-24', 59, 'Credit carte'),
(4704, 9499, 472184, '2022-08-30', 92, 'Credit carte');

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

--
-- Structure de la table `categoris`
--

CREATE TABLE `categoris` (
  `id` int(11) NOT NULL,
  `name_categoris` varchar(255) NOT NULL,
  `id_categorie` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `categoris`
--

INSERT INTO `categoris` (`id`, `name_categoris`, `id_categorie`) VALUES
(23, '🔱 PROMOTION [CHEAPEST]', 2346),
(230, '➖ YouTube Views', 2333),
(2345, '➕ YouTube [ Shorts ]\r\n', 57645),
(2346, '➕ YouTube [ Watchtime ]\r\n', 36767),
(3444, '➕ YouTube Views [ Targeted Views ]\r\n', 367736);

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

--
-- Structure de la table `ordernow`
--

CREATE TABLE `ordernow` (
  `id` int(11) NOT NULL,
  `id_order` varchar(4) NOT NULL,
  `surl` text NOT NULL,
  `sdate` date NOT NULL,
  `id_user` int(11) NOT NULL,
  `sstatus` varchar(255) NOT NULL,
  `quantity` text NOT NULL,
  `sservice` text NOT NULL,
  `remains` text NOT NULL,
  `charge` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `ordernow`
--

INSERT INTO `ordernow` (`id`, `id_order`, `surl`, `sdate`, `id_user`, `sstatus`, `quantity`, `sservice`, `remains`, `charge`) VALUES
(759, '3388', '', '2022-08-23', 58, 'In Progress', '115', '.', '0', '0.2540'),
(760, '3948', '', '2022-08-23', 58, 'In Progress', '103', '.', '0', '0.2280'),
(761, '3743', '', '2022-08-23', 58, 'In Progress', '105', '.', '0', '0.2320'),
(762, '5095', 'http://hpfkjurdhugiheor', '2022-08-23', 58, 'In Progress', '1298', '.', '0', '2.8690'),
(763, '6769', 'http://OFHEZAF', '2022-08-23', 58, 'In Progress', '110', '.', '0', '0.2430'),
(764, '8860', 'http://HFGJHUEH', '2022-08-23', 58, 'In Progress', '107', '.', '0', '0.2360'),
(765, '8063', 'http://UHJKJDFCLNKZRDJESQ', '2022-08-23', 58, 'In Progress', '119', '.', '0', '0.2630'),
(766, '6273', 'http://KFQRSEG', '2022-08-23', 58, 'In Progress', '100', '.', '0', '0.2210'),
(767, '9688', 'http://KJHGKB', '2022-08-23', 58, 'In Progress', '103', '.', '0', '0.2280'),
(768, '7895', 'http://Houssam', '2022-08-23', 58, 'In Progress', '1000', '.', '0', '2.2100'),
(769, '0376', 'http://kjdfngksrdngf', '2022-08-23', 58, 'In Progress', '107', '.', '0', '0.2360'),
(770, '8578', 'http://jhjblknj', '2022-08-23', 58, 'In Progress', '169', '.', '0', '0.3730'),
(771, '9774', 'http://jkbcnf,bqed', '2022-08-23', 58, 'In Progress', '100000', '.', '0', '221.0000'),
(772, '5743', 'http://dfgkwùreq', '2022-08-23', 58, 'In Progress', '3784', '.', '0', '8.3630'),
(773, '6850', 'http://jhvlkufsgqlre', '2022-08-23', 58, 'In Progress', '100000', '.', '0', '21.8900'),
(774, '8368', 'http://houssam123K', '2022-08-24', 58, 'In Progress', '10000', '.', '0', '2.1890'),
(775, '7237', 'http://HIKJPO', '2022-08-24', 59, 'In Progress', '10000', '.', '0', '2.1890'),
(776, '6954', 'http://xicjlkqds', '2022-08-24', 59, 'In Progress', '100000', '.', '0', '21.8900'),
(777, '5304', 'http://1000000000', '2022-08-24', 59, 'In Progress', '10000', '.', '0', '2.1890'),
(778, '8047', 'http://1000000000', '2022-08-24', 59, 'In Progress', '10000', '.', '0', '2.1890'),
(779, '0673', 'http://khjcvjlkdsqfhghru', '2022-08-24', 59, 'In Progress', '100000', '.', '0', '21.8900'),
(780, '5584', 'http://khjbsdf', '2022-08-24', 59, 'In Progress', '50000099', '.', '0', '10945.0220'),
(781, '4068', 'http://hamada', '2022-08-24', 59, 'In Progress', '100000', '.', '0', '21.8900'),
(782, '8873', 'http://LJGHJUGUIJK', '2022-08-24', 59, 'In Progress', '1222334', '.', '0', '267.5690'),
(783, '5006', 'http://name_services', '2022-08-24', 59, 'In Progress', '233', '♛ Youtube - Views S8 [ 5k-10k/day ] [ Reliable ] [ 30 Days Refill ] INSTANT.', '0', '0.0510'),
(784, '4475', 'http://ghjfjhvhb', '2022-08-24', 59, 'In Progress', '10000', 'youtube.', '0', '450.0000'),
(785, '0689', 'http://hgkhj', '2022-08-24', 59, 'In Progress', '100000000', '♛ Youtube - Views S8 [ 5k-10k/day ] [ Reliable ] [ 30 Days Refill ] INSTANT.', '0', '21890.0000'),
(786, '8988', 'http://localhost/', '2022-08-25', 59, 'In Progress', '107', 'youtube.', '0', '4.8150'),
(787, '8592', 'http://localhost/', '2022-08-25', 59, 'In Progress', '280', '♛ Youtube - Views S8 [ 5k-10k/day ] [ Reliable ] [ 30 Days Refill ] INSTANT.', '0', '0.0610'),
(788, '6828', 'http://localhost/', '2022-08-25', 59, 'In Progress', '280', '♛ Youtube - Views S8 [ 5k-10k/day ] [ Reliable ] [ 30 Days Refill ] INSTANT.', '0', '0.0610'),
(789, '7671', 'http://localhost/', '2022-08-25', 59, 'In Progress', '102102102', '♛ Youtube - Views S8 [ 5k-10k/day ] [ Reliable ] [ 30 Days Refill ] INSTANT.', '0', '22350.1500'),
(790, '7588', 'http://472184', '2022-08-30', 92, 'In Progress', '472184', 'youtube.', '0', '103.3610'),
(791, '8757', 'http://472184', '2022-08-30', 92, 'In Progress', '472184', 'youtube.', '0', '103.3610'),
(792, '8975', 'http://472184', '2022-08-30', 92, 'In Progress', '472184666', 'youtube.', '0', '103361.2230'),
(793, '5275', 'http://472184', '2022-08-30', 92, 'In Progress', '472184', 'youtube.', '0', '103.3610'),
(794, '6665', 'http://472184', '2022-08-30', 92, 'In Progress', '998888888', 'youtube.', '0', '218656.7780'),
(795, '0568', 'http://998888888', '2022-08-30', 92, 'In Progress', '99888888', 'youtube.', '0', '21865.6780'),
(796, '7865', 'http://998888888', '2022-08-30', 92, 'In Progress', '99888888', 'youtube.', '0', '21865.6780'),
(797, '9650', 'http://998888888', '2022-08-30', 92, 'In Progress', '9988888', 'youtube.', '0', '2186.5680'),
(798, '0777', 'http://998888888', '2022-08-30', 92, 'In Progress', '9988888', 'youtube.', '0', '2186.5680');

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

--
-- Structure de la table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `id_services` int(11) NOT NULL,
  `rervice` text NOT NULL,
  `Rate_per_1000` varchar(11) NOT NULL,
  `Min_order` varchar(255) NOT NULL,
  `Max_order` varchar(255) NOT NULL,
  `Average_time` varchar(355) NOT NULL,
  `rescription` varchar(566) NOT NULL,
  `selected_KJKjknjJ` int(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `services`
--

INSERT INTO `services` (`id`, `id_services`, `rervice`, `Rate_per_1000`, `Min_order`, `Max_order`, `Average_time`, `rescription`, `selected_KJKjknjJ`) VALUES
(160, 418367, '♛ Youtube - Views S8 [ 5k-10k/day ] [ Reliable ] [ 30 Days Refill ] INSTANT', '0.2189', '100', '100000000', '33 minutes', 'INSTANT START\r\n 2-5MINS RETENTION\r\n 20K PER DAY\r\n60 days guarantee from 12th oct', 2346),
(161, 219805, 'youtube', '45', '54', '76', '67', 'INSTANT START\r\n 2-5MINS RETENTION\r\n 20K PER DAY\r\n60 days guarantee from 12th oct', 2346);

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

--
-- Structure de la table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `Message` text NOT NULL,
  `subject` text NOT NULL,
  `date` date NOT NULL,
  `id_Tickets` int(11) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `tickets`
--

INSERT INTO `tickets` (`id`, `Message`, `subject`, `date`, `id_Tickets`, `status`) VALUES
(2487, 'wa fen a hamada', 'salam  ', '2022-08-24', 59, 'Pending'),
(3285, 'The requested URL was not found on this server', 'The requested URL was not found on this server', '2022-08-23', 51, 'Pending'),
(6281, 'The requested URL was not found on this server', 'Not Found', '2022-08-23', 51, 'Pending'),
(7601, 'wa fen ', 'salam', '2022-08-24', 59, 'Pending');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `add_funds`
--
ALTER TABLE `add_funds`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `categoris`
--
ALTER TABLE `categoris`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `ordernow`
--
ALTER TABLE `ordernow`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `add_funds`
--
ALTER TABLE `add_funds`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4705;

--
-- AUTO_INCREMENT pour la table `categoris`
--
ALTER TABLE `categoris`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3445;

--
-- AUTO_INCREMENT pour la table `ordernow`
--
ALTER TABLE `ordernow`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=799;

--
-- AUTO_INCREMENT pour la table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=162;

--
-- AUTO_INCREMENT pour la table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483648;
COMMIT;

