Changeset 812 for trunk/app/config

Show
Ignore:
Timestamp:
10/12/08 13:13:45 (7 weeks ago)
Author:
aarkerio
Message:

Udate models

Files:
1 modified

Legend:

Unmodified
Added
Removed

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

    r771 r812  
    66 subject_id int REFERENCES subjects(id) NOT NULL, 
    77 created timestamp(0) with time zone DEFAULT now() NOT NULL, 
    8  status int NOT NULL DEFAULT 0, 
     8 status smallint NOT NULL DEFAULT 0, 
    99 user_id int REFERENCES users(id) ON DELETE CASCADE, 
    10  discution int NOT NULL DEFAULT 0,  -- discution, Activ/Desactiv   1/0 
     10 discution smallint NOT NULL DEFAULT 0,  -- discution, Activ/Desactiv   1/0 
    1111 "karanet" smallint NOT NULL DEFAULT 0 
    1212); 
    13 -- search engine index 
    14 CREATE INDEX entries_idx ON entries USING gin(to_tsvector('spanish', body)); 
    1513 
     14