select
ISNULL(B.BARCODE,'') ProductCode,
ISNULL(I.NAME,'') ProductName,
ISNULL((SELECT TOP 1 ROUND(PRICE,2) FROM LG_320_PRCLIST P WITH(NOLOCK) WHERE CARDREF = I.LOGICALREF AND ACTIVE = 0 AND PTYPE = 2 AND CLIENTCODE = '' order by P.LOGICALREF DESC ),0) Price
FROM dbo.LG_320_ITEMS I WITH(NOLOCK) LEFT JOIN LG_320_UNITBARCODE B ON B.ITEMREF=I.LOGICALREF WHERE I.CODE<>'ÿ'AND ISNULL(B.BARCODE,'') <> ''
Tag: Sql
LOGO SQL RAPOR PORTFÖYDE OLAN ÇEK SENETLER
SELECT
(SELECT CLCARD.CODE FROM LG_118_CLCARD CLCARD WHERE CLCARD.LOGICALREF=(SELECT TOP 1 CSTRANS.CARDREF FROM LG_118_01_CSTRANS CSTRANS WHERE CSTRANS.CSREF=LGMAIN.LOGICALREF )) CARIHESAP,
TRNET TUTAR,
* FROM
LG_118_01_CSCARD LGMAIN WITH(NOLOCK)
WHERE
(LGMAIN.CURRSTAT IN (1)) AND (LGMAIN.STATUS IN (0,1)) AND (LGMAIN.DOC = 1)
LOGO INVDEFDE OLMAYAN ITEMLERI SQLDEN EKLEME
INVDEF TABLOSU : URUNLERIN GENEL OLARAK AMBAR BAZLI NEGATIF SEVIYEYE DUSUP DUSMEMESININ BILGISINI ICERIR
INSERT INTO LG_101_INVDEF (INVENNO,ITEMREF,MINLEVEL,MAXLEVEL,SAFELEVEL,LOCATIONREF, PERCLOSEDATE,
ABCCODE,MINLEVELCTRL,MAXLEVELCTRL,SAFELEVELCTRL,NEGLEVELCTRL,IOCTRL,VARIANTREF,OUTCTRL)
SELECT W.NR INVENNO, I.LOGICALREF ITEMREF, 0 MINLEVEL,0 MAXLEVEL, 0 SAFELEVEL, 0 LOCATIONREF, NULL PERCLOSEDATE,
0 ABCCODE, 0 MINLEVELCTRL, 0 MAXLEVELCTRL, 0 SAFELEVELCTRL, 0 NEGLEVELCTRL, 0 IOCTRL, 0 VARIANTREF, 0 OUTCTRL FROM L_CAPIWHOUSE W
CROSS JOIN LG_101_ITEMS I
WHERE FIRMNR=101 AND I.CARDTYPE=1 AND I.LOGICALREF NOT IN ( select ID.ITEMREF from LG_101_INVDEF ID)
LOGO SQL CARI EXTRE
--COKLU CARI TERCIH EDILMEZ
SELECT
T.[CARI_HESAP_KODU],T.ACIKLAMA,T.TARIH,T.FIS_NO,T.FIS_TURU,T.BELGE_NO,T.SATIR_ACIKLAMASI,T.BORC,T.ALACAK,
ROUND((SUM(T.Tutar) OVER (ORDER BY NR)),2) AS BAKIYE,
T.ISLEM_DOVIZI,
T.ISLEM_DOVIZ_TUTARI,
T.RD_TUTARI_EUR,
ROUND((SUM(T.RD_TUTARI_EUR) OVER (ORDER BY NR)),2) AS EUR_BAKIYE
FROM (
SELECT TOP 100 PERCENT
ROW_NUMBER() OVER (ORDER BY (SELECT 100)) AS NR,
CLNTC.CODE [CARI_HESAP_KODU],
CLNTC.DEFINITION_ [ACIKLAMA],
CTRNS.DATE_ TARIH,
CTRNS.TRANNO [FIS_NO],
CASE ((CTRNS.MODULENR*100)+CTRNS.TRCODE)
WHEN 381 THEN 'Satış Siparişi'
WHEN 382 THEN 'Satınalma Siparişi'
WHEN 431 THEN 'Satın Alma Faturası'
WHEN 432 THEN 'Perakende Satış İade Faturası'
WHEN 433 THEN 'Toptan Satış İade Faturası'
WHEN 434 THEN 'Alınan Hizmet Faturası'
WHEN 435 THEN 'Alınan Proforma Faturası'
WHEN 436 THEN 'Alım İade Faturası'
WHEN 437 THEN 'Perakende Satış Faturası'
WHEN 438 THEN 'Toptan Satış Faturası'
WHEN 439 THEN 'Verilen Hizmet Faturası'
WHEN 440 THEN 'Verilen Proforma Faturası'
WHEN 441 THEN 'Verilen Vade Farkı Faturası'
WHEN 442 THEN 'Alınan Vade Farkı Faturası'
WHEN 443 THEN 'Alınan Fiyat Farkı Faturası'
WHEN 444 THEN 'Verilen Fiyat Farkı Faturası'
WHEN 456 THEN 'Müstahsil Makbuzu'
WHEN 501 THEN 'Nakit Tahsilat'
WHEN 502 THEN 'Nakit Ödeme'
WHEN 503 THEN 'Borç Dekontu'
WHEN 504 THEN 'Alacak Dekontu'
WHEN 505 THEN 'Virman İşlemi'
WHEN 506 THEN 'Kur Farkı İşlemi'
WHEN 512 THEN 'Özel İşlem'
WHEN 514 THEN 'Açılış Fişi'
WHEN 570 THEN 'Kredi Kartı Fişi'
WHEN 661 THEN 'Çek Girişi'
WHEN 662 THEN 'Senet Girişi'
WHEN 663 THEN 'Çek Çıkış Cari Hesaba'--CSTRANS.CLACCREF
WHEN 664 THEN 'Senet Çıkış Cari Hesaba'
WHEN 720 THEN 'Gelen Havaleler'
WHEN 721 THEN 'Gönderilen Havaleler'
WHEN 728 THEN 'Banka Alınan Hizmet'
WHEN 729 THEN 'Banka Verilen Hizmet'
WHEN 1001 THEN 'Nakit Tahsilat'
WHEN 1002 THEN 'Nakit Ödeme'
WHEN 6103 THEN 'Borç Dekontu (Çek)'
WHEN 6104 THEN 'Alacak Dekontu (Çek)'
END [FIS_TURU],
CTRNS.DOCODE [BELGE_NO],
CTRNS.LINEEXP [SATIR_ACIKLAMASI],
CASE SIGN WHEN 0 THEN ROUND(AMOUNT,2) ELSE 0 END BORC,
CASE SIGN WHEN 1 THEN ROUND(-1*AMOUNT,2) ELSE 0 END ALACAK,
CASE SIGN WHEN 0 THEN ROUND(AMOUNT,2) ELSE ROUND(-1*AMOUNT,2) END TUTAR,
CASE CTRNS.TRCURR WHEN 0 THEN 'TL' WHEN 160 THEN 'TL' WHEN 1 THEN 'USD' WHEN 17 THEN 'GBP' WHEN 20 THEN 'EUR' END [ISLEM_DOVIZI],
CASE SIGN WHEN 0 THEN ROUND(CTRNS.TRNET,2) ELSE ROUND(-1*CTRNS.TRNET,2) END [ISLEM_DOVIZ_TUTARI] ,
CASE SIGN WHEN 0 THEN ROUND(CTRNS.REPORTNET,2) ELSE ROUND(-1*CTRNS.REPORTNET,2) END [RD_TUTARI_EUR]
FROM LG_{0}_01_CLFLINE CTRNS WITH (NOLOCK)
LEFT OUTER JOIN LG_{0}_PAYPLANS PAYPL WITH (NOLOCK)
ON (CTRNS.PAYDEFREF = PAYPL.LOGICALREF)
LEFT OUTER JOIN LG_{0}_01_CLFICHE CLFIC WITH (NOLOCK)
ON (CTRNS.SOURCEFREF = CLFIC.LOGICALREF)
LEFT OUTER JOIN LG_{0}_01_INVOICE INVFC WITH (NOLOCK)
ON (CTRNS.SOURCEFREF = INVFC.LOGICALREF)
LEFT OUTER JOIN LG_{0}_01_CSROLL RLFIC WITH (NOLOCK)
ON (CTRNS.SOURCEFREF = RLFIC.LOGICALREF)
LEFT OUTER JOIN LG_{0}_01_EMFICHE GLFIC WITH (NOLOCK)
ON (CTRNS.ACCFICHEREF = GLFIC.LOGICALREF)
LEFT OUTER JOIN LG_{0}_CLCARD CLNTC WITH (NOLOCK)
ON (CTRNS.CLIENTREF = CLNTC.LOGICALREF)
LEFT OUTER JOIN LG_{0}_01_ORFICHE ORFIC WITH (NOLOCK)
ON (CTRNS.SOURCEFREF = ORFIC.LOGICALREF)
LEFT OUTER JOIN LG_{0}_PURCHOFFER POFFER WITH (NOLOCK)
ON (CTRNS.OFFERREF = POFFER.LOGICALREF)
WHERE (CTRNS.BRANCH IN ( 0 ))
AND (CTRNS.DEPARTMENT IN ( 0 ))
AND (CTRNS.TRCODE IN ( 31, 32, 33, 34, 36, 37, 38, 39, 43, 44, 56, 1, 2, 3, 4, 5, 6, 12, 14, 41, 42, 45, 46, 70,71, 72, 73, 20, 21, 24, 25, 28, 29, 30, 61, 62, 63, 64, 75, 81, 82 ))
AND CLNTC.CODE='{1}'
AND (CTRNS.DATE_ <= CONVERT(DATETIME, DATEFROMPARTS(YEAR(GETDATE()),12,31), 101)) and CTRNS.CANCELLED=0
ORDER BY CTRNS.DATE_,
CASE WHEN CTRNS.TRCODE = 14 AND CTRNS.MODULENR = 5 THEN 0 ELSE 1 END,
CASE WHEN CTRNS.MODULENR = 5 THEN CLFIC.TIME WHEN CTRNS.MODULENR = 4 THEN INVFC.TIME_ ELSE CTRNS.FTIME END,
CLFIC.LOGICALREF
) AS T
LOGO SAYIMIN EKSIKMI FAZLAMI OLDUGU SORGUSU
SELECT LOGICALREF, LOGICALREFPDA,STFICHEREF, FIS FROM (
SELECT AMOUNT SAYILAN,ONHAND STOKTA,CASE WHEN ONHAND<AMOUNT THEN 'SAYIM EKSIGI' WHEN ONHAND>AMOUNT THEN 'SAYIM FAZLASI' ELSE '2' END FIS,* FROM(
SELECT *,(SELECT ISNULL(SUM(STITOTS.ONHAND),0) FROM LV_119_01_STINVTOT STITOTS WITH(NOLOCK) WHERE (STITOTS.INVENNO = STL.SOURCEINDEX) AND
(STITOTS.STOCKREF = STL.STOCKREF) AND (STITOTS.DATE_ <= STL.DATE_)) ONHAND FROM BM_PDA_STLINE STL WHERE TRCODE=55) AS T) AS T2 GROUP BY LOGICALREF, LOGICALREFPDA,STFICHEREF, FIS
c# sql server get first row
SqlConnection conn = new SqlConnection(BMS_DLL.SQL.sqlConnectionSource.ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT TOP 1 * FROM BM_PDKS_PARAMETRELER WHERE TUR='CALISMASAATI'", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow dr in dt.Rows) {
SE_NS.EditValue = double.Parse( dr["NS"].ToString());
SE_HS.EditValue = double.Parse(dr["HS"].ToString());
}
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
SQL SERVER KURULDUKTAN SONRA COLLATION DEĞİŞİMİ
Sql Serverin setupunun bulunduğu klasor
>Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER2014 /SQLSYSADMINACCOUNTS=Administrator /SAPWD= M@nVendr4 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
>Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER2014 /SQLSYSADMINACCOUNTS=Administrator /SAPWD= M@nVendr4 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
Blog of Sem 