安裝mysql 假丧；
mysql -u root-p登錄崔兴；
create database db_database28;
use db_database28;
create? table tb_gysinfo (id VARCHAR(32) PRIMARY KEY comment "供應(yīng)商編號(hào)",name varchar(50) comment"供應(yīng)商名稱(chēng)",jc varchar(20) comment"供應(yīng)商簡(jiǎn)稱(chēng)",address varchar(100) comment"供應(yīng)商地址",bianma varchar(10) comment"郵政編碼",tel varchar(15) comment"電話", fax varchar(15) comment"傳真",lian varchar(8) comment"聯(lián)系人",itel varchar(15) comment"聯(lián)系電話" ,yh varchar(50) comment"開(kāi)戶銀行",mail varchar(30) comment"電子郵箱");
create table tb_spinfo (id varchar(32)? primary key comment "商品編號(hào)",spname varchar(50) comment "商品名稱(chēng)",jc varchar(30) comment "商品簡(jiǎn)稱(chēng)" ,cd varchar(50) comment "產(chǎn)地",dw varchar(10) comment "商品計(jì)量單位",gg varchar(10)? comment "商品規(guī)格",bz varchar(20) comment"包裝",ph varchar(32) comment"批號(hào)",pzwh varchar(50) comment"批準(zhǔn)文號(hào)",memo varchar(100) comment"備注",gysname varchar(50) comment"供應(yīng)商名稱(chēng)");
create table tb_ruku_main (rkID varchar(32)? primary key comment "入庫(kù)編號(hào)",pzs FLOAT(8) comment "品種數(shù)量",je float(8) comment "總計(jì)金額" ,ysjl varchar(50) comment "驗(yàn)收結(jié)論",gysname varchar(100) comment "供應(yīng)商名稱(chēng)",rkdate datetime(6)? comment "入庫(kù)時(shí)間",czy varchar(30) comment"操作員",jsr varchar(32) comment"經(jīng)手人",jsfs varchar(10) comment"計(jì)算方式");
create table tb_ruku_detail (id varchar(50) primary key comment"流水號(hào)",rkID varchar(30) comment"入庫(kù)編號(hào)",spid varchar(50) comment"商品編號(hào)", dj float(8) comment"單價(jià)",sl float(8) comment"數(shù)量");
create table tb_sell_main (sellID varchar(30) primary key comment"銷(xiāo)售編號(hào)",pzs FLOAT8 comment"銷(xiāo)售品種數(shù)",je float8 comment"總計(jì)金額", ysjl varchar(50) comment"驗(yàn)收結(jié)論",khname varchar(100) comment"客戶名稱(chēng)",xsdate datetime(6) comment"銷(xiāo)售日期",czy varchar(30) comment"操作員",jsr varchar(30) comment"經(jīng)手人",jsfs varchar(10) comment"結(jié)算方式");
create table tb_sell_detail (id varchar(50)? primary key comment"流水號(hào)",sellID varchar(30)? comment"銷(xiāo)售編號(hào)",spid varchar(50) comment"商品編號(hào)",dj float(8) comment"單價(jià)",sl float(8) comment"銷(xiāo)售數(shù)量");
