## Table CREATE TABLE `CUSTOMER_PLAN` ( `RowId` int(11) unsigned NOT NULL auto_increment, `Name` varchar(6) default NULL, `Credits` smallint(6) unsigned default NULL, `Price` decimal(8,2) default NULL, `Credit_Value` decimal(3,2) default NULL, `Status` char(1) default NULL, # A=Active, I=Inactive `Display_Order` char(3) default NULL, `Description` varchar(255) default NULL, PRIMARY KEY (RowId), KEY planname (Name), KEY descript (Description(15)), KEY dispord (Display_Order) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ## Data INSERT INTO `CUSTOMER_PLAN` VALUES(1, 'Free', 0, 0.00, 0.75, 'A', '001', 'Try us out - receive 3 free recipes.'); INSERT INTO `CUSTOMER_PLAN` VALUES(2, 'Shine', 12, 9.75, 0.75, 'A', '002', 'Shine with a small introduction to Vibrant Healthy Living.'); INSERT INTO `CUSTOMER_PLAN` VALUES(3, 'Seeker', 35, 18.75, 0.75, 'A', '003', '-noun. An adventurous person who is seeking new experiences and new information to create a higher level of understanding and enlightenment.'); INSERT INTO `CUSTOMER_PLAN` VALUES(4, 'Sage', 60, 47.00, 0.75, 'A', '004', '-noun. A generous, lively person on the journey for the possession of wisdom and experience. This person is energetic, vibrant and famed for health and wisdom.'); INSERT INTO `CUSTOMER_PLAN` VALUES(5, 'Guru', 120, 89.00, 0.75, 'A', '005', '-noun. A divine teacher. This person has vast knowledge and practices vibrant living while sharing with their community to create a greater understanding and manifestation of truth and beauty.');