#for html update
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {       \n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <p>boomtag{prize}</p>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                               <!--  <h1><sup>$</sup>1</h1> -->\n                            </div>\n                        </div>\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2>\n                                <h3>offer here</h3> -->\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}  \n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='5';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='43';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='45';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  </style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!--h2>free</h2-->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='47';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='49';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='51';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='53';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='55';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n    	boomtag{main_css}\n  	</style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='57';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n      boomtag{main_css}\n    </style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='35';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n      boomtag{main_css}\n    </style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							   		Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section} \n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='36';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n      boomtag{main_css}\n    </style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='37';
UPDATE `sevence`.`gift_screen` SET `html`='<!DOCTYPE HTML>\n<html lang=\"en-US\">\n<head>\n	<meta charset=\"UTF-8\">\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n	<title>boomtag{title}</title>\n    <style type=\"text/css\">\n      boomtag{main_css}\n    </style>\n    <link type=\"text/css\" rel=\"stylesheet\" href=\"http://fonts.googleapis.com/css?family=Montserrat:400,700\">\n    <script src=\"https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\n    <script>\n        if(!(/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent))) {\n             $(document).ready(function() {\n                var maxHeight = -1;\n\n                $(\'.ob-child\').each(function() {\n                maxHeight = maxHeight > $(this).height() ? maxHeight : $(this).height();\n                });\n\n                $(\'.ob-child\').each(function() {\n                $(this).height(maxHeight);\n                });\n            });\n        }\n        $(document).ready(function() {\n	      $(\'#openbox-main\').fadeTo(\'slow\', 1, function() {\n	        console.log(\'test\');\n	        $(\'.partner_section\').fadeTo(\'slow\', 1, function() {\n	          setTimeout(function() {\n	            $(\'.partners\').fadeTo(\'slow\', 1);\n	          }, 500);\n	        } );\n	      });\n	    });\n	    $(document).ready(function() {\n            $(\'.business_partner_link\').click(function(e) {\n                e.preventDefault();\n                location.href = $(this).attr(\'href\') + \"?1=boomtag{client_id}&main_org=boomtag{main_org}\";\n            })\n        });\n    </script>\n</head>\n<body>\n    <div class=\"container\">\n        <div id=\"openbox-main\">\n            <div id=\"openbox-inner\">\n                <div class=\"clearfix\">\n                    <div class=\"col-md-4 ob-greetings ob-child\">\n                        <h2>Congratulations <strong>You Won!</strong></h2>\n                    </div>\n                    <div class=\"col-md-4 main-content ob-child\">\n                        <!-- <div class=\"row upper-c\">\n                            <div class=\"col-sm-12\">\n                                <h1><sup>$</sup>1</h1>\n                            </div>\n                        </div> -->\n                        <div class=\"row lower-c\">\n                            <div class=\"col-sm-12\">\n                                <!-- <h2>free</h2> -->\n                                <h3>boomtag{prize}</h3>\n                                <p style=\"font-style:italic;font-size: 14px;margin-top: 6px;margin-left: 10px;\">\n							    	Prize Info: Your prize will be emailed to you\n							  	</p>\n                            </div>\n                        </div>\n                    </div>\n                    <div class=\"col-md-4 ob-org-name ob-child\">\n                        <h2>boomtag{org_name}</h2>\n                    </div>\n                </div>\n            </div>\n            boomtag{org_links_section}\n        </div>\n    </div>\n</body>\n</html>' WHERE `gift_screen`='38';
#for css update
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");   @media(max-width:767px){      body{         background:url(\"boomtag{boomtime_path}/img/gift_foryou/v1/professional-ob-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;     }      #openbox-main{         /* background: red !important; */         margin-top: 20px !important;         margin-bottom:40px !important;     }      .main-content{         border-top: 3px solid #007ca7;         border-bottom: 3px solid #007ca7;     }          .ob-greetings h2{         position: static;         top: unset;         -webkit-transform: none;         -ms-transform:  none;         transform:  none;     }     .ob-greetings h2 strong{         font-size:22px !important;      }      .ob-org-name h2{         position: static;         top: unset;         -webkit-transform:  none;         -ms-transform:  none;         transform:  none;     }            }  @media(max-width:767px) and (orientation:portrait){      .ob-greetings h2{         font-size:20px !important;     }     body{         background:url(\"boomtag{boomtime_path}/img/gift_foryou/v1/professional-ob-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;     }      }    @media(max-width:767px) and (orientation:landscape){      .main-content .lower-c h2{         font-size:24px !important;     }      .main-content .lower-c h3{         font-size:20px !important;     }      .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{         float:left !important;     }      .col-md-3 {         width: 25% !important;     }     .col-md-6 {         width: 50% !important;     }          .col-md-4 {         width: 33.3333% !important;     }          #openbox-main{         padding:8px !important;     }      .main-content{         border-left: 3px solid #007ca7;         border-right: 3px solid #007ca7;         border-top: none;         border-bottom: none;     }      .ob-greetings h2{         font-size:13px !important;         -ms-word-break: break-all;          word-break: break-all;          word-break: break-word; /* old webkit */      }          .main-content{         padding:15px 15px !important;     }      .ob-greetings h2 strong{         font-size:22px !important;     }  	.partner_section h2 { 		font-size:20px!important; 	}      .ob-org-name h2{         font-size:16px !important;     }      .main-content .upper-c h1{         font-size:60px !important;     }      body{         background: url(\"boomtag{boomtime_path}/img/gift_foryou/v1/professional-ob-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;     }  }    @media(min-width:768px){       #openbox-main{         /* background: blue !important; */     }          .main-content{         border-top: 3px solid #007ca7;         border-bottom: 3px solid #007ca7;     }          #openbox-main{         margin-top: 250px !important;     }        }  @media(min-width:992px){      #openbox-main{         margin-top: 220px !important;     /*    background: pink !important;      */     }          .ob-greetings h2{         font-size:18px !important;     }          .main-content{         border-top: none;         border-bottom: none;         border-left: 3px solid #007ca7;         border-right: 3px solid #007ca7;     }                }  @media(min-width:1200px){      #openbox-main{       /*  background: green !important;   */     }          .ob-greetings h2{         position: relative;         top: 50%;         margin-top:0;         -webkit-transform: translateY(-50%);         -ms-transform: translateY(-50%);         transform: translateY(-50%);     }      .ob-org-name h2{         position: relative;         top: 50%;         margin-top:0;         -webkit-transform: translateY(-50%);         -ms-transform: translateY(-50%);         transform: translateY(-50%);     }     #openbox-main {         margin-top: 370px !important;     }  }  body, html{     height:100%; }  body{     background: url(\"boomtag{boomtime_path}/img/gift_foryou/v1/professional-ob-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0); }  #openbox-main{     background: url(\"boomtag{boomtime_path}/img/gift_foryou/v1/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);     box-shadow: 2px 3px 3px #181818;     margin-top: 320px;     padding: 15px; }  #openbox-inner{     border: 3px solid #2c92b6; }  .ob-greetings{     font-family:\'Montserrat\',sans-serif; }  .ob-greetings h2{     color: #007ca7;     font-size: 24px;     text-align: center;     text-transform: uppercase; } .ob-greetings h2 strong{     color: #363636;     font-size: 42px;     font-weight: bold;     display:block; }  .main-content{     font-family: \'Montserrat\',sans-serif;     text-align: center;     text-transform: uppercase; }  .ob-org-name{     font-family: \'Montserrat\',sans-serif;     text-align: center;     text-transform: uppercase; }  .main-content .upper-c h1{     color: #007ca7;     font-size:120px;     margin-bottom:0;     margin-top:0; } .main-content .upper-c h1 sup{     font-size: 35%; }  .main-content .lower-c h2{     font-size: 40px;     margin: 0; }  .main-content .lower-c h3{     font-size: 32px;     margin: 0; }  .partner_section h2 { font-size:25px; }  a { font-size:18px; font-family:Montserrat,sans-serif; color:#007ca7; }  a:hover { color:#333; }  .main-content,.ob-org-name { font-family:Montserrat,sans-serif; text-align:center; text-transform:uppercase; }  .partner_section,.partners { opacity:0; }' WHERE `gift_screen`='5';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v2/v2-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #f2e1bb;\n        border-bottom: 3px solid #f2e1bb;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:20px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v2/v2-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #f2e1bb;\n        border-right: 3px solid #f2e1bb;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v2/v2-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n   \n    .main-content{\n        border-top: 3px solid #f2e1bb;\n        border-bottom: 3px solid #f2e1bb;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #f2e1bb;\n        border-right: 3px solid #f2e1bb;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n  \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v2/v2-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v2/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #f2e1bb;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #947936;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #947936;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='43';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #7a7750;\n        border-bottom: 3px solid #7a7750;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #7a7750;\n        border-right: 3px solid #7a7750;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n}\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #7a7750;\n        border-bottom: 3px solid #7a7750;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #7a7750;\n        border-right: 3px solid #7a7750;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v3/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #7a7750;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #7a7750;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #7a7750;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #f2e1bb;\n        border-bottom: 3px solid #f2e1bb;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:20px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #f2e1bb;\n        border-right: 3px solid #f2e1bb;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n   \n    .main-content{\n        border-top: 3px solid #f2e1bb;\n        border-bottom: 3px solid #f2e1bb;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #f2e1bb;\n        border-right: 3px solid #f2e1bb;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n  \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v3/v3-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v3/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #f2e1bb;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #947936;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #947936;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='45';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v4/v4-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 4px double #ac9859;\n        border-bottom: 4px double #ac9859;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v4/v4-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 4px double #ac9859;\n        border-right: 4px double #ac9859;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v4/v4-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 4px double #ac9859;\n        border-bottom: 4px double #ac9859;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 4px double #ac9859;\n        border-right: 4px double #ac9859;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v4/v4-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v4/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 4px double #ac9859;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #b1463b;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #b1463b;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='47';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v5/v5-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 2px dotted #5b5e60;\n        border-bottom: 2px dotted #5b5e60;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v5/v5-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 2px dotted #5b5e60;\n        border-right: 2px dotted #5b5e60;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n    \n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v5/v5-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 2px dotted #5b5e60;\n        border-bottom: 2px dotted #5b5e60;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 2px dotted #5b5e60;\n        border-right: 2px dotted #5b5e60;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v5/v5-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: #dcdfdc;\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 2px dotted #5b5e60;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #cd962b;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #cd962b;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='49';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v6/v6-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #df6957;\n        border-bottom: 3px solid #df6957;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v6/v6-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #df6957;\n        border-right: 3px solid #df6957;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n    \n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v6/v6-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #df6957;\n        border-bottom: 3px solid #df6957;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #df6957;\n        border-right: 3px solid #df6957;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v6/v6-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v6/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #df6957;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #9a8379;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #9a8379;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='51';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v7/v7-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #616262;\n        border-bottom: 3px solid #616262;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v7/v7-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #616262;\n        border-right: 3px solid #616262;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n    \n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n    \n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v7/v7-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #616262;\n        border-bottom: 3px solid #616262;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #616262;\n        border-right: 3px solid #616262;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v7/v7-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v7/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #616262;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #1777ad;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #1777ad;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='53';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\".boomtag{boomtime_path}/img/gift_foryou/v8/v8-bg.jpg\") no-repeat scroll center top / auto  #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #d4c6a9;\n        border-bottom: 3px solid #d4c6a9;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v8/v8-bg-portrait.jpg\") no-repeat scroll center top / cover  #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #d4c6a9;\n        border-right: 3px solid #d4c6a9;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n    \n	.partner_section h2 {\n		font-size:20px!important;\n	}\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\n    body{\n        background: url(\"boomtag{boomtime_path}/img/gift_foryou/v8/v8-bg.jpg\") repeat scroll center center / cover  rgba(0, 0, 0, 0) !important;\n    }\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #d4c6a9;\n        border-bottom: 3px solid #d4c6a9;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #d4c6a9;\n        border-right: 3px solid #d4c6a9;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v8/v8-bg.jpg\") repeat scroll center top / cover  rgba(0, 0, 0, 0);\n}\n\n#openbox-main{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v8/proffesional-tag-bg-pattern.png\") repeat scroll 0 0 rgba(0, 0, 0, 0);\n    box-shadow: 2px 3px 3px #999180;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #d4c6a9;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #772f2e;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #772f2e;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='55';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:#f05044;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #f05044;\n        border-bottom: 3px solid #f05044;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:#f05044;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #f05044;\n        border-right: 3px solid #f05044;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n    \n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n\nbody{\n    background:#f05044;\n}\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #f05044;\n        border-bottom: 3px solid #f05044;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #f05044;\n        border-right: 3px solid #f05044;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background:#f05044;\n}\n\n#openbox-main{\n    background: #ffffff;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #f05044;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #8b281f;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #8b281f;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='57';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:#327ec1;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #7fd2ea;\n        border-bottom: 3px solid #7fd2ea;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:#327ec1;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #7fd2ea;\n        border-right: 3px solid #7fd2ea;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n    \n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\n    \n    body{\n        background:#327ec1;\n    }\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #7fd2ea;\n        border-bottom: 3px solid #7fd2ea;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #7fd2ea;\n        border-right: 3px solid #7fd2ea;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\nbody{\n    background:#327ec1;\n}\n\n#openbox-main{\n    background: #ffffff;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #7fd2ea;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #327ec1;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #333333;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #327ec1;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='35';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v11/v11-bg.png\") no-repeat scroll #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #3c2314;\n        border-bottom: 3px solid #3c2314;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v11/v11-bg.png\") no-repeat scroll #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #3c2314;\n        border-right: 3px solid #3c2314;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n    \n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v11/v11-bg.png\") repeat scroll center center rgba(0, 0, 0, 0) !important;\n}\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #3c2314;\n        border-bottom: 3px solid #3c2314;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #3c2314;\n        border-right: 3px solid #3c2314;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v11/v11-bg.png\") repeat scroll center center rgba(0, 0, 0, 0);\n    color:#FFF;\n}\n\n#openbox-main{\n    background: #cc3927;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #3c2314;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #3c2314;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #FFF;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #3c2314;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='36';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v12/v12-bg.png\") no-repeat scroll #363636 !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 2px dotted #5b5e60;\n        border-bottom: 2px dotted #5b5e60;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v12/v12-bg.png\") no-repeat scroll #363636 !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 2px dotted #5b5e60;\n        border-right: 2px dotted #5b5e60;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n	\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n    \n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v12/v12-bg.png\") repeat scroll center center rgba(0, 0, 0, 0) !important;\n}\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 2px dotted #5b5e60;\n        border-bottom: 2px dotted #5b5e60;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 2px dotted #5b5e60;\n        border-right: 2px dotted #5b5e60;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v12/v12-bg.png\") repeat scroll center center rgba(0, 0, 0, 0);\n    color:#00192c;\n}\n\n#openbox-main{\n    background: #ffffff;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 2px dotted #5b5e60;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #b9b18c;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #00192c;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #b9b18c;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='37';
UPDATE `sevence`.`gift_screen` SET `css`='@import url(\"boomtag{boomtime_path}/css/bootstrap.css\");\n\n\n@media(max-width:767px){\n\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v13/v13-bg.png\") no-repeat scroll #2d4a5f !important;\n    }\n\n    #openbox-main{\n        /* background: red !important; */\n        margin-top: 20px !important;\n        margin-bottom:40px !important;\n    }\n\n    .main-content{\n        border-top: 3px solid #7e92a5;\n        border-bottom: 3px solid #7e92a5;\n    }\n    \n    .ob-greetings h2{\n        position: static;\n        top: unset;\n        -webkit-transform: none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    .ob-greetings h2 strong{\n        font-size:22px !important; \n    }\n\n    .ob-org-name h2{\n        position: static;\n        top: unset;\n        -webkit-transform:  none;\n        -ms-transform:  none;\n        transform:  none;\n    }\n    \n    \n\n}\n\n@media(max-width:767px) and (orientation:portrait){\n\n    .ob-greetings h2{\n        font-size:20px !important;\n    }\n    body{\n        background:url(\"boomtag{boomtime_path}/img/gift_foryou/v13/v13-bg-portrait.png\") no-repeat scroll #2d4a5f !important;\n    }\n    \n}\n\n@media(max-width:767px) and (orientation:landscape){\n    .main-content .lower-c h2{\n        font-size:24px !important;\n    }\n\n    .main-content .lower-c h3{\n        font-size:20px !important;\n    }\n\n    .col-md-1, .col-md-2, .col-md-3, .col-md-4, .col-md-5, .col-md-6, .col-md-7, .col-md-8, .col-md-9, .col-md-10, .col-md-11, .col-md-12{\n        float:left !important;\n    }\n\n    .col-md-3 {\n        width: 25% !important;\n    }\n    .col-md-6 {\n        width: 50% !important;\n    }\n    \n    .col-md-4 {\n        width: 33.3333% !important;\n    }\n    \n    #openbox-main{\n        padding:8px !important;\n    }\n\n    .main-content{\n        border-left: 3px solid #7e92a5;\n        border-right: 3px solid #7e92a5;\n        border-top: none;\n        border-bottom: none;\n    }\n\n    .ob-greetings h2{\n        font-size:13px !important;\n        -ms-word-break: break-all; \n        word-break: break-all; \n        word-break: break-word; /* old webkit */ \n    }\n    \n    .main-content{\n        padding:15px 15px !important;\n    }\n\n    .ob-greetings h2 strong{\n        font-size:22px !important;\n    }\n	\n	.partner_section h2 {\n		font-size:20px!important;\n	}\n	\n    .ob-org-name h2{\n        font-size:16px !important;\n    }\n\n    .main-content .upper-c h1{\n        font-size:60px !important;\n    }\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v13/v13-bg.png\") repeat scroll center center rgba(0, 0, 0, 0) !important;\n}\n\n}\n\n@media(min-width:768px){\n\n\n    #openbox-main{\n        /* background: blue !important; */\n    }\n    \n    .main-content{\n        border-top: 3px solid #7e92a5;\n        border-bottom: 3px solid #7e92a5;\n    }\n    \n    #openbox-main{\n        margin-top: 250px !important;\n    }\n\n    \n\n}\n\n@media(min-width:992px){\n\n    #openbox-main{\n        margin-top: 220px !important;\n    /*    background: pink !important;      */\n    }\n    \n    .ob-greetings h2{\n        font-size:18px !important;\n    }\n    \n    .main-content{\n        border-top: none;\n        border-bottom: none;\n        border-left: 3px solid #7e92a5;\n        border-right: 3px solid #7e92a5;\n    }\n    \n\n        \n}\n\n@media(min-width:1200px){\n\n    #openbox-main{\n      /*  background: green !important;   */\n    }\n    \n    .ob-greetings h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n\n    .ob-org-name h2{\n        position: relative;\n        top: 50%;\n        margin-top:0;\n        -webkit-transform: translateY(-50%);\n        -ms-transform: translateY(-50%);\n        transform: translateY(-50%);\n    }\n    #openbox-main {\n        margin-top: 370px !important;\n    }\n\n}\n\nbody,\nhtml{\n    height:100%;\n}\n\n\nbody{\n    background: url(\"boomtag{boomtime_path}/img/gift_foryou/v13/v13-bg.png\") repeat scroll center center rgba(0, 0, 0, 0);\n    color:#2d4a5f;\n}\n\n#openbox-main{\n    background: #ffffff;\n    margin-top: 320px;\n    padding: 15px;\n}\n\n#openbox-inner{\n    border: 3px solid #7e92a5;\n}\n\n.ob-greetings{\n    font-family:\'Montserrat\',sans-serif;\n}\n\n.ob-greetings h2{\n    color: #7e92a5;\n    font-size: 24px;\n    text-align: center;\n    text-transform: uppercase;\n}\n.ob-greetings h2 strong{\n    color: #2d4a5f;\n    font-size: 42px;\n    font-weight: bold;\n    display:block;\n}\n\n.main-content{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.ob-org-name{\n    font-family: \'Montserrat\',sans-serif;\n    text-align: center;\n    text-transform: uppercase;\n}\n\n.main-content .upper-c h1{\n    color: #7e92a5;\n    font-size:120px;\n    margin-bottom:0;\n    margin-top:0;\n}\n.main-content .upper-c h1 sup{\n    font-size: 35%;\n}\n\n.main-content .lower-c h2{\n    font-size: 40px;\n    margin: 0;\n}\n\n.main-content .lower-c h3{\n    font-size: 32px;\n    margin: 0;\n}\n\n.partner_section h2 {\nfont-size:25px;\n}\n\na {\nfont-size:18px;\nfont-family:Montserrat,sans-serif;\ncolor:#007ca7;\n}\n\na:hover {\ncolor:#333;\n}\n\n.main-content,.ob-org-name {\nfont-family:Montserrat,sans-serif;\ntext-align:center;\ntext-transform:uppercase;\n}\n\n.partner_section,.partners {\nopacity:0;\n}' WHERE `gift_screen`='38';
#DCS 09.17.14 Mantis 2035: some adjustments needed for the claim_prize page
#UPDATE END 10.10.14

