Changeset 773 for trunk/app/config

Show
Ignore:
Timestamp:
09/22/08 23:22:18 (2 months ago)
Author:
aarkerio
Message:

Test Unit fixed

Location:
trunk/app/config/sql/postgresql
Files:
2 modified

Legend:

Unmodified
Added
Removed

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

    r688 r773  
    11--                     --- 
    22--   KARAMELO TABLES   --- Chipotle Software 2002-2008 
    3 --                     ---  
    4 -- Name: groups; Type: TABLE; Schema: public; Owner: www-data; Tablespace:  
    5  
    6 -- College information 
    73 
    84\i ./colleges.sql 
    … …  
    7066\i ./results.sql       
    7167\i ./participations.sql 
     68\i ./chats.sql 
    7269 
    7370\i ./shares.sql 
    7471\i ./metadatas.sql 
     72-- ** School resource (Books, CDs, DVDs, Magazines, etc) ** 
    7573\i ./resources.sql 
    7674 
    … …  
    8583\i ./uploads.sql 
    8684\i ./reports.sql 
    87 \i ./comments_lessons.sql 
     85-- ** Comments in Lesson model ** 
    8886\i ./annotations.sql 

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

    r745 r773  
    66   test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE, 
    77   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, 
    8    created timestamp(0) with time zone DEFAULT now() NOT NULL 
     8   created timestamp(0) with time zone DEFAULT now() NOT NULL, 
    99   PRIMARY KEY (user_id, test_id, vclassroom_id, question_id) 
    1010);