Changeset 371 for trunk/app/config

Timestamp:

04/07/08 13:37:00 (8 months ago)

Author:

aarkerio

Message:

Wiki first addition

Location:

trunk/app/config

Files:

• core.php (modified) (1 diff)
• sql/karamelo_postgres.sql (modified) (3 diffs)

trunk/app/config/core.php

@@ -14 +14 @@
  * In development mode, you need to click the flash message to continue.
  */
-    Configure::write('debug', 2);
+    Configure::write('debug', 1);
 /**
  * Application wide charset encoding

trunk/app/config/sql/karamelo_postgres.sql

@@ -657 +657 @@
   title varchar(255) NOT NULL,
   content text NOT NULL,
-  access smallint NOT NULL DEFAULT 0,
+  status smallint NOT NULL DEFAULT 0,
   modified timestamp NOT NULL default now(),
-  user_id serial NOT NULL,
+  user_id int NOT NULL REFERENCES users(id),
+  subject_id smallint NOT NULL REFERENCES subjects(id),
   ip varchar(15) NOT NULL,
-  revision int(5) NOT NULL,
-  accessed datetime NOT NULL
+  revision smallint NOT NULL,
+  accessed date NOT NULL
 );
 
@@ -671 +672 @@
   access smallint NOT NULL default 0,
   modified timestamp NOT NULL default now(),
-  user_id serial NOT NULL,
+  user_id int NOT NULL,
   ip varchar(15) NOT NULL,
-  revision int(5) NOT NULL,
+  revision smallint NOT NULL,
   accessed date NOT NULL default now()
 );
 
 CREATE TABLE settings (
-  id serial PRIMARY KEY,
-  name varchar(50) NOT NULL UNIQUE,
-  value varchar(255) NOT NULL,
-  default varchar(255) NOT NULL,
-  description varchar(255) NOT NULL
+  "id" serial PRIMARY KEY,
+  "name" varchar(50) NOT NULL UNIQUE,
+  "value" varchar(255) NOT NULL,
+  "default" varchar(255) NOT NULL,
+  "description" varchar(255) NOT NULL
 );
 
@@ -693 +694 @@
   user_id int NOT NULL REFERENCES users(id),
   ip varchar(15) NOT NULL,
-  revision int NOT NULL
+  revision smallint NOT NULL
 );