text:
The Line of Beauty
Alan Hollinghurst
Winner of the Man Booker Prize and a finalist for the Lambda Literary Award and the NBCC award
A New York Times Bestseller (Extended)
An LA Times Bestseller
A Northern California Bestseller
A Sunday Times Bestseller
From Alan Hollinghurst, the acclaimed author of The Sparsholt Affair, The Line of Beauty is a sweeping novel about class, sex, and money during four extraordinary years of change and tragedy.
In the summer of 1983, twenty-year-old Nick Guest moves into an attic room in the Notting Hill home of the Feddens: conservative Member of Parliament Gerald, his wealthy wife Rachel, and their two children, Toby-whom Nick had idolized at Oxford-and Catherine, who is highly critical of her family's assumptions and ambitions.
As the boom years of the eighties unfold, Nick, an innocent in the world of politics and money, finds his life altered by the rising fortunes of this glamorous family. His two vividly contrasting love affairs, one with a young black man who works as a clerk and one with a Lebanese millionaire, dramatize the dangers and rewards of his own private pursuit of beauty, a pursuit as compelling to Nick as the desire for power and riches among his friends. Richly textured, emotionally charged, disarmingly comic, this is a major work by one of our finest writers.
PUBLISHERS WEEKLY SEP 20, 2004
Among its other wonders, this almost perfectly written novel, recently longlisted for the Mann Booker, delineates what's arguably the most coruscating portrait of a plutocracy since Goya painted the Spanish Bourbons. To shade in the nuances of class, Hollingsworth uses plot the way it was meant to be used not as a line of utility, but as a thematically connected sequence of events that creates its own mini-value system and symbols.The book is divided into three sections, dated 1983, 1986 and 1987. The protagonist, Nick Guest, is a James scholar in the making and a tripper in the fast gay culture of the time. The first section shows Nick moving into the Notting Hill mansion of Gerald Fedden, one of Thatcher's Tory MPs, at the request of the minister's son, Toby, Nick's all-too-straight Oxford crush. Nick becomes Toby's sister Catherine's confidante, securing his place in the house, and loses his virginity spectacularly to Leo, a black council worker. The next section jumps the reader ahead to a more sophisticated Nick. Leo has dropped out of the picture; cocaine, three-ways and another Oxford alum, the sinisterly alluring, wealthy Lebanese Wani Ouradi, have taken his place. Nick is dimly aware of running too many risks with Wani, and becomes accidentally aware that Gerald is running a few, too. Disaster comes in 1987, with a media scandal that engulfs Gerald and then entangles Nick. While Hollinghurst's story has the true feel of Jamesian drama, it is the authorial intelligence illuminating otherwise trivial pieces of story business so as to make them seem alive and mysteriously significant that gives the most pleasure. This is Nick coming home for the first and only time with the closeted Leo: "there were two front doors set side by side in the shallow recess of the porch. Leo applied himself to the right hand one, and it was one of those locks that require tender probings and tuggings, infinitesimal withdrawals, to get the key to turn." This novel has the air of a classic. is primed for even greater acclaim and sales with this masterful volume, the latest in a wave of Jamesian novels.
Bloomsbury USA
Bookwire Gesellschaft zum Vertrieb digitaler Medien mbH
More Books by Alan Hollinghurst
The Stranger's Child
The Sparsholt Affair
The Swimming-Pool Library
Berenice and Bajazet
El caso Sparsholt

redpajama_set_name: RedPajamaCommonCrawl


Welcome to the 2nd Headliner Highlight, a series where we talk with the people behind the podcast in order to learn how they create, share, and think about podcasting. This week, we talk with Mary Baird-Wilcock the host of The Simplifiers Podcast.
What is The Simplifiers Podcast about?
We take topics in business and in life… and SIMPLIFY them!
Our listeners currently tuning in from 75 countries around the world are primarily female small business owners, founders, freelancers and solopreneurs in creative industries, especially wedding/event planners, photographers, other coaches, marketers and more.
How long have you been podcasting?
What do you do to share & promote your episodes?
In everything we do, we treat this podcast as a business, releasing episodes consistently every Tuesday and Friday with military precision.
What has been most effective? Least effective?
We also make Headliner videos to promote our long form Tuesday interviews on InstaStories, typically breaking it up in to 4x :15 mini videos to create a 4-part story on Instagram.
In addition, we create a Headliner video, complete with the soundwave effect for our friday bonus episodes and publish this to @TheSimplifiers YouTube channel. That way, we are diversifying how and where people can consume our podcast content… not just on all the podcast players, but on YouTube as well.
We are finding that putting these Headliner videos on IG and Instastories, plus our longer Headliner videos on YouTube are super effective for catching people's eyes and peaking their interest to click through and listen to the full episode.
Why do you make audiograms?
They are dynamic, visually appealing to the eye and super simple to create within the Headliner app. My Show Notes Editor creates these currently for our podcast and she's found the platform to be super intuitive to create dynamic videos, fairly quickly each and every week.
For gear… Current podcasting setup?
How has your gear changed since you started?
Started with the Focusrite 18i8… downsized to 2i2.
What is something you think is overrated or underrated in podcasting?
If someone was to only listen to one episode of yours, which one would you send?
As a content creator, I feel like you're only as good as your last episode you've released. Therefore, I'd recommend having a listen to my most recent conversation with Arlene Pellicane (episode 57) where we simplified how to better manage screen time with your kids.
What's working for you right now when you pitch yourself to be on other podcasts, to be THEIR special guest to interview?


text:
Maersk Oil Qatar Signs QR 770 Million Drilling Contract with Gulf Drilling International
HomeMaersk Oil Qatar Signs QR 770 Million Drilling Contract with Gulf Drilling International
DOHA, QATAR - Maersk Oil Qatar and Gulf Drilling International (GDI) have signed a four (4) year agreement for 770 Million Qatari Riyal under which Maersk Oil Qatar will contract Al Jassra, GDI's new-build jack-up drilling rig. The contract covers drilling and well work-over activity in the Al Shaheen field, Qatar's largest offshore oil field. The agreement was signed by Maersk Oil Qatar's Managing Director, Mr. Lewis Affleck, and GDI's Chief Executive Officer, Mr. Ibrahim J. Al-Othman.
Mr. Lewis Affleck, Maersk Oil Qatar's Managing Director said: "By working closely with our partner,Qatar Petroleum, Maersk Oil has started to unlock the significant potential of the Al Shaheen oil field. We have already drilled in excess of 300 wells, and we expect to drill many more in the years ahead to optimise recovery from this giant offshore oil field. We are very pleased that a Qatari company is able to provide the world-class drilling support that we currently require – and we very much look forward to working with GDI."
The Al Jassra will be one of the drilling rigs used to deliver Maersk Oil's latest field development plan, FDP 2012, which was agreed in November 2012 and calls for the drilling of 51 new wells in the Al Shaheen oil field.
Mr Ibrahim J. Al-Othman, GDI's Chief Executive Officer said: "Today's signing signifies an important milestone for GDI. The Al Shaheen field is Qatar's largest offshore oil field, and we are very proud to provide an essential role in the field's future development. Both companies have worked tirelessly to ensure that a credible, economic and sustainable drilling rig solution is delivered. Maersk have been instrumental in providing valuable input into the development of the specifications, design preferences and features of this new rig. In the process, we have cultivated an excellent working relationship that is focused on mutually beneficial results. We are pleased that Maersk Oil is committed to using the services of local Qatari companies and to supporting the country's national vision of building local capacities and developing Qatari skills and competencies."
The state-of-the-art Al Jassra rig is a Pacific Class 400 jack-up drilling rig. The rig will come with a 75' cantilever outreach and provide accommodation for 150 persons. It will provide the capacity and ability to drill the extended reach wells that are needed to access the long thin reservoirs of the Al Shaheen field.
The Al Jassra rig is currently under construction at PPL shipyard in Singapore. Following commissioning and dry tow, the rig is expected to arrive in Qatar mid-year, 2013. Both Maersk Oil Qatar and GDI teams are energetically working to ensure that the rig enters operation safely and efficiently. Early teamwork in ensuring the success of this objective is further proof of the partnership that both companies are so proud of.


