Edit D:\SQL20160530-20170910\16.10.27.28_0001_BASE_CUSTOMERS

Edit D:\SQL20160530-20170910\16.10.27.28_0001_BASE_CUSTOMERS_Add.sql

IF not EXISTS (SELECT * FROM sysobjects WHERE name = 'BASE_CUSTOMERS')
Begin
/****** Object:  Table [dbo].[BASE_CUSTOMERS]    Script Date: 10/27/2016 14:11:20 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[BASE_CUSTOMERS](
	[CUSTOMERID] [int] NOT NULL,
	[CARDNO] [int] NOT NULL,
	[CARDSN] [int] NOT NULL,
	[SCARDSNR] [varchar](15) NOT NULL,
	[OUTID] [varchar](18) NOT NULL,
	[STATUS] [int] NOT NULL,
	[OPENDT] [datetime] NOT NULL,
	[NOUSEDATE] [datetime] NULL,
	[PWD] [varchar](32) NOT NULL,
	[CARDFUNC] [int] NOT NULL,
	[CARDTYPE] [int] NOT NULL,
	[CARDSFID] [int] NULL,
	[CUSTDEPT] [varchar](60) NOT NULL,
	[EMPCODE] [varchar](30) NOT NULL,
	[NAME] [varchar](20) NOT NULL,
	[JPDM] [varchar](20) NULL,
	[NATION] [varchar](2) NULL,
	[SEX] [int] NOT NULL,
	[CERTIFICATEID] [int] NULL,
	[IDCARDNO] [varchar](18) NOT NULL,
	[SERVERID] [int] NOT NULL,
	[MEDICALTYPE] [int] NULL,
	[COUNTRY] [varchar](3) NULL,
	[REGSTARTYEAR] [int] NULL,
	[VER] [int] NOT NULL,
	[ISBIGFARECARD] [int] NOT NULL,
	[OddFare] [decimal](18, 0) NULL,
	[OPCount] [int] NULL,
	[BankCardno] [varchar](30) NULL,
	[QueryPwd] [varchar](32) NULL,
PRIMARY KEY CLUSTERED 
(
	[CUSTOMERID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'????????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BASE_CUSTOMERS'

END

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de