1 neenan 1.1 <!--- Name: createprogramtables.cfm
2 Purpose: The purpose of the file is to copy 3 existing tables as dummy tables with data in the programs database
3 and also create 5 additional tables with empty datarograms database.
4 Date created: 03/08/2005
5 Dependancy:
6 Variables:
7 Date changed: 03/08/2005 Prabin, Neena Created
8 --->
9
10
11 <cfparam name="action" default="">
12
13 <a href="createprogramtables.cfm?action=add">1. Add Dummy Program Tables</a>
14
15 <cfif action IS "add">
16 <cftry>
17 <!-- change the datasource name to your datasource name, you can find the name at application.cfm --->
18 <!--- DContacts table queries --->
19 <cfquery name="addContactTable" datasource="#programsdb#">
20 SELECT contacts.* INTO dContacts
21 FROM Contacts
22 neenan 1.1 </cfquery>
23
24 <cfquery name="deleteOrgRecords" datasource="#programsdb#">
25 DELETE * FROM dContacts
26 </cfquery>
27
28 <cfquery name="altercontactid" datasource="#programsdb#">
29 ALTER TABLE dContacts
30 Alter Column ContactID counter PRIMARY KEY
31 </cfquery>
32
33 <!--- Dorganization Table --->
34 <cfquery name="addOrgTable" datasource="#programsdb#">
35 SELECT organization.* INTO dOrganization
36 FROM organization
37 </cfquery>
38
39 <cfquery name="deleteOrgRecords" datasource="#programsdb#">
40 DELETE * FROM dOrganization
41 </cfquery>
42
43 neenan 1.1 <cfquery name="appendTimesField" datasource="#programsdb#">
44 Alter Table dOrganization ADD Times varchar(50)
45 </cfquery>
46
47 <cfquery name="appendVisitorIDField" datasource="#programsdb#">
48 Alter Table dOrganization ADD visitor_ID long
49 </cfquery>
50
51 <cfquery name="alterOrgID" datasource="#programsdb#">
52 Alter Table dOrganization Alter Column OrgID Counter PRIMARY KEY
53 </cfquery>
54
55 <!--- OutsideUsers table queries --->
56 <cfquery name="addOutsideUsersTable" datasource="#programsdb#">
57 Create table OutsideUsers
58 (visitor_ID counter,
59 fname varchar(30) not null,
60 lname varchar(30) not null,
61 Phone_Number varchar(15),
62 Email varchar(50),
63 OrgID long,
64 neenan 1.1 Vtime varchar(50),
65 Primary key (visitor_ID)
66 )
67 </cfquery>
68
69 <!--- dOrgToProgramType table queries --->
70
71 <cfquery name="addOrgToProgramType" datasource="#programsdb#">
72 SELECT OrgtoProgramtype.* INTO dOrgtoProgramtype
73 FROM OrgtoProgramtype
74 </cfquery>
75
76 <cfquery name="deleteOrgtoProgramtypeRecords" datasource="#programsdb#">
77 DELETE * FROM dOrgtoProgramtype
78 </cfquery>
79
80 <cfquery name="alterOrgPTID" datasource="#programsdb#">
81 Alter Table dOrgToProgramType Alter Column OrgPTID Counter PRIMARY KEY
82 </cfquery>
83
84 <!--- dOrgToService table queries --->
85 neenan 1.1
86 <cfquery name="addOrgtoServiceType" datasource="#programsdb#">
87 SELECT OrgtoService.* INTO dOrgtoService
88 FROM OrgtoService
89 </cfquery>
90
91 <cfquery name="deleteOrgtoServiceRecords" datasource="#programsdb#">
92 DELETE * FROM dOrgtoService
93 </cfquery>
94
95 <cfquery name="alterServicetoOrgID" datasource="#programsdb#">
96 Alter Table dOrgToService Alter Column ServicetoOrgID Counter PRIMARY KEY
97 </cfquery>
98
99 <!--- dService table queries --->
100
101 <cfquery name="addService" datasource="#programsdb#">
102 SELECT Service.* INTO dService
103 FROM Service
104 </cfquery>
105
106 neenan 1.1 <cfquery name="alterServiceID" datasource="#programsdb#">
107 Alter Table dService Alter Column ServiceID Counter PRIMARY KEY
108 </cfquery>
109
110 <!--- dProgramTypes table queries --->
111 <cfquery name="addProgramTypes" datasource="#programsdb#">
112 SELECT ProgramTypes.* INTO dProgramTypes
113 FROM ProgramTypes
114 </cfquery>
115
116 <cfquery name="alterProgramTypeID" datasource="#programsdb#">
117 Alter Table dProgramTypes Alter Column ProgramTypeID Counter PRIMARY KEY
118 </cfquery>
119
120 <!--- dTimeZone table queries --->
121 <cfquery name="addTimeZone" datasource="#programsdb#">
122 SELECT TimeZone.* INTO dTimeZone
123 FROM TimeZone
124 </cfquery>
125
126 <cfcatch type="database">
127 neenan 1.1 <cfif cfcatch.Errorcode IS "S0001">
128 <p> The table already exists
129 </cfif>
130 </cfcatch>
131
132 </cftry>
133 </cfif>
134
135
136
|
Return to
createprogramtables.cfm
CVS log
Up to [Development] / p2rx-programs