Elenco Turbo King Elenco Remote Control Car Kit! FUN875 R/C cars are the hottest thing going, and you can build your own from the ground up. You'll learn all about gears, motors, RF frequency and more from our detailed assembly and training manual. Before you know it, you'll be ready to race! CONFIRMED LOWEST PRICE!
Elenco Turbo King Elenco Remote Control Car Kit! FUN875. R/C cars are the hottest thing going, and you can build your own from the ground up. You'll learn all about gears, motors, RF frequency and more from our detailed assembly and training manual. Before you know it, you'll be ready to race! FUN-875, FUN875, AK-870, AK870, Elenco Remote Control Car Kit.
Remote control requires 9 volt battery (not included).
Car requires 4 AA batteries (not included).


text:
The Harriet Irving Botanical Gardens (HIBG) are located in Wolfville, Nova Scotia, Canada, on the Acadia University campus. The HIBG is a popular tourist destination in the Annapolis Valley. The garden consists of nine native habitats of the Acadian Forest Region, a Medicinal and Food Garden, Conservatory, Formal Walled Garden, and Experimental Garden. The HIBG is also the trail head for 1.5 km of woodland trails. The Harriet Irving Botanical Garden is connected to the K.C Irving Environmental Centre (KCIC) with laboratories, greenhouses, and controlled environmental facilities. The HIBG and K.C Irving centre run educational and recreational programs for the public, hold seminars on various topics  and facilitate conferences and meetings. The staff of the HIBG act as coordinators for PlantWatch, a national program which encourages youth and members of the community to report the blooming times of selected plants to help track global warming and other ecological activities.

History
The HIBG and KCIC were given to Acadia University by the Irving family on September 14, 2002. The Harriet Irving Botanical Gardens are named after Kenneth Colin Irving's wife, Harriet Irving. The gardens were designed by architect Alex Novell and construction began in the fall of 1999. It was the intention of the Irving family to create a space that would be conducive to the interaction of ideas from students, faculty, and the community. The emblem of the gardens features a mayflower; the official flower of Nova Scotia, as well as Harriet Irving's favorite flower, a honey bee representing hard work, and the scotch thistle symbolizing Scotland from where the Irving family originated, as well as the country Nova Scotia is named after. The gates of the HIBG opened on September 14, 2002, and the garden open to the public free of admission due to the K.C Irving Environmental Trust. The funding of the HIBG is provided by the K.C. Irving Environmental Trust as well as donors ranging from individual students to some of Canada's largest corporations.

Attractions
The Harriet Irving Botanical Gardens consists of six acres divided into nine unique habitats of the Acadian Forest Region. The native plants are labelled with their botanical name and common name. Like all botanical gardens, the HIBG maintains a collection consisting of native plants to the Acadian Forest for conservational, educational, and scientific reasons. The HIBG have three living specimens of endangered species that are protected under the Nova Scotia Endangered Species Act. The Pink coreopsis (Coreopsis rosea), Water-pennywort (Hydrocotyle umbellata), and Thread-leaved Sundew (Drosera filiformis) are all on display at the gardens to help educate future generations on the importance of environmental conservation and facilitate further research into the conservation of these species.

As visitors travel through the gardens they pass through a walled garden, experimental garden, medicinal garden, deciduous woodland, freshwater inland marsh, bog, coastal headlands, mixed woodlands, calcareous woodlands, wet woodlands, sand barrens, coniferous woodland, and finish in the conservatory which leads to the KCIC. The arrangement of the habitats allows for explorers of the garden to experience the natural habitats of the Acadian Forest without the lengthy travel to different locations around the province. An article in the local paper, The Grapevine  gives descriptions of interesting events and updates to the gardens regularly.

Each spring the volunteers of the HIBG hold a native plant sale to encourage the integration of native plants into gardens. Seeds are collected from the plant materials in the garden, propagated and sold each year to support the volunteer group and conservations efforts.

Walled Garden
The tall iron gates lead into this garden which is designed as a typical English garden with the exception of utilizing all native plants to the Acadian forest. The plants are pruned to conform to the symmetrical aspects of the traditional English garden style. Ten foot brick walls surround the garden on the West and South side creating a microclimate that provides an early spring. This garden complements the formal Georgian-style architecture of the K.C. Irving Environmental Science Centre with the picturesque landscape of the Acadian Forest Region. Harriet Irving's favorite flower can be seen in bloom in late April in the bordering flower beds.

Experimental Garden
There are several sunken plant beds with eight different representative soil types which host many research projects. This garden allows for plants to be kept on a long term basis, and be exposed to the seasonal changes of the Maritime climate. Plants are stored here before being planted into the gardens, or utilized is research and conservation projects.

Medicinal Garden
In this area a collection of plants used by indigenous peoples and early European settlers can be viewed. This is the only area of the garden which displays non-indigenous species to the Acadian Forest Region. However, many of these plants escaped early homesteads and have become naturalized in the region. A white cedar hedge surrounds the garden, and two rows of linden trees create a pleached hedge along the pathway. Interpretive signs are displayed throughout the garden explaining the early uses of the medicinal and food plants displayed.

Deciduous Woodlands
The deciduous woodlands are characterized by broad-leaved hardwood trees and associated shade-tolerant plants. The soil is rich in organic matter and neutral in pH. Ferns are predominant in the understory and the ostrich fern can be found providing fiddle heads in the spring. Deciduous woodlands are home to a variety of insects and fauna.

Bog
An artificial bog has been created to demonstrate a mossy, peat-covered wetland. Plants such as the Pitcher plant, can be witnessed growing in this area of the HIBG. Plants that thrive in bogs are adapted to nutrient poor, acidic soil. "Other plants include bog laurel, leatherleaf, white-fringed orchid, rose pogonia, grass-pink, bog huckleberry, dragon's-mouth, as well as bunchberry, goldthread, starflowers, reindeer moss, beak-rush, liverwort, bulrush, lichens, chokecherry, sedges and cottongrass".

Freshwater Inland Marsh
In this area of the garden is a man-made pond which is host to many of the native species of plants including cattails, water-lilies, and arrowheads. Freshwater Inland Marshes are important ecosystems for water fowl.

