-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- 主機： localhost:3306
-- 產生時間： 2023 年 12 月 23 日 08:06
-- 伺服器版本： 5.7.44
-- PHP 版本： 8.1.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 資料庫： `fredpbn_db`
--

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

--
-- 資料表結構 `ipcounter`
--

CREATE TABLE `ipcounter` (
  `id` int(11) NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `area` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `country` varchar(4) CHARACTER SET utf8 DEFAULT NULL,
  `company` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `sn` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `remark` varchar(16) DEFAULT NULL,
  `lDate` datetime DEFAULT NULL,
  `lTool` varchar(10) CHARACTER SET ascii DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 傾印資料表的資料 `ipcounter`
--

INSERT INTO `ipcounter` (`id`, `ip`, `count`, `area`, `country`, `company`, `sn`, `remark`, `lDate`, `lTool`) VALUES
(1, '127.0.0.1', 4, NULL, NULL, NULL, '', NULL, NULL, NULL),
(2, '39.8.62.129', 4, NULL, NULL, NULL, '', NULL, NULL, NULL),
(5, '39.8.190.179', 31, NULL, NULL, NULL, '', NULL, NULL, NULL),
(6, '150.116.163.66', 245, 'TWTP', NULL, 'web', '', 'fred 0807', '2019-10-04 15:34:03', 'CT9'),
(8, '203.74.156.20', 128, 'Hsinchu', 'TW', '', '', NULL, '2023-11-14 08:44:34', 'CT60'),
(9, '72.14.199.216', 1, 'USCA', NULL, 'pbndemo', '', NULL, NULL, NULL),
(10, '61.219.173.241', 735, 'Banqiao', 'TW', 'pbndemo', '1074081', 'crony', '2023-11-01 07:26:24', 'CT23'),
(11, '72.14.199.106', 2, 'USCA', NULL, 'pbndemo', '', NULL, NULL, NULL),
(12, '110.26.126.34', 9, 'TWTP', NULL, 'pbndemo', '', 'Zen4', NULL, NULL),
(13, '72.14.199.102', 1, 'USCA', NULL, 'pbndemo', '', NULL, NULL, NULL);

--
-- 已傾印資料表的索引
--

--
-- 資料表索引 `ipcounter`
--
ALTER TABLE `ipcounter`
  ADD PRIMARY KEY (`id`);

--
-- 在傾印的資料表使用自動遞增(AUTO_INCREMENT)
--

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ipcounter`
--
ALTER TABLE `ipcounter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=388;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;