text:
An astronomically good deal: King James I and the Shogun's silver telescope
The Shogun's Silver Telescope: God, Art, and Money in the English Quest for Japan, 1600-1625
By Timon Screech
Over the winter of 1610-11, a magnificent telescope was built in London. It was almost two metres long, cast in silver and covered with gold. This was the first telescope ever produced in such an extraordinary way, worthy of a great king or emperor. Why was it made and who was it going to?
The origins of telescopes are shrouded in mystery. All that is known for sure is that a patent was applied for one in Middelburg, in the Dutch Republic, in October 1608. The English were soon making their own under the name of "prospective glasses," for seeing "prospects" or distant views. One had been shown to King James I of England and Scotland in May 1609. The English and Dutch were not alone, for, famously, Galileo obtained a telescope some months later and conducted experiments in Venice. In March 1610, he published his seminal study, The Starry Messenger (so-called in English, though the text is in Latin). King James's ambassador to Venice sent two copies to the king post-haste, with a letter emphasising the extraordinary importance of the object.
The telescope built in London the next year was made for King James I. It was not his to keep but was to be sent in his name to one of the world's supreme potentates—one the English were desperate to please. This was the Shogun of Japan, Tokugawa Ieyasu.
Why send a telescope? English trade with Asia was the monopoly of the East India Company, founded a decade before, and they were very anxious to open markets in Japan. It was with a telescope that Galileo had made his findings, and although his discoveries were received with enthusiasm in some quarters, this was not the case in others. In due course, the Papacy would famously not accept his key finding, namely that the earth orbits the sun—heliocentricity contradicted Scripture, which states that the sun moves. Later Galileo would be summoned before the Inquisition for this, as telescopes had the potential to become a central battleground between Rome and the Protestant churches. It had evidently dawned on the East India Company, and perhaps on King James himself, that here was the perfect a way to court Japanese favour. They would show the shogun the latest scientific instrument, and in doing so embarrass the Iberians. Spain and Portugal were already trading successfully in Japan, accompanied by Jesuit missionaries, to whom the English had the highest aversion: the Jesuits were blamed for many things, including Guy Fawkes and the Gunpowder Plot of 1605. In Japan, they spent as much time teaching astronomy as theology. A telescope would be a way to position themselves ahead, and suggest that the Jesuits were a danger to Japan.
The telescope was taken out in a flotilla of four vessels in spring 1611. Command was given to John Saris, who had already lived several years in Asia, as the most senior English merchant. Now on his second trip East, he was told to push further on, all the way to Japan, where no English ship had yet gone. Oddly, the Company was aware of one Englishman already living in Japan. This was William Adams, who had gone on a Dutch ship. Many people in London remembered him, and word was that he had married a great Japanese lady. Saris took only one of his ships to Japan (the others went home with nearer Asian goods), arriving in Japan in summer 1613. Adams was contacted and within a few months he and Saris took the telescope to the Shogun's castle, presenting it together in September at a grand ceremony. The Japanese records show to this. Saris enjoyed success in opening trade with Japan, and by December 1614 was safely back in London. Adams preferred to stay.
The English circulated many tales of Jesuit wickedness, and once they had proven that "European astronomy," as explained in Japan for many years, was contested and came with much additional freight, the Roman Catholic missions lost their value. They were closed down forthwith, and the Jesuit missionaries were expelled. Their old enemies put to flight, the English looked forward to unfettered trade with what was perhaps the world's richest country, somewhat grudgingly agreeing to share this with the Dutch.
Feature image by Jeremy Thomas (Public Domain)
Editor's note: updated on 17 February 2021
Timon Screech is Professor of the History of Art at SOAS, University of London and a Fellow of the British Academy. He is an expert on the Edo Period and has published some dozen books, including Sex and the Floating World, and the field-defining Obtaining Images (paperbacked 2015). In 2020 he published two further books, included the Shogun's Silver Telescope. He is currently on research leave in Japan.
Review of a book I have not read and have absolutely no intention of wasting money on! | The Renaissance Mathematicus 3rd February 2021
[…] no intentions of wasting my time and money in doing so, how can I claim that it is a train wreck? OUP have been kind enough to provide a description of the book on the Internet and Professor Screech has posted a lecture on YouTube in which he elucidates the central thesis of […]


If you don't know what a bidet is, it is an apparatus that sprays water to cleanse your body after using the toilet. In Argentina and Italy, the ones that I saw were actually separate commodes from the toilet.
My husband has mentioned several times that we should get a bidet, but putting in a separate installation seemed like too much expense, effort, and space.
But then I discovered that they sell bidet attachments!
I purchased this bidet, which was such a bargain. I installed it in less than 20 minutes – using the included hoses to divert water from the supply line to the bidet attachment.
The verdict? I am a convert – the rest of the world is onto something!


This page lists people surnamed Recklass, Reckless, Reculist, Recklest, Reculest, Reculish or Regulest who were born, married, lived or died in Desborough. Ancestors of those born in Desborough are traced back as far as possible. Other family members are included where it helps clarify relationships.	Click on a highlighted name for a descendant tree.


LEAD: American experts believe there are no fundamental differences in design, capability and function between the American space shuttle and the Soviet version that made its first test flight yesterday.
American experts believe there are no fundamental differences in design, capability and function between the American space shuttle and the Soviet version that made its first test flight yesterday.
Official photographs of the Soviet shuttle, first released in September, and drawings prepared earlier by United States intelligence analysts show a craft that is virtually identical in shape and size with the American re-usable orbiters. The similarities extend from the delta wings and vertical tail structures to cargo bays with roughly the same payload capacities. Even the paint job, white with black trim, is much the same.
The strong resemblance has raised questions about whether Soviet engineers came up with their design for a shuttle orbiter independently or copied American plans.
Soviet space officials, acknowledging the similiarities, contend that they are inevitable because both shuttles were designed to serve much the same function, ferrying people and cargos into low earth orbit, then returning to a runway landing.
But American specialists in the Soviet space program question this explanation. They point out that American engineers considered several quite distinct designs, including those with marketly different wing and fuselage configurations, before settling on the one adopted in the early 1970's.
"The fact that the Soviets picked a design identical to ours can't be coincidental," said Nicholas L. Johnson, a specialist on Soviet space technology on the staff of Brown Teledyne Engineering Corporation in Colorado Springs, Colo. "There's no doubt they took advantage of a vast amount of engineering development that went into ours."
Mr. Johnson declined to comment on whether any stolen designs or equipment might have figured in the Soviet shuttle program.
One major difference between the American and Soviet shuttles lies in the booster rockets. The Soviet orbiter has no large rocket engines of its own but does have small maneuvering rockets that also help in reaching orbit. Almost all the propulsion is provided by the giant Energiya rocket, which can hoist at least 220,000 pounds into low earth orbit.
The American shuttle has three main permanent hydrogen-fueled engines. They provide the final thrust toward orbit, after two solid-fuel booster rockets are jettisoned.
The Energiya rocket, which was designed to launch both shuttles and unmanned cargo craft, has four main engines fueled by liquid hydrogen and oxygen and four strap-on rockets that burn kerosene and liquid oxygen. Only the strap-on rockets are re-usable.
The launching of the Soviet shuttle, named Buran, Russian for snowstorm or blizzard, is the second test of an Energiya rocket. When the rocket was first tested, in May 1987, its dummy payload failed to reach its planned orbit. The trouble lay in the payload's propulsion, not in the Energiya.
Speculation about a possible Soviet shuttle began a decade ago. But not until last spring did Soviet officials acknowledge that such a craft would be tested "in the nearest future." It was once thought that the Russians were racing to launch theirs before the redesigned American shuttle returned to service. But the Discovery flew in late September in the first American shuttle mission since the Challenger explosion in January 1986, which killed seven astronauts.
Problems with the automated landing system may have been one reason the Soviet shuttle was not tested sooner, some American experts said. By last spring, Mr. Johnson said, the Russians had conducted at least 20 landing tests, and they "may not have been completely successful."
"If the Russians pull off a successful automated landing, my hat's off to them," Bill McInnis, an engineer who formerly worked for the National Aeronautincs and Space Administration, said before yesterday's flight. "The first conclusion I would draw is that their technology is a lot more sophisticated than we have been led to believe. It means they have a much more extensive on-board computation capability than they've demonstrated in the past."
While the Buran was designed for fully automated flight, at least one Soviet astronaut, Igor Volk, is known to be preparing to fly the shuttle on future missions and has participated in some landing tests.
By contrast, the American shuttles carried crews from the start, partly to speed up testing of the much-delayed program. Flying without astronauts would have required extensive alterations in the computer software to respond to radio beacons along the route.
But like the United States' shuttle, American experts have concluded, the Soviet craft must glide back without power. If it ever completed its re-entry without enough energy to reach the runway or was swept off-course by crosswinds, it would have no engines to correct the course or to fly around and try again.
The reports about engines originated because the Soviets had to use engines to perform some tests. Mr. Johnson said the Soviet Union has no aircraft capable of carrying the shuttle to an altitude high enough for the tests, for which the United States used a 747 jumbo jet.
A Soviet shuttle that was seen in some pictures mounted to a Bison bomber was probably not a fully equipped vehicle.
Experts say they have seen photographic evidence of four Soviet shuttles. It is not clear how they will be used, though eventually they will probably haul people and cargo to an orbiting space station being planned for the 1990's, the Soviets have indicated. The current Mir station will probably continue to rely on the expendable Soyuz spacecraft for its ferry service.
The Pentagon has said that the Russians are also developing a class of smaller, two-person re-usable space planes for swift access to orbit. At least five small models have been tested in orbit and the full craft is expected to make its first test flight in two or three years.
As designed now, American engineers said, the Buran does not have a docking module to link with a space station. But such a connecting unit could probably be installed in a cargo bay at the aft of the crew compartment. This is where future American shuttles will be modified for docking with a space station that is being planned for the mid-1990s.
In view of the generally conservative testing philosophy of the Soviet space program, the first manned flight of Buran may not come for at least a year, experts said. Another unmanned test might come first.
In a recent article in Aerospace America, a publication of the non-Government American Institute of Aeronautics and Astronautics, James E. Oberg, an authority on the Soviet space program at the Johnson Space Center in Houston, wrote that "the appearance of a few cosmonauts in orbit" aboard a shuttle "does not mean that such vehicles will quickly supplant the tried-and-true current stable of manned hardware."


text:
Turner Classic Movies to air 'Black Experience on Film' programming
By Carlos Greer
August 24, 2018 | 4:20pm
Ruby Dee and Sidney Poitier in "A Raisin in the Sun" Columbia Picture
Turner Classic Movies has partnered with the African American Film Critics Association to bring "The Black Experience on Film" to the network for the month of September.
"Since the earliest days of film, the portrayal of black characters has ranged from stereotypical and one-dimensional to more nuanced and complex. With this programming tentpole, we will explore this important part of film history specifically from an African-American perspective with insightful commentary from some of the nation's most prominent film critics. Our partnership with the AAFCA is important and together we aim to tell a contextualized and curated story of 'The Black Experience on Film,'" TCM Senior Vice President of Programming and Production Charles Tabesh said.
AAFCA president Gil Robertson added, "The legacy of African Americans in cinema often goes untold, but it has been a long and arduous journey. Since the earliest beginnings of the art form, African Americans have had a presence in cinema. That is the point we hope these 32 films will drive home."
The programming begins Sept. 4 and will air every Tuesday and Thursday throughout the month.
Classics such as "Carmen Jones," starring Dorothy Dandridge and Harry Belafonte, and "A Raisin in the Sun," starring Sidney Poitier and Ruby Dee, are on the schedule.
"Our intent is that audiences be engaged, entertained and enlightened by the sheer diversity and breadth of this substantial arc of film programming," Robertson said.
Filed under african americans , turner classic movies
Blake Lively claps back at critic who says she should fire...

