var internetExplorer=document.selection&&window.ActiveXObject&&/MSIE/.test(navigator.userAgent),webkit=/AppleWebKit/.test(navigator.userAgent),safari=/Apple Computer, Inc/.test(navigator.vendor),gecko=navigator.userAgent.match(/gecko\/(\d{8})/i);gecko&&(gecko=Number(gecko[1]));var mac=/Mac/.test(navigator.platform),brokenOpera=window.opera&&/Version\/10.[56]/.test(navigator.userAgent),slowWebkit=/AppleWebKit\/533/.test(navigator.userAgent); function makeWhiteSpace(l){for(var k=[],m=!0;0=g&&-1!=(h=f.lastIndexOf(b,d-g)):-1!=(h=f.indexOf(b,d)))return{from:{node:c,offset:h},to:{node:c,offset:h+g}}}:function(a,b,c){var d=a?h.length-1:0,f=h[d],g=e(b),l=a?g.indexOf(f)+f.length:g.lastIndexOf(f); if(!(a?l>=c||l!=f.length:l<=c||l!=g.length-f.length))for(c=b;!a||c;){c=a?this.history.nodeBefore(c):this.history.nodeAfter(c);if(!a&&!c)break;g=e(c);f=h[a?--d:++d];if(0=a||33<=a&&40>=a}var x={P:!0,DIV:!0,LI:!0};t.prototype={findNext:function(){return this.find(!1)},findPrevious:function(){return this.find(!0)},find:function(a){function b(){var a={node:e,offset:f};c.pos={from:a,to:a};return c.atOccurrence=!1}if(!this.valid)return!1;var c=this,d=a?this.pos.from:this.pos.to,e=d.node,f=d.offset;e&&!e.parentNode&&(e=null,f=0);for(;;){if(this.pos=this.matches(a, e,f))return this.atOccurrence=!0;if(a){if(!e)return b();e=this.history.nodeBefore(e);f=this.history.textAfter(e).length}else{d=this.history.nodeAfter(e);if(!d)return f=this.history.textAfter(e).length,b();e=d;f=0}}},select:function(){this.atOccurrence&&(select.setCursorPos(this.editor.container,this.pos.from,this.pos.to),select.scrollToCursor(this.editor.container))},replace:function(a){if(this.atOccurrence){var b=this.currentMatch;b&&(a=a.replace(/\\(\d)/,function(a,d){return b[d]}));a=this.editor.replaceRange(this.pos.from, this.pos.to,a);this.pos.to=a;this.atOccurrence=!1}},position:function(){if(this.atOccurrence)return{line:this.pos.from.node,character:this.pos.from.offset}}};p.prototype={importCode:function(a){var b=asEditorLines(a);if(!this.options.incrementalLoading||1E3>b.length)this.history.push(null,null,b),this.history.reset();else{var c=function(){var a=b.slice(d,d+1E3);a.push("");e.history.push(e.history.nodeBefore(null),null,a);e.history.reset();d+=1E3;db){d=e.nextSibling;c=f.slice(0, b)+c+f.slice(b);removeElement(e);break}b-=f.length}b=asEditorLines(c);for(c=0;cg?0==f?(h&&select.snapshotMove(e.firstChild,h.firstChild||h,0),removeElement(e),e=null):(select.snapshotMove(e.firstChild,e.firstChild,g,!0),e.currentText=makeWhiteSpace(f),e.firstChild.nodeValue=e.currentText):0--d)return!1;a=a.previousSibling}if(a&&!a.nextSibling)return!1; var m=k(a?a.nextSibling:f.firstChild);d=stringStream(m);var q=a?a.parserFromHere(d):p.Parser.make(d),s={current:null,get:function(){this.current||(this.current=m.nodes.shift());return this.current},next:function(){this.current=null},remove:function(){f.removeChild(this.get());this.current=null},getNonEmpty:function(){for(var a=this.get();a&&isSpan(a)&&""==a.currentText;){var b;if(b=window.opera)b=a,b=(null==b.previousSibling||isBR(b.previousSibling))&&(null==b.nextSibling||isBR(b.nextSibling));b? (this.next(),a=this.get()):(b=a,this.remove(),a=this.get(),select.snapshotMove(b.firstChild,a&&(a.firstChild||a),0))}return a}},n=!1,t=!0,u=0;forEach(q,function(d){var k=s.getNonEmpty();if("\n"==d.value){if(!isBR(k))throw"Parser out of sync. Expected BR.";if(k.dirty||!k.indentation)n=!0;e(a);a=k;k.parserFromHere=q.copy();k.indentation=d.indentation||alwaysZero;k.dirty=!1;if(null==l&&k==b)throw StopIteration;if(null!=l&&(new Date).getTime()>=l||!n&&!t&&1d?(k.currentText=k.currentText.substring(d),k.reduced=!0,d=0):(d-=v,p+=v,s.remove())}}else h&&k.dirty&&h(k,d,g),k.dirty=!1,s.next()}});e(a);webkitLastLineHack(this.container);return{node:s.getNonEmpty(),dirty:n}}}; return p}();addEventHandler(window,"load",function(){var l=window.frameElement.CodeMirror;l.editor=new Editor(l.options);parent.setTimeout(method(l,"init"),0)}); var select={}; (function(){function n(a,b){for(;a&&a.parentNode!=b;)a=a.parentNode;return a}function v(a,b){for(;!a.previousSibling&&a.parentNode!=b;)a=a.parentNode;return n(a.previousSibling,b)}function s(a){var b=a.nextSibling;if(b){for(;b.firstChild;)b=b.firstChild;return 3==b.nodeType||isBR(b)?b:s(b)}for(a=a.parentNode;a&&!a.nextSibling;)a=a.parentNode;return a&&s(a)}select.ie_selection=document.selection&&document.selection.createRangeCollection;select.scrollToNode=function(a,b){if(a){for(var c=a,d=document.body, e=document.documentElement,g=!c.nextSibling||!c.nextSibling.nextSibling||!c.nextSibling.nextSibling.nextSibling,k=0;c&&!c.offsetTop;)k++,c=c.previousSibling;0==k&&(g=!1);if(!webkit||!c||5!=c.offsetTop||5!=c.offsetLeft){for(var k=k*(c?c.offsetHeight:0),h=0,q=a?a.offsetWidth:0;c&&c.offsetParent;)k+=c.offsetTop,isBR(c)||(h+=c.offsetLeft),c=c.offsetParent;var c=d.scrollLeft||e.scrollLeft||0,d=d.scrollTop||e.scrollTop||0,f=!1,l=window.innerWidth||e.clientWidth||0;if(b||qq||q>l)c=h,f=!0}h=k-d;if(0>h||g||h>(window.innerHeight||e.clientHeight||0)-50)d=g?1E6:k,f=!0;f&&window.scrollTo(c,d)}}};select.scrollToCursor=function(a){select.scrollToNode(select.selectionTopNode(a,!0)||a.firstChild,!0)};var f=null;select.snapshotChanged=function(){f&&(f.changed=!0)};select.snapshotReplaceNode=function(a,b,c,d){function e(e){a==e.node?(f.changed=!0,c&&e.offset>c?e.offset-=c:(e.node=b,e.offset+=d||0)):select.ie_selection&&0==e.offset&& e.node==s(a)&&(f.changed=!0)}f&&(e(f.start),e(f.end))};select.snapshotMove=function(a,b,c,d,e){function g(g){a!=g.node||e&&0!=g.offset||(f.changed=!0,g.node=b,g.offset=d?Math.max(0,g.offset+c):c)}f&&(g(f.start),g(f.end))};if(select.ie_selection){var w=function(a){var b=l();b&&(b.pasteHTML(a),b.collapse(!1),b.select())},x=function(a){function b(a){for(var b=null;!b&&a;)b=a.nextSibling,a=a.parentNode;return c(b)}function c(a){for(;a&&a.firstChild;)a=a.firstChild;return{node:a,offset:0}}var d=l();d.collapse(a); a=d.parentElement();if(!isAncestor(document.body,a))return null;if(!a.firstChild)return c(a);var e=d.duplicate();e.moveToElementText(a);e.collapse(!0);for(var g=a.firstChild;g;g=g.nextSibling){if(3==g.nodeType){var k=g.nodeValue.length;e.move("character",k)}else e.moveToElementText(g),e.collapse(!1);var h=d.compareEndPoints("StartToStart",e);if(0==h)return b(g);if(1!=h){if(3!=g.nodeType)return c(g);e.setEndPoint("StartToEnd",d);return{node:g,offset:k-e.text.length}}}return b(a)},l=function(){var a= document.selection;return a?a.createRange?a.createRange():a.createTextRange():null};select.markSelection=function(){f=null;if(document.selection){var a=x(!0),b=x(!1);a&&b&&(f={start:a,end:b,changed:!1})}};select.selectMarked=function(){function a(a){var c=document.body.createTextRange(),b=a.node;if(b)if(3==b.nodeType){c.moveToElementText(b.parentNode);for(a=a.offset;b.previousSibling;)b=b.previousSibling,a+=(b.innerText||"").length;c.move("character",a)}else c.moveToElementText(b),c.collapse(!0); else c.moveToElementText(document.body),c.collapse(!1);return c}if(f&&f.changed){var b=a(f.start),c=a(f.end);b.setEndPoint("StartToEnd",c);b.select()}};select.offsetInNode=function(a){var b=l();if(!b)return 0;var c=b.duplicate();try{c.moveToElementText(a)}catch(d){return 0}b.setEndPoint("StartToStart",c);return b.text.length};select.selectionTopNode=function(a,b){var c=l();if(!c)return!1;var d=c.duplicate();c.collapse(b);var e=c.parentElement();if(e&&isAncestor(a,e)&&(d.moveToElementText(e),1==c.compareEndPoints("StartToStart", d)))return n(e,a);b=0;for(e=a.childNodes.length-1;b")};select.insertTabAtCursor=function(){w("\u00a0\u00a0\u00a0\u00a0")};select.cursorPos=function(a,b){var c= l();if(!c)return null;for(var d=select.selectionTopNode(a,b);d&&!isBR(d);)d=d.previousSibling;var e=c.duplicate();c.collapse(b);if(d)e.moveToElementText(d),e.collapse(!1);else{try{e.moveToElementText(a)}catch(g){return null}e.collapse(!0)}c.setEndPoint("StartToStart",e);return{node:d,offset:c.text.length}};select.setCursorPos=function(a,b,c){function d(c){var b=document.body.createTextRange();c.node?(b.moveToElementText(c.node),b.collapse(!1)):(b.moveToElementText(a),b.collapse(!0));b.move("character", c.offset);return b}var e=d(b);c&&c!=b&&e.setEndPoint("EndToEnd",d(c));e.select()};select.getBookmark=function(a){var b=select.cursorPos(a,!0);a=select.cursorPos(a,!1);if(b&&a)return{from:b,to:a}};select.setBookmark=function(a,b){b&&select.setCursorPos(a,b.from,b.to)}}else{var p=function(){var a=window.getSelection();return a&&0!=a.rangeCount?a.getRangeAt(0):!1},r=function(a){var b=window.getSelection();b&&(b.removeAllRanges(),b.addRange(a))},u=function(a,b){for(;3!=a.nodeType&&!isBR(a);){var c=a.childNodes[b]|| a.nextSibling;for(b=0;!c&&a.parentNode;)a=a.parentNode,c=a.nextSibling;a=c;if(!c)break}return{node:a,offset:b}};select.markSelection=function(){var a=window.getSelection();if(!a||0==a.rangeCount)return f=null;a=a.getRangeAt(0);f={start:u(a.startContainer,a.startOffset),end:u(a.endContainer,a.endOffset),changed:!1}};select.selectMarked=function(){function a(){if(c.start.node==c.end.node&&c.start.offset==c.end.offset){var a=window.getSelection();if(!a||0==a.rangeCount)return!0;a=a.getRangeAt(0);a=u(a.startContainer, a.startOffset);return c.start.node!=a.node||c.start.offset!=a.offset}}function b(a,b){if(a.node)if(0==a.offset)d["set"+b+"Before"](a.node);else d["set"+b](a.node,a.offset);else d.setStartAfter(document.body.lastChild||document.body)}var c=f;if(c&&(c.changed||webkit&&a())){var d=document.createRange();b(c.end,"End");b(c.start,"Start");r(d)}};select.selectionTopNode=function(a,b){var c=p();if(!c)return!1;var d=b?c.startContainer:c.endContainer,e=b?c.startOffset:c.endOffset;window.opera&&!b&&c.endContainer== a&&c.endOffset==c.startOffset+1&&a.childNodes[c.startOffset]&&isBR(a.childNodes[c.startOffset])&&e--;return 3==d.nodeType?0=c)return e["set"+d](l,c),!0;c-=n}}}var e=document.createRange();c=c|| b;d(c.node,c.offset,"End")&&d(b.node,b.offset,"Start")&&r(e)}}})(); var stringStream=function(g){function e(){for(;c==a.length;){d+=a;a="";c=0;try{a=g.next()}catch(b){if(b!=StopIteration)throw b;return!1}}return!0}var a="",c=0,d="";return{peek:function(){return e()?a.charAt(c):null},next:function(){if(!e()){if(0this.maxDepth&&(this.history.shift(),lostundo+=1)},touchedChains:function(){function a(a){for(var b=[],d=a?a.nextSibling:c.container.firstChild;d&&(!isBR(d)||d.hackBR);d=d.nextSibling)!d.hackBR&&d.currentText&&b.push(d.currentText);return{from:a,to:d,text:cleanText(b.join(""))}}function b(a,c){for(var d=c+"Sibling",b=a[d];b&&!isBR(b);)b=b[d];return b}var c=this,g=null,e=[];c.firstTouched&& c.touched.push(null);forEach(c.touched,function(b){if(!b||b.parentNode==c.container&&!b.hackBR){b?b.historyTouched=!1:c.firstTouched=!1;var f=a(b),d=c.after(b);d&&d.text==f.text&&d.to==f.to||(e.push(f),b?b.historyTemp=f:g=f)}});var f=[];c.touched=[];forEach(e,function(e){var h=e.from;if(h?h.historyTemp:g){for(var h=[],d=e.from,l=!0;;){var k=d?d.historyTemp:g;if(!k)if(l)break;else k=a(d);h.unshift(k);d?d.historyTemp=null:g=null;if(!d)break;l=c.after(d);d=b(d,"previous")}d=e.to;for(l=c.before(e.from);d;){k= d?d.historyTemp:g;if(!k)if(l)break;else k=a(d);h.push(k);d?d.historyTemp=null:g=null;l=c.before(d);d=b(d,"next")}f.push(h)}});return f},shadowChain:function(a){var b=[],c=this.after(a[0].from);for(a=a[a.length-1].to;;)if(b.push(c),(c=c.to)&&c!=a)c=c.historyAfter||this.before(a);else break;return b},applyChain:function(a){for(var b=select.cursorPos(this.container,!1),c=a[0].from,g=a[a.length-1].to,e=c?c.nextSibling:this.container.firstChild;e!=g;){var f=e.nextSibling;removeElement(e);e=f}for(e=0;e< a.length;e++){f=a[e];0d&&(m=f.text.length-h.text.length)}select.setCursorPos(this.container,{node:f.from,offset:Math.max(0,b.offset+m)})}else b&&e==a.length-1&&b.node&&b.node.parentNode!=this.container&&select.setCursorPos(this.container,{node:f.from, offset:f.text.length})}this.linkChain(a);return c}}; function method(a,b){return function(){a[b].apply(a,arguments)}}var StopIteration={toString:function(){return"StopIteration"}};function forEach(a,b){if(a.next)try{for(;;)b(a.next())}catch(c){if(c!=StopIteration)throw c;}else for(var d=0;d > >= like rlike in xor between".split(" ")),m=/[*+\-<>=&|:\/]/,n={},p=function(){function b(c,b){var a=c.next();if("@"==a||"$"==a)return c.nextWhileMatches(/[\w\d]/),"sql-var";if("["==a)return b(d(a)),null;if('"'==a||"'"==a||"`"==a)return b(g(a)),null;if(","==a||";"==a)return"sql-separator";if("#"==a){for(;!c.endOfLine();)c.next();return"sql-comment"}if("-"==a){if("-"==c.peek()){for(;!c.endOfLine();)c.next();return"sql-comment"}return/\d/.test(c.peek())?(c.nextWhileMatches(/\d/), "."==c.peek()&&(c.next(),c.nextWhileMatches(/\d/)),"sql-number"):"sql-operator"}if(m.test(a)){if("/"==a&&"*"==c.peek())return b(e("sql-comment","*/")),null;c.nextWhileMatches(m);return"sql-operator"}if(/\d/.test(a))return c.nextWhileMatches(/\d/),"."==c.peek()&&(c.next(),c.nextWhileMatches(/\d/)),"sql-number";if(/[()]/.test(a))return"sql-punctuation";c.nextWhileMatches(/[_\w\d]/);a=c.get();return{style:k.test(a)?"sql-operator":f.test(a)?"sql-keyword":h.test(a)?"sql-function":q.test(a)?"sql-type": "sql-word",content:a}}function d(c){return function(c,a){for(;!c.endOfLine();)if("]"==c.next()){a(b);break}return"sql-word"}}function g(c){return function(d,a){for(var e=!1;!d.endOfLine();){var g=d.next();if(g==c&&!e){a(b);break}e="T-SQL"==n.extension?!e&&c==g&&d.equals(c):!e&&"\\"==g}return"`"==c?"sql-quoted-word":"sql-literal"}}function e(c,d){return function(a,e){for(;!a.endOfLine();){if(a.lookAhead(d,!0)){e(b);break}a.next()}return c}}return function(c,d){return tokenizer(c,d||b)}}();return{make:function(b){function d(a, d,b){e={prev:e,indent:c,col:f,type:a,width:d,align:b}}var h=p(b),e=null,c=0,f=0,a={next:function(){var a=h.next(),b=a.style,k=a.content,l=a.value.length;"\n"==k?(a.indentation=g(e),c=f=0,e&&null==e.align&&(e.align=!1)):"whitespace"==b&&0==f?c=l:e||"sql-comment"==b||d(";",0,!1);"\n"!=k&&(f+=l);"sql-punctuation"==b?"("==k?d(")",l):")"==k&&(e=e.prev):"sql-separator"==b&&";"==k&&e&&!e.prev&&(e=e.prev);return a},copy:function(){var b=e,d=c,g=f,k=h.state;return function(l){h=p(l,k);e=b;c=d;f=g;return a}}}; return a},electricChars:")",configure:function(b){for(var d in b)b.hasOwnProperty(d)&&(n[d]=b[d])}}}(),StopIteration={toString:function(){return"StopIteration"}},indentUnit=2; (function(){function l(g){for(var h="",f=0;f