Fix datatype
authorpnixon <pnixon>
Sat, 19 Mar 2005 18:47:27 +0000 (18:47 +0000)
committerpnixon <pnixon>
Sat, 19 Mar 2005 18:47:27 +0000 (18:47 +0000)
dialup_admin/sql/oracle/badusers.sql

index 1f831ff..7c29ed3 100644 (file)
@@ -10,7 +10,7 @@
 CREATE TABLE badusers (
        id              INT PRIMARY KEY,
        username        VARCHAR(30) NOT NULL,
-       actiondate      DATE,
+       actiondate      TIMESTAMP WITH TIME ZONE,
        reason          VARCHAR(128) NOT NULL,
        admin           VARCHAR(128) NOT NULL
 );