OpenACS

hamiltonc
committed
MAIN:hamiltonc:20050805040206
on 05 Aug 05
fixed a line in dotlrn ecommerce create
/postgresql/dotlrn-ecommerce-create.sql (+2 -2)
1 1 --
2 2 -- packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql
3 3 --
4 4 -- @author Roel Canicula (roelmc@pldtdsl.net)
5 5 -- @creation-date 2005-05-14
6 6 -- @arch-tag: 8371aa52-3001-45da-9391-e181130bbedf
7 7 -- @cvs-id $Id$
8 8 --
9 9
10 10 --- creating table to add section
11 11
12 12 create table dotlrn_ecommerce_section (
13 13         section_id      integer primary key,
14 14         course_id       integer references cr_items(item_id),
15 15         community_id    integer references dotlrn_communities_all(community_id),
16           product_id      integer references  ec_products,
  16         product_id      integer references ec_products(product_id),
17 17         section_name    varchar(2000),
18 18         age             varchar(2000),
19 19         date_time_start timestamptz,      
20 20         date_time_end   timestamptz,
21 21         daily_p         char(1) check (daily_p in ('t','f')),
22 22         weekly_p        char(1) check (weekly_p in ('t','f')),  
23 23         qualified_age_low   integer,
24 24         qualified_age_high  integer,
25 25         account_code_revenue varchar(100),
26 26         account_code_expense varchar(100),
27 27         max_participants     integer,
28 28         waiting_list_p       char(1) check (waiting_list_p in ('t','f')),
29 29         notify_waiting_number integer,
30 30         member_price_number   numeric,
31 31         non_member_price      numeric,
32 32         show_participants_p   char(1) check (show_participants_p in ('t','f')),
33 33         show_sessions_p       char(1) check (show_sessions_p in ('t','f')),
34 34         description           text
35 35 );
36 36