Coastal Headlands
Across from the freshwater inland marsh, are the coastal headlands which represent one of the most unique habitats of the Acadian Forest Region, and are in danger of disappearing due to the development of coastal areas. Plants growing in this area have little to no soil, and are exposed to salt spray from the Atlantic Ocean. From the oval lawn which divides the coastal headlands and freshwater inland marsh, an herbaceous bank can be admired which is decorated with native plants that provide colorful blossoms through the spring, summer and fall seasons. These plants are a representation of plants that can be integrated into home gardens to provide native pollinators a good source of nectar and habitat. Examples of such plants include Turtlehead (Chelone glabra), Joe-Pye Weed (Eupatorium maculatum), and Brown Eyed-Susans (Rudbeckia hirta).

Mixed Woodlands
This habitat consists of both coniferous and deciduous trees, and defines the Acadian Forest Region.

Calcareous Woodlands
An alkaline, gypsum-based soil characterizes this habitat and are often lush in growth with many native orchids to the Acadian Forest Region.

Wet Woodlands
A wide variety of plants and animals call areas with high water tables home. This forest is associated with the later succession stages of marshes and have been drastically reduced in the Acadian Forest Region due to development and urbanization of forested areas.

Sand Barrens
This habitat was created by receding glaciers during the last Ice Age and includes stretches of windblown sand and silt deposits. It is dominated by low shrub species, and a few stunted tree species.

Coniferous Woodlands
The final habitat demonstrated at the HIBG is composed of needle-bearing trees. Coniferous woodlands are dark due to the dense canopy. This habitat is home to many mushrooms and other important decomposers in the food chain.

K.C Irving Environmental Centre
The centre provides a space for students, researchers, and faculty to conduct studies in ecology and conservation. In the basement of the centre the E.C Smith Herbarium can be found. The herbarium contributes to research and conservation of native plants by providing information relating to geographic distribution, flowering and fruiting dates, habitat preferences and other information related to botanical research. A seed and tissue bank for native plants of the Acadian Forest Region is also being developed in the centre for the preservation of biodiversity and propagation of threatened species.

References

Botanical gardens in Canada

redpajama_set_name: RedPajamaWikipedia


text:
Augustan (335)
Restoration (113)
Seventeenth Century (10)
Prose (226)
African or Afro-British (4)
West Indian (1)
Whig (147)
From Whig to Tory (53)
From Tory to Whig (45)
Opposition (Later Pro-Pelhamite) (20)
Opposition Whig (19)
Opposition Patriot (13)
Jacobite (11)
Whiggish (10)
Anglican with Enthusiastic or Evangelical Tendencies (49)
Deist or Theist (41)
Church of Scotland (32)
Latitudinarian (23)
Anglican (High Church) (17)
Cambridge Platonist (12)
Methodist (10)
Your search for Metaphor Category: "Population" AND Literary Period: "Eighteenth Century" AND Gender of Author: "Male" returned 654 results(s) in 0.146 seconds
page 60 of 66 per page: 1025100
"The tops of these scarce veil'd the roots of those; / A winding court where wandering fancy walk'd / And to herself responsive Echo talk'd."
— Brooke, Henry (c. 1703-1783)
"But though man has, in this manner, been rendered the immediate judge of mankind, he has been rendered so only in the first instance; and an appeal lies from his sentence to a much higher tribunal, to the tribunal of their own consciences, to that of the supposed impartial and well-informed spec...
— Smith, Adam (1723-1790)
"The jurisdiction of the man without is founded altogether in the desire of actual praise, and in the aversion to actual blame. The jurisdiction of the man within is founded altogether in the desire of praiseworthiness, and in the aversion to blameworthiness; in the desire of possessing those qua...
"In such cases, this demigod within the breast appears, like the demigods of the poets, though partly of immortal, yet partly too of mortal extraction. When his judgments are steadily and firmly directed by the sense of praiseworthiness and blameworthiness, he seems to act suitably to his divine ...
"But though the approbation of his own conscience can scarce, upon some extraordinary occasions, content the weakness of man; though the testimony of the supposed impartial spectator of the great inmate of the breast cannot always alone support him; yet the influence and authority of this princip...
"The man within immediately calls to us, that we value ourselves too much and other people too little, and that, by doing so, we render ourselves the proper object of the contempt and indignation of our brethren."
"The man within immediately calls to him, in this case too, that he is no better than his neighbour, and that by this unjust preference he renders himself the proper object of the contempt and indignation of mankind; as well as of the punishment which that contempt and indignation must naturally ...
"He has never dared to suffer the man within the breast to be absent one moment from his attention."
"With the eyes of this great inmate he has always been accustomed to regard whatever relates to himself."
"Misery and wretchedness can never enter the breast in which dwells complete self-satisfaction; and though it may be too much, perhaps, to say, with the Stoics, that, under such an accident as that above mentioned, the happiness of a wise man is in every respect equal to what it could have been u...
« Previous 1 2 … 56 57 58 59 60 61 62 63 64 65 66 Next »


HCN channelopathies: pathophysiology in genetic epilepsy and therapeutic implications.
Hyperpolarization-activated cyclic nucleotide-gated channels (HCN) can act as pacemakers in the brain making them strong candidates for driving aberrant hypersynchronous network activity seen in epilepsy. Transcriptional changes in HCN channels occur in several animal models of epilepsy. However, only recently have genetic studies demonstrated sequence variation in HCN1 and HCN2 genes associated with human epilepsy. These include a triple proline deletion in HCN2 that increases channel function and occurs more often in patients with febrile seizure syndromes. Other HCNx gene variants have been described in idiopathic generalized epilepsy although the functional consequence of these remains unclear. In this review we explore potential cellular and network mechanisms involving HCN channels in the genetic epilepsies. We suggest how new genetic sequencing technology, medium-throughput functional assays and the ability to develop syndrome-specific animal models will provide a more comprehensive understanding of how I(h) contributes to pathogenic mechanisms underlying human genetic epilepsy. We also discuss what is known about the pharmacological manipulation of HCN channels in the context of epilepsy and how this may help future efforts in developing HCN-channel-based therapy.


Several people were trapped under Solis' vehicle after it crashed into a tree. Police officers and people nearby helped free those stuck underneath the vehicle and performed "life-saving measures" before Fullerton firefighters arrived on the scene.
The victims, who were between 18 and 49 years old, were taken to the hospital with injuries that were moderate to critical life-threatening. Ten people were taken to the hospital, although it's unclear if Solis was one of them.
Three other vehicles were also damaged in the incident.
Police are investigating and seeking video capturing the incident.


