# Table structure for table 'chastro'
CREATE TABLE chastro (
date1 varchar(8) NOT NULL,
date2 varchar(8) NOT NULL,
sign varchar(12) NOT NULL
);
# Table structure for table 'matches'
CREATE TABLE matches (
sign1 varchar(15) NOT NULL,
sign2 varchar(15) NOT NULL,
m_descript text NOT NULL
);
# Table structure for table 'signs'
CREATE TABLE signs (
signs varchar(20) DEFAULT '1' NOT NULL,
description text NOT NULL,
image varchar(25) DEFAULT '1' NOT NULL,
symbol varchar(30) DEFAULT '1' NOT NULL,
header varchar(100) DEFAULT '1' NOT NULL,
people text NOT NULL,
jobs text NOT NULL,
numbers varchar(100) DEFAULT '1' NOT NULL,
compat varchar(60) DEFAULT '1' NOT NULL,
westsign varchar(25) DEFAULT '1' NOT NULL,
plural varchar(20) DEFAULT '1' NOT NULL
);
# Data for table 'chastro'
INSERT INTO chastro VALUES ( '18990101', '19000130', 'PIG');
INSERT INTO chastro VALUES ( '19000131', '19010218', 'RAT');
INSERT INTO chastro VALUES ( '19010219', '19020207', 'OX');
INSERT INTO chastro VALUES ( '19020208', '19030128', 'TIGER');
INSERT INTO chastro VALUES ( '19030129', '19040215', 'RABBIT');
INSERT INTO chastro VALUES ( '19040216', '19050203', 'DRAGON');
INSERT INTO chastro VALUES ( '19050204', '19060124', 'SNAKE');
INSERT INTO chastro VALUES ( '19060125', '19070212', 'HORSE');
INSERT INTO chastro VALUES ( '19070213', '19080201', 'GOAT');
INSERT INTO chastro VALUES ( '19080202', '19090121', 'MONKEY');
INSERT INTO chastro VALUES ( '19090122', '19100209', 'ROOSTER');
INSERT INTO chastro VALUES ( '19100210', '19110129', 'DOG');
INSERT INTO chastro VALUES ( '19110130', '19120217', 'PIG');
INSERT INTO chastro VALUES ( '19120218', '19130205', 'RAT');
INSERT INTO chastro VALUES ( '19130206', '19140125', 'OX');
INSERT INTO chastro VALUES ( '19140126', '19150213', 'TIGER');
INSERT INTO chastro VALUES ( '19150214', '19160202', 'RABBIT');
INSERT INTO chastro VALUES ( '19160203', '19170122', 'DRAGON');
INSERT INTO chastro VALUES ( '19170123', '19180210', 'SNAKE');
INSERT INTO chastro VALUES ( '19180211', '19190131', 'HORSE');
INSERT INTO chastro VALUES ( '19190201', '19200219', 'GOAT');
INSERT INTO chastro VALUES ( '19200220', '19210207', 'MONKEY');
INSERT INTO chastro VALUES ( '19210208', '19220127', 'ROOSTER');
INSERT INTO chastro VALUES ( '19220128', '19230215', 'DOG');
INSERT INTO chastro VALUES ( '19230216', '19240204', 'PIG');
INSERT INTO chastro VALUES ( '19240205', '19250123', 'RAT');
INSERT INTO chastro VALUES ( '19250124', '19260212', 'OX');
INSERT INTO chastro VALUES ( '19260213', '19270201', 'TIGER');
INSERT INTO chastro VALUES ( '19270202', '19280122', 'RABBIT');
INSERT INTO chastro VALUES ( '19280123', '19290209', 'DRAGON');
INSERT INTO chastro VALUES ( '19290210', '19300129', 'SNAKE');
INSERT INTO chastro VALUES ( '19300130', '19310216', 'HORSE');
INSERT INTO chastro VALUES ( '19310217', '19320205', 'GOAT');
INSERT INTO chastro VALUES ( '19320206', '19330125', 'MONKEY');
INSERT INTO chastro VALUES ( '19330126', '19340213', 'ROOSTER');
INSERT INTO chastro VALUES ( '19340214', '19350203', 'DOG');
INSERT INTO chastro VALUES ( '19350204', '19360123', 'PIG');
INSERT INTO chastro VALUES ( '19360124', '19370210', 'RAT');
INSERT INTO chastro VALUES ( '19370211', '19380130', 'OX');
INSERT INTO chastro VALUES ( '19380131', '19390218', 'TIGER');
INSERT INTO chastro VALUES ( '19390219', '19400207', 'RABBIT');
INSERT INTO chastro VALUES ( '19400208', '19410126', 'DRAGON');
INSERT INTO chastro VALUES ( '19410127', '19420214', 'SNAKE');
INSERT INTO chastro VALUES ( '19420215', '19430204', 'HORSE');
INSERT INTO chastro VALUES ( '19430205', '19440124', 'GOAT');
INSERT INTO chastro VALUES ( '19440125', '19450212', 'MONKEY');
INSERT INTO chastro VALUES ( '19450213', '19460201', 'ROOSTER');
INSERT INTO chastro VALUES ( '19460202', '19470121', 'DOG');
INSERT INTO chastro VALUES ( '19480210', '19490128', 'RAT');
INSERT INTO chastro VALUES ( '19470122', '19480209', 'PIG');
INSERT INTO chastro VALUES ( '19490129', '19500216', 'OX');
INSERT INTO chastro VALUES ( '19500217', '19510205', 'TIGER');
INSERT INTO chastro VALUES ( '19510206', '19520126', 'RABBIT');
INSERT INTO chastro VALUES ( '19520127', '19530213', 'DRAGON');
INSERT INTO chastro VALUES ( '19530214', '19540202', 'SNAKE');
INSERT INTO chastro VALUES ( '19540203', '19550123', 'HORSE');
INSERT INTO chastro VALUES ( '19550124', '19569211', 'GOAT');
INSERT INTO chastro VALUES ( '19560212', '19570130', 'MONKEY');
INSERT INTO chastro VALUES ( '19570131', '19580217', 'ROOSTER');
INSERT INTO chastro VALUES ( '19580218', '19590207', 'DOG');
INSERT INTO chastro VALUES ( '19590208', '19600127', 'PIG');
INSERT INTO chastro VALUES ( '19600128', '19610214', 'RAT');
INSERT INTO chastro VALUES ( '19610215', '19620204', 'OX');
INSERT INTO chastro VALUES ( '19620205', '19639124', 'TIGER');
INSERT INTO chastro VALUES ( '19630125', '19640212', 'RABBIT');
INSERT INTO chastro VALUES ( '19640213', '19650201', 'DRAGON');
INSERT INTO chastro VALUES ( '19650202', '19660120', 'SNAKE');
INSERT INTO chastro VALUES ( '19660121', '19670208', 'HORSE');
INSERT INTO chastro VALUES ( '19670209', '19680129', 'GOAT');
INSERT INTO chastro VALUES ( '19680130', '19690216', 'MONKEY');
INSERT INTO chastro VALUES ( '19690217', '19700205', 'ROOSTER');
INSERT INTO chastro VALUES ( '19700206', '19710126', 'DOG');
INSERT INTO chastro VALUES ( '19710127', '19720214', 'PIG');
INSERT INTO chastro VALUES ( '19720215', '19730202', 'RAT');
INSERT INTO chastro VALUES ( '19730203', '19740122', 'OX');
INSERT INTO chastro VALUES ( '19740123', '19750210', 'TIGER');
INSERT INTO chastro VALUES ( '19750211', '19760130', 'RABBIT');
INSERT INTO chastro VALUES ( '19760131', '19770217', 'DRAGON');
INSERT INTO chastro VALUES ( '19770218', '19780206', 'SNAKE');
INSERT INTO chastro VALUES ( '19780207', '19790127', 'HORSE');
INSERT INTO chastro VALUES ( '19790128', '19800115', 'GOAT');
INSERT INTO chastro VALUES ( '19800116', '19810204', 'MONKEY');
INSERT INTO chastro VALUES ( '19810205', '19820124', 'ROOSTER');
INSERT INTO chastro VALUES ( '19820125', '19830212', 'DOG');
INSERT INTO chastro VALUES ( '19830213', '19840201', 'PIG');
INSERT INTO chastro VALUES ( '19840202', '19850219', 'RAT');
INSERT INTO chastro VALUES ( '19850220', '19860208', 'OX');
INSERT INTO chastro VALUES ( '19860209', '19870128', 'TIGER');
INSERT INTO chastro VALUES ( '19870129', '19880216', 'RABBIT');
INSERT INTO chastro VALUES ( '19880217', '19890205', 'DRAGON');
INSERT INTO chastro VALUES ( '19890206', '19900126', 'SNAKE');
INSERT INTO chastro VALUES ( '19900127', '19910214', 'HORSE');
INSERT INTO chastro VALUES ( '19910215', '19920203', 'GOAT');
INSERT INTO chastro VALUES ( '19920204', '19930122', 'MONKEY');
INSERT INTO chastro VALUES ( '19930123', '19940209', 'ROOSTER');
INSERT INTO chastro VALUES ( '19940210', '19950130', 'DOG');
INSERT INTO chastro VALUES ( '19950131', '19960218', 'PIG');
INSERT INTO chastro VALUES ( '19960219', '19970206', 'RAT');
INSERT INTO chastro VALUES ( '19970207', '19980127', 'OX');
INSERT INTO chastro VALUES ( '19980128', '19990215', 'TIGER');
INSERT INTO chastro VALUES ( '19990216', '20000204', 'RABBIT');
INSERT INTO chastro VALUES ( '20000205', '20010123', 'DRAGON');
INSERT INTO chastro VALUES ( '20010124', '20020213', 'SNAKE');
INSERT INTO chastro VALUES ( '20020214', '20030131', 'HORSE');
INSERT INTO chastro VALUES ( '20030201', '20040131', 'GOAT');
# Data for table 'matches'
INSERT INTO matches VALUES ( 'rat', 'rat', 'Two rats make a great pairing. They do not get wrapped up in mundane, everyday issues. Rats together are creative and entertaining lovers. Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'rat', 'ox', 'This is a mating of opposites. The Rat is bright, gregarious, witty and fun, the Ox is shy, serious, and set in their ways. As lovers fireworks can be expected. They will test each other's endurance over and over again. Their overall compatibility rating is 60%. ');
INSERT INTO matches VALUES ( 'rat', 'tiger', 'This may not be the greatest match. Tension will arise from the Rat and the Tiger competing for the limelight. As lovers their need to be at center stage will eventually dramatically diminish their powerful lovemaking. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'rat', 'rabbit', 'While the Rabbit is introverted and sweet and the Rat is extroverted and brazen, these two make for a good mating. This pair makes good friends and lovers. Their overall compatibility rating is 70%. ');
INSERT INTO matches VALUES ( 'rat', 'dragon', 'The Rat and Dragon are a couple made in heaven. As lovers they will be electrifying. Even their arguments will be interesting and free of permanent damage. Their overall compatibility rating is 100%.');
INSERT INTO matches VALUES ( 'rat', 'snake', 'While the Rat and the Snake have many differences to overcome, in the end they do make a good couple. As lovers they will be very dynamic. Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'rat', 'horse', 'The Rat and the Horse may run into problems. While both are very social, witty and energetic, the Rat needs a circle of friends and the Horse needs independence. This difference in needs will create a great deal of tension. They may not be able to maintain a great love life for more than a short while. Their overall compatibility rating is 20%.');
INSERT INTO matches VALUES ( 'rat', 'goat', 'Although mismatched, the Rat and the Goat may develop a solid relationship if they are willing to put in the effort. The center of their life together must be the home. Under the right circumstances these two are capable of creating a great love. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'rat', 'monkey', 'This is a wonderful pairing. Both are very social, witty and thrive on festive activities. As lovers, they will feed on each other's sexual appetite. The fun will never end! Their overall compatibility rating is 100%.');
INSERT INTO matches VALUES ( 'rat', 'rooster', 'While their motives are different, these two can make a great couple once they understand one another. They will make great lovers that compliment each other. Their overall compatibility rating is 60%.');
INSERT INTO matches VALUES ( 'rat', 'dog', 'This is a wonderful pairing. The Rat's need for being with those who are loyal and the Dog's need to be loyal are perfectly matched. These two make fantastic lovers! Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'rat', 'pig', 'The Rat and the Pig make a wonderful pair. As lovers they will be loyal and attentive. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'ox', 'ox', 'Two Oxen make a force to be reckoned with. They are powerful and packed with stamina and never quit. As lovers they may not have the fire other couples have, but they will be very close and the brute strength of their personalities will provide long lasting fireworks. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'ox', 'tiger', 'The Ox and the Tiger's vastly different approaches to life make this a difficult match. Surprisingly, sometimes their very differences can make these couples spectacular lovers. Their overall compatibility rating is 40%. ');
INSERT INTO matches VALUES ( 'ox', 'rabbit', 'The Ox and the Rabbit make an exceptional pair. Both are quiet, very caring and love home life. As lovers their connection may not seem to have the fireworks of others, but it will be deep and powerful. Their overall compatibility rating is 80%. ');
INSERT INTO matches VALUES ( 'ox', 'dragon', 'These two make a great pair as long as they share the same ambitions. As lovers they can be a very satisfying match. Their overall compatibility rating is 70%. ');
INSERT INTO matches VALUES ( 'ox', 'snake', 'These two seekers of quality and meaning make a great pair. All should go well for these two as lovers. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'ox', 'horse', 'While these two seem totally mismatched, there is the potential for a great relationship. As lovers they may help each other blossom in ways that neither could do alone. Their overall compatibility rating is 50%. ');
INSERT INTO matches VALUES ( 'ox', 'goat', 'These are opposite signs of the Chinese Horoscope. To compensate for their opposition they will have to work hard to make a good relationship. As lovers they will have to struggle to create a common ground as well. Their overall compatibility rating is 20%. ');
INSERT INTO matches VALUES ( 'ox', 'monkey', 'The Ox and the Monkey are so different that clashes are inevitable. If they survive the skirmishes they may come to understand each other well enough to make good lovers. Their overall compatibility rating is 40%. ');
INSERT INTO matches VALUES ( 'ox', 'rooster', 'The Ox and the Rooster approach perfection as a pair. As lovers they are sure to blossom and grow. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'ox', 'dog', 'The Ox and the Dog make a very nice pair. Both are honest and can be trusted. As lovers they will provide each other with the stability they need. Their overall compatibility rating is 70%. ');
INSERT INTO matches VALUES ( 'ox', 'pig', 'The Ox and the Pig make a great match as lovers. They will draw the best of each out into the open. Their overall compatibility rating is 70%. ');
INSERT INTO matches VALUES ( 'tiger', 'tiger', 'While naturally drawn to each other, two Tigers will have trouble anytime one of them tries to assert control over the other. As lovers, control issues may diminish their ability to connect. Their overall compatibility rating is 50%. ');
INSERT INTO matches VALUES ( 'tiger', 'rabbit', 'The Rabbit and Tiger may be too different to develop a deep, lasting relationship. The Rabbit may not be able to stand up to the domineering Tiger. While the Tiger would not purposely hurt the Rabbit, as lovers the Rabbit will be constantly worried about the depth of their relationship. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'tiger', 'dragon', 'Because both possess personalities that are difficult to resist, the Tiger and the Dragon cannot help but be drawn to each other initially. However, in time the Dragon's need for control and the Tiger's need for independence will create friction. As lovers they will make a memorable pair if they can overcome their opposing needs. Their overall compatibility rating is 60%.');
INSERT INTO matches VALUES ( 'tiger', 'snake', 'The Tiger and the Snake will have a difficult time finding common ground. Each needs to get his way. As lovers this need will diminish their potency. Their overall compatibility rating is 30%.');
INSERT INTO matches VALUES ( 'tiger', 'horse', 'The optimistic personalities of the Horse and the Tiger make them a good pair. They each need independence and understand that need in the other. As lovers they will flourish. Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'tiger', 'goat', 'The Goat and the Tiger may have trouble forming a rewarding relationship. The Tiger's need for control may threaten the Goat's creative side. The Goat's need for stability may threaten the Tiger's need for independence. As lovers, these conflicts may usurp any chance the couple may have at bliss. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'tiger', 'monkey', 'These two are so different that their chances of creating a solid relationship are slim. As lovers, constant arguing may diminish the potency of their bond. Their overall compatibility rating is 20%.');
INSERT INTO matches VALUES ( 'tiger', 'rooster', 'The Rooster and the Tiger will have to work hard at creating a rewarding relationship. Conflict will arise from the Rooster's need for control and the Tiger's need for independence. Their overall compatibility rating is 40%. ');
INSERT INTO matches VALUES ( 'tiger', 'dog', 'The Tiger and the Dog pairing is usually very strong and rewarding. They share many of the same qualities and their differences compliment one another. As lovers each will give the other the space they need to ensure their bond is mutually fulfilling. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'tiger', 'pig', 'The Pig and the Tiger may make a good pair if each can make allowances for the other's needs. As lovers, the Tiger brings natural magentism to the mix while the Pig brings sensuality. Together thay may be very potent and fulfilling.Their overall compatibility rating is 70%. ');
INSERT INTO matches VALUES ( 'rabbit', 'rabbit', 'Two Rabbits make an ideal pair. Neither will dominate the other while being mutually loving in a way that each instinctively understands. Their overall compatibility rating is 80%. ');
INSERT INTO matches VALUES ( 'rabbit', 'dragon', 'The Dragon and the Rabbit form sound relationships because their differences compliment each other. As lovers, they have the potential to create a very deep, satisfying relationship.Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'rabbit', 'snake', 'While in many ways opposites, the Rabbit and the Snake go well together. As lovers they have the potential to create a deep emotional and sensual bond. Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'rabbit', 'horse', 'The Rabbit and the Horse will have to work at building a fulfilling relationship. The high strung Horse may well run all over the Rabbit. As lovers the Horse will have to foresake some independence to ease the Rabbit's fears. Conversely, the Rabbit will have to understand the Horse is a free spirit by nature. Their overall compatibility rating is 50%.');
INSERT INTO matches VALUES ( 'rabbit', 'goat', 'The Goat and the Rabbit make a pair that is almost certain to succeed! Their soulful temperments are very much alike. As lovers they have the potential to create a deep, emotional bond few are fortunate to ever know. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'rabbit', 'monkey', 'The Monkey and the Rabbit are near opposites to one another, which means a successful relationship between the two will take considerable work. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'rabbit', 'rooster', 'Since the Rabbit and the Rooster are opposites on the Chinese Horoscope, they will have to work very hard to create a fulfilling relationship which can be sustained. As lovers the Rooster's need for control and penchant for nagging may well chase the Rabbit away. Their overall compatibility rating is 20%. ');
INSERT INTO matches VALUES ( 'rabbit', 'dog', 'The Rabbit and the Dog have the potential to create a very strong, lasting bond. They will find each other totally trustworthy and truly appreciate each other's persona. As lovers, they will enjoy a passionate, intensely intimate union. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'rabbit', 'pig', 'The Rabbit and the Pig are capable of a very strong, satisfying union. As lovers the passionate Rabbit and sensual Pig are hard to top. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'dragon', 'dragon', 'Two Dragons together cannot help but form an enduring, deep bond. As lovers, these naturally sexy, charming Dragons will take each other to new heights! Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'dragon', 'snake', 'The luck of the Dragon and the intuition of the Snake make this a good pairing. As lovers, they will be intensely attracted to one another. Physically they have the ability to create a very powerful, satisfying relationship. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'dragon', 'horse', 'The Dragon and the Horse match well both socially and intimately. As lovers they should be great fun and bond deeply. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'dragon', 'goat', 'The Dragon and the Goat may make a great couple. If problems arise it will probably be from the Dragon's desire to protect the independent thinking Goat. As lovers there is the possibilty of a very powerful physical and emotional bond. Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'dragon', 'monkey', 'The Dragon and the Monkey make for an epic match. They are very much alike and their mating assures fun and passion. They will make exciting, fiery lovers. Their overall compatibility rating is 100%.');
INSERT INTO matches VALUES ( 'dragon', 'rooster', 'The fiery and exciting Dragon and the practical and conservative Rooster combine to make a very complimentary and loving relationship. As lovers their strengths combine to form a very happy and stable union. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'dragon', 'dog', 'Being opposites, the Dog and the Dragon will have to strive to understand each other's motivations. As lovers they may develop an intense, physical connection, but extreme differences in other areas will cause much friction. Their overall compatibility rating is 20%.');
INSERT INTO matches VALUES ( 'dragon', 'pig', 'The Dragon and the Pig make wonderful couples. Each is warm-hearted and will provide the other with the tenderness they need. As long as they respect one another's differences they will flourish in a loving relationship. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'snake', 'snake', 'Two Snakes make for a good pairing since they share the same insecurities and know how to ease them. As lovers they should have a very sensual, fulfilling relationship. Their overall compatibility rating is 80%. ');
INSERT INTO matches VALUES ( 'snake', 'horse', 'Because the Horse and the Snake are almost opposites it may be difficult for them to build a lasting relationship. As lovers the initial attraction may be very strong, but may wane rapidly. The free-spirited Horse needs to be on the move while the Snake loves a stable home. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'snake', 'goat', 'While not bursting with energy, the Snake and the Goat may have a solid relationship. As lovers they are capable of having an incredibly sensual, rewarding connection. Their overall compatibility rating is 70%. ');
INSERT INTO matches VALUES ( 'snake', 'monkey', 'The Snake and the Monkey may be too dissimilar to form a rewarding bond. As lovers, while they may have an intense physical bonding, their differences will probably take the edge off of it. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'snake', 'rooster', 'The Snake and the Rooster share so many of the same views it is hard to imagine them not getting along. As lovers they are nearly ideal for each other. Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'snake', 'dog', 'The Snake and the Dog are well matched. They will ease one another's insecurities without either having to surrender much individuality. As lovers they will create a comforting relationship both will find rewarding. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'snake', 'pig', 'Although it seems the Snake and the Pig have enough in common to create a rewarding bond, the fact is they are opposites on the Horoscope and friction will arise from their differences. As lovers they are both very sensual and love the home, but their opposition may spoil any chances of them building a deep, loving relationship. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'horse', 'horse', 'Two Horses should be drawn to each other immediately. Each will sense and admire the free spirit in the other. As lovers, they should have a very strong mating. However the Horse is an unpredictable sort, so the future will always be a bit uncertain. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'horse', 'goat', 'With a few reasonable compromises the Horse and the Goat can create a fun-filled, rewarding relationship. As lovers they are capable of a very strong, sensual relationship, but the Horse is unpredictable, so the final path of this bond can not be known until it is walked. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'horse', 'monkey', 'The Horse and the Monkey may be too alike to create a rewarding bond. As lovers they should create a fun, energetic bond. Their overall compatibility rating is 50%.');
INSERT INTO matches VALUES ( 'horse', 'rooster', 'While the Horse is unpredictable and free-spirited and the Rooster is a perfectionist, these two make a very good pair. As lovers they may suffer from friction caused by the Rooster's pickiness and the Horse's independence. Their overall compatibility rating is 60%.');
INSERT INTO matches VALUES ( 'horse', 'dog', 'The Horse and the Dog are both fun-loving and good-natured and will enjoy a highly compatible relationship. As lovers they will enjoy a very social kind of perpetual dating. Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'horse', 'pig', 'The differences between the Horse, who loves to be in the spotlight, and the quiet, steady Pig can work as long as both work at the relationship. In time the Horse may become bored and lose interest. Their overall compatibility rating is 60%. ');
INSERT INTO matches VALUES ( 'goat', 'goat', 'Two goats can make an amazing, complimentary relationship. With their love of artistic beauty and generous natures they can lift one another to great heights of love. Their sensual and romantic natures will be demonstrated with many gifts of their time and talents. Their overall compatibility rating is 90%. ');
INSERT INTO matches VALUES ( 'goat', 'monkey', 'The fun-loving Monkey may prove to be too much for the sensitive Goat. As lovers, the Monkey's need for a crowd will upset the more introverted Goat and doom any chance of true intimacy. Their overall compatibility rating is 50%.');
INSERT INTO matches VALUES ( 'goat', 'rooster', 'The Goat and the Rooster will probably have an ongoing, subtle battle for dominance. As lovers, the Goat's moodiness and the Rooster's pickiness may diminish the possibility of true intimacy between the two. Their overall compatibility rating is 50%. ');
INSERT INTO matches VALUES ( 'goat', 'dog', 'Generally the Goat and the Dog do not match up well together. Conflicts will arise because the Goat is basically a deep thinking introvert while the Dog is a fun loving extrovert. As lovers they will be too busy fighting over what to do instead of doing to be a solid pair. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'goat', 'pig', 'Because the Goat and the Pig are so similar in so many important ways they make a natural pair. As lovers they cannot miss. The Goat will blossom in the safe haven the Pig creates for them. Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'monkey', 'monkey', 'Two energetic Monkeys together can't help but be fun! As lovers they will have a very strong physical connection. Their overall compatibility rating is 90%.');
INSERT INTO matches VALUES ( 'monkey', 'rooster', 'The Monkey and Rooster are so different they may have difficulty maintaining a relationship of any kind. Both will vie for control. The Rooster will find the Monkey to be an extreme showoff. The Monkey may consider the Rooster a stick in the mud. It is hard to envision this pairing as successful lovers. Their overall compatibility rating is 40%.');
INSERT INTO matches VALUES ( 'monkey', 'dog', 'While there may be some differences, the Monkey and the Dog's energy level and love will make this a natural pairing. As lovers, they have the potential for happiness as long as the Dog feels the Monkey can be trusted. Their overall compatibility rating is 80%.');
INSERT INTO matches VALUES ( 'monkey', 'pig', 'Both the Pig and the Monkey are happy, sensual beings, which makes the potential for happiness together large. As lovers the bedroom will be their playground, but the Pig will have to accept the Monkey needs a social life beyond the home. Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'rooster', 'rooster', 'Two Roosters in the same house sets the stage for great conflict. Each wants to rule and will fight for the right to reign. As lovers too much time may be spent trying to get the upper hand to allow for the development of a healthy relationship. Their overall compatibility rating is 40%. ');
INSERT INTO matches VALUES ( 'rooster', 'dog', 'The Dog and the Rooster find it difficult to develop a rich, lasting relationship. The Rooster's need for control will often come into conflict with the Dog's need for activity and lack of concern for appearances. As lovers their interests are so discordant they will have to work hard to create a fulfilling love life. Their overall compatibility rating is 50%. ');
INSERT INTO matches VALUES ( 'rooster', 'pig', 'The Pig and the Rooster possess differences that do not compliment one another. As lovers, conflict and tension can be expected. Their overall compatibility rating is 50%. ');
INSERT INTO matches VALUES ( 'dog', 'dog', 'While both have high energy levels that guarantee an an active life, their irrational fear that the other is disloyal may spoil their pairing. They have the potential to be fun, caring lovers, but their lack of trust may spoil the fun. Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'dog', 'pig', 'This can be a fantastic match. Both love home and family. As lovers the Pig's sensuality combined with the Dog's love of adventure may provide fireworks. Their overall compatibility rating is 70%.');
INSERT INTO matches VALUES ( 'pig', 'pig', 'This a wonderful, loving match. Pigs united make for great lovers and a warm home life. Their overall compatibility rating is 80%.');
# Data for table 'signs'
INSERT INTO signs VALUES ( 'RAT', 'While in the Western World the Rat is looked upon with disgust and revulsion, he is admired and honored in much of the East for his cleverness and aptitude for acquiring things of value. In China and Japan Rats are signs of good luck and prosperity.<BR>
The Rat is a charming creature capable of captivating almost anyone. Rats are connoisseurs who take pleasure in flaunting their style. They also possess a great sense of humor. Rats can be very protective and generous to those who are loyal to them.<BR>
Rats are also quite self-serving. They have their own goals and ambitions and will not hesitate to advance them. Those outside a Rat's social circle may find them easily riled and verbally abusive. Rats do not often pass up the opportunity to debate.<BR>
Rats are very curious about everything, and are always on the hunt for new information—anything that may be of use to them in the present or future.<BR>
The Rat’s biggest problem is they find it difficult to see beyond themselves. If they can find room for others they will be well on the way to true happiness.<BR> ', 'images/rattag.jpg', 'images/rat.gif', 'Charming, Sociable, Resourceful, Quick-witted, Ambitious, Crafty, Self-serving.', 'Louis Armstrong, Shirley Bassey, Marlon Brando, Doris Day, Clark Gable, Hugh Grant, Charlton Heston, Gene Kelly, Glenda Jackson, Kris Kristofferson, Gary Lineker, Sean Penn, Burt Reynolds, Olivia Newton-John, Tommy Steele, Donna Summer, Andrew Lloyd Webber, Kim Wilde.', 'Financial advisor, Broker, Moneylender, Lawyer, Detective, Antique dealer, Auctioneer, Songwriter, Pathologist.', '1, 4, 5, 10, 11, 14, 41, 45, 51, and 54.', 'Dragon or the Monkey', 'Sagittarius', 'RATS');
INSERT INTO signs VALUES ( 'OX', 'The Chinese Astrological Ox is neither slow witted nor clumsy. These powerful, dependable beings were meant to lead. While their approach to fulfilling a task may be slow and methodical, they are capable of great things and never lose sight of their goals. Their stamina is endless and they are detail conscious. They believe in getting things right the first time.<BR>
To outsiders Oxen may seem to be too serious and unable to “let their hair down.” Being introverts, these are easy assumptions to make about Oxen. Also they are very independent and appear to have no regard for what others think of them. However, hidden behind that distant air shown to the world, is a being that feels pain, loneliness and regret that they do not connect well with others.<BR>
The Oxen’s comforts and delights are derived from friends and family and work well done. As a friend, lover or family member the Ox makes a reliable and protective ally who is always tender and affectionate.<BR>
When away from the family and out in the world the Ox can be stubborn and dogmatic. They are not ones to back down or take much guff from anyone.<BR>
The Ox is a good source of honest advice.<BR>
The Ox needs to try to be less quick to judge others. When they see the value of those who have qualities different than their own they are well on their way to a warmer social life.<BR> ', 'images/oxtag.jpg', 'images/ox.gif', 'Resolute, Strong-willed, Ambitious, Careful, Patient, Stubborn.', 'Warren Beatty, Jon Bon Jovi, Jeff Bridges, Richard Burton, Barbara Cartland, Charlie Chaplin, Bill Cosby, Sammy Davis Jr, Walt Disney, Dustin Hoffman, Anthony Hopkins, Don Johnson, Jane Fonda, Jack Lemmon, Heather Locklear, Eddie Murphy, Jessica Lange, Paul Newman, Jack Nicholson, Robert Redford, Rod Steiger, Peter Sellers, Sissy Spacek, Bruce Springsteen, Meryl Streep, Twiggy.', 'Composer, Landlord, Doctor, Cook or Chef, Farmer, Police officer, Soldier, Teacher, Judge, Banker, Insurance broker, Gardener. ', '1, 3, 5, 12, 15, 33, 35, 51 and 53.', 'Snake or the Rooster.', 'Capricorn', 'OXEN');
INSERT INTO signs VALUES ( 'TIGER', 'Charismatic and self-assured, Tigers were born to lead. This gives them an air of authority most find hard to resist. They are charming and fun, yet never lose sight or stop pursuing their goals or relinquish control. <BR>
The Tigers' courage is without limit and they rarely lose a fight regardless of the arena. The Tiger is the king of seduction. They are dignified and affectionate. The primal nature of their being makes them very attractive to almost all. <BR>
Tigers are moody and can strike at those around them without warning. A Tiger's feelings run deep and are extraordinarily intense. They do not handle stress well and can be overly emotional. An angry Tiger is something to fear.<BR> Tigers are often excessive in their behavior and a little moderation could go a long way in making them happier. When Tigers remain centered and focus their energy on worthy pursuits they will achieve great things.<BR> ', 'images/tigertag.jpg', 'images/tiger.gif', 'Assertive, Adventurous, Independent, Inventive, Generous, Restless and Impulsive.', 'Sir David Attenborough, Tom Berenger, Agatha Christie, Tom Cruise, Leonardo DiCaprio, Emily Dickinson, Isadora Duncan, Roberta Flack, Frederick Forsyth, Jodie Foster, Sir Alec Guiness, Hugh Hefner, William Hurt, Marilyn Monroe, Demi Moore, Beatrix Potter, Diana Rigg, Lionel Ritchie, Kenny Rogers, Dylan Thomas, H.G. Wells, Stevie Wonder, Natalie Wood.', 'Entrepreneur, Military officer, Politician, Musician, Writer, Poet, Designer, Theatre director, Stockbroker, Athlete, Film star, Trade union leader, Company director, Stunt person, Explorer, Teacher.', '4, 5, 7, 9, 13, 34, 44, 45 and 54.', 'Horse or the Dog.', 'Aquarius', 'TIGERS');
INSERT INTO signs VALUES ( 'RABBIT', 'While they may not like it, the Rabbit is a timid, attractive being who is usually non-confrontational. Rabbits are very popular with friends and family. They are inherently compassionate and protective of those they care about. Rabbits idealize their relationships and may give far more of themselves than is healthy. Fortunately the Rabbit surrounds itself with friends and family who will help it regain its balance when thrown off emotionally. <BR>
Rabbits are a bit fragile and need a solid social foundation in order to thrive. Without a strong family and close friends the Rabbit will not stand up well to adversity. Rabbits are so sensitive to their feelings that any emotional upset may make them physically sick. Rabbits can be pessimistic if they feel as though their lives are at a stand-still. By nature they are insecure about their place in the world. Rabbits move through life at their own pace. They are both contemplative and often procrastinators.<BR>
Rabbits love the home life. Within a strong family environment the Rabbit may find the security it needs to blossom and become more self-assertive.<BR> ', 'images/rabbittag.jpg', 'images/rabbit.gif', 'Sociable, Discreet, Refined, Shrewd, Perceptive, Sensitive, Aloof.', 'Harry Belafonte, Ingrid Bergman, Lewis Carroll, John Cleese, Peter Falk, Peter Fonda, James Fox, David Frost, Cary Grant, Oliver Hardy, Bob Hope, Whitney Houston, John Hurt, Michael Keaton, John Keats, Julian Lennon, Arthur Miller, Roger Moore, Tatum O'Neal, George Orwell, Neil Simon, Jane Seymour, Dusty Springfield, Sting, Orson Welles, Norman Wisdom.', 'Antique dealer, Diplomat, Administrator, Interior decorator, Politician, Historian, Art collector, Barrister, Tailor, Receptionist, Chemist, Landlord, Pharmacist, Beautician, Accountant, Librarian.', '1, 3, 5, 9, 15, 19 and 35.', 'Goat or the Pig.', 'Pisces', 'RABBITS');
INSERT INTO signs VALUES ( 'DRAGON', 'The Dragon is the most celebrated sign of the Chinese Zodiac. They are powerful and very lucky, warm-hearted and full of blazing energy. Dragons are intelligent beings born with endless charisma, which ensures they influence the actions of those around them and often makes them the center of attention—a place they enjoy being. Dragons are known for giving good advice. Just as they are lucky with money, so too are they lucky in love.<BR>
Dragons have a talent for managing projects from there inception to there end with great success. Although their egos may be a bit inflated, they do make good leaders. While Dragons may acquire great wealth, it is power they truly want. Dragons are usually gracious winners and, conversely, very poor losers.<BR>
Being a leader is the natural role of the Dragon. Those who learn to be flexible, compassionate and tolerant may become great leaders.<BR>
', 'images/dragontag.jpg', 'images/dragon.gif', 'Active, Determined, Confident, Enterprising, Versatile, Scrupulous and Lucky.', 'Jeffrey Archer, Michael Barrymore, Count Basie, Julie Christie, James Coburn, Bing Crosby, Neil Diamond, Matt Dillon, Placido Domingo, Kirk Douglas, Michael Douglas, Marlene Dietrich, Tom Jones, John Lennon, Nick Nolte, Al Pacino, Elaine Paige, Gregory Peck, Cliff Richard, Martin Sheen, Ringo Starr, Shirley Temple.', 'Managing director, Salesperson, Advertising executive, Barrister, Film producer, Prime minister or President, Photojournalist, Architect, Astronaut, Artist, Film star, War correspondent.', '3, 4, 5, 6, 15, 21, 34, 35, 36 and 45.', 'Monkey or the Rat.', 'Aries', 'DRAGONS');
INSERT INTO signs VALUES ( 'SNAKE', 'The Snake is the master seducer of the Chinese Zodiac. Always well-liked, Snakes are sociable yet introverted as well as intuitive and blessed with a keen aptitude for business. Although Snakes may not consider money that important, their luck and tendency to be a bit tight with their purse strings ensure they will have more money than they need. Snakes are far more mentally active than they are physically. They tend to analyze events before joining in. Overall Snakes have reserved dispositions and probing minds that make intellectual pursuits far more attractive to them than physical activity.<BR>
At their core, Snakes are a little insecure, and can be very jealous and possessive, which can estrange both their friends and family. Despite their imperfections, Snakes can be alluring, munificent and loving. Snakes tend to trust their own intuition over the advice of others. <BR>
While sometimes they are seen as lazy, Snakes will work very hard when the need arises. They are not quitters and expect the same commitment from their partners in any venture.<BR>
Snakes could often be a little less arrogant, and develop a stronger sense of self.<BR>
', 'images/cobratag.jpg', 'images/snake.gif', 'Thoughtful, Wise, Shrewd, Intuitive, Guarded, Independent, Sometimes Lazy.', 'Kim Basinger, Randy Crawford, Bob Dylan, Greta Garbo, Art Garfunkel, Audrey Hepburn, Paul Hogan, Liz Hurley, Carole King, Dean Martin, Robert Mitchum, Mike Oldfield, Ryan O'Neal, Dorothy Parker, Brad Pitt, Brooke Shields, Paul Simon, Dionne Warwick, Oprah Winfrey, Virginia Woolf, Susannah York.', 'Professor, Linguist, Teacher, Psychiatrist, Psychologist, Astrologer, Clairvoyant, Personnel officer, Public relations executive, Interior designer. ', '1, 2, 4, 6, 13, 24, 42 and 46.', 'Rooster or the Ox.', 'Taurus', 'SNAKES');
INSERT INTO signs VALUES ( 'HORSE', 'The free spirited Horse is the Chinese Zodiac’s wanderer. Horses need their independence and freedom. They are packed with energy and constantly moving from one activity to another. Horses are good with money and, of course, have a passion for travel. <BR>
Paradoxically, Horses desire love, which can lead them to feel ensnared. The rawness of their sex appeal is like a magnet and makes it easy for Horses to find love. Horses are skilled at the art of seduction. However, their relationships are unpredictable because their behavior is so erratic and they may flee without notice. Blessed with a keen wit and powerful presence, Horses love to show off to a crowd. Despite the strength of their being, Horses feel inferior to those around them. <BR>
Horses are not a patient lot. They can be quite impulsive and more than a little insensitive to the feelings of others. These self-reliant beings follow their whims through life, which explains why their paths are often littered with unfinished relationships, jobs and ventures. Conversely, Horses motivate others easily and often do reach their goals. <BR> ', 'images/horsetag.jpg', 'images/horse.gif', 'Active, Alert, Outgoing, Adventurous, Eloquent, Free Spirited, Independent, and Quick tempered.', 'Rowan Atkinson, Ingmar Bergman, Sean Connery, Kevin Costner, Cindy Crawford, James Dean, Clint Eastwood, Britt Ekland, Linda Evans, Ella Fitzgerald, Harrison Ford, Bob Geldof, Gene Hackman, Rita Hayworth, Jimi Hendrix, Janet Jackson, Paul McCartney, Barbra Streisand, Raquel Welch, John Travolta, Michael York.', 'Athlete, Technician, Administrator, Chauffer, Inventor, Lorry driver, Sales person, Teacher, Reporter, Painter, Advertising executive, Poet, Hairdresser, Publican, Tour guide.', '1, 3, 4, 8, 13, 14, 41 and 43.', 'Dog or the Tiger.', 'Gemini', 'HORSES');
INSERT INTO signs VALUES ( 'GOAT', 'Goats are dreamers--creative spirits always in need of more time to explore their inner selves. They are most comfortable while being deep within themselves. To be happy, the Goat’s mind must be free to roam where it pleases. Goats are naturally artistic and inventive. They are not pursuers of material wealth and rely on their imaginations to enrich their lives. However, Goats can be very generous to those they love.<BR>
Goats often do not fare well in romantic liaisons. They are very high strung and tend to feel insecure. They are worriers. To quell their uncertainties, Goats need to feel loved and admired at all times. Goats are extremely sensitive and will fret over the most trifling things. Conflict within a relationship will make Goats retreat further into their minds or physically remove themselves from the scene.<BR>
When love is going well for them, Goats can be quite demanding of their partner. The happy Goat does not just take, but loves to give to its lover too.<BR>
Goats who learn to control their worries can be quite happy. Once they know their friends and family will be waiting for them when they return from their inner journeys, Goats can be very happy.<BR> ', 'images/goattag.jpg', 'images/goat.gif', 'Creative, Artistic, Considerate, Generous, Easy Going, Sensitive, A Worrier.', 'Pamela Anderson, Jane Austen, Anne Bancroft, George Burns, Leslie Caron, Catherine Deneuve, Robert De Niro, John Denver, Mel Gibson, George Harrison, Julio Englesias, Buster Keaton, Mick Jagger, Sir Laurence Olivier, Vangelis, John Wayne, Bruce Willis, Debra Winger.', 'Actor, Painter, Musician, Landscape gardener, Television presenter, Dancer, Escort, Investor, Shareholder.', '3, 4, 5, 12, 34, 45 and 54.', 'Pig or the Rabbit.', 'Cancer', 'GOATS');
INSERT INTO signs VALUES ( 'MONKEY', 'The always charming, super-energized Monkey is the partier of the Chinese Zodiac. Monkeys have an insatiable appetite for fun and activity. Having a good time comes very easily for them in any crowd. They are optimistic, witty and blessed with a razor sharp mind. While Monkeys love to be the center of attention, they are good listeners as well. Their bottomless curiosity ensures they will be knowledgeable on a wide variety of topics. Their intelligence allows them to address complex tasks and situations with ease. Monkeys are show-offs who love nothing more than to bedazzle those around them with their antics.<BR>
Most Monkeys do not have a highly developed sense of morality. Indeed, if its fun, they’ll do it. Their primary goal is the pursuit of their own pleasure. Monkeys make pleasurable, exhilarating lovers, but beware of the possibility they will stray. Monkeys will try anything once, and if it is the slightest bit entertaining are sure to try it again.<BR>
The Monkey’s self-serving attitude may be trouble for many other Signs of the Zodiac. They are very hedonistic and lacking in self-control. If they cannot find a party they will start their own.<BR> ', 'images/monkeytag.jpg', 'images/monkey.gif', 'Resourceful, Charming, Persuasive, Amusing, Sociable, Cunning.', 'David Bellamy, Jacqueline Bisset, Victor Borge, Yul Brynner, Johnny Cash, David Copperfield, Joan Crawford, Timothy Dalton, Ian Fleming, Jerry Hall, Tom Hanks, Harry Houdini, Walter Matthau, Peter O'Toole, Anthony Perkins, Debbie Reynolds, Diana Ross, Tom Selleck, Omar Sharif, Martin Shaw, Rod Stewart, Elizabeth Taylor, Kiri Te Kanawa.', 'Counsellor, Therapist, Bus driver, Nurse, Occupational therapist, English teacher, Stockbroker, Town planner, Writer, Journalist. ', '3, 4, 5, 7, 16, 23, 34, 45 and 54.', 'Rat or the Dragon.', 'Leo', 'MONKEYS');
INSERT INTO signs VALUES ( 'ROOSTER', 'The quick thinking, ingenious Roosters are a pragmatic lot who prefer not to take any risks. Roosters are so aware of what’s going on around them that some may believe them to be psychic. It is not easy to sneak anything by a Rooster. These beings are a frank, honest lot who do not pull any punches and admire those who are truthful with them.<BR>
Roosters do not play games and are not likely to create facades to hide behind. They are honest, open and keep their word. Roosters are perfectionists and like to be in control. Their appearance is of great importance to them. Roosters do love to be noticed and love socializing with those who love them.<BR>
Roosters expect and will fight for control of their surroundings and those who fall within its boundaries. They are extremely neat and expect their family members to be the same. By nature, Roosters are conservative, and loyal, trusting and supportive to those who earn it. Those close to the Rooster who do not live up to their standards will find themselves henpecked incessantly.<BR>
Roosters who learn to let others be what they are will have an extremely gratifying life.<BR> ', 'images/roostertag.jpg', 'images/rooster.gif', 'Meticulous, Efficient, Orderly, Conscientious, Intelligent, Honourable, Notoriously Candid.', 'Dirk Bogarde, Barbara Taylor Bradford, Michael Caine, Eric Clapton, Joan Collins, Errol Flynn, Melanie Griffith, Richard Harris, Goldie Hawn, Katherine Hepburn, Diane Keaton, Jayne Mansfield, Steve Martin, James Mason, Somerset Maugham, Bette Midler, Van Morrison, Willie Nelson, Kim Novak, Yoko Ono, Dolly Parton, Michelle Pfeiffer, George Segal, Peter Ustinov.', 'Newsreader, Sales person, Restaurant owner, Hairdresser, Public relations officer, Farmer, Athlete, Teacher, Waiter, Journalist, Travel writer, Dentist, Surgeon, Soldier, Fireman, Security guard, Police officer.', '1, 5, 6, 12, 15, 16, 24 and 51.', 'Ox or the Snake.', 'Virgo', 'ROOSTERS');
INSERT INTO signs VALUES ( 'DOG', 'Dogs are loyal, truthful and live by their own uncompromising code of ethics. While very trustworthy, they do find it difficult to trust others. Dogs are faithful friends and exceptional listeners. They are the caped warriors of the Chinese Zodiac in that they will fight injustice and side with the underdog anytime, anyplace. <BR>
Dogs can be very rigid in their thinking and behavior. They also tend to be moody and need time alone to sulk and revitalize. Dogs are slow to trust, but with time and evidence that someone is trustworthy they will warm up to them. <BR>
Dogs need physical activity to be happy. They will champion any cause they deem worthy. <BR>
In the pursuit of love, Dogs may be their own worst enemy. They can become so anxious from engaging in the mating ritual that they create too much stress in their potential partners for their dance of love to be successful.<BR> ', 'images/dogtag.jpg', 'images/dog.gif', 'Honest, Dependable, Diligent, Perceptive, Selfless, Caring, Moody, Fun-loving, Adventurous.', 'Brigitte Bardot, Candice Bergen, David Bowie, Kate Bush, Naomi Campbell, Cher, Petula Clark, Jamie Lee Curtis, Sally Field, Zsa Zsa Gabor, Ava Gardner, Michael Jackson, Sophie Loren, Shirley MacLaine, Madonna, Liza Minnelli, David Niven, Sydney Pollack, Elvis Presley, Prince, Sade, Claudia Schiffer, Slyvester Stallone, Sharon Stone.', 'Priest, Nun, Trade union leader, Teacher, Charity worker, Nurse, Doctor, Judge, Lawyer, Scientist, Researcher, Social Worker, Lawyer, Community worker.', '1, 4, 5, 9, 10, 14, 19, 28, 30, 41, 45 and 54.', 'Tiger or the Horse.', 'Libra', 'DOGS');
INSERT INTO signs VALUES ( 'PIG', 'The Pigs of the Chinese Zodiac are giving and principled beings without equal. Pigs are very pleasant and have flawless manners and taste. Because they are also perfectionists, they are often wrongly viewed as snobs or as having feelings of superiority. Pigs are sensuous and luxuriant by nature. They love the finer things in life. Pigs care deeply for their friends and family and will go to great extremes to keep them happy and well. Pigs do not see helping others as a duty but as a pleasure.<BR>
Pigs are so giving they are actually sad when they have no one to give to. Their need to be magnanimous makes them an easy mark for those who live by the con. Pigs make great friends and lovers. Truly believing there is a higher good in all of us, the Pig will do almost anything to not see the bad qualities in their friends and family members. However, once a Pig feels they have been wronged, they become a force to be reckoned with. <BR>
Pigs are curious, intelligent beings. Pigs are sometimes wrongly perceived as being lazy. Their love of family and warm hearts make them wonderful mates. <BR> ', 'images/pigtag.jpg', 'images/pig.gif', 'Sincere, Honest, Trusting, Sociable, Hard Working, Stubborn.', 'Bryan Adams, Woody Allen, Julie Andrews, Fred Astaire, Richard Attenborough, Lucille Ball, Humphrey Bogart, James Cagney, Glenn Close, Richard Dreyfuss, Farrah Fawcett, Ernest Hemingway, Barry Gibb, Alfred Hitchcock, Elton John, Kevin Kline, Jerry Lee Lewis, Dudley Moore, Marie Osmond, Michael Parkinson, Lee Remick, Ginger Rogers, Arnold Schwarzenegger, Steven Spielberg, Emma Thompson.', 'Researcher, Scientist, Chemist, Technician, Musician, Restauranteur, Social worker, Fundraiser, Builder, Chef, Delicatessen owner, Personnel manager, Administrative officer, Civil servant.', '1, 3, 4, 5, 8, 16, 18, 34, 41 and 48.', 'Rabbit or the Goat.', 'Scorpio', 'PIGS');
# --------------------------------------------------------