Return to createprogramtables.cfm CVS log

Up to [Development] / p2rx-programs

*** empty log message ***

<!--- 	Name: createprogramtables.cfm 
       	Purpose: The purpose of the file is to copy 3 existing tables as dummy tables with data in the programs database
				 and also create 5 additional tables with empty datarograms database. 
	   	Date created: 03/08/2005
       	Dependancy:  
	   	Variables: 	
	   	Date changed:   03/08/2005     	Prabin, Neena    Created 
---> 


<cfparam name="action" default="">

<a href="createprogramtables.cfm?action=add">1. Add Dummy Program Tables</a>

<cfif action IS "add">
<cftry>
	<!-- change the datasource name to your datasource name, you can find the name at application.cfm --->
	<!--- DContacts table queries ---> 
	<cfquery name="addContactTable" datasource="#programsdb#">
	SELECT contacts.* INTO dContacts
	FROM Contacts
	</cfquery>
	
	<cfquery name="deleteOrgRecords" datasource="#programsdb#">
	DELETE * FROM dContacts
	</cfquery> 
	
	<cfquery name="altercontactid" datasource="#programsdb#">
 	 ALTER TABLE dContacts 
	 Alter Column ContactID counter PRIMARY KEY
	</cfquery>  
	
	<!--- Dorganization Table ---> 
	<cfquery name="addOrgTable" datasource="#programsdb#">
	SELECT organization.* INTO dOrganization
	FROM organization
	</cfquery>
	
	<cfquery name="deleteOrgRecords" datasource="#programsdb#">
	DELETE * FROM dOrganization
	</cfquery>
	
	<cfquery name="appendTimesField" datasource="#programsdb#">
	Alter Table dOrganization ADD Times varchar(50)
	</cfquery>
	
	<cfquery name="appendVisitorIDField" datasource="#programsdb#">
	Alter Table dOrganization ADD visitor_ID long
	</cfquery> 

	<cfquery name="alterOrgID" datasource="#programsdb#">
	Alter Table dOrganization Alter Column OrgID Counter PRIMARY KEY
	</cfquery> 
		
	<!--- OutsideUsers table queries ---> 
	<cfquery name="addOutsideUsersTable" datasource="#programsdb#">
	Create table OutsideUsers
	(visitor_ID counter,
	fname varchar(30) not null,
	lname varchar(30) not null,
	Phone_Number varchar(15),
	Email varchar(50),
	OrgID long,
	Vtime varchar(50),
    Primary key (visitor_ID)
	)
	</cfquery>
	
	<!--- dOrgToProgramType table queries ---> 
	
	<cfquery name="addOrgToProgramType" datasource="#programsdb#">
	SELECT OrgtoProgramtype.* INTO dOrgtoProgramtype
	FROM OrgtoProgramtype
	</cfquery>
	
	<cfquery name="deleteOrgtoProgramtypeRecords" datasource="#programsdb#">
	DELETE * FROM dOrgtoProgramtype
	</cfquery>
	
	<cfquery name="alterOrgPTID" datasource="#programsdb#">
	Alter Table dOrgToProgramType Alter Column OrgPTID Counter PRIMARY KEY
	</cfquery> 

	<!--- dOrgToService table queries ---> 			
	
	<cfquery name="addOrgtoServiceType" datasource="#programsdb#">
	SELECT OrgtoService.* INTO dOrgtoService
	FROM OrgtoService
	</cfquery>
	
	<cfquery name="deleteOrgtoServiceRecords" datasource="#programsdb#">
	DELETE * FROM dOrgtoService
	</cfquery> 
	
	<cfquery name="alterServicetoOrgID" datasource="#programsdb#">
	Alter Table dOrgToService Alter Column ServicetoOrgID Counter PRIMARY KEY
	</cfquery> 
		
	<!--- dService table queries ---> 		
	
	<cfquery name="addService" datasource="#programsdb#">
	SELECT Service.* INTO dService
	FROM Service
	</cfquery>
	
	<cfquery name="alterServiceID" datasource="#programsdb#">
	Alter Table dService Alter Column ServiceID Counter PRIMARY KEY
	</cfquery> 
	
	<!--- dProgramTypes table queries ---> 		
	<cfquery name="addProgramTypes" datasource="#programsdb#">
	SELECT ProgramTypes.* INTO dProgramTypes
	FROM ProgramTypes
	</cfquery>
	
	<cfquery name="alterProgramTypeID" datasource="#programsdb#">
	Alter Table dProgramTypes Alter Column ProgramTypeID Counter PRIMARY KEY
	</cfquery> 
	
	<!--- dTimeZone table queries ---> 		
	<cfquery name="addTimeZone" datasource="#programsdb#">
	SELECT TimeZone.* INTO dTimeZone
	FROM TimeZone
	</cfquery> 
		
	<cfcatch type="database">
		<cfif cfcatch.Errorcode IS "S0001">
	<p>	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The table already exists
		</cfif>
	</cfcatch>

</cftry>
</cfif>