<?xml version="1.0"?>
<api>
  <query-continue>
    <allpages gapcontinue="Spezial" />
  </query-continue>
  <query>
    <pages>
      <page pageid="8" ns="0" title="SQL">
        <revisions>
          <rev contentformat="text/x-wiki" contentmodel="wikitext" xml:space="preserve">== SQL-Keywords ==
=== SQL INNER JOIN ===

The INNER JOIN keyword return rows when there is at least one match in both tables.

SQL INNER JOIN Syntax:
&lt;pre&gt;
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2 
ON table_name1.column_name=table_name2.column_name
&lt;/pre&gt;

PS: INNER JOIN is the same as JOIN.


== Links ==
* [http://www.w3schools.com/sql/sql_quickref.asp W3Schools SQL Quick Reference]
* [http://www.devguru.com/technologies/t-sql/home.asp DevGuru T-SQL]</rev>
        </revisions>
      </page>
      <page pageid="13" ns="0" title="SVN">
        <revisions>
          <rev contentformat="text/x-wiki" contentmodel="wikitext" xml:space="preserve">=Commands=
==Status==
===Most common usage===
;svn status -u
:Zeigt sowohl lokale Aenderungen als auch die auf dem Server

===Help===
&lt;pre&gt;
status (stat, st): Print the status of working copy files and directories.
usage: status [PATH...]

  With no args, print only locally modified items (no network access).
  With -q, print only summary information about locally modified items.
  With -u, add working revision and server out-of-date information.
  With -v, print full revision information on every item.

  The first six columns in the output are each one character wide:
    First column: Says if item was added, deleted, or otherwise changed
      ' ' no modifications
      'A' Added
      'C' Conflicted
      'D' Deleted
      'I' Ignored
      'M' Modified
      'R' Replaced
      'X' item is unversioned, but is used by an externals definition
      '?' item is not under version control
      '!' item is missing (removed by non-svn command) or incomplete
      '~' versioned item obstructed by some item of a different kind
    Second column: Modifications of a file's or directory's properties
      ' ' no modifications
      'C' Conflicted
      'M' Modified
    Third column: Whether the working copy directory is locked
      ' ' not locked
      'L' locked
    Fourth column: Scheduled commit will contain addition-with-history
      ' ' no history scheduled with commit
      '+' history scheduled with commit
    Fifth column: Whether the item is switched relative to its parent
      ' ' normal
      'S' switched
    Sixth column: Repository lock token
      (without -u)
      ' ' no lock token
      'K' lock token present
      (with -u)
      ' ' not locked in repository, no lock token
      'K' locked in repository, lock toKen present
      'O' locked in repository, lock token in some Other working copy
      'T' locked in repository, lock token present but sTolen
      'B' not locked in repository, lock token present but Broken

  The out-of-date information appears in the eighth column (with -u):
      '*' a newer revision exists on the server
      ' ' the working copy is up to date

  Remaining fields are variable width and delimited by spaces:
    The working revision (with -u or -v)
    The last committed revision and last committed author (with -v)
    The working copy path is always the final field, so it can
      include spaces.

  Example output:
    svn status wc
     M     wc/bar.c
    A  +   wc/qax.c

    svn status -u wc
     M           965    wc/bar.c
           *     965    wc/foo.c
    A  +         965    wc/qax.c
    Status against revision:   981

    svn status --show-updates --verbose wc
     M           965       938 kfogel       wc/bar.c
           *     965       922 sussman      wc/foo.c
    A  +         965       687 joe          wc/qax.c
                 965       687 joe          wc/zig.c
    Status against revision:   981

Valid options:
  -u [--show-updates]      : display update information
  -v [--verbose]           : print extra information
  -N [--non-recursive]     : obsolete; try --depth=files or --depth=immediates
  --depth ARG              : limit operation by depth ARG ('empty', 'files',
                            'immediates', or 'infinity')
  -q [--quiet]             : print nothing, or only summary information
  --no-ignore              : disregard default and svn:ignore property ignores
  --incremental            : give output suitable for concatenation
  --xml                    : output in XML
  --ignore-externals       : ignore externals definitions
  --changelist ARG         : operate only on members of changelist ARG
                             [aliases: --cl]

Global options:
  --username ARG           : specify a username ARG
  --password ARG           : specify a password ARG
  --no-auth-cache          : do not cache authentication tokens
  --non-interactive        : do no interactive prompting
  --config-dir ARG         : read user configuration files from directory ARG
&lt;/pre&gt;

==Update==
==Commit==
==Diff==
==Info==
==Switch==      
==Revert==

==Merge==
===Most common usage===
;&lt;code&gt;svn merge --reintegrate svn+ssh://svnserver/var/lib/svnroot/ishop/ishop-opo/branches/0906-bug_1827 --dry-run&lt;/code&gt;
:tries to merge 0906-bug_1827 to trunk (if you are in the trunk) but makes no changes
:&lt;code&gt;--dry-run:&lt;/code&gt; try operation but make no changes
&lt;br /&gt;

==Log==
==Resolve==
==Add==
==Cleanup==

Recursively clean up the working copy, removing locks, resuming unfinished operations, etc.&lt;br /&gt;
usage: cleanup [PATH...]

==Copy==        
==Resolved==
==Checkout==
==Delete==
==List==
==Blame==

=Workflows=
==Merge branch back to trunk==

# Change to trunk
# Update trunk: ''&lt;code&gt;svn up&lt;/code&gt;''
# Merge:
## Try with &lt;code&gt;--reintegrate --dry-run&lt;/code&gt;&lt;br /&gt;&lt;code&gt;svn merge --reintegrate svn+ssh://svnserver/var/lib/svnroot/ishop/ishop-opo/branches/0906-bug_1827 --dry-run&lt;/code&gt;&lt;br /&gt;'''if it doesn't work:'''
## search the right revision:&lt;br /&gt;''&lt;code&gt;svn log -l 10&lt;/code&gt;'' shows the last 10 changes (commits)&lt;br /&gt;when the right revision is found:
##&lt;code&gt;svn merge -r 14804:HEAD svn+ssh://svnserver/var/lib/svnroot/ishop/ishop-opo/branches/0906-bug_1827 --dry-run&lt;/code&gt;

When the merge is successful, reuse the same command without &lt;code&gt;--dry-run&lt;/code&gt;.

= Config =

===Subversion config file:===
====Speicherort====

{| class=&quot;wikitable&quot; border=&quot;0&quot;
|-
| Windows: || %APPDATA%\Subversion 
|-
|  || 
|}
====Beispiel====
(comments removed)
&lt;pre&gt;
[auth]
# store-passwords = no
# store-auth-creds = no

[helpers]
# editor-cmd = editor (vi, emacs, notepad, etc.)
# diff-cmd = diff_program (diff, gdiff, etc.)
# diff3-cmd = diff3_program (diff3, gdiff3, etc.)
# diff3-has-program-arg = [true | false]
# merge-tool-cmd = merge_command

[tunnels]
# ssh = $SVN_SSH ssh
# rsh = rsh
# rsh = /path/to/rsh -l myusername

[miscellany]
# global-ignores = *.o *.lo *.la *.al .libs *.so *.so.[0-9]* *.a *.pyc *.pyo
#   *.rej *~ #*# .#* .*.swp .DS_Store
global-ignores = .classpath .project target

# log-encoding = latin1
# use-commit-times = yes
# no-unlock = yes
# mime-types-file = /path/to/mime.types
# preserved-conflict-file-exts = doc ppt xls od?
# enable-auto-props = yes
# interactive-conflicts = no

[auto-props]
# *.c = svn:eol-style=native
# *.cpp = svn:eol-style=native
# *.h = svn:eol-style=native
# *.dsp = svn:eol-style=CRLF
# *.dsw = svn:eol-style=CRLF
# *.sh = svn:eol-style=native;svn:executable
# *.txt = svn:eol-style=native
# *.png = svn:mime-type=image/png
# *.jpg = svn:mime-type=image/jpeg
# Makefile = svn:eol-style=native

&lt;/pre&gt;


==Server==
===Serverconfig===
url: &lt;pre&gt;svn://server&lt;/pre&gt;</rev>
        </revisions>
      </page>
    </pages>
  </query>
</api>