Changeset 13092 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
- Timestamp:
- Apr 30, 2007, 4:52:04 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
r13087 r13092 1 1 # Copyright (c) 2004 Joshua Hoblitt 2 2 # 3 # $Id: SQL.pm,v 1. 29 2007-05-01 02:00:07jhoblitt Exp $3 # $Id: SQL.pm,v 1.30 2007-05-01 02:52:04 jhoblitt Exp $ 4 4 5 5 package Nebulous::Server::SQL; … … 29 29 new_object_attr => qq{ 30 30 INSERT INTO storage_object_attr 31 (so_id, class_id, comment,read_lock, write_lock)32 VALUES (?, ?, ?,0, NULL)31 (so_id, read_lock, write_lock) 32 VALUES (?, 0, NULL) 33 33 }, 34 34 delete_object => qq{ … … 48 48 get_object => qq{ 49 49 SELECT storage_object.so_id, 50 ext_id, class_id, comment,read_lock, write_lock, epoch, mtime50 ext_id, read_lock, write_lock, epoch, mtime 51 51 FROM storage_object 52 52 LEFT JOIN storage_object_attr … … 176 176 INSERT INTO volume (name, path) 177 177 VALUES (?, ?) 178 },179 get_class_by_id => qq{180 SELECT class_id, priority, comment181 FROM class182 WHERE class_id = ?183 178 }, 184 179 get_volume_by_name => qq{ … … 257 252 CREATE TABLE storage_object_attr ( 258 253 so_id BIGINT NOT NULL AUTO_INCREMENT, 259 class_id TINYINT NOT NULL,260 comment VARCHAR(255),261 254 read_lock TINYINT DEFAULT 0 NOT NULL, 262 255 write_lock ENUM( 'write' ), 263 256 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 264 257 mtime TIMESTAMP, 265 PRIMARY KEY(so_id), 266 KEY(class_id) 258 PRIMARY KEY(so_id) 267 259 ) ENGINE=innodb; 268 260 … … 318 310 PRIMARY KEY(mountpoint) 319 311 ) ENGINE=innodb; 320 321 ###322 323 CREATE TABLE class (324 class_id TINYINT NOT NULL,325 priority TINYINT,326 comment VARCHAR(255),327 PRIMARY KEY(class_id)328 ) ENGINE=innodb;329 330 ###331 332 INSERT INTO class VALUES(0,0, 'default class ID');333 312 334 313 ###
Note:
See TracChangeset
for help on using the changeset viewer.
