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

Timestamp:

Jun 24, 2009, 2:58:11 PM (17 years ago)

Author:

jhoblitt

Message:

schema changes for clarity (not semantic change)

File:

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

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

@@ -466 +466 @@
 CREATE TABLE storage_object (
     so_id BIGINT NOT NULL AUTO_INCREMENT,
-    ext_id VARCHAR(255) NOT NULL UNIQUE,
+    ext_id VARCHAR(255) NOT NULL,
     ext_id_basename VARCHAR(255) NOT NULL,
     dir_id BIGINT NOT NULL,
@@ -472 +472 @@
     type enum('REG_FILE'),
     PRIMARY KEY(so_id),
+    UNIQUE KEY(ext_id),
     KEY(dir_id),
     KEY(type)
@@ -514 +515 @@
 CREATE TABLE volume (
     vol_id INT NOT NULL AUTO_INCREMENT,
-    name VARCHAR(255) UNIQUE NOT NULL,
+    name VARCHAR(255) NOT NULL,
     host VARCHAR(255) NOT NULL,
-    path VARCHAR(255) UNIQUE NOT NULL,
+    path VARCHAR(255) NOT NULL,
     allocate BOOLEAN DEFAULT FALSE,
     available BOOLEAN DEFAULT FALSE,
@@ -522 +523 @@
     mountpoint VARCHAR(255) NOT NULL,
     PRIMARY KEY(vol_id),
+    UNIQUE KEY(name),
+    UNiQUE KEY(path),
     KEY(host(16)),
-    KEY(mountpoint(255)),
     KEY(allocate),
-    KEY(available)
+    KEY(available),
+    KEY(mountpoint(255))
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -531 +534 @@
 
 CREATE TABLE mountedvol(
-    vol_id INT UNIQUE NOT NULL,
+    vol_id INT NOT NULL,
     FOREIGN KEY(vol_id) REFERENCES volume(vol_id) ON DELETE CASCADE,
     name VARCHAR(255) NOT NULL,