mydb.script

杰表服务器 部分源码 杰创网络报表(简称“杰表”)是一款国产的网络报表开发工具

CREATE TABLE NEXTCUST(NEWCUST DOUBLE)
CREATE TABLE LRB(BZDW VARCHAR,YEAR VARCHAR,MONTH VARCHAR,DW VARCHAR,XM VARCHAR,HH INTEGER,BYS DOUBLE,BNLJ DOUBLE)
CREATE TABLE EMPLOYEE(EMPNO INTEGER,LASTNAME VARCHAR,FIRSTNAME VARCHAR,PHONEEXT VARCHAR,HIREDATE TIMESTAMP,SALARY DOUBLE)
CREATE TABLE INPUT(NUM INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,KIND VARCHAR,GRADE VARCHAR,NAME VARCHAR,UNIT VARCHAR,AMOUNT INTEGER,PRICE NUMERIC(19,4),TOTAL NUMERIC(19,4))
CREATE TABLE CHEQUE(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,PAY_TO VARCHAR,PAY_FOR VARCHAR,PAY_DAY TIMESTAMP,PAY_AMOUNT REAL,PAY_FROM_ACCOUNT VARCHAR,PAY_FROM VARCHAR)
CREATE TABLE JY(ID1 INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,NJ VARCHAR,ZY VARCHAR,BYRS INTEGER,GQRS INTEGER,GXBL DOUBLE,JYL DOUBLE)
CREATE TABLE HYCKWTS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,SHIPPER LONGVARCHAR,FAXNO VARCHAR,TO VARCHAR,ATTN VARCHAR,DATE VARCHAR,CONSIGNEE LONGVARCHAR,WTF LONGVARCHAR,TEL VARCHAR,FAX VARCHAR,LXR VARCHAR,NOTIFY LONGVARCHAR,WYBH VARCHAR,LOADING LONGVARCHAR,DISCHARGE LONGVARCHAR,DELIVERY LONGVARCHAR,ZQ VARCHAR,MARKS VARCHAR,OF VARCHAR,GOODS LONGVARCHAR,WEIGHT VARCHAR,MEAS VARCHAR,TOTAL VARCHAR)
CREATE TABLE ITEMS(ORDERNO DOUBLE,ITEMNO DOUBLE,PARTNO DOUBLE,QTY INTEGER,DISCOUNT DOUBLE)
CREATE TABLE GDP(CY VARCHAR,FFB DOUBLE)
CREATE TABLE PARTS(PARTNO DOUBLE,VENDORNO DOUBLE,DESCRIPTION VARCHAR,ONHAND DOUBLE,ONORDER DOUBLE,COST DOUBLE,LISTPRICE DOUBLE)
CREATE TABLE COUNTRY(NAME VARCHAR,CAPITAL VARCHAR,CONTINENT VARCHAR,AREA DOUBLE,POPULATION DOUBLE)
CREATE TABLE LIFE(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,TBR VARCHAR,BXDH VARCHAR,XZ VARCHAR,PA_NO VARCHAR,GR_NO VARCHAR,BBR VARCHAR,GH VARCHAR,SPJE NUMERIC(19,4),JFJE NUMERIC(19,4),GGBE NUMERIC(19,4),MZ VARCHAR,ZY VARCHAR,SY VARCHAR,LDBBR INTEGER,BZ VARCHAR,NUM INTEGER)
CREATE TABLE BIOLIFE(SPEC_NO DOUBLE,CATAGORY VARCHAR,NAME VARCHAR,SPEC_NAME VARCHAR,LEN_CM DOUBLE,LEN_IN DOUBLE,NOTE LONGVARCHAR,PICTURE LONGVARBINARY)
CREATE TABLE LIST(ID1 INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,QYBM VARCHAR,JCKLM VARCHAR,UNIT VARCHAR,SN_NUM INTEGER,SN_JE DOUBLE,BN_NUM DOUBLE,BN_JE DOUBLE,WT_NUM DOUBLE,WT_JE DOUBLE,ZJ_NUM DOUBLE,JL_JE DOUBLE,XS_JE DOUBLE,DKSL DOUBLE,JXSE DOUBLE,YDSE DOUBLE,YIDSE DOUBLE)
CREATE TABLE ZCFZB(ID DOUBLE,ZC VARCHAR,HC DOUBLE,NCS VARCHAR,QMS VARCHAR,FZQY VARCHAR,HC2 DOUBLE,NCS2 VARCHAR,QMS2 VARCHAR)
CREATE TABLE DATA(ID1 INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,DQ VARCHAR,\u6708\u4efd VARCHAR,CP VARCHAR,D1 DOUBLE,D2 REAL,D3 DOUBLE,D4 DOUBLE,D5 REAL,D6 DOUBLE,D7 DOUBLE,D8 DOUBLE,D9 DOUBLE,D10 DOUBLE,D11 DOUBLE,D12 DOUBLE,D13 DOUBLE,D14 DOUBLE,D15 DOUBLE,D16 DOUBLE,D17 REAL,D18 DOUBLE)
CREATE TABLE LIFE3(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,YSXD_NUM INTEGER,YSXD_BFA NUMERIC(19,4),YSXD_NUMB INTEGER,YSXD_BFB NUMERIC(19,4),YSWS_NUMC INTEGER,JJBF NUMERIC(19,4))
CREATE TABLE LIFE2(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,FGS VARCHAR,JS INTEGER,BXHTH VARCHAR,NUM INTEGER,BBR_NO VARCHAR,BBR_NAME VARCHAR,XZ VARCHAR,BE NUMERIC(19,4),BF NUMERIC(19,4),HBJD VARCHAR)
CREATE TABLE DA_DEMO(ID1 VARCHAR,ID DOUBLE,NAME VARCHAR,SEX VARCHAR,BORN TIMESTAMP,JOB_DATE TIMESTAMP,GL DOUBLE,ZZMM VARCHAR,JBGZ DOUBLE,ZWGZ DOUBLE,GLGZ DOUBLE,JTJJ DOUBLE,YFGZ DOUBLE,YSXL VARCHAR,SXZY VARCHAR,BYXX VARCHAR,ZHXL VARCHAR,QZ VARCHAR,ZB VARCHAR)
CREATE TABLE SALES(\u7f16\u53f7 INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,DQ VARCHAR,DW VARCHAR,NAME VARCHAR,YEAR INTEGER,QUARTER VARCHAR,MONTH INTEGER,MONTH_NUM INTEGER)
CREATE TABLE ORDERS(ORDERNO DOUBLE,CUSTNO DOUBLE,SALEDATE TIMESTAMP,SHIPDATE TIMESTAMP,EMPNO INTEGER,SHIPTOCONTACT VARCHAR,SHIPTOADDR1 VARCHAR,SHIPTOADDR2 VARCHAR,SHIPTOCITY VARCHAR,SHIPTOSTATE VARCHAR,SHIPTOZIP VARCHAR,SHIPTOCOUNTRY VARCHAR,SHIPTOPHONE VARCHAR,SHIPVIA VARCHAR,PO VARCHAR,TERMS VARCHAR,PAYMENTMETHOD VARCHAR,ITEMSTOTAL DOUBLE,TAXRATE DOUBLE,FREIGHT DOUBLE,AMOUNTPAID DOUBLE)
CREATE TABLE NEXTITEM(NEWKEY DOUBLE)
CREATE TABLE NEXTORD(NEWKEY DOUBLE)
CREATE TABLE CIQ(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,LRID VARCHAR,HGBH VARCHAR,CKKA VARCHAR,BAH VARCHAR,CKRQ TIMESTAMP,SBRQ TIMESTAMP,JYDW VARCHAR,YCFS VARCHAR,YCGJM VARCHAR,TYDH VARCHAR,XKZH VARCHAR,YDG VARCHAR,ZYG VARCHAR,JNHYD VARCHAR,PZWH VARCHAR,CJFS VARCHAR,YF NUMERIC(19,4),BF NUMERIC(19,4),ZF NUMERIC(19,4),HTXYH VARCHAR,JS INTEGER,BZZL VARCHAR,MZ INTEGER,JZ INTEGER,JZXH VARCHAR,SFDJ VARCHAR,SCCJ VARCHAR,BJH VARCHAR,XH VARCHAR,SPBH VARCHAR,SPMC VARCHAR,GGXH VARCHAR,SLDW VARCHAR,MDG VARCHAR,DJ NUMERIC(19,4),ZJ NUMERIC(19,4),BJ NUMERIC(19,4),BZ VARCHAR,ZM VARCHAR,SFZSQK VARCHAR,LRY VARCHAR,LRDW VARCHAR,BGY VARCHAR,DWDZ VARCHAR,YB INTEGER,DH VARCHAR,SBDW VARCHAR,TZRQ TIMESTAMP,SD VARCHAR,SJ VARCHAR,ZS VARCHAR,TJ VARCHAR,SY VARCHAR,FX VARCHAR)
CREATE TABLE HXFP(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,ZHI LONGVARCHAR,TO LONGVARCHAR,FPBH LONGVARCHAR,DATE VARCHAR,NM VARCHAR,ADD VARCHAR,DJ VARCHAR,ZJ VARCHAR,PAYTO LONGVARCHAR)
CREATE TABLE DDD(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,D1 VARCHAR,D2 INTEGER,D3 VARCHAR,D4 TIMESTAMP,D5 LONGVARCHAR)
CREATE TABLE GERIMUDANG(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,BIANHAO VARCHAR,KEHUXINZHI VARCHAR,JIANDIANGSHIJIAN TIMESTAMP,CYNAME VARCHAR,FARENDAIBIAO VARCHAR,ZHUCHE INTEGER,ZHIGONGRENSHU INTEGER,CYADDRESS VARCHAR,BANK VARCHAR,BANK_ID VARCHAR,BANK_SHUI_ID VARCHAR,NAME VARCHAR,ZHIWU VARCHAR,TEL VARCHAR,MOD_TEL INTEGER,FAX VARCHAR,FAM_TEL VARCHAR,RENFEI INTEGER,NIANXUQIU INTEGER,NOTE LONGVARCHAR)
CREATE TABLE LIST_M(ID1 INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,QYDM VARCHAR,QYMC VARCHAR,QYLX VARCHAR,SCQ VARCHAR,UNIT VARCHAR)
CREATE TABLE COUNTRYCN(NAME VARCHAR,CAPITAL VARCHAR,CONTINENT VARCHAR,AREA DOUBLE,POPULATION DOUBLE)
CREATE TABLE CUSTOMER(CUSTNO DOUBLE,COMPANY VARCHAR,ADDR1 VARCHAR,ADDR2 VARCHAR,CITY VARCHAR,STATE VARCHAR,ZIP VARCHAR,COUNTRY VARCHAR,PHONE VARCHAR,FAX VARCHAR,TAXRATE DOUBLE,CONTACT VARCHAR,LASTINVOICEDATE TIMESTAMP)
CREATE TABLE BIANZHIDAI(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,DANWEI VARCHAR,HAO INTEGER,DANJIA VARCHAR,D1 INTEGER,D2 INTEGER,E1 INTEGER,D22 INTEGER,R1 INTEGER,R2 INTEGER,RDD INTEGER)
CREATE TABLE PICTURE(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,NAME VARCHAR,PICTURE LONGVARBINARY)
CREATE TABLE VENDORS(VENDORNO DOUBLE,VENDORNAME VARCHAR,ADDRESS1 VARCHAR,ADDRESS2 VARCHAR,CITY VARCHAR,STATE VARCHAR,ZIP VARCHAR,COUNTRY VARCHAR,PHONE VARCHAR,FAX VARCHAR,PREFERRED INTEGER)
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO NEXTCUST VALUES(9851.0E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u4e00\u3001\u4e3b\u8425\u4e1a\u52a1\u6536\u5165',1,265.21E0,985.05E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u51cf\uff1a\u4e3b\u8425\u4e1a\u52a1\u6210\u672c',4,257.03E0,7538.37E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u3000\u3000\u4e3b\u8425\u4e1a\u52a1\u7a0e\u91d1\u53ca\u9644\u52a0',5,325.87E0,385.45E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u4e8c\u3001\u4e3b\u8425\u4e1a\u52a1\u5229\u6da6\uff08\u4e8f\u635f\u4ee5\u201c\uff0d\u201d\u53f7\u586b\u5217\uff09',10,547.32E0,15897.81E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u52a0\uff1a\u5176\u4ed6\u4e1a\u52a1\u5229\u6da6\uff08\u4e8f\u635f\u4ee5\u201c\uff0d\u201d\u53f7\u586b\u5217\uff09',11,210.58E0,2130.98E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u51cf\uff1a\u8425\u4e1a\u8d39\u7528',14,148.29E0,753.25E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u3000\u3000\u7ba1\u7406\u8d39\u7528',15,265.21E0,985.05E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u3000\u3000\u8d22\u52a1\u8d39\u7528',16,157.65E0,4685.21E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u4e09\u3001\u8425\u4e1a\u5229\u6da6\uff08\u4e8f\u635f\u4ee5\u201c\uff0d\u201d\u53f7\u586b\u5217\uff09',18,325.87E0,385.45E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u52a0\uff1a\u6295\u8d44\u6536\u76ca\uff08\u4e8f\u635f\u4ee5\u201c\uff0d\u201d\u53f7\u586b\u5217\uff09',19,547.32E0,15897.81E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u3000\u3000\u8865\u8d34\u6536\u5165',22,210.58E0,2130.98E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u3000\u3000\u8425\u4e1a\u5916\u6536\u5165',23,148.29E0,753.25E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u51cf\uff1a\u8425\u4e1a\u5916\u652f\u51fa',25,265.21E0,985.05E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u56db\u3001\u5229\u6da6\u603b\u989d\uff08\u4e8f\u635f\u603b\u989d\u4ee5\u201c\uff0d\u201d\u53f7\u586b\u5217\uff09',27,85.67E0,223.612E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u3000\u3000\u51cf\uff1a\u6240\u5f97\u7a0e',28,325.87E0,385.45E0)
INSERT INTO LRB VALUES('\u4e0a\u6d77\u987a\u6b23\u6280\u672f\u6709\u9650\u516c\u53f8','2004','2','\u5143','\u4e94\u3001\u51c0\u5229\u6da6\uff08\u51c0\u4e8f\u635f\u4ee5\u201c\uff0d\u201d\u53f7\u586b\u5217\uff09',30,547.32E0,15897.81E0)
INSERT INTO EMPLOYEE VALUES(2,'Nelson','Roberto','250','1988-12-28 00:00:00.0',40000.0E0)
INSERT INTO EMPLOYEE VALUES(4,'Young','Bruce','233','1988-12-28 00:00:00.0',55500.0E0)
INSERT INTO EMPLOYEE VALUES(5,'Lambert','Kim','22','1989-02-06 00:00:00.0',25000.0E0)
INSERT INTO EMPLOYEE VALUES(8,'Johnson','Leslie','410','1989-04-05 00:00:00.0',25050.0E0)
INSERT INTO EMPLOYEE VALUES(9,'Forest','Phil','229','1989-04-17 00:00:00.0',25050.0E0)
INSERT INTO EMPLOYEE VALUES(11,'Weston','K. J.','34','1990-01-17 00:00:00.0',33292.9375E0)
INSERT INTO EMPLOYEE VALUES(12,'Lee','Terri','256','1990-05-01 00:00:00.0',45332.0E0)
INSERT INTO EMPLOYEE VALUES(14,'Hall','Stewart','227','1990-06-04 00:00:00.0',34482.625E0)
INSERT INTO EMPLOYEE VALUES(15,'Young','Katherine','231','1990-06-14 00:00:00.0',24400.0E0)
INSERT INTO EMPLOYEE VALUES(20,'Papadopoulos','Chris','887','1990-01-01 00:00:00.0',25050.0E0)
INSERT INTO EMPLOYEE VALUES(24,'Fisher','Pete','888','1990-09-12 00:00:00.0',23040.0E0)
INSERT INTO EMPLOYEE VALUES(28,'Bennet','Ann','5','1991-02-01 00:00:00.0',34482.8E0)
INSERT INTO EMPLOYEE VALUES(29,'De Souza','Roger','288','1991-02-18 00:00:00.0',25500.0E0)
INSERT INTO EMPLOYEE VALUES(34,'Baldwin','Janet','2','1991-03-21 00:00:00.0',23300.0E0)
INSERT INTO EMPLOYEE VALUES(36,'Reeves','Roger','6','1991-04-25 00:00:00.0',33620.0E0)
INSERT INTO EMPLOYEE VALUES(37,'Stansbury','Willie','7','1991-04-25 00:00:00.0',39224.0E0)
INSERT INTO EMPLOYEE VALUES(44,'Phong','Leslie','216','1991-06-03 00:00:00.0',40350.0E0)
INSERT INTO EMPLOYEE VALUES(45,'Ramanathan','Ashok','209','1991-08-01 00:00:00.0',33292.94E0)
INSERT INTO EMPLOYEE VALUES(46,'Steadman','Walter','210','1991-08-09 00:00:00.0',19599.0E0)
INSERT INTO EMPLOYEE VALUES(52,'Nordstrom','Carol','420','1991-10-02 00:00:00.0',4500.0E0)
INSERT INTO EMPLOYEE VALUES(61,'Leung','Luke','3','1992-02-18 00:00:00.0',34500.0E0)
INSERT INTO EMPLOYEE VALUES(65,'O''Brien','Sue Anne','877','1992-03-23 00:00:00.0',31275.0E0)
INSERT INTO EMPLOYEE VALUES(71,'Burbank','Jennifer M.','289','1992-04-15 00:00:00.0',45332.0E0)
INSERT INTO EMPLOYEE VALUES(72,'Sutherland','Claudia',NULL,'1992-04-20 00:00:00.0',35699.0E0)
INSERT INTO EMPLOYEE VALUES(83,'Bishop','Dana','290','1992-06-01 00:00:00.0',45000.0E0)
INSERT INTO EMPLOYEE VALUES(85,'MacDonald','Mary S.','477','1992-06-01 00:00:00.0',35699.0E0)
INSERT INTO EMPLOYEE VALUES(94,'Williams','Randy','892','1992-08-08 00:00:00.0',28900.0E0)
INSERT INTO EMPLOYEE VALUES(105,'Bender','Oliver H.','255','1992-10-08 00:00:00.0',36799.0E0)
INSERT INTO EMPLOYEE VALUES(107,'Cook','Kevin','894','1993-02-01 00:00:00.0',35500.0E0)
INSERT INTO EMPLOYEE VALUES(109,'Brown','Kelly','202','1993-02-04 00:00:00.0',27000.0E0)
INSERT INTO EMPLOYEE VALUES(110,'Ichida','Yuki','22','1993-02-04 00:00:00.0',25689.0E0)
INSERT INTO EMPLOYEE VALUES(113,'Page','Mary','845','1993-04-12 00:00:00.0',48000.0E0)
INSERT INTO EMPLOYEE VALUES(114,'Parker','Bill','247','1993-06-01 00:00:00.0',35000.0E0)
INSERT INTO EMPLOYEE VALUES(118,'Yamamoto','Takashi','23','1993-07-01 00:00:00.0',32500.0E0)
INSERT INTO EMPLOYEE VALUES(121,'Ferrari','Roberto','1','1993-07-12 00:00:00.0',40500.0E0)
INSERT INTO EMPLOYEE VALUES(127,'Yanowski','Michael','492','1993-08-09 00:00:00.0',44000.0E0)
INSERT INTO EMPLOYEE VALUES(134,'Glon','Jacques',NULL,'1993-08-23 00:00:00.0',24855.0E0)
INSERT INTO EMPLOYEE VALUES(136,'Johnson','Scott','265','1993-09-13 00:00:00.0',30588.99E0)
INSERT INTO EMPLOYEE VALUES(138,'Green','T.J.','218','1993-11-01 00:00:00.0',36000.0E0)
INSERT INTO EMPLOYEE VALUES(141,'Osborne','Pierre',NULL,'1994-01-03 00:00:00.0',35600.0E0)
INSERT INTO EMPLOYEE VALUES(144,'Montgomery','John','820','1994-03-30 00:00:00.0',35699.0E0)
INSERT INTO EMPLOYEE VALUES(145,'Guckenheimer','Mark','221','1994-05-02 00:00:00.0',32000.0E0)
INSERT INTO INPUT VALUES(1,'\u6c34\u679c','\u4e00\u7ea7','\u7ea2\u5bcc\u58eb','\u7bb1',500,3.1000,1550.0000)
INSERT INTO INPUT VALUES(2,'\u6c34\u679c','\u4e8c\u7ea7','\u9999\u8549','\u65a4',1000,2.0000,2000.0000)
INSERT INTO INPUT VALUES(3,'\u98df\u54c1','\u4e00\u7ea7','\u65b9\u4fbf\u9762','\u7bb1',600,1.8000,1080.0000)
INSERT INTO INPUT VALUES(4,'\u98df\u54c1','\u4e00\u7ea7','\u5de7\u514b\u529b','\u76d2',1050,56.8000,59640.0000)
INSERT INTO INPUT VALUES(5,'\u5e72\u98df','\u4e09\u7ea7','\u73cd\u73e0\u6885','\u5305',700,5.2300,3661.0000)
INSERT INTO INPUT VALUES(6,'\u725b\u5976','\u4e00\u7ea7','\u5496\u5561\u725b\u5976','\u76d2',100,2.0000,200.0000)
INSERT INTO INPUT VALUES(7,'\u996e\u6599','\u4e00\u7ea7','\u897f\u74dc\u6c41','\u76d2',300,5.0000,1500.0000)
INSERT INTO INPUT VALUES(8,'\u996e\u6599','\u4e00\u7ea7','\u67f3\u6a59\u6c41','\u76d2',50,12.0000,600.0000)
INSERT INTO INPUT VALUES(9,'\u9762\u5305','\u4e09\u7ea7','\u8089\u677e\u9762\u5305','\u4e2a',1000,2.0000,2000.0000)
INSERT INTO INPUT VALUES(10,'\u9762\u5305','\u4e00\u7ea7','\u706b\u817f\u9762\u5305','\u4e2a',400,3.0000,1200.0000)
INSERT INTO INPUT VALUES(11,'\u8336','\u4e00\u7ea7','\u78a7\u87ba\u6625','\u5305',100,20.0000,2000.0000)
INSERT INTO INPUT VALUES(12,'\u8336','\u4e00\u7ea7','\u9f99\u4e95\u8336','\u5305',100,50.0000,5000.0000)
INSERT INTO INPUT VALUES(13,'\u8336','\u4e00\u7ea7','\u6d0b\u53c2\u8336','\u5305',50,10.0000,500.0000)
INSERT INTO INPUT VALUES(14,'\u725b\u5976','\u4e09\u7ea7','\u7eaf\u725b\u5976','\u5305',800,5.0000,4000.0000)
INSERT INTO INPUT VALUES(15,'\u725b\u5976','\u4e00\u7ea7','\u8349\u8393\u5976','\u5305',100,6.0000,600.0000)
INSERT INTO INPUT VALUES(16,'\u6c34\u679c','\u4e00\u7ea7','\u6843\u5b50','\u7bb1',500,3.1000,1550.0000)
INSERT INTO INPUT VALUES(17,'\u6c34\u679c','\u4e8c\u7ea7','\u8349\u8393','\u65a4',1000,2.0000,2000.0000)
INSERT INTO INPUT VALUES(18,'\u98df\u54c1','\u4e00\u7ea7','\u4e0a\u597d\u4f73','\u7bb1',600,1.8000,1080.0000)
INSERT INTO INPUT VALUES(19,'\u98df\u54c1','\u4e00\u7ea7','\u53e3\u9999\u7cd6','\u76d2',1050,56.8000,59640.0000)
INSERT INTO INPUT VALUES(20,'\u5e72\u98df','\u4e09\u7ea7','\u8bdd\u6885','\u5305',700,5.2300,3661.0000)
INSERT INTO INPUT VALUES(21,'\u725b\u5976','\u4e00\u7ea7','\u679c\u6c41\u725b\u5976','\u76d2',100,2.0000,200.0000)
INSERT INTO INPUT VALUES(22,'\u996e\u6599','\u4e00\u7ea7','\u8292\u679c\u6c41','\u76d2',300,5.0000,1500.0000)
INSERT INTO INPUT VALUES(23,'\u996e\u6599','\u4e00\u7ea7','\u67f3\u897f\u6c41','\u76d2',50,12.0000,600.0000)
INSERT INTO INPUT VALUES(24,'\u9762\u5305','\u4e8c\u7ea7','\u542f\u65af\u86cb\u7cd5','\u4e2a',1000,2.0000,2000.0000)
INSERT INTO INPUT VALUES(25,'\u9762\u5305','\u4e00\u7ea7','\u864e\u76ae\u86cb\u7cd5','\u4e2a',400,3.0000,1200.0000)
INSERT INTO INPUT VALUES(26,'\u8336','\u4e00\u7ea7','\u7acb\u987f','\u5305',100,20.0000,2000.0000)
INSERT INTO INPUT VALUES(27,'\u8336','\u4e8c\u7ea7','\u7ea2\u8336','\u5305',100,50.0000,5000.0000)
INSERT INTO INPUT VALUES(28,'\u8336','\u4e00\u7ea7','\u73ab\u7470\u8336','\u5305',50,10.0000,500.0000)
INSERT INTO INPUT VALUES(29,'\u725b\u5976','\u4e8c\u7ea7','\u6731\u53e4\u529b\u725b\u5976','\u5305',800,5.0000,4000.0000)
INSERT INTO INPUT VALUES(30,'\u725b\u5976','\u4e00\u7ea7','\u9999\u8349\u9178\u5976','\u5305',100,6.0000,600.0000)
INSERT INTO CHEQUE VALUES(1,'\u6df1\u5733\u65b0\u4e1a\u8f6f\u4ef6\u6709\u9650\u516c\u53f8','\u57f9\u8bad\u8d39','2004-01-09 00:00:00.0',58000.0E0,'423051702880563','\u676d\u5dde\u57fa\u56e0\u751f\u7269\u5de5\u7a0b\u516c\u53f8')
INSERT INTO CHEQUE VALUES(2,'\u6d77\u5357\u751f\u5316\u7814\u7a76\u6240','\u8bd5\u5242\u8d27\u6b3e','2004-01-19 00:00:00.0',288900.0E0,'423051702880563','\u676d\u5dde\u57fa\u56e0\u751f\u7269\u5de5\u7a0b\u516c\u53f8')
INSERT INTO JY VALUES(1,'1999\u5c4a','\u77f3\u6cb9\u4e0e\u5929\u7136\u6c14\u5730\u8d28',13,43,3.31E0,100.0E0)
INSERT INTO JY VALUES(2,'2000\u5c4a','\u77f3\u6cb9\u4e0e\u5929\u7136\u6c14\u5730\u8d28',18,55,3.06E0,100.0E0)
INSERT INTO JY VALUES(3,'2001\u5c4a','\u77f3\u6cb9\u4e0e\u5929\u7136\u6c14\u5730\u8d28',27,103,3.81E0,96.3E0)
INSERT INTO JY VALUES(4,'2002\u5c4a','\u77f3\u6cb9\u4e0e\u5929\u7136\u6c14\u5730\u8d28',30,211,7.06E0,96.7E0)
INSERT INTO JY VALUES(5,'2003\u5c4a','\u77f3\u6cb9\u4e0e\u5929\u7136\u6c14\u5730\u8d28',51,327,6.41E0,86.3E0)
INSERT INTO HYCKWTS VALUES(0,'NINGBO IMP & EXP CO LTD\u000d\u000a3F NO. 48, 130 LANE KAIMING STREET\u000d\u000aNINGBO, P. R. CHINA','86-25-86744','USA','SDF','2004-6-8','TO ORDER OF OCBC BANK (MALAYSIA) BERHAD, \u000d\u000aJOHOR BAHRU, \u000d\u000aJOHOR','\u5b81\u6ce2\u8fdb\u51fa\u53e3\u6709\u9650\u516c\u53f8\u5b81\u6ce2\u5e02\u89e3\u653e\u8def\u56fd\u8d38\u5927\u53a6','0574-2365480','0574-85985643','\u674e\u7ea2','THUNDERFLASH ENTERPRISE SDN BHD AC2\u000d\u000aWISMA THUNDERFLASH, 8 JLN MUTIARA 6\u000d\u000aTAMAN PERINDUSTRIAN PLENTONG\u000d\u000a81750 JOHOR BAHRU, JOHOR, MALAYSIA','211343','NINGBO, CHINA','PASIR GUDANEREG PORT, MALAYSIA','SDFASF','12','N/M','1855 CTNS','WASHING MACDFSHINE','6150KGS','68.000CBM','68')
INSERT INTO HYCKWTS VALUES(1,'SHANGHAI IMP & EXPF&mem\u000d\u000a3F NO. 48, 130 LANE KAIMING STREET\u000d\u000aNINGBO, P. R. CHINA','86-25-46512','USA','FDSAF','2004-6-5','TO ORDER OF OCBC BANK (MALAYSIA) BERHAD, \u000d\u000aJOHOR BAHRU, \u000d\u000aJOHOR','\u4e0a\u6d77\u8fdb\u51fa\u53e3\u6709\u9650\u516c\u53f8\u5317\u4eac\u8857439\u53f7\u7075\u65b0\u5927\u53a6','020-54879563','020-88698564','\u5f20\u534e','SDFASDFDH ENTERPRISE SDN BHD AC2\u000d\u000aWISMA THUNDERFLASH, 8 JLN MUTIARA 6\u000d\u000aTAMAN PERINDUSTRIAN PLENTONG\u000d\u000a81750 JOHOR BAHRU, JOHOR, MALAYSIA','234435','SHANGHAI, CHINA','PASIR GUDDFDSFSANG PORT, MALAYSIA','DSFDFG','2','N/M','1835 CTNS','WASHING MACSDFHINE','3450KGS','34.000CBM','34')
INSERT INTO HYCKWTS VALUES(2,'NINJIN IMP & EXP CO LTD\u000d\u000a3F NO. 48, 130 LANE KAIMING STREET\u000d\u000aNINGBO, P. R. CHINA','86-25-89464','USA','WERWR','2004-6-7','TO ORDER OF OCBC BANK (MALAYSIA) BERHAD, \u000d\u000aJOHOR BAHRU, \u000d\u000aJOHOR','\u5357\u4eac\u8fdb\u51fa\u53e3\u6709\u9650\u516c\u53f8\u5357\u4eac\u5e02\u897f\u4eac\u8857334\u53f7\u5929\u5357\u5927\u53a6','025-562024653','025-86598654','\u5170\u98de','SDFSDFSH ENTERPRISE SDN BHD AC2\u000d\u000aWISMA THUNDERFLASH, 8 JLN MUTIARA 6\u000d\u000aTAMAN PERINDUSTRIAN PLENTONG\u000d\u000a81750 JOHOR BAHRU, JOHOR, MALAYSIA','344545','NIANJIN, CHINA','PASIR GUDDFSFDANG PORT, MALAYSIA','DFGDFGDFG','10','N/M','1885 CTNS','WASHING MACHSDFINE','65848KGS','65468.000CBM','65468')
INSERT INTO ITEMS VALUES(1003.0E0,1.0E0,1313.0E0,5,0.0E0)
INSERT INTO ITEMS VALUES(1004.0E0,1.0E0,1313.0E0,10,50.0E0)
INSERT INTO ITEMS VALUES(1004.0E0,2.0E0,12310.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1004.0E0,3.0E0,3316.0E0,8,0.0E0)
INSERT INTO ITEMS VALUES(1004.0E0,4.0E0,5324.0E0,5,0.0E0)
INSERT INTO ITEMS VALUES(1005.0E0,1.0E0,1320.0E0,1,0.0E0)
INSERT INTO ITEMS VALUES(1005.0E0,2.0E0,2367.0E0,2,0.0E0)
INSERT INTO ITEMS VALUES(1005.0E0,3.0E0,11564.0E0,5,0.0E0)
INSERT INTO ITEMS VALUES(1005.0E0,4.0E0,7612.0E0,9,0.0E0)
INSERT INTO ITEMS VALUES(1005.0E0,5.0E0,1946.0E0,4,0.0E0)
INSERT INTO ITEMS VALUES(1006.0E0,1.0E0,900.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1006.0E0,2.0E0,1313.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1006.0E0,3.0E0,1390.0E0,2,0.0E0)
INSERT INTO ITEMS VALUES(1006.0E0,4.0E0,11564.0E0,2,0.0E0)
INSERT INTO ITEMS VALUES(1006.0E0,5.0E0,12301.0E0,1,0.0E0)
INSERT INTO ITEMS VALUES(1007.0E0,1.0E0,1316.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1007.0E0,2.0E0,1946.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1008.0E0,1.0E0,1313.0E0,1,0.0E0)
INSERT INTO ITEMS VALUES(1008.0E0,2.0E0,11635.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1009.0E0,1.0E0,1320.0E0,7,0.0E0)
INSERT INTO ITEMS VALUES(1009.0E0,2.0E0,1328.0E0,4,0.0E0)
INSERT INTO ITEMS VALUES(1009.0E0,3.0E0,1364.0E0,6,0.0E0)
INSERT INTO ITEMS VALUES(1009.0E0,4.0E0,12306.0E0,3,0.0E0)
INSERT INTO ITEMS VALUES(1010.0E0,1.0E0,11238.0E0,2,0.0E0)
INSERT INTO ITEMS VALUES(1011.0E0,1.0E0,5386.0E0,20,0.0E0)
INSERT INTO ITEMS VALUES(1011.0E0,2.0E0,11652.0E0,3,0.0E0)
INSERT INTO ITEMS VALUES(1012.0E0,1.0E0,2350.0E0,5,0.0E0)
INSERT INTO ITEMS VALUES(1012.0E0,2.0E0,2367.0E0,3,0.0E0)
INSERT INTO ITEMS VALUES(1012.0E0,3.0E0,12306.0E0,14,0.0E0)
INSERT INTO ITEMS VALUES(1013.0E0,1.0E0,2341.0E0,6,0.0E0)
INSERT INTO ITEMS VALUES(1013.0E0,2.0E0,5378.0E0,25,0.0E0)
INSERT INTO ITEMS VALUES(1014.0E0,1.0E0,7612.0E0,3,0.0E0)
INSERT INTO ITEMS VALUES(1015.0E0,1.0E0,912.0E0,2,0.0E0)
INSERT INTO ITEMS VALUES(1015.0E0,2.0E0,1330.0E0,45,0.0E0)
INSERT INTO ITEMS VALUES(1015.0E0,3.0E0,2367.0E0,45,0.0E0)
INSERT INTO ITEMS VALUES(1015.0E0,4.0E0,7612.0E0,65,0.0E0)
INSERT INTO ITEMS VALUES(1016.0E0,1.0E0,1313.0E0,10,0.0E0)
INSERT INTO ITEMS VALUES(1016.0E0,2.0E0,2341.0E0,1,0.0E0)
INSERT INTO ITEMS VALUES(1017.0E0,1.0E0,1986.0E0,45,0.0E0)
INSERT INTO ITEMS VALUES(1017.0E0,2.0E0,2314.0E0,3,0.0E0)
INSERT INTO ITEMS VALUES(1017.0E0,3.0E0,2341.0E0,4,0.0E0)
INSERT INTO ITEMS VALUES(1017.0E0,4.0E0,2350.0E0,5,0.0E0)
INSERT INTO ITEMS VALUES(1018.0E0,1.0E0,1946.0E0,16,0.0E0)
INSERT INTO ITEMS VALUES(1018.0E0,2.0E0,2367.0E0,6,0.0E0)
INSERT INTO ITEMS VALUES(1019.0E0,1.0E0,2367.0E0,4,0.0E0)