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

START TRANSACTION;



--
-- Database: `isle`
--

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

--
-- Table structure for table `alert_work`
--

CREATE TABLE `isle_alert_work` (
  `id_alert_work` int(50) NOT NULL,
  `type_alert_work` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `detail_alert_work` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status_alert_work` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `user_player` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `number_money_alert` int(50) NOT NULL,
  `date_alert_work` date NOT NULL,
  `time_alert_work` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `alert_work`
--



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

--
-- Table structure for table `award`
--

CREATE TABLE `isle_award` (
  `id_award` int(50) NOT NULL,
  `Number_award` int(50) NOT NULL,
  `id_item` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item`
--

CREATE TABLE `isle_item` (
  `id_item` int(50) NOT NULL,
  `type_item` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name_item` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `detail_item` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `price` int(50) NOT NULL,
  `show` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `item_user`
--

CREATE TABLE `isle_item_user` (
  `id_item_user` int(50) NOT NULL,
  `id_item` int(50) NOT NULL,
  `user_player` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status_tem_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `log_work`
--

CREATE TABLE `isle_log_work` (
  `id_log` int(50) NOT NULL,
  `user_player` varchar(250) NOT NULL,
  `type_log` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `detail_log` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status_log` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date_log` date NOT NULL,
  `time_log` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `log_work`
--

INSERT INTO `isle_log_work` (`id_log`, `user_player`, `type_log`, `detail_log`, `status_log`, `date_log`, `time_log`) VALUES
(4, 'dayD55', 'player', 'สมัครสมาชิก', 'ผ่าน', '2018-07-31', '14:10:13'),
(5, 'dayD55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-07-31', '16:03:06'),
(6, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '16:03:14'),
(7, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '18:04:10'),
(8, 'team1555', 'player', 'สมัครสมาชิก', 'ผ่าน', '2018-07-31', '18:22:27'),
(9, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '18:22:36'),
(10, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '18:22:42'),
(11, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '20:29:49'),
(12, 'jodari710', 'player', 'สมัครสมาชิก', 'ผ่าน', '2018-07-31', '20:31:41'),
(13, 'jodari710', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '20:31:47'),
(14, 'jodari710', 'player', 'เข้าระบบ', 'ผ่าน', '2018-07-31', '20:31:59'),
(15, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-01', '12:52:47'),
(16, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-02', '17:36:25'),
(17, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-02', '18:05:46'),
(18, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-02', '18:06:06'),
(19, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-02', '19:30:38'),
(20, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-03', '10:38:24'),
(21, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-03', '13:48:35'),
(22, 'dayD55', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:18:00'),
(23, 'dayD55', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:18:14'),
(24, 'dayD55', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:18:29'),
(25, 'dayD55', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:18:56'),
(26, 'dayD55', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:19:23'),
(27, 'dayD55', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:19:29'),
(28, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-03', '18:43:17'),
(29, 'team1555', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-03', '18:44:29'),
(30, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-05', '16:32:34'),
(31, 'dayd55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-08-05', '16:33:05'),
(32, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-05', '16:34:41'),
(33, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:16:33'),
(34, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:17:35'),
(35, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:35:08'),
(36, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:37:16'),
(37, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:38:14'),
(38, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:38:37'),
(39, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:45:23'),
(40, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:58:13'),
(41, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '20:58:20'),
(42, 'dayd55', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-05', '21:01:02'),
(43, 'dayd55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-08-05', '21:14:47'),
(44, 'DAYD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-05', '21:14:57'),
(45, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-06', '06:19:59'),
(46, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-10', '10:38:32'),
(47, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-11', '05:34:42'),
(48, 'team1555', 'player', 'อัพเดตข้อมูล', 'ผ่าน', '2018-08-11', '05:35:44'),
(49, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-11', '05:35:45'),
(50, 'team1555', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-11', '05:36:47'),
(51, 'team1555', 'player', 'อัพเดตรูปภาพ', 'ผ่าน', '2018-08-11', '05:37:41'),
(52, 'team1555', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-11', '05:37:58'),
(53, 'DAYD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-11', '10:28:21'),
(54, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-08-13', '16:55:35'),
(55, 'Dayd55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-09-07', '14:29:45'),
(56, 'dayd55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-10-14', '07:01:41'),
(57, 'dayd55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-10-19', '16:26:26'),
(58, 'dayd55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-10-19', '16:32:50'),
(59, 'dayd55', 'player', 'เข้าระบบ', 'ไม่ผ่าน', '2018-10-19', '16:46:30'),
(60, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-10-19', '16:46:36'),
(61, 'dayD55', 'player', 'เข้าระบบ', 'ผ่าน', '2018-10-19', '17:18:29');

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

--
-- Table structure for table `money`
--

CREATE TABLE `isle_money` (
  `id_money` int(11) NOT NULL,
  `user_player` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `type_money` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `list_money` int(250) NOT NULL,
  `number_money` int(50) NOT NULL,
  `date_money` date NOT NULL,
  `time_money` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `news`
--

CREATE TABLE `isle_news` (
  `id_news` int(50) NOT NULL,
  `name_news` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `detail_news` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date_news` date NOT NULL,
  `time_news` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rush`
--

CREATE TABLE `isle_rush` (
  `id_rush` int(11) NOT NULL,
  `name_rush` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rush`
--

INSERT INTO `isle_rush` (`id_rush`, `name_rush`) VALUES
(1, 'คุณยังไม่ได้ลงทะเบียน Uid เกมส์ The Isle'),
(2, 'ไดโนเสาร์ฝึกหัด');

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

--
-- Table structure for table `show_work`
--

CREATE TABLE `isle_show_work` (
  `id_show` int(11) NOT NULL,
  `name_show` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `detail_show` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `url` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `show_work`
--

INSERT INTO `isle_show_work` (`id_show`, `name_show`, `detail_show`, `url`) VALUES
(1, 'discord', 'discord', 'https://discord.gg/Y4x5A6r');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `alert_work`
--
ALTER TABLE `isle_alert_work`
  ADD PRIMARY KEY (`id_alert_work`);

--
-- Indexes for table `award`
--
ALTER TABLE `isle_award`
  ADD PRIMARY KEY (`id_award`);

--
-- Indexes for table `item`
--
ALTER TABLE `isle_item`
  ADD PRIMARY KEY (`id_item`),
  ADD KEY `id_item` (`id_item`);

--
-- Indexes for table `item_user`
--
ALTER TABLE `isle_item_user`
  ADD PRIMARY KEY (`id_item_user`);

--
-- Indexes for table `log_work`
--
ALTER TABLE `isle_log_work`
  ADD PRIMARY KEY (`id_log`);

--
-- Indexes for table `money`
--
ALTER TABLE `isle_money`
  ADD PRIMARY KEY (`id_money`);

--
-- Indexes for table `news`
--
ALTER TABLE `isle_news`
  ADD PRIMARY KEY (`id_news`);

--
-- Indexes for table `player`
--
ALTER TABLE `isle_player`
  ADD PRIMARY KEY (`user_player`);

--
-- Indexes for table `rush`
--
ALTER TABLE `isle_rush`
  ADD PRIMARY KEY (`id_rush`);

--
-- Indexes for table `show_work`
--
ALTER TABLE `isle_show_work`
  ADD PRIMARY KEY (`id_show`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `alert_work`
--
ALTER TABLE `isle_lert_work`
  MODIFY `id_alert_work` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `award`
--
ALTER TABLE `isle_award`
  MODIFY `id_award` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `isle_item`
  MODIFY `id_item` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `item_user`
--
ALTER TABLE `isle_item_user`
  MODIFY `id_item_user` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_work`
--
ALTER TABLE `isle_log_work`
  MODIFY `id_log` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `money`
--
ALTER TABLE `isle_money`
  MODIFY `id_money` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `isle_news`
  MODIFY `id_news` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rush`
--
ALTER TABLE `isle_rush`
  MODIFY `id_rush` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `show_work`
--
ALTER TABLE `isle_show_work`
  MODIFY `id_show` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

