Changeset 5341 for trunk/install

Timestamp:

Mar 25, 2010, 11:27:17 AM (14 years ago)

Author:

patdenice

Message:

Feature 1535: Add languages table.
Ready for theme manager!

Location:

trunk/install

Files:

• db/85-database.php (modified) (1 diff)
• db/90-database.php (added)
• piwigo_structure-mysql.sql (modified) (1 diff)

trunk/install/db/85-database.php

@@ -37 +37 @@
 )";
 
+if (DB_CHARSET == 'utf8')
+{
+  $query .= " DEFAULT CHARACTER SET utf8";
+}
+
 pwg_query($query);
 

trunk/install/piwigo_structure-mysql.sql

@@ -205 +205 @@
 
 --
+-- Table structure for table `piwigo_languages`
+--
+
+DROP TABLE IF EXISTS `piwigo_languages`;
+CREATE TABLE `piwigo_languages` (
+  `id` varchar(64) NOT NULL default '',
+  `version` varchar(64) NOT NULL default '0',
+  `name` varchar(64) default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+--
 -- Table structure for table `piwigo_old_permalinks`
 --