?? numb1.sql
字號(hào):
-- 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','網(wǎng)站建設(shè)','img/logo.gif','','','','pc'),(3,'btable1','Web程序開發(fā)','img/logo.gif','','','','pc'),(4,'btable1','JAVA開發(fā)','img/logo.gif','','','','pc'),(5,'btable1','C/C++開發(fā)','img/logo.gif','','','','pc'),(6,'btable1','數(shù)據(jù)庫開發(fā)','img/logo.gif','','','','pc'),(7,'btable1','BT專區(qū)','img/logo.gif','','','','pc'),(8,'btable1','Windows','img/logo.gif','','','','pc'),(9,'btable1','Linux/Unix','img/logo.gif','','','','pc'),(10,'btable1','網(wǎng)絡(luò)安全','img/logo.gif','','','','pc'),(11,'btable2','幽默圖片','img/logo.gif','','','','other'),(12,'btable2','明星美眉','img/logo.gif','','','','other'),(13,'btable2','自然風(fēng)景','img/logo.gif','','','','other'),(14,'btable2','邊走邊拍','img/logo.gif','','','','other'),(15,'btable2','軍迷世界','img/logo.gif','','','','other'),(16,'btable2','創(chuàng)意之作','img/logo.gif','','','','other'),(17,'btable2','單身一族','img/logo.gif','','','','other'),(18,'btable2','笑話天地','img/logo.gif','','','','other'),(19,'btable2','搞笑視頻','img/logo.gif','','','','other'),(20,'btable2','經(jīng)典短信','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 */;
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -