SQL : Insère la catégorie par défaut dès la création des tables

2 files changed, 6 insertions, 1 deletions

diff --git a/app/Models/UserDAO.php b/app/Models/UserDAO.php
index afa049fb9..a25b57f89 100644
--- a/app/Models/UserDAO.php
+++ b/app/Models/UserDAO.php
@@ -7,7 +7,10 @@ class FreshRSS_UserDAO extends Minz_ModelPdo {
 
 		$sql = sprintf(SQL_CREATE_TABLES, $db['prefix'] . $username . '_');
 		$stm = $this->bd->prepare($sql, array(PDO::ATTR_EMULATE_PREPARES => true));
-		if ($stm && $stm->execute()) {
+		$values = array(
+			'catName' => Minz_Translate::t('default_category'),
+		);
+		if ($stm && $stm->execute($values)) {
 			return true;
 		} else {
 			$info = $stm->errorInfo();
diff --git a/app/sql.php b/app/sql.php
index 8646b4da5..5a28858a7 100644
--- a/app/sql.php
+++ b/app/sql.php
@@ -52,6 +52,8 @@ CREATE TABLE IF NOT EXISTS `%1$sentry` (
 	INDEX (`is_read`)	-- v0.7
 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
 ENGINE = INNODB;
+
+INSERT INTO `%1$scategory` (name) VALUES(:catName);
 ');
 
 define('SQL_DROP_TABLES', 'DROP TABLES %1$sentry, %1$sfeed, %1$scategory');