【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:book_city.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- 主机: 220.134.132.173
-- 建立日期: Jan 11, 2006, 11:36 PM
-- 服务器版本: 5.0.15
--
PHP 版本: 5.0.4
--
-- 数据库: `book_city`
--
-- --------------------------------------------------------
--
-- 数据表格式: `access`
--
CREATE TABLE `access` (
`post_no` int(8) NOT NULL,
`access_count` int(6) NOT NULL,
PRIMARY KEY (`post_no`)
) ENGINE=InnoDB DEFAULT CHARSET=big5;
--
-- 列出以下数据库的数据: `access`
--
INSERT INTO `access` VALUES (1, 24);
INSERT INTO `access` VALUES (2, 22);
INSERT INTO `access` VALUES (6, 14);
INSERT INTO `access` VALUES (9, 13);
INSERT INTO `access` VALUES (10, 12);
INSERT INTO `access` VALUES (11, 9);
INSERT INTO `access` VALUES (12, 6);
INSERT INTO `access` VALUES (13, 6);
INSERT INTO `access` VALUES (14, 7);
INSERT INTO `access` VALUES (15, 14);
INSERT INTO `access` VALUES (16, 7);
INSERT INTO `access` VALUES (17, 3);
INSERT INTO `access` VALUES (18, 3);
INSERT INTO `access` VALUES (19, 9);
INSERT INTO `access` VALUES (20, 5);
INSERT INTO `access` VALUES (21, 5);
-- --------------------------------------------------------
--
-- 数据表格式: `admin`
--
CREATE TABLE `admin` (
`pass
word` varchar(10) character set ascii NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=big5;
--
-- 列出以下数据库的数据: `admin`
--
INSERT INTO `admin` VALUES ('jk0301');
-- --------------------------------------------------------
--
-- 数据表格式: `book`
--
CREATE TABLE `book` (
`vip_id` varchar(15) character set ascii NOT NULL,
`isbn` varchar(15) character set ascii default NULL,
`book_id` int(6) NOT NULL auto_increment,
`bk_publisher` varchar(80) default NULL,
`bk_writer` varchar(80) default NULL,
`bk_name` varchar(60) NOT NULL,
`ver` tinyint(2) NOT NULL default '1',
`amount` int(5) NOT NULL default '1',
`bk_prize` int(5) NOT NULL,
`book_con` tinyint(8) NOT NULL,
`book_inf` varchar(1000) NOT NULL,
`book_img` varchar(80) default NULL,
`p_date` char(10) character set ascii NOT NULL,
PRIMARY KEY (`book_id`),
KEY `vip_id` (`vip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=big5 AUTO_INCREMENT=124 ;
--
-- --------------------------------------------------------
--
-- 数据表格式: `book_access`
--
CREATE TABLE `book_access` (
`book_no` varchar(6) character set ascii NOT NULL,
`access_count` int(6) NOT NULL,
PRIMARY KEY (`book_no`)
) ENGINE=InnoDB DEFAULT CHARSET=big5;
--
-- 列出以下数据库的数据: `book_access`
--
INSERT INTO `book_access` VALUES ('', 0);
INSERT INTO `book_access` VALUES ('100', 0);
INSERT INTO `book_access` VALUES ('101', 1);
INSERT INTO `book_access` VALUES ('102', 0);
INSERT INTO `book_access` VALUES ('103', 0);
INSERT INTO `book_access` VALUES ('104', 0);
INSERT INTO `book_access` VALUES ('105', 1);
INSERT INTO `book_access` VALUES ('106', 1);
INSERT INTO `book_access` VALUES ('107', 0);
INSERT INTO `book_access` VALUES ('108', 0);
INSERT INTO `book_access` VALUES ('109', 1);
INSERT INTO `book_access` VALUES ('110', 0);
INSERT INTO `book_access` VALUES ('111', 0);
INSERT INTO `book_access` VALUES ('112', 1);
INSERT INTO `book_access` VALUES ('113', 1);
INSERT INTO `book_access` VALUES ('114', 0);
INSERT INTO `book_access` VALUES ('115', 0);
INSERT INTO `book_access` VALUES ('116', 1);
INSERT INTO `book_access` VALUES ('117', 1);
INSERT INTO `book_access` VALUES ('118', 1);
INSERT INTO `book_access` VALUES ('119', 1);
INSERT INTO `book_access` VALUES ('120', 0);
INSERT INTO `book_access` VALUES ('121', 0);
INSERT INTO `book_access` VALUES ('122', 0);
INSERT INTO `book_access` VALUES ('123', 0);
INSERT INTO `book_access` VALUES ('37', 0);
INSERT INTO `book_access` VALUES ('38', 0);
INSERT INTO `book_access` VALUES ('39', 0);
INSERT INTO `book_access` VALUES ('40', 0);
INSERT INTO `book_access` VALUES ('41', 0);
INSERT INTO `book_access` VALUES ('42', 0);
INSERT INTO `book_access` VALUES ('43', 0);
INSERT INTO `book_access` VALUES ('44', 0);
INSERT INTO `book_access` VALUES ('45', 0);
INSERT INTO `book_access` VALUES ('46', 2);
INSERT INTO `book_access` VALUES ('47', 2);
INSERT INTO `book_access` VALUES ('48', 0);
INSERT INTO `book_access` VALUES ('49', 0);
INSERT INTO `book_access` VALUES ('50', 1);
INSERT INTO `book_access` VALUES ('51', 0);
INSERT INTO `book_access` VALUES ('52', 0);
INSERT INTO `book_access` VALUES ('53', 0);
INSERT INTO `book_access` VALUES ('54', 0);
INSERT INTO `book_access` VALUES ('55', 0);
INSERT INTO `book_access` VALUES ('56', 0);
INSERT INTO `book_acce