【正文】 , /*所屬區(qū)域*/ telephone char(11) not null, /*電話號碼*/ regDate datetime not null, /*注冊日期*/ memCode varchar(12) not null, /*密碼*/ driTime int not null, /*身份證號*/ carNum int not null, /*拼車次數(shù)*/ constraint MemberPK primary key (memNo))gogrant all on Member to user01go/*人事表（Member）數(shù)據(jù)：*/insert Member values(39。M0000001139。,39。喻自強39。,39。M39。,39。1965041539。,39。南京市39。, 39。1381760500839。, 39。1990020639。,39。12345639。,2,0)insert Member values(39。M0000001239。,39。張小梅39。,39。F39。,39。1973110139。,39。上海市39。, 39。1360740501639。, 39。1991032839。,39。abcdef39。,3,1)insert Member values(39。M0000001339。,39。張小娟39。,39。F39。,39。1973030639。,39。上海市39。, 39。1370730502539。, 39。1992032839。,39。abc12339。,5,3)insert Member values(39。M0000001439。,39。張露39。, 39。F39。,39。1967010539。,39。南昌市39。, 39。1590720513439。, 39。1990032839。,39。lct12339。,6,0)insert Member values(39。M0000001539。,39。張小東39。,39。M39。,39。1973090339。,39。南昌市39。, 39。1560710524339。, 39。1992032839。,39。56789039。,5,7)insert Member values(39。M0000001639。,39。陳輝39。, 39。M39。,39。1965110139。,39。南昌市39。, 39。1360770535239。, 39。1990032839。,39。qwerty39。,8,4)insert Member values(39。M0000001739。,39。韓梅39。, 39。F39。,39。1973121139。,39。上海市39。, 39。1380780546139。, 39。1990112839。,39。zxcvbn39。,3,1)insert Member values(39。M0000001839。,39。劉風39。, 39。F39。,39。1973052139。,39。福州市39。, 39。1590780557839。, 39。1991022839。,39。asdfgh39。,1,0)insert Member values(39。M0000001939。,39。林翠濤39。,39。M39。,39。1988050239。,39。福州市39。, 39。1508382252339。, 39。1991022839。,39。asuigh39。,1,0)insert Member values(39。M0000002039。,39。羅樂39。, 39。M39。,39。1989052139。,39。南昌市39。, 39。1357696453139。, 39。1991022839。,39。aerfgh39。,8,0)insert Member values(39。M0000002139。,39。萬楊39。, 39。M39。,39。1989051139。,39。南昌市39。, 39。1508382403439。, 39。1991022839。,39。awefgh39。,1,0)insert Member values(39。M0000002239。,39。李宗耀39。, 39。M39。,39。1990021139。,39。宜昌市39。, 39。1359716257839。, 39。1991022839。,39。asdsdh39。,2,0)insert Member values(39。M0000002339。,39。劉陽39。, 39。M39。,39。1988052139。,39。贛州市39。, 39。1350700049139。, 39。1991022839。,39。asdfgh39。,5,0)insert Member values(39。M0000002439。,39。劉翔39。, 39。M39。,39。1973072139。,39。上海市39。, 39。1361700246139。, 39。1991022839。,39。ascfgh39。,1,0)insert Member values(39。M0000002539。,39。趙婷39。, 39。F39。,39。1989052139。,39。大連市39。, 39。1508382275239。, 39。1991022839。,39。asdfgh39。,3,0)insert Member values(39。M0000002639。,39。陳曉燕39。, 39。F39。,39。1988071339。,39。福州市39。, 39。1527098851139。, 39。1991022839。,39。asdfgh39。,6,0)insert Member values(39。M0000002739。,39。陳瀟雅39。, 39。F39。,39。1989082139。,39。贛州市39。, 39。1527098608539。, 39。1991022839。,39。asdfgh39。,1,0)insert Member values(39。M0000002839。,39。楊冬梅39。, 39。F39。,39。1989052939。,39。嘉興市39。, 39。1508382564639。, 39。1991022839。,39。asdfgh39。,2,0)insert Member values(39。M0000002939。,39。陶陽39。, 39。F39。,39。1968051839。,39。哈爾濱市39。, 39。1361496251039。, 39。1991022839。,39。asdfgh39。,1,0)insert Member values(39。M0000003039。,39。熊小云39。, 39。F39。,39。1990052339。,39。南昌市39。, 39。1587918553139。, 39。1991022839。,39。asdfgh39。,9,0)go/*商品信息表*/print 39。create Car39。gocreate table Car( CarNo char(9) not null primary key,/*商品編號*/ check(CarNo like 39。[C][09][09][09][09][09][09][09][09]39。), CarNoo char(8) not null, /*商品編號*/ carType varchar(10) not null, /*商品類型*/ pasNumber int not null, /*商品數(shù)量*/ carTime int not null, /*商品名稱*/ safeCase varchar(20) not null, /*賣家編號*/ carRemark varchar(80) null, /*發(fā)布時間*/ fee int null, /*出租金額*/ issDate datetime not null, /*發(fā)布日期*/ memNo char(9) not null, /*賣家編號*/)gogrant all on Car to user01go/*客戶表（Car）數(shù)據(jù)：*/ insert Car values(39。C0000000139。,39。魯KK555539。,39。大巴39。, 39。1039。,39。239。,39。全險39。,39。南昌到北京39。,4000, 39。2008010939。,39。M0000001139。)insert Car values(39。C0000000239。,39。陜AT123439。,39。小轎車39。, 39。339。, 39。239。,39。全險39。,39。南昌到上海39。,2100, 39。2008010939。,39。M0000001239。)insert Car values(39。C0000000339。,39。贛A1234539。,39。出租車39。, 39。339。, 39。239。,39。全險39。, null , null, 39。2008010939。,39。M0000001339。)insert Car values(39。C0000000439。,39。贛A0000139。,39。商務車39。, 39。539。, 39。239。,39。全險39。, null , null, 39。2008010939。,39。M0000001439。)insert Car values(39。C0000000539。,39。贛A0000239。,39。小面的39。, 39。739。, 39。239。,39。全險39。, null , null, 39。2008010939。,39。M0000001539。)insert Car values(39。C0000000639。,39。贛A0000339。,39。小轎車39。, 39。439。, 39。239。,39。全險39。, null , null, 39。2008010939。,39。M0000001639。)insert Car values(39。C0000000739。,39。贛B0000139。,39。奔馳39。, 39。339。, 39。239。,39。全險39。,39。南昌到福州39。,1500, 39。2008010939。,39。M0000001739。)insert Car values(39。C0000000839。,39。贛B0000239。,39。大巴39。, 39。1039。,39。239。,39。全險39。, null , null, 39。2008010939。,39。M0000001839。)insert Car values(39。C0000000939。,39。贛C0000139。,39。寶馬39。, 39。339。, 39。239。,39。全險39。, null , null, 39。2008010939。,39。M0000001939。)insert Car values(39。C0000001039。,39。贛C0000239。,39。大巴39。 ,39。1039。,39。239。,39。全險39。,39。南昌到云南39。,6000, 39。2008010939。,39。M0000002039。)insert Car values(39。C0000001139。,39。贛C0236439。,39。大巴39。 ,39。1039。,39。239。,39。全險39。,39。南昌到云南39。,6000, 39。2008010939。,39。M0000002039。)insert Car values(39。C0000001239。,39。贛CK456839。,39。大巴39。 ,39。1039。,39。239。,39。全險39。,39。南昌到云南39。,6000, 39。2008010939。,39。M0000002139。)insert Car values(39。C0000001339。,39。贛C8895339。,39。大巴39。 ,39。1039。,39。239。,39。全險39。,39。南昌到云南39。,6000, 39。2008010939。,39。M0000002239。)insert Car values(39。C0000001439。,39。贛C9567839。,39。大巴39。 ,39。1039。,39。239。,39。全險39。,39。南昌到云南39。,6000, 39。2008010939。,39。M0000002339。)insert Car values(39。C0000001539。,39。贛C2356739。,39。大巴39。 ,39。1039。,39。239。,39。全險39。,39。南昌到云南39。,6000, 39。2008010