# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Nov 18, 2005 at 07:04 AM
# Server version: 3.23.46
# PHP Version: 4.0.6
# 
# Database : `classroom`
# 

# --------------------------------------------------------

#
# Table structure for table `ad`
#

CREATE TABLE `ad` (
  `site` varchar(50) NOT NULL default '',
  `ad` blob,
  PRIMARY KEY  (`site`)
) TYPE=MyISAM;

#
# Dumping data for table `ad`
#


# --------------------------------------------------------

#
# Table structure for table `admin`
#

CREATE TABLE `admin` (
  `id` varchar(12) NOT NULL default '',
  `site` varchar(50) default NULL,
  `username` varchar(30) default NULL,
  `password` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `admin`
#

INSERT INTO `admin` (`id`, `site`, `username`, `password`) VALUES ('132-ABKSIE4S', 'christiankidz.info', 'admin', 'kidscourseadmin');

# --------------------------------------------------------

#
# Table structure for table `hits`
#

CREATE TABLE `hits` (
  `id` bigint(20) NOT NULL auto_increment,
  `site` varchar(50) default NULL,
  `hitdate` date default NULL,
  `count` bigint(20) default NULL,
  `studentcount` bigint(20) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `hits`
#


# --------------------------------------------------------

#
# Table structure for table `lesson`
#

CREATE TABLE `lesson` (
  `id` int(11) NOT NULL auto_increment,
  `site` varchar(50) default NULL,
  `name` varchar(50) default NULL,
  `questions` tinyint(4) default NULL,
  `illustration` varchar(50) default NULL,
  `puzzle` int(11) default '0',
  `number` tinyint(4) default NULL,
  `percentage` tinyint(4) default NULL,
  `description` text,
  `text` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

#
# Dumping data for table `lesson`
#

INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (1, 'christiankidz.info', 'Noah\'s Ark', 0, 'Noah.png', 2, 1, 0, '', 'Noah was a man of God, and found grace in the eyes of the Lord. In the days of Noah the people of the Earth were very wicked, and that displeased the Lord. The Lord told Noah that he would flood the Earth with water. The Lord commanded Noah to build an ark so that his family could be saved from the flood.  The Lord wanted the animals to be saved from the flood as well, so he commanded Noah to gather two of every kind of animal and bring them onto the ark.  Before the rain started, Noah, his family and the animals entered the safety of the ark. For forty days and forty nights it rained upon the Earth. When the rain stopped the water began to lower Noah sent a dove to see if it could find dry land.  The dove returned with an olive branch, and so Noah knew that the waters had receded from the Earth.  The Lord then left the rainbow as a promise for Noah that he would never flood the Earth again.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (2, 'christiankidz.info', 'Daniel and the lions den', 0, 'Lion-Den.png', 2, 1, 0, '', 'There was king named Darius who commanded the people that they should not pray to God.  Daniel was a righteous man and prayed to God in his home anyway.  When the king found out that Daniel was praying to God he had Daniel put into a den full of hungry lions.  God promised Daniel that the lions would not harm him, and they did not.  Daniel was released from the den unharmed.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (3, 'christiankidz.info', 'Parting of Red Sea', 0, 'Red-Sea.jpg', 2, 1, 0, '', 'When the Pharaoh of Egypt finally let the people of Israel go they left into the desert and camped by the Red Sea.  Pharaoh changed his mind and decided that he did not want to let the people of Israel go.  Pharaoh gathered his army with their chariots to bring them back to Egypt as slaves.  The Lord commanded Moses to raise his staff and part the waters of the Red Sea so that Moses and his people could walk across on dry land and escape from Pharaoh and his army.  Once they had safely reached the other side Pharaoh commanded his army to chase them by crossing the parted sea.  When the Egyptian army was in the middle of the Red Sea, Moses lowered his staff and the water parted settled and drowned the Egyptian army.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (4, 'christiankidz.info', 'David and Goliath', 0, 'David-and-Goliath.png', 2, 1, 0, '', 'There was a war between the Israelites and the Philistines.  The Philistines sent their biggest soldier who taunted the Israelites to come out and fight him, but the Israelites were scared.  David, a brave Israelite, decided to stand up against the giant Goliath.  Goliath laughed at David when he approached because he was just a small boy.  David put a rock in his sling and flung the rock at Goliath and struck him in the head.  Goliath fell to the ground and David walked up to him, took Goliath\'s sword, and cut off his head.  Because of this, the Israelites gained courage and were able to stand up against the Philistines.  God helped David to kill the giant Goliath.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (5, 'christiankidz.info', 'New star', 0, 'New-Star-in-Sky.jpg', 2, 1, 0, '', 'Because they were righteous, God told wise men that the baby Jesus would be born. God gave them a sign of when the baby would be born, which was a new star in the sky.  They followed God\'s instructions and came to King Herod and asked Herod where the baby Jesus was. Herod did not know so the wise men followed the new star until they found the baby Jesus.  The wise men brought gifts of gold, frankincense and myrrh for the baby Jesus.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (6, 'christiankidz.info', 'Creation', 0, 'Creation.jpg', 2, 1, 0, '', 'In the beginning God created the heaven and the earth.  God created night and day and created the sun and the moon.  God created the oceans and divided land from the waters so we could have land to live on.  God created all kinds of plants including grass, trees, herbs and fruit.  God created the fish in the sea and the birds in the air and then all manner of things that walk upon the earth.  Then God created the first man in his own image and his name was Adam and the first woman and her name was Eve.  God commanded Adam and Eve to not eat the fruit from the tree of the knowledge of good and evil.  The serpent, which is the devil, tempted to Eve to eat the fruit that God had commanded her not to.  Eve ate the fruit and then gave some to Adam to eat, and Adam ate the fruit as well.  Because of this they had to leave the garden of Eden and work for their food for the rest of their lives.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (7, 'christiankidz.info', 'Tower of Babel', 0, 'Tower-of-babel.jpg', 2, 1, 0, '', 'Today people speak many different languages, but long ago everyone spoke only one language.  The people thought that they could build a tower to reach heaven.  Because of this, the Lord caused that they should speak different languages so that they would not be able to talk to each other, and they were scattered so that they lived in different parts of the land instead of in one city.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (8, 'christiankidz.info', 'Moses and the Ten Commandments', 0, 'Tablets-Moses.jpg', 2, 1, 0, '', 'Moses goes into the mountains to pray to the Lord and he sees the angel of the Lord in the form of a burning bush.  The Lord tells Moses to go to Pharaoh and command him to let the people of Israel go free.  When Moses tells Pharaoh God\'s commandment, Pharaoh refuses to let the people of Israel go.  Moses promises Pharaoh that plagues will be visited upon Egypt unless he lets the people of Israel go.  Egypt was plagued with frogs, lice, flies and burning hail.  The Lord also turned the river to blood and killed the firstborn sons of the Egyptians, including Pharaoh\'s own son.  Finally Pharaoh agreed to let the people go.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (9, 'christiankidz.info', 'Teachings of Jesus', 0, 'Jesus-Sermon.jpg', 2, 1, 0, '', 'Jesus taught us to be kind to one another.  He taught that if somebody needs food, then we should give them food.  Jesus taught that if somebody has no clothes and we have extra, then we should clothe them.  Jesus taught that if somebody smites us, then we should turn the other cheek.  Jesus taught us that we should love our enemies.  Jesus taught that we should pray for those that treat us badly. Jesus taught that if somebody asks you to lend something to them, then you should.');
INSERT INTO `lesson` (`id`, `site`, `name`, `questions`, `illustration`, `puzzle`, `number`, `percentage`, `description`, `text`) VALUES (10, 'christiankidz.info', 'Manger Scene', 0, 'Manger-Scene.png', 3, 1, 0, '', 'God promised that his son would be born on the earth.  Mary, the mother of Jesus, and Joseph went to Bethlehem to pay their taxes.  When the got there they could not find a room to stay in for the night.  They finally stayed in a stable, a place where animals are kept.  Jesus was born in a manger and was wrapped in swaddling clothes.');

# --------------------------------------------------------

#
# Table structure for table `lesson_question`
#

CREATE TABLE `lesson_question` (
  `id` int(11) NOT NULL auto_increment,
  `lessonid` int(11) default NULL,
  `question` text,
  `answer` int(11) default NULL,
  `number` tinyint(4) default '0',
  `illustration` varchar(50) default NULL,
  `difficulty` varchar(15) default NULL,
  `text` text,
  PRIMARY KEY  (`id`),
  KEY `lessonid` (`lessonid`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

#
# Dumping data for table `lesson_question`
#

INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (1, 1, 'What did Noah build?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (2, 1, 'How many of each kind of animal did Noah gather?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (3, 1, 'Why did God flood the Earth?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (4, 1, 'How long did it rain in the flood?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (5, 1, 'What bird returned with an olive branch?', 0, 5, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (6, 1, 'What was the token of God\'s promise to man?', 0, 6, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (7, 2, 'What type of animal was in the den?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (8, 2, 'Who had Daniel put into the den?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (9, 2, 'Why was Daniel put into the den?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (10, 2, 'Why didn\'t the lions harm Daniel?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (11, 3, 'Who led the people of Israel out of Egypt?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (12, 3, 'Where did the people camp after leaving Egypt?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (13, 3, 'Who commanded the Egyptian army to go after the people of Israel?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (14, 3, 'How did Moses get his people to safety?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (15, 3, 'What happened when the Egyptian army tried to cross the Red Sea?', 0, 5, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (16, 4, 'Who were the Israelites fighting?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (17, 4, 'Why was Goliath special?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (18, 4, 'Why did Goliath laugh at David?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (19, 4, 'What weapon did David carry?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (20, 4, 'How did God help David defeat Goliath?', 0, 5, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (21, 5, 'What was the sign of the birth of Jesus?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (22, 5, 'What did the wise men bring for Jesus?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (23, 5, 'Who did God tell about the birth of Jesus?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (24, 5, 'Why did God tell the wise men how to find the baby Jesus?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (25, 6, 'Who created the earth?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (26, 6, 'What did God create to give us daylight?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (27, 6, 'In whose image was man created?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (28, 6, 'What was the name of the first woman?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (29, 6, 'What happened after they ate the fruit?', 0, 5, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (30, 7, 'How many languages were spoken in the beginning of the world?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (31, 7, 'What did the people try to build?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (32, 7, 'What were the people trying to reach with the tower?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (33, 7, 'What did the Lord do to the language of the people?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (34, 8, 'What did Moses see when he talked with the Lord?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (35, 8, 'What did the Lord command Moses to do?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (36, 8, 'What did the Lord do when Pharaoh refused to free the people?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (37, 8, 'What did the Lord change the water into?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (38, 8, 'Whose death convinced Pharaoh to let the people go?', 0, 5, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (39, 9, 'What did Jesus teach us to do when somebody is hungry?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (40, 9, 'What did Jesus say you should do if someone smites you?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (41, 9, 'Jesus said that when someone compels you to walk a mile with them you should do what?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (42, 9, 'Jesus said that when someone wants to borrow from you, you should:', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (43, 9, 'Jesus said that you should:', 0, 5, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (44, 10, 'Who was Jesus\' step father?', 0, 1, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (45, 10, 'Where was Jesus born?', 0, 2, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (46, 10, 'Why did Mary and Joseph go to Bethlehem?', 0, 3, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (47, 10, 'Why did they stay in a stable?', 0, 4, '', 'Easy', '');
INSERT INTO `lesson_question` (`id`, `lessonid`, `question`, `answer`, `number`, `illustration`, `difficulty`, `text`) VALUES (48, 10, 'What was Jesus wrapped in when he was born?', 0, 5, '', 'Easy', '');

# --------------------------------------------------------

#
# Table structure for table `lesson_question_answer`
#

CREATE TABLE `lesson_question_answer` (
  `id` int(11) NOT NULL auto_increment,
  `lessonid` int(11) default NULL,
  `questionid` int(11) default NULL,
  `answer` text,
  `isanswer` tinyint(4) default NULL,
  `number` tinyint(4) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=156 ;

#
# Dumping data for table `lesson_question_answer`
#

INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (1, 1, 1, 'Ark', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (2, 1, 1, 'House', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (3, 1, 1, 'Tower', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (4, 1, 1, 'Chair', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (5, 1, 2, 'One', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (6, 1, 2, 'Two', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (7, 1, 2, 'Three', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (8, 1, 2, 'Four', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (9, 1, 3, 'To soak the desert', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (10, 1, 3, 'The people were wicked', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (11, 1, 3, 'To water the trees', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (12, 1, 4, '40 days', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (13, 1, 4, '2 days', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (14, 1, 4, '100 days', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (15, 1, 5, 'Raven', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (16, 1, 5, 'Dove', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (17, 1, 5, 'Blue jay', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (18, 1, 5, 'Eagle', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (19, 1, 6, 'The Rainbow', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (20, 1, 6, 'The ocean', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (21, 1, 6, 'The mountains of Ararat', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (22, 2, 7, 'Elephant', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (23, 2, 7, 'Tiger', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (24, 2, 7, 'Lion', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (25, 2, 7, 'Bear', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (26, 2, 8, 'God', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (27, 2, 8, 'General', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (28, 2, 8, 'The King', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (29, 2, 9, 'He refused to pray to God', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (30, 2, 9, 'He prayed to God', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (31, 2, 9, 'He didn\'t pay his taxes', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (32, 2, 10, 'He smelled bad', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (33, 2, 10, 'It wasn\'t dinner time', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (34, 2, 10, 'God protected him', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (35, 3, 11, 'Pharaoh', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (36, 3, 11, 'John', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (37, 3, 11, 'Moses', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (38, 3, 11, 'Noah', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (39, 3, 12, 'Babylon', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (40, 3, 12, 'Nile River', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (41, 3, 12, 'Edge of the Red Sea', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (42, 3, 12, 'In the mountains', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (43, 3, 13, 'Pharaoh', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (44, 3, 13, 'Moses', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (45, 3, 13, 'Joseph', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (46, 3, 14, 'Built boats for them', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (47, 3, 14, 'Taught them how to swim', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (48, 3, 14, 'Parted the Red Sea', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (49, 3, 15, 'They got across safely', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (50, 3, 15, 'They drowned', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (51, 3, 15, 'They took a wrong turn', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (52, 4, 16, 'Egyptians', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (53, 4, 16, 'Philistines', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (54, 4, 16, 'Babylonians', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (55, 4, 17, 'He was a midget', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (56, 4, 17, 'He had better weapons', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (57, 4, 17, 'He was a giant', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (58, 4, 18, 'David was a just small boy', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (59, 4, 18, 'David wore funny shoes', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (60, 4, 18, 'David told him jokes', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (61, 4, 19, 'Sling and stone', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (62, 4, 19, 'Bow and arrow', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (63, 4, 19, 'Spear', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (64, 4, 20, 'God told David to run away', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (65, 4, 20, 'God knocked Goliath down', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (66, 4, 20, 'God gave David courage', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (67, 5, 21, 'Big building', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (68, 5, 21, 'Thunder and lightning', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (69, 5, 21, 'New star in sky', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (70, 5, 22, 'Gold, frankincense and myrrh', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (71, 5, 22, 'Party hats', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (72, 5, 22, 'Bells and whistles', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (73, 5, 23, 'King Herod', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (74, 5, 23, 'Scribes', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (75, 5, 23, 'Wise men', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (76, 5, 24, 'Because they were wicked', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (77, 5, 24, 'Because they were righteous', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (78, 5, 24, 'Because they had blue hair', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (79, 6, 25, 'Adam', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (80, 6, 25, 'Eve', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (81, 6, 25, 'God', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (82, 6, 26, 'Sun', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (83, 6, 26, 'Ocean', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (84, 6, 26, 'Moon', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (85, 6, 26, 'Grass', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (86, 6, 27, 'Animals', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (87, 6, 27, 'God', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (88, 6, 27, 'Eve', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (89, 6, 28, 'Adam', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (90, 6, 28, 'Eve', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (91, 6, 28, 'Lucifer', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (92, 6, 29, 'Nothing', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (93, 6, 29, 'They had to leave the Garden of Eden', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (94, 6, 29, 'God said it was okay', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (95, 7, 30, 'One', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (96, 7, 30, 'Ten', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (97, 7, 30, 'Thirty', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (98, 7, 30, 'One hundred', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (99, 7, 31, 'Pyramid', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (100, 7, 31, 'Bridge', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (101, 7, 31, 'Tower', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (102, 7, 31, 'Table', 0, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (103, 7, 32, 'The ocean', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (104, 7, 32, 'Mountain top', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (105, 7, 32, 'Desert', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (106, 7, 32, 'Heaven', 1, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (107, 7, 33, 'Made them talk faster', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (108, 7, 33, 'Made them unable to speak', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (109, 7, 33, 'Made them speak different languages', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (110, 8, 34, 'A burning bush', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (111, 8, 34, 'Bright light', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (112, 8, 34, 'Smoke', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (113, 8, 35, 'Stay on the mountain', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (114, 8, 35, 'Tell Pharaoh to free the people of Israel', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (115, 8, 35, 'Cook a feast', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (116, 8, 36, 'Gave up', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (117, 8, 36, 'Told Moses to go back to the mountain', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (118, 8, 36, 'Sent plagues upon Egypt', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (119, 8, 37, 'Sand', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (120, 8, 37, 'Grape juice', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (121, 8, 37, 'Milk', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (122, 8, 37, 'Blood', 1, 4);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (123, 8, 38, 'Moses', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (124, 8, 38, 'Pharaoh', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (125, 8, 38, 'Pharaoh\'s son', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (126, 9, 39, 'Ask them for money', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (127, 9, 39, 'Tell them to get a job', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (128, 9, 39, 'Feed them', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (129, 9, 40, 'Turn the other cheek', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (130, 9, 40, 'Hit them back', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (131, 9, 40, 'Yell really loud', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (132, 9, 41, 'Go, but mumble and be miserable the whole time', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (133, 9, 41, 'Go two miles with them', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (134, 9, 41, 'Refuse to go', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (135, 9, 42, 'Take something from them', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (136, 9, 42, 'Refuse to share', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (137, 9, 42, 'Lend to them', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (138, 9, 43, 'Hate your friends and enemies', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (139, 9, 43, 'Love your friends but hate your enemies', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (140, 9, 43, 'Love both your friends and your enemies', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (141, 10, 44, 'Peter', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (142, 10, 44, 'Joseph', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (143, 10, 44, 'James', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (144, 10, 45, 'Bethlehem', 1, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (145, 10, 45, 'Judea', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (146, 10, 45, 'Jerusalem', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (147, 10, 46, 'To sit on a jury', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (148, 10, 46, 'To pay taxes', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (149, 10, 46, 'To meet their friends', 0, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (150, 10, 47, 'Because it was more comfortable', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (151, 10, 47, 'Because they could not afford a room in the inn', 0, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (152, 10, 47, 'Because there was no room at the inn', 1, 3);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (153, 10, 48, 'Hospital gown', 0, 1);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (154, 10, 48, 'Swaddling clothes', 1, 2);
INSERT INTO `lesson_question_answer` (`id`, `lessonid`, `questionid`, `answer`, `isanswer`, `number`) VALUES (155, 10, 48, 'Scarf', 0, 3);

# --------------------------------------------------------

#
# Table structure for table `payment`
#

CREATE TABLE `payment` (
  `id` int(11) NOT NULL auto_increment,
  `orderid` varchar(12) default NULL,
  `site` varchar(50) default NULL,
  `students` int(11) default NULL,
  `active` tinyint(4) default NULL,
  `price` decimal(5,2) default NULL,
  `firstname` varchar(30) default NULL,
  `lastname` varchar(30) default NULL,
  `address` varchar(100) default NULL,
  `city` varchar(50) default NULL,
  `state` char(2) default NULL,
  `zip` varchar(15) default NULL,
  `email` varchar(100) default NULL,
  `phone` varchar(30) default NULL,
  `createdate` datetime default NULL,
  `bookquantity` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `payment`
#


# --------------------------------------------------------

#
# Table structure for table `product`
#

CREATE TABLE `product` (
  `id` bigint(20) NOT NULL auto_increment,
  `site` varchar(50) default NULL,
  `name` varchar(100) default NULL,
  `description` blob,
  `price` decimal(5,2) default NULL,
  `shipping` decimal(5,2) default NULL,
  `category` varchar(50) default NULL,
  `number` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `product`
#


# --------------------------------------------------------

#
# Table structure for table `puzzles`
#

CREATE TABLE `puzzles` (
  `id` varchar(12) NOT NULL default '',
  `site` varchar(50) default NULL,
  `name` varchar(50) default NULL,
  `difficulty` varchar(50) default NULL,
  `puzzletype` varchar(30) default NULL,
  `filetype` varchar(30) default NULL,
  `number` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `puzzles`
#

INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('13C-1292B041', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 4);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('6C8-2FB4C0FB', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 3);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('4AD-5CF9CBB7', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 2);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('2DA-20A147B5', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 1);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('21C-310ACBE3', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 5);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('45C-6304E8FC', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 6);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('89C-1636C1AC', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 7);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('101-41C638DF', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 8);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('513-34AB4FBA', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 9);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('583-2CCB3C4F', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 10);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('675-78DF14C1', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 11);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('712-70E1E7A2', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 12);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('745-4EE22764', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 13);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('797-79C02836', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 14);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('945-34A1A2E5', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 15);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('984-7EB86D56', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 16);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('B80-5655F1F5', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 17);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('D7A-54BD99B6', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 18);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('DC1-582FF5C2', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 19);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('DD5-3AC4A168', 'christiankidz.info', NULL, NULL, 'Maze', 'PDF', 20);
INSERT INTO `puzzles` (`id`, `site`, `name`, `difficulty`, `puzzletype`, `filetype`, `number`) VALUES ('F21-0F281745', 'christiankidz.info', NULL, NULL, 'Wordsearch', 'PDF', 21);

# --------------------------------------------------------

#
# Table structure for table `scheme`
#

CREATE TABLE `scheme` (
  `name` varchar(30) NOT NULL default '',
  `site` varchar(50) default NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`name`)
) TYPE=MyISAM;

#
# Dumping data for table `scheme`
#

INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorBackground', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorBackdrop', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorBackdropBorder', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorText', 'christiankidz.info', '#1635BD');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorFormboxHeaderBackground', 'christiankidz.info', '#108218');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorFormboxHeaderText', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorFormboxBodyBackground', 'christiankidz.info', '#E5F0FB');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorFormboxBodyText', 'christiankidz.info', '#000000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorFormboxBorder', 'christiankidz.info', '#000000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorCopyright', 'christiankidz.info', '#1635BD');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorMenuBackground', 'christiankidz.info', '#FFFFC0');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorMenuBorder', 'christiankidz.info', '#000000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorMenuLinks', 'christiankidz.info', '#FF9000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorMenuText', 'christiankidz.info', '#000080');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorLink', 'christiankidz.info', '#1635BD');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorErrorText', 'christiankidz.info', '#FF0000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorTipBoxBackground', 'christiankidz.info', '#FFFFC0');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('TextCopyright', 'christiankidz.info', 'Copyright &copy; 2005 christiankidz.info.');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorLinkHover', 'christiankidz.info', '#A01818');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorDivider', 'christiankidz.info', 'Green');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorSignUpText', 'christiankidz.info', '#008000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAdminLink', 'christiankidz.info', '#000000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('SizeAdminLink', 'christiankidz.info', '14px');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAdminOddRowBackground', 'christiankidz.info', '#CFE4F7');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAdminTableHeaderBackgroun', 'christiankidz.info', '#144578');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAdminTableHeaderText', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('AdminSiteHitBorderColor', 'christiankidz.info', '#000000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAdminTableHeaderLink', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorQuestionText', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorQuestionBackground', 'christiankidz.info', '#050B5F');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAnswerBackground', 'christiankidz.info', '#FFFFFF');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAnswerText', 'christiankidz.info', '#000000');
INSERT INTO `scheme` (`name`, `site`, `value`) VALUES ('ColorAnswerBackgroundOver', 'christiankidz.info', '#AAADCE');

# --------------------------------------------------------

#
# Table structure for table `student`
#

CREATE TABLE `student` (
  `id` varchar(12) NOT NULL default '',
  `active` tinyint(4) default NULL,
  `site` varchar(50) default NULL,
  `paymentid` int(11) default NULL,
  `name` varchar(50) default NULL,
  `username` varchar(30) default NULL,
  `password` varchar(30) default NULL,
  `age` tinyint(4) default NULL,
  `difficulty` varchar(15) default NULL,
  `complete` tinyint(4) default '0',
  `puzzlesactive` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `student`
#

INSERT INTO `student` (`id`, `active`, `site`, `paymentid`, `name`, `username`, `password`, `age`, `difficulty`, `complete`, `puzzlesactive`) VALUES ('985-3DFB1673', 1, 'christiankidz.info', 5, 'Student Name', 'username', 'password', 3, 'Hard', 0, 0);

# --------------------------------------------------------

#
# Table structure for table `student_lesson`
#

CREATE TABLE `student_lesson` (
  `studentid` varchar(12) NOT NULL default '',
  `lessonid` int(11) NOT NULL default '0',
  `correct` tinyint(4) default '0',
  `complete` tinyint(4) default '0',
  KEY `studentid` (`studentid`)
) TYPE=MyISAM;

#
# Dumping data for table `student_lesson`
#