📄 xt.sql

📁 一个用VB写的财务软件源码
💻 SQL
字号:
/****** Object:  Table [dbo].[TCON_DAITEM]    Script Date: 2003-5-30 15:37:58 ******/
CREATE TABLE [dbo].[TCON_DAITEM] (
	[cItmSysCoding] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cItmDaCoding] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcItmDaCaption] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcItmDaName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cItmDaEdition] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcItmSynosis] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dItmRemove] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_Account]    Script Date: 2003-5-30 15:37:59 ******/
CREATE TABLE [dbo].[tSYS_Account] (
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BeginYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BeginMonth] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Master] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[CurrencyName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[EnterName] [varchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TelCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zip] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[EMail] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[TaxNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Law] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[EconomyProperty] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[EnterType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[TradeID] [smallint] NOT NULL ,
	[VoucherPrintMode] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VoucherNumberMode] [smallint] NULL ,
	[SubjectOnFront] [smallint] NULL ,
	[SeparateChar] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[SeparateSubject] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_Auth]    Script Date: 2003-5-30 15:38:00 ******/
CREATE TABLE [dbo].[tSYS_Auth] (
	[AuthID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AuthName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[AuthMenuName] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[bEnd] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_Manage]    Script Date: 2003-5-30 15:38:00 ******/
CREATE TABLE [dbo].[tSYS_Manage] (
	[ID] [int] NOT NULL ,
	[ComputerName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SubSysID] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountYear] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[LoginDateTime] [datetime] NOT NULL ,
	[RunState] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[QuitDateTime] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_MutexInfo]    Script Date: 2003-5-30 15:38:00 ******/
CREATE TABLE [dbo].[tSYS_MutexInfo] (
	[SubSysID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AuthMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MutexSubSysID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MutexAuthMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_MutexObjectInfo]    Script Date: 2003-5-30 15:38:00 ******/
CREATE TABLE [dbo].[tSYS_MutexObjectInfo] (
	[SubSysID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AuthMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ObjectMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MutexSubSysID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MutexAuthMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MutexObjectMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_MutexObjectStatus]    Script Date: 2003-5-30 15:38:00 ******/
CREATE TABLE [dbo].[tSYS_MutexObjectStatus] (
	[IID] [int] NOT NULL ,
	[SubSysID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AuthMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ObjectMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ObjectStatus] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ObjectValue] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ComputerName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserID] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_MutexStatus]    Script Date: 2003-5-30 15:38:00 ******/
CREATE TABLE [dbo].[tSYS_MutexStatus] (
	[IID] [int] NOT NULL ,
	[SubSysID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AuthMenuName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ComputerName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserID] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_PZtype]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_PZtype] (
	[TypeID] [smallint] NOT NULL ,
	[SignID] [smallint] NOT NULL ,
	[Sign] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SignText] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_Period]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_Period] (
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Year] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PeriodID] [smallint] NOT NULL ,
	[FromDate] [datetime] NOT NULL ,
	[ToDate] [datetime] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_Register]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_Register] (
	[vcCustomerName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcAuthorizeNo] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcSerialNumber] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dtUpdate] [datetime] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_SubSys]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_SubSys] (
	[SubSysID] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SubSysName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_SubSysUsed]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_SubSysUsed] (
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SubSysID] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BeginYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BeginMonth] [smallint] NOT NULL ,
	[ModiYear] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[ModiMonth] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_Trade]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_Trade] (
	[ID] [smallint] NOT NULL ,
	[Name] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[NameEng] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_TradeCode]    Script Date: 2003-5-30 15:38:01 ******/
CREATE TABLE [dbo].[tSYS_TradeCode] (
	[TradeID] [smallint] NOT NULL ,
	[ClassName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassNameEng] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmmc] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmmcEng] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmjc] [smallint] NOT NULL ,
	[yefx] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IsEndkm] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_TradeCodeClass]    Script Date: 2003-5-30 15:38:02 ******/
CREATE TABLE [dbo].[tSYS_TradeCodeClass] (
	[TradeID] [smallint] NOT NULL ,
	[ClassSerial] [smallint] NOT NULL ,
	[ClassName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassNameEng] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[yefx] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_User]    Script Date: 2003-5-30 15:38:02 ******/
CREATE TABLE [dbo].[tSYS_User] (
	[UserID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserName] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[tiType] [smallint] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tSYS_UserAuth]    Script Date: 2003-5-30 15:38:02 ******/