text:
CATEGORY : Pro Evolution Soccer 2009 | Stadiums
Stadium Sant ' Elia - Italy
AUTHOR Forzaroma | August 31 2009 | 3004 hits
Stadio Comunale Sant'Elia is a football stadium in Cagliari, Italy. It is currently the home of Cagliari Calcio. The stadium has a capacity of 23,486. It hosted three matches in the 1990 FIFA World Cup. Its construction began in 1970, following Cagliari Calcio's first and so far only Scudetto, thus taking the place of the old Amsicora Stadium. The stadium could accommodate up to about 60,000 spectators
Bmp new banners,Paper flying,adboards TIM
photographers and assistants.,light effects
shadows in the stadium,complete reconstruction mesh public,
restructuring shares stadium
optimization and 3d base by Forzaroma
overwrite Estadio do Dragao
Forzaroma
Mirrors Available
Pro Evolution Soccer 2009 is the latest update to the award-winning football series, with new additions, smarter AI, and better graphics. Exclusive rights to the UEFA Champions League allows you to play as and against your favorite players and teams. PES 2009 has been released for PLAYSTATION 3, Xbox 360, PC-DVD, PlayStation 2 and PlayStation Portable.
Konami has announced that they have obtained the rights to the UEFA Champions League for the next four years. Konami secured the exclusive rights to the UEFA Champions League for Pro Evolution Soccer 2009. Manchester United and Liverpool will be the licensed English clubs in PES 2009. Since the UEFA Champions League license does not include the rights to all the participating clubs and a number of licenses are held exclusively by EA Sports, not all Champions League clubs will be licensed in the game.
The following leagues are fully licensed:
- Ligue 1
- Eredivisie
The following leagues are partially licensed:
- Barclays Premier League (Manchester United and Liverpool)
- Liga BBVA (Barcelona, Real Madrid, Atletico Madrid, Villarreal, Sevilla and others)
- Serie A (All clubs licensed - Juventus, AC Milan, Inter Milan, Roma, Lazio, etc, but the logo and name of the league are unlicensed)
- Unlicensed clubs have real player names but use fake club names, badges, and kits.These can be edited by the user.
- However, only the top tiers of Spanish, English, French, Dutch, and Italian leagues are available in game.
Download Stadium Sant ' Elia - Italy. This is a mod for Pro Evolution Soccer 2009 video game.


text:
-- MySQL dump 10.13  Distrib 5.5.25, for osx10.6 (i386)
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	5.5.25

