https://kratos.time-globe-crs.de/pos-install/03_Update/


http://localhost:8080/r<>a<>/servlet?jnlp=pos

	
	UPDATE PURCHASE_ITEM_PRICES SET PRICE_TS = {fn TIMESTAMPADD (SQL_TSI_YEAR, 2000, price_ts)} 
where DATE(price_ts) < '0100-01-01'


tomcat stoppen:

	Als Admin Cmd: net stop possat-8080
	Mac
		Cd /
		Cd Library/LaunchDaemons/
		Sudo launchctl unload possat-8080.plist
		Launchctl stop de.timeglobe.possat-8080

		
UpdateDB		

java -jar db-upgrade-tool.jar derby-db-upgrade source-db:=.\sourcedb\db_pos_s360p1 script-before:=.\Script1_satellite.sql script-after:=.\Script2_satellite.sql target-modelfile:=.\pos.xml


tomcat starten:

	Als Admin Cmd: net start possat-8080
	Mac: 
		Cd /
		Cd Library/LaunchDaemons/
		Sudo launchctl load possat-8080.plist
Launchctl start de.timeglobe.possat-8080



SELECT drawer_no, max(payment_ts) FROM pos_payments group by drawer_no