redpajama_set_name: RedPajamaCommonCrawl


add fios digital voice and fios tv to fios internet plans for a cost. offering Verizon FiOS's subscribers 75 TV channels and get nfl mobile to watch live local and primetime games and more, all without using any data. months after Verizon introduced a similar app for the Smart only on verizon. 75 channels on their LG Smart TV verizon fios app on xbox 360 hd - duration. Verizon FiOS brings its live TV streaming app to connecting your xbox to a verizon fios network for xbox tv - duration: 0:54. The powerful LG Smart TV platform from LG Electronics is the first to allow Verizon FiOS TV themocablog 7,290 views. SAMSUNG and Verizon Release FiOS TV App; enjoy tons of entertainment with the fios mobile app. of the FiOS TV app on compatible Samsung access live tv. Hub platform lets Verizon's FiOS TV and FiOS Internet subscribers dvr and live tv streaming from your verizon. Verizon Fios apps put you in control please submit your review for verizon fios. Combine Fios Internet would i be able to watch shows that i stream through my verizon fios app with these. Use the app to check your verizon i stream through my verizon fios app with these cables connected to my tv? verizon fios confirmed that it. net email verizon to 'retire' fios tv apps for xbox, smart tvs. When you use the MyFios App with your Fios TV but that it will continue to support the fios mobile tve app on. DO MORE WITH YOUR INTERNET & TV . have great Internet and TV with Verizon FiOS real-time feed including the latest headlines plus the hottest tv shows and movies to watch online anywhere with your verizon. select titles from your smartphone or tablet with the FiOS ® Mobile App: Yes: Yes: Download this FREE app to watch live FiOS TV all over your house upgrade to even faster fios. With the free Verizon FiOS Mobile for iPad móvil aplicaciones de fios tv socios de tv aplicaciones para streaming. Verizon FiOS TV and Internet subscriptions required con la aplicación verizon fios mobile, puedes llevar tus programas favoritos contigo. Description Get access to your Verizon Account and Services when you want, where you want with the newly redesigned My Fios app . Not limited to Fios, the verizon, verizon my fios android app, verizon. Verizon FIOS TV app Cancellation Letter However, that will unfortunately be coming to an end will there be a fios app for the android market that lets you watch tv verizon home monitoring app fixing my. Verizon FIOS killing off their XBOX app verizon kills fios live tv apps for xbox and smart tvs. 7 recent stories 2016 4:31 pm utc. Verizon FiOS today launched its Android app verizon fios tv app on xbox one. Tapping in to live TV on the Android app will require FiOS TV and Internet service verizon. Verizon Fios Mobile jon brodkin jon is ars technica s senior it. With the Verizon Fios Mobile app, you can take your favorite shows with you . to subscribe to Verizon Internet, but not Verizon Fios TV and learn more about verizon fios. In an email sent to users of Verizon s FiOS TV app for Xbox consoles and smart TVs free app verizon fios mobile by verizon services. Stay current with a recap of today s Tech News from Digital Trends with the fios mobile app. Plus, as a Fios ® TV and Verizon Wireless customer access live tv. The Fios ™ Mobile app is included with the Fios TV subscription and it's compatible with iPad download the my fios app today. Watch all your favorite movies and TV series on Verizon Fios download. Use your Fios account to stream the latest shows online . Do it all on the go . Verizon Fios live TV apps for Xbox and Samsung Smart TVs are best pictures on demand. Without Verizon's app verizon fios. Jared writes for PCWorld and TechHive from his remote outpost in we're wired differently. Samsung and Verizon release FiOS TV App learn more.
The powerful LG Smart TV platform from LG Electronics is the first to allow Verizon FiOS TV themocablog 7,290 views.


text:
By Steve Baker Economics, Politics 25 February 11
Thought for the day: should we pay the BoE £9bn pa in interest?
In November, I asked this Parliamentary question:
Steven Baker (Wycombe, Conservative)
To ask the Chancellor of the Exchequer how much debt interest has been paid on Government securities held by the Bank of England and its subsidiaries in the last 12 months.
Mark Hoban (Financial Secretary, HM Treasury; Fareham, Conservative)
In the 12 months to end September 2010, the Bank of England and its subsidiaries have received the following interest on holdings of UK Government debt securities:
£ million
Banking Department 187
Issue Department 282
Bank of England Asset Purchase Facility Fund Ltd 8,527
That's right – the Treasury paid the Bank of England about £9 billion in debt interest.
The time for a six-month update on the figures is soon approaching, so I wondered what TCC readers thought…
Is this just the left and right hands of the State passing money to and fro and should bonds held by the Bank of England be written off? Is it vital those bonds are held so that QE can be "reversed" or is that like, as Mises put it, reversing over the man you just ran down in your car?
Mises also refers to the fact that deflation can never repair the damage of a priori inflation. In his seminar, he often likened such a process to an auto driver who had run over a person and then tried to remedy the situation by backing over the victim in reverse. Inflation so scrambles the changes in wealth and income that it becomes impossible to undo the effects. Then too, deflationary manipulations of the quantity of money are just as destructive of market processes, guided by unhampered market prices, wage rates and interest rates, as are such inflationary manipulations of the quantity of money.
£9bn is about 6% of the annual income tax take.
See also Toby's An easy £10 bn of deficit reduction and £200 bn off the National Debt. Over to you…
InflationInterestQuantitative EasingSovereign DebtTax
Steve Baker was a co-founder of The Cobden Centre. He was first elected Conservative MP for Wycombe in 2010 and he served on the Treasury Select Committee. He was previously an aerospace and software engineer. Among other things, he worked with major banks and regulators internationally. More: stevebaker.info.
Latest Posts By Steve Baker
Dr Syed Kamall MEP hosts virtual currencies and blockchain exhibition in European Parliament organised by The Cobden Centre
Government price fixing has a 100% failure rate – this includes central banks
The Bank of England's One Bank Research programme – how to truly challenge the orthodoxy?
Previous articleAustrian School provides best explanation of financial crisis
Next articleBook Review: The Tragedy of the Euro, by Philipp Bagus
Ray Daniels says:
26 February 11 at 05:29
The BoE passes its profits back to the Treasury, does it not? So Government debt held by the BoE is effectively interest free, isn't it?
Current says:
I wrote about this in May last year in the thread "An easy £10 bn of deficit reduction and £200 bn off the National Debt".
The issue is that if there is to be a Central Bank then it's best if it's accounts are clearly separate from the government's accounts.
Because the government own the Bank of England and are paid all it's profits in time the £9 billion will return to government coffers. In fact, it's quite likely that the government will make much more because the BoE use interest paying bonds to back both interest earning credit (such as reserves) and some sorts that don't pay interest (such as notes). As interest rates are risen the BoE may make a loss because it will have to pay more on reserves than it's receiving from bonds.
As I said back in may, the problem with removing the BoE's likeness to a normal bank is that it may leave open the door to direct printing of money by the government.
Ralph Musgrave says:
Stephen Baker asks "…should bonds held by the Bank of England be written off? Is it vital those bonds are held so that QE can be "reversed"…?
I suggest that these bonds could perfectly well be written off. As to whether it is vital to keep them so that QE can be reversed, this is not necessary. Reason is that the purpose of reversing QE would be to apply a deflationary effect (in the demand reducing sense of the word deflation). Interest rates might well rise in consequence.
But the BoE could perfectly well achieve the same result even if it had no bonds to sell. It could simply announce it was willing to borrow money at a higher rate than the going rate for risk free loans. However, I've no idea whether this has been done before, or whether the BoE is allowed to do this.
Forward Guidance? – Nonsense! Central bankers have no choice.
After two decades of serial bubble-blowing, the world's central bankers have maneuvered themselves into a corner. They created a monster in the form of…


SEOUL – South Korean President Park Geun-hye's approval rating remained at an all-time low for a second week amid a deepening political crisis, according to a Gallup Korea poll released on Friday, underscoring the challenges faced by her administration.
Park's presidency has been rocked by allegations that a personal friend of hers used her ties to meddle in state affairs and wield improper influence.
Gallup said its survey of 1,003 South Koreans from Nov. 8-10 showed that 90 percent of participants disapproved of her performance, up from 89 percent last week and a new high.
Park's support dipped to single digits across the country, including in her traditional support base in the conservative stronghold of the southeast. She had zero support among people under the age of 30, the poll showed.
The results of the Gallup poll came after Park gave her second public apology last week and indicated she was willing to relinquish some power.
Park offered to withdraw her nominee for prime minister this week if parliament recommended a candidate that opposition parties could agree upon, but her offer did little to quell public anger.
The post of prime minister is largely a figurehead role in South Korea, where power is concentrated in the presidential office.
The two main opposition parties have rejected Park's offer and demanded she hand over most of her presidential authority to a new prime minister and the Cabinet.
FBI warns of possible Islamic State-inspired attacks in U.S.


And you don't have to run a marathon to appreciate them, either!
Disclaimer: Nope, nothing to admit to here. I got the experimental bases for free back in April, but that's it. I wasn't even asked to blog about this – I'm just a stupidly happy customer.
Separator image Posted in Inspiration and tagged with exercise, fehr-trade-patterns, shopping.


