【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-javastepdb.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 bspdb
--
CREATE DATABASE IF NOT EXISTS bspdb;
USE bspdb;
--
-- Definition of table `bsp_corp`
--
DROP TABLE IF EXISTS `bsp_corp`;
CREATE TABLE `bsp_corp` (
`CORP_ID` varchar(5) NOT NULL,
`CORPNAME_CN` varchar(50) default NULL,
`CORPNAME_EN` varchar(50) NOT NULL,
`NATION` varchar(15) NOT NULL,
`MAD_EN` varchar(100) default NULL,
`TELNUM` varchar(16) NOT NULL,
`CONTACT` varchar(20) NOT NULL,
`POSTCODE` varchar(10) NOT NULL,
`EMAIL` varchar(30) NOT NULL,
`NCORPCODE` varchar(20) default NULL,
`PCORPNBR` varchar(5) default NULL,
`CORPTYPE` varchar(3) NOT NULL,
`MAD_CN` varchar(100) default NULL,
`FAXNUM` varchar(15) NOT NULL,
`VRN` varchar(30) default NULL,
PRIMARY KEY (`CORP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bsp_corp`
--
/*!40000 ALTER TABLE `bsp_corp` DISABLE KEYS */;
INSERT INTO `bsp_corp` (`CORP_ID`,`CORPNAME_CN`,`CORPNAME_EN`,`NATION`,`MAD_EN`,`TELNUM`,`CONTACT`,`POSTCODE`,`EMAIL`,`NCORPCODE`,`PCORPNBR`,`CORPTYPE`,`MAD_CN`,`FAXNUM`,`VRN`) VALUES
('1111','aeronote','aerontet','China','ber','222222','1111','111111','tfnew21@sina.com','','','MFR','???','1111',NULL);
/*!40000 ALTER TABLE `bsp_corp` ENABLE KEYS */;
--
-- Definition of table `bsp_corp_spl`
--
DROP TABLE IF EXISTS `bsp_corp_spl`;
CREATE TABLE `bsp_corp_spl` (
`CORP_ID` varchar(5) NOT NULL,
`SPL` varchar(5) NOT NULL,
`LDATE` date NOT NULL,
`NOTES` varchar(1000) default NULL,
PRIMARY KEY (`CORP_ID`,`SPL`),
KEY `FKB1C7559A6B3512F9` (`CORP_ID`),
CONSTRAINT `FKB1C7559A6B3512F9` FOREIGN KEY (`CORP_ID`) REFERENCES `bsp_corp` (`CORP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bsp_corp_spl`
--
/*!40000 ALTER TABLE `bsp_corp_spl` DISABLE KEYS */;
INSERT INTO `bsp_corp_spl` (`CORP_ID`,`SPL`,`LDATE`,`NOTES`) VALUES
('1111','1111','2008-05-15','');
/*!40000 ALTER TABLE `bsp_corp_spl` ENABLE KEYS */;
--
-- Definition of table `bsp_inq`
--
DROP TABLE IF EXISTS `bsp_inq`;
CREATE TABLE `bsp_inq` (
`IID` varchar(20) NOT NULL,
`OIC` varchar(20) default NULL,
`BUYER_ID` varchar(20) NOT NULL,
`CDATE` date NOT NULL,
`REM` varchar(5000) default NULL,
`IFN` varchar(20) default NULL,
`QFN` varchar(20) default NULL,
`STATUS` varchar(2) NOT NULL,
PRIMARY KEY (`IID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bsp_inq`
--
/*!40000 ALTER TABLE `bsp_inq` DISABLE KEYS */;
INSERT INTO `bsp_inq` (`IID`,`OIC`,`BUYER_ID`,`CDATE`,`REM`,`IFN`,`QFN`,`STATUS`) VALUES
('1111200805310000000','','TFNEW','2008-05-31','sdfsfsf',NULL,NULL,'1'),
('1111200805310000001','','TFNEW','2008-05-31','rwrrwer',NULL,NULL,'1');
/*!40000 ALTER TABLE `bsp_inq` ENABLE KEYS */;
--
-- Definition of table `bsp_inq_parts`
--
DROP TABLE IF EXISTS `bsp_inq_parts`;
CREATE TABLE `bsp_inq_parts` (
`IIN` int(11) NOT NULL,
`IID` varchar(20) NOT NULL,
`PNR` varchar(32) NOT NULL,
`MFR` varchar(20) default NULL,
`KWD` varchar(30) NOT NULL,
`BQU` decimal(6,2) NOT NULL,
`UNT` varchar(12) NOT NULL,
`CND` varchar(12) NOT NULL,
`LTM` int(11) default NULL,
`PRI` varchar(5) default NULL,
`REM` varchar(300) default NULL,
`KWD_CN` varchar(30) default NULL,
`CERT` varchar(45) default NULL,
PRIMARY KEY (`IIN`,`IID`),
KEY `FK7CB3BA6D753DC9D1` (`IID`),
CONSTRAINT `FK7CB3BA6D753DC9D1` FOREIGN KEY (`IID`) REFERENCES `bsp_inq` (`IID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bsp_inq_parts`
--
/*!40000 ALTER TABLE `bsp_inq_parts` DISABLE KEYS */;
INSERT INTO `bsp_inq_parts` (`IIN`,`IID`,`PNR`,`MFR`,`KWD`,`BQU`,`UNT`,`CND`,`LTM`,`PRI`,`REM`,`KWD_CN`,`CERT`) VALUES
(1,'1111200805310000