ALTER TABLE `bim_production`.`business` 
ADD COLUMN `BEP_status` TINYINT NOT NULL DEFAULT 0 AFTER `status_date`,
ADD COLUMN `BSC_status` TINYINT NOT NULL DEFAULT 0 AFTER `BEP_status`;
#MT 10.17.14 Mantis 2110: We need to track business status for different applications

ALTER TABLE `sevence`.`todo` ADD COLUMN `bt_app` TINYINT(1) NULL DEFAULT '0'  AFTER `temp_data` ;
#RC 10.17.14 Mantis 2109 : ADD column 'bt_app' in todo table

CREATE TABLE `bim_production`.`business_advisor_history` (
  `business_advisor_history` INT NOT NULL AUTO_INCREMENT,
  `business` INT NOT NULL,
  `advisor` INT NULL,
  `advisor_change_date` DATE NOT NULL,
  PRIMARY KEY (`business_advisor_history`));
#MT 10.17.14 Mantis 2112: We need to track advisor history

CREATE TABLE `bim_production`.`business_status` (
  `business_status` INT NOT NULL AUTO_INCREMENT,
  `business` INT NOT NULL,
  `status` INT NULL,
  `app` INT NOT NULL,
  `status_change_date` DATE NOT NULL,
  PRIMARY KEY (`business_status`));
