-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- 主机: localhost
-- 生成日期: 2024-04-30 17:19:16
-- 服务器版本: 5.7.40-log
-- PHP 版本: 7.4.33
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 */;
--
-- 数据库: `qqgz_ougou_vip`
--
-- --------------------------------------------------------
--
-- 表的结构 `fa_qqgz_codes`
--
CREATE TABLE `fa_qqgz_codes` (
`id` int(11) NOT NULL COMMENT '序号',
`code` varchar(255) NOT NULL COMMENT '激活码',
`num` varchar(255) DEFAULT '-1' COMMENT '激活码次数',
`day` varchar(255) NOT NULL COMMENT '激活码天数',
`device` varchar(255) DEFAULT '' COMMENT '设备号',
`device_num` varchar(255) DEFAULT '3' COMMENT '换绑次数',
`opening_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开通时间',
`expiration_time` timestamp NULL DEFAULT NULL COMMENT '到期时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- 转存表中的数据 `fa_qqgz_codes`
--
INSERT INTO `fa_qqgz_codes` (`id`, `code`, `num`, `day`, `device`, `device_num`, `opening_time`, `expiration_time`) VALUES
(1, '123456', '-1', '30', '0a:00:27:00:00:15', '103', '2024-04-26 11:34:06', '2025-03-30 11:34:16'),
(2, 'JSAFHJWF', '-1', '30', '0a:00:27:00:00:15', '3', '2024-04-26 11:34:06', '2025-04-30 11:34:16');
--
-- 转储表的索引
--
--
-- 表的索引 `fa_qqgz_codes`
--
ALTER TABLE `fa_qqgz_codes`
ADD PRIMARY KEY (`id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `fa_qqgz_codes`
--
ALTER TABLE `fa_qqgz_codes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号', AUTO_INCREMENT=3;
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 */;