SET NOCOUNT ON;

/* TemplateType表 */
DELETE FROM templateType
SET IDENTITY_INSERT templateType ON
insert into templateType (pkId, name, type) values (1, 'login', '登录类')
insert into templateType (pkId, name, type) values (2, 'news', '新闻类')
insert into templateType (pkId, name, type) values (3, 'links', '链接类')
insert into templateType (pkId, name, type) values (4, 'search', '搜索类')
insert into templateType (pkId, name, type) values (5, 'dynamic', '动态类')
insert into templateType (pkId, name, type) values (6, 'other', '其它类')
SET IDENTITY_INSERT templateType OFF


/* Template表 */

SET IDENTITY_INSERT template ON
update template set typeId = 1 where pkId in (11,18,30)
update template set typeId = 2 where pkId in (1,5,6,7,10,12,13,15,22,26,27,28,32,33,36)
update template set typeId = 3 where pkId in (3,4,34,35)
update template set typeId = 4 where pkId in (9,17,19)
update template set typeId = 5 where pkId in (14,23,24,25,37)
update template set typeId = 6 where pkId in (16)
SET IDENTITY_INSERT template OFF

