Add a mechanism for completely deleting a node

[max-horvath]

While seldom needed (setting a node PERMANENTLY_CLOSED is generally preferable), deleting a node including all connections ever to take place there is sometimes usefull, for example when the node was never put in production.

This requires changing the SQL constraints and implementing the delete function with a "Big Fat Warning (tm)"

---

A node cannot be deleted, even after every content and owner and tech officers have been removed ...

Following error occurs:

DELETE FROM nodes WHERE node_id='0014BFC92DDB'
Error: 
ERROR: update or delete on "nodes" violates foreign key constraint "node_stakeholders_node_id_fkey" on "node_stakeholders" DETAIL: Key (node_id)=(0014BFC92DDB) is still referenced from table "node_stakeholders".

[fproulx]

I tried here on my database (which is a dump of ISF database) I removed a stakeholder and I'm getting the foreign key error for connection stats but not on "node_stakeholders". I guess we might add a checkbox like ("I understand that this will drop all nodes statistics etc...")

[max-horvath]

Well, a owner (stakeholder) can't delete a node, anyway (I added this a few weeks ago as this is a task for an administrator, ONLY).

So I don't think we'd need a fancy checkbox. A network admin knows, why he's going to delete a node and what's going to happen.

Anyway ... as I'm not so much into Postgres I'd be very happy if you could add a constrain or whatever is needed so that I as an administrator can delete a node within WiFiDog and not via Postgres command line ;) ...

[benoitg]

This has been fixed (accidentally, but still) many revisions back.