wbf_vault.sql

来自「一个非常好用的ADO封装类,程序员不再需要跟烦人的COM接口打交道,写数据库程序」· SQL 代码 · 共 25 行

/* 
CREATE DATABASE WBF_Vault
REM GO
*/

USE WBF_VAULT
GO

CREATE TABLE dbo.Accounts
  (
    AccountID nvarchar(32) PRIMARY KEY,
    Name nvarchar(255) NOT NULL,
    FileCode nvarchar(32) NOT NULL,
    Address text NOT NULL,
    Phone1 nvarchar(20) NOT NULL,
    Phone2 nvarchar(20) NOT NULL,
    Fax nvarchar(20) NOT NULL,
    Email nvarchar(20) NOT NULL,
    ProjectIDMask nvarchar(32) NOT NULL,
    ProjectFCMask nvarchar(32) NOT NULL,
    Created datetime NOT NULL,
    Note text NOT NULL
)
GO