IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 10576


Ignore:
Timestamp:
Dec 8, 2006, 10:59:59 AM (19 years ago)
Author:
jhoblitt
Message:

make SQL syntax MySQL 5 compatible

Location:
trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • trunk/Nebulous-Server/Changes

    r10575 r10576  
    88    - add a Nebulous::Server->config() accessor
    99    - make Nebulous::Server->db() Apache::DBI aware
     10    - make SQL syntax MySQL 5 compatible
    1011
    11120.02 Fri Dec  2 17:36:59 HST 2005

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

    r10451 r10576  
    11# Copyright (c) 2004  Joshua Hoblitt
    22#
    3 # $Id: SQL.pm,v 1.20 2006-12-05 00:15:18 jhoblitt Exp $
     3# $Id: SQL.pm,v 1.21 2006-12-08 20:59:59 jhoblitt Exp $
    44
    55package Nebulous::Server::SQL;
    … …  
    179179CREATE TABLE storage_object (
    180180    so_id BIGINT NOT NULL AUTO_INCREMENT,
    181     ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
     181    ext_id VARCHAR(255) NOT NULL UNIQUE,
    182182    type enum('REG_FILE'),
    183183    PRIMARY KEY(so_id),
    … …  
    201201    ins_id BIGINT NOT NULL AUTO_INCREMENT,
    202202    so_id BIGINT NOT NULL,
    203     uri VARCHAR(255) BINARY NOT NULL,
     203    uri VARCHAR(255) NOT NULL,
    204204    sha1sum CHAR(40) ASCII,
    205205    assigned_location BOOL,
    … …  
    220220CREATE TABLE volume (
    221221    vol_id INT NOT NULL AUTO_INCREMENT,
    222     name VARCHAR(255) UNIQUE BINARY NOT NULL,
    223     uri VARCHAR(255) BINARY NOT NULL,
     222    name VARCHAR(255) UNIQUE NOT NULL,
     223    uri VARCHAR(255) NOT NULL,
    224224    PRIMARY KEY(vol_id),
    225225    KEY(name(16))

  • trunk/Nebulous/Changes

    r10575 r10576  
    88    - add a Nebulous::Server->config() accessor
    99    - make Nebulous::Server->db() Apache::DBI aware
     10    - make SQL syntax MySQL 5 compatible
    1011
    11120.02 Fri Dec  2 17:36:59 HST 2005

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

    r10451 r10576  
    11# Copyright (c) 2004  Joshua Hoblitt
    22#
    3 # $Id: SQL.pm,v 1.20 2006-12-05 00:15:18 jhoblitt Exp $
     3# $Id: SQL.pm,v 1.21 2006-12-08 20:59:59 jhoblitt Exp $
    44
    55package Nebulous::Server::SQL;
    … …  
    179179CREATE TABLE storage_object (
    180180    so_id BIGINT NOT NULL AUTO_INCREMENT,
    181     ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
     181    ext_id VARCHAR(255) NOT NULL UNIQUE,
    182182    type enum('REG_FILE'),
    183183    PRIMARY KEY(so_id),
    … …  
    201201    ins_id BIGINT NOT NULL AUTO_INCREMENT,
    202202    so_id BIGINT NOT NULL,
    203     uri VARCHAR(255) BINARY NOT NULL,
     203    uri VARCHAR(255) NOT NULL,
    204204    sha1sum CHAR(40) ASCII,
    205205    assigned_location BOOL,
    … …  
    220220CREATE TABLE volume (
    221221    vol_id INT NOT NULL AUTO_INCREMENT,
    222     name VARCHAR(255) UNIQUE BINARY NOT NULL,
    223     uri VARCHAR(255) BINARY NOT NULL,
     222    name VARCHAR(255) UNIQUE NOT NULL,
     223    uri VARCHAR(255) NOT NULL,
    224224    PRIMARY KEY(vol_id),
    225225    KEY(name(16))
Note: See TracChangeset for help on using the changeset viewer.