#MT 10.20.14 Mantis 2111: We need to track business status history for businesses

CREATE TABLE `sevence`.`notifications` (
  `notification` INT(11) NOT NULL AUTO_INCREMENT,
  `from` INT(11) NOT NULL,
  `recipient` INT(11) NOT NULL,
  `business` INT(11) NULL,
  `date` DATE NULL,
  `message` TEXT NULL,
  `status` TINYINT(3) NULL DEFAULT 0 COMMENT '0=unread, 1=read, 2=dismissed, 3=completed',
  `dismissable` TINYINT(1) NULL DEFAULT 0,
  PRIMARY KEY (`notification`));
#KA 10.22.2014 M2128: Notifications: DB/API

ALTER TABLE `sevence`.`org_provider_link` ADD COLUMN `opt_out` TINYINT(1) NULL DEFAULT '0'  AFTER `verified` ;
ALTER TABLE `sevence`.`org_provider_link` ADD COLUMN `notes` TEXT NULL  AFTER `opt_out` ;
#RC 10.23.14 Mantis 2180 : ADD columns 'opt_out' and 'notes' in org_provider_link table

ALTER TABLE `sevence`.`notifications` 
ADD COLUMN `parent_notification` INT(11) NULL DEFAULT 0 AFTER `dismissable`;
#KA 10.27.2014 M2155: Notifications: DB/API part II

