--	添加图片应用
INSERT INTO [DB_CLASS]
           ([Name]
           ,[Remark]
           ,[Icon]
           ,[Url]
           ,[Type])
     VALUES
           ('图片管理'
           ,'分类存储图片、照片资源'
           ,'Template/Image/icon_application_album.gif'
           ,'Main/Album/Default.aspx'
           ,0);
--	添加应用扩展类型
INSERT INTO [DB_CLASS_EXTENSION]
           ([ClassId]
           ,[Name]
           ,[Extension])
	SELECT ClassId, 'JPEG 图片', 'jpeg'
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_CLASS_EXTENSION]
           ([ClassId]
           ,[Name]
           ,[Extension])
	SELECT ClassId, 'JPEG 图片', 'jpg'
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_CLASS_EXTENSION]
           ([ClassId]
           ,[Name]
           ,[Extension])
	SELECT ClassId, 'GIF 图像', 'gif'
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_CLASS_EXTENSION]
           ([ClassId]
           ,[Name]
           ,[Extension])
	SELECT ClassId, 'PNG 图形格式', 'png'
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_CLASS_EXTENSION]
           ([ClassId]
           ,[Name]
           ,[Extension])
	SELECT ClassId, 'Windows 位图', 'bmp'
		From DB_CLASS Where Name = '图片管理';
--	添加标签
INSERT INTO [DB_ATTRIBUTE]
           ([ClassId]
           ,[Name]
           ,[Remark]
           ,[Type]
           ,[Required]
           ,[Special]
           ,[DefaultValue])
	SELECT ClassId, '相机品牌', '', 3, 0, 1, ''
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_ATTRIBUTE]
           ([ClassId]
           ,[Name]
           ,[Remark]
           ,[Type]
           ,[Required]
           ,[Special]
           ,[DefaultValue])
	SELECT ClassId, '相机型号', '', 3, 0, 2, ''
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_ATTRIBUTE]
           ([ClassId]
           ,[Name]
           ,[Remark]
           ,[Type]
           ,[Required]
           ,[Special]
           ,[DefaultValue])
	SELECT ClassId, '宽度', '', 1, 0, 3, ''
		From DB_CLASS Where Name = '图片管理';
INSERT INTO [DB_ATTRIBUTE]
           ([ClassId]
           ,[Name]
           ,[Remark]
           ,[Type]
           ,[Required]
           ,[Special]
           ,[DefaultValue])
	SELECT ClassId, '高度', '', 1, 0, 4, ''
		From DB_CLASS Where Name = '图片管理';