← Back to branch summary

~kfader/mvhub/pages.t-too-slow

« back to all changes in this revision

Viewing changes to app-mvhub/setup/old_database/add_data_entry_program.sql

  • Committer: Keith Fader
  • Date: 2010-10-08 20:09:01 UTC
  • mfrom: (501.2.3 trunk)
  • Revision ID: kfader@thecsl.org-20101008200901-sqopqsvdfvexb4u2
Fixed add_mech_objects to initialize new mech object each time. Modified TestHelper to use cached mech objects for consistency

Show diffs side-by-side

added added

removed removed

Lines of Context:
app-mvhub/setup/old_database/add_data_entry_program.sql
1
 
/* Revision 1.1 */
2
 
 
3
 
/* SQL code used to re-insert program into data entry table following gaffe
4
 
   described in CVS logs for agency_form.pl */
5
 
 
6
 
INSERT INTO data_entry_program
7
 
( program_id,
8
 
agency_id,
9
 
program_name,
10
 
updated_by,
11
 
update_status,
12
 
address1,
13
 
city,
14
 
state,
15
 
zip,
16
 
main_phone,
17
 
website,
18
 
email,
19
 
short_program_description,
20
 
long_program_description,
21
 
eligibility,
22
 
fees_charged,
23
 
fees_explained,
24
 
program_schedule,
25
 
hours,
26
 
languages,
27
 
appointment,
28
 
bring,
29
 
handicapped_accessible,
30
 
child_care_provided,
31
 
wait_list,
32
 
volunteer_opportunities,
33
 
volunteer_information,
34
 
resource_library,
35
 
meeting_space,
36
 
meeting_space_description,
37
 
news_letter,
38
 
news_letter_description,
39
 
public_net_access,
40
 
public_net_access_description,
41
 
contact_first_name,
42
 
contact_last_name,
43
 
contact_phone,
44
 
contact_email,
45
 
contact_email_available,
46
 
area_type,
47
 
area_data,
48
 
areas_served_description,
49
 
online_registration
50
 
)
51
 
VALUES
52
 
(,
53
 
,
54
 
'',
55
 
,
56
 
,
57
 
'',
58
 
'',
59
 
'',
60
 
'',
61
 
'',
62
 
'',
63
 
'',
64
 
'',
65
 
'',
66
 
'',
67
 
'',
68
 
'',
69
 
'',
70
 
'',
71
 
'',
72
 
'',
73
 
'',
74
 
'',
75
 
'',
76
 
'',
77
 
'',
78
 
'',
79
 
'',
80
 
'',
81
 
'',
82
 
'',
83
 
'',
84
 
'',
85
 
'',
86
 
'',
87
 
'',
88
 
'',
89
 
'',
90
 
'',
91
 
'',
92
 
'',
93
 
'',
94
 
''
95
 
);