Update of /cvsroot/fink/scripts/pdb
In directory sc8-pr-cvs5.sourceforge.net:/tmp/cvs-serv4949
Modified Files:
Tag: redesign_pdb
schema.sql
Log Message:
Use a case insensitive collation for the pdb tables
Index: schema.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/schema.sql,v
retrieving revision 1.8.2.5
retrieving revision 1.8.2.6
diff -u -d -r1.8.2.5 -r1.8.2.6
--- schema.sql 8 Feb 2007 04:49:06 -0000 1.8.2.5
+++ schema.sql 8 Feb 2007 20:58:20 -0000 1.8.2.6
@@ -2,7 +2,7 @@
name varchar(32) not null,
description text,
primary key (name)
-) collate latin1_bin;
+) collate ascii_general_ci;
create table if not exists package (
pkg_id int unsigned not null auto_increment,
@@ -26,7 +26,7 @@
index (name),
index (section),
index (rel_id)
-) collate latin1_bin;
+) collate ascii_general_ci;
create table if not exists distribution (
dist_id int unsigned not null auto_increment,
@@ -36,7 +36,7 @@
priority tinyint unsigned not null default '1',
active boolean default 1,
primary key (dist_id)
-) collate latin1_bin;
+) collate ascii_general_ci;
create table if not exists distribution_releases (
rel_id int unsigned not null auto_increment,
@@ -46,9 +46,9 @@
priority tinyint unsigned not null default '1',
active boolean default 1,
primary key (rel_id)
-) collate latin1_bin;
+) collate ascii_general_ci;
create table if not exists latest_pkg (
pkg_id int not null default '0',
primary key (pkg_id)
-) collate latin1_bin;
+) collate ascii_general_ci;
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Fink-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-commits
