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 <[email protected]> > --- > 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!
