数据库建表语句 (6)

/NAVICATMYSQLDATATRANSFERSOURCESERVERLOCALHOSTSOURCESERVERVERSION50521SOURCEHOSTLOCALHOST3306SOURCEDATABASEDB_JIUDIANSCTARGETSERVERTYPEMYSQLTARGETSERVERVERSION50521FILEENCODING65001DATE20140327214311/SETFOREIGN_KEY_CHECKS0TABLESTRUCTUREFORT_ADMINDROPTABLEIFEXISTST_ADMINCREATETABLET_ADMINUSERIDINT11NOTNULL,USERNAMEVARCHAR50DEFAULTNULL,USERPWVARCHAR50DEFAULTNULL,PRIMARYKEYUSERIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_ADMININSERTINTOT_ADMINVALUES1,ADMIN,ADMINTABLESTRUCTUREFORT_CATELOGDROPTABLEIFEXISTST_CATELOGCREATETABLET_CATELOGIDINT11NOTNULL,NAMEVARCHAR50DEFAULTNULL,JIESHAOVARCHAR500DEFAULTNULL,DELVARCHAR50DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_CATELOGINSERTINTOT_CATELOGVALUES1,红酒,红酒,NOINSERTINTOT_CATELOGVALUES2,白酒,白酒,NOINSERTINTOT_CATELOGVALUES3,黄酒,黄酒,NOINSERTINTOT_CATELOGVALUES4,香烟,香烟,NOINSERTINTOT_CATELOGVALUES5,牛肉,牛肉,NOINSERTINTOT_CATELOGVALUES6,FF,FF,YESTABLESTRUCTUREFORT_CHUKUDROPTABLEIFEXISTST_CHUKUCREATETABLET_CHUKUIDINT11NOTNULL,DANJUHAOVARCHAR50DEFAULTNULL,SHIJIANVARCHAR50DEFAULTNULL,ZONGJIAGEINT11DEFAULTNULL,JINGSHOURENVARCHAR50DEFAULTNULL,BEIZHUVARCHAR50DEFAULTNULL,DELVARCHAR50DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_CHUKUINSERTINTOT_CHUKUVALUES1,20140003,20140326,800,飞哥,出库5瓶二锅头,NOTABLESTRUCTUREFORT_CHUKUMINGXIDROPTABLEIFEXISTST_CHUKUMINGXICREATETABLET_CHUKUMINGXIIDINT11NOTNULL,CHUKU_IDINT11DEFAULTNULL,GOODS_IDINT11DEFAULTNULL,SHULIANGINT11DEFAULTNULL,BEIZHUVARCHAR500DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_CHUKUMINGXIINSERTINTOT_CHUKUMINGXIVALUES1,1,2,5,5瓶二锅头TABLESTRUCTUREFORT_GONGYINGSHANGDROPTABLEIFEXISTST_GONGYINGSHANGCREATETABLET_GONGYINGSHANGIDINT11NOTNULL,MINGCHENGVARCHAR50DEFAULTNULL,DIZHIVARCHAR50DEFAULTNULL,LIANXIRENVARCHAR50DEFAULTNULL,DIANHUAVARCHAR50DEFAULTNULL,YOUBIANVARCHAR50DEFAULTNULL,CHUANZHENVARCHAR50DEFAULTNULL,YOUXIANGVARCHAR50DEFAULTNULL,KAHUHANGVARCHAR50DEFAULTNULL,ZHANGHAOVARCHAR50DEFAULTNULL,TYPEVARCHAR50DEFAULTNULL,DELVARCHAR50DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_GONGYINGSHANGTABLESTRUCTUREFORT_GOODSDROPTABLEIFEXISTST_GOODSCREATETABLET_GOODSIDINT11NOTNULL,CATELOG_IDINT11DEFAULTNULL,NAMEVARCHAR50DEFAULTNULL,CHANDIVARCHAR50DEFAULTNULL,DANWEIVARCHAR50DEFAULTNULL,GUIGEVARCHAR50DEFAULTNULL,BEIZHUVARCHAR50DEFAULTNULL,DELVARCHAR50DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_GOODSINSERTINTOT_GOODSVALUES1,1,干红葡萄酒,南京,干红公司,650ML,干红葡萄酒,NOINSERTINTOT_GOODSVALUES2,2,二锅头,北京,酒厂,500ML,北京二锅头,NOINSERTINTOT_GOODSVALUES3,2,茅台,贵州,贵州茅台,500ML,茅台酒，国酒,NOTABLESTRUCTUREFORT_KEHUDROPTABLEIFEXISTST_KEHUCREATETABLET_KEHUIDINT11NOTNULL,MINGCHENGVARCHAR50DEFAULTNULL,DIZHIVARCHAR50DEFAULTNULL,LIANXIRENVARCHAR50DEFAULTNULL,DIANHUAVARCHAR50DEFAULTNULL,YOUBIANVARCHAR50DEFAULTNULL,CHUANZHENVARCHAR50DEFAULTNULL,YOUXIANGVARCHAR50DEFAULTNULL,KAHUHANGVARCHAR50DEFAULTNULL,ZHANGHAOVARCHAR50DEFAULTNULL,TYPEVARCHAR50DEFAULTNULL,DELVARCHAR50DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_KEHUTABLESTRUCTUREFORT_KUCUNDROPTABLEIFEXISTST_KUCUNCREATETABLET_KUCUNIDINT11NOTNULL,GOODS_IDINT11DEFAULTNULL,SHULIANGINT11DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_KUCUNINSERTINTOT_KUCUNVALUES1,2,15INSERTINTOT_KUCUNVALUES2,1,10INSERTINTOT_KUCUNVALUES3,3,10TABLESTRUCTUREFORT_RUKUDROPTABLEIFEXISTST_RUKUCREATETABLET_RUKUIDINT11NOTNULL,DANJUHAOVARCHAR50DEFAULTNULL,SHIJIANVARCHAR50DEFAULTNULL,ZONGJIAGEINT11DEFAULTNULL,JINGSHOURENVARCHAR50DEFAULTNULL,BEIZHUVARCHAR50DEFAULTNULL,DELVARCHAR50DEFAULTNULL,TYPEINT11DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_RUKUINSERTINTOT_RUKUVALUES1,20140001,20140326,1000,高哥,这个是采购白酒的,NO,3INSERTINTOT_RUKUVALUES2,20140002,20140326,1000,高哥,20瓶红酒,NO,3INSERTINTOT_RUKUVALUES3,20140006,20140327,8000,高哥,采购茅台酒,NO,3INSERTINTOT_RUKUVALUES4,20140007,20140327,1800,高哥,高哥软件服务,NO,2TABLESTRUCTUREFORT_RUKUMINGXIDROPTABLEIFEXISTST_RUKUMINGXICREATETABLET_RUKUMINGXIIDINT11NOTNULL,RUKU_IDINT11DEFAULTNULL,GOODS_IDINT11DEFAULTNULL,SHULIANGINT11DEFAULTNULL,BEIZHUVARCHAR500DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_RUKUMINGXIINSERTINTOT_RUKUMINGXIVALUES1,1,2,10,10瓶二锅头INSERTINTOT_RUKUMINGXIVALUES2,2,1,10,20瓶红酒INSERTINTOT_RUKUMINGXIVALUES3,3,3,10,10瓶茅台INSERTINTOT_RUKUMINGXIVALUES4,4,2,10,10瓶二锅头TABLESTRUCTUREFORT_YUANGONGDROPTABLEIFEXISTST_YUANGONGCREATETABLET_YUANGONGIDINT11NOTNULL,NAMEVARCHAR50DEFAULTNULL,SEXVARCHAR50DEFAULTNULL,AGEVARCHAR50DEFAULTNULL,ADDRESSVARCHAR50DEFAULTNULL,TELVARCHAR50DEFAULTNULL,QUANXIANVARCHAR50DEFAULTNULL,LOGINNAMEVARCHAR50DEFAULTNULL,LOGINPWVARCHAR50DEFAULTNULL,DELVARCHAR50DEFAULTNULL,PRIMARYKEYIDENGINEINNODBDEFAULTCHARSETUTF8RECORDSOFT_Y