Index: /trunk/Nebulous-Server/Changes
===================================================================
--- /trunk/Nebulous-Server/Changes	(revision 10575)
+++ /trunk/Nebulous-Server/Changes	(revision 10576)
@@ -8,4 +8,5 @@
     - add a Nebulous::Server->config() accessor
     - make Nebulous::Server->db() Apache::DBI aware
+    - make SQL syntax MySQL 5 compatible
 
 0.02 Fri Dec  2 17:36:59 HST 2005
Index: /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
===================================================================
--- /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 10575)
+++ /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 10576)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.20 2006-12-05 00:15:18 jhoblitt Exp $
+# $Id: SQL.pm,v 1.21 2006-12-08 20:59:59 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -179,5 +179,5 @@
 CREATE TABLE storage_object (
     so_id BIGINT NOT NULL AUTO_INCREMENT,
-    ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
+    ext_id VARCHAR(255) NOT NULL UNIQUE,
     type enum('REG_FILE'),
     PRIMARY KEY(so_id),
@@ -201,5 +201,5 @@
     ins_id BIGINT NOT NULL AUTO_INCREMENT,
     so_id BIGINT NOT NULL,
-    uri VARCHAR(255) BINARY NOT NULL,
+    uri VARCHAR(255) NOT NULL,
     sha1sum CHAR(40) ASCII,
     assigned_location BOOL,
@@ -220,6 +220,6 @@
 CREATE TABLE volume (
     vol_id INT NOT NULL AUTO_INCREMENT,
-    name VARCHAR(255) UNIQUE BINARY NOT NULL,
-    uri VARCHAR(255) BINARY NOT NULL,
+    name VARCHAR(255) UNIQUE NOT NULL,
+    uri VARCHAR(255) NOT NULL,
     PRIMARY KEY(vol_id),
     KEY(name(16))
Index: /trunk/Nebulous/Changes
===================================================================
--- /trunk/Nebulous/Changes	(revision 10575)
+++ /trunk/Nebulous/Changes	(revision 10576)
@@ -8,4 +8,5 @@
     - add a Nebulous::Server->config() accessor
     - make Nebulous::Server->db() Apache::DBI aware
+    - make SQL syntax MySQL 5 compatible
 
 0.02 Fri Dec  2 17:36:59 HST 2005
Index: /trunk/Nebulous/lib/Nebulous/Server/SQL.pm
===================================================================
--- /trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 10575)
+++ /trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 10576)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.20 2006-12-05 00:15:18 jhoblitt Exp $
+# $Id: SQL.pm,v 1.21 2006-12-08 20:59:59 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -179,5 +179,5 @@
 CREATE TABLE storage_object (
     so_id BIGINT NOT NULL AUTO_INCREMENT,
-    ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
+    ext_id VARCHAR(255) NOT NULL UNIQUE,
     type enum('REG_FILE'),
     PRIMARY KEY(so_id),
@@ -201,5 +201,5 @@
     ins_id BIGINT NOT NULL AUTO_INCREMENT,
     so_id BIGINT NOT NULL,
-    uri VARCHAR(255) BINARY NOT NULL,
+    uri VARCHAR(255) NOT NULL,
     sha1sum CHAR(40) ASCII,
     assigned_location BOOL,
@@ -220,6 +220,6 @@
 CREATE TABLE volume (
     vol_id INT NOT NULL AUTO_INCREMENT,
-    name VARCHAR(255) UNIQUE BINARY NOT NULL,
-    uri VARCHAR(255) BINARY NOT NULL,
+    name VARCHAR(255) UNIQUE NOT NULL,
+    uri VARCHAR(255) NOT NULL,
     PRIMARY KEY(vol_id),
     KEY(name(16))