New Laravel project =================== composer create-project laravel/laravel your-project-name 5.4.* SERVER ====== CHECK INODES df -i CLEAR INODES FROM MAILDROP rm -rf /var/spool/postfix/maildrop RESTART APACHE SERVER service httpd restart START CROND /sbin/service crond start LARAVEL FIX PASSWORDS ===================== $get_old_user = pg_query($db_secure,"SELECT * FROM \"users\" WHERE \"account_password\" IS NOT NULL") or die(pg_result_error()); $old_users = pg_fetch_all($get_old_user); foreach ($old_users AS $old_user) { $accountId = $old_user['id']; $accountName = $old_user['account_name']; $oldPass = $old_user['account_password']; $newPass = \Hash::make($oldPass); echo 'NAME: '.$accountName.'<br>'; echo 'OLD PASS: '.$oldPass.'<br>'; echo 'NEW PASS: '.$newPass.'<br>'; $update_user_sql = "UPDATE \"users\" SET \"password\" ='$newPass' WHERE \"id\" = '$accountId';"; $update_user = pg_query($db_secure,$update_user_sql) or die(pg_result_error_field()); } INSERT INTO "CONTEST_PARAMS"("SPORT","CONTEST_TYPE","SCORING","MIN_PLAYERS","MAX_PLAYERS","PRIZE_POOL","SALARY_CAP","ENTRY_FEE","OTS_BUCKS","CONTEST_NAME","NUM_PICKS","TYPE","CREATOR","MIN_BET","MAX_BET","DOW","GUARANTEED","STATUS","SPECIAL","CRYPTO","PUBLIC_PRIVATE") VALUES ('NFL','OTS','OTS','2','999999','200','60000','0','NO','NFL PRO Members $200 Giveaway','8','TOURNAMENT','OTS','5000','11250','Tue,Wed,Thu,Fri,Sat','200','ACTIVE','FREEROLL','NONE','PRO') INSERT INTO "NCAAB_TEAM_LIST" ("SCHOOL_ABV","SCHOOL_NAME","CONFERENCE","SCHOOL_ID","DIVISION", "CBS_ABV","CBS_NAME","UPPER_NAME","ALT_NAME","COVERS_ABV","COVERS_NAME","UPPER_NAME2","LEVEL") VALUES ('MWM','Merrimack','Independent (FCS)','319838','2','MW','Merrimack','MERRIMACK', 'Merrimack','MW','Merrimack','MERRIMACK','2'); INSERT INTO "SOCCER_TEAM_LIST" ("TEAM_ABV","TEAM_NAME","DIVISION","ESPN_ID","ESPN_NAME","UPPER_NAME","LOW_TEAM_NAME") VALUES ('HUD','Huddersfield Town','1','335','Huddersfield Town','HUDDERSFIELD TOWN','huddersfield-town'); INSERT INTO "SOCCER_TEAM_LIST" ("TEAM_ABV","TEAM_NAME","DIVISION","UPPER_NAME","LOW_TEAM_NAME","espn_abv","ESPN_ABV") VALUES ('ACJ','AC Ajaccio','1','AC AJACCIO','ac-ajaccio','AJC','AJC'); INSERT INTO "CFL_PLAYER_LIST" ("PLAYER_ID","PLAYER_NAME","TEAM_ABV","TEAM_NAME","POS","DOB", "HEIGHT","WEIGHT","TEAM_ID","BOX_NAME","COLLEGE","F_INIT","LAST_NAME","CFL_ID") VALUES ('152593','Banks, Brandon','HAM','Hamilton Tiger-Cats','WR','1987-12-21','5"7','150','6','B. Banks','Kansas State','B','Banks','152593'); INSERT INTO "NHL_ROSTER" ("PLAYER_NAME","TEAM_ABV","TEAM_NAME","POS","TEAM_ID","BOX_NAME","LAST_NAME","ROTO_ID") VALUES ('Kaprizov, Kirill','MIN','Minnesota Wild','D','29','K. Kaprizov','Kaprizov','5278'); insert into "ncaaf_team_list" ("school_abv","school_name","conference","school_id","division", "cbs_abv","cbs_name","upper_name","alt_name","covers_abv","covers_name","upper_name2","level") VALUES ('LIU','Long Island University','Independent (FCS)','319838','2','LI','Long Island','LONG ISLAND', 'Long Island','LI','Long Island','LONG ISLAND','2'); AFTER PHP ARTISAN TINKER ======================== App\User::Create(['email'=>"mandc@iadowrfilms.com","password"=>bcrypt('123456'),'name'=>"iadowrfilms"]); MAKE A COLUMN DEFAULT TIME NOW ============================== ALTER TABLE transaction_log ALTER COLUMN updated_at SET DEFAULT now(); RENAME A TABLE ============== ALTER TABLE name RENAME TO new_name CREATE A TABLE WITH COPYING ALL DATA ==================================== select * into "nfl_2014_schedule" from "nfl_schedule" SEARCH FOR DUPLICATES ==================================== select date, ots_id, count(*) from mlb_boxscores group by date, ots_id HAVING count(*) > 1 EXAMPLE ======= SELECT * INTO "NCAAB_2019_SCHEDULE" FROM "NCAAB_SCHEDULE"; SELECT * INTO "NCAAB_2019_BOXSCORES" FROM "NCAAB_BOXSCORES"; SELECT * INTO "NCAAB_2019_BOXSCORES_TOTALS" FROM "NCAAB_BOXSCORES_TOTALS"; SELECT * INTO "NCAAB_2019_PICKS" FROM "NCAAB_PICKS"; SELECT * INTO "NCAAB_2019_PICKS_DEVSTATS" FROM "NCAAB_PICKS_DEVSTATS"; SELECT * INTO "NCAAB_2019_TEAMDEF" FROM "NCAAB_TEAMDEF"; SELECT * INTO "NCAAB_2019_TEAMOFF" FROM "NCAAB_TEAMOFF"; SELECT * INTO "NCAAB_2019_TEAMST" FROM "NCAAB_TEAMST"; SELECT * INTO "NCAAB_2019_TEAMSTATS" FROM "NCAAB_TEAMSTATS"; SELECT * INTO "NCAAB_2019_VPICKS_STATS" FROM "NCAAB_VPICKS_STATS"; DELETING INFO ============== DELETE FROM "NCAAB_SCHEDULE"; DELETE FROM "NCAAB_BOXSCORES"; DELETE FROM "NCAAB_BOXSCORES_TOTALS"; DELETE FROM "NCAAB_PICKS"; DELETE FROM "NCAAB_PICKS_DEVSTATS"; DELETE FROM "NCAAB_TEAMDEF"; DELETE FROM "NCAAB_TEAMOFF"; DELETE FROM "NCAAB_TEAMST"; DELETE FROM "NCAAB_TEAMSTATS"; DELETE FROM "NCAAB_VPICKS_STATS"; CREATE UNIQUE INDEX "OTS_GAMEID_INDEX" ON "NHL_SCHEDULE" ("OTS_GAMEID"); update table set field = replace(field, 'cat', 'dog') ALTER TABLE sample.public.employee ADD PRIMARY KEY (ssn) CHANGE TO TYPE INTEGER FROM CHAR VAR ==================================== ALTER TABLE users ALTER COLUMN ltc_address TYPE integer USING (ltc_address::integer); DELETE DUPLICATES ================= DELETE FROM "NBA_PLAYER_LIST" WHERE "OTS_ID" IN (SELECT "OTS_ID" FROM (SELECT "OTS_ID", ROW_NUMBER() OVER (partition BY "NAME", "TEAM_ABV", "TEAM_NAME" ORDER BY "OTS_ID") AS rnum FROM "NBA_PLAYER_LIST") t WHERE t.rnum > 1); ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_RUSH_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_RUSH_YPG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_RUSH_AVG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_RUSH_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_RUSH_TDPCT" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_RUSH_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_REC_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_REC_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_REC_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_REC_YPG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_REC_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_TACKLES" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_SACKS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_INT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_DEF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_STUFFS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_ASS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_SAFETY" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_SACK_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_TACKLE_FOR_LOSS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PUNTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PUNT_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PUNT_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FGM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FGA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FG_BLK" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_XPM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_XPA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_KR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_KR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_KR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PR_LONG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FUM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FUM_LOST" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FUM_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_FUM_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_SINGLE" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_KR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_PR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "AWAY_STT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_RUSH_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_RUSH_YPG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_RUSH_AVG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_RUSH_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_RUSH_TDPCT" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_RUSH_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_REC_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_REC_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_REC_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_REC_YPG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_REC_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_TACKLES" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_SACKS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_INT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_DEF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_STUFFS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_ASS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_SAFETY" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_SACK_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_TACKLE_FOR_LOSS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PUNTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PUNT_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PUNT_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FGM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FGA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FG_BLK" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_XPM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_XPA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_KR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_KR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_KR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PR_LONG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FUM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FUM_LOST" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FUM_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_FUM_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_SINGLE" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_KR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_PR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "CONF_STT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_RUSH_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_RUSH_YPG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_RUSH_AVG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_RUSH_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_RUSH_TDPCT" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_RUSH_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_REC_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_REC_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_REC_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_REC_YPG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_REC_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_TACKLES" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_SACKS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_INT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_DEF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_STUFFS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_ASS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_SAFETY" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_SACK_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_TACKLE_FOR_LOSS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PUNTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PUNT_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PUNT_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FGM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FGA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FG_BLK" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_XPM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_XPA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_KR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_KR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_KR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PR_LONG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FUM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FUM_LOST" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FUM_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_FUM_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_SINGLE" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_KR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_PR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "IC_STT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_RUSH_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_RUSH_YPG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_RUSH_AVG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_RUSH_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_RUSH_TDPCT" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_RUSH_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_REC_YDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_REC_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_REC_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_REC_YPG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_REC_100YG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_TACKLES" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_SACKS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_INT" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_DEF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FF" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_STUFFS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_ASS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_SAFETY" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_SACK_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_TACKLE_FOR_LOSS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PUNTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PUNT_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PUNT_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FGM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FGA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FG_BLK" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_XPM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_XPA" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_KR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_KR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_KR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PR_NO" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PR_YARDS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PR_LONG" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PR_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FUM" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FUM_LOST" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FUM_REC" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_FUM_TD" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_SINGLE" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PTS" integer; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_KR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_PR_AVG" real; ALTER TABLE "CFL_PLAYER_STATS" ADD "LAST5_STT" integer; UPDATE "SOCCER_SCHEDULE" SET "week" = '1' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" >= '2022-08-05' AND "DATE" <= '2022-08-07'; UPDATE "SOCCER_SCHEDULE" SET "week" = '2' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-14'; UPDATE "SOCCER_SCHEDULE" SET "week" = '3' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-21'; UPDATE "SOCCER_SCHEDULE" SET "week" = '4' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-28'; UPDATE "SOCCER_SCHEDULE" SET "week" = '5' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-31'; UPDATE "SOCCER_SCHEDULE" SET "week" = '6' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-09-04'; UPDATE "SOCCER_SCHEDULE" SET "week" = '7' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-09-11'; UPDATE "SOCCER_SCHEDULE" SET "week" = '8' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-09-18'; UPDATE "SOCCER_SCHEDULE" SET "week" = '9' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-02'; UPDATE "SOCCER_SCHEDULE" SET "week" = '10' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-09'; UPDATE "SOCCER_SCHEDULE" SET "week" = '11' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-16'; UPDATE "SOCCER_SCHEDULE" SET "week" = '12' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-23'; UPDATE "SOCCER_SCHEDULE" SET "week" = '13' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-30'; UPDATE "SOCCER_SCHEDULE" SET "week" = '14' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-11-06'; UPDATE "SOCCER_SCHEDULE" SET "week" = '15' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-11-13'; UPDATE "SOCCER_SCHEDULE" SET "week" = '16' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-12-28'; UPDATE "SOCCER_SCHEDULE" SET "week" = '17' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-01'; UPDATE "SOCCER_SCHEDULE" SET "week" = '18' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-11'; UPDATE "SOCCER_SCHEDULE" SET "week" = '19' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-15'; UPDATE "SOCCER_SCHEDULE" SET "week" = '20' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-29'; UPDATE "SOCCER_SCHEDULE" SET "week" = '21' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-01'; UPDATE "SOCCER_SCHEDULE" SET "week" = '22' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-05'; UPDATE "SOCCER_SCHEDULE" SET "week" = '23' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-12'; UPDATE "SOCCER_SCHEDULE" SET "week" = '24' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-19'; UPDATE "SOCCER_SCHEDULE" SET "week" = '25' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-26'; UPDATE "SOCCER_SCHEDULE" SET "week" = '26' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-03-05'; UPDATE "SOCCER_SCHEDULE" SET "week" = '27' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-03-12'; UPDATE "SOCCER_SCHEDULE" SET "week" = '28' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-03-19'; UPDATE "SOCCER_SCHEDULE" SET "week" = '29' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-02'; UPDATE "SOCCER_SCHEDULE" SET "week" = '30' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-09'; UPDATE "SOCCER_SCHEDULE" SET "week" = '31' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-16'; UPDATE "SOCCER_SCHEDULE" SET "week" = '32' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-23'; UPDATE "SOCCER_SCHEDULE" SET "week" = '33' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-30'; UPDATE "SOCCER_SCHEDULE" SET "week" = '34' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-07'; UPDATE "SOCCER_SCHEDULE" SET "week" = '35' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-14'; UPDATE "SOCCER_SCHEDULE" SET "week" = '36' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-21'; UPDATE "SOCCER_SCHEDULE" SET "week" = '37' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-27'; UPDATE "SOCCER_SCHEDULE" SET "week" = '38' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-06-03'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '1' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" >= '2022-08-05' AND "DATE" <= '2022-08-07'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '2' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-14'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '3' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-21'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '4' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-28'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '5' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-08-31'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '6' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-09-04'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '7' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-09-11'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '8' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-09-18'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '9' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-02'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '10' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-09'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '11' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-16'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '12' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-23'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '13' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-10-30'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '14' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-11-06'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '15' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-11-13'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '16' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2022-12-28'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '17' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-01'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '18' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-11'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '19' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-15'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '20' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-01-29'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '21' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-01'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '22' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-05'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '23' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-12'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '24' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-19'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '25' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-02-26'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '26' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-03-05'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '27' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-03-12'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '28' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-03-19'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '29' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-02'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '30' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-09'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '31' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-16'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '32' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-23'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '33' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-04-30'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '34' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-07'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '35' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-14'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '36' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-21'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '37' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-05-27'; UPDATE "SOCCER_SCHEDULE" SET "ROUND" = '38' WHERE "LEAGUE" = 'LIGUE 1' AND "DATE" = '2023-06-03';