Differences

This shows you the differences between two versions of the page.

--- groups:mxp:projectdb [2023/08/01 15:01] – cse-readx028
+++ groups:mxp:projectdb [2023/08/01 15:35] (current) – cse-sull0153
@@ Line 3: / Line 3: @@
 The database contains summaries of over 500 MXP projects going back to 1970. Data from Kurt's long-standing database was imported to MySQL running on a department server, and is accessed here using the [[https://www.dokuwiki.org/plugin:dbquery|DokuWiki dbquery Plugin]].
-<file html old-query.txt>
-<database2 mxp auth=oit-csemxp database=@mysql:host=mysql-prod5.oit.umn.edu;dbname=cse_mxp maydrop=!@ALL mayadmin=@admin,manager mayedit=@admin,manager,wick mayinsert=@webgrp_mxp maydelete=@webgrp_mxp,@admin,manager mayfilter=@ALL mayexport=@ALL mayprint=@ALL mayviewlog=@ALL sort=!ProjDate>
-IDPrimKey, integer, id, primary readonly
-ProjDate, date, Date, visible alwaysshow
-MXPCodeDescription, text, Category, required length=40 visible
-ProjName, text, Project Name, length=256 visible alwaysshow
-ProjDescription, text, Project Description, visible alwaysshow
-Students, text, Students, length=150 visible alwaysshow
-Student1, text, Student1, length=40
-Student2, text, Student2, length=40
-Student3, text, Student3, length=40
-RefMXP, text, Reference, length=5 visible alwaysshow
-ProjEqBuilt, text, ProjEqBuilt, length=256
-RepLocation, text, RepLocation, length=50 alwaysshow
-RefAIP, text, RefAIP, length=50
-ProjURL, URL, ProjURL, length=256 alwaysshow
-Notes, text, Notes, length=100 alwaysshow
-</database2>
-</file>