Changeset 16259
- Timestamp:
- Jan 28, 2008, 9:48:08 AM (18 years ago)
- Location:
- trunk
- Files:
-
- 4 edited
-
Nebulous-Server/Changes (modified) (1 diff)
-
Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (3 diffs)
-
Nebulous/Changes (modified) (1 diff)
-
Nebulous/lib/Nebulous/Server/SQL.pm (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/Nebulous-Server/Changes
r16244 r16259 2 2 3 3 0.07 4 - add additional fkey constrains to the instance table 5 - fix installation of neb-replicate & neb-cull 4 6 - redo database schema with foreign keys 5 7 - add Nebulous::Keys pod -
trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
r16244 r16259 1 1 # Copyright (c) 2004 Joshua Hoblitt 2 2 # 3 # $Id: SQL.pm,v 1.4 4 2008-01-26 02:04:46jhoblitt Exp $3 # $Id: SQL.pm,v 1.45 2008-01-28 19:48:08 jhoblitt Exp $ 4 4 5 5 package Nebulous::Server::SQL; … … 325 325 ### 326 326 327 CREATE TABLE instance (328 ins_id BIGINT NOT NULL AUTO_INCREMENT,329 so_id BIGINT NOT NULL,330 FOREIGN KEY(so_id) REFERENCES storage_object(so_id),331 vol_id INT NOT NULL,332 uri VARCHAR(255) NOT NULL UNIQUE,333 sha1sum CHAR(40) ASCII,334 assigned_vol_id INT,335 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,336 mtime TIMESTAMP,337 PRIMARY KEY(ins_id),338 KEY(so_id),339 KEY(vol_id),340 KEY(uri(64))341 ) ENGINE=innodb;342 343 ###344 345 327 CREATE TABLE lock_record ( 346 328 so_id BIGINT NOT NULL, … … 365 347 KEY(allocate), 366 348 KEY(available) 349 ) ENGINE=innodb; 350 351 ### 352 353 CREATE TABLE instance ( 354 ins_id BIGINT NOT NULL AUTO_INCREMENT, 355 so_id BIGINT NOT NULL, 356 FOREIGN KEY(so_id) REFERENCES storage_object(so_id), 357 vol_id INT NOT NULL, 358 FOREIGN KEY(vol_id) REFERENCES volume(vol_id), 359 uri VARCHAR(255) NOT NULL UNIQUE, 360 sha1sum CHAR(40) ASCII, 361 assigned_vol_id INT, 362 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 363 mtime TIMESTAMP, 364 PRIMARY KEY(ins_id), 365 KEY(so_id), 366 KEY(vol_id), 367 KEY(uri(64)) 367 368 ) ENGINE=innodb; 368 369 -
trunk/Nebulous/Changes
r16244 r16259 2 2 3 3 0.07 4 - add additional fkey constrains to the instance table 5 - fix installation of neb-replicate & neb-cull 4 6 - redo database schema with foreign keys 5 7 - add Nebulous::Keys pod -
trunk/Nebulous/lib/Nebulous/Server/SQL.pm
r16244 r16259 1 1 # Copyright (c) 2004 Joshua Hoblitt 2 2 # 3 # $Id: SQL.pm,v 1.4 4 2008-01-26 02:04:46jhoblitt Exp $3 # $Id: SQL.pm,v 1.45 2008-01-28 19:48:08 jhoblitt Exp $ 4 4 5 5 package Nebulous::Server::SQL; … … 325 325 ### 326 326 327 CREATE TABLE instance (328 ins_id BIGINT NOT NULL AUTO_INCREMENT,329 so_id BIGINT NOT NULL,330 FOREIGN KEY(so_id) REFERENCES storage_object(so_id),331 vol_id INT NOT NULL,332 uri VARCHAR(255) NOT NULL UNIQUE,333 sha1sum CHAR(40) ASCII,334 assigned_vol_id INT,335 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,336 mtime TIMESTAMP,337 PRIMARY KEY(ins_id),338 KEY(so_id),339 KEY(vol_id),340 KEY(uri(64))341 ) ENGINE=innodb;342 343 ###344 345 327 CREATE TABLE lock_record ( 346 328 so_id BIGINT NOT NULL, … … 365 347 KEY(allocate), 366 348 KEY(available) 349 ) ENGINE=innodb; 350 351 ### 352 353 CREATE TABLE instance ( 354 ins_id BIGINT NOT NULL AUTO_INCREMENT, 355 so_id BIGINT NOT NULL, 356 FOREIGN KEY(so_id) REFERENCES storage_object(so_id), 357 vol_id INT NOT NULL, 358 FOREIGN KEY(vol_id) REFERENCES volume(vol_id), 359 uri VARCHAR(255) NOT NULL UNIQUE, 360 sha1sum CHAR(40) ASCII, 361 assigned_vol_id INT, 362 epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 363 mtime TIMESTAMP, 364 PRIMARY KEY(ins_id), 365 KEY(so_id), 366 KEY(vol_id), 367 KEY(uri(64)) 367 368 ) ENGINE=innodb; 368 369
Note:
See TracChangeset
for help on using the changeset viewer.
