[Arianne-commits] stendhal/src/games/stendhal/tools/port1_2 port.sql, NONE, 1.1

[Hendrik <nh...@us...>]

Update of /cvsroot/arianne/stendhal/src/games/stendhal/tools/port1_2
In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv25544/src/games/stendhal/tools/port1_2

Added Files:
	port.sql 
Log Message:
script to port data from marauroa 1.0 to marauroa 2.0: Note this does not port logging tables and there are to java programs which have to be executed

--- NEW FILE: port.sql ---
insert into account(id, username, password, email, timedate, status)
select id, username, password, email, timedate, status from olddatabase.player;

insert into characters(player_id, charname, object_id)
select player_id, charname, object_id from olddatabase.characters;

insert into rpobject(object_id)
select object_id from olddatabase.characters;

insert into banlist(id, address, mask)
select id, address, mask from olddatabase.banlist;