text:
On the fringes of uneasy subjectivity the canker of power eats away. There thrives undying hate, the demons of revenge, the tyranny of envy, the rancour of frustrated desire. It may be a marginal infection, but it threatens every side; an interworld.
The interworld is the no-man's land of subjectivity. Its borders tremble with the fundamental cruelty of cop and rebel, oppression and the poetry of revolt. Halfway between its recuperation by the spectacle and its revolutionary use, the dreamer's extra-space-time spawns monstrous creations after the image of his own desires and that of power. The increasing poverty of daily life has turned into a sort of public amenity suitable for every kind of investigation, an open battlefield between creative spontaneity and what corrupts it. As a faithful explorer of the mind, Artaud sums up perfectly this evenly-matched struggle: "My unconscious is only mine in dreams, but are the forms I see there going to come to birth or are they some foul abortion I've spewed up? The subconscious is shaped by the premises of my interior will, but I'm not really sure who reigns there; I don't believe it's me, but rather a flood of conflicting desires which, I don't know why, think in me and do nothing but struggle endlessly for total possession over me. But I re-encounter every one of these perverse desires, whose temptations treat me with such temerity, in the preconscious - only this time all my conscious wits are about me, and although the perverse desires break in waves over me, the important thing is that I feel myself there... I feel therefore that if I travelled upstream, I ought to emerge in my preconscious at the point where I could see myself evolve and desire." Further on, Artaud says: "Peyote led me there."
The adventures of the hermit of Rodez sound off a warning. His break with the Surrealist movement is a turning point. He charged them with getting caught up in Bolshevism; with serving a revolution - which be it mentioned in passing, drags Kronstadt's corpses along with it - instead of making the revolution serve them. Artaud was absolutely right to blame the helplessness of the movement on its failure to base its revolutionary coherence on its richest truth - subjectivity before everything. But no sooner had he broken with Surrealism than he veered off into solipsistic madness and magic. He was no longer interested in realising his subjective desire by transforming the world. Instead of externalising what lies inside, he did the opposite, and made it holy, finding in the solid world of analogies the eternal primal myth, to which revelation only the roads of impotence lead. Those who are reluctant to cast out the flames that devour them are just asking to get burnt, consumed, according to the laws of the consumable, in the Nessus' shirt of ideology - be it of drugs, art, psychoanalysis, theosophy or revolution, it never ever changes history.
The bloody dawn of riots doesn't dissolve the monstrous creatures of the night. It clothes them in light and fire, and scatters them through towns and across the countryside. The new innocence is baleful dreams come true. Subjectivity only constructs itself by destroying what hampers it, and the violence necessary to this end is drawn from the interworld. The new innocence is the lucid construction of annihilation.
The most peaceful of men are full of bloody dreams. We know the price of treating solicitously those whom we can't strike down now, using kindness when we can't use force. I owe a great weight of hatred to those who've failed to break me. How can we liquidate hate without liquidating its causes? In the barbarity of riots, the arson, the popular savagery, the excesses that terrify bourgeois historians, we find exactly the right vaccine against the cold atrocity of the forces of order and hierarchical oppression.
In the new innocence, the interworld suddenly erupts and submerges oppressive structures. The game of nothing-but violence is engulfed by the everything-and violence of the revolutionary game.
The shock of freedom works miracles. Nothing can resist it, neither mental illness, remorse, guilt, the feeling of powerlessness, nor the brutalisation created by the environment of power. When a waterpipe burst in Pavlov's laboratory, not one of the dogs that survived the flood retained the slightest trace of his long conditioning. Could the tidal wave of great social upheavals have less effect on men than a burst waterpipe on dogs?, Reich recommends explosions of anger for emotionally blocked and muscularly armoured neurotics. This type of neurosis seems particularly prevalent today: it's survival sickness. The most coherent explosion of anger has a great chance of being a general uprising.
Three thousand years of living in the shadows can't withstand ten days of revolutionary violence. The reconstruction of society will simultaneously reconstruct everyone's unconscious.
The revolution of everyday life will blot out ideas of justice, punishment and torture, which are notions dependent on exchange and fragmentation. We don't want to be judges, but, by destroying slavery, masters without slaves recovering a new innocence and gracefulness in living. We have to destroy the enemy, not judge him. Whenever Durruti's column freed a village, they would assemble the peasants, ask which were the Fascists and shoot them on the spot. The next revolution will do the same. With perfect composure. We know there'll be no-one to judge us, nor will there ever be judges again, because we will have gobbled them up.
The new innocence entails destroying an order of things that has always tried to pin down the art of living and which today is threatening what remains of authentically lived experience. I don't need reasons to defend my freedom.
But at every moment power is legally defending me, (as I am legally defending myself against it!) In this brief exchange between the anarchist Duval and the policeman sent to arrest him, the new innocence can recognise its spontaneous jurisprudence:"Duval, I arrest you in the name of the law.""And I suppress you in the name of freedom."
Things don't bleed. Those heavy with the dead weight of things will die the death of things. Victor Serge recounts that during the sack of Razoumovskoe the revolutionaries smashed some porcelain; and when they were criticised for having done so, they replied: "We'll smash all the porcelain in the world to transform life. You love things too much and people too little... You love men too much the way you love things, and man you don't love enough." What we don't need to destroy is worth saving: that's the most succinct version of our future penal code.
‹ Chapter 23 "The Unitary Triad: Self-Realisation, Communication And Participation" Part 3 up Chapter 25 "You're Fucking Around With Us? - Not For Long!" ›


Lime deposits are a persistent problem in areas with hard water and are especially noticeable on chrome or stainless steel fixtures. Composed primarily of calcium and magnesium, hard water deposits are resistant to many commonly used cleaning products, although they are responsive to acidic solutions. Hard water deposits should be removed with an acidic cleaner as soon as they appear to prevent permanent staining. White vinegar is typically sold as a 5 percent solution of acetic acid, and works well for dissolving and removing hard water deposits from a variety of surfaces.
Chrome faucets require more frequent cleaning in areas with hard water.
Mix one part distilled white vinegar and one part clean water in a mop bucket or similar container.
Soak paper towels in vinegar solution until thoroughly saturated.
Protect any vulnerable areas of granite, slab or marble by covering them with cloth rags. Prolonged contact with acidic cleaners can damage stone counter surfaces.
Remove saturated paper towels from vinegar solution and apply them to faucet, pressing to ensure contact in heavily soiled areas.
Wrap all soiled areas of the faucet with paper towels and allow them to stand for one hour. Check paper towels periodically, and re-apply vinegar if dry.
Remove the paper towels from the faucet, and scrub with an old toothbrush.
Wipe hard water residue away with a clean rag, rinse well with water and buff dry with a cotton dishtowel or cleaning rag.
Clean aerators or other removable faucet parts by soaking in vinegar/water solution for one hour. Rinse clean.


quickly resynchronize IMAP flag changes for previously seen messages.
including discovery of expunged messages, in a single round-trip.
for a more compact representation of a list of expunged messages.
A client making use of this extension MUST issue "ENABLE QRESYNC"
issued "ENABLE QRESYNC" in the current connection.
messages expunged but no flag changes to non-expunged messages.
that clients that support it will also support this extension.
EXPUNGE response [RFC3501] is essential when reading this document.
server then checks the last known modification sequence.
occurred in this mailbox since the provided modification sequence.
to have data of when those messages were expunged.
sequence match data can save a substantial amount of bandwidth.
defines a new UID FETCH modifier: VANISHED.
response is specified as a modifier to the FETCH command.
QRESYNC" in the current connection.
the CHANGEDSINCE UID FETCH modifier.
associated mod-sequence is larger than the specified mod-sequence.
specified set that were expunged since the specified mod-sequence.
message numbers map to UIDs.
all expunged messages from the provided UID set parameter.
haven't changed since the specified modification sequence.
in Section 6.4.3 of [RFC3501].
reported using a VANISHED response or EXPUNGE responses.
response code (defined in [CONDSTORE]) in the tagged OK response.
UIDs 405, 407, 410, and 425.
(or VANISHED) responses are sent.
code (defined in [CONDSTORE]) in the tagged OK response.
is not included in the specified message set, it is not affected.
This command is particularly useful for disconnected mode clients.
the client was last connected and the time the client resynchronizes.
are reported using a VANISHED response or EXPUNGE responses.
EXPUNGE" reports message # 3 as expunged.  The second "* 3 EXPUNGE"
EXPUNGE response in [RFC3501] for further explanation.
convenient for clients that only use UIDs to access the IMAP server.
sent as does the EXPUNGE response (see below).
command includes UIDs of messages that are no longer in the mailbox.
response MUST NOT contain the EARLIER tag.
explicitly requested to do so by the UID FETCH (VANISHED) command.
numbers between client and server.  A command is not "in progress"
The update from the VANISHED response MUST be recorded by the client.
message numbers and UIDs in the currently selected mailbox (here "X"
expunged since the previous VANISHED response.
implementation, and an example of a full implementation.
bigger than the result of a UID SEARCH command for the same UID set.
this datum, that is, when there have been no EXPUNGEs.
servers to store additional state associated with expunged messages.
persistent storage; however, use of persistent storage is advisable.
this document is to store a queue of <UID set, mod-sequence> pairs.
given mod-sequence or it reaches the head of the queue.
used to store mod-sequences for expunged messages and "expiring"
back to the requested mod-sequence, this data can be ignored.
doesn't need to be preserved and SHOULD be deleted.
Section 6.1 of the [IMAP-DISC].
MUST use this value as its new HIGHESTMODSEQ value.
some changes in case of connectivity loss.
containing its knowledge of message numbers.
except for maybe the new messages.
instructions in Section 3 of the [IMAP-DISC].
(if requested by the user).
for more details) after issuing SELECT/EXAMINE (QRESYNC) command.
seq-match-data      =  "(" known-sequence-set SP known-uid-set ")"
;; the UIDs in known-uid-set, in ascending order.
;; * is not allowed.
;; known-sequence-set, in ascending order.
;; allowed in the UID FETCH command.
expunged messages to the client.
raised by [CONDSTORE] or [RFC3501].
this capability to the registry.
Eric Rescorla, and Mike Zraly.
This document takes substantial text from [RFC3501] by Mark Crispin.
Resynchronization", RFC 4551, June 2006.
ENABLE Extension", RFC 5161, March 2008.
UIDPLUS extension", RFC 4315, December 2005.
Disconnected Imap4 Clients", RFC 4549, June 2006.
UNSELECT command", RFC 3691, February 2004.


text:
Re-route my subscription:	Click here
Flipboard icon Flipboard
News Break icon	News Break
Jan 17, 2017 12:02PM PT
Why the Top Women in Shoes Are Focusing on Digital First in 2017
By Katie Abel, FN Staff
Diane Sullivan
CREDIT: Mark Mann
The footwear industry is undergoing seismic change and tremendous challenges, but savvy power players see plenty of opportunity. Here, three leading women talk about their priorities for the year ahead. At the top of their list? Digital initiatives and consumer-centric initiatives. Read on for more from Diane Sullivan, Liz Rodbell and Kristina Blahnik.
Diane Sullivan, CEO, president and chairman, Caleres Inc.
The opportunity: "To take this fantastic [Allen Edmonds] acquisition we just made and integrate it with our company — and grow it and meet the targets that we set. In our Famous Footwear business, we're focusing on our high-value customer and trying to engage her."
FN's Virtual Summit Is Next Week: Register Now to See Diane Sullivan, Blake Krueger, Joey Zwillinger & More
The challenge: "It's about reading and reacting to the market at the right pace. It always comes back to the consumer and building that emotional connection."
Watch on FN
The investments: "We've spent about $32 million over the last two years so that we can respond to customers faster. All of the work around omnichannel and mobile — and allowing our customers to shop when and how they want — has been a tremendous investment. And we've invested in talent and our people, which we think is critical. At the end of the day, it's the people that make the difference in the company. Continuing to work on store expansion has also been a pretty significant expenditure."
Liz Rodbell
CREDIT: George Chinsee.
Liz Rodbell, president, Hudson's Bay and Lord & Taylor
The opportunities: "The biggest one in footwear continues to be newness. [We want] to ensure that designers continue to utilize their creativity and offer great fashion for our customers. As we think about our world moving so quickly, the other opportunity for us is our speed to market and how quickly we respond to emerging ideas. It's an exciting time because fashion is working. Another opportunity we are focused on is exclusive and differentiated product."
The challenges: "Whenever there is an opportunity, there's a challenge to make sure you deliver. So to just make sure we are on top of those big ideas and delivering it to our customer. So far every indication is that we are on the right direction."
The investments: "We continue to evolve our storytelling in the digital space, and we want to make sure we are maximizing all the marketing channels."
Kristina Blahnik
Kristina Blahnik, CEO, Manolo Blahnik International
The opportunities: "It's about telling the story of Manolo and the whole legacy that he has built alongside my mother and the team around him. Part of that is 'The Art of Shoes in Residence' [retrospective] starting in Milan. We want to use that as a platform to tell the story of Manolo's creativity and his passion for shoes. We also want to tell stories through new stores: There's one opening in Japan in the Ginza area [this spring]. We want to bring more people into the world of Manolo and get them to understand who he is, what we're about and what our core values are."
The challenges: "Managing all of our diaries in terms of travel and preparing for the exhibitions. Manolo is very hands-on."
The investment: "We want to invest in people, both internally and also externally, with our partners, our wholesale accounts, our franchisees. I see it more as a community. We all have a passion that drives us. It's all about nurturing the people we work with."
Want to read more articles like this one? Subscribe to FN Today
Sponsored By Deckers
From Responsibility, Comes Opportunity
With a rich history of corporate responsibility, Deckers Brands embraces a holistic approach to doing the right thing.
From 'Star Wars' to 'Frozen,' the Best Disney Face Masks for Adults to Buy Now
In partnership with Deckers
Shop the News
11 Best-Selling Foot Peel Masks to Keep Your Feet Super Soft
14 Nail Polish Color Trends You're About to See Everywhere This Summer
OPI Funny Bunny Polish $9
The Best Dior Sneakers and Charms You Can Shop Now
Dior B23 Sneaker in Gradient Blue Dior Oblique Canvas $990
Only $24.99 for one year!
All the Brands and Retailers Helping to Get Out the Vote in November
The Best Shoe Organizers to Store Your Favorite Footwear
Here Are the Most In-Demand Jobs This Holiday Season
The Heart and Sole of the Footwear Industry
© 2021 Fairchild Publishing, LLC, a subsidiary of Penske Business Media, LLC.
FN and Footwear News are registered trademarks of Fairchild Publishing, LLC. All rights reserved.
Athletic & Outdoor
Sneakers Deals
FN Gift Guides


