bunkbook 20070423 0109.sql

网上订票系统源代码

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.18-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 bunkbook
--

CREATE DATABASE IF NOT EXISTS bunkbook;
USE bunkbook;

--
-- Definition of table `bb_control`
--

DROP TABLE IF EXISTS `bb_control`;
CREATE TABLE `bb_control` (
  `SysName` varchar(45) NOT NULL default '',
  `SysAdminEmail` varchar(45) NOT NULL default '',
  `Discount20` float default '0',
  `Discount40` float default '0',
  `Discount40HQ` float default '0'
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

--
-- Dumping data for table `bb_control`
--

/*!40000 ALTER TABLE `bb_control` DISABLE KEYS */;
INSERT INTO `bb_control` (`SysName`,`SysAdminEmail`,`Discount20`,`Discount40`,`Discount40HQ`) VALUES 
 ('网上订舱系统','[e-mail]',50,70,100);
/*!40000 ALTER TABLE `bb_control` ENABLE KEYS */;


--
-- Definition of table `bb_orders`
--

DROP TABLE IF EXISTS `bb_orders`;
CREATE TABLE `bb_orders` (
  `OID` int(10) unsigned NOT NULL auto_increment,
  `OSHIPPER` varchar(25) NOT NULL default '' COMMENT '发货人',
  `OCONSIGNEE` varchar(25) NOT NULL default '' COMMENT '收货人',
  `ONOTIFY` varchar(25) NOT NULL default '' COMMENT '被通知人',
  `ODS` datetime NOT NULL default '1980-01-01 00:00:00' COMMENT '出货日期',
  `OPOL` varchar(20) NOT NULL default '' COMMENT '装货港',
  `OPOD` varchar(20) NOT NULL default '' COMMENT '目的港',
  `ODOG` varchar(45) NOT NULL default '' COMMENT '货品名',
  `OMARKS` varchar(15) NOT NULL default '' COMMENT '唛头',
  `OQTY` smallint(5) unsigned NOT NULL default '0' COMMENT '数量',
  `OGW` float unsigned NOT NULL default '0' COMMENT '毛重',
  `OCBM` float unsigned NOT NULL default '0' COMMENT '体积',
  `OFRIGHT` tinyint(1) unsigned NOT NULL default '0' COMMENT '运费',
  `OCONTAINER` tinyint(1) unsigned NOT NULL default '0' COMMENT '箱型',
  `OCSIZE` tinyint(1) unsigned NOT NULL default '0' COMMENT '尺寸',
  `OCN` smallint(5) unsigned NOT NULL default '0' COMMENT '数量',
  `ODELIVER` tinyint(1) NOT NULL default '0' COMMENT '送货',
  `OCONSIGNEEC` varchar(25) NOT NULL default '' COMMENT '托运公司',
  `OTEL` varchar(20) NOT NULL default '' COMMENT '电话',
  `OFAX` varchar(20) NOT NULL default '' COMMENT '传真',
  `OCONNECT` varchar(25) NOT NULL default '' COMMENT '联系人',
  `ODATE` datetime NOT NULL default '1980-01-01 00:00:00' COMMENT '日期',
  `OREMARKS` varchar(200) NOT NULL default '' COMMENT '备注或要求',
  `OPubDate` datetime NOT NULL default '1980-01-01 00:00:00' COMMENT '记录添加日期',
  `OState` tinyint(1) unsigned NOT NULL default '0' COMMENT '0为普通订单，1为已经成交订单。',
  `OUID` int(10) unsigned NOT NULL default '0' COMMENT '下订单的用户ID',
  PRIMARY KEY  (`OID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='订单表';

--
-- Dumping data for table `bb_orders`
--

/*!40000 ALTER TABLE `bb_orders` DISABLE KEYS */;
INSERT INTO `bb_orders` (`OID`,`OSHIPPER`,`OCONSIGNEE`,`ONOTIFY`,`ODS`,`OPOL`,`OPOD`,`ODOG`,`OMARKS`,`OQTY`,`OGW`,`OCBM`,`OFRIGHT`,`OCONTAINER`,`OCSIZE`,`OCN`,`ODELIVER`,`OCONSIGNEEC`,`OTEL`,`OFAX`,`OCONNECT`,`ODATE`,`OREMARKS`,`OPubDate`,`OState`,`OUID`) VALUES 
 (3,'大连万州科贸','福州大地出口公司','黄建华','2007-04-11 00:00:00','大连','福州','儿童玩具（TOY）','T07001',100,1.7,20,0,0,0,0,0,'','','','','1980-01-01 00:00:00','','2007-04-20 21:52:07',0,1);
/*!40000 ALTER TABLE `bb_orders` ENABLE KEYS */;


--
-- Definition of table `bb_pubs`
--

DROP TABLE IF EXISTS `bb_pubs`;
CREATE TABLE `bb_pubs` (
  `PID` int(10) unsigned NOT NULL auto_increment,
  `PUID` smallint(6) unsigned NOT NULL default '0',
  `PDate` datetime NOT NULL default '1980-01-01 00:00:00',
  `PTitle` varchar(45) NOT NULL default '',
  `PContent` mediumtext,
  `PType` tinyint(1) unsigned NOT NULL default '0',
  `PUrl` varchar(100) default NULL,
  PRIMARY KEY  (`PID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

--
-- Dumping data for table `bb_pubs`
--

/*!40000 ALTER TABLE `bb_pubs` DISABLE KEYS */;
INSERT INTO `bb_pubs` (`PID`,`PUID`,`PDate`,`PTitle`,`PContent`,`PType`,`PUrl`) VALUES 
 (10,1,'2007-04-20 00:37:06','公司4月举行特惠活动！！','公司4月举行特惠活动！',0,'');
/*!40000 ALTER TABLE `bb_pubs` ENABLE KEYS */;


--
-- Definition of table `bb_sailingdate`
--

DROP TABLE IF EXISTS `bb_sailingdate`;
CREATE TABLE `bb_sailingdate` (
  `SID` int(10) unsigned NOT NULL auto_increment,
  `SRoute` varchar(15) NOT NULL default '' COMMENT '航线',
  `SShip` varchar(15) NOT NULL default '' COMMENT '船名',
  `SSNumber` varchar(10) NOT NULL default '' COMMENT '航次',
  `SLPort` varchar(15) NOT NULL default '' COMMENT '起运港',
  `SDPort` varchar(15) NOT NULL default '' COMMENT '目的港',
  `SLDate` datetime NOT NULL default '1980-01-01 00:00:00' COMMENT '起运日期',
  `SDDate` datetime NOT NULL default '1980-01-01 00:00:00' COMMENT '到达日期',
  `SSMaster` varchar(25) NOT NULL default '' COMMENT '船东',
  `SPPorts` varchar(255) NOT NULL default '' COMMENT '途径港口',
  `SBunkNum20` smallint(5) unsigned NOT NULL default '0' COMMENT '20寸舱位数量',
  `SBP20` float unsigned NOT NULL default '0' COMMENT '20寸舱位价格',
  `SBP40` float unsigned NOT NULL default '0' COMMENT '40寸舱位价格',
  `SBP40HQ` float unsigned NOT NULL default '0' COMMENT '40HQ舱位价格',
  `SBunkNum40` smallint(5) unsigned NOT NULL default '0' COMMENT '40寸舱位数量',
  `SBunkNum40HQ` smallint(5) unsigned NOT NULL default '0' COMMENT '40HQ舱位数量',
  `SRemark` varchar(200) NOT NULL default '' COMMENT '备注',
  PRIMARY KEY  (`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='船期表';

--
-- Dumping data for table `bb_sailingdate`
--

/*!40000 ALTER TABLE `bb_sailingdate` DISABLE KEYS */;
INSERT INTO `bb_sailingdate` (`SID`,`SRoute`,`SShip`,`SSNumber`,`SLPort`,`SDPort`,`SLDate`,`SDDate`,`SSMaster`,`SPPorts`,`SBunkNum20`,`SBP20`,`SBP40`,`SBP40HQ`,`SBunkNum40`,`SBunkNum40HQ`,`SRemark`) VALUES 
 (1,'CHINA-JAPAN','SKY BRIGHT','055E/055W','TXG 台中','DAC 大连','2007-04-23 00:00:00','2007-04-30 00:00:00','新海丰航运 SITC','',150,12000,20000,26000,150,50,'4月特惠。');
/*!40000 ALTER TABLE `bb_sailingdate` ENABLE KEYS */;


--
-- Definition of table `bb_users`
--

DROP TABLE IF EXISTS `bb_users`;
CREATE TABLE `bb_users` (
  `UID` int(10) unsigned NOT NULL auto_increment,
  `UNick` varchar(16) NOT NULL default '' COMMENT '登录名',
  `UPwd` varchar(16) character set latin1 NOT NULL default '' COMMENT '登录密码',
  `UName` varchar(10) NOT NULL default '' COMMENT '真实姓名',
  `ULevel` tinyint(1) unsigned NOT NULL default '1' COMMENT '用户等级 1 普通 2 VIP 3 超级管理员',
  `ULastIP` varchar(15) character set latin1 default NULL COMMENT '上次登录IP',
  `ULastDate` datetime default NULL COMMENT '上次登录时间',
  `ULoginTimes` smallint(6) unsigned default '0',
  `UEmail` varchar(45) default NULL,
  `UCount` smallint(5) unsigned NOT NULL default '0' COMMENT '成功订单数量',
  PRIMARY KEY  (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='用户表';

--
-- Dumping data for table `bb_users`
--

/*!40000 ALTER TABLE `bb_users` DISABLE KEYS */;
INSERT INTO `bb_users` (`UID`,`UNick`,`UPwd`,`UName`,`ULevel`,`ULastIP`,`ULastDate`,`ULoginTimes`,`UEmail`,`UCount`) VALUES 
 (1,'admin','admin','超级管理员',3,'192.168.0.2','2007-03-30 18:44:52',47,'[e-mail]',0),
 (4,'zhangsan','1234','张三',2,'192.168.0.2','2007-03-30 18:45:22',8,'[e-mail]',0),
 (8,'lisi','1233','李逍遥',1,'192.168.0.2','2007-03-30 16:24:49',6,'[e-mail]',0),
 (9,'wangwu','123','王五',1,'192.168.0.2','2007-03-30 13:52:26',0,'[e-mail]',0),
 (10,'xiuliu','123','王天相',1,'192.168.0.2','2007-03-30 13:52:26',0,'[e-mail]',0),
 (11,'xiaoqingfeng','12345','张音节',1,'192.168.0.2','2007-03-30 18:45:48',3,'[e-mail]',0),
 (12,'qq','123','琴起',1,'','2007-04-20 01:10:10',0,'a@b.c',0),
 (13,'xiaoqing','123','萧青封',1,'192.168.0.2','2007-04-21 01:47:45',4,'[e-mail]',0),
 (15,'qinxue','123','勤雪',1,'','2007-04-21 01:52:32',0,'[e-mail]',0),
 (18,'com','com','大连九州经贸',2,'192.168.0.2',NULL,3,'a@b.c',0);
/*!40000 ALTER TABLE `bb_users` 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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;