Testserver with shared database: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann update script |
imported>Hendrik Brummermann |
||
Line 13:
=== Setup test database ===
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>
=== Configure marauroa on test server ===
| |||