INSERT INTO todo_type (todo_type, name) VALUES('call_maintenance', 'Called for a monthly appointment'),
('dupe_search', 'Search for duplicate business records'),
('sold', 'This business sold');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_bing', 'Push profile date to Bing');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_facebook', 'Push profile data to Facebook');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_foursqaure', 'Push profile data to Foursquare');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_google', 'Push profile data to Google');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_sp', 'Push profile data to Superpages');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_yp', 'Push profile data to Yellow Pages');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_yelp', 'Push profile data to Yelp');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('push_yahoo', 'Push profile data to Yahoo');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('no_sale', 'Did not sell to this prospect');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('pres_rescheduled', 'The presentation was rescheduled');
#SLOW new to do types for reporting support and new to do functionality

ALTER TABLE `sevence`.`notifications` 
CHANGE COLUMN `date` `date` DATETIME NULL DEFAULT NULL ;
#KA 10.31.14 M2128: Notifications: DB/API

CREATE TABLE `bim_production`.`app_version` (
  `advisor` int(11) NOT NULL,
  `bep` varchar(2555) NULL,
  `bep_change_date` varchar(255) NULL,
  `bsc` varchar(255) NULL,
  `bsc_change_date` varchar(255) NULL,
  `bim` varchar(255) NULL,
  `bim_change_date` varchar(255) NULL,
  PRIMARY KEY (`advisor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#MT 10.31.14 M2162: Installed app versions and current app versions

CREATE TABLE `bim_production`.`bt_app` (
  `bt_app` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(255) NOT NULL,
  `app_shortname` varchar(255) DEFAULT NULL,
  `app_key` varchar(255) DEFAULT NULL,
  `app_iconurl` varchar(255) DEFAULT NULL,
  `app_version` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `install_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bt_app`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#MT 10.31.14 M2129: Business list API info for advisor

ALTER TABLE promo_card_print ADD COLUMN pfl_order VARCHAR(30);
ALTER TABLE promo_card_print ADD COLUMN blank_back TINYINT(1);
ALTER TABLE promo_card_print ADD COLUMN ship_to_org TINYINT(1);
ALTER TABLE promo_card_print ADD COLUMN received_date DATETIME(1);
#SLOW PFL Printing

ALTER TABLE `bim_production`.`app_version` 
ADD COLUMN `ba` VARCHAR(255) NULL AFTER `bim_change_date`,
ADD COLUMN `ba_change_date` VARCHAR(255) NULL AFTER `ba`;
#MT 11.04.14 M2162: Installed app versions and current app versions

INSERT INTO todo_type (todo_type, name) VALUES('activate_org', 'Activate this business');
#SLOW todo type to help with failed org activation.
#11.4.14 UPDATE END

#11.10.14 UPDATE BEGIN
INSERT INTO todo_type (todo_type, name) VALUES('promo_cards', 'Ordered promo cards');
INSERT INTO todo_type (todo_type, name) VALUES('promo_card_pickup', 'Pickup promo cards');
ALTER TABLE promo_card_print CHANGE COLUMN received_date received_date DATETIME;
#SLOW 11.10.14 More changes to promo card printing
#11.10.14 UPDATE END

#11.20.14 UPDATE BEGIN
ALTER TABLE org_auth_data CHANGE location_description location_description text, CHANGE amenities amenities text, CHANGE products_services products_services text;
ALTER TABLE org_auth_data CHANGE facebook_url facebook_url varchar(100);
#SLOW table structure is truncating data from the app.

# SLOW Manually added the dupe_search ID email.

# SLOW Manually added the profile_info ID email.

ALTER TABLE `sevence`.`notifications` 
CHANGE COLUMN `parent_notification` `thread` INT(11) NULL DEFAULT '0' ;
#KA 11.13.14 M2155: Notifications: DB/API part II

CREATE TABLE `sevence`.`dp_category` (
  `dp_category` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `dt_category` INT NULL,
  PRIMARY KEY (`dp_category`),
  INDEX `dt_category_idx` (`dt_category` ASC),
  INDEX `business_org_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `dt_category_idx`
    FOREIGN KEY (`dt_category`)
    REFERENCES `sevence`.`dt_category` (`dt_category`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_subcategory` (
  `dp_subcategory` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `dt_subcategory` INT NULL,
  PRIMARY KEY (`dp_subcategory`),
  INDEX `business_org_idx2` (`business_org` ASC),
  INDEX `dt_subcategory_idx2` (`dt_subcategory` ASC),
  CONSTRAINT `business_org_idx2`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `dt_subcategory_idx2`
    FOREIGN KEY (`dt_subcategory`)
    REFERENCES `sevence`.`dt_subcategory` (`dt_subcategory`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_product` (
  `dp_product` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `dt_product` INT NULL,
  PRIMARY KEY (`dp_product`),
  INDEX `business_org_idx1` (`business_org` ASC),
  INDEX `dt_product_idx` (`dt_product` ASC),
  CONSTRAINT `business_org_idx1`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `dt_product_idx`
    FOREIGN KEY (`dt_product`)
    REFERENCES `sevence`.`dt_product` (`dt_product`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_brand` (
  `dp_brand` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `dt_brand` INT NULL,
  PRIMARY KEY (`dp_brand`),
  INDEX `business_org_idx3` (`business_org` ASC),
  INDEX `dt_brand_idx` (`dt_brand` ASC),
  CONSTRAINT `business_org_idx3`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `dt_brand_idx`
    FOREIGN KEY (`dt_brand`)
    REFERENCES `sevence`.`dt_brand` (`dt_brand`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_service` (
  `dp_service` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `dt_service` INT NULL,
  PRIMARY KEY (`dp_service`),
  INDEX `dt_service_idx` (`dt_service` ASC),
  INDEX `business_org_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx4`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `dt_service_idx`
    FOREIGN KEY (`dt_service`)
    REFERENCES `sevence`.`dt_service` (`dt_service`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_category_ad_hoc` (
  `dp_category_ad_hoc` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `cat_name` VARCHAR(255) NULL,
  PRIMARY KEY (`dp_category_ad_hoc`),
  INDEX `business_org_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx5`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_subcategory_ad_hoc` (
  `dp_subcategory_ad_hoc` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `cat_name` VARCHAR(255) NULL,
  `sub_cat_name` VARCHAR(255) NULL,
  PRIMARY KEY (`dp_subcategory_ad_hoc`),
  INDEX `business_org_idx6` (`business_org` ASC),
  CONSTRAINT `business_org_idx6`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_product_ad_hoc` (
  `dp_product_ad_hoc` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `cat_name` VARCHAR(255) NULL,
  `product_name` VARCHAR(255) NULL,
  PRIMARY KEY (`dp_product_ad_hoc`),
  INDEX `business_org_idx7_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx7`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_brand_ad_hoc` (
  `dp_brand_ad_hoc` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `cat_name` VARCHAR(255) NULL,
  `brand_name` VARCHAR(255) NULL,
  PRIMARY KEY (`dp_brand_ad_hoc`),
  INDEX `business_org_idx8_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx8`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_service_ad_hoc` (
  `dp_service_ad_hoc` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `cat_name` VARCHAR(255) NULL,
  `service_name` VARCHAR(255) NULL,
  PRIMARY KEY (`dp_service_ad_hoc`),
  INDEX `business_org_idx9_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx9`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE TABLE `sevence`.`dp_collateral` (
  `dp_collateral` INT NOT NULL AUTO_INCREMENT,
  `business_org` INT NULL,
  `url` VARCHAR(255) NULL,
  PRIMARY KEY (`dp_collateral`),
  INDEX `business_org_idx` (`business_org` ASC),
  CONSTRAINT `business_org_idx10`
    FOREIGN KEY (`business_org`)
    REFERENCES `sevence`.`business_org` (`business`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 11.13.14 Mantis 0002204: Design Package DB and UI and API: Business background

CREATE  TABLE `sevence`.`dp_business_personality` (
  `dp_business_personality` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT(11) NULL DEFAULT NULL ,
  `word_1` TEXT NULL ,
  `word_2` TEXT NULL ,
  `word_3` TEXT NULL ,
  `word_4` TEXT NULL ,
  `word_5` TEXT NULL ,
  `word_6` TEXT NULL ,
  `word_7` TEXT NULL ,
  `word_8` TEXT NULL ,
  `word_9` TEXT NULL ,
  PRIMARY KEY (`dp_business_personality`) ,
  INDEX `business_org_idx_2` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_2`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

CREATE  TABLE `sevence`.`dp_business_recording` (
  `dp_business_recording` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT(11) NULL DEFAULT NULL ,
  `recording_desc` VARCHAR(255) NULL ,
  `url` TEXT NULL ,
  PRIMARY KEY (`dp_business_recording`) ,
  INDEX `business_org_idx_4` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_4`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 11.13.14 M2205: CREATE table name 'dp_business_personality' & 'dp_business_recording'

CREATE TABLE `sevence`.`sample_photo` (
  `sample_photo` INT(11) NOT NULL AUTO_INCREMENT,
  `url` TEXT NULL,
  `dt_category` INT(11) NULL,
  `type` INT(4) NULL,
  `demo` VARCHAR(20) NULL,
  `age_range` VARCHAR(10) NULL,
  `saturation` VARCHAR(10) NULL,
  `value` VARCHAR(10) NULL,
  PRIMARY KEY (`sample_photo`),
  INDEX `fk_dt_cat_idx` (`dt_category` ASC),
  CONSTRAINT `fk_dt_cat`
    FOREIGN KEY (`dt_category`)
    REFERENCES `sevence`.`dt_category` (`dt_category`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#KA 11.14.2014 M2212: Sample Photo Library

CREATE TABLE `sevence`.`sample_photo_subcat` (
  `sample_photo_subcats` INT(11) NOT NULL AUTO_INCREMENT,
  `sample_photo` INT(11) NOT NULL,
  `dt_subcategory` INT(11) NOT NULL,
  PRIMARY KEY (`sample_photo_subcats`),
  INDEX `fk_sample_photo_idx` (`sample_photo` ASC),
  INDEX `fk_dt_subcat_idx` (`dt_subcategory` ASC),
  CONSTRAINT `fk_sample_photo`
    FOREIGN KEY (`sample_photo`)
    REFERENCES `sevence`.`sample_photo` (`sample_photo`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dt_subcat`
    FOREIGN KEY (`dt_subcategory`)
    REFERENCES `sevence`.`dt_subcategory` (`dt_subcategory`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
    
ALTER TABLE `sevence`.`sample_photo` 
ADD COLUMN `thumb_url` TEXT NULL AFTER `url`;
#KA 11.14.2014 M2212: Sample Photo Library

CREATE  TABLE `sevence`.`dp_web_tools` (
  `dp_web_tools` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT(11) NULL DEFAULT NULL ,
  `web_tool_name` VARCHAR(255) NULL ,
  PRIMARY KEY (`dp_web_tools`) ,
  INDEX `business_org_idx_5` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_5`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 11.14.14 M2206: CREATE table name 'dp_web_tools'

CREATE  TABLE `sevence`.`dp_design` (
  `dp_design` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT(11) NULL DEFAULT NULL ,
  `saturation` VARCHAR(20) NULL ,
  `brightness` VARCHAR(20) NULL ,
  `layout` INT(1) NULL ,
  PRIMARY KEY (`dp_design`) ,
  INDEX `business_org_idx_3` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_3`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
    
CREATE  TABLE `sevence`.`dp_design_examples` (
  `dp_design_examples` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT(11) NULL DEFAULT NULL ,
  `site_url` TEXT NULL ,
  `recording_url` TEXT NULL ,
  PRIMARY KEY (`dp_design_examples`) ,
  INDEX `business_org_idx` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_6`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 11.14.14 M2208: CREATE table name 'dp_design' and 'dp_design_examples'

ALTER TABLE `sevence`.`dp_design` ADD COLUMN `fave_1` TEXT NULL  AFTER `layout` , ADD COLUMN `fave_2` TEXT NULL  AFTER `fave_1` , ADD COLUMN `fave_3` TEXT NULL  AFTER `fave_2` ;
#RC 11.17.14 M2208: ADD fields to the table 'dp_design'

ALTER TABLE `sevence`.`dp_design` ADD COLUMN `headline_font` TEXT NULL  AFTER `fave_3` , ADD COLUMN `body_font` TEXT NULL  AFTER `headline_font` ;
#RC 11.17.14 M2211: ADD fields to the table 'dp_design'

INSERT INTO todo_type (todo_type, name) VALUES('claiming_data', 'This information is required for claiming');
#SLOW changes to the transactions screen

CREATE TABLE `sevence`.`sample_photo_product` (
  `sample_photo_product` INT(11) NOT NULL AUTO_INCREMENT,
  `sample_photo` INT(11) NULL,
  `dt_product` INT(11) NULL,
  PRIMARY KEY (`sample_photo_product`),
  INDEX `fk_sample_photo_idx` (`sample_photo` ASC),
  INDEX `fk_dt_product_idx` (`dt_product` ASC),
  CONSTRAINT `fk_sample_photo_1`
    FOREIGN KEY (`sample_photo`)
    REFERENCES `sevence`.`sample_photo` (`sample_photo`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dt_product_1`
    FOREIGN KEY (`dt_product`)
    REFERENCES `sevence`.`dt_product` (`dt_product`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
CREATE TABLE `sevence`.`sample_photo_service` (
  `sample_photo_service` INT(11) NOT NULL AUTO_INCREMENT,
  `sample_photo` INT(11) NULL,
  `dt_service` INT(11) NULL,
  PRIMARY KEY (`sample_photo_service`),
  INDEX `fk_sample_photo_2_idx` (`sample_photo` ASC),
  INDEX `fk_dt_service_2_idx` (`dt_service` ASC),
  CONSTRAINT `fk_sample_photo_2`
    FOREIGN KEY (`sample_photo`)
    REFERENCES `sevence`.`sample_photo` (`sample_photo`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dt_service_2`
    FOREIGN KEY (`dt_service`)
    REFERENCES `sevence`.`dt_service` (`dt_service`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
CREATE TABLE `sevence`.`sample_photo_brand` (
  `sample_photo_brand` INT(11) NOT NULL AUTO_INCREMENT,
  `sample_photo` INT(11) NULL,
  `dt_brand` INT(11) NULL,
  PRIMARY KEY (`sample_photo_brand`),
  INDEX `fk_sample_photo_3_idx` (`sample_photo` ASC),
  INDEX `fk_dt_brand_3_idx` (`dt_brand` ASC),
  CONSTRAINT `fk_sample_photo_3`
    FOREIGN KEY (`sample_photo`)
    REFERENCES `sevence`.`sample_photo` (`sample_photo`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dt_brand_3`
    FOREIGN KEY (`dt_brand`)
    REFERENCES `sevence`.`dt_brand` (`dt_brand`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#KA 11.18.2014 M2212: Sample Photo Library

CREATE TABLE `dp_colors` (
  `dp_colors` int(11) NOT NULL AUTO_INCREMENT,
  `business_org` int(11) DEFAULT NULL,
  `analogous_1_1` varchar(100) DEFAULT NULL,
  `analogous_1_2` varchar(100) DEFAULT NULL,
  `analogous_1_3` varchar(100) DEFAULT NULL,
  `analogous_1_4` varchar(100) DEFAULT NULL,
  `analogous_1_5` varchar(100) DEFAULT NULL,
  `analogous_2_1` varchar(100) DEFAULT NULL,
  `analogous_2_2` varchar(100) DEFAULT NULL,
  `analogous_2_3` varchar(100) DEFAULT NULL,
  `analogous_2_4` varchar(100) DEFAULT NULL,
  `analogous_2_5` varchar(100) DEFAULT NULL,
  `compliment_1_1` varchar(100) DEFAULT NULL,
  `compliment_1_2` varchar(100) DEFAULT NULL,
  `compliment_1_3` varchar(100) DEFAULT NULL,
  `compliment_1_4` varchar(100) DEFAULT NULL,
  `compliment_1_5` varchar(100) DEFAULT NULL,
  `compliment_2_1` varchar(100) DEFAULT NULL,
  `compliment_2_2` varchar(100) DEFAULT NULL,
  `compliment_2_3` varchar(100) DEFAULT NULL,
  `compliment_2_4` varchar(100) DEFAULT NULL,
  `compliment_2_5` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`dp_colors`),
  KEY `business_org_idx14_idx` (`business_org`),
  KEY `business_org_idx17_idx` (`business_org`),
  CONSTRAINT `business_org_idx17` FOREIGN KEY (`business_org`) REFERENCES `business_org` (`business`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
#MT 11.18.14 Mantis 0002209: Design Package DB, UI and API for Colors

ALTER TABLE promo_card_print ADD manual_file tinyint(1);
#SLOW promo card printing

ALTER TABLE `sevence`.`promo_card_print` ADD COLUMN `shipping_method` VARCHAR(50) NOT NULL DEFAULT 'FDXG'  AFTER `manual_file` ;
#RC 11.19.14 M2219: ADD field to the table 'promo_card_print'

INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('referral', 'Qualified Referral');
#SLOW 11.18.14 pipeline reporting stuff

CREATE TABLE `sevence`.`dp_photos` (
  `dp_photos` INT(11) NOT NULL AUTO_INCREMENT,
  `business_org` INT(11) NULL,
  `sample_photo` INT(11) NULL,
  PRIMARY KEY (`dp_photos`),
  INDEX `sample_photo_idx` (`sample_photo` ASC),
  CONSTRAINT `fk_sample_photo_4`
    FOREIGN KEY (`sample_photo`)
    REFERENCES `sevence`.`sample_photo` (`sample_photo`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT);
#DCS 11.20.14 Mantis 2210: Design Package DB, UI and API for Images

ALTER TABLE `sevence`.`dp_design` ADD COLUMN `provide_photos` TEXT NULL AFTER `body_font` ;
#DCS 11.20.14 Mantis 2210: Design Package DB, UI and API for Images (additional column if business is supplying the photographs)
#11.20.14 UPDATE END

#11.25.14 UPDATE BEGIN
ALTER TABLE `sevence`.`gift` ADD COLUMN `notify_purchaser` TINYINT(1) NOT NULL DEFAULT '0'  AFTER `source` ;
#RC 10.29.14 Mantis 0002161 : ADD COLUMN to gift table

INSERT INTO `sevence`.`email_marketing` (`email_marketing`, `type`, `id`, `org`, `active`, `name`, `subject`, `headline`, `narrative`, `body`, `email_cycle`, `queued_on`, `hide`, `show_event`, `show_article`, `email_design`, `client_or_org`, `client_type`, `marketing_list`, `marketing_list_opt`, `org_type`, `org_restrict`, `editor`, `photo`, `photo_filename`, `offer`, `event`, `campaign_type`, `push_type`, `edit_date`, `edit_prof`, `permalink`, `show_reward`, `email_trigger`) VALUES (NULL, '1', 'gc_notify', '3', '1', 'GC Notification', 'GC Notification', ' ', '', '<p style="text-align: left;">We thought you would like to know that {gc_To} picked up the gift certificate you sent.</p>', '1', '2014-05-28 06:31:16', '0', '0', '0', '4', '0', '0', '0', '0', 'ALL', 'NONE', '1', '0', '', '0', '0', '0', '0', '2014-10-17 05:39:45', '12337', 'gc-notify', '0', 'RR');
#RC 10.29.14 Mantis 0002161 : INSERT new email_marketing for email with an id "gc_notify"
#11.25.14 UPDATE END

#12.15.14 UPDATE BEGIN
ALTER TABLE `sevence`.`prof` ADD COLUMN `is_acct_manager` TINYINT(1) NOT NULL DEFAULT '0'  AFTER `is_advisor` ;
#RC 11.18.14 M2215: ADD field to the table 'prof'

CREATE  TABLE `sevence`.`business_sales_notes` (
  `business_sales_notes` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT NULL ,
  `date` DATETIME NULL ,
  `advisor` INT NULL ,
  `notes` TEXT NULL ,
  PRIMARY KEY (`business_sales_notes`) ,
  INDEX `business_org_idx` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_14`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 11.21.14 M2227: CREATE table name 'business_sales_notes'

CREATE  TABLE `sevence`.`pipeline` (
  `pipeline` INT NOT NULL AUTO_INCREMENT ,
  `business_org` INT NULL ,
  `advisor` INT NULL ,
  `referring_advisor` INT NULL ,
  `stage` INT NULL ,
  `outcome` TEXT NULL ,
  `units_BIM` INT NULL ,
  `units_network` INT NULL ,
  `units_BSC` INT NULL ,
  `estimated_close_date` DATETIME NULL ,
  `latest_est_close_date` DATETIME NULL ,
  PRIMARY KEY (`pipeline`) ,
  INDEX `business_org_idx` (`business_org` ASC) ,
  CONSTRAINT `business_org_idx_17`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 11.25.14 M2239: CREATE table name 'pipeline'

INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('value', 'What is the value of this sale');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`) VALUES ('latest_estimate', 'New estimated close date');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`, `days`) VALUES ('close_countdown', 'Countdown to the close date', '0');
INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`, `days`) VALUES ('schedule_followup', 'Schedule the followup meeting', '0');
UPDATE `sevence`.`todo_type` SET `name`='Scheduling claiming with Account Manager' WHERE `todo_type`='schedule_claiming';
#SLOW more pipeline reporting

ALTER TABLE `sevence`.`pipeline` ADD COLUMN `start_date` DATETIME NULL  AFTER  `units_BSC` ;
#RC 11.27.14 M2249: ALTER table 'pipeline' ADD COLUMN `start_date`

ALTER TABLE `sevence`.`pipeline` ADD COLUMN `close_date` DATETIME NULL  AFTER `latest_est_close_date` ;
#RC 12.01.14 M2261: ALTER table 'pipeline' ADD COLUMN `close_date`

CREATE  TABLE `sevence`.`bt_product` (
  `bt_product` INT NOT NULL AUTO_INCREMENT ,
  `desc` VARCHAR(100) NULL ,
  `setup` DECIMAL(11,2) NULL ,
  `monthly_price` DECIMAL(11,2) NULL ,
  `active` TINYINT(1) NULL ,
  PRIMARY KEY (`bt_product`) );
  
INSERT INTO `sevence`.`bt_product` (`desc`, `setup`, `monthly_price`, `active`) VALUES ('BIM only', '150', '69', '1');
INSERT INTO `sevence`.`bt_product` (`desc`, `setup`, `monthly_price`, `active`) VALUES ('BIM & network', '299', '99', '1');
INSERT INTO `sevence`.`bt_product` (`desc`, `setup`, `monthly_price`, `active`) VALUES ('Website 5 pages or less', '399', '199', '1');
INSERT INTO `sevence`.`bt_product` (`desc`, `setup`, `monthly_price`, `active`) VALUES ('Website more than 5 pages', '399', '199', '1');
#RC 12.02.14 M2265: CREATE table name 'bt_product' and INSERT values

ALTER TABLE `sevence`.`pipeline` CHANGE COLUMN `units_BIM` `bt_product` INT(11) NULL DEFAULT NULL  , CHANGE COLUMN `units_network` `locations` INT(11) NULL DEFAULT NULL  , CHANGE COLUMN `units_BSC` `website_pages` INT(11) NULL DEFAULT NULL  ;
#RC 12.02.14 M2241: ALTER table 'pipeline' CHANGE COLUMN

CREATE  TABLE `sevence`.`bt_network` (
  `bt_network` INT NOT NULL AUTO_INCREMENT ,
  `network_name` VARCHAR(100) NULL ,
  PRIMARY KEY (`bt_network`) );

CREATE  TABLE `sevence`.`bt_network_detail` (
  `bt_network_detail` INT NOT NULL AUTO_INCREMENT ,
  `bt_network` INT NULL ,
  `business_org` INT NULL ,
  PRIMARY KEY (`bt_network_detail`) ,
  INDEX `bt_network_fk` (`bt_network` ASC) ,
  INDEX `business_org_fk` (`business_org` ASC) ,
  CONSTRAINT `bt_network_fk`
    FOREIGN KEY (`bt_network` )
    REFERENCES `sevence`.`bt_network` (`bt_network` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `business_org_fk`
    FOREIGN KEY (`business_org` )
    REFERENCES `sevence`.`business_org` (`business` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 12.05.14 M2274: CREATE table 'bt_network' and 'bt_network_detail'

ALTER TABLE `sevence`.`dp_brand` 
ADD COLUMN `dp_design` INT(11) NULL AFTER `dt_brand`,
ADD INDEX `fk_dp_brand_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_brand` 
ADD CONSTRAINT `fk_dp_brand_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

ALTER TABLE `sevence`.`dp_business_personality` 
CHANGE COLUMN `word_1` `word_1` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_2` `word_2` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_3` `word_3` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_4` `word_4` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_5` `word_5` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_6` `word_6` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_7` `word_7` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_8` `word_8` VARCHAR(50) NULL DEFAULT NULL ,
CHANGE COLUMN `word_9` `word_9` VARCHAR(50) NULL DEFAULT NULL ,
ADD COLUMN `dp_design` INT(11) NULL AFTER `word_9`,
ADD INDEX `fk_dp_business_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_business_personality` 
ADD CONSTRAINT `fk_dp_business_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

ALTER TABLE `sevence`.`dp_business_recording` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_brecording_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_business_recording` 
ADD CONSTRAINT `fk_dp_brecording_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_category` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_category_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_category` 
ADD CONSTRAINT `fk_dp_category_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_collateral` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_collateral_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_collateral` 
ADD CONSTRAINT `fk_dp_collateral_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_colors` 
CHANGE COLUMN `analogous_1_1` `analogous_1_1` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_1_2` `analogous_1_2` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_1_3` `analogous_1_3` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_1_4` `analogous_1_4` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_1_5` `analogous_1_5` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_2_1` `analogous_2_1` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_2_2` `analogous_2_2` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_2_3` `analogous_2_3` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_2_4` `analogous_2_4` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `analogous_2_5` `analogous_2_5` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_1_1` `compliment_1_1` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_1_2` `compliment_1_2` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_1_3` `compliment_1_3` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_1_4` `compliment_1_4` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_1_5` `compliment_1_5` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_2_1` `compliment_2_1` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_2_2` `compliment_2_2` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_2_3` `compliment_2_3` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_2_4` `compliment_2_4` VARCHAR(20) NULL DEFAULT NULL ,
CHANGE COLUMN `compliment_2_5` `compliment_2_5` VARCHAR(20) NULL DEFAULT NULL ,
ADD COLUMN `base_color` VARCHAR(20) NULL DEFAULT NULL AFTER `compliment_2_5`,
ADD COLUMN `dp_design` INT(11) NULL AFTER `base_color`,
ADD INDEX `fk_dp_colors_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_colors` 
ADD CONSTRAINT `fk_dp_colors_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

ALTER TABLE `sevence`.`dp_design_examples` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_dexamples_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_design_examples` 
ADD CONSTRAINT `fk_dp_dexamples_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_photos` 
ADD COLUMN `is_gray` TINYINT(1) NULL DEFAULT 0 AFTER `sample_photo`,
ADD COLUMN `dp_design` INT(11) NULL AFTER `is_gray`,
ADD INDEX `fk_dp_photos_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_photos` 
ADD CONSTRAINT `fk_dp_photos_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

ALTER TABLE `sevence`.`dp_product` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_product_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_product` 
ADD CONSTRAINT `fk_dp_product_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_service` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_service_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_service` 
ADD CONSTRAINT `fk_dp_service_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_subcategory` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_subcategory_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_subcategory` 
ADD CONSTRAINT `fk_dp_subcategory_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  
ALTER TABLE `sevence`.`dp_web_tools` 
ADD COLUMN `dp_design` INT(11) NULL,
ADD INDEX `fk_dp_web_tools_design_idx` (`dp_design` ASC);
ALTER TABLE `sevence`.`dp_web_tools` 
ADD CONSTRAINT `fk_dp_web_tools_design`
  FOREIGN KEY (`dp_design`)
  REFERENCES `sevence`.`dp_design` (`dp_design`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

DROP TABLE `sevence`.`dp_brand_ad_hoc`;
DROP TABLE `sevence`.`dp_product_ad_hoc`, `sevence`.`dp_service_ad_hoc`, `sevence`.`dp_subcategory_ad_hoc`;
DROP TABLE `sevence`.`dp_category_ad_hoc`;

CREATE TABLE `sevence`.`dp_ad_hoc` (
  `dp_ad_hoc` INT(11) NOT NULL AUTO_INCREMENT,
  `dp_design` INT(11) NULL,
  `type` VARCHAR(20) NULL,
  `name` VARCHAR(100) NULL,
  PRIMARY KEY (`dp_ad_hoc`),
  INDEX `fk_dp_ad_hoc_design_idx` (`dp_design` ASC),
  CONSTRAINT `fk_dp_ad_hoc_design`
    FOREIGN KEY (`dp_design`)
    REFERENCES `sevence`.`dp_design` (`dp_design`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
    
ALTER TABLE `sevence`.`dp_ad_hoc` 
ADD COLUMN `business_org` INT(11) NULL AFTER `dp_ad_hoc`;
#RC 12.08.14 M2279: Design package DB, UI and API changes

CREATE TABLE `sevence`.`sample_website` (
  `sample_website` INT NOT NULL AUTO_INCREMENT,
  `website_desc` varchar(40) NULL,
  `URL` text NULL,
  `saturation` varchar(50) NULL,
  `brightness` varchar(50) NULL,
  PRIMARY KEY (`sample_website`))
ENGINE=InnoDB DEFAULT CHARSET=latin1;
#DCS 12.08.14 Mantis 0002280: sample website table (sample_website)

CREATE TABLE `sevence`.`sample_website_cat`(
 `sample_website_cat` INT NOT NULL AUTO_INCREMENT,
 `sample_website` INT NOT NULL,
 `dt_category` INT NOT NULL,
PRIMARY KEY (`sample_website_cat`),
CONSTRAINT `sample_website_idx`
    FOREIGN KEY (`sample_website`)
    REFERENCES `sevence`.`sample_website` (`sample_website`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
);
#DCS 12.08.14 Mantis 0002280: sample website table (sample_website_cat)

INSERT INTO `sevence`.`todo_type` (`todo_type`, `name`, `days`) VALUES ('collect_passwords', 'Collect information about previously claimed profiles', '0');
#SLOW Pipeline reporting

ALTER TABLE `sevence`.`pipeline` 
ADD COLUMN `post_sale` INT NULL DEFAULT 0 AFTER `close_date`;
#MT 12.10.14 Mantis 0002291: changes to the schedule_claiming post

CREATE  TABLE `sevence`.`regions` (
  `regions` INT NOT NULL AUTO_INCREMENT ,
  `region_name` VARCHAR(255) NULL ,
  PRIMARY KEY (`regions`) );
#MT 12.11.14 0002306: Syncing region and territory info across sevence and BIM

CREATE  TABLE `sevence`.`territory` (
  `territory` INT NOT NULL AUTO_INCREMENT ,
  `territory_name` VARCHAR(255) NULL ,
  `regions` INT(11) NULL ,
  PRIMARY KEY (`territory`) ,
  INDEX `regions_idx` (`regions` ASC) ,
  CONSTRAINT `regions`
    FOREIGN KEY (`regions` )
    REFERENCES `sevence`.`regions` (`regions` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#MT 12.11.14 0002306: Syncing region and territory info across sevence and BIM

ALTER TABLE `sevence`.`prof` 
ADD COLUMN `territory` INT NULL,
ADD INDEX `prof_territory_idx` (`territory` ASC);
ALTER TABLE `sevence`.`prof` 
ADD CONSTRAINT `prof_territory`
  FOREIGN KEY (`territory`)
  REFERENCES `sevence`.`territory` (`territory`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
#MT 12.11.14 0002306: Syncing region and territory info across sevence and BIM

CREATE  TABLE `bim_production`.`regions` (
  `regions` INT NOT NULL AUTO_INCREMENT ,
  `region_name` VARCHAR(255) NULL ,
  PRIMARY KEY (`regions`) );
#RC 11.18.14 M2217: CREATE table 'regions'

CREATE  TABLE `bim_production`.`territory` (
  `territory` INT NOT NULL AUTO_INCREMENT ,
  `territory_name` VARCHAR(255) NULL ,
  `regions` INT(11) NULL ,
  PRIMARY KEY (`territory`) ,
  INDEX `regions_idx` (`regions` ASC) ,
  CONSTRAINT `regions`
    FOREIGN KEY (`regions` )
    REFERENCES `bim_production`.`regions` (`regions` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);
#RC 11.18.14 M2217: CREATE table 'territory'
    
ALTER TABLE `bim_production`.`advisor` ADD COLUMN `territory` INT(11) NULL  AFTER `inside_sales` , 
  ADD CONSTRAINT `territory`
  FOREIGN KEY (`territory` )
  REFERENCES `bim_production`.`territory` (`territory` )
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
, ADD INDEX `territory_idx` (`territory` ASC) ;
#RC 11.18.14 M2217: ADD field and FK to the table 'advisor'

ALTER TABLE `bim_production`.`business` ADD COLUMN `territory` INT(11) NULL  AFTER `BSC_status` , 
  ADD CONSTRAINT `territory_idx_2`
  FOREIGN KEY (`territory` )
  REFERENCES `bim_production`.`territory` (`territory` )
  ON DELETE NO ACTION
  ON UPDATE NO ACTION
, ADD INDEX `territory_idx` (`territory` ASC) ;
#RC 11.18.14 M2217: ADD field and FK to the table 'business'
#12.15.14 UPDATE END
