c644dr24

1-- phpMyAdmin SQL Dump
2-- version 5.0.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 04, 2020 at 09:41 PM
7-- Server version: 10.4.14-MariaDB
8-- PHP Version: 7.4.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11START TRANSACTION;
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8mb4 */;
19
20--
21-- Database: `sampreglog`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `admins`
28--
29
30CREATE TABLE IF NOT EXISTS `admins` (
31  `id` int(11) NOT NULL AUTO_INCREMENT,
32  `user_id` int(11) NOT NULL,
33  `level` int(11) NOT NULL,
34  `rank` varchar(56) NOT NULL,
35  PRIMARY KEY (`id`),
36  KEY `id` (`id`),
37  KEY `admins_ibfk_1` (`user_id`)
38) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
39
40--
41-- Dumping data for table `admins`
42--
43
44INSERT INTO `admins` (`id`, `user_id`, `level`, `rank`) VALUES
45(3, 3, 5, 'Test'),
46(4, 1, 2, '13');
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `users`
52--
53
54CREATE TABLE IF NOT EXISTS `users` (
55  `ID` int(11) NOT NULL AUTO_INCREMENT,
56  `UserName` varchar(56) NOT NULL,
57  `Password` varchar(256) NOT NULL,
58  `IP` varchar(56) NOT NULL DEFAULT '127.0.0.1',
59  `Money` int(11) NOT NULL DEFAULT 0,
60  PRIMARY KEY (`ID`)
61) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
62
63--
64-- Dumping data for table `users`
65--
66
67INSERT INTO `users` (`ID`, `UserName`, `Password`, `IP`, `Money`) VALUES
68(1, 'Ice', '123456', '127.0.0.1', 0),
69(3, 'Frosty', '123456', '127.0.0.1', 0);
70
71--
72-- Constraints for dumped tables
73--
74
75--
76-- Constraints for table `admins`
77--
78ALTER TABLE `admins`
79  ADD CONSTRAINT `admins_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
80COMMIT;
81
82/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
83/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
84/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
85