From 445972a1965e441eaff524168f6bac0bdd5b9030 Mon Sep 17 00:00:00 2001 From: Harvie Date: Tue, 21 Dec 2010 04:50:02 +0100 Subject: [PATCH] TODO: Minor DB cleanups, fixed typo psql -> pgsql --- doc/TODO | 7 +++++++ wwwroot/backend/pgsql/backend.inc | 3 +++ wwwroot/backend/psql/backend.inc | 3 --- 3 files changed, 10 insertions(+), 3 deletions(-) create mode 100644 wwwroot/backend/pgsql/backend.inc delete mode 100644 wwwroot/backend/psql/backend.inc diff --git a/doc/TODO b/doc/TODO index da40148..6dcc374 100644 --- a/doc/TODO +++ b/doc/TODO @@ -67,3 +67,10 @@ - Fix /(id|k)/*/download (ERROR: Empty file to download.) (I think this should be implemented as template (and smarty method for download). template can be ID down in base36 = 638807 in base10) + +- Cleanup DB + (Make script for deleting nodes in recycle bin) + (Some actions (like loging, etc...) may be implemented using SQL triggers) + (Mark all nodes that should become part of distribution of kyberia software) + (Delete unused tables) + (Replace duplicit tables with VIEWs) diff --git a/wwwroot/backend/pgsql/backend.inc b/wwwroot/backend/pgsql/backend.inc new file mode 100644 index 0000000..875fe22 --- /dev/null +++ b/wwwroot/backend/pgsql/backend.inc @@ -0,0 +1,3 @@ + diff --git a/wwwroot/backend/psql/backend.inc b/wwwroot/backend/psql/backend.inc deleted file mode 100644 index 342cd4a..0000000 --- a/wwwroot/backend/psql/backend.inc +++ /dev/null @@ -1,3 +0,0 @@ - -- 2.30.2