tbl1_About_rp¶
- Description
This is the Solutions “About” table for the Request Portal application. Solutions will compare version numbers in this table with version numbers in the local tbl1_about_rp_local table in RequestPortalDashboard.accdb If version numbers do not match, the program will not be allowed to start up. Future Direction: It would be nice to have a single solutions “About” table with a field for the version number of each application, instead of all of these separate tables.
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
Version_Number varchar(255) DEFAULT NULL
- Description
data version number for this application
- Options
display="true", null="true", search="false", type=""
Release_Date datetime DEFAULT NULL
- Description
date latest version of this application was prepared
- Options
display="true", null="true", search="false", type=""
database_path varchar(255) DEFAULT NULL
- Description
obsolete?
- Options
display="true", null="true", search="false", type=""
database_name varchar(255) DEFAULT NULL
- Description
obsolete?
- Options
display="true", null="true", search="false", type=""
database_type varchar(255) DEFAULT NULL
- Description
obsolete? this was from when we had choice of MSAccess or MySQL
- Options
display="true", null="true", search="false", type=""
connection_string varchar(255) DEFAULT NULL
- Description
not used in data db; only in local about table.
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""
share_path varchar(255) DEFAULT NULL
- Description
this is from before solutions used MySQL. but not quite obsolete yet since SolutionsDashboard.accdb still uses this for images and docs subfolders.
- Options
display="true", null="true", search="false", type=""