if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SUPO_BBS_FILE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[SUPO_BBS_FILE] DROP CONSTRAINT FK_SUPO_BBS_FILE GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SUPO_BBS_FILE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SUPO_BBS_FILE] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SUPO_BBS_LIST]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SUPO_BBS_LIST] GO
CREATE TABLE [dbo].[SUPO_BBS_FILE] ( [BBS_ID] [char] (6) COLLATE Korean_Wansung_CI_AS NOT NULL , [BBS_SEQ] [int] NOT NULL , [FILE_SEQ] [int] NOT NULL , [FILE_PATH] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL , [FILE_NM] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL , [FILE_STRG_NM] [varchar] (40) COLLATE Korean_Wansung_CI_AS NOT NULL , [FILE_SIZE] [varchar] (9) COLLATE Korean_Wansung_CI_AS NOT NULL , [FILE_CTYPE] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[SUPO_BBS_LIST] ( [BBS_ID] [char] (6) COLLATE Korean_Wansung_CI_AS NOT NULL , [BBS_SEQ] [int] NOT NULL , [ANSW_RFRN] [int] NOT NULL , [ANSW_SEQ] [smallint] NOT NULL , [ANSW_LVL] [smallint] NOT NULL , [COMP_ID] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL , [USR_ID] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL , [USR_NM] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL , [USR_MAIL] [varchar] (100) COLLATE Korean_Wansung_CI_AS NULL , [USR_IP] [varchar] (25) COLLATE Korean_Wansung_CI_AS NOT NULL , [TITL] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL , [BRWS_CNT] [int] NOT NULL , [REG_DT_TM] [datetime] NOT NULL , [UPD_DT_TM] [datetime] NOT NULL , [BGN_PRD] [datetime] NULL , [END_PRD] [datetime] NULL , [HTML_YN] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL , [DEL_YN] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL , [EVT_YN] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL , [CONT] [text] COLLATE Korean_Wansung_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
이렇게 em에서 다른 섭의 db의 bbs스크립트를 가져와서 실행시키면 collate에러가 나는데 왜 그런지 ㅡㅡa 급해염.... |