test generated column


ALTER TABLE Schedules ADD COLUMN Score INT GENERATED ALWAYS AS (Game1 + Game2 + Game3)

query executed successfully
Array ( [0] => Array ( [Sequence] => 12 [registration_date] => 2022-08-11 11:59:48 [Rank] => 017 [user_id] => 2090 [first_name] => Roy [last_name] => Wilson [user_phone] => 289-356-3013 [user_email] => mbepic@gmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 12 [Game3] => 4 [group_id] => 3 [Crt_ID] => 8 [time_id] => 1 [travel] => [Score] => 31 ) [1] => Array ( [Sequence] => 2 [registration_date] => 2022-08-12 20:55:18 [Rank] => 002 [user_id] => 2101 [first_name] => Dennis [last_name] => Carter [user_phone] => 647-977-2373 [user_email] => dwcarter@rogers.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 5 [group_id] => 1 [Crt_ID] => 7 [time_id] => 1 [travel] => [Score] => 35 ) [2] => Array ( [Sequence] => 9999 [registration_date] => 2022-08-13 20:20:56 [Rank] => 052 [user_id] => 2104 [first_name] => Doug [last_name] => Dey [user_phone] => 905-301-3636 [user_email] => Djdey1@yahoo.com [event_id] => 2744 [Game1] => 0 [Game2] => 0 [Game3] => 0 [group_id] => 99 [Crt_ID] => 99 [time_id] => 99 [travel] => [Score] => 0 ) [3] => Array ( [Sequence] => 36 [registration_date] => 2022-08-13 00:54:08 [Rank] => 064 [user_id] => 2106 [first_name] => Helen [last_name] => Hartai [user_phone] => 289-312-0733 [user_email] => helenhartai@gmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 15 [group_id] => 9 [Crt_ID] => 4 [time_id] => 2 [travel] => Zoli [Score] => 45 ) [4] => Array ( [Sequence] => 11 [registration_date] => 2022-08-13 00:41:46 [Rank] => 015 [user_id] => 2107 [first_name] => Zoli [last_name] => Hartai [user_phone] => 289-312-0733 [user_email] => zolhartai@gmail.com [event_id] => 2744 [Game1] => 10 [Game2] => 15 [Game3] => 4 [group_id] => 3 [Crt_ID] => 8 [time_id] => 1 [travel] => Zoli [Score] => 29 ) [5] => Array ( [Sequence] => 5 [registration_date] => 2022-08-11 01:03:50 [Rank] => 009 [user_id] => 2118 [first_name] => David [last_name] => Lam [user_phone] => 416-616-0277 [user_email] => davidbinglam@gmail.com [event_id] => 2744 [Game1] => 0 [Game2] => 15 [Game3] => 10 [group_id] => 2 [Crt_ID] => 4 [time_id] => 1 [travel] => Lam [Score] => 25 ) [6] => Array ( [Sequence] => 3 [registration_date] => 2022-08-12 11:10:49 [Rank] => 003 [user_id] => 2121 [first_name] => Peter [last_name] => Milovanovic [user_phone] => 416-882-8805 [user_email] => peter.milovanovic@rogers.com [event_id] => 2744 [Game1] => 11 [Game2] => 4 [Game3] => 5 [group_id] => 1 [Crt_ID] => 7 [time_id] => 1 [travel] => [Score] => 20 ) [7] => Array ( [Sequence] => 10 [registration_date] => 2022-08-13 01:23:52 [Rank] => 014 [user_id] => 2125 [first_name] => Cheryl [last_name] => Soo Hon [user_phone] => 289-500-6533 [user_email] => soohonc@hotmail.com [event_id] => 2744 [Game1] => 10 [Game2] => 12 [Game3] => 15 [group_id] => 3 [Crt_ID] => 8 [time_id] => 1 [travel] => Soo Hon [Score] => 37 ) [8] => Array ( [Sequence] => 22 [registration_date] => 2022-08-11 14:28:50 [Rank] => 033 [user_id] => 2128 [first_name] => Marv [last_name] => Wainberg [user_phone] => 905-477-7329 [user_email] => mwainberg60@rogers.com [event_id] => 2744 [Game1] => 5 [Game2] => 12 [Game3] => 14 [group_id] => 6 [Crt_ID] => 6 [time_id] => 1 [travel] => [Score] => 31 ) [9] => Array ( [Sequence] => 9 [registration_date] => 2022-08-11 23:35:10 [Rank] => 013 [user_id] => 2138 [first_name] => Gary [last_name] => Shienfield [user_phone] => 416-271-5076 [user_email] => gary.shienfield@gmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 15 [group_id] => 3 [Crt_ID] => 8 [time_id] => 1 [travel] => [Score] => 45 ) [10] => Array ( [Sequence] => 1 [registration_date] => 2022-08-12 02:50:45 [Rank] => 001 [user_id] => 2140 [first_name] => Ian [last_name] => Reodica [user_phone] => 647-409-0331 [user_email] => i_reodica@hotmail.com [event_id] => 2744 [Game1] => 11 [Game2] => 15 [Game3] => 15 [group_id] => 1 [Crt_ID] => 7 [time_id] => 1 [travel] => [Score] => 41 ) [11] => Array ( [Sequence] => 23 [registration_date] => 2022-08-10 15:37:31 [Rank] => 034 [user_id] => 2148 [first_name] => Heather [last_name] => Bergman [user_phone] => 416-788-4220 [user_email] => habergman@hotmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 14 [group_id] => 6 [Crt_ID] => 6 [time_id] => 1 [travel] => [Score] => 44 ) [12] => Array ( [Sequence] => 32 [registration_date] => 2022-08-11 11:24:06 [Rank] => 059 [user_id] => 2156 [first_name] => Michelle [last_name] => Penrose-Sinclair [user_phone] => 647-208-2260 [user_email] => michelle.sinclair@rogers.com [event_id] => 2744 [Game1] => 8 [Game2] => 15 [Game3] => 8 [group_id] => 8 [Crt_ID] => 8 [time_id] => 2 [travel] => [Score] => 31 ) [13] => Array ( [Sequence] => 25 [registration_date] => 2022-08-12 18:42:08 [Rank] => 036 [user_id] => 2158 [first_name] => Michelle [last_name] => Farwell [user_phone] => 416-454-5382 [user_email] => mfarwell444@hotmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 15 [group_id] => 7 [Crt_ID] => 6 [time_id] => 2 [travel] => [Score] => 45 ) [14] => Array ( [Sequence] => 24 [registration_date] => 2022-08-13 02:35:53 [Rank] => 035 [user_id] => 2163 [first_name] => Jeff [last_name] => Birchard [user_phone] => 905-642-2833 [user_email] => jeffbirchard1@gmail.com [event_id] => 2744 [Game1] => 5 [Game2] => 15 [Game3] => 15 [group_id] => 6 [Crt_ID] => 6 [time_id] => 1 [travel] => Birch [Score] => 35 ) [15] => Array ( [Sequence] => 27 [registration_date] => 2022-08-11 01:19:55 [Rank] => 044 [user_id] => 2164 [first_name] => Adele [last_name] => Birchard [user_phone] => 647-882-3639 [user_email] => abirchard@hotmail.ca [event_id] => 2744 [Game1] => 2 [Game2] => 6 [Game3] => 15 [group_id] => 7 [Crt_ID] => 6 [time_id] => 2 [travel] => Birch [Score] => 23 ) [16] => Array ( [Sequence] => 34 [registration_date] => 2022-08-11 11:51:32 [Rank] => 062 [user_id] => 2174 [first_name] => Marie [last_name] => Hewitt [user_phone] => 416-618-8563 [user_email] => mariehewitt.mba@gmail.com [event_id] => 2744 [Game1] => 8 [Game2] => 14 [Game3] => 15 [group_id] => 9 [Crt_ID] => 4 [time_id] => 2 [travel] => [Score] => 37 ) [17] => Array ( [Sequence] => 6 [registration_date] => 2022-08-13 02:36:26 [Rank] => 010 [user_id] => 2182 [first_name] => Kathy [last_name] => Rintoul [user_phone] => 416-606-8621 [user_email] => klrintoul@gmail.com [event_id] => 2744 [Game1] => 0 [Game2] => 9 [Game3] => 15 [group_id] => 2 [Crt_ID] => 4 [time_id] => 1 [travel] => [Score] => 24 ) [18] => Array ( [Sequence] => 21 [registration_date] => 2022-08-13 12:14:04 [Rank] => 032 [user_id] => 2189 [first_name] => Susan [last_name] => Bach [user_phone] => 416-409-2748 [user_email] => susanfbach@gmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 12 [Game3] => 15 [group_id] => 6 [Crt_ID] => 6 [time_id] => 1 [travel] => [Score] => 42 ) [19] => Array ( [Sequence] => 15 [registration_date] => 2022-08-10 08:32:26 [Rank] => 023 [user_id] => 2200 [first_name] => Peggy [last_name] => Wrightson [user_phone] => 416-903-8597 [user_email] => phwrightson@gmail.com [event_id] => 2744 [Game1] => 8 [Game2] => 11 [Game3] => 9 [group_id] => 4 [Crt_ID] => 3 [time_id] => 1 [travel] => gary [Score] => 28 ) [20] => Array ( [Sequence] => 19 [registration_date] => 2022-08-12 16:57:06 [Rank] => 030 [user_id] => 2225 [first_name] => Dave [last_name] => Dodds [user_phone] => 416-706-1490 [user_email] => Ddodds321@gmail.com [event_id] => 2744 [Game1] => 5 [Game2] => 15 [Game3] => 5 [group_id] => 5 [Crt_ID] => 3 [time_id] => 2 [travel] => [Score] => 25 ) [21] => Array ( [Sequence] => 20 [registration_date] => 2022-08-11 16:03:49 [Rank] => 031 [user_id] => 2231 [first_name] => Richard [last_name] => Tranquada [user_phone] => 905-479-7891 [user_email] => richard.tranquada@sympatico.ca [event_id] => 2744 [Game1] => 5 [Game2] => 9 [Game3] => 15 [group_id] => 5 [Crt_ID] => 3 [time_id] => 2 [travel] => Tran [Score] => 29 ) [22] => Array ( [Sequence] => 13 [registration_date] => 2022-08-12 15:10:09 [Rank] => 018 [user_id] => 2232 [first_name] => Gary [last_name] => Phillips [user_phone] => 905-235-4570 [user_email] => Phillips@bell.net [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 9 [group_id] => 4 [Crt_ID] => 3 [time_id] => 1 [travel] => gary [Score] => 39 ) [23] => Array ( [Sequence] => 28 [registration_date] => 2022-08-10 13:39:22 [Rank] => 045 [user_id] => 2237 [first_name] => Barbara [last_name] => Macphie [user_phone] => 416-399-4250 [user_email] => barbaramacphie@hotmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 6 [Game3] => 8 [group_id] => 7 [Crt_ID] => 6 [time_id] => 2 [travel] => [Score] => 29 ) [24] => Array ( [Sequence] => 14 [registration_date] => 2022-08-10 21:10:22 [Rank] => 021 [user_id] => 2242 [first_name] => Arthur [last_name] => Wright [user_phone] => 647-390-0213 [user_email] => cherie_wright@hotmail.com [event_id] => 2744 [Game1] => 8 [Game2] => 15 [Game3] => 15 [group_id] => 4 [Crt_ID] => 3 [time_id] => 1 [travel] => [Score] => 38 ) [25] => Array ( [Sequence] => 33 [registration_date] => 2022-08-12 19:31:14 [Rank] => 060 [user_id] => 2245 [first_name] => Ross [last_name] => Lehman [user_phone] => 905-251-2166 [user_email] => r.lehman@rogers.com [event_id] => 2744 [Game1] => 15 [Game2] => 14 [Game3] => 12 [group_id] => 9 [Crt_ID] => 4 [time_id] => 2 [travel] => [Score] => 41 ) [26] => Array ( [Sequence] => 26 [registration_date] => 2022-08-11 03:12:44 [Rank] => 039 [user_id] => 2251 [first_name] => Pat [last_name] => Borrelli [user_phone] => 416-399-4799 [user_email] => patborrelli.pb@gmail.com [event_id] => 2744 [Game1] => 2 [Game2] => 15 [Game3] => 8 [group_id] => 7 [Crt_ID] => 6 [time_id] => 2 [travel] => [Score] => 25 ) [27] => Array ( [Sequence] => 35 [registration_date] => 2022-08-12 12:45:53 [Rank] => 064 [user_id] => 2275 [first_name] => Anne Marie [last_name] => Riopel [user_phone] => 905-642-6433 [user_email] => annemarie.riopel@sympatico.ca [event_id] => 2744 [Game1] => 8 [Game2] => 15 [Game3] => 12 [group_id] => 9 [Crt_ID] => 4 [time_id] => 2 [travel] => [Score] => 35 ) [28] => Array ( [Sequence] => 8 [registration_date] => 2022-08-09 23:22:53 [Rank] => 012 [user_id] => 2289 [first_name] => Jenn [last_name] => Parker [user_phone] => 416-454-3144 [user_email] => forgedar@idirect.com [event_id] => 2744 [Game1] => 15 [Game2] => 9 [Game3] => 10 [group_id] => 2 [Crt_ID] => 4 [time_id] => 1 [travel] => [Score] => 34 ) [29] => Array ( [Sequence] => 4 [registration_date] => 2022-08-11 21:01:00 [Rank] => 007 [user_id] => 2296 [first_name] => Nicolas [last_name] => Baradhi [user_phone] => 416-731-1334 [user_email] => baradhinicolas@gmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 4 [Game3] => 15 [group_id] => 1 [Crt_ID] => 7 [time_id] => 1 [travel] => [Score] => 34 ) [30] => Array ( [Sequence] => 30 [registration_date] => 2022-08-10 13:01:09 [Rank] => 053 [user_id] => 2319 [first_name] => Andrew [last_name] => Paterson [user_phone] => 647-404-2644 [user_email] => andy@MARKHAMMOWER.COM [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 15 [group_id] => 8 [Crt_ID] => 8 [time_id] => 2 [travel] => [Score] => 45 ) [31] => Array ( [Sequence] => 29 [registration_date] => 2022-08-09 21:18:58 [Rank] => 048 [user_id] => 2327 [first_name] => Cam [last_name] => Lund [user_phone] => 647-297-4700 [user_email] => cam.lund@rogers.com [event_id] => 2744 [Game1] => 8 [Game2] => 11 [Game3] => 15 [group_id] => 8 [Crt_ID] => 8 [time_id] => 2 [travel] => [Score] => 34 ) [32] => Array ( [Sequence] => 31 [registration_date] => 2022-08-09 20:52:59 [Rank] => 054 [user_id] => 2346 [first_name] => Nancy [last_name] => Blue [user_phone] => 416-272-4336 [user_email] => njblue1@rogers.com [event_id] => 2744 [Game1] => 15 [Game2] => 11 [Game3] => 8 [group_id] => 8 [Crt_ID] => 8 [time_id] => 2 [travel] => [Score] => 34 ) [33] => Array ( [Sequence] => 16 [registration_date] => 2022-08-09 20:40:31 [Rank] => 024 [user_id] => 2347 [first_name] => Allie [last_name] => Mione [user_phone] => 647-988-6387 [user_email] => allisoncmione@gmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 11 [Game3] => 15 [group_id] => 4 [Crt_ID] => 3 [time_id] => 1 [travel] => Allie [Score] => 41 ) [34] => Array ( [Sequence] => 17 [registration_date] => 2022-08-12 16:11:04 [Rank] => 026 [user_id] => 2359 [first_name] => Betty [last_name] => Larocque [user_phone] => 905-424-1289 [user_email] => bettylarocque@icloud.com [event_id] => 2744 [Game1] => 15 [Game2] => 9 [Game3] => 5 [group_id] => 5 [Crt_ID] => 3 [time_id] => 2 [travel] => [Score] => 29 ) [35] => Array ( [Sequence] => 7 [registration_date] => 2022-08-09 20:41:24 [Rank] => 012 [user_id] => 2366 [first_name] => Ralph [last_name] => Mione [user_phone] => 416-988-6387 [user_email] => ralphmione67@hotmail.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 15 [group_id] => 2 [Crt_ID] => 4 [time_id] => 1 [travel] => Allie [Score] => 45 ) [36] => Array ( [Sequence] => 18 [registration_date] => 2022-08-13 12:51:14 [Rank] => 029 [user_id] => 2390 [first_name] => Chris [last_name] => Fernando [user_phone] => 416-728-9796 [user_email] => cnando7710@yahoo.com [event_id] => 2744 [Game1] => 15 [Game2] => 15 [Game3] => 15 [group_id] => 5 [Crt_ID] => 3 [time_id] => 2 [travel] => [Score] => 45 ) [37] => Array ( [Sequence] => 9999 [registration_date] => 2022-08-13 13:42:03 [Rank] => 019 [user_id] => 2391 [first_name] => Ian [last_name] => Richards [user_phone] => 647-936-0960 [user_email] => ianrichards@ymail.com [event_id] => 2744 [Game1] => 0 [Game2] => 0 [Game3] => 0 [group_id] => 99 [Crt_ID] => 99 [time_id] => 99 [travel] => [Score] => 0 ) )

column generated!