Changeset 596 for trunk/app/config

Timestamp:

06/09/08 20:42:10 (6 months ago)

Author:

aarkerio

Message:

Update

Files:

• trunk/app/config/sql/postgresql/wikis.sql (modified) (2 diffs)

trunk/app/config/sql/postgresql/wikis.sql

@@ -2 +2 @@
 CREATE TABLE wikis (
   id serial PRIMARY KEY,
-  title varchar(255) NOT NULL,
+  title varchar(150) NOT NULL,
   content text NOT NULL,
   status smallint NOT NULL DEFAULT 0,
@@ -10 +10 @@
   ip varchar(15) NOT NULL,
   revision smallint NOT NULL,
-  accessed date NOT NULL
+  accessed date NOT NULL DEFAULT now()
 );