VERSION GECISLI KURULUM ICIN BILGISAYARDA BULUNAN VERSIONDAN SONRAKI BUTUN VERSIONLAR FTPDEN INDIRILIR SONRA BIR SONRAKI VERSION LOGO KLASORUNU ATILIR LBSLOADI VARSA ODA ATILIR VE LOGO CALISTIRILIR MOBILESALES GENEL TANIMLARA GIRILIR VERSION GECISI YAPILSIN EKRANI ACILIR BASLAT DENILIR. SONRA LOGO KAPATILIR VE BIR SONRAKI VERSIONDAN AYNI SEKILDE DEVAM EDILIR SON VERSIONA KADAR.
ILK KURULUM : KURMA ISLEMINDEN ONCE LOGO VERITABANINDA ASAGIDAKI SORGULAR CALISTIRILIR
USE [VERITABANIADI]
GO
/****** Object: Table [dbo].[WOR_ANDDEVICE] Script Date: 14.02.2020 13:02:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CABIN](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[TYPE] [int] NOT NULL,
[BRAND] [nvarchar](50) NULL,
[MODEL] [nvarchar](50) NULL,
[BARCODE] [nvarchar](70) NOT NULL,
[LOCINFO] [int] NOT NULL,
[STATUS] [int] NOT NULL,
[CLIENTCODE] [nvarchar](50) NULL,
[SALESMANREF] [int] NULL,
[MODIFIEDDATE] [datetime] NULL,
[CREATEDDATE] [datetime] NOT NULL,
[FIRM] [nvarchar](30) NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
---------------------------------------
GO
/****** Object: Table [dbo].[WOR_CABINTRANS] Script Date: 24.10.2019 14:18:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CABINTRANS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CABINID] [int] NOT NULL,
[TRTYPE] [int] NOT NULL,
[TRFICHENO] [nvarchar](50) NULL,
[TRFICHEREF] [int] NULL,
[CLIENTCODE] [nvarchar](50) NULL,
[CLIENTREF] [int] NULL,
[DATE] [datetime] NULL,
[SALESMANREF] [int] NULL,
[TRCODE] [int] NULL,
[FIRM] [nvarchar](30) NULL,
[PERIOD] [nvarchar](30) NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
------------------------------------------------
GO
/****** Object: Table [dbo].[WOR_CABINTYPE] Script Date: 24.10.2019 14:18:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CABINTYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CABINTYPE] [nvarchar](30) NOT NULL,
[ITEMGROUP1] [nvarchar](30) NULL,
[ITEMGROUP2] [nvarchar](30) NULL,
[ITEMGROUP3] [nvarchar](30) NULL,
[ITEMGROUP4] [nvarchar](30) NULL,
[ITEMGROUP5] [nvarchar](30) NULL,
[CREATEDDATE] [datetime] NOT NULL,
[STATUS] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ANDDEVICE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DEVICESERINO1] [nvarchar](50) NOT NULL,
[DEVICESERINO2] [nvarchar](50) NOT NULL,
[DEVICESERINO3] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_ANDDEVICE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ANDTRANSLOG] Script Date: 14.02.2020 13:02:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ANDTRANSLOG](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[DATASTR] [ntext] NOT NULL,
[ANDFICHENO] [varchar](50) NOT NULL,
[FICHENO] [varchar](50) NOT NULL,
[FICHETYPE] [int] NOT NULL,
CONSTRAINT [PK_WOR_ANDTRANSLOG] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASE] Script Date: 14.02.2020 13:02:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CTYPEID] [int] NOT NULL,
[CUSTOMERID] [int] NOT NULL,
[SERINO] [nvarchar](50) NOT NULL,
[SHIPREF] [int] NOT NULL,
[STATUS] [int] NOT NULL,
[WAREHOUSE] [int] NOT NULL,
[USERID] [int] NOT NULL,
[TEDKABULDATE] [datetime] NOT NULL,
[TEDIADEDATE] [datetime] NOT NULL,
[MUSCIKISDATE] [datetime] NOT NULL,
[MUSIADEDATE] [datetime] NOT NULL,
[KAYIPDATE] [datetime] NOT NULL,
[LASTREADDATE] [datetime] NOT NULL,
[SPECID] [int] NOT NULL,
[MODEL] [varchar](50) NOT NULL,
[REASONID] [int] NOT NULL,
[PRODUCERSERINO] [varchar](50) NOT NULL,
CONSTRAINT [PK_WOR_CASE_1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASELOG] Script Date: 14.02.2020 13:02:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASELOG](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[SERINO] [nvarchar](50) NOT NULL,
[FCUSTOMERID] [int] NOT NULL,
[SCUSTOMERID] [int] NOT NULL,
[DESC_] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_CASELOG] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASEREASON] Script Date: 14.02.2020 13:02:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASEREASON](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[DESC_] [nvarchar](200) NOT NULL,
CONSTRAINT [PK_WOR_CASEREASONS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASESPEC] Script Date: 14.02.2020 13:02:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASESPEC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[SPEC] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_CASESPEC] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CASETYPE] Script Date: 14.02.2020 13:02:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CASETYPE](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ITEMID] [int] NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[NAME] [nvarchar](100) NOT NULL,
[SPECODE] [nvarchar](50) NOT NULL,
[MARK] [nvarchar](50) NOT NULL,
[MODEL] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_CASE] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CLCARDINFO] Script Date: 14.02.2020 13:02:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CLCARDINFO](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CLIENTREF] [int] NOT NULL,
[CLCODE] [nvarchar](100) NOT NULL,
[CLNAME] [nvarchar](100) NOT NULL,
[PHOTO] [image] NOT NULL,
CONSTRAINT [PK_WOR_CLCARDINFO] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_COLORS] Script Date: 14.02.2020 13:02:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_COLORS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CTYPE] [int] NOT NULL,
[COLOR] [nvarchar](50) NOT NULL,
[DESC_] [nvarchar](100) NOT NULL,
CONSTRAINT [PK_WOR_COLORS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CUSTGPSDATA] Script Date: 14.02.2020 13:02:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CUSTGPSDATA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CLIENTCODE] [nvarchar](50) NOT NULL,
[USERID] [int] NOT NULL,
[LATITUDE] [nvarchar](50) NOT NULL,
[LONGITUDE] [nvarchar](50) NOT NULL,
[HDOP] [nvarchar](50) NOT NULL,
[SHIPADDRCODE] [varchar](50) NOT NULL,
[DATE_] [datetime] NOT NULL,
[SHIPADDRID] [int] NOT NULL,
CONSTRAINT [PK_WOR_CUSTGPSDATA] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_CUSTGPSLOC] Script Date: 14.02.2020 13:02:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_CUSTGPSLOC](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CLIENTREF] [int] NOT NULL,
[LATITUDE] [nvarchar](100) NOT NULL,
[LONGTITUDE] [nvarchar](100) NOT NULL,
[CLCODE] [varchar](100) NOT NULL,
[CLNAME] [varchar](100) NOT NULL,
CONSTRAINT [PK_WOR_CUSTOMERGPSLOCATION] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DEFORDER] Script Date: 14.02.2020 13:02:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DEFORDER](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[LINENO_] [int] NOT NULL,
[DEFINITION_] [nvarchar](30) NOT NULL,
[SPECODE] [nvarchar](11) NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[SLSMANREF] [int] NOT NULL,
[ISSHOWSTOC] [int] NOT NULL,
[WHOUSE] [int] NOT NULL,
[STYPE] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[WRKTYPE] [int] NOT NULL,
[FORMGROUP] [nvarchar](50) NOT NULL,
[USEPENETRATION] [int] NOT NULL,
[PTYPE] [int] NOT NULL,
[ENTPRICE] [int] NOT NULL,
[PRODUCTCLASSREF] [int] NOT NULL,
[MINSTOCK] [varchar](50) NOT NULL,
[USEMINSTOCK] [int] NOT NULL,
[FIRMNR] [varchar](50) NOT NULL,
[DONEMNR] [varchar](50) NOT NULL,
[CREATEDDATE] [datetime] NULL,
[MODIFIEDDATE] [datetime] NULL,
[INNERSQL] [nvarchar](max) NOT NULL,
CONSTRAINT [PK_WOR_DEFORDER] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DEFORDERDETAIL] Script Date: 14.02.2020 13:02:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DEFORDERDETAIL](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[DEFORDERID] [int] NOT NULL,
[GROUP_] [nvarchar](20) NOT NULL,
[PRODUCTID] [int] NOT NULL,
[PCODE] [nvarchar](25) NOT NULL,
[MCODE] [nvarchar](50) NOT NULL,
[PNAME] [nvarchar](51) NOT NULL,
[MINAMOUNT] [nvarchar](53) NOT NULL,
[MAXAMOUNT] [nvarchar](53) NOT NULL,
[ISSLCTUNIT] [int] NOT NULL,
[UNIT] [int] NOT NULL,
[ISSHOWSTOCK] [int] NOT NULL,
[LINENO_] [int] NOT NULL,
[COLORID] [int] NOT NULL,
[UNITREF] [int] NOT NULL,
[LINETYPE] [int] NOT NULL,
CONSTRAINT [PK_DEFORDERDETAIL] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DELETEDRECS] Script Date: 14.02.2020 13:02:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DELETEDRECS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FIRMNR] [smallint] NOT NULL,
[PERIODNR] [smallint] NOT NULL,
[RECTYPE] [smallint] NOT NULL,
[LOGICALREF] [int] NOT NULL,
[DELETEDDATE] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DESIGNS] Script Date: 14.02.2020 13:02:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DESIGNS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[FILENAME] [nvarchar](50) NOT NULL,
[TYPE] [int] NOT NULL,
[SECTORTYPE] [int] NOT NULL,
[SECTORNR] [int] NOT NULL,
[VALUE] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_DESIGNS] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_DESIGNSETTINGS] Script Date: 14.02.2020 13:02:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_DESIGNSETTINGS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[FILENAME] [nvarchar](50) NOT NULL,
[STARTY] [int] NOT NULL,
[DETAILCOUNT] [int] NOT NULL,
[TITLEHEIGHT] [int] NOT NULL,
[DETAILHEIGHT] [int] NOT NULL,
[PAGEENDHEIGHT] [int] NOT NULL,
[PRINTINGENDHEIGHT] [int] NOT NULL,
CONSTRAINT [PK_WOR_DESIGNSETTINGS] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_EMAILFORMS] Script Date: 14.02.2020 13:02:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_EMAILFORMS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FORMNAME] [nvarchar](100) NOT NULL,
[FORMTYPE] [int] NOT NULL,
[FORMCONTENT] [nvarchar](max) NOT NULL,
[FORMCONFIG] [nvarchar](max) NULL,
CONSTRAINT [PK_WOR_EMAILFORMS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_GPSDATA] Script Date: 14.02.2020 13:02:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_GPSDATA](
[GPSDATAID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[LATITUDE] [nvarchar](30) NOT NULL,
[LONGTITUDE] [nvarchar](30) NOT NULL,
[SPEED] [float] NOT NULL,
[DISTANCE] [float] NOT NULL,
[TIMESPAN] [float] NOT NULL,
CONSTRAINT [PK_WOR_GPSDATA] PRIMARY KEY CLUSTERED
(
[GPSDATAID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_MARKETINGMESSAGE] Script Date: 14.02.2020 13:02:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_MARKETINGMESSAGE](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[DEFINITION_] [nvarchar](50) NOT NULL,
[BEGDATE] [datetime] NOT NULL,
[ENDDATE] [datetime] NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[TYPE] [int] NOT NULL,
[NOTE] [ntext] NOT NULL,
CONSTRAINT [PK_WOR_MARKETINGMESSAGE] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_MESSAGE] Script Date: 14.02.2020 13:02:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_MESSAGE](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[SENDER] [int] NOT NULL,
[RECIPIENT] [int] NOT NULL,
[NOTE] [nvarchar](501) NOT NULL,
[ISREAD] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
CONSTRAINT [PK_WOR_MESSAGE] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PARAMETER] Script Date: 14.02.2020 13:02:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PARAMETER](
[Id] [int] NOT NULL,
[No] [nvarchar](1024) NOT NULL,
[Name] [nvarchar](1024) NOT NULL,
[CategoryId] [int] NOT NULL,
[CategoryName] [nvarchar](1024) NOT NULL,
CONSTRAINT [PK_WOR_PARAMETER] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PARAMROLE] Script Date: 14.02.2020 13:02:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PARAMROLE](
[RoleId] [int] NOT NULL,
[ParameterId] [int] NOT NULL,
[Value] [nvarchar](max) NULL,
CONSTRAINT [PK_WOR_PARAMROLE] PRIMARY KEY CLUSTERED
(
[RoleId] ASC,
[ParameterId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PARAMUSER] Script Date: 14.02.2020 13:02:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PARAMUSER](
[UserId] [int] NOT NULL,
[ParameterId] [int] NOT NULL,
[Value] [nvarchar](max) NULL,
[IsModified] [int] NOT NULL,
CONSTRAINT [PK_WOR_PARAMUSER] PRIMARY KEY CLUSTERED
(
[UserId] ASC,
[ParameterId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PENETRATION] Script Date: 14.02.2020 13:02:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PENETRATION](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[LINENO_] [int] NOT NULL,
[DEFINITION_] [nvarchar](30) NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[STYPE] [int] NOT NULL,
[PNTGROUP] [nvarchar](50) NOT NULL,
[PTYPE] [int] NOT NULL,
[ENTPRICE] [int] NOT NULL,
[COLRIGHT] [varchar](100) NOT NULL,
[DEFFIELD1] [varchar](100) NOT NULL,
[DEFFIELD2] [varchar](100) NOT NULL,
[DEFFIELD3] [varchar](100) NOT NULL,
[DEFFIELD4] [varchar](100) NOT NULL,
[DEFFIELD5] [varchar](100) NOT NULL,
[DEFFIELD6] [varchar](100) NOT NULL,
[DEFFIELD7] [varchar](100) NOT NULL,
[DEFFIELD8] [varchar](100) NOT NULL,
[DEFFIELD9] [varchar](100) NOT NULL,
[DEFFIELD10] [varchar](100) NOT NULL,
CONSTRAINT [PK_WOR_PENETRATION] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PENETRATIONDETAIL] Script Date: 14.02.2020 13:02:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PENETRATIONDETAIL](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[PNTID] [int] NOT NULL,
[PRTYPE] [nvarchar](50) NOT NULL,
[PRODUCTID] [int] NOT NULL,
[PCODE] [nvarchar](25) NOT NULL,
[PNAME] [nvarchar](51) NOT NULL,
[BARCODE] [nvarchar](30) NOT NULL,
[UNIT] [nvarchar](30) NOT NULL,
[LINENO_] [int] NOT NULL,
[PRTYPEINT] [int] NOT NULL,
CONSTRAINT [PK_WOR_PENETRATIONDETAIL] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PRINTDESIGNER] Script Date: 14.02.2020 13:02:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PRINTDESIGNER](
[ID] [int] IDENTITY(1,1) NOT NULL,
[NAME] [nvarchar](50) NULL,
[DESIGN] [nvarchar](max) NULL,
[REPORTTYPE] [nvarchar](50) NULL,
[FORMCONFIG] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PROCESS] Script Date: 14.02.2020 13:02:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PROCESS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DATE_] [datetime] NOT NULL,
[USERID] [int] NOT NULL,
[CLIENTREF] [int] NOT NULL,
[PTYPE] [int] NOT NULL,
[PREF] [int] NOT NULL,
[PDISTANCE] [float] NOT NULL,
[VREASON] [nvarchar](50) NOT NULL,
[VNOTE] [ntext] NOT NULL,
[ISPRINT] [int] NOT NULL,
[CLCODE] [varchar](60) NOT NULL,
[CLNAME] [varchar](120) NOT NULL,
[SHIPINFOREF] [int] NOT NULL,
[ENLEM] [varchar](50) NOT NULL,
[BOYLAM] [varchar](50) NOT NULL,
[FIRM] [int] NULL,
[USERTITLE] [int] NULL,
[VISITIMAGE] [varbinary](max) NULL,
[NTSSFICHENO] [varchar](max) NULL,
CONSTRAINT [PK_WOR_PROCESS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_PROGMENU] Script Date: 14.02.2020 13:02:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_PROGMENU](
[progmenuid] [int] IDENTITY(1,1) NOT NULL,
[mainmenu] [nvarchar](500) NULL,
[submenu1] [nvarchar](500) NULL,
[submenu2] [nvarchar](500) NULL,
[submenu3] [nvarchar](500) NULL,
[submenu4] [nvarchar](500) NULL,
[submenu5] [nvarchar](500) NULL,
[fno] [nvarchar](500) NULL,
[parentfno] [nvarchar](500) NULL,
[lineno_] [int] NULL,
[level_] [int] NULL,
[visible] [int] NULL,
[lang] [int] NULL,
[picturename] [nvarchar](500) NULL,
[url] [nvarchar](500) NULL,
[modul] [nvarchar](500) NULL,
CONSTRAINT [PK_WOR_PROGMENU] PRIMARY KEY CLUSTERED
(
[progmenuid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_QUOTA] Script Date: 14.02.2020 13:02:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_QUOTA](
[QUOTAID] [int] IDENTITY(1,1) NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[DESC_] [nvarchar](200) NOT NULL,
[GROUPCODE] [nvarchar](750) NOT NULL,
[BEGDATE] [datetime] NOT NULL,
[ENDDATE] [datetime] NOT NULL,
[AMOUNT] [float] NOT NULL,
[PTYPE] [int] NOT NULL,
[ALERTTYPE] [int] NOT NULL,
CONSTRAINT [PK_WOR_QUOTA] PRIMARY KEY CLUSTERED
(
[QUOTAID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_QUOTADETAIL] Script Date: 14.02.2020 13:02:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_QUOTADETAIL](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QUOTAID] [int] NOT NULL,
[CODE] [varchar](50) NOT NULL,
CONSTRAINT [PK_WOR_QUOTADETAIL] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_REPORTS] Script Date: 14.02.2020 13:02:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_REPORTS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[REPINDEX] [int] NOT NULL,
[REPORTNAME] [nvarchar](50) NOT NULL,
[REPORTPATH] [nvarchar](500) NOT NULL,
[RTYPE] [int] NOT NULL,
[REPORTCONTENT] [varchar](max) NOT NULL,
CONSTRAINT [PK_WOR_REPORTS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTE] Script Date: 14.02.2020 13:02:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTE](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[ROUTECODE] [nvarchar](20) NULL,
[ROUTEDEFINITION] [nvarchar](50) NULL,
[USERID] [int] NULL,
[CREATEDDATE] [date] NULL,
[PERIODSTARTDATE] [date] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTEDAY] Script Date: 14.02.2020 13:03:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTEDAY](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[ROUTEID] [int] NULL,
[DAY] [int] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTEPLAN] Script Date: 14.02.2020 13:03:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTEPLAN](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[ROUTEID] [int] NULL,
[CLIENTREF] [nvarchar](50) NULL,
[SHIPMENTREF] [nvarchar](50) NULL,
[SEQUENCE] [int] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_ROUTEPROCESS] Script Date: 14.02.2020 13:03:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_ROUTEPROCESS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERCUSTOMERID] [int] NULL,
[ROUTEPLANID] [int] NULL,
[ROUTEDAYID] [int] NULL,
[CREATEDDATE] [date] NULL,
[PROCESSREF] [nvarchar](50) NULL,
[FICHENO] [nvarchar](50) NULL,
[PROCESSTYPE] [int] NULL,
[CLIENTREF] [nvarchar](50) NULL,
[FIRM] [nvarchar](10) NULL,
[PSEQUENCE] [int] NULL,
[SEQUENCE] [int] NULL,
[USERID] [int] NULL,
[PROCESSDATE] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SERIAL] Script Date: 14.02.2020 13:03:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SERIAL](
[WDATA] [nvarchar](4000) NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SETTINGS] Script Date: 14.02.2020 13:03:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SETTINGS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PNAME] [nvarchar](50) NOT NULL,
[PVALUE] [nvarchar](1000) NOT NULL,
CONSTRAINT [PK_WOR_SETTINGS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEY] Script Date: 14.02.2020 13:03:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEY](
[SURVEYID] [int] IDENTITY(1,1) NOT NULL,
[SDATE] [datetime] NOT NULL,
[DESC_] [nvarchar](100) NOT NULL,
[STATUS] [int] NOT NULL,
[FIELD1] [nvarchar](50) NULL,
[FIELD2] [nvarchar](50) NULL,
[FIELD3] [nvarchar](50) NULL,
[FIELD4] [nvarchar](50) NULL,
[FIELD5] [nvarchar](50) NULL,
[FIELD6] [nvarchar](50) NULL,
[FIELD7] [nvarchar](50) NULL,
[FIELD8] [nvarchar](50) NULL,
[FIELD9] [nvarchar](50) NULL,
[FIELD10] [nvarchar](50) NULL,
[USECASE] [int] NOT NULL,
[MUSTDO] [int] NOT NULL,
[PERIOD] [int] NOT NULL,
CONSTRAINT [PK_WOR_SURVEY] PRIMARY KEY CLUSTERED
(
[SURVEYID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYADETAIL] Script Date: 14.02.2020 13:03:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYADETAIL](
[SADETAILID] [int] IDENTITY(1,1) NOT NULL,
[SURVEYID] [int] NOT NULL,
[SQDETAILID] [int] NOT NULL,
[ANSWER] [nvarchar](100) NOT NULL,
[POINT] [int] NOT NULL,
CONSTRAINT [PK_WOR_SURVEYADETAIL] PRIMARY KEY CLUSTERED
(
[SADETAILID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYANSWERNEW] Script Date: 14.02.2020 13:03:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYANSWERNEW](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[SID] [int] NULL,
[QID] [int] NULL,
[SUBJECT] [nvarchar](250) NULL,
CONSTRAINT [PK_WOR_SURVEYANSWERNEW] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYNEW] Script Date: 14.02.2020 13:03:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYNEW](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[BEGDATE] [datetime] NULL,
[ENDDATE] [datetime] NULL,
[STATUS] [int] NULL,
[SUBJECT] [nvarchar](250) NULL,
[CHOICEPROD] [int] NULL,
[ENTERPRODAMOUNT] [int] NULL,
[DEFPRODAMOUNT] [float] NULL,
CONSTRAINT [PK_WOR_SURVEYNEW] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYQDETAIL] Script Date: 14.02.2020 13:03:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYQDETAIL](
[SQDETAILID] [int] IDENTITY(1,1) NOT NULL,
[SURVEYID] [int] NOT NULL,
[QTYPE] [int] NOT NULL,
[QUESTION] [nvarchar](150) NOT NULL,
CONSTRAINT [PK_WOR_SURVEYDATIL] PRIMARY KEY CLUSTERED
(
[SQDETAILID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_SURVEYQUESTIONSNEW] Script Date: 14.02.2020 13:03:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_SURVEYQUESTIONSNEW](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[SID] [int] NULL,
[SUBJECT] [nvarchar](250) NULL,
[TYPE] [int] NULL,
[DTYPE] [int] NULL,
[DEFVAL] [nvarchar](250) NULL,
[ISMUST] [int] NULL,
CONSTRAINT [PK_WOR_SURVEYQUESTIONSNEW] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_TODO] Script Date: 14.02.2020 13:03:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_TODO](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[TODOUSERID] [int] NOT NULL,
[DESC_] [nvarchar](50) NOT NULL,
[BEGDATE] [datetime] NOT NULL,
[ENDDATE] [datetime] NOT NULL,
[PRIORITY] [int] NOT NULL,
[SENDEMAIL] [int] NOT NULL,
[EMAILADDR] [nvarchar](50) NOT NULL,
[NOTE] [ntext] NOT NULL,
[USERID] [int] NOT NULL,
[CUSTOMERID] [int] NOT NULL,
[USERNOTE] [nvarchar](500) NOT NULL,
[STATUS] [int] NOT NULL,
[DEFINITIONTIME] [datetime] NOT NULL,
[READTIME] [datetime] NOT NULL,
[COMPLATETIME] [datetime] NOT NULL,
[SALESMUST] [int] NOT NULL,
CONSTRAINT [PK_WOR_TODO] PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_TRANSFERDATA] Script Date: 14.02.2020 13:03:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_TRANSFERDATA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[SESSIONID] [nvarchar](100) NOT NULL,
[DATE_] [datetime] NOT NULL,
[DATASTR] [ntext] NOT NULL,
CONSTRAINT [PK_WOR_TRANSFERDATA] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_UNITSET] Script Date: 14.02.2020 13:03:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_UNITSET](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UNITSETREF] [int] NOT NULL,
[UNITREF] [int] NOT NULL,
[UNITCODE] [nvarchar](50) NOT NULL,
[CHOICEUNIT] [int] NOT NULL,
[CONVERTUNIT] [int] NOT NULL,
[RATIO] [float] NOT NULL,
[MAINUNIT] [int] NOT NULL,
CONSTRAINT [PK_WOR_UNITSET] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERANSWER] Script Date: 14.02.2020 13:03:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERANSWER](
[USERANSWID] [int] IDENTITY(1,1) NOT NULL,
[SLSCODE] [nvarchar](50) NOT NULL,
[SURVEYID] [int] NOT NULL,
[SQDETAILID] [int] NOT NULL,
[SADETAILID] [int] NOT NULL,
[CLIENTREF] [int] NOT NULL,
[CLIENTCODE] [nvarchar](50) NOT NULL,
[CLIENTNAME] [nvarchar](100) NOT NULL,
[FIELD1] [nvarchar](50) NOT NULL,
[FIELD2] [nvarchar](50) NOT NULL,
[FIELD3] [nvarchar](50) NOT NULL,
[FIELD4] [nvarchar](50) NOT NULL,
[FIELD5] [nvarchar](50) NOT NULL,
[FIELD6] [nvarchar](50) NOT NULL,
[FIELD7] [nvarchar](50) NOT NULL,
[FIELD8] [nvarchar](50) NOT NULL,
[FIELD9] [nvarchar](50) NOT NULL,
[FIELD10] [nvarchar](50) NOT NULL,
[CASEID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
CONSTRAINT [PK_WOR_USERANSWER] PRIMARY KEY CLUSTERED
(
[USERANSWID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERANSWERNEW] Script Date: 14.02.2020 13:03:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERANSWERNEW](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NULL,
[SID] [int] NULL,
[QID] [int] NULL,
[PID] [int] NULL,
[CID] [int] NULL,
[DATE_] [datetime] NULL,
[SUBJECT] [nvarchar](4000) NULL,
[AMOUNT] [float] NULL,
[CLCODE] [nvarchar](250) NULL,
[CLNAME] [nvarchar](250) NULL,
[PCODE] [nvarchar](250) NULL,
[PNAME] [nvarchar](250) NULL,
[UNIQUEVAL] [nvarchar](50) NULL,
CONSTRAINT [PK_WOR_USERANSWERNEW] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERCUSTOMERS] Script Date: 14.02.2020 13:03:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERCUSTOMERS](
[LOGICALREF] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NULL,
[CLIENTREF] [nvarchar](50) NULL,
[SHIPMENTREF] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[LOGICALREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERFIRMS] Script Date: 14.02.2020 13:03:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERFIRMS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[FIRMNR] [nvarchar](10) NOT NULL,
[PERIODNR] [nvarchar](10) NOT NULL,
CONSTRAINT [PK_WOR_FIRMS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERMENU] Script Date: 14.02.2020 13:03:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERMENU](
[usersmenuid] [int] IDENTITY(1,1) NOT NULL,
[usersid] [int] NULL,
[level_] [int] NULL,
[fno] [nvarchar](500) NULL,
[parentfno] [nvarchar](500) NULL,
[visible] [int] NULL,
CONSTRAINT [PK_WOR_USERMENU] PRIMARY KEY CLUSTERED
(
[usersmenuid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERORDERS] Script Date: 14.02.2020 13:03:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERORDERS](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ORFICHEREF] [int] NOT NULL,
[SALESMANREF] [int] NOT NULL,
CONSTRAINT [PK_WOR_USERORDERS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERPENETRATION] Script Date: 14.02.2020 13:03:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERPENETRATION](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PNTID] [int] NOT NULL,
[PNTDETAILID] [int] NOT NULL,
[USERID] [int] NOT NULL,
[CLIENTID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[VY] [int] NOT NULL,
[AMOUNT] [float] NOT NULL,
[PRICE] [float] NOT NULL,
[CURRENCY] [nvarchar](10) NOT NULL,
[SOURCETYPE] [int] NOT NULL,
[DEFFIELD1] [varchar](100) NOT NULL,
[DEFFIELD2] [varchar](100) NOT NULL,
[DEFFIELD3] [varchar](100) NOT NULL,
[DEFFIELD4] [varchar](100) NOT NULL,
[DEFFIELD5] [varchar](100) NOT NULL,
[DEFFIELD6] [varchar](100) NOT NULL,
[DEFFIELD7] [varchar](100) NOT NULL,
[DEFFIELD8] [varchar](100) NOT NULL,
[DEFFIELD9] [varchar](100) NOT NULL,
[DEFFIELD10] [varchar](100) NOT NULL,
[PIMAGE] [varbinary](max) NULL,
CONSTRAINT [PK_WOR_USERPENETRATION] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERQUOTA] Script Date: 14.02.2020 13:03:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERQUOTA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[QUOTAID] [int] NOT NULL,
[AMOUNT] [float] NOT NULL,
CONSTRAINT [PK_WOR_USERQUOTA] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERROLE] Script Date: 14.02.2020 13:03:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERROLE](
[USERROLEID] [int] IDENTITY(1,1) NOT NULL,
[DESC_] [nvarchar](50) NULL,
CONSTRAINT [PK_WOR_USERROLE] PRIMARY KEY CLUSTERED
(
[USERROLEID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERROLERIGHT] Script Date: 14.02.2020 13:03:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERROLERIGHT](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERROLEID] [int] NOT NULL,
[PARAMNO] [nvarchar](50) NOT NULL,
[PARAMVALUE] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_USERROLERIGHT] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERS] Script Date: 14.02.2020 13:03:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERS](
[USERID] [int] IDENTITY(1,1) NOT NULL,
[USERNAME] [nvarchar](50) NOT NULL,
[PASSWORD] [nvarchar](50) NOT NULL,
[TYPE] [int] NOT NULL,
[CODE] [nvarchar](50) NOT NULL,
[NAME] [nvarchar](50) NOT NULL,
[GROUPCODE] [nvarchar](50) NOT NULL,
[FNAME] [nvarchar](50) NOT NULL,
[LNAME] [nvarchar](50) NOT NULL,
[EMAIL] [nvarchar](50) NOT NULL,
[WEB] [nvarchar](50) NOT NULL,
[SPECODE] [nvarchar](50) NOT NULL,
[ADMIN] [int] NOT NULL,
[LOGOVALUES] [nvarchar](50) NOT NULL,
[DOSHIP] [int] NOT NULL,
[LOGOUSER] [varchar](50) NOT NULL,
[LOGOPWD] [varchar](50) NOT NULL,
[WINUSERNAME] [varchar](50) NOT NULL,
[APPTYPE] [int] NOT NULL,
[USERROLEID] [int] NOT NULL,
[DISTVEHICLE] [nvarchar](50) NULL,
CONSTRAINT [PK_WOR_USERS] PRIMARY KEY CLUSTERED
(
[USERID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERSRIGHT] Script Date: 14.02.2020 13:03:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERSRIGHT](
[USERRIGHTID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[PARAMNO] [nvarchar](50) NOT NULL,
[PARAMVALUE] [nvarchar](4000) NULL,
CONSTRAINT [PK_WOR_USERRIGHT] PRIMARY KEY CLUSTERED
(
[USERRIGHTID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_USERSTARTINFO] Script Date: 14.02.2020 13:03:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_USERSTARTINFO](
[ID] [int] IDENTITY(1,1) NOT NULL,
[USERID] [int] NOT NULL,
[DATE_] [datetime] NOT NULL,
[PLAKA] [nvarchar](50) NOT NULL,
[STARTKM] [nvarchar](50) NOT NULL,
[ENDKM] [nvarchar](50) NOT NULL,
[NOTE] [nvarchar](500) NOT NULL,
CONSTRAINT [PK_WOR_USERSTARTINFO] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_VERSION] Script Date: 14.02.2020 13:03:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_VERSION](
[MAJOR] [nvarchar](50) NOT NULL,
[MINOR] [nvarchar](50) NOT NULL,
[BUILD] [nvarchar](50) NOT NULL,
[REVISION] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[WOR_VISITINFO] Script Date: 14.02.2020 13:03:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WOR_VISITINFO](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DESC_] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_WOR_VISITINFO] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_DEVICESERINO1] DEFAULT ('') FOR [DEVICESERINO1]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_DEVICESERINO2] DEFAULT ('') FOR [DEVICESERINO2]
GO
ALTER TABLE [dbo].[WOR_ANDDEVICE] ADD CONSTRAINT [DF_WOR_ANDDEVICE_DEVICESERINO3] DEFAULT ('') FOR [DEVICESERINO3]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD CONSTRAINT [DF_WOR_ANDTRANSLOG_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD CONSTRAINT [DF_WOR_ANDTRANSLOG_DATE_] DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD CONSTRAINT [DF_WOR_ANDTRANSLOG_DATASTR] DEFAULT ('') FOR [DATASTR]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD DEFAULT ('') FOR [ANDFICHENO]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD DEFAULT ('') FOR [FICHENO]
GO
ALTER TABLE [dbo].[WOR_ANDTRANSLOG] ADD DEFAULT ((0)) FOR [FICHETYPE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_CTYPEID] DEFAULT ((0)) FOR [CTYPEID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_CUSTOMERID] DEFAULT ((0)) FOR [CUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_SERINO] DEFAULT ('') FOR [SERINO]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_SHIPCODE] DEFAULT ((0)) FOR [SHIPREF]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_STATUS] DEFAULT ((0)) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_WAREHOUSE] DEFAULT ((0)) FOR [WAREHOUSE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_KABULDATE] DEFAULT ('01.01.1900') FOR [TEDKABULDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_TEDIADEDATE] DEFAULT ('01.01.1900') FOR [TEDIADEDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_MUSTERICIKIS] DEFAULT ('01.01.1900') FOR [MUSCIKISDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_MUSIADEDATE] DEFAULT ('01.01.1900') FOR [MUSIADEDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_KAYIPDATE] DEFAULT ('01.01.1900') FOR [KAYIPDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD CONSTRAINT [DF_WOR_CASE_LASTREADDATE] DEFAULT ('01.01.1900') FOR [LASTREADDATE]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ((0)) FOR [SPECID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ('') FOR [MODEL]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ((0)) FOR [REASONID]
GO
ALTER TABLE [dbo].[WOR_CASE] ADD DEFAULT ('') FOR [PRODUCERSERINO]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_DATE_] DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_SERINO] DEFAULT ('') FOR [SERINO]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_FCUSTOMERID] DEFAULT ((0)) FOR [FCUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_SCUSTOMERID] DEFAULT ('') FOR [SCUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_CASELOG] ADD CONSTRAINT [DF_WOR_CASELOG_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_CASEREASON] ADD CONSTRAINT [DF_WOR_CASEREASONS_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_CASEREASON] ADD CONSTRAINT [DF_WOR_CASEREASONS_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_CASESPEC] ADD CONSTRAINT [DF_WOR_CASESPEC_SPEC] DEFAULT ('') FOR [SPEC]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_ITEMID] DEFAULT ((0)) FOR [ITEMID]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_NAME] DEFAULT ('') FOR [NAME]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_SPECODE] DEFAULT ('') FOR [SPECODE]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_MARK] DEFAULT ('') FOR [MARK]
GO
ALTER TABLE [dbo].[WOR_CASETYPE] ADD CONSTRAINT [DF_WOR_CASE_MODEL] DEFAULT ('') FOR [MODEL]
GO
ALTER TABLE [dbo].[WOR_COLORS] ADD CONSTRAINT [DF_WOR_COLORS_CTYPE] DEFAULT (0) FOR [CTYPE]
GO
ALTER TABLE [dbo].[WOR_COLORS] ADD CONSTRAINT [DF_WOR_COLORS_COLOR] DEFAULT ('') FOR [COLOR]
GO
ALTER TABLE [dbo].[WOR_COLORS] ADD CONSTRAINT [DF_WOR_COLORS_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_CLIENTCODE] DEFAULT ('') FOR [CLIENTCODE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_LATITUDE] DEFAULT ('') FOR [LATITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_LONGITUDE] DEFAULT ('') FOR [LONGITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD CONSTRAINT [DF_WOR_CUSTGPSDATA_HDOP] DEFAULT ('') FOR [HDOP]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD DEFAULT ('') FOR [SHIPADDRCODE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSDATA] ADD DEFAULT ((0)) FOR [SHIPADDRID]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD CONSTRAINT [DF_WOR_CUSTOMERGPSLOCATION_CLIENTREF] DEFAULT (0) FOR [CLIENTREF]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD CONSTRAINT [DF_WOR_CUSTOMERGPSLOCATION_LATITUDE] DEFAULT ('') FOR [LATITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD CONSTRAINT [DF_WOR_CUSTOMERGPSLOCATION_LONGTITUDE] DEFAULT ('') FOR [LONGTITUDE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD DEFAULT ('') FOR [CLCODE]
GO
ALTER TABLE [dbo].[WOR_CUSTGPSLOC] ADD DEFAULT ('') FOR [CLNAME]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_LINENO] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_DESCRIPTION] DEFAULT ('') FOR [DEFINITION_]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_SPECODE] DEFAULT ('') FOR [SPECODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_SLSMANREF] DEFAULT (0) FOR [SLSMANREF]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_ISSHOWSTOC] DEFAULT (0) FOR [ISSHOWSTOC]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_WHOUSE] DEFAULT (0) FOR [WHOUSE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_STYPE] DEFAULT (0) FOR [STYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_TYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_WRKTYPE] DEFAULT (0) FOR [WRKTYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD CONSTRAINT [DF_WOR_DEFORDER_FORMGROUP] DEFAULT ('') FOR [FORMGROUP]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT (0) FOR [USEPENETRATION]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT (0) FOR [ENTPRICE]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ((0)) FOR [PRODUCTCLASSREF]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('0') FOR [MINSTOCK]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ((0)) FOR [USEMINSTOCK]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('') FOR [FIRMNR]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('') FOR [DONEMNR]
GO
ALTER TABLE [dbo].[WOR_DEFORDER] ADD DEFAULT ('') FOR [INNERSQL]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_DEFORDERID] DEFAULT (0) FOR [DEFORDERID]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_GROUP] DEFAULT ('') FOR [GROUP_]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_PCODE] DEFAULT ('') FOR [PCODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_MCODE] DEFAULT ('') FOR [MCODE]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_MINAMOUNT] DEFAULT (0) FOR [MINAMOUNT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_MAXAMOUNT] DEFAULT (0) FOR [MAXAMOUNT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_ISSLCTUNIT] DEFAULT (0) FOR [ISSLCTUNIT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_UNIT] DEFAULT (0) FOR [UNIT]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_DEFORDERDETAIL_ISSHOWSTOCK] DEFAULT (0) FOR [ISSHOWSTOCK]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD CONSTRAINT [DF_WOR_DEFORDERDETAIL_LINENO_] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD DEFAULT (0) FOR [COLORID]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD DEFAULT (0) FOR [UNITREF]
GO
ALTER TABLE [dbo].[WOR_DEFORDERDETAIL] ADD DEFAULT ((0)) FOR [LINETYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_FILENAME] DEFAULT ('') FOR [FILENAME]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_TYPE] DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_SECTORTYPE] DEFAULT ((0)) FOR [SECTORTYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_SECTORNR] DEFAULT ((0)) FOR [SECTORNR]
GO
ALTER TABLE [dbo].[WOR_DESIGNS] ADD CONSTRAINT [DF_WOR_DESIGNS_VALUE] DEFAULT ('') FOR [VALUE]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_TYPE] DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_FILENAME] DEFAULT ('') FOR [FILENAME]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_STARTY] DEFAULT ((0)) FOR [STARTY]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_DETAILCOUNT] DEFAULT ((0)) FOR [DETAILCOUNT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_TITLEHEIGHT] DEFAULT ((0)) FOR [TITLEHEIGHT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_DETAILHEIGHT] DEFAULT ((0)) FOR [DETAILHEIGHT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_PAGEENDHEIGHT] DEFAULT ((0)) FOR [PAGEENDHEIGHT]
GO
ALTER TABLE [dbo].[WOR_DESIGNSETTINGS] ADD CONSTRAINT [DF_WOR_DESIGNSETTINGS_PRINTINGENDHEIGHT] DEFAULT ((0)) FOR [PRINTINGENDHEIGHT]
GO
ALTER TABLE [dbo].[WOR_EMAILFORMS] ADD CONSTRAINT [DF_WOR_EMAILFORMS_FORMNAME] DEFAULT ((0)) FOR [FORMNAME]
GO
ALTER TABLE [dbo].[WOR_EMAILFORMS] ADD CONSTRAINT [DF_WOR_EMAILFORMS_FORMTYPE] DEFAULT ('') FOR [FORMTYPE]
GO
ALTER TABLE [dbo].[WOR_EMAILFORMS] ADD CONSTRAINT [DF_WOR_EMAILFORMS_FORMCONTENT] DEFAULT ('') FOR [FORMCONTENT]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_LATITUDE] DEFAULT ('') FOR [LATITUDE]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_LONGTITUDE] DEFAULT ('') FOR [LONGTITUDE]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_SPEED] DEFAULT (0) FOR [SPEED]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_DISTANCE] DEFAULT (0) FOR [DISTANCE]
GO
ALTER TABLE [dbo].[WOR_GPSDATA] ADD CONSTRAINT [DF_WOR_GPSDATA_TIMESPAN] DEFAULT (0) FOR [TIMESPAN]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_DESC_] DEFAULT ('') FOR [DEFINITION_]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_VIEWTYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_MARKETINGMESSAGE] ADD CONSTRAINT [DF_WOR_MARKETINGMESSAGE_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_SENDER] DEFAULT (0) FOR [SENDER]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_RECIPENT] DEFAULT (0) FOR [RECIPIENT]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_ISREAD] DEFAULT (0) FOR [ISREAD]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD CONSTRAINT [DF_WOR_MESSAGE_MSGTYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_MESSAGE] ADD DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_LINENO_] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_DESC_] DEFAULT ('') FOR [DEFINITION_]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_STYPE] DEFAULT (0) FOR [STYPE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_PNTGROUP] DEFAULT ('') FOR [PNTGROUP]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_PTYPE] DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD CONSTRAINT [DF_WOR_PENETRATION_ENTPRICE] DEFAULT (0) FOR [ENTPRICE]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [COLRIGHT]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD1]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD2]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD3]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD4]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD5]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD6]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD7]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD8]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD9]
GO
ALTER TABLE [dbo].[WOR_PENETRATION] ADD DEFAULT ('') FOR [DEFFIELD10]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PNTID] DEFAULT (0) FOR [PNTID]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PRTYPE] DEFAULT ('') FOR [PRTYPE]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PRODUCTID] DEFAULT (0) FOR [PRODUCTID]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PCODE] DEFAULT ('') FOR [PCODE]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_BARCODE] DEFAULT ('') FOR [BARCODE]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_UNIT] DEFAULT ('') FOR [UNIT]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD CONSTRAINT [DF_WOR_PENETRATIONDETAIL_LINENO_] DEFAULT (0) FOR [LINENO_]
GO
ALTER TABLE [dbo].[WOR_PENETRATIONDETAIL] ADD DEFAULT ((0)) FOR [PRTYPEINT]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_CLIENTREF] DEFAULT (0) FOR [CLIENTREF]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_PTYPE] DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_PREF] DEFAULT (0) FOR [PREF]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_PDISTANCE] DEFAULT (0) FOR [PDISTANCE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_VREASON] DEFAULT ('') FOR [VREASON]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD CONSTRAINT [DF_WOR_PROCESS_VNOTE] DEFAULT ('') FOR [VNOTE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT (0) FOR [ISPRINT]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [CLCODE]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [CLNAME]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ((0)) FOR [SHIPINFOREF]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [ENLEM]
GO
ALTER TABLE [dbo].[WOR_PROCESS] ADD DEFAULT ('') FOR [BOYLAM]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_mainmenu] DEFAULT ('') FOR [mainmenu]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu1] DEFAULT ('') FOR [submenu1]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu2] DEFAULT ('') FOR [submenu2]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu3] DEFAULT ('') FOR [submenu3]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu4] DEFAULT ('') FOR [submenu4]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_submenu5] DEFAULT ('') FOR [submenu5]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_fno] DEFAULT ('') FOR [fno]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_parentfno] DEFAULT ('') FOR [parentfno]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_lineno_] DEFAULT (0) FOR [lineno_]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_level_] DEFAULT (0) FOR [level_]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_visible] DEFAULT (0) FOR [visible]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_lang] DEFAULT (0) FOR [lang]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_picturename] DEFAULT ('') FOR [picturename]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_url] DEFAULT ('') FOR [url]
GO
ALTER TABLE [dbo].[WOR_PROGMENU] ADD CONSTRAINT [DF_WOR_PROGMENU_modul] DEFAULT ('') FOR [modul]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_AMOUNT] DEFAULT (0) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_PTYPE] DEFAULT (0) FOR [PTYPE]
GO
ALTER TABLE [dbo].[WOR_QUOTA] ADD CONSTRAINT [DF_WOR_QUOTA_ALERTTYPE] DEFAULT (0) FOR [ALERTTYPE]
GO
ALTER TABLE [dbo].[WOR_QUOTADETAIL] ADD CONSTRAINT [DF_WOR_QUOTADETAIL_QUOTAID] DEFAULT (0) FOR [QUOTAID]
GO
ALTER TABLE [dbo].[WOR_QUOTADETAIL] ADD CONSTRAINT [DF_WOR_QUOTADETAIL_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD CONSTRAINT [DF_WOR_REPORTS_REPINDEX] DEFAULT ((0)) FOR [REPINDEX]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD CONSTRAINT [DF_WOR_REPORTS_REPORTNAME] DEFAULT ('') FOR [REPORTNAME]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD CONSTRAINT [DF_WOR_REPORTS_REPORTPATH] DEFAULT ('') FOR [REPORTPATH]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD DEFAULT ((0)) FOR [RTYPE]
GO
ALTER TABLE [dbo].[WOR_REPORTS] ADD DEFAULT ('') FOR [REPORTCONTENT]
GO
ALTER TABLE [dbo].[WOR_SETTINGS] ADD CONSTRAINT [DF_WOR_SETTINGS_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_SETTINGS] ADD CONSTRAINT [DF_WOR_SETTINGS_PVALUE] DEFAULT ('') FOR [PVALUE]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_DESC] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_STATUS] DEFAULT (0) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD1] DEFAULT ('') FOR [FIELD1]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD2] DEFAULT ('') FOR [FIELD2]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD3] DEFAULT ('') FOR [FIELD3]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD4] DEFAULT ('') FOR [FIELD4]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD5] DEFAULT ('') FOR [FIELD5]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD6] DEFAULT ('') FOR [FIELD6]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD7] DEFAULT ('') FOR [FIELD7]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD8] DEFAULT ('') FOR [FIELD8]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD9] DEFAULT ('') FOR [FIELD9]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD CONSTRAINT [DF_SURVEY_FIELD10] DEFAULT ('') FOR [FIELD10]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD DEFAULT ((0)) FOR [USECASE]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD DEFAULT ((0)) FOR [MUSTDO]
GO
ALTER TABLE [dbo].[WOR_SURVEY] ADD DEFAULT ((0)) FOR [PERIOD]
GO
ALTER TABLE [dbo].[WOR_SURVEYADETAIL] ADD CONSTRAINT [DF_SURVEYADETAIL_ANSWER] DEFAULT ('') FOR [ANSWER]
GO
ALTER TABLE [dbo].[WOR_SURVEYADETAIL] ADD CONSTRAINT [DF_SURVEYADETAIL_POINT] DEFAULT (0) FOR [POINT]
GO
ALTER TABLE [dbo].[WOR_SURVEYANSWERNEW] ADD CONSTRAINT [DF_WOR_SURVEYANSWERNEW_SID] DEFAULT ((0)) FOR [SID]
GO
ALTER TABLE [dbo].[WOR_SURVEYANSWERNEW] ADD CONSTRAINT [DF_WOR_SURVEYANSWERNEW_QID] DEFAULT ((0)) FOR [QID]
GO
ALTER TABLE [dbo].[WOR_SURVEYANSWERNEW] ADD CONSTRAINT [DF_WOR_SURVEYANSWERNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_STATUS] DEFAULT ((0)) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_CHOICEPROD] DEFAULT ((0)) FOR [CHOICEPROD]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_ENTERPRODAMOUNT] DEFAULT ((0)) FOR [ENTERPRODAMOUNT]
GO
ALTER TABLE [dbo].[WOR_SURVEYNEW] ADD CONSTRAINT [DF_WOR_SURVEYNEW_DEFPRODAMOUNT] DEFAULT ((0)) FOR [DEFPRODAMOUNT]
GO
ALTER TABLE [dbo].[WOR_SURVEYQDETAIL] ADD CONSTRAINT [DF_SURVEYDETAIL_QTYPE] DEFAULT (0) FOR [QTYPE]
GO
ALTER TABLE [dbo].[WOR_SURVEYQDETAIL] ADD CONSTRAINT [DF_SURVEYDATIL_ANSWER] DEFAULT ('') FOR [QUESTION]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_SID] DEFAULT ((0)) FOR [SID]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_TYPE] DEFAULT ((0)) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_DTYPE] DEFAULT ((0)) FOR [DTYPE]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_DEFVAL] DEFAULT ('') FOR [DEFVAL]
GO
ALTER TABLE [dbo].[WOR_SURVEYQUESTIONSNEW] ADD CONSTRAINT [DF_WOR_SURVEYQUESTIONSNEW_ISMUST] DEFAULT ((0)) FOR [ISMUST]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_TODOUSERID] DEFAULT (0) FOR [TODOUSERID]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_DESC_] DEFAULT ('') FOR [DESC_]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_BEGDATE] DEFAULT ('01.01.1900') FOR [BEGDATE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_ENDDATE] DEFAULT ('01.01.1900') FOR [ENDDATE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_PRIORITY] DEFAULT (0) FOR [PRIORITY]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_SENDEMAIL] DEFAULT (0) FOR [SENDEMAIL]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_EMAILADDR] DEFAULT ('') FOR [EMAILADDR]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_CUSTOMERID] DEFAULT (0) FOR [CUSTOMERID]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_USERNOTE] DEFAULT ('') FOR [USERNOTE]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_STATUS] DEFAULT (0) FOR [STATUS]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_DEFINITIONTIME] DEFAULT ('01.01.1900') FOR [DEFINITIONTIME]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_READTIME] DEFAULT ('01.01.1900') FOR [READTIME]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD CONSTRAINT [DF_WOR_TODO_COMPLATETIME] DEFAULT ('01.01.1900') FOR [COMPLATETIME]
GO
ALTER TABLE [dbo].[WOR_TODO] ADD DEFAULT ((0)) FOR [SALESMUST]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_SESSIONID] DEFAULT ('') FOR [SESSIONID]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_DATE_] DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_TRANSFERDATA] ADD CONSTRAINT [DF_WOR_TRANSFERDATA_DATASTR] DEFAULT ('') FOR [DATASTR]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_UNITSETREF] DEFAULT ((0)) FOR [UNITSETREF]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_UNITREF] DEFAULT ((0)) FOR [UNITREF]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_UNITCODE] DEFAULT ('') FOR [UNITCODE]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_CHOICEUNIT] DEFAULT ((0)) FOR [CHOICEUNIT]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_CONVERTUNIT] DEFAULT ((0)) FOR [CONVERTUNIT]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_RATIO] DEFAULT ((0)) FOR [RATIO]
GO
ALTER TABLE [dbo].[WOR_UNITSET] ADD CONSTRAINT [DF_WOR_UNITSET_MAINUNIT] DEFAULT ((0)) FOR [MAINUNIT]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_SLSCODE] DEFAULT ('') FOR [SLSCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_CLIENTREF] DEFAULT (0) FOR [CLIENTREF]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_CLIENTCODE] DEFAULT ('') FOR [CLIENTCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_WOR_USERANSWER_CLIENTNAME] DEFAULT ('') FOR [CLIENTNAME]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD1] DEFAULT ('') FOR [FIELD1]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD2] DEFAULT ('') FOR [FIELD2]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD3] DEFAULT ('') FOR [FIELD3]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD4] DEFAULT ('') FOR [FIELD4]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD5] DEFAULT ('') FOR [FIELD5]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD6] DEFAULT ('') FOR [FIELD6]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD7] DEFAULT ('') FOR [FIELD7]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD8] DEFAULT ('') FOR [FIELD8]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD9] DEFAULT ('') FOR [FIELD9]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD CONSTRAINT [DF_USERANSWER_FIELD10] DEFAULT ('') FOR [FIELD10]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD DEFAULT ((0)) FOR [CASEID]
GO
ALTER TABLE [dbo].[WOR_USERANSWER] ADD DEFAULT (getdate()) FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_SID] DEFAULT ((0)) FOR [SID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_QID] DEFAULT ((0)) FOR [QID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_PID] DEFAULT ((0)) FOR [PID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_CID] DEFAULT ((0)) FOR [CID]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_SUBJECT] DEFAULT ('') FOR [SUBJECT]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_AMOUNT] DEFAULT ((0)) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_CLCODE] DEFAULT ('') FOR [CLCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_CLNAME] DEFAULT ('') FOR [CLNAME]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_PCODE] DEFAULT ('') FOR [PCODE]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_PNAME] DEFAULT ('') FOR [PNAME]
GO
ALTER TABLE [dbo].[WOR_USERANSWERNEW] ADD CONSTRAINT [DF_WOR_USERANSWERNEW_UNIQUEVAL] DEFAULT ('') FOR [UNIQUEVAL]
GO
ALTER TABLE [dbo].[WOR_USERFIRMS] ADD CONSTRAINT [DF_WOR_FIRMS_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERFIRMS] ADD CONSTRAINT [DF_WOR_FIRMS_FIRMNR] DEFAULT ('') FOR [FIRMNR]
GO
ALTER TABLE [dbo].[WOR_USERFIRMS] ADD CONSTRAINT [DF_WOR_FIRMS_PERIODNR] DEFAULT ('') FOR [PERIODNR]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_usersid] DEFAULT (0) FOR [usersid]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_level_] DEFAULT (0) FOR [level_]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_fno] DEFAULT ('') FOR [fno]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_parentfno] DEFAULT ('') FOR [parentfno]
GO
ALTER TABLE [dbo].[WOR_USERMENU] ADD CONSTRAINT [DF_WOR_USERMENU_visible] DEFAULT (0) FOR [visible]
GO
ALTER TABLE [dbo].[WOR_USERORDERS] ADD CONSTRAINT [DF_WOR_USERORDERS_ORFICHEREF] DEFAULT (0) FOR [ORFICHEREF]
GO
ALTER TABLE [dbo].[WOR_USERORDERS] ADD CONSTRAINT [DF_WOR_USERORDERS_SALESMANREF] DEFAULT (0) FOR [SALESMANREF]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_PNTIND] DEFAULT (0) FOR [PNTID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_PNTDETAILID] DEFAULT (0) FOR [PNTDETAILID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_CLIENTID] DEFAULT (0) FOR [CLIENTID]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_VY] DEFAULT (0) FOR [VY]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_AMOUNT] DEFAULT (0) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_PRICE] DEFAULT (0) FOR [PRICE]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD CONSTRAINT [DF_WOR_USERPENETRATION_CURRENCY] DEFAULT ('') FOR [CURRENCY]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT (0) FOR [SOURCETYPE]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD1]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD2]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD3]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD4]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD5]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD6]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD7]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD8]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD9]
GO
ALTER TABLE [dbo].[WOR_USERPENETRATION] ADD DEFAULT ('') FOR [DEFFIELD10]
GO
ALTER TABLE [dbo].[WOR_USERQUOTA] ADD CONSTRAINT [DF_WOR_USERQUOTA_USERID] DEFAULT (0) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERQUOTA] ADD CONSTRAINT [DF_WOR_USERQUOTA_QUOTAID] DEFAULT (0) FOR [QUOTAID]
GO
ALTER TABLE [dbo].[WOR_USERQUOTA] ADD CONSTRAINT [DF_WOR_USERQUOTA_AMOUNT] DEFAULT (0) FOR [AMOUNT]
GO
ALTER TABLE [dbo].[WOR_USERROLERIGHT] ADD CONSTRAINT [DF_WOR_USERSROLERIGHT_PARAMNO] DEFAULT ('') FOR [PARAMNO]
GO
ALTER TABLE [dbo].[WOR_USERROLERIGHT] ADD CONSTRAINT [DF_WOR_USERSROLERIGHT_PARAMVALUE] DEFAULT ('') FOR [PARAMVALUE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_USERNAME] DEFAULT ('') FOR [USERNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_PASSWORD] DEFAULT ('') FOR [PASSWORD]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_TYPE] DEFAULT (0) FOR [TYPE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_CODE] DEFAULT ('') FOR [CODE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_NAME] DEFAULT ('') FOR [NAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_GROUPCODE] DEFAULT ('') FOR [GROUPCODE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_FNAME] DEFAULT ('') FOR [FNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_LNAME] DEFAULT ('') FOR [LNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_EMAIL] DEFAULT ('') FOR [EMAIL]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_WEB] DEFAULT ('') FOR [WEB]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_SPECODE] DEFAULT ('') FOR [SPECODE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_ADMIN] DEFAULT (0) FOR [ADMIN]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF_WOR_USERS_LOGOVALUES] DEFAULT ('') FOR [LOGOVALUES]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD CONSTRAINT [DF__WOR_USERS__DOSHI__181857E1] DEFAULT (0) FOR [DOSHIP]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ('') FOR [LOGOUSER]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ('') FOR [LOGOPWD]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ('') FOR [WINUSERNAME]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ((0)) FOR [APPTYPE]
GO
ALTER TABLE [dbo].[WOR_USERS] ADD DEFAULT ((0)) FOR [USERROLEID]
GO
ALTER TABLE [dbo].[WOR_USERSRIGHT] ADD CONSTRAINT [DF_WOR_USERRIGHT_PARAMNO] DEFAULT ('') FOR [PARAMNO]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_USERID] DEFAULT ((0)) FOR [USERID]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_DATE_] DEFAULT ('01.01.1900') FOR [DATE_]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_PLAKA] DEFAULT ('') FOR [PLAKA]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_STARTKM] DEFAULT ('') FOR [STARTKM]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_ENDKM] DEFAULT ('') FOR [ENDKM]
GO
ALTER TABLE [dbo].[WOR_USERSTARTINFO] ADD CONSTRAINT [DF_WOR_USERSTARTINFO_NOTE] DEFAULT ('') FOR [NOTE]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_MAJOR] DEFAULT ('') FOR [MAJOR]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_MINOR] DEFAULT ('') FOR [MINOR]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_BUILD] DEFAULT ('') FOR [BUILD]
GO
ALTER TABLE [dbo].[WOR_VERSION] ADD CONSTRAINT [DF_WOR_VERSION_REVISION] DEFAULT ('') FOR [REVISION]
GO
ALTER TABLE [dbo].[WOR_VISITINFO] ADD CONSTRAINT [DF_WOR_VISITINFO_DESC_] DEFAULT ('') FOR [DESC_]
GO
Blog of Sem 