/*!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 `BUCKETING_COLS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `BUCKETING_COLS` (
  `SD_ID` bigint(20) NOT NULL,
  `BUCKET_COL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`SD_ID`,`INTEGER_IDX`),
  KEY `BUCKETING_COLS_N49` (`SD_ID`),
  CONSTRAINT `BUCKETING_COLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CDS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `CDS` (
  `CD_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`CD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `COLUMNS_V2`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `COLUMNS_V2` (
  `CD_ID` bigint(20) NOT NULL,
  `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `TYPE_NAME` varchar(4000) DEFAULT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`CD_ID`,`COLUMN_NAME`),
  KEY `COLUMNS_V2_N49` (`CD_ID`),
  CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DATABASE_PARAMS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `DATABASE_PARAMS` (
  `DB_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`DB_ID`,`PARAM_KEY`),
  KEY `DATABASE_PARAMS_N49` (`DB_ID`),
  CONSTRAINT `DATABASE_PARAMS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DBS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `DBS` (
  `DB_ID` bigint(20) NOT NULL,
  `DESC` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `DB_LOCATION_URI` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `OWNER_TYPE` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`DB_ID`),
  UNIQUE KEY `UNIQUE_DATABASE` (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DB_PRIVS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `DB_PRIVS` (
  `DB_GRANT_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `DB_ID` bigint(20) DEFAULT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `DB_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`DB_GRANT_ID`),
  UNIQUE KEY `DBPRIVILEGEINDEX` (`DB_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`DB_PRIV`,`GRANTOR`,`GRANTOR_TYPE`),
  KEY `DB_PRIVS_N49` (`DB_ID`),
  CONSTRAINT `DB_PRIVS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `GLOBAL_PRIVS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `GLOBAL_PRIVS` (
  `USER_GRANT_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `USER_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`USER_GRANT_ID`),
  UNIQUE KEY `GLOBALPRIVILEGEINDEX` (`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`USER_PRIV`,`GRANTOR`,`GRANTOR_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `IDXS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `IDXS` (
  `INDEX_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `DEFERRED_REBUILD` bit(1) NOT NULL,
  `INDEX_HANDLER_CLASS` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `INDEX_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `INDEX_TBL_ID` bigint(20) DEFAULT NULL,
  `LAST_ACCESS_TIME` int(11) NOT NULL,
  `ORIG_TBL_ID` bigint(20) DEFAULT NULL,
  `SD_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`INDEX_ID`),
  UNIQUE KEY `UNIQUEINDEX` (`INDEX_NAME`,`ORIG_TBL_ID`),
  KEY `IDXS_N51` (`SD_ID`),
  KEY `IDXS_N50` (`INDEX_TBL_ID`),
  KEY `IDXS_N49` (`ORIG_TBL_ID`),
  CONSTRAINT `IDXS_FK1` FOREIGN KEY (`ORIG_TBL_ID`) REFERENCES `TBLS` (`TBL_ID`),
  CONSTRAINT `IDXS_FK2` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`),
  CONSTRAINT `IDXS_FK3` FOREIGN KEY (`INDEX_TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `INDEX_PARAMS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `INDEX_PARAMS` (
  `INDEX_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`INDEX_ID`,`PARAM_KEY`),
  KEY `INDEX_PARAMS_N49` (`INDEX_ID`),
  CONSTRAINT `INDEX_PARAMS_FK1` FOREIGN KEY (`INDEX_ID`) REFERENCES `IDXS` (`INDEX_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `NUCLEUS_TABLES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `NUCLEUS_TABLES` (
  `CLASS_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `TYPE` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `OWNER` varchar(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `VERSION` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `INTERFACE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`CLASS_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PARTITIONS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PARTITIONS` (
  `PART_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `LAST_ACCESS_TIME` int(11) NOT NULL,
  `PART_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `SD_ID` bigint(20) DEFAULT NULL,
  `TBL_ID` bigint(20) DEFAULT NULL,
  `LINK_TARGET_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`PART_ID`),
  UNIQUE KEY `UNIQUEPARTITION` (`PART_NAME`,`TBL_ID`),
  KEY `PARTITIONS_N49` (`TBL_ID`),
  KEY `PARTITIONS_N50` (`SD_ID`),
  KEY `PARTITIONS_N51` (`LINK_TARGET_ID`),
  CONSTRAINT `PARTITIONS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`),
  CONSTRAINT `PARTITIONS_FK2` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`),
  CONSTRAINT `PARTITIONS_FK3` FOREIGN KEY (`LINK_TARGET_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PARTITION_EVENTS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PARTITION_EVENTS` (
  `PART_NAME_ID` bigint(20) NOT NULL,
  `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `EVENT_TIME` bigint(20) NOT NULL,
  `EVENT_TYPE` int(11) NOT NULL,
  `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TBL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`PART_NAME_ID`),
  KEY `PARTITIONEVENTINDEX` (`PARTITION_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PARTITION_KEYS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PARTITION_KEYS` (
  `TBL_ID` bigint(20) NOT NULL,
  `PKEY_COMMENT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PKEY_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PKEY_TYPE` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`TBL_ID`,`PKEY_NAME`),
  KEY `PARTITION_KEYS_N49` (`TBL_ID`),
  CONSTRAINT `PARTITION_KEYS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PARTITION_KEY_VALS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PARTITION_KEY_VALS` (
  `PART_ID` bigint(20) NOT NULL,
  `PART_KEY_VAL` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`PART_ID`,`INTEGER_IDX`),
  KEY `PARTITION_KEY_VALS_N49` (`PART_ID`),
  CONSTRAINT `PARTITION_KEY_VALS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PARTITION_PARAMS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PARTITION_PARAMS` (
  `PART_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`PART_ID`,`PARAM_KEY`),
  KEY `PARTITION_PARAMS_N49` (`PART_ID`),
  CONSTRAINT `PARTITION_PARAMS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PART_COL_PRIVS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PART_COL_PRIVS` (
  `PART_COLUMN_GRANT_ID` bigint(20) NOT NULL,
  `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PART_ID` bigint(20) DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PART_COL_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`PART_COLUMN_GRANT_ID`),
  KEY `PART_COL_PRIVS_N49` (`PART_ID`),
  KEY `PARTITIONCOLUMNPRIVILEGEINDEX` (`PART_ID`,`COLUMN_NAME`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`PART_COL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`),
  CONSTRAINT `PART_COL_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PART_PRIVS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `PART_PRIVS` (
  `PART_GRANT_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PART_ID` bigint(20) DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PART_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`PART_GRANT_ID`),
  KEY `PARTPRIVILEGEINDEX` (`PART_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`PART_PRIV`,`GRANTOR`,`GRANTOR_TYPE`),
  KEY `PART_PRIVS_N49` (`PART_ID`),
  CONSTRAINT `PART_PRIVS_FK1` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ROLES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `ROLES` (
  `ROLE_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `ROLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`ROLE_ID`),
  UNIQUE KEY `ROLEENTITYINDEX` (`ROLE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ROLE_MAP`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `ROLE_MAP` (
  `ROLE_GRANT_ID` bigint(20) NOT NULL,
  `ADD_TIME` int(11) NOT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `ROLE_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ROLE_GRANT_ID`),
  UNIQUE KEY `USERROLEMAPINDEX` (`PRINCIPAL_NAME`,`ROLE_ID`,`GRANTOR`,`GRANTOR_TYPE`),
  KEY `ROLE_MAP_N49` (`ROLE_ID`),
  CONSTRAINT `ROLE_MAP_FK1` FOREIGN KEY (`ROLE_ID`) REFERENCES `ROLES` (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SDS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SDS` (
  `SD_ID` bigint(20) NOT NULL,
  `CD_ID` bigint(20) DEFAULT NULL,
  `INPUT_FORMAT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `IS_COMPRESSED` bit(1) NOT NULL,
  `IS_STOREDASSUBDIRECTORIES` bit(1) NOT NULL,
  `LOCATION` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `NUM_BUCKETS` int(11) NOT NULL,
  `OUTPUT_FORMAT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `SERDE_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`SD_ID`),
  KEY `SDS_N49` (`SERDE_ID`),
  KEY `SDS_N50` (`CD_ID`),
  CONSTRAINT `SDS_FK1` FOREIGN KEY (`SERDE_ID`) REFERENCES `SERDES` (`SERDE_ID`),
  CONSTRAINT `SDS_FK2` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SD_PARAMS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SD_PARAMS` (
  `SD_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`SD_ID`,`PARAM_KEY`),
  KEY `SD_PARAMS_N49` (`SD_ID`),
  CONSTRAINT `SD_PARAMS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SEQUENCE_TABLE`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SEQUENCE_TABLE` (
  `SEQUENCE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `NEXT_VAL` bigint(20) NOT NULL,
  PRIMARY KEY (`SEQUENCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SERDES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SERDES` (
  `SERDE_ID` bigint(20) NOT NULL,
  `NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `SLIB` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`SERDE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SERDE_PARAMS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SERDE_PARAMS` (
  `SERDE_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`SERDE_ID`,`PARAM_KEY`),
  KEY `SERDE_PARAMS_N49` (`SERDE_ID`),
  CONSTRAINT `SERDE_PARAMS_FK1` FOREIGN KEY (`SERDE_ID`) REFERENCES `SERDES` (`SERDE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SKEWED_COL_NAMES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SKEWED_COL_NAMES` (
  `SD_ID` bigint(20) NOT NULL,
  `SKEWED_COL_NAME` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`SD_ID`,`INTEGER_IDX`),
  KEY `SKEWED_COL_NAMES_N49` (`SD_ID`),
  CONSTRAINT `SKEWED_COL_NAMES_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SKEWED_COL_VALUE_LOC_MAP`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SKEWED_COL_VALUE_LOC_MAP` (
  `SD_ID` bigint(20) NOT NULL,
  `STRING_LIST_ID_KID` bigint(20) NOT NULL,
  `LOCATION` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`SD_ID`,`STRING_LIST_ID_KID`),
  KEY `SKEWED_COL_VALUE_LOC_MAP_N49` (`STRING_LIST_ID_KID`),
  KEY `SKEWED_COL_VALUE_LOC_MAP_N50` (`SD_ID`),
  CONSTRAINT `SKEWED_COL_VALUE_LOC_MAP_FK2` FOREIGN KEY (`STRING_LIST_ID_KID`) REFERENCES `SKEWED_STRING_LIST` (`STRING_LIST_ID`),
  CONSTRAINT `SKEWED_COL_VALUE_LOC_MAP_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SKEWED_STRING_LIST`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SKEWED_STRING_LIST` (
  `STRING_LIST_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`STRING_LIST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SKEWED_STRING_LIST_VALUES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SKEWED_STRING_LIST_VALUES` (
  `STRING_LIST_ID` bigint(20) NOT NULL,
  `STRING_LIST_VALUE` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`STRING_LIST_ID`,`INTEGER_IDX`),
  KEY `SKEWED_STRING_LIST_VALUES_N49` (`STRING_LIST_ID`),
  CONSTRAINT `SKEWED_STRING_LIST_VALUES_FK1` FOREIGN KEY (`STRING_LIST_ID`) REFERENCES `SKEWED_STRING_LIST` (`STRING_LIST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SKEWED_VALUES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SKEWED_VALUES` (
  `SD_ID_OID` bigint(20) NOT NULL,
  `STRING_LIST_ID_EID` bigint(20) NOT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`SD_ID_OID`,`INTEGER_IDX`),
  KEY `SKEWED_VALUES_N50` (`SD_ID_OID`),
  KEY `SKEWED_VALUES_N49` (`STRING_LIST_ID_EID`),
  CONSTRAINT `SKEWED_VALUES_FK2` FOREIGN KEY (`STRING_LIST_ID_EID`) REFERENCES `SKEWED_STRING_LIST` (`STRING_LIST_ID`),
  CONSTRAINT `SKEWED_VALUES_FK1` FOREIGN KEY (`SD_ID_OID`) REFERENCES `SDS` (`SD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SORT_COLS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `SORT_COLS` (
  `SD_ID` bigint(20) NOT NULL,
  `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `ORDER` int(11) NOT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`SD_ID`,`INTEGER_IDX`),
  KEY `SORT_COLS_N49` (`SD_ID`),
  CONSTRAINT `SORT_COLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TABLE_PARAMS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `TABLE_PARAMS` (
  `TBL_ID` bigint(20) NOT NULL,
  `PARAM_KEY` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`TBL_ID`,`PARAM_KEY`),
  KEY `TABLE_PARAMS_N49` (`TBL_ID`),
  CONSTRAINT `TABLE_PARAMS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TBLS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `TBLS` (
  `TBL_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `DB_ID` bigint(20) DEFAULT NULL,
  `LAST_ACCESS_TIME` int(11) NOT NULL,
  `OWNER` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `RETENTION` int(11) NOT NULL,
  `SD_ID` bigint(20) DEFAULT NULL,
  `TBL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TBL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `VIEW_EXPANDED_TEXT` mediumtext,
  `VIEW_ORIGINAL_TEXT` mediumtext,
  `LINK_TARGET_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`TBL_ID`),
  UNIQUE KEY `UNIQUETABLE` (`TBL_NAME`,`DB_ID`),
  KEY `TBLS_N50` (`SD_ID`),
  KEY `TBLS_N49` (`DB_ID`),
  KEY `TBLS_N51` (`LINK_TARGET_ID`),
  CONSTRAINT `TBLS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`),
  CONSTRAINT `TBLS_FK2` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`),
  CONSTRAINT `TBLS_FK3` FOREIGN KEY (`LINK_TARGET_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TBL_COL_PRIVS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `TBL_COL_PRIVS` (
  `TBL_COLUMN_GRANT_ID` bigint(20) NOT NULL,
  `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TBL_COL_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TBL_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`TBL_COLUMN_GRANT_ID`),
  KEY `TABLECOLUMNPRIVILEGEINDEX` (`TBL_ID`,`COLUMN_NAME`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`TBL_COL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`),
  KEY `TBL_COL_PRIVS_N49` (`TBL_ID`),
  CONSTRAINT `TBL_COL_PRIVS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TBL_PRIVS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `TBL_PRIVS` (
  `TBL_GRANT_ID` bigint(20) NOT NULL,
  `CREATE_TIME` int(11) NOT NULL,
  `GRANT_OPTION` smallint(6) NOT NULL,
  `GRANTOR` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `GRANTOR_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `PRINCIPAL_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TBL_PRIV` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TBL_ID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`TBL_GRANT_ID`),
  KEY `TBL_PRIVS_N49` (`TBL_ID`),
  KEY `TABLEPRIVILEGEINDEX` (`TBL_ID`,`PRINCIPAL_NAME`,`PRINCIPAL_TYPE`,`TBL_PRIV`,`GRANTOR`,`GRANTOR_TYPE`),
  CONSTRAINT `TBL_PRIVS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TAB_COL_STATS`
--
CREATE TABLE IF NOT EXISTS `TAB_COL_STATS` (
 `CS_ID` bigint(20) NOT NULL,
 `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `TBL_ID` bigint(20) NOT NULL,
 `LONG_LOW_VALUE` bigint(20),
 `LONG_HIGH_VALUE` bigint(20),
 `DOUBLE_HIGH_VALUE` double(53,4),
 `DOUBLE_LOW_VALUE` double(53,4),
 `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `NUM_NULLS` bigint(20) NOT NULL,
 `NUM_DISTINCTS` bigint(20),
 `AVG_COL_LEN` double(53,4),
 `MAX_COL_LEN` bigint(20),
 `NUM_TRUES` bigint(20),
 `NUM_FALSES` bigint(20),
 `LAST_ANALYZED` bigint(20) NOT NULL,
  PRIMARY KEY (`CS_ID`),
  CONSTRAINT `TAB_COL_STATS_FK` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `PART_COL_STATS`
--
CREATE TABLE IF NOT EXISTS `PART_COL_STATS` (
 `CS_ID` bigint(20) NOT NULL,
 `DB_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 `PART_ID` bigint(20) NOT NULL,
 `LONG_LOW_VALUE` bigint(20),
 `LONG_HIGH_VALUE` bigint(20),
 `DOUBLE_HIGH_VALUE` double(53,4),
 `DOUBLE_LOW_VALUE` double(53,4),
 `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin,
 `NUM_NULLS` bigint(20) NOT NULL,
 `NUM_DISTINCTS` bigint(20),
 `AVG_COL_LEN` double(53,4),
 `MAX_COL_LEN` bigint(20),
 `NUM_TRUES` bigint(20),
 `NUM_FALSES` bigint(20),
 `LAST_ANALYZED` bigint(20) NOT NULL,
  PRIMARY KEY (`CS_ID`),
  CONSTRAINT `PART_COL_STATS_FK` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE INDEX PCS_STATS_IDX ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME,PARTITION_NAME);

--
-- Table structure for table `TYPES`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `TYPES` (
  `TYPES_ID` bigint(20) NOT NULL,
  `TYPE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TYPE1` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `TYPE2` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  PRIMARY KEY (`TYPES_ID`),
  UNIQUE KEY `UNIQUE_TYPE` (`TYPE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TYPE_FIELDS`
--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `TYPE_FIELDS` (
  `TYPE_NAME` bigint(20) NOT NULL,
  `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `FIELD_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `FIELD_TYPE` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `INTEGER_IDX` int(11) NOT NULL,
  PRIMARY KEY (`TYPE_NAME`,`FIELD_NAME`),
  KEY `TYPE_FIELDS_N49` (`TYPE_NAME`),
  CONSTRAINT `TYPE_FIELDS_FK1` FOREIGN KEY (`TYPE_NAME`) REFERENCES `TYPES` (`TYPES_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Table `MASTER_KEYS` for classes [org.apache.hadoop.hive.metastore.model.MMasterKey]
CREATE TABLE IF NOT EXISTS `MASTER_KEYS`
(
    `KEY_ID` INTEGER NOT NULL AUTO_INCREMENT,
    `MASTER_KEY` VARCHAR(767) BINARY NULL,
    PRIMARY KEY (`KEY_ID`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;

-- Table `DELEGATION_TOKENS` for classes [org.apache.hadoop.hive.metastore.model.MDelegationToken]
CREATE TABLE IF NOT EXISTS `DELEGATION_TOKENS`
(
    `TOKEN_IDENT` VARCHAR(767) BINARY NOT NULL,
    `TOKEN` VARCHAR(767) BINARY NULL,
    PRIMARY KEY (`TOKEN_IDENT`)
) ENGINE=INNODB DEFAULT CHARSET=latin1;

--
-- Table structure for VERSION
--
CREATE TABLE IF NOT EXISTS `VERSION` (
  `VER_ID` BIGINT NOT NULL,
  `SCHEMA_VERSION` VARCHAR(127) NOT NULL,
  `VERSION_COMMENT` VARCHAR(255),
  PRIMARY KEY (`VER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table FUNCS
--
CREATE TABLE IF NOT EXISTS `FUNCS` (
  `FUNC_ID` BIGINT(20) NOT NULL,
  `CLASS_NAME` VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_bin,
  `CREATE_TIME` INT(11) NOT NULL,
  `DB_ID` BIGINT(20),
  `FUNC_NAME` VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin,
  `FUNC_TYPE` INT(11) NOT NULL,
  `OWNER_NAME` VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin,
  `OWNER_TYPE` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_bin,
  PRIMARY KEY (`FUNC_ID`),
  UNIQUE KEY `UNIQUEFUNCTION` (`FUNC_NAME`, `DB_ID`),
  KEY `FUNCS_N49` (`DB_ID`),
  CONSTRAINT `FUNCS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table FUNC_RU
--
CREATE TABLE IF NOT EXISTS `FUNC_RU` (
  `FUNC_ID` BIGINT(20) NOT NULL,
  `RESOURCE_TYPE` INT(11) NOT NULL,
  `RESOURCE_URI` VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_bin,
  `INTEGER_IDX` INT(11) NOT NULL,
  PRIMARY KEY (`FUNC_ID`, `INTEGER_IDX`),
  CONSTRAINT `FUNC_RU_FK1` FOREIGN KEY (`FUNC_ID`) REFERENCES `FUNCS` (`FUNC_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Transaction and Lock Tables
-- These are not part of package jdo, so if you are going to regenerate this file you need to manually add the following section back to the file.
-- ----------------------------
CREATE TABLE TXNS (
  TXN_ID bigint PRIMARY KEY,
  TXN_STATE char(1) NOT NULL,
  TXN_STARTED bigint NOT NULL,
  TXN_LAST_HEARTBEAT bigint NOT NULL,
  TXN_USER varchar(128) NOT NULL,
  TXN_HOST varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE TXN_COMPONENTS (
  TC_TXNID bigint,
  TC_DATABASE varchar(128) NOT NULL,
  TC_TABLE varchar(128),
  TC_PARTITION varchar(767),
  FOREIGN KEY (TC_TXNID) REFERENCES TXNS (TXN_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE COMPLETED_TXN_COMPONENTS (
  CTC_TXNID bigint,
  CTC_DATABASE varchar(128) NOT NULL,
  CTC_TABLE varchar(128),
  CTC_PARTITION varchar(767)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE NEXT_TXN_ID (
  NTXN_NEXT bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO NEXT_TXN_ID VALUES(1);

CREATE TABLE HIVE_LOCKS (
  HL_LOCK_EXT_ID bigint NOT NULL,
  HL_LOCK_INT_ID bigint NOT NULL,
  HL_TXNID bigint,
  HL_DB varchar(128) NOT NULL,
  HL_TABLE varchar(128),
  HL_PARTITION varchar(767),
  HL_LOCK_STATE char(1) not null,
  HL_LOCK_TYPE char(1) not null,
  HL_LAST_HEARTBEAT bigint NOT NULL,
  HL_ACQUIRED_AT bigint,
  HL_USER varchar(128) NOT NULL,
  HL_HOST varchar(128) NOT NULL,
  PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID),
  KEY HIVE_LOCK_TXNID_INDEX (HL_TXNID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID);

CREATE TABLE NEXT_LOCK_ID (
  NL_NEXT bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO NEXT_LOCK_ID VALUES(1);

CREATE TABLE COMPACTION_QUEUE (
  CQ_ID bigint PRIMARY KEY,
  CQ_DATABASE varchar(128) NOT NULL,
  CQ_TABLE varchar(128) NOT NULL,
  CQ_PARTITION varchar(767),
  CQ_STATE char(1) NOT NULL,
  CQ_TYPE char(1) NOT NULL,
  CQ_WORKER_ID varchar(128),
  CQ_START bigint,
  CQ_RUN_AS varchar(128)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
  NCQ_NEXT bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);

-- -----------------------------------------------------------------
-- Record schema version. Should be the last step in the init script
-- -----------------------------------------------------------------
INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '0.14.0', 'Hive release version 0.14.0');

/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2012-08-23  0:56:31

redpajama_set_name: RedPajamaGithub


The Wire has a collection of No Wave photos by Catherine Ceresole.
Roxane Gay talked about An Unnamed State with Room 220.
Jason Diamond on the influence of Denis Johnson.
Robert P. Baird remembers Bill Knott.
Scott Tobias on Veronica Mars, closed systems, and more.
Stephen Graham Jones talks about the process behind his new novel Not for Nothing.


text:
package org.openecard.common.util;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.nio.charset.Charset;
import java.util.BitSet;
import javax.annotation.Nonnull;
import javax.annotation.Nullable;

/**
 * URL encoder class supporting standard URL encoding and URL encoding of query parameters.
 *
 * @author Tobias Wich
 */
