Creating an External SQL License Database for EDP Standalone

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDP > EDP Install, Configuration, Administration > EDP Install >

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: Standalone EDP 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

 

)