select
(CASE WHEN P.PTYPE='0' THEN 'MIKTAR' ELSE 'VAR/YOK' END) PENETRATIONTYPE,
U.CODE+'-'+U.FNAME SALESMAN,
PNTHEADER.DATE,
CLCARD.CODE+'-'+CLCARD.DEFINITION_ CLIENT,
ISNULL(P.PCODE,'') PCODE,
ISNULL(P.PDEFINITION,'') PDEFINITION,
ISNULL(WD.ITEMNAME,'') ITEMNAME ,
WU.PRICE,
WU.AMOUNT,
WU.NOTE
from WOR_PNTHEADER PNTHEADER
LEFT JOIN WOR_PNTTRANS WU ON WU.PNTHEADER_REF=PNTHEADER.PNT_GUID
LEFT JOIN WOR_PENETRATIONDETAIL WD ON WU.PNTDTL_ID=WD.LOGICALREF
LEFT JOIN WOR_USERS U ON U.USERID=PNTHEADER.SALESMANREF
LEFT JOIN WOR_PENETRATION P ON P.LOGICALREF=PNTHEADER.PNT_ID
LEFT JOIN LG_219_CLCARD CLCARD ON CLCARD.LOGICALREF=PNTHEADER.CLIENTREF
/*where PNTHEADER.LOGICALREF=9*/
ORDER BY PNTHEADER.DATE, WD.SEQUENCE
Category: MOBILESALES
LOGO Mobilsales tabloları sil
Collation sorunundan dolayı karşıma çıktı:
Ayrıca yine veritabanı altında Programmability->Store Procedures altından getParameters ve WOR_ ile başlayan prosedürleri, Functions->Scalar-Valued Functions altından GetWebOrderDateInt, Views altındadan VGetdate viewini siliniz. Sildikten sonra yeniden tabloların oluşturulmasını sağlayabilirsiniz?(Mobile Sales Genel Ayarlar açılarak veritabanı tablolarını ekleyebilirsiniz.)
bunlarıda sil:
spWebOrderParseBarkod
splitString
LOGO MOBILESALES CARI ZIYARET RAPORU
SELECT DISTINCT M.P_KODU,
M.CARI_KODU,M.CARI_ADI,M.GUN,
(
SELECT TOP 1 WP.DATE_ FROM WOR_PROCESS WP ,WOR_USERS WU WHERE WP.FIRM = '121'
AND WU.APPTYPE=1 AND WP.USERID=WU.USERID
AND ( WP.DATE_ BETWEEN ? AND ? )
AND WU.USERNAME=M.P_KODU AND WP.CLCODE=M.CARI_KODU
ORDER BY WP.DATE_ DESC
) SON_GIDILEN_TARIH,
(SELECT W2.FNAME FROM WOR_USERS W2 WHERE W2.CODE=M.P_KODU) AS P_ADI
FROM E_WINGS_121_SCS3 M WHERE 1=1
LOGO MOBILESALES 262 VERSIYON GECISI YAPMADAN KURMAK VE VERSION GECISLI KURULUM
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 