⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 numb1.sql

📁 现今的社会是一个信息飞速发达的社会
💻 SQL
字号:
🔍 
-- MySQL dump 10.9
--
-- Host: localhost    Database: numb1
-- ------------------------------------------------------
-- Server version	4.1.14-nt

/*!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 latin1 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `board`
--

DROP TABLE IF EXISTS `board`;
CREATE TABLE `board` (
  `id` int(11) NOT NULL auto_increment,
  `btable` varchar(20) NOT NULL default 'btable1',
  `name` varchar(30) NOT NULL default '',
  `logo` varchar(100) default NULL,
  `inform` varchar(160) default NULL,
  `focus` varchar(200) default NULL,
  `boardmast` varchar(255) NOT NULL default '',
  `page` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `board`
--


/*!40000 ALTER TABLE `board` DISABLE KEYS */;
LOCK TABLES `board` WRITE;
INSERT INTO `board` VALUES (1,'btable1','菜鸟交流','img/logo.gif','','','','pc'),(2,'btable1','网站建设','img/logo.gif','','','','pc'),(3,'btable1','Web程序开发','img/logo.gif','','','','pc'),(4,'btable1','JAVA开发','img/logo.gif','','','','pc'),(5,'btable1','C/C++开发','img/logo.gif','','','','pc'),(6,'btable1','数据库开发','img/logo.gif','','','','pc'),(7,'btable1','BT专区','img/logo.gif','','','','pc'),(8,'btable1','Windows','img/logo.gif','','','','pc'),(9,'btable1','Linux/Unix','img/logo.gif','','','','pc'),(10,'btable1','网络安全','img/logo.gif','','','','pc'),(11,'btable2','幽默图片','img/logo.gif','','','','other'),(12,'btable2','明星美眉','img/logo.gif','','','','other'),(13,'btable2','自然风景','img/logo.gif','','','','other'),(14,'btable2','边走边拍','img/logo.gif','','','','other'),(15,'btable2','军迷世界','img/logo.gif','','','','other'),(16,'btable2','创意之作','img/logo.gif','','','','other'),(17,'btable2','单身一族','img/logo.gif','','','','other'),(18,'btable2','笑话天地','img/logo.gif','','','','other'),(19,'btable2','搞笑视频','img/logo.gif','','','','other'),(20,'btable2','经典短信','img/logo.gif','','','','other'),(21,'btable2','怀旧音乐','img/logo.gif','','','','other');
UNLOCK TABLES;
/*!40000 ALTER TABLE `board` ENABLE KEYS */;

--
-- Table structure for table `btable1`
--

