CREATE TABLE [dnt_albumcategories] (
	[albumcateid] autoincrement (1,1) ,
	[title] longtext not null ,
	[description] longtext,
	[albumcount] long default 0,
	[displayorder] long default 0
	)
;

CREATE Unique INDEX [PrimaryKey] on [dnt_albumcategories]([albumcateid] ) with Primary
;

CREATE INDEX [albumcateid] on [dnt_albumcategories]([albumcateid] )
;



CREATE TABLE [dnt_albums] (
	[albumid] autoincrement (1,1) ,
	[albumcateid] long default 0,
	[userid] long default 0,
	[username] longtext,
	[title] longtext,
	[description] longtext,
	[logo] longtext,
	[password] longtext,
	[imgcount] long default 0,
	[views] long default 0,
	[type] long default 0,
	[createdatetime] datetime default Now()
	)
;

CREATE Unique INDEX [PrimaryKey] on [dnt_albums]([albumid] ) with Primary
;

CREATE INDEX [albumcateid] on [dnt_albums]([albumcateid] )
;

CREATE INDEX [albumid] on [dnt_albums]([albumid] )
;

CREATE INDEX [userid] on [dnt_albums]([userid] )
;



CREATE TABLE [dnt_help] (
	[id] autoincrement (1,1) ,
	[title] longtext,
	[message] longtext not null ,
	[pid] long default 0,
	[orderby] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_help]([id] ) with Primary
;
CREATE INDEX [id] on [dnt_help]([id] )
;
CREATE INDEX [pid] on [dnt_help]([pid] )
;



CREATE TABLE [dnt_myposts] (
	[uid] long default 0,
	[tid] long default 0,
	[pid] long default 0,
	[dateline] datetime
	)
;
CREATE INDEX [pid] on [dnt_myposts]([pid] )
;
CREATE INDEX [tid] on [dnt_myposts]([tid] )
;
CREATE INDEX [uid] on [dnt_myposts]([uid] )
;

CREATE TABLE [dnt_mytopics] (
	[uid] long default 0,
	[tid] long default 0,
	[dateline] datetime
	)
;
CREATE INDEX [tid] on [dnt_mytopics]([tid] )
;
CREATE INDEX [uid] on [dnt_mytopics]([uid] )
;

CREATE TABLE [dnt_photocomments] (
	[commentid] autoincrement (1,1) ,
	[photoid] long default 0,
	[username] varchar(50),
	[userid] long default 0,
	[ip] longtext,
	[postdatetime] datetime,
	[content] longtext
	)
;
CREATE INDEX [commentid] on [dnt_photocomments]([commentid] )
;
CREATE INDEX [photoid] on [dnt_photocomments]([photoid] )
;
CREATE INDEX [userid] on [dnt_photocomments]([userid] )
;


CREATE TABLE [dnt_photos] (
	[photoid] autoincrement (1,1) ,
	[filename] longtext,
	[attachment] longtext,
	[filesize] long default 0,
	[title] longtext,
	[description] longtext,
	[postdate] datetime default Now(),
	[albumid] long default 0,
	[userid] long default 0,
	[username] varchar(50),
	[views] long default 0,
	[commentstatus] long default 0,
	[tagstatus] long default 0,
	[comments] long default 0,
	[isattachment] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_photos]([photoid] ) with Primary
;
CREATE INDEX [albumid] on [dnt_photos]([albumid] )
;
CREATE INDEX [photoid] on [dnt_photos]([photoid] )
;
CREATE INDEX [userid] on [dnt_photos]([userid] )
;


CREATE TABLE [dnt_phototags] (
	[tagid] long default 0,
	[photoid] long default 0
	)
;
CREATE INDEX [tagid] on [dnt_phototags]([tagid] )
;
CREATE INDEX [tagid1] on [dnt_phototags]([photoid] )
;

