【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-db_database09.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
-- MySQL dump 10.10
--
-- Host: localhost Database: db_database09
-- ------------------------------------------------------
-- Server version 5.0.24a-community-nt-log
/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Temporary table structure for view `chkadmin`
--
DROP TABLE IF EXISTS `chkadmin`;
/*!50001 DROP VIEW IF EXISTS `chkadmin`*/;
/*!50001 CREATE TABLE `chkadmin` (
`name` varchar(50),
`pwd` varchar(50)
) */;
--
-- Temporary table structure for view `goods`
--
DROP TABLE IF EXISTS `goods`;
/*!50001 DROP VIEW IF EXISTS `goods`*/;
/*!50001 CREATE TABLE `goods` (
`id` int(8),
`name` varchar(200),
`shuliang` int(8),
`addtime` datetime,
`price` float
) */;
--
-- Temporary table structure for view `scoreinfo`
--
DROP TABLE IF EXISTS `scoreinfo`;
/*!50001 DROP VIEW IF EXISTS `scoreinfo`*/;
/*!50001 CREATE TABLE `scoreinfo` (
`sno` varchar(50),
`sname` varchar(50),
`yw` int(8),
`wy` int(8),
`sx` int(8)
) */;
--
-- Table structure for table `tb_admin`
--
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`pwd` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_admin`
--
/*!40000 ALTER TABLE `tb_admin` DISABLE KEYS */;
LOCK TABLES `tb_admin` WRITE;
INSERT INTO `tb_admin` VALUES (1,'mr','mrsoft');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_admin` ENABLE KEYS */;
--
-- Table structure for table `tb_changeview`
--
DROP TABLE IF EXISTS `tb_changeview`;
CREATE TABLE `tb_changeview` (
`id` int(8) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`userpwd` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_changeview`
--
/*!40000 ALTER TABLE `tb_changeview` DISABLE KEYS */;
LOCK TABLES `tb_changeview` WRITE;
INSERT INTO `tb_changeview` VALUES (1,'mrlzh','12345678'),(2,'mrjx','87654321');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_changeview` ENABLE KEYS */;
--
-- Table structure for table `tb_goods`
--
DROP TABLE IF EXISTS `tb_goods`;
CREATE TABLE `tb_goods` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(200) NOT NULL,
`shuliang` int(8) NOT NULL,
`addtime` datetime NOT NULL,
`price` float NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_goods`
--
/*!40000 ALTER TABLE `tb_goods` DISABLE KEYS */;
LOCK TABLES `tb_goods` WRITE;
INSERT INTO `tb_goods` VALUES (1,'涓绘澘',12,'2007-03-12 00:00:00',600),(2,'鏄剧ず鍗?,34,'2007-04-20 00:00:00',500);
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_goods` ENABLE KEYS */;
--
-- Table structure for table `tb_leaveword`
--
DROP TABLE IF EXISTS `tb_leaveword`;
CREATE TABLE `tb_leaveword` (
`id` int(8) NOT NULL auto_increment,
`title` varchar(200) NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_leave
word`
--
/*!40000 ALTER TABLE `tb_leaveword` DISABLE KEYS */;
LOCK TABLES `tb_leaveword` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_leaveword` ENABLE KEYS */;
--
-- Table structure for table `tb_modifypro`
--
DROP TABLE IF EXISTS `tb_modifypro`;
CREATE TABLE `tb_modifypro` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`pwd` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tb_modifypro`
--
/*!40000 ALTER TABLE `tb_modifypro` DISABLE KEYS */;
LOCK TABLES `tb_modifypro` WRITE;
INSERT INTO `tb_modifypro` VALUES (1,'mrsoft','12345678'),(2,'mr','87654321');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tb_modifypro` ENABLE