. add command to continue
. investigate user reordering
+ . manage old games
- WEBSOCKET TRANSPORT
. refactoring $enc attribute management
echo " rebuild"
echo " psql"
echo " piped"
- echo " add <filesql>"
+ echo " add <filesql> [<filesql2> [..]]"
+ echo " del <filesql> [<filesql2> [..]]"
echo " dump [dumpfile]"
echo " dumpall [dumpfile]"
echo " all"
fi
;;
"add")
- cat "$1" | sqlexe
+ ( echo "-- MESG: add start" ; cat "$@" | egrep -iv "$MATCH_DROP" ; echo "-- MESG: add end" ; ) | sqlexe
+ ;;
+ "del")
+ ( echo "-- MESG: del start" ; cat "$@" | egrep -i "$MATCH_DROP" | tac ; echo "-- MESG: del end" ; ) | sqlexe
;;
"help"|"-h"|"--help")
usage 0
;;
esac
-exit 0
\ No newline at end of file
+exit 0
ALTER TABLE #PFX#bin5_matches ADD FOREIGN KEY (tcode) REFERENCES #PFX#bin5_tournaments(code) ON UPDATE cascade ON DELETE cascade;
ALTER TABLE #PFX#bin5_games DROP COLUMN act;
-ALTER TABLE #PFX#bin5_games ADD COLUMN act integer; -- end reason of the game
+ALTER TABLE #PFX#bin5_games ADD COLUMN act integer DEFAULT -1; -- end reason of the game