CREATE TABLE [dnt_spaceattachments] (
	[aid] autoincrement (1,1) ,
	[uid] long default 0,
	[spacepostid] long default 0,
	[postdatetime] datetime default Now(),
	[filename] longtext,
	[filetype] varchar(50),
	[filesize] long default 0,
	[attachment] longtext,
	[downloads] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spaceattachments]([aid] ) with Primary
;
CREATE INDEX [aid] on [dnt_spaceattachments]([aid] )
;
CREATE INDEX [spacepostid] on [dnt_spaceattachments]([spacepostid] )
;
CREATE INDEX [uid] on [dnt_spaceattachments]([uid] )
;


CREATE TABLE [dnt_spacecategories] (
	[categoryid] autoincrement (1,1) ,
	[title] longtext,
	[uid] long default 0,
	[description] longtext,
	[typeid] long default 0,
	[categorycount] long default 0,
	[displayorder] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacecategories]([categoryid] ) with Primary
;
CREATE INDEX [id] on [dnt_spacecategories]([categoryid] )
;
CREATE INDEX [postid] on [dnt_spacecategories]([title] )
;
CREATE INDEX [typeid] on [dnt_spacecategories]([typeid] )
;
CREATE INDEX [uid] on [dnt_spacecategories]([uid] )
;



CREATE TABLE [dnt_spacecomments] (
	[commentid] autoincrement (1,1) ,
	[postid] long default 0,
	[author] varchar(50),
	[email] varchar(50),
	[url] varchar(50),
	[ip] varchar(50),
	[postdatetime] datetime default Now(),
	[content] longtext,
	[parentid] long default 0,
	[uid] long default 0,
	[posttitle] varchar(50)
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacecomments]([commentid] ) with Primary
;
CREATE INDEX [commentid] on [dnt_spacecomments]([commentid] )
;
CREATE INDEX [parentid] on [dnt_spacecomments]([parentid] )
;
CREATE INDEX [postid] on [dnt_spacecomments]([postid] )
;
CREATE INDEX [uid] on [dnt_spacecomments]([uid] )
;


CREATE TABLE [dnt_spaceconfigs] (
	[spaceid] autoincrement (1,1) ,
	[userid] long default 0,
	[spacetitle] varchar(50),
	[description] varchar(50),
	[blogdispmode] long default 0,
	[bpp] long default 0,
	[commentpref] long default 0,
	[messagepref] long default 0,
	[rewritename] longtext,
	[themeid] long default 0,
	[themepath] varchar(50),
	[postcount] long default 0,
	[commentcount] long default 0,
	[visitedtimes] long default 0,
	[createdatetime] datetime default Now(),
	[updatedatetime] datetime default Now(),
	[defaulttab] long default 0,
	[status] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spaceconfigs]([spaceid] ) with Primary
;
CREATE INDEX [spaceid] on [dnt_spaceconfigs]([spaceid] )
;
CREATE INDEX [themeid] on [dnt_spaceconfigs]([themeid] )
;
CREATE INDEX [userid] on [dnt_spaceconfigs]([userid] )
;



CREATE TABLE [dnt_spacecustomizepanels] (
	[moduleid] long default 0,
	[userid] varchar(50),
	[panelcontent] longtext
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacecustomizepanels]([moduleid] ) with Primary
;
CREATE INDEX [userid] on [dnt_spacecustomizepanels]([userid] )
;

CREATE TABLE [dnt_spacelinks] (
	[linkid] autoincrement (1,1) ,
	[userid] long default 0,
	[linktitle] longtext,
	[linkurl] varchar(50),
	[description] longtext
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacelinks]([linkid] ) with Primary
;
CREATE INDEX [linkid] on [dnt_spacelinks]([linkid] )
;
CREATE INDEX [userid] on [dnt_spacelinks]([userid] )
;

CREATE TABLE [dnt_spacemoduledefs] (
	[moduledefid] autoincrement (1,1) ,
	[modulename] varchar(50),
	[cachetime] long default 0,
	[configfile] longtext,
	[controller] longtext
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacemoduledefs]([moduledefid] ) with Primary
;
CREATE INDEX [moduledefid] on [dnt_spacemoduledefs]([moduledefid] )
;

