Changeset 3016 for trunk/Nebulous/lib

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/lib/Nebulous/Server/SQL.pm (modified) (3 diffs)

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.3 2005-01-05 03:19:12 jhoblitt Exp $
+# $Id: SQL.pm,v 1.4 2005-01-15 04:02:12 jhoblitt Exp $
 
 package PS::IPP::IData::Server::SQL;
@@ -24 +24 @@
     new_object          => qq{
         INSERT INTO storage_object
-        VALUES (NULL, ?, ?, ?, 0, NULL, NULL)
+        (so_id, ext_id, class_id, comment, read_lock, write_lock)
+        VALUES (NULL, ?, ?, ?, 0, NULL)
     },
     delete_object       => qq{
@@ -39 +40 @@
     },
     get_object          => qq{
-        SELECT *
+        SELECT so_id, ext_id, class_id, comment, read_lock, write_lock, epoch, mtime
         FROM storage_object
         WHERE ext_id = ?