

CREATE TABLE [ebizTruck].[dbo].[Car] (
	[CarNo] [varchar] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CarNumber] [varchar] (15) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DriverCode] [varchar] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DriverName] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TelNumber1] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TelNumber2] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[MachineNumber] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ProductDate] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[OwnerType] [varchar] (2) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Capacity] [int] NOT NULL ,
	[TransportPrice] [int] NOT NULL ,
	[IDCardNo] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[GroupID] [smallint] NOT NULL ,
	[CarIndex] [smallint] NOT NULL ,
	[PriorOrder] [smallint] NOT NULL ,
	[PriorTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[*StandbyOrder] [smallint] NOT NULL ,
	[*CarStatus] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[*TagDate] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[*TagTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[*InvoiceNo] [smallint] NOT NULL ,
	[*CustName] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[*SiteName] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[CarAdjust] (
	[AdjustDate] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AdjustTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CarNo] [varchar] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AdjustType] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AdjustCount] [smallint] NOT NULL ,
	[EditType] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[CarTagLog] (
	[TagDate] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TagTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[IDCardNo] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CarNo] [varchar] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DriverName] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CarStatus] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PlanDate] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PlanNo] [smallint] NOT NULL ,
	[InvoiceNo] [smallint] NOT NULL ,
	[InvoiceTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AfterWork] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[StandbyMinute] [int] NOT NULL ,
	[WorkMinute] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[CarWork] (
	[PlanDate] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CarNo] [varchar] (6) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DriverName] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[FirstTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CarStatus] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[StandbyOrder] [smallint] NOT NULL ,
	[TagTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[InvoiceTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DayTotal] [smallint] NOT NULL ,
	[DayReal] [smallint] NOT NULL ,
	[DayAdjust] [smallint] NOT NULL ,
	[AfterCount] [smallint] NOT NULL ,
	[MonthTotal] [smallint] NOT NULL ,
	[YearTotal] [smallint] NOT NULL ,
	[GroupID] [smallint] NOT NULL ,
	[PriorOrder] [smallint] NOT NULL ,
	[PriorTime] [varchar] (8) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[MonthReal] [smallint] NOT NULL ,
	[MonthAdjust] [smallint] NOT NULL ,
	[YearReal] [smallint] NOT NULL ,
	[YearAdjust] [smallint] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Conf_Config] (
	[SectionKey] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ItemKey] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[UserID] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ItemValue] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Unit] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DisplayOrder] [int] NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (255) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Conf_ConnDB] (
	[ConnName] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[UseConnection] [varchar] (2) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[dbType] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Host] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[dbName] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ID] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PWD] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[*ShareName] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ShareID] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[SharePWD] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Conf_Printer] (
	[ReportCode] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PrinterType] [varchar] (2) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[SystemUse] [varchar] (2) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DefaultUse] [varchar] (2) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ReportName] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PrinterName] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PrinterPort] [varchar] (5) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PrinterDriver] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[PaperSize] [int] NOT NULL ,
	[TopMargin] [real] NOT NULL ,
	[LeftMargin] [real] NOT NULL ,
	[RightMargin] [real] NOT NULL ,
	[BottomMargin] [real] NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[LastDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (200) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Conf_Report] (
	[ReportCode] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ReportName] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[SubmitCount] [int] NOT NULL ,
	[Submit1] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit2] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit3] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit4] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit5] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit6] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit7] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit8] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit9] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Submit10] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[LastDate] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Conf_User] (
	[CompanyID] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[FactCode] [varchar] (10) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[CompanyName] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ShortName] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ChiefName] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[RegisterNo] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ZipCode] [varchar] (7) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Address1] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Address2] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TradeStatus] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TradeItem] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TelNumber1] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[TelNumber2] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[FaxNumber] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[LocalNumber] [varchar] (5) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[LastDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (200) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[DataUpdated] (
	[TableName] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[UpdateTime] [datetime] NOT NULL ,
	[Remark] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Section_Group] (
	[SectionCode] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[SectionName] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ValueList] [varchar] (200) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DisplayOrder] [int] NOT NULL ,
	[CanModify] [varchar] (2) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [ebizTruck].[dbo].[Section_Item] (
	[SectionCode] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ItemCode] [varchar] (20) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[ItemName] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DefaultSelection] [varchar] (5) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[DisplayOrder] [int] NOT NULL ,
	[Value1] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Value2] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[Value3] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
	[AppendDate] [smalldatetime] NOT NULL ,
	[EditDate] [smalldatetime] NOT NULL ,
	[Remark] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [ebizTruck].[dbo].[Car] WITH NOCHECK ADD 
	CONSTRAINT [PK_Car] PRIMARY KEY  CLUSTERED 
	(
		[CarNo]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[CarAdjust] WITH NOCHECK ADD 
	CONSTRAINT [PK_CarAdjust] PRIMARY KEY  CLUSTERED 
	(
		[AdjustDate],
		[AdjustTime],
		[CarNo]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[CarTagLog] WITH NOCHECK ADD 
	CONSTRAINT [PK_CarTagLog] PRIMARY KEY  CLUSTERED 
	(
		[TagDate],
		[TagTime],
		[IDCardNo]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[CarWork] WITH NOCHECK ADD 
	CONSTRAINT [PK_CarWork] PRIMARY KEY  CLUSTERED 
	(
		[PlanDate],
		[CarNo]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_Config] WITH NOCHECK ADD 
	CONSTRAINT [PK_ConfConfig] PRIMARY KEY  CLUSTERED 
	(
		[SectionKey],
		[ItemKey],
		[UserID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_ConnDB] WITH NOCHECK ADD 
	CONSTRAINT [PK_Conf_ConnDB] PRIMARY KEY  CLUSTERED 
	(
		[ConnName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_Printer] WITH NOCHECK ADD 
	CONSTRAINT [PK_Conf_Printer] PRIMARY KEY  CLUSTERED 
	(
		[ReportCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_Report] WITH NOCHECK ADD 
	CONSTRAINT [PK_Conf_Report] PRIMARY KEY  CLUSTERED 
	(
		[ReportCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_User] WITH NOCHECK ADD 
	CONSTRAINT [PK_Conf_User] PRIMARY KEY  CLUSTERED 
	(
		[CompanyID],
		[FactCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[DataUpdated] WITH NOCHECK ADD 
	CONSTRAINT [PK_DataUpdated] PRIMARY KEY  CLUSTERED 
	(
		[TableName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Section_Group] WITH NOCHECK ADD 
	CONSTRAINT [PK_Section_Group] PRIMARY KEY  CLUSTERED 
	(
		[SectionCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Section_Item] WITH NOCHECK ADD 
	CONSTRAINT [PK_Section_Item] PRIMARY KEY  CLUSTERED 
	(
		[SectionCode],
		[ItemCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [ebizTruck].[dbo].[Car] ADD 
	CONSTRAINT [DF_Car_CarNo] DEFAULT ('') FOR [CarNo],
	CONSTRAINT [DF_Car_CarNumber] DEFAULT ('') FOR [CarNumber],
	CONSTRAINT [DF_Car_DriverCode] DEFAULT ('') FOR [DriverCode],
	CONSTRAINT [DF_Car_DriverName] DEFAULT ('') FOR [DriverName],
	CONSTRAINT [DF_Car_TelNumber1] DEFAULT ('') FOR [TelNumber1],
	CONSTRAINT [DF_Car_TelNumber2] DEFAULT ('') FOR [TelNumber2],
	CONSTRAINT [DF_Car_MachineNumber] DEFAULT ('') FOR [MachineNumber],
	CONSTRAINT [DF_Car_ProductDate] DEFAULT ('') FOR [ProductDate],
	CONSTRAINT [DF_Car_OwnerType] DEFAULT ('') FOR [OwnerType],
	CONSTRAINT [DF_Car_Capacity] DEFAULT (0) FOR [Capacity],
	CONSTRAINT [DF_Car_TransportPrice] DEFAULT (0) FOR [TransportPrice],
	CONSTRAINT [DF_Car_IDCardNo] DEFAULT ('') FOR [IDCardNo],
	CONSTRAINT [DF_Car_GroupID] DEFAULT (0) FOR [GroupID],
	CONSTRAINT [DF_Car_CarIndex] DEFAULT (0) FOR [CarIndex],
	CONSTRAINT [DF_Car_PriorOrder] DEFAULT (0) FOR [PriorOrder],
	CONSTRAINT [DF_Car_PriorTime] DEFAULT ('') FOR [PriorTime],
	CONSTRAINT [DF_Car_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Car_EditDate] DEFAULT (getdate()) FOR [EditDate],
	CONSTRAINT [DF_Car_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[CarAdjust] ADD 
	CONSTRAINT [DF_CarAdjust_AdjustDate] DEFAULT ('') FOR [AdjustDate],
	CONSTRAINT [DF_CarAdjust_AdjustTime] DEFAULT ('') FOR [AdjustTime],
	CONSTRAINT [DF_CarAdjust_CarNo] DEFAULT ('') FOR [CarNo],
	CONSTRAINT [DF_CarAdjust_AdjustType] DEFAULT ('') FOR [AdjustType],
	CONSTRAINT [DF_CarAdjust_AdjustCount] DEFAULT (0) FOR [AdjustCount],
	CONSTRAINT [DF_CarAdjust_EditType] DEFAULT ('') FOR [EditType],
	CONSTRAINT [DF_CarAdjust_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_CarAdjust_EditDate] DEFAULT (getdate()) FOR [EditDate],
	CONSTRAINT [DF_CarAdjust_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[CarTagLog] ADD 
	CONSTRAINT [DF_CarTagLog_TagDate] DEFAULT ('') FOR [TagDate],
	CONSTRAINT [DF_CarTagLog_TagTime] DEFAULT ('') FOR [TagTime],
	CONSTRAINT [DF_CarTagLog_IDCardNo] DEFAULT ('') FOR [IDCardNo],
	CONSTRAINT [DF_CarTagLog_CarNo] DEFAULT ('') FOR [CarNo],
	CONSTRAINT [DF_CarTagLog_DriverName] DEFAULT ('') FOR [DriverName],
	CONSTRAINT [DF_CarTagLog_CarStatus] DEFAULT ('') FOR [CarStatus],
	CONSTRAINT [DF_CarTagLog_PlanDate] DEFAULT ('') FOR [PlanDate],
	CONSTRAINT [DF_CarTagLog_PlanNo] DEFAULT (0) FOR [PlanNo],
	CONSTRAINT [DF_CarTagLog_InvoiceNo] DEFAULT (0) FOR [InvoiceNo],
	CONSTRAINT [DF_CarTagLog_InvoiceTime] DEFAULT ('') FOR [InvoiceTime],
	CONSTRAINT [DF_CarTagLog_AfterWork] DEFAULT ('') FOR [AfterWork],
	CONSTRAINT [DF_CarTagLog_StandbyMinute] DEFAULT (0) FOR [StandbyMinute],
	CONSTRAINT [DF_CarTagLog_WorkMinute] DEFAULT (0) FOR [WorkMinute]
GO

ALTER TABLE [ebizTruck].[dbo].[CarWork] ADD 
	CONSTRAINT [DF_CarWork_PlanDate] DEFAULT ('') FOR [PlanDate],
	CONSTRAINT [DF_CarWork_CarNo] DEFAULT ('') FOR [CarNo],
	CONSTRAINT [DF_CarWork_DriverName] DEFAULT ('') FOR [DriverName],
	CONSTRAINT [DF_CarWork_FirstTime] DEFAULT ('') FOR [FirstTime],
	CONSTRAINT [DF_CarWork_CarStatus] DEFAULT ('') FOR [CarStatus],
	CONSTRAINT [DF_CarWork_StandbyOrder] DEFAULT (0) FOR [StandbyOrder],
	CONSTRAINT [DF_CarWork_TagTime] DEFAULT ('') FOR [TagTime],
	CONSTRAINT [DF_CarWork_InvoiceTime] DEFAULT ('') FOR [InvoiceTime],
	CONSTRAINT [DF_CarWork_DayTotal] DEFAULT (0) FOR [DayTotal],
	CONSTRAINT [DF_CarWork_DayReal] DEFAULT (0) FOR [DayReal],
	CONSTRAINT [DF_CarWork_DayAdjust] DEFAULT (0) FOR [DayAdjust],
	CONSTRAINT [DF_CarWork_AfterCount] DEFAULT (0) FOR [AfterCount],
	CONSTRAINT [DF_CarWork_MonthTotal] DEFAULT (0) FOR [MonthTotal],
	CONSTRAINT [DF_CarWork_YearTotal] DEFAULT (0) FOR [YearTotal],
	CONSTRAINT [DF_CarWork_GroupID] DEFAULT (0) FOR [GroupID],
	CONSTRAINT [DF_CarWork_PriorOrder] DEFAULT (0) FOR [PriorOrder],
	CONSTRAINT [DF_CarWork_PriorTime] DEFAULT ('') FOR [PriorTime],
	CONSTRAINT [DF_CarWork_MonthReal] DEFAULT (0) FOR [MonthReal],
	CONSTRAINT [DF_CarWork_MonthAdjust] DEFAULT (0) FOR [MonthAdjust],
	CONSTRAINT [DF_CarWork_YearReal] DEFAULT (0) FOR [YearReal],
	CONSTRAINT [DF_CarWork_YearAdjust] DEFAULT (0) FOR [YearAdjust]
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_Config] ADD 
	CONSTRAINT [DF_ConfConfig_SectionKey] DEFAULT ('') FOR [SectionKey],
	CONSTRAINT [DF_ConfConfig_ItemKey] DEFAULT ('') FOR [ItemKey],
	CONSTRAINT [DF_ConfConfig_UserID] DEFAULT ('') FOR [UserID],
	CONSTRAINT [DF_ConfConfig_ItemValue] DEFAULT ('') FOR [ItemValue],
	CONSTRAINT [DF_ConfConfig_Unit] DEFAULT ('') FOR [Unit],
	CONSTRAINT [DF_ConfConfig_DisplayOrder] DEFAULT (0) FOR [DisplayOrder],
	CONSTRAINT [DF_ConfConfig_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_ConfConfig_EditDate] DEFAULT (getdate()) FOR [EditDate],
	CONSTRAINT [DF_ConfConfig_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_ConnDB] ADD 
	CONSTRAINT [DF_Conf_ConnDB_ConnName] DEFAULT ('') FOR [ConnName],
	CONSTRAINT [DF_Conf_ConnDB_UseConnection] DEFAULT ('') FOR [UseConnection],
	CONSTRAINT [DF_Conf_ConnDB_dbType] DEFAULT ('') FOR [dbType],
	CONSTRAINT [DF_Conf_ConnDB_Host] DEFAULT ('') FOR [Host],
	CONSTRAINT [DF_Conf_ConnDB_dbName] DEFAULT ('') FOR [dbName],
	CONSTRAINT [DF_Conf_ConnDB_ID] DEFAULT ('') FOR [ID],
	CONSTRAINT [DF_Conf_ConnDB_PWD] DEFAULT ('') FOR [PWD],
	CONSTRAINT [DF_Conf_ConnDB_*ShareName] DEFAULT ('') FOR [*ShareName],
	CONSTRAINT [DF_Conf_ConnDB_ShareID] DEFAULT ('') FOR [ShareID],
	CONSTRAINT [DF_Conf_ConnDB_SharePWD] DEFAULT ('') FOR [SharePWD],
	CONSTRAINT [DF_Conf_ConnDB_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Conf_ConnDB_EditDate] DEFAULT (getdate()) FOR [EditDate],
	CONSTRAINT [DF_Conf_ConnDB_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_Printer] ADD 
	CONSTRAINT [DF_Conf_Printer_ReportCode] DEFAULT ('') FOR [ReportCode],
	CONSTRAINT [DF_Conf_Printer_PrinterType] DEFAULT ('') FOR [PrinterType],
	CONSTRAINT [DF_Conf_Printer_SystemUse] DEFAULT ('') FOR [SystemUse],
	CONSTRAINT [DF_Conf_Printer_DefaultUse] DEFAULT ('') FOR [DefaultUse],
	CONSTRAINT [DF_Conf_Printer_ReportName] DEFAULT ('') FOR [ReportName],
	CONSTRAINT [DF_Conf_Printer_PrinterName] DEFAULT ('') FOR [PrinterName],
	CONSTRAINT [DF_Conf_Printer_PrinterPort] DEFAULT ('') FOR [PrinterPort],
	CONSTRAINT [DF_Conf_Printer_PrinterDriver] DEFAULT ('') FOR [PrinterDriver],
	CONSTRAINT [DF_Conf_Printer_PaperSize] DEFAULT (0) FOR [PaperSize],
	CONSTRAINT [DF_Conf_Printer_TopMargin] DEFAULT (0) FOR [TopMargin],
	CONSTRAINT [DF_Conf_Printer_LeftMargin] DEFAULT (0) FOR [LeftMargin],
	CONSTRAINT [DF_Conf_Printer_RightMargin] DEFAULT (0) FOR [RightMargin],
	CONSTRAINT [DF_Conf_Printer_BottomMargin] DEFAULT (0) FOR [BottomMargin],
	CONSTRAINT [DF_Conf_Printer_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Conf_Printer_LastDate] DEFAULT (getdate()) FOR [LastDate],
	CONSTRAINT [DF_Conf_Printer_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_Report] ADD 
	CONSTRAINT [DF_Conf_Report_ReportCode] DEFAULT ('') FOR [ReportCode],
	CONSTRAINT [DF_Conf_Report_ReportName] DEFAULT ('') FOR [ReportName],
	CONSTRAINT [DF_Conf_Report_SubmitCount] DEFAULT (0) FOR [SubmitCount],
	CONSTRAINT [DF_Conf_Report_Submit1] DEFAULT ('') FOR [Submit1],
	CONSTRAINT [DF_Conf_Report_Submit2] DEFAULT ('') FOR [Submit2],
	CONSTRAINT [DF_Conf_Report_Submit3] DEFAULT ('') FOR [Submit3],
	CONSTRAINT [DF_Conf_Report_Submit4] DEFAULT ('') FOR [Submit4],
	CONSTRAINT [DF_Conf_Report_Submit5] DEFAULT ('') FOR [Submit5],
	CONSTRAINT [DF_Conf_Report_Submit6] DEFAULT ('') FOR [Submit6],
	CONSTRAINT [DF_Conf_Report_Submit7] DEFAULT ('') FOR [Submit7],
	CONSTRAINT [DF_Conf_Report_Submit8] DEFAULT ('') FOR [Submit8],
	CONSTRAINT [DF_Conf_Report_Submit9] DEFAULT ('') FOR [Submit9],
	CONSTRAINT [DF_Conf_Report_Submit10] DEFAULT ('') FOR [Submit10],
	CONSTRAINT [DF_Conf_Report_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Conf_Report_LastDate] DEFAULT (getdate()) FOR [LastDate]
GO

ALTER TABLE [ebizTruck].[dbo].[Conf_User] ADD 
	CONSTRAINT [DF_Conf_User_CompanyID] DEFAULT ('') FOR [CompanyID],
	CONSTRAINT [DF_Conf_User_FactCode] DEFAULT ('') FOR [FactCode],
	CONSTRAINT [DF_Conf_User_CompanyName] DEFAULT ('') FOR [CompanyName],
	CONSTRAINT [DF_Conf_User_ShortName] DEFAULT ('') FOR [ShortName],
	CONSTRAINT [DF_Conf_User_ChiefName] DEFAULT ('') FOR [ChiefName],
	CONSTRAINT [DF_Conf_User_RegisterNo] DEFAULT ('') FOR [RegisterNo],
	CONSTRAINT [DF_Conf_User_ZipCode] DEFAULT ('') FOR [ZipCode],
	CONSTRAINT [DF_Conf_User_Address1] DEFAULT ('') FOR [Address1],
	CONSTRAINT [DF_Conf_User_Address2] DEFAULT ('') FOR [Address2],
	CONSTRAINT [DF_Conf_User_TradeStatus] DEFAULT ('') FOR [TradeStatus],
	CONSTRAINT [DF_Conf_User_TradeItem] DEFAULT ('') FOR [TradeItem],
	CONSTRAINT [DF_Conf_User_TelNumber1] DEFAULT ('') FOR [TelNumber1],
	CONSTRAINT [DF_Conf_User_TelNumber2] DEFAULT ('') FOR [TelNumber2],
	CONSTRAINT [DF_Conf_User_FaxNumber] DEFAULT ('') FOR [FaxNumber],
	CONSTRAINT [DF_Conf_User_LocalNumber] DEFAULT ('') FOR [LocalNumber],
	CONSTRAINT [DF_Conf_User_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Conf_User_LastDate] DEFAULT (getdate()) FOR [LastDate],
	CONSTRAINT [DF_Conf_User_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[DataUpdated] ADD 
	CONSTRAINT [DF_DataUpdated_TableName] DEFAULT ('') FOR [TableName],
	CONSTRAINT [DF_DataUpdated_UpdateTime] DEFAULT (getdate()) FOR [UpdateTime],
	CONSTRAINT [DF_DataUpdated_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[Section_Group] ADD 
	CONSTRAINT [DF_Section_Group_SectionCode] DEFAULT ('') FOR [SectionCode],
	CONSTRAINT [DF_Section_Group_SectionName] DEFAULT ('') FOR [SectionName],
	CONSTRAINT [DF_Section_Group_ValueList] DEFAULT ('') FOR [ValueList],
	CONSTRAINT [DF_Section_Group_DisplayOrder] DEFAULT (0) FOR [DisplayOrder],
	CONSTRAINT [DF_Section_Group_CanModify] DEFAULT ('') FOR [CanModify],
	CONSTRAINT [DF_Section_Group_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Section_Group_EditDate] DEFAULT (getdate()) FOR [EditDate],
	CONSTRAINT [DF_Section_Group_Remark] DEFAULT ('') FOR [Remark]
GO

ALTER TABLE [ebizTruck].[dbo].[Section_Item] ADD 
	CONSTRAINT [DF_Section_Item_SectionCode] DEFAULT ('') FOR [SectionCode],
	CONSTRAINT [DF_Section_Item_ItemCode] DEFAULT ('') FOR [ItemCode],
	CONSTRAINT [DF_Section_Item_ItemName] DEFAULT ('') FOR [ItemName],
	CONSTRAINT [DF_Section_Item_DefaultSelection] DEFAULT ('') FOR [DefaultSelection],
	CONSTRAINT [DF_Section_Item_DisplayOrder] DEFAULT (0) FOR [DisplayOrder],
	CONSTRAINT [DF_Section_Item_Value1] DEFAULT ('') FOR [Value1],
	CONSTRAINT [DF_Section_Item_Value2] DEFAULT ('') FOR [Value2],
	CONSTRAINT [DF_Section_Item_Value3] DEFAULT ('') FOR [Value3],
	CONSTRAINT [DF_Section_Item_AppendDate] DEFAULT (getdate()) FOR [AppendDate],
	CONSTRAINT [DF_Section_Item_EditDate] DEFAULT (getdate()) FOR [EditDate],
	CONSTRAINT [DF_Section_Item_Remark] DEFAULT ('') FOR [Remark]
GO

