[aur-dev] [PATCH v4 2/6] Edit a comment in the backend

[Lukas Fleischer]

On Fri, 10 Jul 2015 at 18:47:32, Marcel Korpel wrote:
> Create two new actions, do_AddComment and do_EditComment. When editing
> or deleting a comment, a timestamp is added.
> 
> Signed-off-by: Marcel Korpel <marcel.korpel at gmail.com>
> ---
>  schema/aur-schema.sql        |  2 ++
>  web/html/pkgbase.php         |  2 ++
>  web/lib/pkgbasefuncs.inc.php | 34 +++++++++++++++++++++++++++++++++-
>  web/lib/pkgfuncs.inc.php     | 26 ++++++++++++++++++++++++++
>  4 files changed, 63 insertions(+), 1 deletion(-)
> 
> diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
> index 594a804..3aef7a3 100644
> --- a/schema/aur-schema.sql
> +++ b/schema/aur-schema.sql
> @@ -254,6 +254,8 @@ CREATE TABLE PackageComments (
>         UsersID INTEGER UNSIGNED NULL DEFAULT NULL,
>         Comments TEXT NOT NULL DEFAULT '',
>         CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
> +       EditedTS BIGINT UNSIGNED NULL DEFAULT NULL,
> +       EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
>         DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
>         PRIMARY KEY (ID),
>         INDEX (UsersID),
> [...]

If you add new fields to the database, upgrade instructions need to be
added as well. Please add a file upgrading/4.1.0.txt that follows the
format used in the other files in that directory, see e.g. (1) in
upgrading/3.5.0.txt.

Thanks!