Changeset 4875

Timestamp:

Aug 24, 2005, 4:17:39 PM (21 years ago)

Author:

jhoblitt

Message:

add log table

Location:

trunk

Files:

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

trunk/Nebulous-Server/docs/database_setup.txt

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: database_setup.txt,v 1.4 2005-07-29 04:02:01 jhoblitt Exp $
+# $Id: database_setup.txt,v 1.5 2005-08-25 02:17:39 jhoblitt Exp $
 
 ### Database Setup
@@ -68 +68 @@
     ) ENGINE=innodb;
 
+DROP TABLE IF EXISTS log;
+CREATE TABLE log (
+    timestamp TIMESTAMP,
+    hostname VARCHAR(255),
+    level VARCHAR(255),
+    sub VARCHAR(255),    
+    message VARCHAR(2048) NOT NULL,
+    PRIMARY KEY(timestamp)
+) ENGINE=innodb;
+
+
 ### Initialization
+
+# localhost
+
+$ mkdir /tmp/po01 /tmp/po02
+INSERT INTO volume VALUES (1,'po01','file:/tmp/po01');
+INSERT INTO volume VALUES (1,'po02','file:/tmp/po02');
 
 # NFS

trunk/Nebulous/docs/database_setup.txt

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: database_setup.txt,v 1.4 2005-07-29 04:02:01 jhoblitt Exp $
+# $Id: database_setup.txt,v 1.5 2005-08-25 02:17:39 jhoblitt Exp $
 
 ### Database Setup
@@ -68 +68 @@
     ) ENGINE=innodb;
 
+DROP TABLE IF EXISTS log;
+CREATE TABLE log (
+    timestamp TIMESTAMP,
+    hostname VARCHAR(255),
+    level VARCHAR(255),
+    sub VARCHAR(255),    
+    message VARCHAR(2048) NOT NULL,
+    PRIMARY KEY(timestamp)
+) ENGINE=innodb;
+
+
 ### Initialization
+
+# localhost
+
+$ mkdir /tmp/po01 /tmp/po02
+INSERT INTO volume VALUES (1,'po01','file:/tmp/po01');
+INSERT INTO volume VALUES (1,'po02','file:/tmp/po02');
 
 # NFS