aboutsummaryrefslogtreecommitdiffstats
path: root/install/piwigo_structure.sql
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2009-10-06 08:42:25 +0000
committernikrou <nikrou@piwigo.org>2009-10-06 08:42:25 +0000
commit2afb92238db9fc6a3b478f2fb49cef8672fcb51f (patch)
treebb7857ad4cf1ed4ced6d843d98b6975a64924b2a /install/piwigo_structure.sql
parent9e1b5427963ce7350ccac91bbb9da0e508920903 (diff)
Feature 1026 : update database structure (adding author_id)
git-svn-id: http://piwigo.org/svn/trunk@3979 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--install/piwigo_structure.sql1
1 files changed, 1 insertions, 0 deletions
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,