History for sqlmarker / STINK_student_records
2013-12-12
• Clarified salaries for senior staff (closes #14).
Nigel Stanger committed on 12 Dec 2013
2013-09-19
Updated solution and comments for 2013 results.
Nigel Stanger committed on 19 Sep 2013
Added some optional constraints.
Nigel Stanger committed on 19 Sep 2013
2013-09-12
Changed the test values for rank and salary to avoid problems with clevel folks who restrict senior salaries to >$100000.
Nigel Stanger committed on 12 Sep 2013
2013-09-04
Added legal boundary values for Salary.
Nigel Stanger committed on 4 Sep 2013
2013-09-03
Added the ability to specify that a number column should include no length or decimal places.
Nigel Stanger committed on 3 Sep 2013
Added support for alternative true/false values in PHP, placeholders for them in XML, and a quick and dirty shell script to set them.
Nigel Stanger committed on 3 Sep 2013
Changed sample username to be the same as one in the fixture in order to show up any UNIQUE constraint.
Nigel Stanger committed on 3 Sep 2013
Added legal boundary values.
Nigel Stanger committed on 3 Sep 2013
Added legal boundary values.
Nigel Stanger committed on 3 Sep 2013
2013-09-02
Added default value testing.
Nigel Stanger committed on 2 Sep 2013
2013-08-30
Added legal values test.
Nigel Stanger committed on 30 Aug 2013
Inserted missing </table>.
Nigel Stanger committed on 30 Aug 2013
Added legal min/max values for relevant columns.
Nigel Stanger committed on 30 Aug 2013
Replaced overflow tests with underflow test.
Nigel Stanger committed on 30 Aug 2013
Fixed too-long legal values and added more illegal values.
Nigel Stanger committed on 30 Aug 2013
2013-08-01
Fixed inconsistencies with specification (especially Person.Username).
Nigel Stanger committed on 1 Aug 2013
2013-07-27
Enabled all tables.
Nigel Stanger committed on 27 Jul 2013
Rewrote all classes to match scenario. Also fixed some broken file names.
Nigel Stanger committed on 27 Jul 2013
2013-07-26
Tidied up the FKs in Staff and Student.
Nigel Stanger committed on 26 Jul 2013
Added initial test class files.
Nigel Stanger committed on 26 Jul 2013
Fixed a typo in one of the Staff constraint names.
Nigel Stanger committed on 26 Jul 2013
Added sample SQL schema.
Nigel Stanger committed on 26 Jul 2013
Updated sample answer schema.
Nigel Stanger committed on 26 Jul 2013
2013-07-24
Moved current assignment scenario file into its proper subdirectory.
Nigel Stanger committed on 24 Jul 2013