Changeset 8464 for trunk/install

Timestamp:

Jan 4, 2011, 11:55:08 AM (13 years ago)

Author:

plg

Message:

feature 2095 added: new column images.added_by (foreign key on users.id)

Location:

trunk/install

Files:

• db/92-database.php (added)
• piwigo_structure-mysql.sql (modified) (1 diff)
• piwigo_structure-pdo-sqlite.sql (modified) (1 diff)
• piwigo_structure-pgsql.sql (modified) (1 diff)
• piwigo_structure-sqlite.sql (modified) (1 diff)

trunk/install/piwigo_structure-mysql.sql

@@ -196 +196 @@
   `level` tinyint unsigned NOT NULL default '0',
   `md5sum` char(32) default NULL,
+  `added_by` smallint(5) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),

trunk/install/piwigo_structure-pdo-sqlite.sql

@@ -192 +192 @@
   "level" INTEGER default 0 NOT NULL,
   "md5sum" CHAR(32),
+  "added_by" INTEGER default 0 NOT NULL,
   PRIMARY KEY ("id")
 );

trunk/install/piwigo_structure-pgsql.sql

@@ -236 +236 @@
   "level" INTEGER default 0 NOT NULL,
   "md5sum" CHAR(32),
+  "added_by" INTEGER default 0 NOT NULL,
   PRIMARY KEY ("id")
 );

trunk/install/piwigo_structure-sqlite.sql

@@ -192 +192 @@
   "level" INTEGER default 0 NOT NULL,
   "md5sum" CHAR(32),
+  "added_by" INTEGER default 0 NOT NULL,
   PRIMARY KEY ("id")
 );