CREATE TABLE [dnt_spacemodules] (
	[moduleid] long default 0,
	[tabid] long default 0,
	[uid] long default 0,
	[moduledefid] long default 0,
	[panename] varchar(50),
	[displayorder] long default 0,
	[userpref] longtext,
	[val] long default 0,
	[moduletype] long default 0,
	[moduleurl] varchar(50)
	)
;
CREATE INDEX [moduledefid] on [dnt_spacemodules]([moduledefid] )
;
CREATE INDEX [moduleid] on [dnt_spacemodules]([moduleid] )
;
CREATE INDEX [tabid] on [dnt_spacemodules]([tabid] )
;
CREATE INDEX [uid] on [dnt_spacemodules]([uid] )
;

CREATE TABLE [dnt_spacepostcategories] (
	[id] autoincrement (1,1) ,
	[postid] long default 0,
	[categoryid] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacepostcategories]([id] ) with Primary
;
CREATE INDEX [categoryid] on [dnt_spacepostcategories]([categoryid] )
;
CREATE INDEX [id] on [dnt_spacepostcategories]([id] )
;
CREATE INDEX [postid] on [dnt_spacepostcategories]([postid] )
;

CREATE TABLE [dnt_spaceposts] (
	[postid] autoincrement (1,1) ,
	[author] longtext,
	[uid] long default 0,
	[postdatetime] datetime,
	[content] longtext,
	[title] longtext,
	[category] longtext,
	[poststatus] long default 0,
	[commentstatus] long default 0,
	[postupdatetime] datetime,
	[views] long default 0,
	[commentcount] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spaceposts]([postid] ) with Primary
;
CREATE INDEX [postid] on [dnt_spaceposts]([postid] )
;
CREATE INDEX [uid] on [dnt_spaceposts]([uid] )
;

CREATE TABLE [dnt_spaceposttags] (
	[tagid] long default 0,
	[spacepostid] long default 0
	)
;
CREATE INDEX [spacepostid] on [dnt_spaceposttags]([spacepostid] )
;
CREATE INDEX [tagid] on [dnt_spaceposttags]([tagid] )
;

CREATE TABLE [dnt_spacetabs] (
	[tabid] long default 0,
	[uid] long default 0,
	[displayorder] long default 0,
	[tabname] varchar(50),
	[iconfile] varchar(50),
	[template] varchar(50)
	)
;
CREATE INDEX [tabid] on [dnt_spacetabs]([tabid] )
;
CREATE INDEX [uid] on [dnt_spacetabs]([uid] )
;

CREATE TABLE [dnt_spacethemes] (
	[themeid] autoincrement (1,1) ,
	[directory] varchar(50),
	[name] varchar(50),
	[type] long default 0,
	[author] varchar(50),
	[createdate] varchar(50),
	[copyright] varchar(50)
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_spacethemes]([themeid] ) with Primary
;
CREATE INDEX [themeid] on [dnt_spacethemes]([themeid] )
;

CREATE TABLE [dnt_tags] (
	[tagid] autoincrement (1,1) ,
	[tagname] varchar(50),
	[userid] long default 0,
	[postdatatime] datetime,
	[orderid] long default 0,
	[color] varchar(50),
	[count] long default 0,
	[fcount] long default 0,
	[pcount] long default 0,
	[scount] long default 0,
	[vcount] long default 0
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_tags]([tagid] ) with Primary
;
CREATE INDEX [orderid] on [dnt_tags]([orderid] )
;
CREATE INDEX [tagid] on [dnt_tags]([tagid] )
;
CREATE INDEX [userid] on [dnt_tags]([userid] )
;



