# - testing cvs
### Steps to setup a new client on 
## an RPS DEV server.

1. Create database in mysql:

	mysql> create database C_SANCTUARY;

2. Create tables in database:

	mysql> use C_SANCTUARY;
	mysql> source /app/tools/rps/sql/create/RPS_CLIENT_DB.sql;

3. Seed tables with defaults:

	Some tables need at least one row in them in order
	for the RPS app to work properly. Here is the list of tables
	that you should check:

	- channel
	- deduction_type
	- label
	- price_level
	- product_status
	- product_price (I don't think this one needs any defaults -jff-)
	- product_format
	- product_type
	- service
	- statement_type
	- income_source
	- contract_rate_type

	In most cases it's easiest to just copy the tables from existing database, like this:

	Example:
		INSERT INTO label (label_name,label_name_clean,date_created) VALUES ('Sanctuary','sanctuary',now());

	Copy values from other database:
		insert into channel (select * from C_DUALTONE.channel);
		insert into deduction_type (select * from C_DUALTONE.deduction_type);
		insert into price_level (select * from C_DUALTONE.price_level);
		INSERT INTO product_status (SELECT * FROM C_DUALTONE.product_status);
		INSERT INTO product_format (SELECT * FROM C_DUALTONE.product_format);
		INSERT INTO product_type (SELECT * FROM C_DUALTONE.product_type);
		INSERT INTO statement_type (SELECT * FROM C_DUALTONE.statement_type);
		INSERT INTO income_source (SELECT * FROM C_DUALTONE.income_source);
		INSERT INTO contract_rate_type (SELECT * FROM C_DUALTONE.contract_rate_type);

		INSERT INTO service (SELECT * FROM C_DUALTONE.service);
		or
		CREATE TABLE service (SELECT * FROM C_DUALTONE.service);

	**Be careful with this because you should only populate the service table with services known to that client.

4. Add this client to /app/tools/common/lib/Common/Consts.pm

5. Add the client to the vhost files:
	- /usr/local/apache/conf/vhosts.conf
	- /usr/local/apache/conf/vhosts_ssl.conf

6. Add client to your hosts file (if necessary)

7. restart server and test page.