Changeset 10576 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

Timestamp:

Dec 8, 2006, 10:59:59 AM (19 years ago)

Author:

jhoblitt

Message:

make SQL syntax MySQL 5 compatible

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (4 diffs)

trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

@@ -1 +1 @@
 # 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 +179 @@
 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 +201 @@
     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 +220 @@
 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))