Aaron: 1 revision imported: Hopefully full import

2023-06-21T00:25:40Z

1 revision imported: Hopefully full import

← Older revision	Revision as of 00:25, 21 June 2023
(No difference)

Aaron: Created page with "==Introduction== Scheduling system started off without dbs, the first db support added was just login support to provide some minimal security. The next db added was the Pool Lay..."

2012-09-09T00:17:38Z

Created page with "==Introduction== Scheduling system started off without dbs, the first db support added was just login support to provide some minimal security. The next db added was the Pool Lay..."

New page

==Introduction==
Scheduling system started off without dbs, the first db support added was just login support to provide some minimal security.
The next db added was the Pool Layout DB in Fall 2012 to add in support for larger pools using the much improved pool layout
system. Also in Fall 2012, added support for another database "sched". This db has several tables:
*tm - slightly manipulated version of the teams report exported from Rainier.
*ev - slightly manipulated version of the events report exported from Rainier.
*gm - This is a games table derived from the xml files that references tmid and evid keys from the tm and ev tables.

==Examples==
<pre>
sqlite> select tmid,name from tm where program = 'Goleta';
132|Team 01
133|Team 03
134|Team 04
135|Team 05
sqlite> select * from gm inner join ev on ev.evid=gm.evid inner join tm on gm.tmid1=tm.tmid or gm.tmid2=tm.tmid where tm.tmid='135';
493|135||262|3|1|11-12|10:10 AM-10:30 AM|262|Fall 2012|Goleta|Games|Sep 29, 2012|2012-09-29|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
496|135||262|3|2|11-12|10:35 AM-10:55 AM|262|Fall 2012|Goleta|Games|Sep 29, 2012|2012-09-29|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
499|135||266|3|1|11-12|10:10 AM-10:30 AM|266|Fall 2012|Goleta|Games|Oct 13, 2012|2012-10-13|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
502|135||266|3|2|11-12|10:35 AM-10:55 AM|266|Fall 2012|Goleta|Games|Oct 13, 2012|2012-10-13|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
505|135||272|3|1|11-12|10:10 AM-10:30 AM|272|Fall 2012|Goleta|Games|Nov 03, 2012|2012-11-03|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
508|135||272|3|2|11-12|10:35 AM-10:55 AM|272|Fall 2012|Goleta|Games|Nov 03, 2012|2012-11-03|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
2427|307|135|584|6|1||10:10 AM-10:30 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3||
2430|135|308|584|7|2||10:35 AM-10:55 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3||
2432|135|301|584|7|3||11:00 AM-11:20 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3||
2433|307|135|584|6|4||11:25 AM-11:45 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3||
3223|301|135|268|3|1||10:10 AM-10:30 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
3224|301|135|268|3|2||10:35 AM-10:55 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
3225|301|135|268|3|3||11:00 AM-11:20 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
3226|301|135|268|3|4||11:25 AM-11:45 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3||
4380|135|504|974|7|1||10:10 AM-10:30 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3||
4382|503|135|974|6|2||10:35 AM-10:55 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3||
4387|135|502|974|8|3||11:00 AM-11:20 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3||
4390|135|505|974|8|4||11:25 AM-11:45 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3||
<pre>

Scheduling-Databases - Revision history

Aaron: 1 revision imported: Hopefully full import

Aaron: Created page with "==Introduction== Scheduling system started off without dbs, the first db support added was just login support to provide some minimal security. The next db added was the Pool Lay..."