Testserver with shared database: Difference between revisions

Please start the test server once, so that it will create all the tables, do not login.

We are going to replace some tables with VIEWs pointing to the main database:

<source lang="sql">

DROP TABLE account;

DROP TABLE accountban;

DROP TABLE banlist;

DROP TABLE characters;

DROP TABLE loginEvent;

CREATE VIEW account AS SELECT * FROM marauroa.account;

CREATE VIEW accountban AS SELECT * FROM marauroa.accountban;

CREATE VIEW banlist AS SELECT * FROM marauroa.banlist;

CREATE VIEW characters AS SELECT * FROM marauroa.characters;

CREATE VIEW loginEvent AS SELECT * FROM marauroa.loginEvent;

</source>