USE [Hincol] GO /****** Object: Table [dbo].[kjco_upload_career] Script Date: 05/27/2010 12:08:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[kjco_upload_career]( [id] [char](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [mcate] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [subcate] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [jobdesc] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [jprofile] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [jexp] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [edu] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [location] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [enterdate] [datetime] NULL, [datefrom] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [dateto] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF =================================================================================================== USE [Hincol] GO /****** Object: Table [dbo].[kjco_maincat] Script Date: 05/27/2010 12:09:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[kjco_maincat]( [id] [char](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [mcate] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [enterdate] [datetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF ========================================================================================================== USE [Hincol] GO /****** Object: Table [dbo].[kjco_subcat] Script Date: 05/27/2010 12:11:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[kjco_subcat]( [id] [char](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [mcateid] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [subcat] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [enterdate] [datetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF ===================================================================================================================