Devexpress XtraGridView büyük datada update işlemi

On By semt20In C SHARP, Devexpress, SqlLeave a comment 
        public DLG_TAKVIM() {

            InitializeComponent();
            Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
            BMS_DLL.CFGGETSET.AYARLARIYUKLE();
            gridControl1.DataSource = BMS_DLL.SQL.SELECT("select * from (SELECT dt, Ay, Gün, Hafta, Saat, Açıklama, Saat Old_Saat, Açıklama Old_Açıklama FROM BM_PDKS_TAKVIM WITH(NOLOCK)) as t");
        }
        private void GUNCELLE() {
            try {
                DataTable DT = (DataTable)gridControl1.DataSource;
                DataRow[] DT_NEW = DT.Select("(Saat <> Old_Saat) OR (Açıklama <> Old_Açıklama)");
                if (DT_NEW != null && DT_NEW.Length > 0) {
                    foreach (DataRow R in DT_NEW) {
                        DateTime _DT= (DateTime)R["dt"];
                        double SAAT = (double)R["Saat"];
                        string ACIKLAMA = (string)R["Açıklama"];
                        BMS_DLL.SQL.EXECUTE(this, "UPDATE BM_PDKS_TAKVIM SET Saat='"+ SAAT + "' , Açıklama='"+ ACIKLAMA + "' WHERE dt='"+_DT+"' ");
                    }

                }
            } catch { }
        }

Yukarıdaki kodda gridview üzerinden deişen alanları alıp(saat,açıklama) sqlde sadece bu satırları update etme işlemini yapar.

c# sql server get first row

On By semt20In C SHARP, SqlLeave a comment 
            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 ERP SQL HAREKET GÖRMÜŞ MALZEMENİN BİRİMİNİ ÇEVİRME HAREKETLER DAHIL

On By semt20In LOGO ERP, SqlLeave a comment 
/*MALZEME */SELECT LOGICALREF FROM dbo.LG_211_ITEMS WITH(NOLOCK) WHERE  CODE='M-4299-04-CL-SP' /*MALZEMENIN LOGICALREFINI BULMAK ICIN=1367*/
/*BIRIM*/ SELECT LOGICALREF,UNITSETREF,CODE,NAME FROM LG_211_UNITSETL WITH(NOLOCK) WHERE MAINUNIT=1 AND NAME='ADET' /*HANGI MALZEME BIRIMI OLACAK LOGICALREF=55 UNITSETREF=6*/

/*GUNCELLEME ISLEMI*/
update LG_211_ITEMS set UNITSETREF = 6 /*BIRIMIN UNITSETREFI*/ where LOGICALREF = 1367 /*MALZEMENIN LOGICALREFI*/
update LG_211_ITMUNITA set UNITLINEREF = 55 /*BIRIMIN LOGICALREFI*/ where ITEMREF = 1367 /*MALZEMENIN LOGICALREFI*/

/*RISKLI:GERIYE DONUK HAREKETLERI GUNCELLEMEK ICIN (TALEP,SIPARIS VE IRSALIYE)*/
update LG_211_01_STLINE set UOMREF = 55 /*BIRIMIN LOGICALREFI*/ , USREF = 6 /*BIRIMIN UNITSETREFI*/ where Stockref = 1367 /*MALZEMENIN LOGICALREFI*/
update LG_211_01_ORFLINE set UOMREF = 55 /*BIRIMIN LOGICALREFI*/ , USREF = 6 /*BIRIMIN UNITSETREFI*/ where Stockref = 1367 /*MALZEMENIN LOGICALREFI*/
update LG_211_01_DEMANDLINE  set UOMREF = 55 /*BIRIMIN LOGICALREFI*/ , USREF = 6 /*BIRIMIN UNITSETREFI*/ where Stockref = 1367 /*MALZEMENIN LOGICALREFI*/

LOGO MOBILESALES 262 VERSIYON GECISI YAPMADAN KURMAK VE VERSION GECISLI KURULUM

On By semt20In LOGO ERP, MOBILESALES, SqlLeave a comment

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