CREATE TABLE [dnt_topicidentify] (
	[identifyid] autoincrement (1,1) ,
	[name] longtext,
	[filename] longtext
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_topicidentify]([identifyid] ) with Primary
;
CREATE INDEX [identifyid] on [dnt_topicidentify]([identifyid] )
;


CREATE TABLE [dnt_topictagcaches] (
	[tid] long default 0,
	[linktid] long default 0,
	[linktitle] varchar(50)
	)
;
CREATE INDEX [linktid] on [dnt_topictagcaches]([linktid] )
;
CREATE INDEX [tid] on [dnt_topictagcaches]([tid] )
;



CREATE TABLE [dnt_topictags] (
	[tagid] long default 0,
	[tid] long default 0
	)
;
CREATE INDEX [tagid] on [dnt_topictags]([tagid] )
;
CREATE INDEX [tid] on [dnt_topictags]([tid] )
;


CREATE TABLE [dnt_topictypes] (
	[typeid] autoincrement (1,1) ,
	[displayorder] long default 0,
	[name] varchar(30) default "''",
	[description] varchar(255) default "''"
	)
;
CREATE Unique INDEX [PrimaryKey] on [dnt_topictypes]([typeid] ) with Primary
;
CREATE INDEX [typeid] on [dnt_topictypes]([typeid] )
;

CREATE INDEX [msgtoid] ON [dnt_pms] ([msgtoid])
;


DROP TABLE [dnt_smilies];

CREATE TABLE [dnt_smilies] (
	[id] long default 0,
	[displayorder] long not null ,
	[type] long not null ,
	[code] varchar(30) not null ,
	[url] varchar(60) not null 
	)
;




ALTER TABLE [dnt_admingroups] ADD [allowviewrealname] integer NULL;
UPDATE [dnt_admingroups] SET [allowviewrealname] = 1;
ALTER TABLE [dnt_admingroups] ALTER column [allowviewrealname] integer NOT NULL;

ALTER TABLE [dnt_favorites] ADD [typeid] integer NOT NULL DEFAULT 0;

ALTER TABLE [dnt_forumfields] ADD [applytopictype] integer NOT NULL DEFAULT 0;
ALTER TABLE [dnt_forumfields] ADD [postbytopictype] integer NOT NULL DEFAULT 0;
ALTER TABLE [dnt_forumfields] ADD [viewbytopictype] integer NOT NULL DEFAULT 0;
ALTER TABLE [dnt_forumfields] ADD [topictypeprefix] integer NOT NULL DEFAULT 0;
ALTER TABLE [dnt_forumfields] ADD [permuserlist] longtext NULL;



ALTER TABLE [dnt_advertisements] Alter [code] longtext NOT NULL DEFAULT '';

ALTER TABLE [dnt_advertisements] Alter [parameters] longtext NOT NULL DEFAULT '';


ALTER TABLE [dnt_userfields] ADD [realname] varchar (10) NOT NULL DEFAULT '';
ALTER TABLE [dnt_userfields] ADD [idcard] varchar (20) NOT NULL DEFAULT '';
ALTER TABLE [dnt_userfields] ADD [mobile] varchar (20) NOT NULL DEFAULT '';
ALTER TABLE [dnt_userfields] ADD [phone] varchar (20) NOT NULL DEFAULT '';

ALTER TABLE [dnt_usergroups] ADD [allowspace] short NOT NULL DEFAULT 0;
ALTER TABLE [dnt_usergroups] ADD [maxspaceattachsize] long NOT NULL DEFAULT 0;
ALTER TABLE [dnt_usergroups] ADD [maxspacephotosize] long NOT NULL DEFAULT 0;

ALTER TABLE [dnt_topics] ADD [identify] integer NOT NULL DEFAULT 0;

ALTER TABLE [dnt_users] ADD [spaceid] integer NOT NULL DEFAULT 0;

ALTER TABLE [dnt_users] DROP COLUMN [newsletter];
ALTER TABLE [dnt_users] ADD [newsletter] integer NOT NULL DEFAULT 7;

