【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,bookshop.mysql200805211639.sql,希望对大家有所帮助!
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.22-community-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 utf8 */;
/*!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' */;
--
-- Create schema bookshop
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ bookshop;
USE bookshop;
--
-- Table structure for table `bookshop`.`admin`
--
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`adminid` int(11) NOT NULL auto_increment,
`adminname` varchar(50) NOT NULL,
`adminpass` varchar(50) NOT NULL,
PRIMARY KEY (`adminid`),
UNIQUE KEY `adminname` (`adminname`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
--
-- Dumping data for table `bookshop`.`admin`
--
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
--
-- Table structure for table `bookshop`.`books`
--
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
`bookid` int(10) unsigned NOT NULL auto_increment,
`bookname` varchar(45) NOT NULL,
`typeid` int(10) unsigned NOT NULL,
`price` float default NULL,
`saleprice` float default NULL,
`descript` varchar(45) default NULL,
`imageurl` varchar(45) default NULL,
`saletime` datetime default NULL,
PRIMARY KEY (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
--
-- Dumping data for table `bookshop`.`books`
--
/*!40000 ALTER TABLE `books` DISABLE KEYS */;
INSERT INTO `books` (`bookid`,`bookname`,`typeid`,`price`,`saleprice`,`descript`,`imageurl`,`saletime`) VALUES
(1,'c++ programe',1,45,39,'about c++','001.jpg','2008-05-12 00:00:00'),
(2,'java programe',1,45,39,'about java programe','003.jpg','2008-05-12 00:00:00'),
(3,'鑻辫璇硶',2,30,28,'楂橀樁鑻辫璇硶','004.jpg','2008-05-20 00:00:00'),
(4,'鐢═CP/IP杩涜缃戦檯浜掕繛',3,30,28,'TCP/IP缃戠粶閫氫俊瀛︿範璧勬枡','002.jpg','2008-05-20 00:00:00'),
(5,'缃戠粶缁煎悎甯冪嚎鎶鏈?,3,30,28,'缃戠粶宸ョ▼甯堝繀澶囨妧鏈墜鍐?,'wangluobuxian.jpg','2008-05-20 00:00:00');
/*!40000 ALTER TABLE `books` ENABLE KEYS */;
--
-- Table structure for table `bookshop`.`booktype`
--
DROP TABLE IF EXISTS `booktype`;
CREATE TABLE `booktype` (
`typeid` int(10) unsigned NOT NULL auto_increment,
`typename` varchar(45) NOT NULL,
`booktypename` varchar(255) default NULL,
PRIMARY KEY (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
--
-- Dumping data for table `bookshop`.`booktype`
--
/*!40000 ALTER TABLE `booktype` DISABLE KEYS */;
INSERT INTO `booktype` (`typeid`,`typename`,`booktypename`) VALUES
(1,'绋嬪簭璁捐',NULL),
(2,'澶栬瀛︿範',NULL),
(3,'缃戠粶閫氫俊',NULL);
/*!40000 ALTER TABLE `booktype` ENABLE KEYS */;
--
-- Table structure for table `bookshop`.`orders`
--
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`orderid` varchar(45) NOT NULL,
`username` varchar(45) NOT NULL,
`realname` varchar(45) NOT NULL,
`address` varchar(45) NOT NULL,
`zip` int(10) unsigned default NULL,
`tel` varchar(45) NOT NULL,
`email` varchar(45) NOT NULL,
`price` float NOT NULL,
`ordertime` varchar(45) NOT NULL,
`descript` varchar(45) default NULL,
PRIMARY KEY (`orderid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
--
-- Dumping data for table `bookshop`.`orders`
--
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` (`orderid`,`username`,`realname`,`address`,`zip`,`tel`,`email`,`price`,`ordertime`,`descript`) VALUES
('sa','sa','灏忕帇','鍖椾含11鍙?,10,'010-123456','xw1314@163.com',78,'2008-05-20 17:26:51','--\r\n');
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
--
-- Table structure for table `bookshop`.`shopcart`
--
DROP TABLE IF EXISTS `shopcart`;
CREATE TABLE `shopcart` (
`cartid` int(10) unsigned default NULL,
`orderid` varchar(45) default NULL,
`bookid` int(10) unsigned NOT NULL auto_increment,
`count` int(10) unsigned default NULL,
`price` double default NULL,
PRIMARY KEY (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
--
-- Dumping data for table `bookshop`.`shopcart`
--
/*!40000 ALTER TABLE `shopcart`