CREATE TABLE [dbo].[tSYS_UserAuth] (
	[AccountID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AuthID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

create table [dbo].[TSYS_NAVIGATEMUSTER]
(
  [MODULEID] [smallint] not null,
  [MODULECAPTION] [VARCHAR](30),
  [BARID] [smallint] not null,
  [BARCAPTION] [VARCHAR](30) not null,
  [SUBMENUID] [VARCHAR](10) not null,
  [SUBMENUCAPTION] [VARCHAR](30) not null,
  [SUBMENUICONFILENAME] [VARCHAR](50) not null,
  [SUBMENUPROGRAMID] [VARCHAR](50) not null,
  [ISVISIBLE] [smallint] default -1
)
;
ALTER TABLE [dbo].[tSYS_Account] WITH NOCHECK ADD 
	CONSTRAINT [DF__tSYS_Acco__Vouch__77BFCB91] DEFAULT ((-1)) FOR [VoucherNumberMode],
	CONSTRAINT [DF__tSYS_Acco__Subje__78B3EFCA] DEFAULT (0) FOR [SubjectOnFront],
	CONSTRAINT [DF__tSYS_Acco__Separ__79A81403] DEFAULT (0) FOR [SeparateChar],
	CONSTRAINT [DF__tSYS_Acco__Separ__7A9C383C] DEFAULT (0) FOR [SeparateSubject],
	 PRIMARY KEY  CLUSTERED 
	(
		[AccountID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_Auth] WITH NOCHECK ADD 
	CONSTRAINT [DF__tSYS_Auth__bEnd__0BC6C43E] DEFAULT (0) FOR [bEnd],
	 PRIMARY KEY  CLUSTERED 
	(
		[AuthID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_Manage] WITH NOCHECK ADD 
	CONSTRAINT [DF__tSYS_Mana__RunSt__1273C1CD] DEFAULT ('正常') FOR [RunState],
	 PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_MutexInfo] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_MutexInfo] PRIMARY KEY  CLUSTERED 
	(
		[SubSysID],
		[AuthMenuName],
		[MutexSubSysID],
		[MutexAuthMenuName]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_MutexObjectInfo] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_MutexObjectInfo] PRIMARY KEY  CLUSTERED 
	(
		[SubSysID],
		[AuthMenuName],
		[ObjectMenuName],
		[MutexSubSysID],
		[MutexAuthMenuName],
		[MutexObjectMenuName]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_MutexObjectStatus] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[IID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_MutexStatus] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[IID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_PZtype] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_PZtype] PRIMARY KEY  NONCLUSTERED 
	(
		[TypeID],
		[SignID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_Period] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_Period] PRIMARY KEY  NONCLUSTERED 
	(
		[AccountID],
		[Year],
		[PeriodID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_SubSys] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[SubSysID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_SubSysUsed] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_SubSysUsed] PRIMARY KEY  NONCLUSTERED 
	(
		[AccountID],
		[SubSysID]
	)  ON [PRIMARY] 
;

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

ALTER TABLE [dbo].[tSYS_TradeCode] WITH NOCHECK ADD 
	CONSTRAINT [DF__tSYS_Trad__IsEnd__060DEAE8] DEFAULT (0) FOR [IsEndkm],
	CONSTRAINT [PK_SYS_TradeCode] PRIMARY KEY  NONCLUSTERED 
	(
		[TradeID],
		[kmdm]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_TradeCodeClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_TradeCodeClass] PRIMARY KEY  NONCLUSTERED 
	(
		[TradeID],
		[ClassSerial]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_User] WITH NOCHECK ADD 
	 PRIMARY KEY  CLUSTERED 
	(
		[UserID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tSYS_UserAuth] WITH NOCHECK ADD 
	CONSTRAINT [PK_SYS_UserAuth] PRIMARY KEY  NONCLUSTERED 
	(
		[AccountID],
		[UserID],
		[AuthID]
	)  ON [PRIMARY] 
;

 /* 以下两个表用于授权和站点控制  yigang 2003-08-27 */ 
 CREATE TABLE tSys_StationInfo 
    (SystemID  CHAR(40) not null,
     Pcid  CHAR(40) not null, 
     PcName  CHAR(100) ,
     LoginDate CHAR(8) not null 
    );
 ALTER TABLE tSys_StationInfo ADD constraint YKCWSYSDB_KEY primary key (SystemID,Pcid);
 
 CREATE TABLE TSYS_SYSTEM 
    (SERIALNUMBER VARCHAR(30) ,
     Enterprise VARCHAR(100),
     LICENCE VARCHAR(20),
     DBVAR VARCHAR(10)
    );
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -