【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“flower.sql”一文,供大家参考学习
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# 主机: localhost
# 建立日期: Jan 15, 2005, 11:06 PM
# 服务器版本: 4.0.20
#
PHP 版本: 4.3.4
#
# 数据库: `flower`
#
# --------------------------------------------------------
#
# 数据表格式: `board`
#
CREATE TABLE `board` (
`board_title` varchar(60) NOT NULL default '',
`board_nickname` varchar(20) NOT NULL default '',
`board_contant` varchar(255) NOT NULL default '',
`board_time` datetime NOT NULL default '0000-00-00 00:00:00',
`board_no` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`board_no`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;
#
# 列出以下数据库的数据: `board`
#
INSERT INTO `board` (`board_title`, `board_nickname`, `board_contant`, `board_time`, `board_no`) VALUES ('jkl ajofj l', 'amy', 'l;aj jlfjfmgkgjjggj', '2005-01-13 07:39:11', 36);
# --------------------------------------------------------
#
# 数据表格式: `bull`
#
CREATE TABLE `bull` (
`bulletins_no` int(10) NOT NULL auto_increment,
`bulletins_date` date default NULL,
`bulletins_title` varchar(50) default NULL,
`bulletins_contant` varchar(255) default NULL,
PRIMARY KEY (`bulletins_no`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
#
# 列出以下数据库的数据: `bull`
#
INSERT INTO `bull` (`bulletins_no`, `bulletins_date`, `bulletins_title`, `bulletins_contant`) VALUES (9, '2005-01-13', 'jfksl', 'fj;j ;jgkgjhjhl');
INSERT INTO `bull` (`bulletins_no`, `bulletins_date`, `bulletins_title`, `bulletins_contant`) VALUES (8, '2005-01-11', '网络花店今日开张', '
网络花店今日开张,所有的花都有特价,要买要快!!');
# --------------------------------------------------------
#
# 数据表格式: `company`
#
CREATE TABLE `company` (
`company_name` varchar(30) NOT NULL default '',
`company_tel` varchar(10) default NULL,
`company_fax` varchar(10) default NULL,
`company_number` varchar(10) default NULL,
`company_add` varchar(50) NOT NULL default '',
`company_email` varchar(25) NOT NULL default '',
`company_person` varchar(30) NOT NULL default '',
`company_introduction` varchar(255) NOT NULL default '',
PRIMARY KEY (`company_name`)
) TYPE=MyISAM;
#
# 列出以下数据库的数据: `company`
#
INSERT INTO `company` (`company_name`, `company_tel`, `company_fax`, `company_number`, `company_add`, `company_email`, `company_person`, `company_introduction`) VALUES ('圆仔花', '06-2569485', '06-2569486', '87694534', '台南县大湾路1234号', 'ksut@ksut.com.tw', 'ivy', '');
# --------------------------------------------------------
#
# 数据表格式: `oder`
#
CREATE TABLE `oder` (
`order_no` varchar(20) NOT NULL default '',
`order_quantity` int(5) NOT NULL default '0',
`order_total` float NOT NULL default '0',
`order_date` date NOT NULL default '0000-00-00',
`order_deliver_date` date NOT NULL default '0000-00-00',
`order_deliver_address` varchar(100) NOT NULL default '',
`order_receiver` varchar(20) NOT NULL default '',
`order_card` varchar(255) NOT NULL default '',
`order_sugary` varchar(255) NOT NULL default '',
`order_status` varchar(255) NOT NULL default '',
`product_no` varchar(10) NOT NULL default '',
`product_name` varchar(30) NOT NULL default '',
`product_price` float NOT NULL default '0',
`product_price_rebate` float NOT NULL default '0',
`order_pay` float NOT NULL default '0',
`userdata_id_number` varchar(12) NOT NULL default ''
) TYPE=MyISAM;
#
# 列出以下数据库的数据: `oder`
#
INSERT INTO `oder` (`order_no`, `order_quantity`, `order_total`, `order_date`, `order_deliver_date`, `order_deliver_address`, `order_receiver`, `order_card`, `order_sugary`, `order_status`, `product_no`, `product_name`, `product_price`, `product_price_rebate`, `order_pay`, `userdata_id_number`) VALUES ('3681105800978', 1, '5000', '2005-01-15', '2005-06-03', 'tests', 'ling', 'photo/product/card1.jpg', '', '', 'EE0007', '小熊花束2', '5000', '5000', '5000', '0');
INSERT INTO `oder` (`order_no`, `order_quantity`, `order_total`, `order_date`, `order_deliver_date`, `order_deliver_address`, `order_receiver`, `order_card`, `order_sugary`, `order_status`, `product_no`, `product_name`, `product_price`, `product_price_rebate`, `order_pay`, `userdata_id_number`) VALUES ('79', 1, '5000', '2005-01-15', '2005-06-03', 'tests', 'ling', 'photo/product/card1.jpg', ''