DROP TABLE IF EXISTS `btable1`;
CREATE TABLE `btable1` (
  `id` int(11) NOT NULL auto_increment,
  `boardid` int(40) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `clas` char(2) NOT NULL default 'a',
  `txt` text NOT NULL,
  `up` char(2) NOT NULL default 'n',
  `super` char(2) NOT NULL default 'n',
  `recommendation` char(2) NOT NULL default 'n',
  `locked` char(2) default 'n',
  `userid` varchar(20) default NULL,
  `username` varchar(20) NOT NULL default '',
  `lastid` varchar(20) default NULL,
  `lastname` varchar(20) default NULL,
  `tim` datetime NOT NULL default '0000-00-00 00:00:00',
  `editime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) default NULL,
  `readtimes` int(11) default '0',
  `retimes` int(11) NOT NULL default '0',
  `lastretime` datetime NOT NULL default '0000-00-00 00:00:00',
  `penname` varchar(250) default NULL,
  `upload_pic` varchar(100) NOT NULL default '',
  `upload_file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `btable1`
--


/*!40000 ALTER TABLE `btable1` DISABLE KEYS */;
LOCK TABLES `btable1` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `btable1` ENABLE KEYS */;

--
-- Table structure for table `btable2`
--

DROP TABLE IF EXISTS `btable2`;
CREATE TABLE `btable2` (
  `id` int(11) NOT NULL auto_increment,
  `boardid` int(40) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `clas` char(2) NOT NULL default 'a',
  `txt` text NOT NULL,
  `up` char(2) NOT NULL default 'n',
  `super` char(2) NOT NULL default 'n',
  `recommendation` char(2) NOT NULL default 'n',
  `locked` char(2) default 'n',
  `userid` varchar(20) default NULL,
  `username` varchar(20) NOT NULL default '',
  `lastid` varchar(20) default NULL,
  `lastname` varchar(20) default NULL,
  `tim` datetime NOT NULL default '0000-00-00 00:00:00',
  `editime` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(15) default NULL,
  `readtimes` int(11) default '0',
  `retimes` int(11) NOT NULL default '0',
  `lastretime` datetime NOT NULL default '0000-00-00 00:00:00',
  `penname` varchar(250) default NULL,
  `upload_pic` varchar(100) NOT NULL default '',
  `upload_file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `btable2`
--


/*!40000 ALTER TABLE `btable2` DISABLE KEYS */;
LOCK TABLES `btable2` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `btable2` ENABLE KEYS */;

--
-- Table structure for table `friend`
--

DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend` (
  `id` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `friendid` varchar(20) NOT NULL default '',
  `friendname` varchar(20) NOT NULL default '',
  `isfriend` char(2) NOT NULL default 'y',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `friend`
--


/*!40000 ALTER TABLE `friend` DISABLE KEYS */;
LOCK TABLES `friend` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `friend` ENABLE KEYS */;

--
-- Table structure for table `gift`
--

DROP TABLE IF EXISTS `gift`;
CREATE TABLE `gift` (
  `userid` varchar(20) NOT NULL default '',
  `flower` int(11) NOT NULL default '0',
  `flcom` text,
  PRIMARY KEY  (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gift`
--


/*!40000 ALTER TABLE `gift` DISABLE KEYS */;
LOCK TABLES `gift` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `gift` ENABLE KEYS */;

--
-- Table structure for table `massage`
--

DROP TABLE IF EXISTS `massage`;
CREATE TABLE `massage` (
  `id` int(11) NOT NULL auto_increment,
  `toid` varchar(20) NOT NULL default '',
  `toname` varchar(20) NOT NULL default '',
  `frid` varchar(20) NOT NULL default '',
  `frname` varchar(20) NOT NULL default '',
  `title` varchar(30) NOT NULL default '',
  `txt` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `isread` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `massage`
--


/*!40000 ALTER TABLE `massage` DISABLE KEYS */;
LOCK TABLES `massage` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `massage` ENABLE KEYS */;

--
-- Table structure for table `master`
--

DROP TABLE IF EXISTS `master`;
CREATE TABLE `master` (
  `id` int(11) NOT NULL auto_increment,
  `bid` int(11) NOT NULL default '0',
  `bname` varchar(30) NOT NULL default '',
  `userid` varchar(20) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `master`
--

--
-- Table structure for table `numb1`
--

DROP TABLE IF EXISTS `numb1`;
CREATE TABLE `numb1` (
  `userid` varchar(20) NOT NULL default '',
  `pw` varchar(20) NOT NULL default '',
  `mail` varchar(40) NOT NULL default '',
  `tim` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `numb1`
--


/*!40000 ALTER TABLE `numb1` DISABLE KEYS */;
LOCK TABLES `numb1` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `numb1` ENABLE KEYS */;

--
-- Table structure for table `onlcount`
--

DROP TABLE IF EXISTS `onlcount`;
CREATE TABLE `onlcount` (
  `id` int(11) NOT NULL auto_increment,
  `page` varchar(80) NOT NULL default '',
  `time` varchar(10) NOT NULL default '',
  `userid` varchar(20) NOT NULL default 'guest',
  `username` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `onlcount`
--


/*!40000 ALTER TABLE `onlcount` DISABLE KEYS */;
LOCK TABLES `onlcount` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `onlcount` ENABLE KEYS */;

--
-- Table structure for table `online`
--

DROP TABLE IF EXISTS `online`;
CREATE TABLE `online` (
  `userid` varchar(20) NOT NULL default '',
  `ontims` int(11) default '0',
  `txt` int(11) default '0',
  `re` int(11) default '0',
  `point` int(11) default '0',
  `popu` int(11) NOT NULL default '0',
  `suptxt` int(11) default '0',
  `recomtxt` int(11) NOT NULL default '0',
  `lastip` varchar(15) default NULL,
  `lastim` datetime default '0000-00-00 00:00:00',
  `penname1` varchar(250) default NULL,
  `penname2` varchar(250) default NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `online`
--


/*!40000 ALTER TABLE `online` DISABLE KEYS */;
LOCK TABLES `online` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `online` ENABLE KEYS */;

--
-- Table structure for table `rebtable1`
--

DROP TABLE IF EXISTS `rebtable1`;
CREATE TABLE `rebtable1` (
  `id` int(11) NOT NULL auto_increment,
  `bbsid` int(11) default '0',
  `boardid` int(11) NOT NULL default '0',
  `retitle` varchar(40) NOT NULL default '',
  `txt` text NOT NULL,
  `userid` varchar(20) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editime` datetime default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `penname` varchar(250) default NULL,
  `upload_pic` varchar(100) NOT NULL default '',
  `upload_file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rebtable1`
--


/*!40000 ALTER TABLE `rebtable1` DISABLE KEYS */;
LOCK TABLES `rebtable1` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `rebtable1` ENABLE KEYS */;

--
-- Table structure for table `rebtable2`
--

DROP TABLE IF EXISTS `rebtable2`;
CREATE TABLE `rebtable2` (
  `id` int(11) NOT NULL auto_increment,
  `bbsid` int(11) default '0',
  `boardid` int(11) NOT NULL default '0',
  `retitle` varchar(40) NOT NULL default '',
  `txt` text NOT NULL,
  `userid` varchar(20) NOT NULL default '',
  `username` varchar(20) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editime` datetime default '0000-00-00 00:00:00',
  `ip` varchar(15) NOT NULL default '',
  `penname` varchar(250) default NULL,
  `upload_pic` varchar(100) NOT NULL default '',
  `upload_file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rebtable2`
--


/*!40000 ALTER TABLE `rebtable2` DISABLE KEYS */;
LOCK TABLES `rebtable2` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `rebtable2` ENABLE KEYS */;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userid` varchar(20) NOT NULL default '',
  `step` int(11) NOT NULL default '1',
  `root` varchar(75) default NULL,
  `question` varchar(30) NOT NULL default '',
  `answer` varchar(30) NOT NULL default '',
  `face` varchar(50) default NULL,
  `name` varchar(20) default NULL,
  `sex` varchar(5) default NULL,
  `birth` varchar(10) default '2004-12-02',
  `mail` varchar(5) default NULL,
  `qq` varchar(15) default NULL,
  `web` varchar(30) default NULL,
  `tel` varchar(15) default NULL,
  `comefrom` varchar(20) default NULL,
  `job` varchar(20) default NULL,
  `love` varchar(30) default NULL,
  `aboutme` varchar(200) default NULL,
  `refusemassage` char(2) NOT NULL default 'n',
  PRIMARY KEY  (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--


/*!40000 ALTER TABLE `user` DISABLE KEYS */;
LOCK TABLES `user` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -