.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 '',
  `OCONSIGNEE` varchar(25) NOT NULL default '',
  `ONOTIFY` varchar(25) NOT NULL default '' ,
  `ODS` datetime NOT NULL default '1980-01-01 00:00:00' ,
  `OPOL` varchar(20) NOT NULL default '' ,
  `OPOD` varchar(20) NOT NULL default '' ,
  `ODOG` varchar(45) NOT NULL default '' ,
  `OMARKS` varchar(15) NOT NULL default '' ,
  `OQTY` smallint(5) unsigned NOT NULL default '0' ,
  `OGW` float unsigned NOT NULL default '0' ,
  `OCBM` float unsigned NOT NULL default '0' ,
  `OFRIGHT` tinyint(1) unsigned NOT NULL default '0' ,
  `OCONTAINER` tinyint(1) unsigned NOT NULL default '0' ,
  `OCSIZE` tinyint(1) unsigned NOT NULL default '0' ,
  `OCN` smallint(5) unsigned NOT NULL default '0' ,
  `ODELIVER` tinyint(1) NOT NULL default '0' ,
  `OCONSIGNEEC` varchar(25) NOT NULL default '' ,
  `OTEL` varchar(20) NOT NULL default '' ,
  `OFAX` varchar(20) NOT NULL default ''  ,
  `OCONNECT` varchar(25) NOT NULL default '',
  `ODATE` datetime NOT NULL default '1980-01-01 00:00:00' ,
  `OREMARKS` varchar(200) NOT NULL default '' ,
  `OPubDate` datetime NOT NULL default '1980-01-01 00:00:00' ,
  `OState` tinyint(1) unsigned NOT NULL default '0' ,
  `OUID` int(10) unsigned NOT NULL default '0' ,
  PRIMARY KEY  (`OID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 ;

--
-- Dumping data for table `bb_orders`
--
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`
--


--
-- 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 '',
  `SShip` varchar(15) NOT NULL default '' ,
  `SSNumber` varchar(10) NOT NULL default '',
  `SLPort` varchar(15) NOT NULL default '',
  `SDPort` varchar(15) NOT NULL default '' ,
  `SLDate` datetime NOT NULL default '1980-01-01 00:00:00',
  `SDDate` datetime NOT NULL default '1980-01-01 00:00:00',
  `SSMaster` varchar(25) NOT NULL default '' ,
  `SPPorts` varchar(255) NOT NULL default ''  ,
  `SBunkNum20` smallint(5) unsigned NOT NULL default '0' ,
  `SBP20` float unsigned NOT NULL default '0',
  `SBP40` float unsigned NOT NULL default '0',
  `SBP40HQ` float unsigned NOT NULL default '0'  ,
  `SBunkNum40` smallint(5) unsigned NOT NULL default '0' ,
  `SBunkNum40HQ` smallint(5) unsigned NOT NULL default '0' ,
  `SRemark` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`SID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 ;

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



--
-- 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 '' ,
  `UPwd` varchar(16) character set latin1 NOT NULL default '' ,
  `UName` varchar(10) NOT NULL default '' ,
  `ULevel` tinyint(1) unsigned NOT NULL default '1' ,
  `ULastIP` varchar(15) character set latin1 default NULL ,
  `ULastDate` datetime default NULL ,
  `ULoginTimes` smallint(6) unsigned default '0',
  `UEmail` varchar(45) default NULL,
  `UCount` smallint(5) unsigned NOT NULL default '0' ,
  PRIMARY KEY  (`UID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

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





/*!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 */;