Creating an External SQL License Database for EDP Standalone

A separate database with a few ST_TABLES may be used for individuals using EQuIS Data Processor (EDP) and wanting to use network licensing. The database managing EDP product keys needs to contain the tables ST_LICENSE, ST_LICENSE_USE, ST_USER and ST_VERSION. It must be accessible by all workstations that will consume network licenses. The following SQL statements define the table structure required by EDP.

Note: EDP Standalone network licenses only work on Microsoft SQL Server databases.

The logins used in the license connection strings require the permissions indicated below for each table.

-- PERMISSIONS:

-- Adding licenses: SELECT/INSERT/UPDATE/DELETE

-- Using licenses: SELECT

CREATE TABLE st_license(

app_id int NOT NULL,

key_type int NOT NULL,

key_string varchar(25) NULL,

license_title varchar(255) NULL,

license_server varchar(255) NULL,

CONSTRAINT PK_st_license PRIMARY KEY ( app_id ASC, key_type ASC )

)

-- PERMISSIONS:

-- Adding licenses: SELECT/INSERT/UPDATE/DELETE

-- Using licenses: SELECT/INSERT/UPDATE/DELETE

CREATE TABLE st_license_use(

app_id int NOT NULL,

workstation varchar(128) NOT NULL,

user_name varchar(128) NULL,

license_checked_out datetime NULL,

license_expires datetime NULL,

checksum varchar(128) NULL

)

-- PERMISSIONS:

-- Adding licenses: None

-- Using licenses: None

CREATE TABLE st_user(

user_id int NOT NULL,

client_code char(4) NULL,

user_name varchar(128) NOT NULL,

password varchar(64) NOT NULL,

email_address varchar(100) NOT NULL,

ftp_location varchar(256) NULL,

notice_delivery_type varchar(12) NULL,

status_flag char(1) default ('A') NOT NULL,

auto_archive varchar(20) NULL,

first_name varchar(128) NULL,

last_name varchar(128) NULL,

comments varchar(512) NULL,

last_use_date datetime NULL,

last_host_address varchar(200) NULL,

facility_display varchar(5) NULL,

language_code varchar(5) NULL,

date_format varchar(20) NULL,

datetime_format varchar(30) NULL,

enterprise_code varchar(40) NULL,

last_facility_id int NULL,

CONSTRAINT PK__st_user PRIMARY KEY CLUSTERED (user_id ASC),

CONSTRAINT UQ_st_user_email_address UNIQUE NONCLUSTERED (email_address ASC),

CONSTRAINT UQ_st_user_user_name UNIQUE NONCLUSTERED (user_name ASC)

)

-- PERMISSIONS:

-- Adding licenses: SELECT

-- Using licenses: SELECT

CREATE TABLE st_version (

ver_date datetime NOT NULL,

ver_comment varchar(255) NOT NULL

)