-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathglobe_bank.sql
111 lines (96 loc) · 16.8 KB
/
globe_bank.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
-- MySQL dump 10.13 Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost Database: globe_bank
-- ------------------------------------------------------
-- Server version 5.7.27-0ubuntu0.18.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admins`
--
DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`hashed_password` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admins`
--
LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
INSERT INTO `admins` VALUES (5,'jimmy','tu','[email protected]','jianmingtu1','$2y$10$u4SzuvhDBYcjwrLcPJc3qe3yXkVaQHn4VIxo9yuLoEkFe3ABWAR8y');
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject_id` int(11) DEFAULT NULL,
`menu_name` varchar(255) DEFAULT NULL,
`position` int(3) DEFAULT NULL,
`visible` tinyint(1) DEFAULT NULL,
`content` text,
PRIMARY KEY (`id`),
KEY `fk_subject_id` (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pages`
--
LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES (1,1,'Globe',1,0,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/about us_96582054.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>About Globe Bank</h1>\r\n <p>Our mission at Globe Bank International is simple: To serve every coordinate in every hemisphere as if it were our own. From the beginning, it\'s been our goal to incorporate world-class services with an unmatched level of responsiveness and thoughtfulness, no matter what your level of banking need. </p>\r\n\r\n <p>Globe Bank International (NYSE: GBI), founded in 1950, is one of the newer financial institutions widely active in the world financial market. Despite our youth, we have a history solidly built on hard work, common-sense business practices, empowering investments, and an unyielding dedication to excellence.</p>\r\n\r\n <p>We currently operate in 42 countries and have nearly 130,000 employees. Our client base is in the millions, from individuals to worldwide conglomerates, and our assets total approximately $1.8 trillion. Learn more about our services and our history, and let us know how we can work together to help you.</p>\r\n\r\n</div>\r\n'),(2,1,'History',2,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/history_643025418.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>History</h1>\r\n <p>Founded in 1950 by brothers Otis and Isaac Bott, Globe Bank launched as a community financial institution with a fervent mission to help small businesses get their footing in the new economy of Postwar England. While the promise of prosperity was rampant, it was unfortunate that those willing to help with financial backing were understandably cautious and scarce.</p>\r\n\r\n <p>The Botts believed in the power of community and ingenuity, so much so that several organizations, even to this day, credit the brothers for both their initial formation and their continued success. Among those businesses in the early days is what we now know as The Landon Hotel chain. As others repeatedly turned down requests for financing from its passionate, but inexperienced founder, Arthur Landon, the Botts appreciated and supported Landon\'s verve and vision. What started as a single hotel in London\'s West End, backed by Globe Bank, is now an impressive hotel empire that thrives in cities all around the world.</p>\r\n\r\n <p>More recently, Globe Bank International has received acclaim for its high-profile investment in Winged Achene Technologies, giving it the means to expand from a small specialty helicopter blade company to a transnational rotorcraft resource, expanding not only the company\'s financial horizons, but creating several thousand sustainable jobs in three cities.</p>\r\n\r\n <p>The Botts\' keen instincts for solid investments grew just as swiftly as those companies it supported. In 1974, it moved its home office from London to Washington D.C. to better serve its growing clientele, and changed its name to Globe Bank International. Globe Bank International rapidly became key in corporate, commercial, and investment banking in the United States and internationally, assisting in intercontinental and domestic asset management and growth.</p>\r\n\r\n <p>Still, at its core, Globe Bank International remains a community bank, focusing on the specific needs of individuals and organizations in each community in which its branches are located. Today, Globe Bank is overseen by Otis Bott, President, alongside his son, Gerald Bott, CEO. They have successfully maintained the values and ideals of the family business, despite the bank\'s tremendous growth over the last half century.</p>\r\n\r\n</div>\r\n'),(3,1,'Leadership',3,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/leadership_469723021.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Leadership</h1>\r\n\r\n <h2>Board of Directors</h2>\r\n <ul>\r\n <li>Robert Otis Bott, President</li>\r\n <li>Sarah M. Bott</li>\r\n <li>Alisha Bryan</li>\r\n <li>Henry Terry</li>\r\n <li>Meredith Jewel Coffey</li>\r\n <li>Jesse Gould</li>\r\n <li>Lea Sheryl Rodriquez</li>\r\n <li>Joseph Riley</li>\r\n <li>Martin Stephens</li>\r\n <li>Jimmie Frank</li>\r\n </ul>\r\n\r\n <h2>Executive Team</h2>\r\n <ul>\r\n <li>Gerald Bott, Chairman and Chief Executive Officer</li>\r\n <li>Stewart Talley, Chief Risk Officer</li>\r\n <li>Judson Phillips, General Counsel</li>\r\n <li>Naomi Ballard, VP Human Resources</li>\r\n <li>Dominique Stein, Asset Management CEO </li>\r\n <li>Cantby Bott, Chief Financial Officer</li>\r\n <li>Frederic Owen, Commercial Banking CEO</li>\r\n <li>Freeman McConnell, Corporate & Investment Bank CEO</li>\r\n <li>Saul Hunt, Consumer & Community Banking CEO</li>\r\n <li>Cheri Karla Mann, Chief Operating Officer</li>\r\n </ul>\r\n\r\n</div>\r\n'),(4,1,'Contact Us',4,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/contact_dv1060035.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n\r\n<div id=\"content\">\r\n <h1>Contact Us</h1>\r\n <p>We\'re available 24 hours a day, 7 days a week for all your customer service needs.</p>\r\n <ul>\r\n <li><a href=\"#\">General banking</a></li>\r\n <li><a href=\"#\">Online banking</a></li>\r\n <li><a href=\"#\">Mobile banking</a></li>\r\n <li><a href=\"#\">Report fraud</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(5,2,'Banking',1,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/banking_57278269.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Banking</h1>\r\n <h2>Branch, ATM, and Online Banking </h2>\r\n <p>Bank from anywhere around the globe! With hundreds of branches and even more ATMs, it\'s almost guaranteed that you\'re within a short walk or drive from one of our locations. We go beyond the typical banking hours with our secure online banking services. If you need to manage or move your money, your accounts are available 24 hours a day. </p>\r\n\r\n <ul>\r\n <li><a href=\"#\">Find a branch</a></li>\r\n\r\n <li><a href=\"#\">Find an ATM</a></li>\r\n\r\n <li><a href=\"#\">Learn about online banking</a></li>\r\n\r\n <li><a href=\"#\">Learn about Bott Bill Pay</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(6,2,'Credit',2,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/creditcards_598949380.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Credit Cards</h1>\r\n <p>Our credit card program has been redesigned to help everyone build and improve their credit rather than sink deep into debt. With variable rates that suite your financial profile and needs, we grow with you, rather than against you.</p>\r\n <ul>\r\n <li><a href=\"#\">Compare our credit cards</a></li>\r\n <li><a href=\"#\">Cash back credit cards</a></li>\r\n <li><a href=\"#\">Rewards cards</a></li>\r\n <li><a href=\"#\">Check your credit score</a></li>\r\n <li><a href=\"#\">Transfer a balance</a></li>\r\n </ul>\r\n</div>\r\n'),(7,2,'Mortgages',3,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/homeloans_84513610.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Mortgages</h1>\r\n <p>People shouldn\'t have to buy the farm before they buy the farm. We believed that in 1950, and we believe that today. A home—whether a farm or condo or anything in between—is a place where you should feel safe and secure, not afraid that your mortgage is going to drain you of all happiness. Our home loan and home equity professionals take the time to discuss all options, and combine our pre-approval screening with financial forecasts so you know exactly what you can afford for your first or next home.</p>\r\n <ul>\r\n <li><a href=\"#\">Check current mortgage rates</a></li>\r\n <li><a href=\"#\">Check current refinance rates</a></li>\r\n <li><a href=\"#\">Learn how to buy a home</a></li>\r\n <li><a href=\"#\">Learn how to refinance</a></li>\r\n <li><a href=\"#\">Mortgage rate calculator</a></li>\r\n </ul>\r\n</div>\r\n'),(8,3,'Checking',1,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/bizchecking_86519574.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Business Checking</h1>\r\n <p>Options abound when it comes to selecting a Globe Bank business checking account. With so many choices, it might seem daunting to select the account that\'s right for your business. However, our talented customer service team is always available to help, whether in person, by phone, or online. Take a peek at some of our options, and when you\'re ready to get started, give us a shout.</p>\r\n\r\n <ul>\r\n <li><a href=\"#\">Compare our checking accounts</a></li>\r\n <li><a href=\"#\">What you\'ll need to open an account</a></li>\r\n <li><a href=\"#\">How to choose the right checking account for your business</a></li>\r\n <li><a href=\"#\">Accounts with no monthly service fee</a></li>\r\n <li><a href=\"#\">Order checks</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(9,3,'Loans',2,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/bizloans_539438468.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Business Loans</h1>\r\n <p>Businesses need upkeep to stay profitable in a competitive market. Whether you need to purchase new equipment, have plans for an expansion, or want to remodel your facility, Globe Bank can help you finance your vision.</p>\r\n <ul>\r\n <li><a href=\"#\">Compare our business term loans</a></li>\r\n <li><a href=\"#\">Learn about SBA loan options</a></li>\r\n <li><a href=\"#\">Estimate monthly payments</a></li>\r\n <li><a href=\"#\">Check your application status</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(10,3,'Merchant Services',3,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/merchant_619738814.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Merchant Services</h1>\r\n <p>Whether onsite, online, or on-the-go, your business needs to be nimble in processing payments. We\'ve got the experience to navigate the ever-changing world of payment processing technology. We\'ll make it easy for you to get started with a merchant account, so you can start taking payments almost immediately. </p>\r\n <ul>\r\n <li><a href=\"#\">Compare our merchant accounts</a></li>\r\n <li><a href=\"#\">Credit card processing options</a></li>\r\n <li><a href=\"#\">Accepting mobile payments</a></li>\r\n <li><a href=\"#\">POS systems</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(11,5,'Financing',1,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/financing_522867260.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Financing</h1>\r\n <p>From simple loans to long-term financing for sustained corporate growth, our advisors are here to help with a comprehensive selection of solutions and products to build your business.</p>\r\n <ul>\r\n <li><a href=\"#\">Lines of credit</a></li>\r\n <li><a href=\"#\">Asset-based loans</a></li>\r\n <li><a href=\"#\">Real estate loans</a></li>\r\n <li><a href=\"#\">Employee stock ownership plans</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(12,5,'Investments',2,1,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/investments_97489446.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Investments and Asset Management</h1>\r\n <p>We\'ll guide you through the global market like no one else can—from global liquidity, real estate securities, hedge funds, and more. We\'ll help you understand investment risk, dealing with inflation and soft economies, as well as asset allocation and regulatory requirements.</p>\r\n <ul>\r\n <li><a href=\"#\">Investments for insurance companies</a></li>\r\n <li><a href=\"#\">Pension fund investments</a></li>\r\n <li><a href=\"#\">Investment goals for non-profits and charitable institutions</a></li>\r\n <li><a href=\"#\">Educational establishments investments and endowments</a></li>\r\n <li><a href=\"#\">Social and environmental impact of investments</a></li>\r\n </ul>\r\n\r\n</div>\r\n'),(13,5,'Treasury',3,0,'<div id=\"hero-image\">\r\n <img src=\"images/page_assets/treasury_591423262.png\" width=\"900\" height=\"200\" alt=\"\" />\r\n</div>\r\n\r\n<div id=\"content\">\r\n <h1>Treasury Services</h1>\r\n <p>Let Globe Bank be your co-CFO. We\'ll help you improve cash flow, improve efficiency, streamline payroll and payment processing, and help you to build a leaner, cleaner organization.</p>\r\n <ul>\r\n <li><a href=\"#\">Collections and cash applications</a></li>\r\n <li><a href=\"#\">Deposit and account management options</a></li>\r\n <li><a href=\"#\">Payment processing</a></li>\r\n <li><a href=\"#\">Payroll procedures</a></li>\r\n <li><a href=\"#\">Fraud protection</a></li>\r\n <li><a href=\"#\">Liquidity management</a></li>\r\n <li><a href=\"#\">International expansion</a></li>\r\n <li><a href=\"#\">Healthcare program management</a></li>\r\n </ul>\r\n\r\n</div>\r\n');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subjects`
--
DROP TABLE IF EXISTS `subjects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subjects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`menu_name` varchar(255) DEFAULT NULL,
`position` int(3) DEFAULT NULL,
`visible` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subjects`
--
LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
INSERT INTO `subjects` VALUES (1,'About Globe Bank',1,1),(2,'Consumer',2,1),(3,'Small',3,0),(5,'Commercial',4,1);
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-07-25 16:33:14