v007_to_v008.sql

来自「CRM源码This file describes some issues tha」· SQL 代码 · 共 25 行

CREATE TABLE dbo.QW_CUSTOMER (
	[qw_customerid] [int] NOT NULL,
	[qw_orgid] [int] NULL,
	[qw_firstname] [varchar] (100) NULL ,
	[qw_lastname] [varchar] (100) NULL ,
	[qw_fullname] [varchar] (255) NULL ,
	[qw_soundex] [varchar] (4) NULL ,
	[qw_title] [varchar] (40) NULL ,
	[qw_department] [varchar] (100) NULL ,
	[qw_mailstop] [varchar] (100) NULL ,
	[qw_phone] [varchar] (30) NULL ,
	[qw_altphone] [varchar] (30) NULL ,
	[qw_email] [varchar] (255) NULL ,
	[qw_fax] [varchar] (30) NULL ,
	[qw_notes] [text] NULL ,
	CONSTRAINT [pk_qw_customer] PRIMARY KEY CLUSTERED ([qw_customerid]) WITH FILLFACTOR = 80 ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT INTO QW_FIELDINFO (qw_tablename,qw_fieldinfo_type_id,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_address',7,14,2,'Mailing');
INSERT INTO QW_FIELDINFO (qw_tablename,qw_fieldinfo_type_id,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES ('qw_address',7,14,3,'Billing');

-- all new update scripts must include a line like this:
UPDATE QX_SYS_PROP SET PROP_VAL = '008' WHERE (PROP_ID = 'DB_APP_VERSION');