james af47f30aeb Fix special award nominations to work with "-1" special award (i dont want to nomiiated for special awradsa)		2011-03-04 19:21:30 +00:00
..
db_update.php	Dennis. Changes allow 'installation' in windows servers (and others) Complete functionality in windows servers still 'in work'	2011-02-22 21:54:34 +00:00
db.code.version.txt	Fix special award nominations to work with "-1" special award (i dont want to nomiiated for special awradsa)	2011-03-04 19:21:30 +00:00
db.full.6.sql	Add the full database structure for db version 6	2005-05-26 20:32:42 +00:00
db.full.7.sql	whoops, the code for the fairmanager was messed up - should be fixed now	2005-06-07 21:36:07 +00:00
db.full.8.sql	Add the full 8 database version for installations to use	2005-11-22 14:21:53 +00:00
db.full.9.sql	Whoops! Rollback to 0.9.4 and fix the bug in the full.9.sql so the installer will work again! I'll need to repackage...	2005-12-15 15:53:37 +00:00
db.full.11.sql	Bump version number to 0.9.6	2006-01-16 05:21:52 +00:00
db.full.12.sql	add full version 12 database	2006-01-20 19:58:06 +00:00
db.full.13.sql	Add full db.13 file, and bump version number to 1.0.0	2006-02-02 02:59:12 +00:00
db.full.16.sql	Add full 16 and 17 and update for 17	2006-03-08 21:21:20 +00:00
db.full.17.sql	Add full 16 and 17 and update for 17	2006-03-08 21:21:20 +00:00
db.full.18.sql	Fix the broken sql script, looks like the 'questions' inserts were pasted in the middle of another query!	2006-07-24 16:07:54 +00:00
db.full.22.sql	Add full db 22 file	2006-09-04 15:42:34 +00:00
db.full.52.sql	Add FULL db.52 file, dumped directly from phpMyAdmin	2007-10-09 19:26:13 +00:00
db.full.148.sql	Add a FULL DB 148 version, so we dont need to upgrade from 52 everytime anymore!	2009-10-22 17:00:07 +00:00
db.full.175.sql	Recommit 175 FULL due to missing 174 php	2010-06-09 16:51:49 +00:00
db.update.1.sql	add the database updater code, and always ensure that the code and db are running the same version	2005-03-10 17:28:15 +00:00
db.update.2.sql	add the database updater code, and always ensure that the code and db are running the same version	2005-03-10 17:28:15 +00:00
db.update.3.sql	hmm this didnt get committeed	2005-03-29 19:56:42 +00:00
db.update.4.sql	lots more db changes	2005-04-19 19:22:38 +00:00
db.update.5.sql	enter winning projects	2005-05-04 21:23:00 +00:00
db.update.6.sql	whoops last messgae should hav ebeen : add schools management	2005-05-13 17:36:29 +00:00
db.update.7.sql	whoops, the code for the fairmanager was messed up - should be fixed now	2005-06-07 21:36:07 +00:00
db.update.8.sql	wow i scrwered this one up :) this should work now	2005-11-21 21:00:31 +00:00
db.update.9.sql	Add the judge inviter to the judge administration section	2005-11-25 21:15:29 +00:00
db.update.10.sql	Bug and Typo fixes are per John Meskes	2005-12-15 22:28:04 +00:00
db.update.11.sql	Whoops, fix the bugs in the db update file, it should import properly now.	2006-01-03 02:17:30 +00:00
db.update.12.sql	Update translation manager to work with unlimited number of languages as defined in the languages table	2006-01-19 17:15:07 +00:00
db.update.13.sql	Merge Jamie's changes from Peterborough, allowing different divisions to be available to the different age categories. -- default is 'no'	2006-02-01 16:29:08 +00:00
db.update.14.sql	Add a configuration option to specify whether to collect 'personal' information about the students, such as address, phone number, date of birth, etc.	2006-02-05 21:39:32 +00:00
db.update.15.sql	switch the new database stuff to DB16 instead of 15, and bump the required db number	2006-02-24 17:52:04 +00:00
db.update.16.sql	switch the new database stuff to DB16 instead of 15, and bump the required db number	2006-02-24 17:52:04 +00:00
db.update.17.sql	Bug #0000056 - Change variable wording of filterdivisionbycategory	2006-03-09 13:15:34 +00:00
db.update.18.sql	switch year unsigned int (10) to year int (11) so year's of -1 (defaults) will work.	2006-07-12 14:45:53 +00:00
db.update.19.sql	Properly rollover the schools, allow 'lastlogin' to be NULL	2006-07-26 14:51:30 +00:00
db.update.20.sql	The new judge scheduler.	2006-08-01 19:43:15 +00:00
db.update.21.sql	Split the Configuration Variables page into separate 'Category' pages	2006-08-11 18:53:10 +00:00
db.update.22.sql	Add support to choose what status a project must have to be used by the judge scheduler. Allows for any of open, payment pending or complete projects to be allowed.	2006-08-12 18:05:38 +00:00
db.update.23.sql	Replace "Sex" with "Gender", and allow the db field to be null, instead of defaulting to "male"	2006-09-04 16:28:28 +00:00
db.update.24.sql	Add the option to collect teacher signatures on the signature page	2006-09-18 19:33:48 +00:00
db.update.25.sql	Add a prize value field to award prizes, also add editor the the value, as well add editor for the contact position	2006-09-20 16:24:52 +00:00
db.update.26.sql	Add more school information to the schools database (school lanaguage, school level, principal and school email addresS)	2006-10-15 17:11:56 +00:00
db.update.27.sql	update database length of email field from 32 to 128	2006-10-15 20:42:02 +00:00
db.update.28.sql	Add salutation field to award contacts	2006-10-16 03:36:39 +00:00
db.update.29.sql	Commit the db.29 update	2006-10-20 05:06:06 +00:00
db.update.30.sql	Update database for the language pack installer system to work properly	2006-10-25 16:35:16 +00:00
db.update.31.sql	Add db update 31 to fix any fairs that have rolled over their config variables using 2.0.0.. it is essentially the same db updates as db.21 that re-categorizes the variables.	2006-10-30 20:11:27 +00:00
db.update.32.sql	Add a configurable character limit on project title length, default is 100 characters	2006-12-06 18:22:31 +00:00
db.update.33.sql	Add new participnt registration type: openorinvite - allows you to use the system as if it was OPEN or INVITE however limits cannot be imposed in the inviter since when its reached in the inviter it could easily be bypassed by registering through the 'open' way.	2007-01-02 23:38:53 +00:00
db.update.34.sql	update add 2 missing columns to config.	2007-01-10 05:12:36 +00:00
db.update.35.sql	- Fix an issue with the default import of judging questions	2007-01-16 19:32:40 +00:00
db.update.36.sql	- Add location and contact info for each tour. Dump this in the CSV dump of	2007-01-20 08:10:26 +00:00
db.update.37.sql	- Add a type field to each config variable. The type field is used to tell the	2007-01-20 22:23:44 +00:00
db.update.38.sql	- Properly copy the config type in the config editor when copying -1 config values into	2007-01-21 01:40:46 +00:00
db.update.39.sql	- Add a new config variable 'specialawardnomination_aftersignatures'.	2007-01-21 05:45:36 +00:00
db.update.40.sql	- Move the judging age preferences to the expertise page... and rename that	2007-01-30 06:12:11 +00:00
db.update.41.sql	- Add a 4th text section to the signature page (of course, it's optional, and	2007-01-31 00:48:24 +00:00
db.update.42.sql	- Add a config option (default 'no') to ask the students for a pronunciation	2007-01-31 07:35:08 +00:00
db.update.43.sql	Fix text on one configuration variable	2007-02-21 20:42:48 +00:00
db.update.44.sql	- Fix the name of the generate project number function	2007-03-05 04:27:44 +00:00
db.update.45.sql	- Add a new student report generator	2007-03-18 07:10:54 +00:00
db.update.46.sql	- How did that ';' get in there ?	2007-03-18 23:54:35 +00:00
db.update.47.sql	- Turn off table label boxes by default	2007-03-26 16:55:45 +00:00
db.update.48.sql	- BAM!	2007-03-26 06:15:41 +00:00
db.update.49.sql	- Add a special awards feature (off by default) to the judge scheduler. It:	2007-03-28 06:16:41 +00:00
db.update.50.sql	Implement web consent restrictions, settable by the admin (under the admin->participant registration menu) to prevent firstname and or lastname (and or photos once they are implemented) of students, on a per studnet basis, from being displayed on the website. It currently affects the confirmed participants page, and the winners page (the only two public places where sutdent info is available thorugh the system)	2007-03-31 01:10:08 +00:00
db.update.51.sql	- Update database for schools report query.	2007-09-13 19:18:18 +00:00
db.update.52.sql	Fix the config variables rollover/install for the type and type_values fields	2007-10-01 18:51:56 +00:00
db.update.53.sql	LOL, dont use my address as the FROM!	2007-10-29 20:25:25 +00:00
db.update.54.sql	Add document manager, and update tableeditor to allow setting of a downloadlink for documents	2007-10-31 20:00:23 +00:00
db.update.55.sql	move the wording on the judges "invitaion only" screen into the page text editor so the fairs can make it say whatever they want it to say.	2007-10-31 20:31:00 +00:00
db.update.56.sql	- Database update. Add the users, users_volunteer, and users_committee table	2007-11-12 22:45:41 +00:00
db.update.57.sql	Clarify what project_num_format config variable is	2007-11-13 20:15:36 +00:00
db.update.58.sql	Ahh found the encoding problem, need to set the charset on the command line mysql --defualt-character-set when running INSTALL or DBUPDATE scripts.	2007-11-15 20:45:19 +00:00
db.update.59.sql	Oops dont change an update file thats already been applied, make a new one!	2007-11-15 20:47:20 +00:00
db.update.60.sql	Add 'emailcontact' field to registrations table, that SCHOOLINVITE teachers can put their own email address into to receive emails that would normally go to the students. If the students email is valid the student will still get the emails as well.	2007-11-15 21:17:20 +00:00
db.update.61.sql	Add missing semicolon which prevented the last two queries from happening	2007-11-16 16:46:57 +00:00
db.update.62.php	PHP 5.3 DEPRECATED split() so, convert all split()'s to explode()'s	2010-09-10 19:38:56 +00:00
db.update.62.sql	- Fix login check for an expired password	2007-11-17 21:59:59 +00:00
db.update.63.sql	- Fix login check for an expired password	2007-11-17 21:59:59 +00:00
db.update.64.sql	- Add a system_report_id field to the reports, and set it to the reports.id	2007-11-21 21:21:10 +00:00
db.update.65.sql	Add trophy selection (student keeper, student return, school keeper, school return) to prizes	2007-11-23 21:21:37 +00:00
db.update.66.sql	Add award source configuration	2007-11-23 22:07:55 +00:00
db.update.67.sql	- Add a multiselect option to the config editor	2007-11-25 23:30:51 +00:00
db.update.68.sql	- Change the user editor, read the fields and required fields from a config	2007-11-26 02:28:45 +00:00
db.update.69.sql	Update fake scripts for 2008	2007-11-27 22:47:06 +00:00
db.update.70.sql	Dont check CURL support inside the loop and dont allow checking to be called without CURL support	2007-11-28 18:46:32 +00:00
db.update.71.sql	Add enabled and website (for help) to external sources	2007-11-29 18:38:06 +00:00
db.update.72.sql	- Add a new school report to list ALL schools (name, address, contact, and phone).	2007-12-03 22:04:06 +00:00
db.update.73.sql	- Add a schools access code report to the database	2007-12-07 23:58:51 +00:00
db.update.74.sql	Add the email address to the new participant email	2007-12-09 21:06:55 +00:00
db.update.75.php	- Query the proper report id using the system_report_id, instead of inserting	2007-12-10 17:40:34 +00:00
db.update.75.sql	- Implement "My Reports". Committee members (with admin access, because	2007-12-10 02:50:53 +00:00
db.update.76.php	- Fix multirole creation. If a user tries to create an account, and they	2007-12-12 03:01:44 +00:00
db.update.77.sql	Fix dave's broken database code	2007-12-12 18:29:51 +00:00
db.update.78.sql	switch the stock entries in the database if anything's usign the old values	2007-12-13 17:10:11 +00:00
db.update.79.sql	- Add a year field to the users db, we'll need it eventually	2007-12-13 18:09:22 +00:00
db.update.80.sql	Bump version for development 2.1.7	2007-12-13 19:52:27 +00:00
db.update.81.php	- Select the first contact for each sponsor as the primary	2007-12-13 21:50:31 +00:00
db.update.81.sql	- Add a primary contact field to the award contacts	2007-12-13 21:23:29 +00:00
db.update.82.sql	Add support to omit unawarded awards and prizes from the awards ceremony script. Resolves RFE 136.	2007-12-17 17:35:19 +00:00
db.update.83.sql	Add support for a minimum number of words in the project description. Resolves RFE 162.	2007-12-17 18:19:08 +00:00
db.update.84.sql	- Sneak in a change to the report tables, we're going to create tour reports	2007-12-19 21:16:58 +00:00
db.update.85.sql	- Add a tour number to the database, and modify the tour editor to include the	2007-12-20 01:05:04 +00:00
db.update.86.sql	- Fix report stock when the report stock keys were updated	2007-12-20 09:25:43 +00:00
db.update.87.php	- Change the password expiry mechanism to always check	2007-12-21 08:38:13 +00:00
db.update.87.sql	- Change the password expiry mechanism to always check	2007-12-21 08:38:13 +00:00
db.update.88.sql	- Add a config option to disable printing the cash/scholarship amount on the	2007-12-22 05:11:42 +00:00
db.update.89.sql	- Add the database stuff for the name check.. oops.	2007-12-22 23:44:46 +00:00
db.update.90.sql	- Fix the db update	2007-12-23 01:52:18 +00:00
db.update.91.sql	- Replace reports_acpresentation with a report from the report generator.	2007-12-25 05:13:42 +00:00
db.update.92.sql	- Also add the database update :)	2007-12-29 08:47:53 +00:00
db.update.93.sql	- Change the volunteer position description/meet_place colums to text from	2007-12-29 19:43:56 +00:00
db.update.94.sql	- Add a grade column that uses the format "Grade x", instead of just the	2007-12-30 21:20:36 +00:00
db.update.95.sql	- Add a filter to the last commit, to not show the none tshirts.	2007-12-30 22:16:34 +00:00
db.update.96.sql	Add the schoolaccess page to the page text editor	2008-01-22 19:22:51 +00:00
db.update.97.sql	- Typo in the ordering	2008-01-23 06:02:10 +00:00
db.update.98.sql	- Add a registration fee item editor	2008-01-23 07:53:10 +00:00
db.update.99.sql	- Fix drawing label boxes around text items	2008-01-23 18:32:31 +00:00
db.update.100.sql	- Report to export school CSV data in the format used by the CSV importer	2008-01-23 19:27:46 +00:00
db.update.101.sql	- More GVRSF stuff that I missed. Add two fields to the award_awards:	2008-01-24 07:46:12 +00:00
db.update.102.sql	- Fix the paper type in system report 44	2008-01-25 05:31:27 +00:00
db.update.103.sql	- Add number checking (and parsing) to the config editor	2008-01-28 21:48:44 +00:00
db.update.104.sql	- Add First Aid and CPR data collection to the user table.	2008-02-23 03:28:43 +00:00
db.update.105.sql	- Add judge_scheduler_activity and judge_scheduler_percent to the config, if	2008-02-28 20:03:48 +00:00
db.update.106.sql	VERY important update to reports_items that dave must have missed.. took me THREE HOURS to track down why alignment wasnt being saved from the report editor!	2008-03-27 06:22:11 +00:00
db.update.107.sql	Oops and add the db update for the new config options	2008-07-16 17:24:19 +00:00
db.update.108.sql	Migrate css to a theme and setup to allow multiple themes	2008-07-24 16:20:16 +00:00
db.update.109.sql	Update the database to store the page texts in multiple languages	2008-08-18 21:09:12 +00:00
db.update.110.sql	Create a Localization Category for config variables, and move the Province/State, Postal/Zip there	2008-08-18 21:33:30 +00:00
db.update.111.php	If there's no entry for the current fairyear, insert the default entry	2008-08-22 17:11:20 +00:00
db.update.111.sql	Add cms table, and move the 'index' pagetext to cms	2008-08-19 21:13:29 +00:00
db.update.112.sql	Use page text description instead of the database page text name on the page text editor list. (BUG 198)	2008-08-26 21:06:05 +00:00
db.update.113.sql	Add countries table and populate	2008-08-28 21:41:31 +00:00
db.update.114.sql	- One more quick fix, make it "special award only", instead of "awards",	2008-09-15 15:46:22 +00:00
db.update.115.sql	Fix Quebec province translation so its country code is properly set.	2008-10-06 18:50:18 +00:00
db.update.116.php	Only foreach if something exists	2009-11-02 18:45:22 +00:00
db.update.116.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.117.php	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.117.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.118.php	HOpefully fix the 118 update to convert sponsor_contacts to users_sponsor	2009-10-20 19:40:55 +00:00
db.update.118.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.119.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.120.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.121.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.122.php	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.122.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.123.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.124.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.125.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.126.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.127.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.128.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.129.php	Switch 129 update to use the new db129 functions	2009-10-22 16:20:17 +00:00
db.update.129.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.129.user.inc.php	PHP 5.3 DEPRECATED split() so, convert all split()'s to explode()'s	2010-09-10 19:38:56 +00:00
db.update.130.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
db.update.131.php	Update 131 update to properly create the sponsorship logs and award donations for past years	2009-10-22 16:46:32 +00:00
db.update.131.sql	Fix 131	2009-09-09 02:38:57 +00:00
db.update.132.sql	- Database update for feeder fair award info	2009-09-13 07:08:12 +00:00
db.update.133.sql	- Selection screen to select what stats to download from feeder fairs	2009-09-17 07:00:09 +00:00
db.update.134.sql	- Change the report name to be consistent with other naming	2009-09-18 05:37:21 +00:00
db.update.135.sql	Make sponsorships table able to handle either an organization sponsor (linked to sponsors) or an individual sponsor (linked to users)	2009-09-18 15:12:10 +00:00
db.update.136.php	- Rename YSF to YSC	2009-09-19 06:12:48 +00:00
db.update.136.sql	- For the first time probably ever, DELETE a config variable :O	2009-09-19 06:53:49 +00:00
db.update.137.sql	- Server-side award uploading. Tag registrations, proejcts, and students with	2009-09-21 07:20:49 +00:00
db.update.138.sql	- Turn the uploader into a popup window	2009-09-23 05:53:33 +00:00
db.update.139.sql	- Add two more fields:	2009-09-25 04:29:41 +00:00
db.update.140.sql	- do it properly	2009-09-27 08:43:36 +00:00
db.update.141.sql	Fix broken db update	2009-10-14 20:34:13 +00:00
db.update.142.php	Oops commit the db files too	2009-10-02 17:24:53 +00:00
db.update.142.sql	Oops commit the db files too	2009-10-02 17:24:53 +00:00
db.update.143.sql	Update default fundraising goals, and insert defaults if none exist	2009-10-06 19:04:45 +00:00
db.update.144.sql	Updated fundraising_campaigns table to use "fundraising_goal" field instead of "fundraising_goal_id"	2009-10-06 20:49:37 +00:00
db.update.145.sql	Database updates	2009-10-08 19:20:07 +00:00
db.update.146.php	PHP 5.3 DEPRECATED split() so, convert all split()'s to explode()'s	2010-09-10 19:38:56 +00:00
db.update.146.sql	- commit all outstanding changes	2009-10-14 19:53:09 +00:00
db.update.146.user.inc.php	PHP 5.3 DEPRECATED split() so, convert all split()'s to explode()'s	2010-09-10 19:38:56 +00:00
db.update.147.sql	- Enable maxyear user filtering. unfortunately it needs to be specified	2009-10-16 18:39:39 +00:00
db.update.148.sql	Add todo list for receipts and database to track receipts	2009-10-20 19:09:54 +00:00
db.update.149.php	Of course, we cant re-use the old one, due to function name collisions, DUH! what the hell was i thinking, i just went through this.	2009-10-22 20:46:12 +00:00
db.update.149.sql	Add a 149 update script to convert emergency contacts to parents	2009-10-22 19:54:53 +00:00
db.update.149.user.inc.php	PHP 5.3 DEPRECATED split() so, convert all split()'s to explode()'s	2010-09-10 19:38:56 +00:00
db.update.150.sql	- These are fair-specific now, dont' need them as config options.	2009-11-06 02:11:58 +00:00
db.update.151.sql	Fix broken 151 db update	2009-11-13 21:25:40 +00:00
db.update.152.sql	Add all the missing judge registration fields, and let them be configurable.	2009-11-26 17:50:00 +00:00
db.update.153.sql	Working email sending from fundraising module, and implement new emailqueue system. None of the existing emails are migrated to the new system yet, and both old and new work in parallel until we can finish migration	2009-12-01 22:02:03 +00:00
db.update.154.sql	Completely convert the old communication module over to the new system... (almost).	2009-12-02 22:17:20 +00:00
db.update.155.php	Set the database charset in the UPDATE script so the conversions will actually work - that only took 8 hours to figure out!	2009-12-03 20:55:16 +00:00
db.update.155.sql	Set the database charset in the UPDATE script so the conversions will actually work - that only took 8 hours to figure out!	2009-12-03 20:55:16 +00:00
db.update.156.sql	Change projects.projectdivisions_id and project.projectcategories_id from TINYINT to INT so they match what is allowed in the division and category configuration	2010-01-22 04:03:02 +00:00
db.update.157.sql	Add a 'per_fair' option to the awards, so an award can be treated as a	2010-01-27 20:24:17 +00:00
db.update.158.sql	Remove the typepref selection, it turned into	2010-02-02 17:48:59 +00:00
db.update.159.sql	Fix judge invite only text on user_new to actually show up	2010-02-03 00:30:24 +00:00
db.update.160.sql	Support Highest, High, Indiffernt (short and long), and expertise 5,4,3	2010-02-04 17:55:07 +00:00
db.update.161.sql	Add another missing semi-colon	2011-02-21 21:40:52 +00:00
db.update.162.sql	Add ability to cancel emails in the queue to be sent	2010-02-11 15:58:26 +00:00
db.update.163.sql	Remove config->external award sources from CONFIG	2010-02-12 16:48:45 +00:00
db.update.164.sql	If anyones emails are still set to come from 'website@sfiab.ca' wipe that out, which will force it to default to the fair manager's email address when sending - we dont want anything coming from that address!	2010-02-18 16:13:36 +00:00
db.update.165.sql	Database table for computing floor locations	2010-02-22 18:45:55 +00:00
db.update.166.sql	Some fairs did a rollvoer before the NULL was fixed (I think it was	2010-02-22 18:45:57 +00:00
db.update.167.sql	Aparently some emails use "webmaster@sfiab.ca" -- wipe that out as well to force them to set a proper from address or use the fair manager's email	2010-03-02 20:18:39 +00:00
db.update.168.sql	And finally, update the db, which resyncs my git to svn HEAD. :)	2010-03-02 22:55:51 +00:00
db.update.169.sql	typo	2010-03-25 04:36:47 +00:00
db.update.170.sql	set enable_stats to 'no' for YSO	2010-03-30 17:03:58 +00:00
db.update.171.sql	Add a new date 'judge schedule available' to specify when judge assignments and schedules become available to judges. When the chief judge is playing with the scheduler he doesnt want to have judges thinkign they are assigned to their final teams/projects/timeslots, so only make them available to judges after this date has passed.	2010-04-06 14:29:50 +00:00
db.update.172.sql	Sneak in one more update to 172	2010-06-03 19:29:31 +00:00
db.update.173.php	Added a command at the end to switch the character encoding for the entire database	2010-06-10 19:09:00 +00:00
db.update.173.sql	Added updates for converting from Latin1 to utf8 character encoding	2010-06-04 20:23:59 +00:00
db.update.174.php	Missing file, that's why it wasn't converting properly	2010-06-09 16:45:51 +00:00
db.update.174.sql	Convert labels to new format and millimeters. Drop now-unused columns	2010-06-08 18:49:21 +00:00
db.update.175.php	Implement fair name/logo as fields in a report instead of special	2010-06-09 07:43:59 +00:00
db.update.175.sql	Implement fair name/logo as fields in a report instead of special	2010-06-09 07:43:59 +00:00
db.update.176.sql	Oops, remove teh database name from the db update on create table	2010-06-11 20:27:53 +00:00
db.update.177.sql	add specific character encoding	2010-06-10 20:37:49 +00:00
db.update.178.sql	Oops, remove teh database name from the db update on create table	2010-06-11 20:27:53 +00:00
db.update.179.sql	school management partially updated	2010-06-10 22:10:20 +00:00
db.update.180.sql	Added team management for SOIAB. Minor typo correction in conferences.php	2010-06-14 18:30:39 +00:00
db.update.181.sql	add event types	2010-06-14 19:25:49 +00:00
db.update.182.sql	Modified events table to filter properly by event and handle URLs properly	2010-06-14 19:43:10 +00:00
db.update.183.sql	Add a title field and default it to the event name (lets them do things like "Compound Boggle #1" and "Compound Boggle #2"	2010-06-14 20:37:31 +00:00
db.update.184.sql	Add schedule view for school access, allow schools to register teams for events	2010-06-15 21:43:21 +00:00
db.update.185.sql	Added conferences_id to the so_teams table and updated corresponding code accordingly	2010-06-16 15:16:25 +00:00
db.update.186.sql	D'OH	2010-06-17 15:11:59 +00:00
db.update.187.sql	Oops fix my missing semicolon now	2010-06-17 15:14:36 +00:00
db.update.188.php	Updates and cleanups to the installer	2010-07-05 19:37:24 +00:00
db.update.188.sql	Create science fair conferences for all past years that the system knows about	2010-06-17 20:03:45 +00:00
db.update.189.sql	DB table for linking users to teams in events	2010-06-22 14:53:08 +00:00
db.update.190.php	Massive overhaul of the configuration variables	2010-06-22 21:32:03 +00:00
db.update.190.sql	Massive overhaul of the configuration variables	2010-06-22 21:32:03 +00:00
db.update.191.php	Migrate all dates to use conferences ONLY, instead of dual conference/FAIRYEAR setup	2010-06-23 16:06:01 +00:00
db.update.191.sql	Migrate all dates to use conferences ONLY, instead of dual conference/FAIRYEAR setup	2010-06-23 16:06:01 +00:00
db.update.192.sql	Use proper fieldname conventions	2010-06-23 19:58:33 +00:00
db.update.193.sql	Populating the roles table, add "superuser" field to the accounts table	2010-06-23 20:45:12 +00:00
db.update.194.sql	Add missing ; to 194	2011-02-21 16:22:29 +00:00
db.update.195.php	Fixes for issue with record id's	2010-07-14 18:30:04 +00:00
db.update.195.sql	Add missing ; to 194	2011-02-21 16:22:29 +00:00
db.update.196.sql	Put update 196 back in after dave somehow removed it?!	2010-07-13 13:40:44 +00:00
db.update.197.php	Move db updates to 197	2010-07-13 03:30:07 +00:00
db.update.197.sql	Fix an update bug. The code needs to be run to set the conference ID	2010-07-13 04:25:00 +00:00
db.update.198.sql	Fix an update bug. The code needs to be run to set the conference ID	2010-07-13 04:25:00 +00:00
db.update.199.sql	Add an oid field to confrences so we know which conferences are the same	2010-07-13 05:20:37 +00:00
db.update.200.sql	make showing the winners link optional	2010-07-13 20:18:50 +00:00
db.update.201.sql	Start un-breaking all the broken UI navigation	2010-07-13 21:23:39 +00:00
db.update.202.sql	Add a field so we can record email->username linkage	2010-07-14 18:57:00 +00:00
db.update.203.sql	Updates to work with new user system. Also updated the committees_link table fieldname to use "accounts_id" instead of "users_uid" and updated code accordingly.	2010-07-14 21:04:50 +00:00
db.update.204.php	Fix one small issue with db update 204	2010-07-21 15:14:32 +00:00
db.update.204.sql	Adding conferences_id fields to judges tables. Will later drop the year fields	2010-07-15 21:18:36 +00:00
db.update.205.sql	Fix some user/account bugs	2010-07-27 19:06:36 +00:00
db.update.206.sql	Update rolestasks to be conference-type specific	2010-08-20 17:40:11 +00:00
db.update.207.sql	Change "pageid" and "NAV_PAGE_ID" to "navident" and "NAV_IDENT" and add the field to the database	2010-09-23 21:09:04 +00:00
db.update.208.sql	Add account registration and email address confirmation	2010-09-27 19:13:56 +00:00
db.update.209.php	Fix a typo	2010-10-05 19:45:28 +00:00
db.update.209.sql	migrate categories/divisions/subdivisions from FAIRYEAR to conferences_id	2010-10-05 19:43:30 +00:00
db.update.210.sql	Quick correction on automatic e-mail	2010-10-12 18:00:17 +00:00
db.update.211.sql	Added user settings config for science olympic judges	2010-10-13 21:01:01 +00:00
db.update.212.php	Updated volunteer preferences to work with the new interface and with the new conference id system	2010-10-14 14:10:49 +00:00
db.update.213.sql	fix schedule display boxes to be the same for FF/IE/Chrome	2010-10-14 15:11:52 +00:00
db.update.214.sql	Changed the scienceolympic judge settings to a generic activity selection tab (replacing so_judge_other.php with activities.php)	2010-10-14 15:26:47 +00:00
db.update.215.sql	Added teacher interface in olympics	2010-10-14 17:51:56 +00:00
db.update.216.php	Updated these tables to include the conference id:	2010-10-20 21:58:26 +00:00
db.update.217.php	Many updates of queries, switching from usage of FAIRYEAR to conference_id.	2010-11-01 15:24:59 +00:00
db.update.218.php	Adding conferences_id to the last two tables that need it	2010-11-02 16:24:04 +00:00
db.update.219.sql	A quick fix. The award_awards_table had the conferences_id set to 0 where the year was -1. Modified it to match.	2010-11-05 17:48:19 +00:00
db.update.220.sql	Altering tables projectdivisions, projectsubdivisions, and projectcategories, changing their primary keys from (year, id) to (conferences_id, id)	2010-11-10 19:25:46 +00:00
db.update.221.sql	Rewrote the installation script to deal with conferences	2010-11-10 23:05:24 +00:00
db.update.222.sql	Added the rollover for the fiscal year, and removed the rollover for the fair year	2010-11-18 16:38:12 +00:00
db.update.223.sql	Added an icon for conference management. Added fields in the config for teachers	2010-11-18 22:46:46 +00:00
db.update.224.sql	Add copyoriginal, copyparent, and notes(currently unused) to conferences table	2010-11-25 20:45:44 +00:00
db.update.225.sql	Add copyoriginal, copyparent, and notes(currently unused) to conferences table	2010-11-25 20:45:44 +00:00
db.update.226.sql	Added teacher abillity to add/remove students	2010-11-29 22:54:12 +00:00
db.update.227.sql	Added date of birth, food requriements, t-shirt size and medical alert info to the users table as student fields	2011-02-16 19:08:58 +00:00
db.update.228.sql	Added api functionality for creating and saving projects	2011-02-17 22:04:47 +00:00
db.update.229.sql	Added emergency contact info as an array member of the user object.	2011-02-22 20:52:54 +00:00
db.update.230.sql	Adding additional student fields to the users table	2011-02-24 17:44:12 +00:00
db.update.231.sql	Add two missing emails (for teachers and participants)	2011-03-02 06:26:33 +00:00
db.update.232.sql	Add page_text's for participant and teacher invite only	2011-03-02 06:41:14 +00:00
db.update.233.sql	Oosp actually put in the db update too	2011-03-03 17:39:14 +00:00
db.update.234.sql	add numstudents API to the project object	2011-03-04 01:05:15 +00:00
db.update.235.sql	Fix special award nominations to work with "-1" special award (i dont want to nomiiated for special awradsa)	2011-03-04 19:21:30 +00:00
db.update.999.sql	Merge all changes from branch r1284:1498 into trunk	2009-09-09 00:26:12 +00:00
FILES	Switch the database versioning code from a flat textfile (db/db.db.version.txt) to a record in the config table (var=DBVERSION, year=0)	2005-06-07 21:03:55 +00:00