https://www.cs.vassar.edu/ 2026-04-14T21:51:13+00:00 https://www.cs.vassar.edu/ https://www.cs.vassar.edu/_media/favicon.ico text/html 2008-06-02T16:25:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/research/ursi_2008/aiptasiabase/wiki1.7notes?rev=1212423953&do=diff Notes on MediaWiki 1.7 Database Storage * Every table starts with 'aiptasia_' Hereafter I will leave out the 'aiptasia' part. * User info stored in _user * All the main page text (past, present, and pre-built) is stored as a blob object in _text table. text/html 2008-06-06T22:26:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/research/ursi_2008/aiptasiabase/database?rev=1212791173&do=diff Database modifications Tool Structure * tl_name varchar(255) primaryKey The unique tool name with extension * tl_size int file size * tl_num_inputs tinyint number of possible inputs * tl_inputs varchar(255) dataType key of accepted input types comma separated, semicolon separated between num inputs text/html 2008-07-02T19:42:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/research/ursi_2008/aiptasiabase/security?rev=1215027720&do=diff Security Concerns There are many important things to be concerned about when creating a system like this, and security is one of them. From a systems administration point of view, the following things must be considered. Uploading Executables Allowing any user to upload and run any executable is TERRIFYING. This will require either auditing uploaded programs (and requiring uploaded programs to be sent in the form of source code to be compiled in-house), or carefully making sure that only trus…