Changeset 5479

Timestamp:

Nov 4, 2005, 4:46:32 PM (21 years ago)

Author:

jhoblitt

Message:

split storage_object table -> storage_object & storage_object_attr

Location:

trunk

Files:

• Nebulous-Server/docs/database_setup.txt (modified) (3 diffs)
• Nebulous/docs/database_setup.txt (modified) (3 diffs)

trunk/Nebulous-Server/docs/database_setup.txt

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: database_setup.txt,v 1.5 2005-08-25 02:17:39 jhoblitt Exp $
+# $Id: database_setup.txt,v 1.6 2005-11-05 02:46:32 jhoblitt Exp $
 
 ### Database Setup
@@ -18 +18 @@
     so_id BIGINT NOT NULL AUTO_INCREMENT,
     ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
+    PRIMARY KEY(so_id),
+    KEY(ext_id(64)),
+) ENGINE=innodb;
+
+DROP TABLE IF EXISTS storage_attr ;
+CREATE TABLE storage_attr (
+    so_id BIGINT NOT NULL AUTO_INCREMENT,
     class_id TINYINT NOT NULL,
     comment VARCHAR(255),
@@ -25 +32 @@
     mtime TIMESTAMP,
     PRIMARY KEY(so_id),
-    KEY(ext_id(64)),
     KEY(class_id)
 ) ENGINE=innodb;

trunk/Nebulous/docs/database_setup.txt

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: database_setup.txt,v 1.5 2005-08-25 02:17:39 jhoblitt Exp $
+# $Id: database_setup.txt,v 1.6 2005-11-05 02:46:32 jhoblitt Exp $
 
 ### Database Setup
@@ -18 +18 @@
     so_id BIGINT NOT NULL AUTO_INCREMENT,
     ext_id VARCHAR(255) BINARY NOT NULL UNIQUE,
+    PRIMARY KEY(so_id),
+    KEY(ext_id(64)),
+) ENGINE=innodb;
+
+DROP TABLE IF EXISTS storage_attr ;
+CREATE TABLE storage_attr (
+    so_id BIGINT NOT NULL AUTO_INCREMENT,
     class_id TINYINT NOT NULL,
     comment VARCHAR(255),
@@ -25 +32 @@
     mtime TIMESTAMP,
     PRIMARY KEY(so_id),
-    KEY(ext_id(64)),
     KEY(class_id)
 ) ENGINE=innodb;