| |
[Phpbb-checkins] phpBB2/install/schemas firebird_schema.sql,1.50,1.51 mssql_schema.sql,1.46,1.47 mysql_schema.sql,1.195,1.196 oracle_schema.sql,1.38,1.39 postgres_schema.sql,1.42,1.43 sqlite_schema.sql,1.38,1.39 From: Nils Adermann <naderman@us...> - 2006-05-30 21:46
|
Update of /cvsroot/phpbb/phpBB2/install/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3882/install/schemas
Modified Files:
firebird_schema.sql mssql_schema.sql mysql_schema.sql
oracle_schema.sql postgres_schema.sql sqlite_schema.sql
Log Message:
- add support for min/max of numerical search backend settings
- change word_text maximum length
- don't update search settings if nothing was changed
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/install/schemas/mysql_schema.sql,v
retrieving revision 1.195
retrieving revision 1.196
diff -C2 -d -r1.195 -r1.196
*** mysql_schema.sql 28 May 2006 19:24:10 -0000 1.195
--- mysql_schema.sql 30 May 2006 21:46:12 -0000 1.196
***************
*** 587,591 ****
# Table: 'phpbb_search_wordlist'
CREATE TABLE phpbb_search_wordlist (
! word_text varchar(50) BINARY DEFAULT '' NOT NULL,
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
--- 587,591 ----
# Table: 'phpbb_search_wordlist'
CREATE TABLE phpbb_search_wordlist (
! word_text varchar(252) BINARY DEFAULT '' NOT NULL,
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/install/schemas/postgres_schema.sql,v
retrieving revision 1.42
retrieving revision 1.43
diff -C2 -d -r1.42 -r1.43
*** postgres_schema.sql 28 May 2006 19:24:13 -0000 1.42
--- postgres_schema.sql 30 May 2006 21:46:12 -0000 1.43
***************
*** 916,920 ****
CREATE TABLE phpbb_search_wordlist (
word_id INT4 DEFAULT nextval('phpbb_search_wordlist_seq'),
! word_text varchar(50) DEFAULT '' NOT NULL,
word_common INT2 DEFAULT '0' NOT NULL,
PRIMARY KEY (word_text),
--- 916,920 ----
CREATE TABLE phpbb_search_wordlist (
word_id INT4 DEFAULT nextval('phpbb_search_wordlist_seq'),
! word_text varchar(252) DEFAULT '' NOT NULL,
word_common INT2 DEFAULT '0' NOT NULL,
PRIMARY KEY (word_text),
Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/install/schemas/mssql_schema.sql,v
retrieving revision 1.46
retrieving revision 1.47
diff -C2 -d -r1.46 -r1.47
*** mssql_schema.sql 28 May 2006 19:24:10 -0000 1.46
--- mssql_schema.sql 30 May 2006 21:46:12 -0000 1.47
***************
*** 1437,1441 ****
*/
CREATE TABLE [phpbb_search_wordlist] (
! [word_text] [nvarchar] (50) NOT NULL ,
[word_id] [int] IDENTITY (1, 1) NOT NULL ,
[word_common] [int] NOT NULL
--- 1437,1441 ----
*/
CREATE TABLE [phpbb_search_wordlist] (
! [word_text] [nvarchar] (252) NOT NULL ,
[word_id] [int] IDENTITY (1, 1) NOT NULL ,
[word_common] [int] NOT NULL
Index: firebird_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/install/schemas/firebird_schema.sql,v
retrieving revision 1.50
retrieving revision 1.51
diff -C2 -d -r1.50 -r1.51
*** firebird_schema.sql 28 May 2006 19:24:10 -0000 1.50
--- firebird_schema.sql 30 May 2006 21:46:12 -0000 1.51
***************
*** 912,916 ****
# phpbb_search_wordlist
CREATE TABLE phpbb_search_wordlist (
! word_text VARCHAR(50) DEFAULT '' NOT NULL,
word_id INTEGER NOT NULL,
word_common INTEGER DEFAULT 0 NOT NULL
--- 912,916 ----
# phpbb_search_wordlist
CREATE TABLE phpbb_search_wordlist (
! word_text VARCHAR(252) DEFAULT '' NOT NULL,
word_id INTEGER NOT NULL,
word_common INTEGER DEFAULT 0 NOT NULL
Index: oracle_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/install/schemas/oracle_schema.sql,v
retrieving revision 1.38
retrieving revision 1.39
diff -C2 -d -r1.38 -r1.39
*** oracle_schema.sql 28 May 2006 19:24:12 -0000 1.38
--- oracle_schema.sql 30 May 2006 21:46:12 -0000 1.39
***************
*** 1214,1218 ****
*/
CREATE TABLE phpbb_search_wordlist (
! word_text varchar2(50) DEFAULT '' NOT NULL,
word_id number(8) NOT NULL,
word_common number(1) DEFAULT '0' NOT NULL,
--- 1214,1218 ----
*/
CREATE TABLE phpbb_search_wordlist (
! word_text varchar2(252) DEFAULT '' NOT NULL,
word_id number(8) NOT NULL,
word_common number(1) DEFAULT '0' NOT NULL,
Index: sqlite_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/install/schemas/sqlite_schema.sql,v
retrieving revision 1.38
retrieving revision 1.39
diff -C2 -d -r1.38 -r1.39
*** sqlite_schema.sql 28 May 2006 19:24:13 -0000 1.38
--- sqlite_schema.sql 30 May 2006 21:46:12 -0000 1.39
***************
*** 629,633 ****
# Table: phpbb_search_wordlist
CREATE TABLE phpbb_search_wordlist (
! word_text varchar(50) NOT NULL DEFAULT '',
word_id mediumint(8) NOT NULL,
word_common tinyint(1) NOT NULL DEFAULT '0',
--- 629,633 ----
# Table: phpbb_search_wordlist
CREATE TABLE phpbb_search_wordlist (
! word_text varchar(252) NOT NULL DEFAULT '',
word_id mediumint(8) NOT NULL,
word_common tinyint(1) NOT NULL DEFAULT '0',
|
|
