From f6e45ed24420e719a969ffd301cf019ba0aa912a Mon Sep 17 00:00:00 2001
From: hjpotter92 <hjpotter92@iitkgp.ac.in>
Date: Sun, 2 Mar 2014 21:58:10 +0530
Subject: [ticket/11875] Create new map for UNSIGNED 4-byte integer

ULINT => Unsigned Large INTeger
---
 phpBB/phpbb/db/tools.php | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'phpBB/phpbb/db')

diff --git a/phpBB/phpbb/db/tools.php b/phpBB/phpbb/db/tools.php
index 3a7207e743..7f143873b1 100644
--- a/phpBB/phpbb/db/tools.php
+++ b/phpBB/phpbb/db/tools.php
@@ -44,6 +44,7 @@ class tools
 			'mysql_41'	=> array(
 				'INT:'		=> 'int(%d)',
 				'BINT'		=> 'bigint(20)',
+				'ULINT'		=> 'INT(10) UNSIGNED',
 				'UINT'		=> 'mediumint(8) UNSIGNED',
 				'UINT:'		=> 'int(%d) UNSIGNED',
 				'TINT:'		=> 'tinyint(%d)',
@@ -74,6 +75,7 @@ class tools
 			'mysql_40'	=> array(
 				'INT:'		=> 'int(%d)',
 				'BINT'		=> 'bigint(20)',
+				'ULINT'		=> 'INT(10) UNSIGNED',
 				'UINT'		=> 'mediumint(8) UNSIGNED',
 				'UINT:'		=> 'int(%d) UNSIGNED',
 				'TINT:'		=> 'tinyint(%d)',
@@ -104,6 +106,7 @@ class tools
 			'firebird'	=> array(
 				'INT:'		=> 'INTEGER',
 				'BINT'		=> 'DOUBLE PRECISION',
+				'ULINT'		=> 'INTEGER',
 				'UINT'		=> 'INTEGER',
 				'UINT:'		=> 'INTEGER',
 				'TINT:'		=> 'INTEGER',
@@ -134,6 +137,7 @@ class tools
 			'mssql'		=> array(
 				'INT:'		=> '[int]',
 				'BINT'		=> '[float]',
+				'ULINT'		=> '[int]',
 				'UINT'		=> '[int]',
 				'UINT:'		=> '[int]',
 				'TINT:'		=> '[int]',
@@ -164,6 +168,7 @@ class tools
 			'mssqlnative'	=> array(
 				'INT:'		=> '[int]',
 				'BINT'		=> '[float]',
+				'ULINT'		=> '[int]',
 				'UINT'		=> '[int]',
 				'UINT:'		=> '[int]',
 				'TINT:'		=> '[int]',
@@ -194,6 +199,7 @@ class tools
 			'oracle'	=> array(
 				'INT:'		=> 'number(%d)',
 				'BINT'		=> 'number(20)',
+				'ULINT'		=> 'number(10)',
 				'UINT'		=> 'number(8)',
 				'UINT:'		=> 'number(%d)',
 				'TINT:'		=> 'number(%d)',
@@ -224,7 +230,8 @@ class tools
 			'sqlite'	=> array(
 				'INT:'		=> 'int(%d)',
 				'BINT'		=> 'bigint(20)',
-				'UINT'		=> 'INTEGER UNSIGNED', //'mediumint(8) UNSIGNED',
+				'ULINT'		=> 'INTEGER UNSIGNED', // 'int(10) UNSIGNED
+				'UINT'		=> 'INTEGER UNSIGNED', // 'mediumint(8) UNSIGNED',
 				'UINT:'		=> 'INTEGER UNSIGNED', // 'int(%d) UNSIGNED',
 				'TINT:'		=> 'tinyint(%d)',
 				'USINT'		=> 'INTEGER UNSIGNED', //'mediumint(4) UNSIGNED',
@@ -254,6 +261,7 @@ class tools
 			'postgres'	=> array(
 				'INT:'		=> 'INT4',
 				'BINT'		=> 'INT8',
+				'ULINT'		=> 'INT4', // unsigned
 				'UINT'		=> 'INT4', // unsigned
 				'UINT:'		=> 'INT4', // unsigned
 				'USINT'		=> 'INT2', // unsigned
@@ -287,7 +295,7 @@ class tools
 	* A list of types being unsigned for better reference in some db's
 	* @var array
 	*/
-	var $unsigned_types = array('UINT', 'UINT:', 'USINT', 'BOOL', 'TIMESTAMP');
+	var $unsigned_types = array('ULINT', 'UINT', 'UINT:', 'USINT', 'BOOL', 'TIMESTAMP');
 
 	/**
 	* A list of supported DBMS. We change this class to support more DBMS, the DBMS itself only need to follow some rules.
-- 
cgit v1.2.1


From 7696f39ac3ecb803468f230129a76dac59f2972b Mon Sep 17 00:00:00 2001
From: hjpotter92 <hjpotter92@iitkgp.ac.in>
Date: Sun, 2 Mar 2014 23:23:44 +0530
Subject: [ticket/11875] Recreate schemas for install

PHPBB3-11875
---
 phpBB/phpbb/db/tools.php | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'phpBB/phpbb/db')

diff --git a/phpBB/phpbb/db/tools.php b/phpBB/phpbb/db/tools.php
index 7f143873b1..18e30d309a 100644
--- a/phpBB/phpbb/db/tools.php
+++ b/phpBB/phpbb/db/tools.php
@@ -230,12 +230,12 @@ class tools
 			'sqlite'	=> array(
 				'INT:'		=> 'int(%d)',
 				'BINT'		=> 'bigint(20)',
-				'ULINT'		=> 'INTEGER UNSIGNED', // 'int(10) UNSIGNED
+				'ULINT'		=> 'INTEGER UNSIGNED', // 'int(10) UNSIGNED',
 				'UINT'		=> 'INTEGER UNSIGNED', // 'mediumint(8) UNSIGNED',
 				'UINT:'		=> 'INTEGER UNSIGNED', // 'int(%d) UNSIGNED',
 				'TINT:'		=> 'tinyint(%d)',
-				'USINT'		=> 'INTEGER UNSIGNED', //'mediumint(4) UNSIGNED',
-				'BOOL'		=> 'INTEGER UNSIGNED', //'tinyint(1) UNSIGNED',
+				'USINT'		=> 'INTEGER UNSIGNED', // 'mediumint(4) UNSIGNED',
+				'BOOL'		=> 'INTEGER UNSIGNED', // 'tinyint(1) UNSIGNED',
 				'VCHAR'		=> 'varchar(255)',
 				'VCHAR:'	=> 'varchar(%d)',
 				'CHAR:'		=> 'char(%d)',
@@ -247,7 +247,7 @@ class tools
 				'STEXT_UNI'	=> 'text(65535)',
 				'TEXT_UNI'	=> 'text(65535)',
 				'MTEXT_UNI'	=> 'mediumtext(16777215)',
-				'TIMESTAMP'	=> 'INTEGER UNSIGNED', //'int(11) UNSIGNED',
+				'TIMESTAMP'	=> 'INTEGER UNSIGNED', // 'int(11) UNSIGNED',
 				'DECIMAL'	=> 'decimal(5,2)',
 				'DECIMAL:'	=> 'decimal(%d,2)',
 				'PDECIMAL'	=> 'decimal(6,3)',
-- 
cgit v1.2.1