diff options
| author | gweltas <gweltas@piwigo.org> | 2004-09-26 21:24:49 +0000 |
|---|---|---|
| committer | gweltas <gweltas@piwigo.org> | 2004-09-26 21:24:49 +0000 |
| commit | 1d4238055a7fbb86bdb901f09eb5de90026ba431 (patch) | |
| tree | a3273603e2a8c4e859bded7f992c02a8ba101270 /install | |
| parent | bb8189ea750fdde2b489abd563034e0efb32db20 (diff) | |
-First draft of history display
git-svn-id: http://piwigo.org/svn/trunk@537 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 3a387603b..8ad3d1f7a 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -94,12 +94,13 @@ CREATE TABLE phpwebgallery_groups ( DROP TABLE IF EXISTS phpwebgallery_history; CREATE TABLE phpwebgallery_history ( - date int(11) NOT NULL default '0', + date datetime NOT NULL default '0000-00-00 00:00:00', login varchar(15) default NULL, IP varchar(50) NOT NULL default '', category varchar(150) default NULL, file varchar(50) default NULL, - picture varchar(150) default NULL + picture varchar(150) default NULL, + PRIMARY KEY `date` (`date`) ) TYPE=MyISAM; -- |