zcfz_createtable.sql

本程序功能是将银行系统的月计表转换为所需要的资产负债表

#zcfzgzrq
CREATE TABLE if not exists zcfzgzrq (
  yhbh char(2) NOT NULL default '',
  yhmc char(20) NOT NULL default '',
  yhkl char(10) NOT NULL default '',
  sydw char(40) not null default '',
  gzrq date NOT NULL default '0000-00-00'
)TYPE=MyISAM;

#zcfzgbb
CREATE TABLE if not exists zcfzgbb (
  hh int(4),
  xmdh char(5) ,
  xmmc char(30),
  kmdh char(5),
  kmmc char(30) ,
  yefx char(10),
  kmxz char(10) ,
  bjye double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#zcfzxmb 
CREATE TABLE if not exists zcfzxmb (
  hh int(4),
  xmdh char(5),
  xmmc char(30),
  xmfl char(30),
  sjye double(18,2) NOT NULL default '0',
  bjzje double(18,2) NOT NULL default '0',
  bjye double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#zcfzxmb_BAK 
CREATE TABLE if not exists zcfzxmb_BAK (
  ny char(6),
  hh int(4),
  xmdh char(5),
  xmmc char(30),
  xmfl char(30),
  sjye double(18,2) NOT NULL default '0',
  bjzje double(18,2) NOT NULL default '0',
  bjye double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#zcfzHSyjb 
CREATE TABLE if not exists zcfzHSyjb (
  zw int(1) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#zcfzHSyjb_bak 
CREATE TABLE if not exists zcfzHSyjb_bak (
  ny char(6),
  zw int(1) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#zcfzGByjb 
CREATE TABLE if not exists zcfzGByjb (
  tmp  char(4) ,
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#zcfzyjb 
CREATE TABLE if not exists zcfzyjb (
  kmdh char(5) ,
  bqye double(18,2) NOT NULL default '0',
  jd char(4)
) TYPE=MyISAM;

#gkk_yjb
CREATE TABLE if not exists gkk_yjb(
  zw int(3) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#gkk_yjb_bak
CREATE TABLE if not exists gkk_yjb_bak(
  ny char(6),
  zw int(3) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#yjb_hj
CREATE TABLE if not exists yjb_hj(
  zw int(3) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#yjb
CREATE TABLE if not exists yjb(
  bh int(3) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#yjb_BAK
CREATE TABLE if not exists yjb_BAK(
  ny char(6),
  bh int(3) NOT NULL default '0',
  kmdh char(5) ,
  sqyeJF double(18,2) NOT NULL default '0',
  sqyeDF double(18,2) NOT NULL default '0',
  bqfseJF double(18,2) NOT NULL default '0',
  bqfseDF double(18,2) NOT NULL default '0',
  bqyeJF double(18,2) NOT NULL default '0',
  bqyeDF double(18,2) NOT NULL default '0'
) TYPE=MyISAM;

#xkmb
CREATE TABLE if not exists xkmb(
  xh   int(3) NOT NULL default '0',
  kmdh char(5) ,
  kmmc char(30) NOT NULL default ' '
) TYPE=MyISAM;