当前文件： ThreeLayerMusic/DB_51aspx/script.sql[22K，2009-6-12 11:57:32]，打开代码结构图

		            
  1USE [MusicData]
  2GO
  3/**//****** Object:  Table [dbo].[WebConfig]    Script Date: 10/30/2008 23:04:49 ******/
  4SET ANSI_NULLS ON
  5GO
  6SET QUOTED_IDENTIFIER ON
  7GO
  8CREATE TABLE [dbo].[WebConfig](
  9    [WebName] [nvarchar](max) NULL,
 10    [WebUrl] [nvarchar](max) NULL,
 11    [WebLogo] [nvarchar](max) NULL,
 12    [WebCopy] [nvarchar](max) NULL
 13) ON [PRIMARY]
 14GO
 15/**//****** Object:  Table [dbo].[Users]    Script Date: 10/30/2008 23:04:49 ******/
 16SET ANSI_NULLS ON
 17GO
 18SET QUOTED_IDENTIFIER ON
 19GO
 20CREATE TABLE [dbo].[Users](
 21    [userid] [int] IDENTITY(1,1) NOT NULL,
 22    [username] [nvarchar](255) NULL,
 23    [password] [nvarchar](255) NULL,
 24    [email] [nvarchar](255) NULL,
 25    [sex] [nvarchar](255) NULL,
 26    [regtimes] [datetime] NULL,
 27 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
 28(
 29    [userid] ASC
 30)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 31) ON [PRIMARY]
 32GO
 33/**//****** Object:  Table [dbo].[topic]    Script Date: 10/30/2008 23:04:49 ******/
 34SET ANSI_NULLS ON
 35GO
 36SET QUOTED_IDENTIFIER ON
 37GO
 38CREATE TABLE [dbo].[topic](
 39    [Topicid] [int] NULL,
 40    [title] [nvarchar](10) NULL,
 41    [boardid] [int] NULL,
 42    [addtime] [datetime] NULL
 43) ON [PRIMARY]
 44GO
 45/**//****** Object:  Table [dbo].[test]    Script Date: 10/30/2008 23:04:49 ******/
 46SET ANSI_NULLS ON
 47GO
 48SET QUOTED_IDENTIFIER ON
 49GO
 50CREATE TABLE [dbo].[test](
 51    [id] [int] IDENTITY(1,1) NOT NULL,
 52    [name] [nvarchar](255) NULL,
 53    [date] [datetime] NULL
 54) ON [PRIMARY]
 55GO
 56/**//****** Object:  Table [dbo].[syslog]    Script Date: 10/30/2008 23:04:49 ******/
 57SET ANSI_NULLS ON
 58GO
 59SET QUOTED_IDENTIFIER ON
 60GO
 61CREATE TABLE [dbo].[syslog](
 62    [lid] [int] IDENTITY(1,1) NOT NULL,
 63    [logmsg] [nvarchar](255) NULL,
 64    [logip] [nvarchar](50) NULL,
 65    [sysname] [nvarchar](255) NULL,
 66    [lotime] [datetime] NULL,
 67 CONSTRAINT [PK_syslog] PRIMARY KEY CLUSTERED 
 68(
 69    [lid] ASC
 70)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 71) ON [PRIMARY]
 72GO
 73/**//****** Object:  Table [dbo].[sysadmin]    Script Date: 10/30/2008 23:04:49 ******/
 74SET ANSI_NULLS ON
 75GO
 76SET QUOTED_IDENTIFIER ON
 77GO
 78CREATE TABLE [dbo].[sysadmin](
 79    [aid] [int] IDENTITY(1,1) NOT NULL,
 80    [aname] [nvarchar](255) NULL,
 81    [apass] [nvarchar](255) NULL,
 82    [aqx] [nvarchar](50) NULL,
 83 CONSTRAINT [PK_sysadmin] PRIMARY KEY CLUSTERED 
 84(
 85    [aid] ASC
 86)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 87) ON [PRIMARY]
 88GO
 89/**//****** Object:  Table [dbo].[Singer]    Script Date: 10/30/2008 23:04:49 ******/
 90SET ANSI_NULLS ON
 91GO
 92SET QUOTED_IDENTIFIER ON
 93GO
 94CREATE TABLE [dbo].[Singer](
 95    [SingerID] [int] IDENTITY(1,1) NOT NULL,
 96    [Singer] [nvarchar](255) NULL,
 97    [NavID] [int] NULL,
 98    [Abcd] [nvarchar](255) NULL,
 99    [da] [nvarchar](max) NULL,
100    [pic] [nvarchar](255) NULL,
101    [isgood] [int] NOT NULL,
102    [hits] [int] NULL,
103 CONSTRAINT [PK_Singer] PRIMARY KEY CLUSTERED 
104(
105    [SingerID] ASC
106)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
107) ON [PRIMARY]
108GO
109/**//****** Object:  Table [dbo].[searchpage]    Script Date: 10/30/2008 23:04:49 ******/
110SET ANSI_NULLS ON
111GO
112SET QUOTED_IDENTIFIER ON
113GO
114CREATE TABLE [dbo].[searchpage](
115    [pid] [int] IDENTITY(1,1) NOT NULL,
116    [psqlstr] [nvarchar](255) NULL,
117    [plist] [text] NULL,
118    [pcout] [int] NULL,
119    [pdate] [datetime] NULL,
120 CONSTRAINT [PK_searchpage] PRIMARY KEY CLUSTERED 
121(
122    [pid] ASC
123)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
124) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
125GO
126/**//****** Object:  Table [dbo].[searchcaches]    Script Date: 10/30/2008 23:04:49 ******/
127SET ANSI_NULLS ON
128GO
129SET QUOTED_IDENTIFIER ON
130GO
131CREATE TABLE [dbo].[searchcaches](
132    [searchid] [int] IDENTITY(1,1) NOT NULL,
133    [keywords] [nvarchar](255) NULL,
134    [searchstring] [nvarchar](255) NULL,
135    [ip] [nvarchar](50) NULL,
136    [topics] [int] NULL,
137    [tids] [text] NULL,
138    [postdatetime] [datetime] NULL,
139    [expiration] [datetime] NULL,
140 CONSTRAINT [PK_searchcaches] PRIMARY KEY CLUSTERED 
141(
142    [searchid] ASC
143)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
144) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
145GO
146/**//****** Object:  Table [dbo].[Nav]    Script Date: 10/30/2008 23:04:49 ******/
147SET ANSI_NULLS ON
148GO
149SET QUOTED_IDENTIFIER ON
150GO
151CREATE TABLE [dbo].[Nav](
152    [Navid] [int] IDENTITY(1,1) NOT NULL,
153    [NavName] [nvarchar](255) NULL,
154 CONSTRAINT [PK_Nav] PRIMARY KEY CLUSTERED 
155(
156    [Navid] ASC
157)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
158) ON [PRIMARY]
159GO
160/**//****** Object:  Table [dbo].[MusicList]    Script Date: 10/30/2008 23:04:49 ******/
161SET ANSI_NULLS ON
162GO
163SET QUOTED_IDENTIFIER ON
164GO
165CREATE TABLE [dbo].[MusicList](
166    [ID] [int] IDENTITY(1,1) NOT NULL,
167    [Wma] [nvarchar](255) NULL,
168    [MusicName] [nvarchar](255) NULL,
169    [Singer] [nvarchar](255) NULL,
170    [NavID] [int] NULL,
171    [SingerID] [int] NULL,
172    [hits] [int] NULL,
173    [AlbumID] [int] NULL,
174    [IsGood] [int] NOT NULL,
175    [LastTime] [datetime] NULL,
176    [SongWords] [nvarchar](max) NULL,
177 CONSTRAINT [PK_MusicList] PRIMARY KEY CLUSTERED 
178(
179    [ID] ASC
180)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
181) ON [PRIMARY]
182GO
183/**//****** Object:  Table [dbo].[Music_pinglun]    Script Date: 10/30/2008 23:04:49 ******/
184SET ANSI_NULLS ON
185GO
186SET QUOTED_IDENTIFIER ON
187GO
188CREATE TABLE [dbo].[Music_pinglun](
189    [mpid] [int] IDENTITY(1,1) NOT NULL,
190    [id] [int] NULL,
191    [username] [nvarchar](50) NULL,
192    [userid] [int] NULL,
193    [mpcon] [nvarchar](max) NULL,
194    [mptime] [datetime] NULL,
195 CONSTRAINT [PK_Music_pinlun] PRIMARY KEY CLUSTERED 
196(
197    [mpid] ASC
198)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
199) ON [PRIMARY]
200GO
201/**//****** Object:  Table [dbo].[LXFlash]    Script Date: 10/30/2008 23:04:49 ******/
202SET ANSI_NULLS ON
203GO
204SET QUOTED_IDENTIFIER ON
205GO
206CREATE TABLE [dbo].[LXFlash](
207    [ID] [int] IDENTITY(1,1) NOT NULL,
208    [PicUrl] [nvarchar](max) NULL,
209    [ImgUrl] [nvarchar](max) NULL,
210    [Url] [nvarchar](max) NULL,
211    [TName] [nvarchar](max) NULL,
212 CONSTRAINT [PK_LXFlash] PRIMARY KEY CLUSTERED 
213(
214    [ID] ASC
215)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
216) ON [PRIMARY]
217GO
218/**//****** Object:  Table [dbo].[Link]    Script Date: 10/30/2008 23:04:49 ******/
219SET ANSI_NULLS ON
220GO
221SET QUOTED_IDENTIFIER ON
222GO
223CREATE TABLE [dbo].[Link](
224    [LinkID] [int] IDENTITY(1,1) NOT NULL,
225    [LinkName] [nvarchar](max) NULL,
226    [LinkPic] [nvarchar](max) NULL,
227    [LinkUrl] [nvarchar](max) NULL,
228    [LinkDate] [datetime] NULL,
229 CONSTRAINT [PK_Link] PRIMARY KEY CLUSTERED 
230(
231    [LinkID] ASC
232)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
233) ON [PRIMARY]
234GO
235/**//****** Object:  Table [dbo].[KeyWord]    Script Date: 10/30/2008 23:04:49 ******/
236SET ANSI_NULLS ON
237GO
238SET QUOTED_IDENTIFIER ON
239GO
240CREATE TABLE [dbo].[KeyWord](
241    [KeyID] [int] IDENTITY(1,1) NOT NULL,
242    [KeyWords] [nvarchar](max) NULL,
243    [Keydate] [datetime] NULL,
244    [KeyHits] [int] NULL,
245    [KeyType] [nvarchar](max) NULL,
246    [KeyB] [nvarchar](max) NULL,
247 CONSTRAINT [PK_KeyWord] PRIMARY KEY CLUSTERED 
248(
249    [KeyID] ASC
250)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
251) ON [PRIMARY]
252GO
253/**//****** Object:  Table [dbo].[Album]    Script Date: 10/30/2008 23:04:49 ******/
254SET ANSI_NULLS ON
255GO
256SET QUOTED_IDENTIFIER ON
257GO
258CREATE TABLE [dbo].[Album](
259    [AlbumID] [int] IDENTITY(1,1) NOT NULL,
260    [NavID] [int] NULL,
261    [NavName] [nvarchar](255) NULL,
262    [SingerID] [int] NULL,
263    [Singer] [nvarchar](255) NULL,
264    [name] [nvarchar](255) NULL,
265    [Yuyan] [nvarchar](255) NULL,
266    [Gongsi] [nvarchar](255) NULL,
267    [pic] [nvarchar](255) NULL,
268    [intro] [nvarchar](max) NULL,
269    [Times] [nvarchar](255) NULL,
270    [hits] [int] NULL,
271    [IsGood] [int] NOT NULL,
272    [Date] [datetime] NULL,
273 CONSTRAINT [PK_Album] PRIMARY KEY CLUSTERED 
274(
275    [AlbumID] ASC
276)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
277) ON [PRIMARY]
278GO
279/**//****** Object:  Default [DF__Users__regtimes__2D27B809]    Script Date: 10/30/2008 23:04:49 ******/
280ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [DF__Users__regtimes__2D27B809]  DEFAULT (getdate()) FOR [regtimes]
281GO
282/**//****** Object:  Default [DF_test_date]    Script Date: 10/30/2008 23:04:49 ******/
283ALTER TABLE [dbo].[test] ADD  CONSTRAINT [DF_test_date]  DEFAULT (getdate()) FOR [date]
284GO
285/**//****** Object:  Default [DF_syslog_lotime]    Script Date: 10/30/2008 23:04:49 ******/
286ALTER TABLE [dbo].[syslog] ADD  CONSTRAINT [DF_syslog_lotime]  DEFAULT (getdate()) FOR [lotime]
287GO
288/**//****** Object:  Default [DF__Singer__isgood__59FA5E80]    Script Date: 10/30/2008 23:04:49 ******/
289ALTER TABLE [dbo].[Singer] ADD  DEFAULT ((0)) FOR [isgood]
290GO
291/**//****** Object:  Default [DF__Singer__hits__5AEE82B9]    Script Date: 10/30/2008 23:04:49 ******/
292ALTER TABLE [dbo].[Singer] ADD  DEFAULT ((0)) FOR [hits]
293GO
294/**//****** Object:  Default [DF_searchpage_pdate]    Script Date: 10/30/2008 23:04:49 ******/
295ALTER TABLE [dbo].[searchpage] ADD  CONSTRAINT [DF_searchpage_pdate]  DEFAULT (getdate()) FOR [pdate]
296GO
297/**//****** Object:  Default [DF__MusicList__hits__5BE2A6F2]    Script Date: 10/30/2008 23:04:49 ******/
298ALTER TABLE [dbo].[MusicList] ADD  DEFAULT ((0)) FOR [hits]
299GO
300/**//****** Object:  Default [DF__MusicList__IsGoo__5CD6CB2B]    Script Date: 10/30/2008 23:04:49 ******/
301ALTER TABLE [dbo].[MusicList] ADD  DEFAULT ((0)) FOR [IsGood]
302GO
303/**//****** Object:  Default [DF__MusicList__LastT__5DCAEF64]    Script Date: 10/30/2008 23:04:49 ******/
304ALTER TABLE [dbo].[MusicList] ADD  DEFAULT (getdate()) FOR [LastTime]
305GO
306/**//****** Object:  Default [DF_Music_pinlun_mptime]    Script Date: 10/30/2008 23:04:49 ******/
307ALTER TABLE [dbo].[Music_pinglun] ADD  CONSTRAINT [DF_Music_pinlun_mptime]  DEFAULT (getdate()) FOR [mptime]
308GO
309/**//****** Object:  Default [DF__Link__LinkDate__5FB337D6]    Script Date: 10/30/2008 23:04:49 ******/
310ALTER TABLE [dbo].[Link] ADD  DEFAULT (getdate()) FOR [LinkDate]
311GO
312/**//****** Object:  Default [DF__KeyWord__KeyHits__60A75C0F]    Script Date: 10/30/2008 23:04:49 ******/
313ALTER TABLE [dbo].[KeyWord] ADD  DEFAULT ((0)) FOR [KeyHits]
314GO
315/**//****** Object:  Default [DF__Album__hits__619B8048]    Script Date: 10/30/2008 23:04:49 ******/
316ALTER TABLE [dbo].[Album] ADD  DEFAULT ((0)) FOR [hits]
317GO
318/**//****** Object:  Default [DF__Album__IsGood__628FA481]    Script Date: 10/30/2008 23:04:49 ******/
319ALTER TABLE [dbo].[Album] ADD  DEFAULT ((0)) FOR [IsGood]
320GO
321/**//****** Object:  Default [DF__Album__Date__6383C8BA]    Script Date: 10/30/2008 23:04:49 ******/
322ALTER TABLE [dbo].[Album] ADD  DEFAULT (getdate()) FOR [Date]
323GO
324