public class UrlEncoder {

    private static final Charset ASCII = Charset.forName("ASCII");
    private static final int RADIX = 16;

    // character classes according to RFC 2396
    private static final BitSet ALPHA = new BitSet(256);
    private static final BitSet DIGIT = new BitSet(256);
    private static final BitSet HEX = new BitSet(256);
    private static final BitSet UNRESERVED = new BitSet(256);
    private static final BitSet RESERVED = new BitSet(256);
    private static final BitSet SUB_DELIM = new BitSet(256);
    private static final BitSet GEN_DELIM = new BitSet(256);
    private static final BitSet PCHAR = new BitSet(256);
    private static final BitSet QUERY = new BitSet(256);
    private static final BitSet FRAGMENT = new BitSet(256);

    private static final BitSet QUERY_SAFE = new BitSet(256);
    private static final BitSet FRAGMENT_SAFE = new BitSet(256);

    private final Charset charset;

    static {
	ALPHA.set('a', 'z' + 1);
	ALPHA.set('A', 'Z' + 1);
	DIGIT.set('0', '9' + 1);
	HEX.or(DIGIT);
	HEX.set('a', 'f');
	HEX.set('A', 'F');

	setBits(SUB_DELIM, "!$&'()*+,;=");

	setBits(GEN_DELIM, ":/?#[]@");

	RESERVED.or(SUB_DELIM);
	RESERVED.or(GEN_DELIM);

	UNRESERVED.or(ALPHA);
	UNRESERVED.or(DIGIT);
	setBits(UNRESERVED, "-._~");

	PCHAR.or(UNRESERVED);
	PCHAR.or(SUB_DELIM);
	setBits(PCHAR, ":@");
	// and percent encoded, but this is handled in the encode function

	QUERY.or(PCHAR);
	setBits(QUERY, "/?");

	FRAGMENT.or(PCHAR);
	setBits(FRAGMENT, "/?");

	// calculate safe character sets
	QUERY_SAFE.or(QUERY);
	QUERY_SAFE.andNot(RESERVED);

	FRAGMENT_SAFE.or(FRAGMENT);
	FRAGMENT_SAFE.andNot(RESERVED);
    }

