diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-09-19 04:50:02 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-09-19 04:50:02 +0000 |
| commit | b7dab9cdab72b6463121856d26dcfea0eb0df376 (patch) | |
| tree | 661d707f54a7c4b4dfb37c3a01de548446d52dfe /phpBB/develop | |
| parent | ea065f3e67ee0c0cb28c88569042461dd8cf2c27 (diff) | |
| download | forums-b7dab9cdab72b6463121856d26dcfea0eb0df376.tar forums-b7dab9cdab72b6463121856d26dcfea0eb0df376.tar.gz forums-b7dab9cdab72b6463121856d26dcfea0eb0df376.tar.bz2 forums-b7dab9cdab72b6463121856d26dcfea0eb0df376.tar.xz forums-b7dab9cdab72b6463121856d26dcfea0eb0df376.zip | |
- Oracle now works with large amounts of text
- MSSQL now works :P (sans UTF-8 support)
- The current schema files work well enough to install, etc. but must be tightened. Will get to it when I get some time...
git-svn-id: file:///svn/phpbb/trunk@6381 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/develop')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 98a4e14740..c655a2245a 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -73,9 +73,9 @@ $dbms_type_map = array( 'MTEXT_UNI' => 'mediumtext', 'TIMESTAMP' => 'int(11) UNSIGNED', 'DECIMAL' => 'decimal(5,2)', - 'VCHAR_UNI' => 'varchar(255)', + 'VCHAR_UNI' => 'text', 'VCHAR_UNI:'=> array('varchar(%d)', 'limit' => array('mult', 3, 255, 'text')), - 'VCHAR_CI' => 'varchar(252)', + 'VCHAR_CI' => 'text', 'VARBINARY' => 'varbinary(255)', ), @@ -121,16 +121,16 @@ $dbms_type_map = array( 'STEXT' => '[varchar] (3000)', 'TEXT' => '[varchar] (8000)', 'MTEXT' => '[text]', - 'XSTEXT_UNI'=> '[nvarchar] (1000)', - 'STEXT_UNI' => '[nvarchar] (3000)', - 'TEXT_UNI' => '[nvarchar] (8000)', - 'MTEXT_UNI' => '[ntext]', + 'XSTEXT_UNI'=> '[text]', + 'STEXT_UNI' => '[text]', + 'TEXT_UNI' => '[text]', + 'MTEXT_UNI' => '[text]', 'TIMESTAMP' => '[int]', 'DECIMAL' => '[float]', - 'VCHAR_UNI' => '[nvarchar] (255)', - 'VCHAR_UNI:'=> '[nvarchar] (%d)', - 'VCHAR_CI' => '[nvarchar] (252)', - 'VARBINARY' => '[varbinary] (255)', + 'VCHAR_UNI' => '[varchar] (255)', + 'VCHAR_UNI:'=> '[varchar] (%d)', + 'VCHAR_CI' => '[varchar] (252)', + 'VARBINARY' => '[varchar] (255)', ), 'oracle' => array( @@ -863,12 +863,12 @@ function get_schema_struct() 'bbcode_tag' => array('VCHAR:16', ''), 'bbcode_helpline' => array('VCHAR', ''), 'display_on_posting' => array('BOOL', 0), - 'bbcode_match' => array('TEXT', ''), - 'bbcode_tpl' => array('MTEXT', ''), - 'first_pass_match' => array('MTEXT', ''), - 'first_pass_replace' => array('MTEXT', ''), - 'second_pass_match' => array('MTEXT', ''), - 'second_pass_replace' => array('MTEXT', ''), + 'bbcode_match' => array('TEXT_UNI', ''), + 'bbcode_tpl' => array('MTEXT_UNI', ''), + 'first_pass_match' => array('MTEXT_UNI', ''), + 'first_pass_replace' => array('MTEXT_UNI', ''), + 'second_pass_match' => array('MTEXT_UNI', ''), + 'second_pass_replace' => array('MTEXT_UNI', ''), ), 'PRIMARY_KEY' => 'bbcode_id', 'KEYS' => array( |