ra.sql

来自「一个用VB写的财务软件源码」· SQL 代码 · 共 62 行

CREATE TABLE [dbo].[TRA_ADDRESS] (
	[ID] [numeric](18, 0) NOT NULL ,
	[COMPANYCODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[COMPANYNAME] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CODE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ACCEPTADDRESS] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[USERNAME] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PASSWORD] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LINKMAN] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[TELEPHONE] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[FAX] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZIP] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[ADDRESS] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TRA_NATIVESETTING] (
	[ID] [numeric](18, 0) NOT NULL ,
	[SUBSYSID] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TRANSMODE] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NATIVEADDRESS] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[USERNAME] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PASSWORD] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FLAG] [numeric](18, 0) NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[TRA_TRANSSETTING] (
	[ID] [numeric](18, 0) NOT NULL ,
	[SUBSYSID] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TITLE] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ACCEPTCOMPANY] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CONTENT] [varchar] (3500) COLLATE Chinese_PRC_CI_AS NULL ,
	[FLAG] [numeric](18, 0) NOT NULL ,
	[LASTSENDDATE] [datetime] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[TRA_ADDRESS] WITH NOCHECK ADD 
	CONSTRAINT [PK_TRA_ADDRESS] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TRA_NATIVESETTING] WITH NOCHECK ADD 
	CONSTRAINT [DF_TRA_NATIVESETTING_FLAG] DEFAULT (0) FOR [FLAG],
	CONSTRAINT [PK_TRA_NATIVESETTING] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TRA_TRANSSETTING] WITH NOCHECK ADD 
	CONSTRAINT [DF_TRA_TRANSSETTING_FLAG] DEFAULT (0) FOR [FLAG],
	CONSTRAINT [PK_TRA_TRANSSETTING] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;