Changeset 791 for trunk/app/config

Show
Ignore:
Timestamp:
10/02/08 18:47:46 (2 months ago)
Author:
aarkerio
Message:

Update SQL tables

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/app/config/sql/postgresql/messages.sql

    r436 r791  
    66    "created" timestamp(0) with time zone DEFAULT now() NOT NULL, 
    77    "level" int NOT NULL DEFAULT 0,  -- build the message thread if reply exist 
    8     "sender" int NOT NULL REFERENCES users(id) ON DELETE CASCADE, -- Who send the message 
     8    "sender_id" int NOT NULL REFERENCES users(id) ON DELETE CASCADE, -- Who send the message 
    99    "user_id" int NOT NULL REFERENCES users(id) ON DELETE CASCADE,  -- Who receive the message 
    1010    "status" smallint NOT NULL DEFAULT 0