UPDATE [dnt_favorites] SET [typeid]=0;
UPDATE [dnt_forumfields] SET [applytopictype]=0, [postbytopictype]=0, [viewbytopictype]=0, [topictypeprefix]=0;
UPDATE [dnt_userfields] SET [realname]='', [idcard]='', [mobile]='', [phone]='';
UPDATE [dnt_usergroups] SET [allowspace]=0, [maxspaceattachsize]=0, [maxspacephotosize]=0;
UPDATE [dnt_topics] SET [identify]=0;
UPDATE [dnt_users] SET [spaceid]=0, [newsletter]=7;


INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('', '默认皮肤', 0, 'Discuz!NT', '2007-08-23', 'Copyright 2007 Comsenz Inc.');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('', '部落窝', 0, '部落窝', '2007-08-23', 'Copyright©2005-2007 BlogWorld. All rights reserved');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('default', '默认皮肤', 1, 'Discuz!NT', '2007-08-23', 'Copyright 2007 Comsenz Inc.');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('fadgirl', '时尚女孩', 1, 'Discuz!NT', '2007-08-23', 'Copyright 2007 Comsenz Inc.');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('dream', '梦幻', 1, 'Discuz!NT', '2007-08-23', 'Copyright 2007 Comsenz Inc.');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('patina', '古色古香', 1, 'Discuz!NT', '2007-08-23', 'Copyright 2007 Comsenz Inc.');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('romantic', '浪漫传奇', 1, 'Discuz!NT', '2007-08-23', 'Copyright 2007 Comsenz Inc.');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('window', '窗', 2, '部落窝', '2007-08-23', 'Copyright©2005-2007 BlogWorld. All rights reserved');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('orange', '桔色', 2,  '部落窝', '2007-08-23', 'Copyright©2005-2007 BlogWorld. All rights reserved');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('green', '幽静夜空', 2, '部落窝', '2007-08-23', 'Copyright©2005-2007 BlogWorld. All rights reserved');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('bird', '山水麻雀', 2,  '部落窝', '2007-08-23', 'Copyright©2005-2007 BlogWorld. All rights reserved');
INSERT INTO [dnt_spacethemes]([directory], [name], [type], [author], [createdate], [copyright]) VALUES ('promise', '约定一生', 2,  '部落窝', '2007-08-23', 'Copyright©2005-2007 BlogWorld. All rights reserved');

INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('友情链接', 0, 'builtin_linkmodule.xml', 'Discuz.Space.Modules.LinkModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('个人信息', 0, 'builtin_userinfomodule.xml', 'Discuz.Space.Modules.builtin.forum.UserInfoModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('帖子调用', 0, 'builtin_showtopicmodule.xml', 'Discuz.Space.Modules.builtin.forum.ShowTopicModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('日历', 0, 'builtin_calendarmodule.xml', 'Discuz.Space.Modules.CalendarModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('用户菜单', 0, 'builtin_leftmenumodule.xml', 'Discuz.Space.Modules.LeftMenuModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('最新评论', 0, 'builtin_newcommentmodule.xml', 'Discuz.Space.Modules.NewCommentModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('最新文章', 0, 'builtin_newpostmodule.xml', 'Discuz.Space.Modules.NewPostModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('文章列表', 0, 'builtin_postlistmodule.xml', 'Discuz.Space.Modules.PostListModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('便条纸', 0, 'builtin_notepadmodule.xml', 'Discuz.Space.Modules.builtin.notepad, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('数据统计', 0, 'builtin_statisticmodule.xml', 'Discuz.Space.Modules.StatisticModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('我的相册', 0, 'builtin_showalbummodule.xml', 'Discuz.Web.space.modules.builtin.album.ShowAlbumModule, Discuz.Web');
INSERT INTO [dnt_spacemoduledefs]([modulename], [cachetime], [configfile], [controller]) VALUES ('自定义面板', 0, 'builtin_customizepanel.xml', 'Discuz.Space.Modules.builtin.CustomizePanel, Discuz.Web');

INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('人物', '生活随拍 朋友恋人 偶像明星 帅哥美女 网友自拍', 0, 1);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('风景', '自然风景 名胜古迹 建筑雕塑 民俗风情 城市魅影', 0, 2);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('动物', '狗 猫 鸟类 鱼类 昆虫', 0, 3);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('植物', '花卉 树木', 0, 4);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('艺术', '邮票 古玩 绘画 书法 篆刻', 0, 5);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('娱乐', '搞笑 游戏 动漫 电影', 0, 6);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('体育', '足球 篮球 奥运会 世界杯', 0, 7);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('时尚', '汽车 时装 家居 美食 手机', 0, 8);
INSERT INTO [dnt_albumcategories]([title], [description], [albumcount], [displayorder]) VALUES ('科技', '天文 地理 海洋 科普 计算机', 0, 9);

INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('找抽帖', 'zc.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('变态帖', 'bt.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('吵架帖', 'cj.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('炫耀帖', 'xy.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('炒作帖', 'cz.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('委琐帖', 'ws.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('火星帖', 'hx.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('精彩帖', 'jc.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('无聊帖', 'wl.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('温情帖', 'wq.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('XX帖', 'xx.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('跟风帖', 'gf.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('垃圾帖', 'lj.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('推荐帖', 'tj.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('搞笑帖', 'gx.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('悲情帖', 'bq.gif');
INSERT INTO [dnt_topicidentify]([name], [filename]) VALUES ('牛帖', 'nb.gif');

INSERT INTO [dnt_smilies] VALUES (1, 0, 0, '默认表情', 'default');
INSERT INTO [dnt_smilies] VALUES (2, 0, 1, ':default1:', 'default/0.gif');
INSERT INTO [dnt_smilies] VALUES (3, 0, 1, ':default2:', 'default/1.gif');
INSERT INTO [dnt_smilies] VALUES (4, 0, 1, ':default3:', 'default/10.gif');
INSERT INTO [dnt_smilies] VALUES (5, 0, 1, ':default4:', 'default/11.gif');
INSERT INTO [dnt_smilies] VALUES (6, 0, 1, ':default5:', 'default/12.gif');
INSERT INTO [dnt_smilies] VALUES (7, 0, 1, ':default6:', 'default/13.gif');
INSERT INTO [dnt_smilies] VALUES (8, 0, 1, ':default7:', 'default/14.gif');
INSERT INTO [dnt_smilies] VALUES (9, 0, 1, ':default8:', 'default/15.gif');
INSERT INTO [dnt_smilies] VALUES (10, 0, 1, ':default9:', 'default/16.gif');
INSERT INTO [dnt_smilies] VALUES (11, 0, 1, ':default10:', 'default/17.gif');
INSERT INTO [dnt_smilies] VALUES (12, 0, 1, ':default11:', 'default/18.gif');
INSERT INTO [dnt_smilies] VALUES (13, 0, 1, ':default12:', 'default/19.gif');
INSERT INTO [dnt_smilies] VALUES (14, 0, 1, ':default13:', 'default/2.gif');
INSERT INTO [dnt_smilies] VALUES (15, 0, 1, ':default14:', 'default/20.gif');
INSERT INTO [dnt_smilies] VALUES (16, 0, 1, ':default15:', 'default/21.gif');
INSERT INTO [dnt_smilies] VALUES (17, 0, 1, ':default16:', 'default/22.gif');
INSERT INTO [dnt_smilies] VALUES (18, 0, 1, ':default17:', 'default/23.gif');
INSERT INTO [dnt_smilies] VALUES (19, 0, 1, ':default18:', 'default/24.gif');
INSERT INTO [dnt_smilies] VALUES (20, 0, 1, ':default19:', 'default/25.gif');
INSERT INTO [dnt_smilies] VALUES (21, 0, 1, ':default20:', 'default/26.gif');
INSERT INTO [dnt_smilies] VALUES (22, 0, 1, ':default21:', 'default/27.gif');
INSERT INTO [dnt_smilies] VALUES (23, 0, 1, ':default22:', 'default/28.gif');
INSERT INTO [dnt_smilies] VALUES (24, 0, 1, ':default23:', 'default/29.gif');
INSERT INTO [dnt_smilies] VALUES (25, 0, 1, ':default24:', 'default/3.gif');
INSERT INTO [dnt_smilies] VALUES (26, 0, 1, ':default25:', 'default/30.gif');
INSERT INTO [dnt_smilies] VALUES (27, 0, 1, ':default26:', 'default/31.gif');
INSERT INTO [dnt_smilies] VALUES (28, 0, 1, ':default27:', 'default/32.gif');
INSERT INTO [dnt_smilies] VALUES (29, 0, 1, ':default28:', 'default/33.gif');
INSERT INTO [dnt_smilies] VALUES (30, 0, 1, ':default29:', 'default/34.gif');
INSERT INTO [dnt_smilies] VALUES (31, 0, 1, ':default30:', 'default/35.gif');
INSERT INTO [dnt_smilies] VALUES (32, 0, 1, ':default31:', 'default/36.gif');
INSERT INTO [dnt_smilies] VALUES (33, 0, 1, ':default32:', 'default/37.gif');
INSERT INTO [dnt_smilies] VALUES (34, 0, 1, ':default33:', 'default/38.gif');
INSERT INTO [dnt_smilies] VALUES (35, 0, 1, ':default34:', 'default/39.gif');
INSERT INTO [dnt_smilies] VALUES (36, 0, 1, ':default35:', 'default/4.gif');
INSERT INTO [dnt_smilies] VALUES (37, 0, 1, ':default36:', 'default/40.gif');
INSERT INTO [dnt_smilies] VALUES (38, 0, 1, ':default37:', 'default/41.gif');
INSERT INTO [dnt_smilies] VALUES (39, 0, 1, ':default38:', 'default/42.gif');
INSERT INTO [dnt_smilies] VALUES (40, 0, 1, ':default39:', 'default/43.gif');
INSERT INTO [dnt_smilies] VALUES (41, 0, 1, ':default40:', 'default/44.gif');
INSERT INTO [dnt_smilies] VALUES (42, 0, 1, ':default41:', 'default/45.gif');
INSERT INTO [dnt_smilies] VALUES (43, 0, 1, ':default42:', 'default/46.gif');
INSERT INTO [dnt_smilies] VALUES (44, 0, 1, ':default43:', 'default/47.gif');
INSERT INTO [dnt_smilies] VALUES (45, 0, 1, ':default44:', 'default/48.gif');
INSERT INTO [dnt_smilies] VALUES (46, 0, 1, ':default45:', 'default/49.gif');
INSERT INTO [dnt_smilies] VALUES (47, 0, 1, ':default46:', 'default/5.gif');
INSERT INTO [dnt_smilies] VALUES (48, 0, 1, ':default47:', 'default/50.gif');
INSERT INTO [dnt_smilies] VALUES (49, 0, 1, ':default48:', 'default/51.gif');
INSERT INTO [dnt_smilies] VALUES (50, 0, 1, ':default49:', 'default/52.gif');
INSERT INTO [dnt_smilies] VALUES (51, 0, 1, ':default50:', 'default/53.gif');
INSERT INTO [dnt_smilies] VALUES (52, 0, 1, ':default51:', 'default/54.gif');
INSERT INTO [dnt_smilies] VALUES (53, 0, 1, ':default52:', 'default/55.gif');
INSERT INTO [dnt_smilies] VALUES (54, 0, 1, ':default53:', 'default/56.gif');
INSERT INTO [dnt_smilies] VALUES (55, 0, 1, ':default54:', 'default/57.gif');
INSERT INTO [dnt_smilies] VALUES (56, 0, 1, ':default55:', 'default/58.gif');
INSERT INTO [dnt_smilies] VALUES (57, 0, 1, ':default56:', 'default/59.gif');
INSERT INTO [dnt_smilies] VALUES (58, 0, 1, ':default57:', 'default/6.gif');
INSERT INTO [dnt_smilies] VALUES (59, 0, 1, ':default58:', 'default/60.gif');
INSERT INTO [dnt_smilies] VALUES (60, 0, 1, ':default59:', 'default/61.gif');
INSERT INTO [dnt_smilies] VALUES (61, 0, 1, ':default60:', 'default/62.gif');
INSERT INTO [dnt_smilies] VALUES (62, 0, 1, ':default61:', 'default/63.gif');
INSERT INTO [dnt_smilies] VALUES (63, 0, 1, ':default62:', 'default/64.gif');
INSERT INTO [dnt_smilies] VALUES (64, 0, 1, ':default63:', 'default/65.gif');
INSERT INTO [dnt_smilies] VALUES (65, 0, 1, ':default64:', 'default/66.gif');
INSERT INTO [dnt_smilies] VALUES (66, 0, 1, ':default65:', 'default/67.gif');
INSERT INTO [dnt_smilies] VALUES (67, 0, 1, ':default66:', 'default/68.gif');
INSERT INTO [dnt_smilies] VALUES (68, 0, 1, ':default67:', 'default/69.gif');
INSERT INTO [dnt_smilies] VALUES (69, 0, 1, ':default68:', 'default/7.gif');
INSERT INTO [dnt_smilies] VALUES (70, 0, 1, ':default69:', 'default/70.gif');
INSERT INTO [dnt_smilies] VALUES (71, 0, 1, ':default70:', 'default/71.gif');
INSERT INTO [dnt_smilies] VALUES (72, 0, 1, ':default71:', 'default/72.gif');
INSERT INTO [dnt_smilies] VALUES (73, 0, 1, ':default72:', 'default/73.gif');
INSERT INTO [dnt_smilies] VALUES (74, 0, 1, ':default73:', 'default/74.gif');
INSERT INTO [dnt_smilies] VALUES (75, 0, 1, ':default74:', 'default/75.gif');
INSERT INTO [dnt_smilies] VALUES (76, 0, 1, ':default75:', 'default/76.gif');
INSERT INTO [dnt_smilies] VALUES (77, 0, 1, ':default76:', 'default/77.gif');
INSERT INTO [dnt_smilies] VALUES (78, 0, 1, ':default77:', 'default/78.gif');
INSERT INTO [dnt_smilies] VALUES (79, 0, 1, ':default78:', 'default/79.gif');
INSERT INTO [dnt_smilies] VALUES (80, 0, 1, ':default79:', 'default/8.gif');
INSERT INTO [dnt_smilies] VALUES (81, 0, 1, ':default80:', 'default/80.gif');
INSERT INTO [dnt_smilies] VALUES (82, 0, 1, ':default81:', 'default/81.gif');
INSERT INTO [dnt_smilies] VALUES (83, 0, 1, ':default82:', 'default/82.gif');
INSERT INTO [dnt_smilies] VALUES (84, 0, 1, ':default83:', 'default/83.gif');
INSERT INTO [dnt_smilies] VALUES (86, 0, 1, ':default84:', 'default/84.gif');
INSERT INTO [dnt_smilies] VALUES (87, 0, 1, ':default85:', 'default/85.gif');
INSERT INTO [dnt_smilies] VALUES (88, 0, 1, ':default86:', 'default/86.gif');
INSERT INTO [dnt_smilies] VALUES (89, 0, 1, ':default87:', 'default/9.gif');

UPDATE [dnt_usergroups] SET [maxspaceattachsize]=204800, [maxspacephotosize]=204800 WHERE [groupid] < 4 OR [groupid] > 9