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';