    /**
     * Creates an instance for the UTF-8 character set.
     *
     * @see #UrlEncoder(java.nio.charset.Charset)
     */
    public UrlEncoder() {
	this(Charset.forName("UTF-8"));
    }

    /**
     * Creates an instance for the given character set.
     *
     * @param charset The character set used to encode and decode strings.
     */
    public UrlEncoder(Charset charset) {
	this.charset = charset;
    }

    private static void setBits(BitSet bs, String chars) {
	setBitsVal(bs, chars, true);
    }

    private static void unsetBits(BitSet bs, String chars) {
	setBitsVal(bs, chars, false);
    }

    private static void setBitsVal(BitSet bs, String chars, boolean value) {
	for (byte next : chars.getBytes(ASCII)) {
	    bs.set(next, value);
	}
    }

    /**
     * URL encodes the given string, so that it is usable in the query part of a URL.
     * This method is based on RFC 3986.
     *
     * @param content Data which will be encoded. {@code null} is permitted.
     * @return Encoded data or {@code null} if {@code null} has been supplied as parameter.
     */
    public String encodeQueryParam(@Nullable String content) {
        if (content == null) {
            return null;
        }
        return urlEncode(content, QUERY_SAFE, false, true);
    }

    /**
     * URL encodes the given string, so it is usable in an encoded form ({@code application/x-www-form-urlencoded}).
     *
     * @see URLEncoder
     * @param content Data which will be encoded. {@code null} is permitted.
     * @return Encoded data or {@code null} if {@code null} has been supplied as parameter.
     */
    public String urlEncodeUrl(@Nullable String content) {
        if (content == null) {
            return null;
        }
	try {
	    return URLEncoder.encode(content, charset.name());
	} catch (UnsupportedEncodingException ex) {
	    // can not happen as the charset is already verified in the constructor
	    throw new IllegalStateException("Charset became invalid out of a sudden.");
	}
    }

