Guild deletion

[nclx]

Deleting guild from the table guilds deletes guild_membership, guild_ranks but it doesnt delete guild_invites (didnt test any other and didnt import new schema, is old database "optimized").

[marksamman]

The schema has a foreign key for guilds.id with ON DELETE CASCADE. It might have been missing initially and as it looks like was never patched by the database updater. The table is currently unused by the server, but will be kept for people to implement guild invitations on their own using the table.

To add the foreign key, execute this query:
ALTER TABLE guild_invites ADD FOREIGN KEY (guild_id) REFERENCES guilds (id) ON DELETE CASCADE