-- Slot Game Database Export
-- Tarih: 2025-05-31 02:23:59



--
-- Veritabanı: `slot_game`
--

--
-- Tablo yapısı: `symbols`
--

CREATE TABLE `symbols` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `symbol` varchar(10) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Tablo verileri: `symbols`
--

INSERT INTO `symbols` VALUES ('1', '🍒', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('2', '🍊', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('3', '🍋', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('4', '🍇', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('5', '🍉', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('6', '7️⃣', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('7', '💎', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('8', '🎰', '2025-05-26 01:05:58');
INSERT INTO `symbols` VALUES ('9', '🍒', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('10', '🍊', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('11', '🍋', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('12', '🍇', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('13', '🍉', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('14', '7️⃣', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('15', '💎', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('16', '🎰', '2025-05-26 19:15:02');
INSERT INTO `symbols` VALUES ('17', '🍒', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('18', '🍊', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('19', '🍋', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('20', '🍇', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('21', '🍉', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('22', '7️⃣', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('23', '💎', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('24', '🎰', '2025-05-26 19:40:00');
INSERT INTO `symbols` VALUES ('25', '🍒', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('26', '🍊', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('27', '🍋', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('28', '🍇', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('29', '🍉', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('30', '7️⃣', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('31', '💎', '2025-05-26 22:29:21');
INSERT INTO `symbols` VALUES ('32', '🎰', '2025-05-26 22:29:21');

--
-- Tablo yapısı: `user_stats`
--

CREATE TABLE `user_stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `credits` int(11) NOT NULL DEFAULT 1000,
  `total_games` int(11) NOT NULL DEFAULT 0,
  `total_wins` int(11) NOT NULL DEFAULT 0,
  `total_losses` int(11) NOT NULL DEFAULT 0,
  `highest_win` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `user_stats_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Tablo verileri: `user_stats`
--

INSERT INTO `user_stats` VALUES ('1', '1', '5000', '0', '0', '0', '0');
INSERT INTO `user_stats` VALUES ('2', '1', '5000', '0', '0', '0', '0');

--
-- Tablo yapısı: `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `telegram_id` bigint(20) NOT NULL,
  `username` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `last_login` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `telegram_id` (`telegram_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Tablo verileri: `users`
--

INSERT INTO `users` VALUES ('1', '12345', 'test_user', '2025-05-30 14:00:55', '2025-05-30 14:00:55');

