Changeset 3016 for trunk/Nebulous/t/Test/Nebulous.pm

Timestamp:

Jan 14, 2005, 6:02:12 PM (22 years ago)

Author:

jhoblitt

Message:

update database scheme for mysql 4.1 syntax

File:

• trunk/Nebulous/t/Test/Nebulous.pm (modified) (3 diffs)

trunk/Nebulous/t/Test/Nebulous.pm

@@ -1 +1 @@
 # Copyright (C) 2004  Joshua Hoblitt
 #
-# $Id: Nebulous.pm,v 1.1.1.1 2004-12-22 02:16:23 jhoblitt Exp $
+# $Id: Nebulous.pm,v 1.2 2005-01-15 04:02:12 jhoblitt Exp $
 
 package Test::IData;
@@ -68 +68 @@
     read_lock TINYINT DEFAULT 0 NOT NULL,
     write_lock ENUM( 'write' ),
-    epoch TIMESTAMP NOT NULL,
+    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    mtime TIMESTAMP,
     PRIMARY KEY(so_id),
     KEY(ext_id(64)),
@@ -78 +79 @@
     ins_id BIGINT NOT NULL AUTO_INCREMENT,
     so_id BIGINT NOT NULL,
-    uri VARCHAR(255) BINARY NOT NULL UNIQUE,
-    sha1sum CHAR(40),
+    uri VARCHAR(255) BINARY NOT NULL,
+    sha1sum CHAR(40) ASCII,
     assigned_location BOOL,
-    epoch TIMESTAMP NOT NULL,
-    atime TIMESTAMP NOT NULL,
+    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    mtime TIMESTAMP,
     PRIMARY KEY(ins_id),
     KEY(so_id),