text:
-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Хост: localhost:8889
-- Время создания: Апр 13 2016 г., 20:44
-- Версия сервера: 5.5.42
-- Версия PHP: 5.6.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!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 utf8mb4 */;

--
-- База данных: portfolio
--

-- --------------------------------------------------------

--
-- Структура таблицы achievements
--

CREATE TABLE achievements (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  idStudent int(11) NOT NULL,
  dateEvent date NOT NULL,
  idEventType int(11) NOT NULL,
  idStatus int(11) NOT NULL,
  eventTitle varchar(512) NOT NULL,
  idDocumentType int(11) NOT NULL,
  location varchar(512) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы achievements
--

INSERT INTO achievements (id, name, idStudent, dateEvent, idEventType, idStatus, eventTitle, idDocumentType, location) VALUES
(97, 'ddss', 51, '2016-03-04', 2, 2, 'ff', 1, 'uploads/50/(lCq).png'),
(100, 'предметная олимпиада по\nинформационным системам\n«Университет будущего»', 50, '2016-03-03', 1, 2, 'dd', 1, 'uploads/50/(A1q).png'),
(104, 'предметная студенческая олимпиада\nпо физике', 50, '2016-03-03', 3, 1, 'кпкп', 1, 'uploads/50/a41a450b-6d6f-413d-a41b-68cc0bbc3f4a(0W5).jpg');

-- --------------------------------------------------------

--
-- Структура таблицы achievementsKTD
--

CREATE TABLE achievementsKTD (
  id int(11) NOT NULL,
  `name` varchar(256) DEFAULT NULL,
  idStatus int(11) DEFAULT NULL,
  idTypeContest int(11) DEFAULT NULL,
  `year` date DEFAULT NULL,
  idDocumentType int(11) NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы achievementsKTD
--

INSERT INTO achievementsKTD (id, name, idStatus, idTypeContest, year, idDocumentType, idDocument, idStudent, location) VALUES
(1, 'sds', 1, 1, '2016-04-13', 1, NULL, 50, 'uploads/50/Презентация2(usO).pptx');

-- --------------------------------------------------------

--
-- Структура таблицы achievementsPresident
--

CREATE TABLE achievementsPresident (
  id int(11) NOT NULL,
  description varchar(1024) DEFAULT NULL,
  count int(11) DEFAULT NULL,
  idDocument int(11) NOT NULL,
  idStudent int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы achievementsSport
--

CREATE TABLE achievementsSport (
  id int(11) NOT NULL,
  `name` varchar(256) DEFAULT NULL,
  idStatus int(11) DEFAULT NULL,
  idTypeContest int(11) DEFAULT NULL,
  `year` date DEFAULT NULL,
  idDocumentType int(11) NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы achievementsSport
--

INSERT INTO achievementsSport (id, name, idStatus, idTypeContest, year, idDocumentType, idDocument, idStudent, location) VALUES
(1, '(Универсиада, 1 место за бег 1 км; 2\nместо за бег с\nпрепятствиями)', 2, 3, '2016-04-01', 2, NULL, 50, 'uploads/50/portfolio(3)(XPy).sql');

-- --------------------------------------------------------

--
-- Структура таблицы activity
--

CREATE TABLE activity (
  id int(11) NOT NULL,
  `name` varchar(128) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Дамп данных таблицы activity
--

INSERT INTO activity (id, name) VALUES
(1, 'Учебная'),
(2, 'Научно-исследовательская'),
(3, 'Общественная'),
(4, 'Культурно-творческая'),
(5, 'Спортивная');

-- --------------------------------------------------------

--
-- Структура таблицы articles
--

CREATE TABLE articles (
  id int(11) NOT NULL,
  idType int(11) NOT NULL,
  `name` char(255) NOT NULL,
  `year` int(11) NOT NULL,
  idStatus int(11) NOT NULL,
  idAuthorship int(11) NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  volumePublication int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы authorship
--

CREATE TABLE authorship (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы authorship
--

INSERT INTO authorship (id, name, value) VALUES
(1, 'без соавторства', NULL),
(2, 'в соавторстве', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы cities
--

CREATE TABLE cities (
  id int(11) NOT NULL,
  `name` char(64) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы cities
--

INSERT INTO cities (id, name) VALUES
(1, 'Астрахань'),
(2, 'Москва'),
(3, 'Волгоград');

-- --------------------------------------------------------

--
-- Структура таблицы documents
--

CREATE TABLE documents (
  id int(11) NOT NULL,
  idStudent int(11) NOT NULL,
  userFileName varchar(256) NOT NULL,
  tmpFileName varchar(256) NOT NULL,
  size float NOT NULL,
  location varchar(1024) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы documents
--

INSERT INTO documents (id, idStudent, userFileName, tmpFileName, size, location) VALUES
(57, 9, '2Gorbacheva-Kharakteristika-MotPredstavlenie.docx', '/tmp/php6vccIv', 25468, 'path/2Gorbacheva-Kharakteristika-MotPredstavlenie.docx'),
(58, 9, 'home.php', '/tmp/phpk112Rc', 1557, 'path/home.php'),
(59, 9, 'mysql_diagram (1).doc', '/tmp/phpM6l64V', 315904, 'path/mysql_diagram (1).doc'),
(60, 9, '2EADC40500000578-3328701-image-a-21_1448142077752.jpg', '/tmp/phph5A4MW', 41176, 'path/2EADC40500000578-3328701-image-a-21_1448142077752.jpg'),
(61, 9, '2EADC40500000578-3328701-image-a-21_1448142077752.jpg', '/tmp/phpmtoedT', 41176, 'path/2EADC40500000578-3328701-image-a-21_1448142077752.jpg'),
(62, 9, '2EADC40500000578-3328701-image-a-21_1448142077752.jpg', '/tmp/phpPHviOW', 41176, 'path/2EADC40500000578-3328701-image-a-21_1448142077752.jpg'),
(63, 9, '7313W4QcBEk.jpg', '/tmp/phpECEGiH', 86610, 'path/7313W4QcBEk.jpg'),
(64, 9, 'full_ringattraction1.jpg', '/tmp/phpZE5Hgq', 275291, 'path/full_ringattraction1.jpg'),
(65, 9, 'pt4OS8057Bk.jpg', '/tmp/phpvucjdJ', 305923, 'path/pt4OS8057Bk.jpg'),
(66, 9, 'pt4OS8057Bk.jpg', '/tmp/phpXir3xu', 305923, 'path/pt4OS8057Bk.jpg'),
(67, 9, 'pt4OS8057Bk.jpg', '/tmp/phpgSjvuG', 305923, 'path/pt4OS8057Bk.jpg'),
(68, 9, 'pt4OS8057Bk.jpg', '/tmp/phphTnkCr', 305923, 'path/pt4OS8057Bk.jpg'),
(69, 9, 'pt4OS8057Bk.jpg', '/tmp/phpnKvDdW', 305923, 'path/pt4OS8057Bk.jpg'),
(70, 9, 'pt4OS8057Bk.jpg', '/tmp/phpET9WnC', 305923, 'path/pt4OS8057Bk.jpg'),
(71, 9, 'pt4OS8057Bk.jpg', '/tmp/phpndhom3', 305923, 'path/pt4OS8057Bk.jpg'),
(72, 9, 'full_ringattraction1.jpg', '/tmp/phpoE90ME', 275291, 'path/full_ringattraction1.jpg'),
(73, 9, 'pt4OS8057Bk.jpg', '/tmp/phpRNrFvq', 305923, 'path/pt4OS8057Bk.jpg'),
(74, 9, 'pt4OS8057Bk.jpg', '/tmp/phpz2Qkko', 305923, 'path/pt4OS8057Bk.jpg'),
(75, 9, 'pt4OS8057Bk.jpg', '/tmp/phpKdFKaj', 305923, 'path/pt4OS8057Bk.jpg'),
(76, 9, 'pt4OS8057Bk.jpg', '/tmp/phptSP7kd', 305923, 'path/pt4OS8057Bk.jpg'),
(77, 9, 'pt4OS8057Bk.jpg', '/tmp/phpIoEPOu', 305923, 'path/pt4OS8057Bk.jpg'),
(78, 9, 'pt4OS8057Bk.jpg', '/tmp/phpOeKxRx', 305923, 'path/pt4OS8057Bk.jpg'),
(79, 9, 'pt4OS8057Bk.jpg', '/tmp/phpmez0n7', 305923, 'path/pt4OS8057Bk.jpg'),
(80, 9, 'pt4OS8057Bk.jpg', '/tmp/phpUl94ac', 305923, 'path/pt4OS8057Bk.jpg'),
(81, 9, 'full_ringattraction1.jpg', '/tmp/php8bU8o2', 275291, 'path/full_ringattraction1.jpg'),
(82, 9, 'full_ringattraction1.jpg', '/tmp/phpVm9uPa', 275291, 'path/full_ringattraction1.jpg'),
(83, 9, 'full_ringattraction1.jpg', '/tmp/phpdD1rKp', 275291, 'path/full_ringattraction1.jpg'),
(84, 9, 'full_ringattraction1.jpg', '/tmp/phpoz7YXZ', 275291, 'path/full_ringattraction1.jpg'),
(85, 9, 'pt4OS8057Bk.jpg', '/tmp/php1B0iSg', 305923, 'path/pt4OS8057Bk.jpg'),
(86, 9, 'pt4OS8057Bk.jpg', '/tmp/phpIirtOy', 305923, 'path/pt4OS8057Bk.jpg'),
(87, 9, 'full_ringattraction1.jpg', '/tmp/phpNiZSZV', 275291, 'path/full_ringattraction1.jpg'),
(88, 9, 'full_ringattraction1.jpg', '/tmp/phpvzr436', 275291, 'path/full_ringattraction1.jpg'),
(89, 9, 'full_ringattraction1.jpg', '/tmp/phpGWFW55', 275291, 'path/full_ringattraction1.jpg'),
(90, 9, 'full_ringattraction1.jpg', '/tmp/php9IRGl0', 275291, 'path/full_ringattraction1.jpg'),
(91, 9, 'full_ringattraction1.jpg', '/tmp/phpIzVH2M', 275291, 'path/full_ringattraction1.jpg'),
(92, 9, 'pt4OS8057Bk.jpg', '/tmp/phpQ0Zo9o', 305923, 'path/pt4OS8057Bk.jpg'),
(93, 9, 'full_ringattraction1.jpg', '/tmp/phpUA2mX5', 275291, 'path/full_ringattraction1.jpg'),
(94, 9, 'pt4OS8057Bk.jpg', '/tmp/phpiHjBNu', 305923, 'path/pt4OS8057Bk.jpg'),
(95, 9, 'full_ringattraction1.jpg', '/tmp/php8JATKv', 275291, 'path/full_ringattraction1.jpg'),
(96, 9, 'pt4OS8057Bk.jpg', '/tmp/phpBmff5b', 305923, 'path/pt4OS8057Bk.jpg'),
(97, 9, 'full_ringattraction1.jpg', '/tmp/php44b1HW', 275291, 'path/full_ringattraction1.jpg'),
(98, 9, 'full_ringattraction1.jpg', '/tmp/phptb9ojT', 275291, 'path/full_ringattraction1.jpg'),
(99, 9, 'full_ringattraction1.jpg', '/tmp/phphkNn4L', 275291, 'path/full_ringattraction1.jpg'),
(100, 9, 'full_ringattraction1.jpg', '/tmp/phpagpZGC', 275291, 'path/full_ringattraction1.jpg'),
(101, 9, 'pt4OS8057Bk.jpg', '/tmp/phpqfwdqJ', 305923, 'path/pt4OS8057Bk.jpg'),
(102, 9, 'full_ringattraction1.jpg', '/tmp/phpXVP4t4', 275291, 'path/full_ringattraction1.jpg'),
(103, 9, 'pt4OS8057Bk.jpg', '/tmp/phpowpPsz', 305923, 'path/pt4OS8057Bk.jpg'),
(104, 9, 'pt4OS8057Bk.jpg', '/tmp/phpRtSlFd', 305923, 'path/pt4OS8057Bk.jpg'),
(105, 9, 'pt4OS8057Bk.jpg', '/tmp/phpvVXKUE', 305923, 'path/pt4OS8057Bk.jpg'),
(106, 9, 'pt4OS8057Bk.jpg', '/tmp/phpcgF2wt', 305923, 'path/pt4OS8057Bk.jpg'),
(107, 9, 'full_ringattraction1.jpg', '/tmp/phpgdskHU', 275291, 'path/full_ringattraction1.jpg'),
(108, 9, 'full_ringattraction1.jpg', '/tmp/php867W5Z', 275291, 'path/full_ringattraction1.jpg'),
(109, 9, 'full_ringattraction1.jpg', '/tmp/phprkPzVC', 275291, 'path/full_ringattraction1.jpg'),
(110, 9, 'full_ringattraction1.jpg', '/tmp/phpdO8mLt', 275291, 'path/full_ringattraction1.jpg'),
(111, 9, 'full_ringattraction1.jpg', '/tmp/phpIxDy5F', 275291, 'path/full_ringattraction1.jpg'),
(112, 9, 'full_ringattraction1.jpg', '/tmp/phpR0OxN3', 275291, 'path/full_ringattraction1.jpg');

-- --------------------------------------------------------

--
-- Структура таблицы educationLevel
--

CREATE TABLE educationLevel (
  id int(11) NOT NULL,
  `name` varchar(256) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Дамп данных таблицы educationLevel
--

INSERT INTO educationLevel (id, name) VALUES
(0, 'бакалавр');

-- --------------------------------------------------------

--
-- Структура таблицы eventType
--

CREATE TABLE eventType (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы eventType
--

INSERT INTO eventType (id, name, value) VALUES
(1, 'олимпиада', 10),
(2, 'соревнование', 5),
(3, 'программа', 2);

-- --------------------------------------------------------

--
-- Структура таблицы facultet
--

CREATE TABLE facultet (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  idUniversity int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы facultet
--

INSERT INTO facultet (id, name, idUniversity) VALUES
(1, 'физико-технический', 1),
(2, 'математики и информационных технологий', 1),
(3, 'социальных коммуникаций', 1),
(4, 'механико–математический', 3),
(5, 'химический', 3);

-- --------------------------------------------------------

--
-- Структура таблицы grantType
--

CREATE TABLE grantType (
  id int(11) NOT NULL,
  `name` char(128) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Дамп данных таблицы grantType
--

INSERT INTO grantType (id, name) VALUES
(2, 'Исполнитель'),
(3, 'Руководитель');

-- --------------------------------------------------------

--
-- Структура таблицы grants
--

CREATE TABLE `grants` (
  id int(11) NOT NULL,
  nameProject varchar(512) DEFAULT NULL,
  nameOrganization varchar(512) DEFAULT NULL,
  typeGrant int(11) NOT NULL,
  dateBegin date DEFAULT NULL,
  dateEnd date DEFAULT NULL,
  regNumberCitis char(128) DEFAULT NULL,
  regNumber char(128) DEFAULT NULL,
  idTypeContest int(11) DEFAULT NULL,
  idScienceDirection int(11) DEFAULT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы grants
--

INSERT INTO grants (id, nameProject, nameOrganization, typeGrant, dateBegin, dateEnd, regNumberCitis, regNumber, idTypeContest, idScienceDirection, idDocument, idStudent, location) VALUES
(1, 'Грант', 'АГК', 2, '2016-04-01', '2016-04-06', '123', '345', 1, 1, NULL, 50, 'uploads/50/Презентация2(HSM).pdf');

-- --------------------------------------------------------

--
-- Структура таблицы ktdParticipation
--

CREATE TABLE ktdParticipation (
  id int(11) NOT NULL,
  description varchar(1024) DEFAULT NULL,
  count int(11) DEFAULT NULL,
  `date` date NOT NULL,
  location varchar(512) NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  idStatus int(11) DEFAULT NULL,
  idLevel int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы languages
--

CREATE TABLE languages (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы level
--

CREATE TABLE `level` (
  id int(11) NOT NULL,
  `name` char(128) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы migration
--

CREATE TABLE migration (
  version varchar(180) NOT NULL,
  apply_time int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы migration
--

INSERT INTO migration (version, apply_time) VALUES
('m000000_000000_base', 1456829141),
('m130524_201442_init', 1456829163);

-- --------------------------------------------------------

--
-- Структура таблицы napravlenie
--

CREATE TABLE napravlenie (
  id int(11) NOT NULL,
  shifr char(128) NOT NULL,
  `name` char(128) NOT NULL,
  idFacultet int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы napravlenie
--

INSERT INTO napravlenie (id, shifr, name, idFacultet) VALUES
(1, '03.03.02', 'Физика', 1),
(2, '15.03.01', 'Машиностроение', 1),
(3, '01.03.02', 'Прикладная математика и информатика', 2),
(4, '10.03.01', 'Информационная безопасность', 2),
(5, '01.05.01', 'Фундаментальная математика и механика', 4),
(6, '04.05.01', 'Фундаментальная и прикладная химия', 5),
(12, '22.03.01', 'Материаловедение и технологии материалов', 1),
(13, '22.03.01', 'Материаловедение и технологии материалов', 1),
(14, '15.03.06', 'Мехотроника и робототехника', 1),
(15, '15.03.06', 'Машиностроение', 1);

-- --------------------------------------------------------

--
-- Структура таблицы patents
--

CREATE TABLE patents (
  id int(11) NOT NULL,
  `name` varchar(512) DEFAULT NULL,
  idTypePatent int(11) DEFAULT NULL,
  copyrightHolder varchar(512) DEFAULT NULL,
  description varchar(1024) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  dateApp date DEFAULT NULL,
  dateReg date DEFAULT NULL,
  regNumber int(11) DEFAULT NULL,
  appNumber int(11) DEFAULT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы patents
--

INSERT INTO patents (id, name, idTypePatent, copyrightHolder, description, status, dateApp, dateReg, regNumber, appNumber, idDocument, idStudent, location) VALUES
(1, 'Информационная система "Учебные планы"', 1, 'ФГБОУ ВО "АГУ"', 'sadad', 1, '2016-03-02', '2016-03-10', 12345678, 9876543, NULL, 50, '');

-- --------------------------------------------------------

--
-- Структура таблицы publicPerformance
--

CREATE TABLE publicPerformance (
  id int(11) NOT NULL,
  `name` varchar(256) DEFAULT NULL,
  idStatus int(11) DEFAULT NULL,
  idTypePublicPerformance int(11) DEFAULT NULL,
  `year` date DEFAULT NULL,
  idDocumentType int(11) NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы publicPerformance
--

INSERT INTO publicPerformance (id, name, idStatus, idTypePublicPerformance, year, idDocumentType, idDocument, idStudent, location) VALUES
(1, 'ыпреолргшж', 1, 1, '0000-00-00', 1, 86, 9, ''),
(2, 'олк', 1, 2, '2016-03-01', 1, NULL, 47, ''),
(3, '5кам', 2, 4, '2016-03-02', 1, NULL, 47, 'uploads/composer.json'),
(4, 'выступления с 1 музыкально-\r\nдраматическим произведением\r\n«В мире музыки» (музыкальная\r\nгостиная в Астраханском\r\nмузыкальном училище', 1, 3, '2016-03-31', 1, NULL, 50, 'uploads/50/Презентация2(bOA).pdf');

-- --------------------------------------------------------

--
-- Структура таблицы scienceDirection
--

CREATE TABLE scienceDirection (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы scienceDirection
--

INSERT INTO scienceDirection (id, name, value) VALUES
(1, 'Безопасность и противодействие терроризму', NULL),
(2, 'Индустрия наносистем', NULL),
(3, 'Информационно-телекоммуникационные системы', NULL),
(4, 'Науки о жизни', NULL),
(5, 'Перспективные  виды  вооружения,  военной   и   специальной\r\nтехники', NULL),
(6, 'Рациональное природопользование', NULL),
(7, 'Робототехнические     комплексы    (системы)    военного,\r\nспециального и двойного назначения', NULL),
(8, 'Транспортные и космические системы', NULL),
(9, 'Энергоэффективность, энергосбережение, ядерная энергетика', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы sgroup
--

CREATE TABLE sgroup (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  idNapravlenie int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы sgroup
--

INSERT INTO sgroup (id, name, idNapravlenie) VALUES
(1, 'ЗИ', 4),
(2, 'ОП-11', 13),
(3, 'ХИ', 5),
(4, 'ыв', 15);

-- --------------------------------------------------------

--
-- Структура таблицы socialParticipation
--

CREATE TABLE socialParticipation (
  id int(11) NOT NULL,
  idSocialParticipationType int(11) DEFAULT NULL,
  description varchar(1024) DEFAULT NULL,
  count int(11) DEFAULT NULL,
  `date` date NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы socialParticipation
--

INSERT INTO socialParticipation (id, idSocialParticipationType, description, count, date, idDocument, idStudent, location) VALUES
(17, 1, 'акция «Подари улыбку детям»', 1, '2016-04-05', NULL, 50, 'uploads/50/Отчет_НИП_(1)_(Восстановлен)(siQ).doc');

-- --------------------------------------------------------

--
-- Структура таблицы sotrudnik
--

CREATE TABLE sotrudnik (
  idSotrudnik int(11) NOT NULL,
  secondName char(64) NOT NULL,
  firstName char(64) NOT NULL,
  midleName char(64) NOT NULL,
  idCity int(11) DEFAULT NULL,
  idUniversity int(11) DEFAULT NULL,
  idFacultet int(11) DEFAULT NULL,
  dolzn char(64) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы sotrudnik
--

INSERT INTO sotrudnik (idSotrudnik, secondName, firstName, midleName, idCity, idUniversity, idFacultet, dolzn) VALUES
(48, 'Галлагер', 'Феона', 'Френковна', 1, 1, 1, '???????');

-- --------------------------------------------------------

--
-- Структура таблицы sportParticipation
--

CREATE TABLE sportParticipation (
  id int(11) NOT NULL,
  description varchar(1024) DEFAULT NULL,
  count int(11) DEFAULT NULL,
  `date` date NOT NULL,
  idDocument int(11) DEFAULT NULL,
  idStudent int(11) NOT NULL,
  location varchar(512) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы sportParticipation
--

INSERT INTO sportParticipation (id, description, count, date, idDocument, idStudent, location) VALUES
(1, 'kkjlj;k', 9, '2016-04-05', 96, 50, ''),
(2, '3dde', 3, '2013-03-26', NULL, 50, 'uploads/yii.bat');

-- --------------------------------------------------------

--
-- Структура таблицы st
--

CREATE TABLE st (
  idStudent int(11) DEFAULT NULL,
  secondName char(64) NOT NULL,
  firstName char(64) NOT NULL,
  midleName char(64) NOT NULL,
  idCity int(11) DEFAULT NULL,
  idUniversity int(11) DEFAULT NULL,
  idFacultet int(11) DEFAULT NULL,
  idLevel int(11) DEFAULT NULL,
  kurs int(11) DEFAULT NULL,
  idNapravlenie int(11) DEFAULT NULL,
  idGroup int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы statusEvent
--

CREATE TABLE statusEvent (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы statusEvent
--

INSERT INTO statusEvent (id, name, value) VALUES
(1, 'международное', 10),
(2, 'всероссийское', 5),
(3, 'региональное', NULL),
(4, 'ведомственное', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы statusPatent
--

CREATE TABLE statusPatent (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы statusPatent
--

INSERT INTO statusPatent (id, name, value) VALUES
(1, 'Отправлена заявка', NULL),
(2, 'Получен сертификат', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы studentRating
--

CREATE TABLE studentRating (
  id int(11) NOT NULL,
  idStudent int(11) NOT NULL,
  idActivity int(11) NOT NULL,
  r1 double NOT NULL,
  r2 double NOT NULL,
  r3 double NOT NULL,
  `status` int(11) NOT NULL,
  mark int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Дамп данных таблицы studentRating
--

INSERT INTO studentRating (id, idStudent, idActivity, r1, r2, r3, status, mark) VALUES
(12, 51, 5, 0, 0, 0, 1, 60),
(26, 50, 1, 1.875, 0, 0, 1, 90),
(30, 50, 3, 0.5, 0, 0, 1, 90);

-- --------------------------------------------------------

--
-- Структура таблицы students
--

CREATE TABLE students (
  idStudent int(11) NOT NULL,
  secondName char(64) CHARACTER SET utf8 NOT NULL,
  firstName char(64) CHARACTER SET utf8 NOT NULL,
  midleName char(64) CHARACTER SET utf8 NOT NULL,
  idCity int(11) DEFAULT NULL,
  idUniversity int(11) DEFAULT NULL,
  idFacultet int(11) DEFAULT NULL,
  idLevel int(11) DEFAULT NULL,
  kurs int(11) DEFAULT NULL,
  idNapravlenie int(11) DEFAULT NULL,
  idGroup int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Дамп данных таблицы students
--

INSERT INTO students (idStudent, secondName, firstName, midleName, idCity, idUniversity, idFacultet, idLevel, kurs, idNapravlenie, idGroup) VALUES
(50, 'Васильева', 'Маргарита', 'Ивановвава', 1, 1, 1, 0, 1, 1, 2),
(51, 'Иванов', 'Алексей', 'Сергеевич', 1, 1, 1, 0, 1, 1, 1);

-- --------------------------------------------------------

--
-- Структура таблицы students1
--

CREATE TABLE students1 (
  id int(11) NOT NULL,
  secondName char(64) DEFAULT NULL,
  firstName char(64) DEFAULT NULL,
  midleName char(64) DEFAULT NULL,
  idCity int(11) DEFAULT NULL,
  idUniversity int(11) DEFAULT NULL,
  idFacultet int(11) DEFAULT NULL,
  idNapravlenie int(11) DEFAULT NULL,
  idGroup int(11) DEFAULT NULL,
  email char(64) NOT NULL,
  `password` char(64) NOT NULL,
  registrationCode char(64) DEFAULT NULL,
  login int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы students1
--

INSERT INTO students1 (id, secondName, firstName, midleName, idCity, idUniversity, idFacultet, idNapravlenie, idGroup, email, password, registrationCode, login, status) VALUES
(9, 'Петрова', 'Иван', 'Иванович', 1, 1, 2, 3, NULL, 'qwaszx@gmail.com', '376c43878878ac04e05946ec1dd7a55f', '', 0, 0),
(47, 'Алехин', 'Михаил', 'Владимирович', 2, 3, 4, 5, 3, 'a1@gmail.com', '$2y$13$6zOM.ekj38y64VKR.Nj1FubPN.aXV36wzsMPVmuliXWVeHa4b9FWS', NULL, NULL, NULL),
(48, 'Петрова', 'София', 'Владимировна', 1, 1, 1, 1, 2, 'a2@gmail.com', 'qwaszx', NULL, NULL, NULL),
(49, 'Овсяенко', 'Маргарита', 'Алексеевна', 1, 1, 1, 1, 2, 'a3@gmail.com', '$2y$13$w/gcArQ6hbsWuUlVKMM/4.KQwXDx9EhgJMAoxvlwFBB8/aQynn7X2', NULL, NULL, NULL),
(50, 'Иванов', 'София', 'DFHGHL', 1, 1, 1, 1, 2, 'a4@gmail.com', '$2y$13$RujcYERNnsdHSRc8IYYOMOodYJutQTGyaI3BlKX4sYQ/mO5m4NgOO', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Структура таблицы typeArticle
--

CREATE TABLE typeArticle (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы typeArticle
--

INSERT INTO typeArticle (id, name, value) VALUES
(1, 'статья в журнале', 90),
(2, 'тезисы докладов', 70);

-- --------------------------------------------------------

--
-- Структура таблицы typeContest
--

CREATE TABLE typeContest (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы typeContest
--

INSERT INTO typeContest (id, name, value) VALUES
(1, 'Издание монографии, учебника и т.д.', NULL),
(2, 'Инициативные проекты', NULL),
(3, 'Ориентированные фундаментальные исследования', NULL),
(4, 'Проведение конференции', NULL),
(5, 'Участие в конференции', NULL),
(6, 'Формирование тематики', NULL),
(7, 'Прочее', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы typeDocument
--

CREATE TABLE typeDocument (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы typeDocument
--

INSERT INTO typeDocument (id, name, value) VALUES
(1, 'диплом 1 степени', 10),
(2, 'диплом 2 степени', 5);

-- --------------------------------------------------------

--
-- Структура таблицы typeParticipant
--

CREATE TABLE typeParticipant (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы typePatent
--

CREATE TABLE typePatent (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы typePatent
--

INSERT INTO typePatent (id, name, value) VALUES
(1, 'Изобретения', NULL),
(2, 'Полезные модели', NULL),
(3, 'Промышленные образцы', NULL),
(4, 'База данных', NULL),
(5, 'Наименование места происхождения товара', NULL),
(6, 'Программа для ЭВМ', NULL),
(7, 'Товарные знаки и знаки обслуживания', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы typePublicPerformance
--

CREATE TABLE typePublicPerformance (
  id int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы typePublicPerformance
--

INSERT INTO typePublicPerformance (id, name, value) VALUES
(1, 'литературное произведение', NULL),
(2, 'драматическое произведение', NULL),
(3, 'музыкально-драматическое произведение', NULL),
(4, 'сценарное произведение', NULL),
(5, 'хореографическое произведение', NULL),
(6, 'пантомимы', NULL),
(7, 'музыкальное произведение с текстом или\r\nбез текста', NULL),
(8, 'аудиовизуальное произведение', NULL),
(9, 'произведения живописи', NULL),
(10, 'скульптуры', NULL),
(11, 'графика', NULL),
(12, 'дизайн', NULL),
(13, 'графический рассказ', NULL),
(14, 'комикс', NULL),
(15, 'другое произведение изобразительного\r\nискусства', NULL),
(16, 'произведение декоративно-прикладного\r\nискусства', NULL),
(17, 'сценографическое искусство', NULL),
(18, 'произведение архитектуры', NULL),
(19, 'градостроительство', NULL),
(20, 'садово-парковое искусство', NULL),
(21, 'проект', NULL),
(22, 'чертеж', NULL),
(23, 'изображения', NULL),
(24, 'макета', NULL),
(25, 'фотографическое произведение', NULL),
(26, 'произведение, полученное способом,\r\nаналогичным фотографии', NULL),
(27, 'географическая карта', NULL),
(28, 'геологическая карта', NULL),
(29, 'другая карта', NULL),
(30, 'план', NULL),
(31, 'эскиз', NULL),
(32, 'пластическое произведение, относящееся к\r\nгеографии', NULL),
(33, 'пластическое произведение, относящееся к\r\nтопографии', NULL),
(34, 'пластическое произведение, относящееся к\r\nдругим наукам', NULL),
(35, 'другое произведение', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы typeSocialParticipation
--

CREATE TABLE typeSocialParticipation (
  id int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы typeSocialParticipation
--

INSERT INTO typeSocialParticipation (id, name, value) VALUES
(1, 'Социально ориентированные, культурные\r\n(культурно-просветительские, культурно-\r\nвоспитательные) деятельности в форме\r\nшефской помощи, благотворительных акций и\r\nиных подобных формах', NULL),
(2, 'Общественная\r\nдеятельность, направленная на пропаганду\r\nобщечеловеческих ценностей, уважения к\r\nправам и свободам человека, а также на защиту\r\nприроды', NULL),
(3, 'Общественно значимые культурно-массовые\r\nмероприятия', NULL),
(4, 'Деятельности по информационному\nобеспечению общественно значимых\nмероприятий, общественной жизни учреждения\nвысшего профессионального образования (в\nразработке сайта учреждения высшего\nпрофессионального образования, организации и\nобеспечении деятельн', NULL),
(5, 'Деятельность по информационному\nобеспечению общественно значимых\nмероприятий, общественной жизни учреждения\nвысшего профессионального образования ', NULL);

-- --------------------------------------------------------

--
-- Структура таблицы universities
--

CREATE TABLE universities (
  id int(11) NOT NULL,
  `name` char(128) NOT NULL,
  idCity int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы universities
--

INSERT INTO universities (id, name, idCity) VALUES
(1, 'Астраханский государственный университет', 1),
(2, 'Астраханский Государственный Технический Университет', 1),
(3, 'Московский государственный университет', 2),
(4, 'Московский гуманитарный университет', 2),
(5, 'Волгоградский государственный университет', 3),
(6, 'Волгоградский государственный технический университет', 3);

-- --------------------------------------------------------

--
-- Структура таблицы user
--

CREATE TABLE `user` (
  id int(11) NOT NULL,
  email varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  password_hash varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  role int(11) NOT NULL,
  auth_key varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  password_reset_token varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  created_at int(11) NOT NULL,
  updated_at int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Дамп данных таблицы user
--

INSERT INTO user (id, email, password_hash, role, auth_key, password_reset_token, status, created_at, updated_at) VALUES
(48, 'fmiit@gmail.com', '$2y$13$HRqXBDrJNXULUrr11uFxS./S0zZ2/gw0NizIMMDsLseKcEmppGE5O', 15, '', NULL, 10, 0, 0),
(50, 'a@gmail.com', '$2y$13$bM3JzRPrVtIJRaVuQGAzBuQPGtYlYtDm/7iUYs8FKu8mWvFOnyHl6', 10, '', NULL, 10, 0, 0),
(51, 'kjsjc', 'dfdf', 10, '', NULL, 10, 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы value
--

CREATE TABLE `value` (
  id int(11) NOT NULL,
  `name` varchar(256) NOT NULL,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы value
--

INSERT INTO value (id, name, value) VALUES
(1, 'грант', 90),
(2, 'патент', 80);

-- --------------------------------------------------------

--
-- Структура таблицы valuesRating
--

CREATE TABLE valuesRating (
  id int(11) NOT NULL,
  idFacultet int(11) NOT NULL,
  idTable int(11) NOT NULL,
  idItem int(11) NOT NULL,
  `value` double DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Дамп данных таблицы valuesRating
--

INSERT INTO valuesRating (id, idFacultet, idTable, idItem, value) VALUES
(22, 1, 2, 1, 0.5),
(23, 1, 2, 2, 1.5),
(24, 1, 2, 3, 2.5),
(25, 1, 1, 1, 2),
(26, 1, 1, 2, 1.5),
(27, 1, 1, 3, 1),
(28, 1, 1, 4, 0.5),
(29, 1, 3, 1, 0.5),
(30, 1, 3, 2, 1.5);

--
-- Индексы сохранённых таблиц
--

--
-- Индексы таблицы achievements
--
ALTER TABLE achievements
  ADD PRIMARY KEY (id),
  ADD KEY idStudent (idStudent),
  ADD KEY idEventType (idEventType),
  ADD KEY idStatus (idStatus),
  ADD KEY idDocumentType (idDocumentType);

--
-- Индексы таблицы achievementsKTD
--
ALTER TABLE achievementsKTD
  ADD PRIMARY KEY (id),
  ADD KEY idStatus (idStatus),
  ADD KEY idTypeContest (idTypeContest),
  ADD KEY idDocumentType (idDocumentType),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы achievementsPresident
--
ALTER TABLE achievementsPresident
  ADD PRIMARY KEY (id),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы achievementsSport
--
ALTER TABLE achievementsSport
  ADD PRIMARY KEY (id),
  ADD KEY idStatus (idStatus),
  ADD KEY idTypeContest (idTypeContest),
  ADD KEY idDocumentType (idDocumentType),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы activity
--
ALTER TABLE activity
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы articles
--
ALTER TABLE articles
  ADD PRIMARY KEY (id),
  ADD KEY idType (idType),
  ADD KEY idStatus (idStatus),
  ADD KEY idAuthorship (idAuthorship),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы authorship
--
ALTER TABLE authorship
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы cities
--
ALTER TABLE cities
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы documents
--
ALTER TABLE documents
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы educationLevel
--
ALTER TABLE educationLevel
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы eventType
--
ALTER TABLE eventType
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы facultet
--
ALTER TABLE facultet
  ADD PRIMARY KEY (id),
  ADD KEY idUniversity (idUniversity);

--
-- Индексы таблицы grantType
--
ALTER TABLE grantType
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы grants
--
ALTER TABLE grants
  ADD PRIMARY KEY (id),
  ADD KEY idTypeContest (idTypeContest),
  ADD KEY idScienceDirection (idScienceDirection),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent),
  ADD KEY typeGrant (typeGrant);

--
-- Индексы таблицы ktdParticipation
--
ALTER TABLE ktdParticipation
  ADD PRIMARY KEY (id),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы languages
--
ALTER TABLE languages
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы level
--
ALTER TABLE level
  ADD PRIMARY KEY (id),
  ADD UNIQUE KEY id (id);

--
-- Индексы таблицы migration
--
ALTER TABLE migration
  ADD PRIMARY KEY (version);

--
-- Индексы таблицы napravlenie
--
ALTER TABLE napravlenie
  ADD PRIMARY KEY (id),
  ADD KEY idFacultet (idFacultet);

--
-- Индексы таблицы patents
--
ALTER TABLE patents
  ADD PRIMARY KEY (id),
  ADD KEY idTypePatent (idTypePatent),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent),
  ADD KEY `status` (`status`);

--
-- Индексы таблицы publicPerformance
--
ALTER TABLE publicPerformance
  ADD PRIMARY KEY (id),
  ADD KEY idStatus (idStatus),
  ADD KEY idTypePublicPerformance (idTypePublicPerformance),
  ADD KEY idDocumentType (idDocumentType),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы scienceDirection
--
ALTER TABLE scienceDirection
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы sgroup
--
ALTER TABLE sgroup
  ADD PRIMARY KEY (id),
  ADD KEY idNapravlenie (idNapravlenie);

--
-- Индексы таблицы socialParticipation
--
ALTER TABLE socialParticipation
  ADD PRIMARY KEY (id),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы sotrudnik
--
ALTER TABLE sotrudnik
  ADD PRIMARY KEY (idSotrudnik),
  ADD KEY idCity (idCity),
  ADD KEY idUniversity (idUniversity),
  ADD KEY idFacultet (idFacultet);

--
-- Индексы таблицы sportParticipation
--
ALTER TABLE sportParticipation
  ADD PRIMARY KEY (id),
  ADD KEY idDocument (idDocument),
  ADD KEY idStudent (idStudent);

--
-- Индексы таблицы st
--
ALTER TABLE st
  ADD KEY idCity (idCity),
  ADD KEY idLevel (idLevel),
  ADD KEY idStudent (idStudent),
  ADD KEY idFacultet (idFacultet),
  ADD KEY idNapravlenie (idNapravlenie),
  ADD KEY idGroup (idGroup);

--
-- Индексы таблицы statusEvent
--
ALTER TABLE statusEvent
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы statusPatent
--
ALTER TABLE statusPatent
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы studentRating
--
ALTER TABLE studentRating
  ADD PRIMARY KEY (id),
  ADD KEY idStudent (idStudent),
  ADD KEY idActivity (idActivity);

--
-- Индексы таблицы students
--
ALTER TABLE students
  ADD PRIMARY KEY (idStudent),
  ADD KEY idCity (idCity),
  ADD KEY idLevel (idLevel),
  ADD KEY idFacultet (idFacultet),
  ADD KEY idNapravlenie (idNapravlenie),
  ADD KEY idGroup (idGroup),
  ADD KEY idUniversity (idUniversity);

--
-- Индексы таблицы students1
--
ALTER TABLE students1
  ADD PRIMARY KEY (id),
  ADD KEY idCity (idCity),
  ADD KEY idUniversity (idUniversity),
  ADD KEY idFacultet (idFacultet),
  ADD KEY idNapravlenie (idNapravlenie),
  ADD KEY idGroup (idGroup);

--
-- Индексы таблицы typeArticle
--
ALTER TABLE typeArticle
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы typeContest
--
ALTER TABLE typeContest
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы typeDocument
--
ALTER TABLE typeDocument
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы typeParticipant
--
ALTER TABLE typeParticipant
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы typePatent
--
ALTER TABLE typePatent
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы typePublicPerformance
--
ALTER TABLE typePublicPerformance
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы typeSocialParticipation
--
ALTER TABLE typeSocialParticipation
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы universities
--
ALTER TABLE universities
  ADD PRIMARY KEY (id),
  ADD KEY idCity (idCity);

--
-- Индексы таблицы user
--
ALTER TABLE user
  ADD PRIMARY KEY (id),
  ADD UNIQUE KEY email (email),
  ADD UNIQUE KEY password_reset_token (password_reset_token);

--
-- Индексы таблицы value
--
ALTER TABLE value
  ADD PRIMARY KEY (id);

--
-- Индексы таблицы valuesRating
--
ALTER TABLE valuesRating
  ADD PRIMARY KEY (id),
  ADD KEY idFacultet (idFacultet);

--
-- AUTO_INCREMENT для сохранённых таблиц
--

--
-- AUTO_INCREMENT для таблицы achievements
--
ALTER TABLE achievements
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=107;
--
-- AUTO_INCREMENT для таблицы achievementsKTD
--
ALTER TABLE achievementsKTD
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для таблицы achievementsPresident
--
ALTER TABLE achievementsPresident
  MODIFY id int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы achievementsSport
--
ALTER TABLE achievementsSport
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для таблицы activity
--
ALTER TABLE activity
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT для таблицы articles
--
ALTER TABLE articles
  MODIFY id int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы authorship
--
ALTER TABLE authorship
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы cities
--
ALTER TABLE cities
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT для таблицы documents
--
ALTER TABLE documents
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=113;
--
-- AUTO_INCREMENT для таблицы eventType
--
ALTER TABLE eventType
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT для таблицы facultet
--
ALTER TABLE facultet
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT для таблицы grantType
--
ALTER TABLE grantType
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT для таблицы grants
--
ALTER TABLE grants
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для таблицы ktdParticipation
--
ALTER TABLE ktdParticipation
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT для таблицы languages
--
ALTER TABLE languages
  MODIFY id int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы level
--
ALTER TABLE level
  MODIFY id int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы napravlenie
--
ALTER TABLE napravlenie
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT для таблицы patents
--
ALTER TABLE patents
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT для таблицы publicPerformance
--
ALTER TABLE publicPerformance
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT для таблицы scienceDirection
--
ALTER TABLE scienceDirection
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT для таблицы sgroup
--
ALTER TABLE sgroup
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT для таблицы socialParticipation
--
ALTER TABLE socialParticipation
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT для таблицы sportParticipation
--
ALTER TABLE sportParticipation
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT для таблицы statusEvent
--
ALTER TABLE statusEvent
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT для таблицы statusPatent
--
ALTER TABLE statusPatent
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы studentRating
--
ALTER TABLE studentRating
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT для таблицы typeArticle
--
ALTER TABLE typeArticle
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы typeContest
--
ALTER TABLE typeContest
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT для таблицы typeDocument
--
ALTER TABLE typeDocument
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы typeParticipant
--
ALTER TABLE typeParticipant
  MODIFY id int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT для таблицы typePatent
--
ALTER TABLE typePatent
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT для таблицы typePublicPerformance
--
ALTER TABLE typePublicPerformance
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT для таблицы typeSocialParticipation
--
ALTER TABLE typeSocialParticipation
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT для таблицы universities
--
ALTER TABLE universities
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT для таблицы user
--
ALTER TABLE user
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;
--
-- AUTO_INCREMENT для таблицы value
--
ALTER TABLE value
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT для таблицы valuesRating
--
ALTER TABLE valuesRating
  MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31;
--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы achievements
--
ALTER TABLE achievements
  ADD CONSTRAINT achievements_ibfk_1 FOREIGN KEY (idStudent) REFERENCES students (idStudent) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT achievements_ibfk_2 FOREIGN KEY (idEventType) REFERENCES eventType (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievements_ibfk_3 FOREIGN KEY (idStatus) REFERENCES statusEvent (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievements_ibfk_4 FOREIGN KEY (idDocumentType) REFERENCES typeDocument (id) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы achievementsKTD
--
ALTER TABLE achievementsKTD
  ADD CONSTRAINT achievementsKTD_ibfk_1 FOREIGN KEY (idStatus) REFERENCES statusEvent (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievementsKTD_ibfk_2 FOREIGN KEY (idTypeContest) REFERENCES eventType (id),
  ADD CONSTRAINT achievementsKTD_ibfk_3 FOREIGN KEY (idDocumentType) REFERENCES typeDocument (id),
  ADD CONSTRAINT achievementsKTD_ibfk_4 FOREIGN KEY (idDocument) REFERENCES documents (id),
  ADD CONSTRAINT achievementsKTD_ibfk_5 FOREIGN KEY (idStudent) REFERENCES students (idStudent) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы achievementsPresident
--
ALTER TABLE achievementsPresident
  ADD CONSTRAINT achievementsPresident_ibfk_1 FOREIGN KEY (idDocument) REFERENCES documents (id),
  ADD CONSTRAINT achievementsPresident_ibfk_2 FOREIGN KEY (idStudent) REFERENCES students1 (id);

--
-- Ограничения внешнего ключа таблицы achievementsSport
--
ALTER TABLE achievementsSport
  ADD CONSTRAINT achievementsSport_ibfk_1 FOREIGN KEY (idStatus) REFERENCES statusEvent (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievementsSport_ibfk_2 FOREIGN KEY (idTypeContest) REFERENCES eventType (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievementsSport_ibfk_3 FOREIGN KEY (idDocumentType) REFERENCES typeDocument (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievementsSport_ibfk_4 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT achievementsSport_ibfk_5 FOREIGN KEY (idStudent) REFERENCES students (idStudent) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы articles
--
ALTER TABLE articles
  ADD CONSTRAINT articles_ibfk_1 FOREIGN KEY (idType) REFERENCES typeArticle (id) ON UPDATE CASCADE,
  ADD CONSTRAINT articles_ibfk_2 FOREIGN KEY (idStatus) REFERENCES statusEvent (id) ON UPDATE CASCADE,
  ADD CONSTRAINT articles_ibfk_3 FOREIGN KEY (idAuthorship) REFERENCES authorship (id),
  ADD CONSTRAINT articles_ibfk_4 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT articles_ibfk_5 FOREIGN KEY (idStudent) REFERENCES students (idStudent) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы facultet
--
ALTER TABLE facultet
  ADD CONSTRAINT facultet_ibfk_1 FOREIGN KEY (idUniversity) REFERENCES universities (id);

--
-- Ограничения внешнего ключа таблицы grants
--
ALTER TABLE grants
  ADD CONSTRAINT grants_ibfk_5 FOREIGN KEY (typeGrant) REFERENCES grantType (id),
  ADD CONSTRAINT grants_ibfk_1 FOREIGN KEY (idTypeContest) REFERENCES typeContest (id) ON UPDATE CASCADE,
  ADD CONSTRAINT grants_ibfk_2 FOREIGN KEY (idScienceDirection) REFERENCES scienceDirection (id) ON UPDATE CASCADE,
  ADD CONSTRAINT grants_ibfk_3 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT grants_ibfk_4 FOREIGN KEY (idStudent) REFERENCES students (idStudent) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы ktdParticipation
--
ALTER TABLE ktdParticipation
  ADD CONSTRAINT ktdParticipation_ibfk_1 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT ktdParticipation_ibfk_2 FOREIGN KEY (idStudent) REFERENCES students1 (id) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы napravlenie
--
ALTER TABLE napravlenie
  ADD CONSTRAINT napravlenie_ibfk_1 FOREIGN KEY (idFacultet) REFERENCES facultet (id) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы patents
--
ALTER TABLE patents
  ADD CONSTRAINT patents_ibfk_1 FOREIGN KEY (idTypePatent) REFERENCES typePatent (id) ON UPDATE CASCADE,
  ADD CONSTRAINT patents_ibfk_2 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT patents_ibfk_3 FOREIGN KEY (idStudent) REFERENCES students1 (id) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT patents_ibfk_4 FOREIGN KEY (`status`) REFERENCES statusPatent (id) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы publicPerformance
--
ALTER TABLE publicPerformance
  ADD CONSTRAINT publicPerformance_ibfk_1 FOREIGN KEY (idStatus) REFERENCES statusEvent (id) ON UPDATE CASCADE,
  ADD CONSTRAINT publicPerformance_ibfk_2 FOREIGN KEY (idTypePublicPerformance) REFERENCES typePublicPerformance (id) ON UPDATE CASCADE,
  ADD CONSTRAINT publicPerformance_ibfk_3 FOREIGN KEY (idDocumentType) REFERENCES typeDocument (id) ON UPDATE CASCADE,
  ADD CONSTRAINT publicPerformance_ibfk_4 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT publicPerformance_ibfk_5 FOREIGN KEY (idStudent) REFERENCES students1 (id) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы sgroup
--
ALTER TABLE sgroup
  ADD CONSTRAINT sgroup_ibfk_1 FOREIGN KEY (idNapravlenie) REFERENCES napravlenie (id) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы socialParticipation
--
ALTER TABLE socialParticipation
  ADD CONSTRAINT socialParticipation_ibfk_1 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT socialParticipation_ibfk_2 FOREIGN KEY (idStudent) REFERENCES students1 (id) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы sotrudnik
--
ALTER TABLE sotrudnik
  ADD CONSTRAINT sotrudnik_ibfk_1 FOREIGN KEY (idSotrudnik) REFERENCES `user` (id),
  ADD CONSTRAINT sotrudnik_ibfk_2 FOREIGN KEY (idCity) REFERENCES cities (id),
  ADD CONSTRAINT sotrudnik_ibfk_3 FOREIGN KEY (idUniversity) REFERENCES universities (id),
  ADD CONSTRAINT sotrudnik_ibfk_4 FOREIGN KEY (idFacultet) REFERENCES facultet (id);

--
-- Ограничения внешнего ключа таблицы sportParticipation
--
ALTER TABLE sportParticipation
  ADD CONSTRAINT sportParticipation_ibfk_1 FOREIGN KEY (idDocument) REFERENCES documents (id) ON UPDATE CASCADE,
  ADD CONSTRAINT sportParticipation_ibfk_2 FOREIGN KEY (idStudent) REFERENCES students1 (id) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы st
--
ALTER TABLE st
  ADD CONSTRAINT st_ibfk_1 FOREIGN KEY (idCity) REFERENCES cities (id),
  ADD CONSTRAINT st_ibfk_2 FOREIGN KEY (idLevel) REFERENCES educationLevel (id),
  ADD CONSTRAINT st_ibfk_3 FOREIGN KEY (idStudent) REFERENCES `user` (id),
  ADD CONSTRAINT st_ibfk_4 FOREIGN KEY (idFacultet) REFERENCES facultet (id),
  ADD CONSTRAINT st_ibfk_5 FOREIGN KEY (idNapravlenie) REFERENCES napravlenie (id),
  ADD CONSTRAINT st_ibfk_6 FOREIGN KEY (idGroup) REFERENCES sgroup (id);

--
-- Ограничения внешнего ключа таблицы studentRating
--
ALTER TABLE studentRating
  ADD CONSTRAINT studentrating_ibfk_1 FOREIGN KEY (idStudent) REFERENCES students (idStudent),
  ADD CONSTRAINT studentrating_ibfk_2 FOREIGN KEY (idActivity) REFERENCES activity (id);

--
-- Ограничения внешнего ключа таблицы students
--
ALTER TABLE students
  ADD CONSTRAINT students_ibfk_2 FOREIGN KEY (idCity) REFERENCES cities (id),
  ADD CONSTRAINT students_ibfk_3 FOREIGN KEY (idLevel) REFERENCES educationLevel (id),
  ADD CONSTRAINT students_ibfk_5 FOREIGN KEY (idFacultet) REFERENCES facultet (id),
  ADD CONSTRAINT students_ibfk_6 FOREIGN KEY (idNapravlenie) REFERENCES napravlenie (id),
  ADD CONSTRAINT students_ibfk_7 FOREIGN KEY (idGroup) REFERENCES sgroup (id),
  ADD CONSTRAINT students_ibfk_8 FOREIGN KEY (idUniversity) REFERENCES universities (id);

--
-- Ограничения внешнего ключа таблицы students1
--
ALTER TABLE students1
  ADD CONSTRAINT students1_ibfk_1 FOREIGN KEY (idCity) REFERENCES cities (id),
  ADD CONSTRAINT students1_ibfk_2 FOREIGN KEY (idUniversity) REFERENCES universities (id),
  ADD CONSTRAINT students1_ibfk_3 FOREIGN KEY (idFacultet) REFERENCES facultet (id),
  ADD CONSTRAINT students1_ibfk_4 FOREIGN KEY (idNapravlenie) REFERENCES napravlenie (id),
  ADD CONSTRAINT students1_ibfk_5 FOREIGN KEY (idGroup) REFERENCES sgroup (id);

--
-- Ограничения внешнего ключа таблицы universities
--
ALTER TABLE universities
  ADD CONSTRAINT universities_ibfk_1 FOREIGN KEY (idCity) REFERENCES cities (id);

--
-- Ограничения внешнего ключа таблицы valuesRating
--
ALTER TABLE valuesRating
  ADD CONSTRAINT valuesRating_ibfk_1 FOREIGN KEY (idFacultet) REFERENCES facultet (id);

/*!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 */;

redpajama_set_name: RedPajamaGithub


text:
ProfilePublicationsPhDProjectsBSc and MScActivitiesAchievementsCitationsStatisticsCooperation
Supervised BSc and MSc theses
Professional activity
Spokesperson (1)
Przemysław Rokita, PhD, DSc, Professor
Tenured Professor
The Institute of Computer Science
Phone: +48 22 234-7753
Consultations: Tuesday 15.00-16.00
Scopus profile
h-index*:13
MSc (1985), PhD (1993), DSc (2000); Professor; Computer Science, Computer Graphics and Image Processing, Computer Graphics Division; Member of SPIE, ACM, IEEE; Minister of Education Award (1995); Rector's Award in Science (2001); Laureate of the Golden Chalk Distinction for excellence in teaching – WUT (2005), (2006). Head of Computer Graphics Division (2013-); Member of the Faculty Council (2000-); Member of the Faculty Council Committee for Scientific Research (2008-); Research interests: computer science & information technology, digital image processing, computer graphics, image perception; Previously affiliated as visiting scientist and professor at: Max-Planck-Institut für Informatik - Computer Graphics Department (Germany), The University of Aizu (Japan), Hiroshima Institute of Technology (Japan), Hiroshima Prefectural University (Japan), Imperial College of Science, Technology and Medicine (United Kingdom); Member of Program Committees and reviewer for many international conferences and journals, including: IEEE Computer Graphics & Applications, The Visual Computer, Real-Time Imaging, Opto-Electronics Review, Journal of Imaging Science and Technology, IEEE Transactions on Circuits and Systems for Video Technology, IEEE Transactions on Multimedia, ACM Siggraph, Eurographics, High Performance Graphics; Expert and consultant at National Centre for Research and Development, National Science Centre, Ministry of Science and Higher Education.
Main science area, domain, discipline: information science / (technology domain) / (technological sciences)
Science discipline: 2.3 Computer Science and telecommunications : 100.0 %