    /**
     * URL encodes the given string, so that it is usable in the fragment part of a URL.
     * This method is based on RFC 3986.
     *
     * @param content Data which will be encoded. {@code null} is permitted.
     * @return Encoded data or {@code null} if {@code null} has been supplied as parameter.
     */
    public String encodeFragment(@Nullable String content) {
        if (content == null) {
            return null;
        }
        return urlEncode(content, FRAGMENT_SAFE, false, true);
    }

    private String urlEncode(@Nonnull String content, BitSet safeChars, boolean wsPlus, boolean keepEscapes) {
	byte[] contentBytes = content.getBytes(charset);
	ByteArrayInputStream is = new ByteArrayInputStream(contentBytes);
	ByteArrayOutputStream os = new ByteArrayOutputStream();

	int nextVal;
        while ((nextVal = is.read()) != -1) {
            byte b = (byte) (nextVal & 0xFF);

	    if (wsPlus && b == ' ') {
		// space as special element
		os.write('+');
	    } else if (keepEscapes && b == '%') {
		// already encoded numbers
		is.mark(2);
		int c1 = is.read();
		int c2 = is.read();
		if (HEX.get(c1) && HEX.get(c2)) {
		    os.write('%');
		    os.write(c1);
		    os.write(c2);
		} else {
		    // rewind stream and encode the last character
		    is.reset();
		    encodeChar(os, b);
		}
	    } else if (safeChars.get(b)) {
		// characters which should not be encoded
                os.write(b);
            } else {
		// characters which should be encoded
		encodeChar(os, b);
            }
        }

        return new String(os.toByteArray(), charset);
    }

    private static void encodeChar(ByteArrayOutputStream os, byte b) {
	os.write('%');
	char hex1 = Character.toUpperCase(Character.forDigit((b >> 4) & 0xF, RADIX));
	char hex2 = Character.toUpperCase(Character.forDigit(b & 0xF, RADIX));
	os.write(hex1);
	os.write(hex2);
    }

}


State and local policymakers are responsible for scores of decisions that affect families and kids, including decisions about public education. That's why educator and parent activism is so critical during state legislative sessions, city or town council meetings, and school board proceedings.
Click here to read a few examples where educator activism helped score a win for public education and the common good.


text:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Windows.UI.Xaml.Data;

namespace DiveInoUWP.Converters
{
    public class GenericConverter : IValueConverter
    {
        public object Convert(object value, Type targetType, object parameter, string language)
        {
            return value;
        }

        public object ConvertBack(object value, Type targetType, object parameter, string language)
        {
            // no convert to a specific type needed -> the "value" is already an instance of the correct type.
            return value;
        }
    }
}


Makers Quarters will be an urban mixed-use neighborhood with the East Village District of downtown San Diego located between 14th and 17th streets between Broadway and G Streets.
The multiphase project is being developed by a joint venture of three firms known as Lankford Phelps Portman, which includes San Diego-based Lankford & Associates Inc. Developers have not announced timetables or expected project costs, but the development would span more than five city blocks and likely be built out over the next decade.
This will be a great addition to the downtown San Diego real estate market as much needed new inventory of both residential, commercial and mixed use units become keep adding to the progress and development of the downtown metro area.
Concept drawings showed mixed-use buildings housing offices, apartments and retail spaces, and developers are looking to include an open marketplace with community gathering spots.
Two mid-rise buildings with green roofs, mixing offices and residences.
Three low-rise, loft-style office buildings catering to the flexible, open floor plan desired by high-tech design and development firms.
A 100- to 150-room hotel.
A plaza incorporating the historic Coliseum Athletic Club at the southwest corner 15th and E streets.
Please contact us for more information on downtown San Diego condos or if you need assistance.


text:
Odd Goods for All: The Ever-Interesting Odd Market Returned to Santa Monica Pier For the Holidays
By Sam Skopp
The Odd Market, a popular event series that travels across Los Angeles, sees mostly independent vendors sell all sorts of things, from food to clothing, home goods, nick knacks and more. Saturday, Dec. 16 saw the market return to Santa Monica Pier for a Holiday-themed edition that drew crowds in search of gift inspiration.
L.A.-based comic book author Jonathan Hennessey was among the day's 75-plus vendors, selling educational comic books he authored, including "The Comic Book Story of Video Games," "The Comic Book Story of Beer," and "Alexander Hamilton: The Graphic History of an American Founding Father."
"It's been great," said Hennessey, about participating in the Odd Market. "I live inland so it's always kind of a privilege to have an excuse to come out here."
While he occasionally sells at similar events, they're mostly dedicated comic book conventions and not markets as expensive as the Odd Market, though he noted that, since books are starting to have a reduced retail footprint, it can be refreshing for a book vendor to be part of one such event.
"It's something I could do any weekend, but I wouldn't get any writing done," he joked.
Ditch Planet was also among the L.A.-based independent businesses with a table at Saturday's event, selling candles and scented room sprays. Company founders Brooke and Peo explained that they had sold at the Gene Autry Museum Odd Market location in the past, but that this was their first time on the pier.
"The weather is amazing," said Brooke. "I like the tourism. Out-of-towners like to buy."
While Ditch Planet has booths at other events around town, like the Melrose Trading Post and the Renegade Craft Fair, she finds the Odd Market to have its own character.
"I feel like the Odd Market has a much more laid back vibe," Brooke said.
DeLight from Paris, which was one of the food vendors featured at the event, was not only participating in its first Odd Market, but launched as a business just two months prior.
"It's cool because it's open air," said Celine, the company's founder. "There's sunshine and people from different areas. And it's comfortable."
She then explained that their French-style tea cakes are packaged in boxes adorned with pictures of the flowers used as ingredients in the recipes for the cakes.
These were just a few of the many vendors present at the pier on Saturday. For more information on upcoming Odd Market events on the Pier and elsewhere in Los Angeles, visit theoddmarket.com.
Leather goods by Smiths & Kings.
Haiku Cats.
Photos: Sam Skopp.
Tags: All, Ever-Interesting, Goods, Holidays, Market, Odd, Pier, Returns, santa monica in News
Drop in Santa Monica Mountains Monarch Butterfly Numbers 'Deeply Concerning'
January 7, 2022 Staff Writer
By Dolores Quintana There are 18 critically endangered species of butterflies and moths in the state of California and the...
JW Marriot Santa Monica. Photo: Sam Catanzaro.
JW Marriot Santa Monica to Pay Housekeepers $25 an Hour Following Agreement With Labor Union
Family health insurance and other benefits part of agreement ending lengthy dispute By Sam Catanzaro Ending a lengthy labor dispute,...
Food Delivery Driver in Santa Monica Has Vehicle Stolen
A food delivery driver in Santa Monica recently watched their car get stolen in front of their eyes. According to...
by Juliet Lemar