From 2afb92238db9fc6a3b478f2fb49cef8672fcb51f Mon Sep 17 00:00:00 2001 From: nikrou Date: Tue, 6 Oct 2009 08:42:25 +0000 Subject: Feature 1026 : update database structure (adding author_id) git-svn-id: http://piwigo.org/svn/trunk@3979 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/piwigo_structure.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'install') diff --git a/install/piwigo_structure.sql b/install/piwigo_structure.sql index dac9c5feb..559addfc4 100644 --- a/install/piwigo_structure.sql +++ b/install/piwigo_structure.sql @@ -52,6 +52,7 @@ CREATE TABLE `piwigo_comments` ( `image_id` mediumint(8) unsigned NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `author` varchar(255) default NULL, + `author_id` smallint(5) DEFAULT NULL, `content` longtext, `validated` enum('true','false') NOT NULL default 'false', `validation_date` datetime default NULL, -- cgit v1.2.3