Discuz.Web/install/sqlscript/sqlserver/album/setup2.1.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

CREATE TABLE [dnt_albums] (
	[albumid] [int] IDENTITY (1, 1) NOT NULL ,
	[albumcateid] [int] NOT NULL ,
	[userid] [int] NOT NULL CONSTRAINT [DF_dnt_spacealbums_userid] DEFAULT ((-1)),
	[username] [nchar] (20)  NOT NULL CONSTRAINT [DF_dnt_albums_username] DEFAULT (''),
	[title] [nchar] (50)  NOT NULL CONSTRAINT [DF_dnt_spacealbums_title] DEFAULT (''),
	[description] [nchar] (200)  NOT NULL CONSTRAINT [DF_dnt_spacealbums_description] DEFAULT (''),
	[logo] [nchar] (255)  NOT NULL CONSTRAINT [DF_dnt_spacealbums_logo] DEFAULT (''),
	[password] [nchar] (50)  NOT NULL CONSTRAINT [DF_dnt_spacealbums_password] DEFAULT (''),
	[imgcount] [int] NOT NULL CONSTRAINT [DF_dnt_spacealbums_imgcount] DEFAULT (0),
	[views] [int] NOT NULL CONSTRAINT [DF_dnt_spacealbums_views] DEFAULT (0),
	[type] [int] NOT NULL CONSTRAINT [DF_dnt_spacealbums_type] DEFAULT (0),
	[createdatetime] [datetime] NOT NULL CONSTRAINT [DF_dnt_spacealbums_createdatetime] DEFAULT (getdate()),
	CONSTRAINT [PK_dnt_spacealbums] PRIMARY KEY  CLUSTERED 
	(
		[albumid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [dnt_albumcategories] (
	[albumcateid] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nchar] (50)  NOT NULL ,
	[description] [nchar] (300)  NULL ,
	[albumcount] [int] NOT NULL CONSTRAINT [DF_dnt_albumcategories_albumcount] DEFAULT (0),
	[displayorder] [int] NOT NULL CONSTRAINT [DF_dnt_albumcategories_displayorder] DEFAULT (0),
	CONSTRAINT [PK_dnt_albumcategories] PRIMARY KEY  CLUSTERED 
	(
		[albumcateid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_photos] (
	[photoid] [int] IDENTITY (1, 1) NOT NULL ,
	[filename] [char] (255)  NOT NULL ,
	[attachment] [nchar] (255)  NOT NULL ,
	[filesize] [int] NOT NULL ,
	[title] [nchar] (20)  NOT NULL ,
	[description] [nchar] (200)  NOT NULL CONSTRAINT [DF_dnt_spacephoto_description] DEFAULT (''),
	[postdate] [datetime] NOT NULL CONSTRAINT [DF_dnt_spacephoto_postdate] DEFAULT (getdate()),
	[albumid] [int] NOT NULL ,
	[userid] [int] NOT NULL ,
	[username] [nchar] (20)  NOT NULL CONSTRAINT [DF_dnt_photos_username] DEFAULT (''),
	[views] [int] NOT NULL CONSTRAINT [DF_dnt_photos_viewcount] DEFAULT (0),
	[commentstatus] [tinyint] NOT NULL CONSTRAINT [DF_dnt_photos_commentstatus] DEFAULT (0),
	[tagstatus] [tinyint] NOT NULL CONSTRAINT [DF_dnt_photos_tagstatus] DEFAULT (0),
	[comments] [int] NOT NULL CONSTRAINT [DF_dnt_photos_comments] DEFAULT (0),
	[isattachment] [int] NOT NULL CONSTRAINT [DF_dnt_photos_isattachment] DEFAULT (0),
	[width] [int] NULL ,
	[height] [int] NULL ,
	CONSTRAINT [PK_dnt_spacephoto] PRIMARY KEY  CLUSTERED 
	(
		[photoid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_phototags] (