在A表里面我定义了一个 id 自动标识+1的id aaaaa bbbbb而在B表里面就也定义了一个 id 也是自动标识+1的id cccccc dddddd如果我要把A表的ID级联到B表的ID上面(更新和删除)
要使得删除或者更新A表的内容时,B表也跟着删除和更新那么我上面设置的ID值这样的思路正确吗?
如果错了,那么我应该怎么做到我想要的效果?
要使得删除或者更新A表的内容时,B表也跟着删除和更新那么我上面设置的ID值这样的思路正确吗?
如果错了,那么我应该怎么做到我想要的效果?
我有三個表:貨幣Moneys,供應商Supplier和採購表Purchase首先:貨幣資料表中的貨幣編碼:MoneyCode(主鍵)
和供應商表,採購表中的MoneyCode(外鍵)都有關聯, 另外,供應商資料表中的供應商編碼SupplierCode(主鍵)和
採購表中的SupplierCode(外鍵)也有關聯,我想要實現級聯刪除,修改貨幣資料表MoneyCode的時候
把供應商,採購表中的外鍵貨幣編碼一起修改,*/
--例如
drop table moneyscreate table Moneys
(
MoneyCode int primary key,
)
godrop table Suppliercreate table Supplier
(
SupplierCode int ,-- primary key ,
MoneyCode int FOREIGN KEY REFERENCES Moneys(MoneyCode) ON UPDATE CASCADE ,
constraint pk_s primary key(SupplierCode,MoneyCode)
)
go
drop table Purchase
create table Purchase
(
Purchasecode int primary key,
SupplierCode int ,--FOREIGN KEY REFERENCES Supplier(SupplierCode) ON UPDATE CASCADE ,
MoneyCode int ,--FOREIGN KEY REFERENCES Supplier(SupplierCode,MoneyCode) ON UPDATE CASCADE ,
constraint fk_test FOREIGN KEY (SupplierCode,MoneyCode) REFERENCES Supplier(SupplierCode,MoneyCode) ON UPDATE CASCADE
)
go
insert Moneys values(1)
insert Moneys values(2)
insert Moneys values(3)insert Supplier values(10,1)
insert Supplier values(20,2)
insert Supplier values(30,3)insert Purchase values(100,10,1)
insert Purchase values(200,20,2)
insert Purchase values(300,30,3)--测试1
update Moneys set MoneyCode = 4 where MoneyCode = 1
--测试2
update Supplier set MoneyCode = 3 where SupplierCode = 10select * from Moneys
select * from Supplier
select * from Purchase
/*
insert Purchase values(100,10,1)
insert Purchase values(200,20,2)
insert Purchase values(300,30,3)
*/
/*
alter table cb add constraint fk_cb foreign key(mx_id) references zb(zb_id) on delete cascadealter table 从表 add constraint 外键名 foreign key(从表字段) references 主表(主表字段) on delete cascade*/--例如
create table zb --主表
(
zb_id int primary key,
)gocreate table cb --从表
(
cb_id int primary key
FOREIGN KEY REFERENCES zb(zb_id) ON DELETE CASCADE , --指定级联删除
)
go--主表数据
insert zb values(1)
insert zb values(2)
insert zb values(3)
--从表数据
insert cb values(1)
insert cb values(2)
insert cb values(3)
select * from zb
select * from cb
zb_id
-----------
1
2
3(所影响的行数为 3 行)mx_id
-----------
1
2
3(所影响的行数为 3 行)
--级联删除
delete from zb where zb_id = 1
select * from zb
select * from cb
zb_id
-----------
2
3(所影响的行数为 2 行)mx_id
-----------
2
3
(所影响的行数为 2 行)alter table cb add constraint fk_cb foreign key(mx_id) references zb(zb_id) on delete cascadealter table 从表 add constraint 外键名 foreign key(从表字段) references 主表(主表字段) on delete cascade
不如我把我的表导出来A表 名字xinzj1
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xinzj1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xinzj1]
GOCREATE TABLE [dbo].[xinzj1] (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[lmxx] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[son_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sin_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[musicdown] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[Toppai] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tims_s] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
B表 名字xinzj2
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xinzj2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xinzj2]
GOCREATE TABLE [dbo].[xinzj2] (
[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[alb_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[languages] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_company] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[orders] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ordersjs] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[cover] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
如果有什么出错的地方请帮我修改一下喔
导出来给我(级联两个表的ID之后) ^__^
drop table [dbo].[xinzj1]
GO CREATE TABLE [dbo].[xinzj1] (
[id] [numeric](18, 0) NOT NULL primary key ,
[lmxx] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[son_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sin_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[musicdown] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[Toppai] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tims_s] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
--B表 名字xinzj2
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xinzj2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xinzj2]
GO CREATE TABLE [dbo].[xinzj2] (
[id] [numeric](18, 0) NOT NULL primary key
FOREIGN KEY REFERENCES xinzj1(id) ON DELETE CASCADE ,
[alb_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[languages] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_company] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[orders] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ordersjs] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[cover] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
drop table [dbo].[xinzj1]
GO CREATE TABLE [dbo].[xinzj1] (
[id] [numeric](18, 0) NOT NULL primary key ,
[lmxx] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[son_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sin_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[musicdown] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[Toppai] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tims_s] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
--B表 名字xinzj2
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xinzj2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xinzj2]
GO CREATE TABLE [dbo].[xinzj2] (
[id] [numeric](18, 0) NOT NULL primary key
FOREIGN KEY REFERENCES xinzj1(id) ON DELETE CASCADE ,
[alb_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[languages] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_company] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[orders] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ordersjs] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[cover] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
drop table [dbo].[xinzj1]
GO CREATE TABLE [dbo].[xinzj1] (
[id] [numeric](18, 0) NOT NULL primary key ,
[lmxx] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[son_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sin_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[musicdown] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[Toppai] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tims_s] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
--B表 名字xinzj2
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xinzj2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xinzj2]
GO CREATE TABLE [dbo].[xinzj2] (
[id] [numeric](18, 0) NOT NULL primary key
FOREIGN KEY REFERENCES xinzj1(id) ON DELETE CASCADE ,
[alb_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[languages] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_company] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_date] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[orders] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ordersjs] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[cover] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO insert xinzj1 select 1,'name1','son1','sin1','music1','top1','2001-01-01'
insert xinzj1 select 2,'name2','son2','sin2','music2','top2','2001-01-01'insert xinzj2 select 1,'alb_name','lang','pub_cy','pub_date',N'orders',N'ordersjs',N'cover'
select * from xinzj1select * from xinzj2
/*
id lmxx son_name sin_name musicdown Toppai tims_s
-------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ------------------------------------------------------
1 name1 son1 sin1 music1 top1 2001-01-01 00:00:00.000
2 name2 son2 sin2 music2 top2 2001-01-01 00:00:00.000(所影响的行数为 2 行)id alb_name languages pub_company pub_date orders ordersjs cover
-------------------- ---------- ---------- ----------- ---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 alb_name lang pub_cy pub_date orders ordersjs cover
*/
/*
id lmxx son_name sin_name musicdown Toppai tims_s
-------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ------------------------------------------------------
2 name2 son2 sin2 music2 top2 2001-01-01 00:00:00.000(所影响的行数为 1 行)id alb_name languages pub_company pub_date orders ordersjs cover
-------------------- ---------- ---------- ----------- ---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (所影响的行数为 0 行)
*/drop table [dbo].[xinzj2]
drop table [dbo].[xinzj1]
在自增上是无法完成级联删除的创建吧?????????
这是在开玩笑吧,
在企业管理里去掉自增属性就可建立关系了。。
在A表里面设置了一个自动标识+1
然后把B表的id 字段级联了后就可以了?删除A表的一条记录
B表后面的记录跟着删除
是这样吗?
因为我是要做在网页里面添加数据库的我们现在有两个数据库
那么我就分别做成两个不同的页面去添加这个记录分别为 sub1.asp 和 sub2.asp
对应 xinjz1 xinjz2然后加一个 IFRAME 去同时提交两个网页<Script language="VBScript">
<!--
sub fsubmit()
main1.form1.submit
main2.form1.submitEnd sub
-->
</script>
因为我每一首歌的记录都必须要有一个id来做标记的
所以在 xinjz1 这里的字段 id 是要自动递增+1我刚才试过把xinjz1的id设置成自动+1
添加xinjz1字段的记录没有问题
然后我再把xinjz2的id设置成自动+1(为了要跟xinjz1的id对上,在网页添加数据的时候可以找回目标)
但是企业管理器就提示出错了
因为级联了后就不能有两个自增标识了(但是为了让两个表同步添加………………)我真的想不出办法了
首先是sub1.asp 的<form method="post" action="<%=MM_editAction%>" name="form1">
<table height="104" align="left">
<tr valign="baseline">
<td nowrap align="right"><p align="left" >栏目选择:</p> </td>
<td><input type="text" name="lmxx" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌手名:</div></td>
<td><input name="sin_name" type="text" id="sin_name" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌名:</div></td>
<td><input name="son_name" type="text" id="son_name" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌曲上传:</div></td>
<td><input type="text" name="musicdown" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌曲添加时间:</div></td>
<td><input type="text" name="tims_s" value="<%
Dim sTime
Dim mTime
Dim rTime
sTime=FormatDateTime(now(), vbShortDate)
mTime=month(sTime)
IF mTime<10 then
mTime="0"&mTime
End if
rTime=year(sTime)&"-"&mTime&"-"&day(sTime)
Response.Write rTime
%>" size="32"> </td>
</tr>
<tr valign="baseline"> </tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>然后是 sub2.asp 的<form method="POST" action="<%=MM_editAction%>" name="form1">
<table width="525" align="left">
<tr valign="baseline">
<td width="104" align="right" nowrap><div align="left">专辑名:</div></td>
<td width="409"><input type="text" name="alb_name" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">语种:</div></td>
<td><input type="text" name="languages" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">发行公司:</div></td>
<td><input type="text" name="pub_company" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">发行日期:</div></td>
<td><input type="text" name="pub_date" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap><div align="left">专业点评:</div></td>
<td><textarea name="orders" cols="50" rows="10"></textarea> </td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap><div align="left">专辑介绍:</div></td>
<td><textarea name="ordersjs" cols="50" rows="10"></textarea> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">封面图上传:</div></td>
<td><input type="text" name="cover" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
最后是 IFRAME (add.asp) 的
<Script language="VBScript">
<!--
sub fsubmit()
main1.form1.submit
main2.form1.submitEnd sub
-->
</script>
</head><body>
<table width="693" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><IFRAME name="main1" marginWidth=0 marginHeight=0 src="sub1.asp" frameBorder=0 width="563" height="136" scrolling=no framespacing=0></IFRAME>
</td>
</tr>
<tr>
<td><IFRAME name="main2" marginWidth=0 marginHeight=0 src="sub2.asp" frameBorder=0 width="563" height="470" scrolling=no framespacing=0></IFRAME>
<form method="POST" name="form2">
<p><input type="button" value="提交" name="B1" onClick="fsubmit()"></p>
</form></td>
</tr>
</table>
发现有人可以这样定义
就分两个页面
一个是html 一个asp
yy.html yy.asp分别是
yy.html<form method="post" action="yy.asp" name="form1">
<table height="104" align="left">
<tr valign="baseline">
<td nowrap align="right"><p align="left" >栏目选择:</p> </td>
<td><input type="text" name="lmxx" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌手名:</div></td>
<td><input name="sin_name" type="text" id="sin_name" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌名:</div></td>
<td><input name="son_name" type="text" id="son_name" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌曲上传:</div></td>
<td><input type="text" name="musicdown" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">歌曲添加时间:</div></td>
<td><input type="text" name="tims_s" size="32"> </td>
</tr>
<tr valign="baseline"> </tr>
</table>
<table width="525" align="left">
<tr valign="baseline">
<td width="104" align="right" nowrap><div align="left">专辑名:</div></td>
<td width="409"><input type="text" name="alb_name" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">语种:</div></td>
<td><input type="text" name="languages" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">发行公司:</div></td>
<td><input type="text" name="pub_company" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">发行日期:</div></td>
<td><input type="text" name="pub_date" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap><div align="left">专业点评:</div></td>
<td><textarea name="orders" cols="50" rows="10"></textarea> </td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap><div align="left">专辑介绍:</div></td>
<td><textarea name="ordersjs" cols="50" rows="10"></textarea> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"><div align="left">封面图上传:</div></td>
<td><input type="text" name="cover" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
<label>
<input type="submit" name="Submit" value="提交" />
</label>
</form>
而yy.asp就是
conn.open connstr
lmxx=request.form("lmxx")
sin_name=request.form("sin_name")
son_name=request.form("son_name")
son_name=request.form("musicdown")
son_name=request.form("tims_s")
son_name=request.form("alb_name")
son_name=request.form("languages")
son_name=request.form("pub_company")
son_name=request.form("pub_date")
son_name=request.form("orders")
son_name=request.form("ordersjs")
son_name=request.form("cover")
exec= "insert into yuanja(lmxx,sin_name,son_name,musicdown,tims_s,alb_name,languages,pub_company,pub_date,orders,ordersjs,cover)values( ' "+lmxx+ " ', ' "+sin_name+ " ', ' "+son_name+ " ',' "+musicdown+ " ',' "+tims_s+ " ',' "+alb_name+ " ',' "+languages+ " ',' "+pub_company+ " ',' "+pub_date+ " ',' "+orders+ " ',' "+ordersjs+ " ',' "+cover+ " ',) "
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功! "
htm 是静态的,必须事行知道数据,而且一成为文件数据就固定 了
今晚我又想了很久
重新把字段都分开了
现在是建立了3个表分别是 歌曲列表 歌手列表 专辑列表SQL代码贴出来
帮手看看要怎么链接好
这次的规划性应该比较好的了
要麻烦 happyflystone 再次帮手链接一下那些字段了if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Alblist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Alblist]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Musiclist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Musiclist]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sonlist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Sonlist]
GOCREATE TABLE [dbo].[Alblist] (
[alb_name_id] [int] NOT NULL ,
[sin_id] [float] NULL ,
[sin_name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[alb_name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[languages] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[pic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[pub_date] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[hit] [float] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[Musiclist] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[musicdown] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[son_name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[sin_name] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[sin_id] [int] NULL ,
[hit] [int] NULL ,
[alb_name_id] [int] NULL ,
[orders] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ordersjs] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GOCREATE TABLE [dbo].[Sonlist] (
[sin_id] [int] NOT NULL ,
[sin_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[pic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
种子标识 下载地址 歌名 歌手名字
sin_id hit alb_name_id orders ordersjs
歌手ID 点击数 专辑ID 专辑点评(内容) 专辑介绍(内容)
歌手名字列表 Sonlist sin_id sin_name pic
歌手ID 歌手名字 专辑封面图
专辑列表 Alblist alb_name_id sin_id sin_name alb_name languages
专辑ID 歌手ID 歌手名字 专辑名 语种 pic pub_date hit
专辑封面图 专辑发行日期 点击数