tbl1_about_300¶
- Description
This is the Solutions “About” table for the 300_checker application. Solutions will compare version numbers in this table with version numbers in the tbl1_about_300_local table in 300_checker.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=""
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=""
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=""
application_name varchar(255) DEFAULT NULL
- Description
Full name of application
- 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=""