.. index:: tbl1_About_rp ============= tbl1_About_rp ============= .. default-role:: doc :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=""``