1. Add Dummy Program Tables
SELECT contacts.* INTO dContacts
FROM Contacts
DELETE * FROM dContacts
ALTER TABLE dContacts
Alter Column ContactID counter PRIMARY KEY
SELECT organization.* INTO dOrganization
FROM organization
DELETE * FROM dOrganization
Alter Table dOrganization ADD Times varchar(50)
Alter Table dOrganization ADD visitor_ID long
Alter Table dOrganization Alter Column OrgID Counter PRIMARY KEY
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)
)
SELECT OrgtoProgramtype.* INTO dOrgtoProgramtype
FROM OrgtoProgramtype
DELETE * FROM dOrgtoProgramtype
Alter Table dOrgToProgramType Alter Column OrgPTID Counter PRIMARY KEY
SELECT OrgtoService.* INTO dOrgtoService
FROM OrgtoService
DELETE * FROM dOrgtoService
Alter Table dOrgToService Alter Column ServicetoOrgID Counter PRIMARY KEY
SELECT Service.* INTO dService
FROM Service
Alter Table dService Alter Column ServiceID Counter PRIMARY KEY
SELECT ProgramTypes.* INTO dProgramTypes
FROM ProgramTypes
Alter Table dProgramTypes Alter Column ProgramTypeID Counter PRIMARY KEY
SELECT TimeZone.* INTO dTimeZone
FROM TimeZone
The table already exists