--
-- Host: localhost    Database: slot_game
-- ------------------------------------------------------


--
-- Table structure for table `symbols`
--

CREATE TABLE `symbols` (
  `id` int NOT NULL AUTO_INCREMENT,
  `symbol` varchar(10) COLLATE utf8mb4_general_ci 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;

--
-- Dumping data for table `symbols`
--

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

--
-- Table structure for table `user_stats`
--

CREATE TABLE `user_stats` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `credits` int NOT NULL DEFAULT '1000',
  `total_games` int NOT NULL DEFAULT '0',
  `total_wins` int NOT NULL DEFAULT '0',
  `total_losses` int NOT NULL DEFAULT '0',
  `highest_win` int 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=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_stats`
--

INSERT INTO `user_stats` VALUES (1,1,5000,0,0,0,0),(2,1,5000,0,0,0,0),(3,3,5000,0,0,0,0),(4,3,5000,0,0,0,0),(5,5,5000,0,0,0,0),(6,6,5000,0,0,0,0),(7,3,5000,0,0,0,0),(8,68,5000,0,0,0,0),(9,82,5000,0,0,0,0),(10,586,5000,0,0,0,0);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `telegram_id` bigint NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ticket_balance` decimal(10,2) DEFAULT '0.00',
  `pap_balance` decimal(10,2) DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `telegram_id` (`telegram_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1013 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,12345,'test_user','2025-05-30 14:00:55','2025-05-30 14:00:55',0.00,0.00),(3,8013391949,'merve gizay','2025-05-31 01:03:22','2025-06-09 15:05:48',0.00,0.00),(5,7766890158,'Yunus','2025-05-31 01:08:43','2025-06-09 03:54:21',0.00,0.00),(6,1761901617,'newmessengers','2025-05-31 01:09:18','2025-06-09 13:40:46',0.00,0.00),(68,5461474603,'Gokhan_papiteam','2025-05-31 19:26:53','2025-06-09 02:14:00',0.00,0.00),(82,7670445994,'psikopatyazar06','2025-05-31 19:48:23','2025-06-03 10:09:23',0.00,0.00),(586,1101262911,'hnnbllecter','2025-06-05 17:49:09','2025-06-05 17:50:19',0.00,0.00);


