forked from amazingfate/help
7e42394ecb
Replacement done with
find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \
's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g'
(note some inconsistencies with space between name and = and also having
empty value, and some more complicated expression to also clear up
double space before/after the attribute)
translation files will be prepped with:
find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \
$'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/'
(note that not all languages use the " as quote character for the
attributes, but that also single quotes appera in the po file. Hence
the use of the shell $'string' syntax to be able to quote ' as \'
It also requires to quote the backslash, so that it needs to be escaped
once for the shell, then another time for perl. Also don't work on
obsolete strings (those are prefixed with #~ in the po files)
Also note that <link..></link> gets turned into <link ../> during
translation extraction (along with removal of the space between the
attribute name and the value), so the pattern needs to be slightly
different here)
Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713
Tested-by: Jenkins
Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
64 lines
4.8 KiB
XML
64 lines
4.8 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!--
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* Licensed to the Apache Software Foundation (ASF) under one or more
|
|
* contributor license agreements. See the NOTICE file distributed
|
|
* with this work for additional information regarding copyright
|
|
* ownership. The ASF licenses this file to you under the Apache
|
|
* License, Version 2.0 (the "License"); you may not use this file
|
|
* except in compliance with the License. You may obtain a copy of
|
|
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
|
|
-->
|
|
<helpdocument version="1.0">
|
|
<meta>
|
|
<topic id="textsharedexplorerdatabasetablewizard03xml" indexer="include" status="PUBLISH">
|
|
<title id="tit" xml-lang="en-US">Table Wizard - Set Primary Key</title>
|
|
<filename>/text/sdatabase/tablewizard03.xhp</filename>
|
|
</topic>
|
|
<history>
|
|
<created date="2004-07-06T15:25:35">UFI: new Table Wizard page 3</created>
|
|
</history>
|
|
</meta>
|
|
<body>
|
|
<section id="setprimary">
|
|
<h1 id="par_idN10546"><link href="text/sdatabase/tablewizard03.xhp">Table Wizard - Set Primary Key</link></h1>
|
|
<paragraph role="paragraph" id="par_idN10556" xml-lang="en-US">Specifies a field in the table to be used as a primary key.</paragraph>
|
|
</section>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CHK_USEPRIMEKEY" id="bm_id2796411" localize="false"/>
|
|
<h2 id="par_idN10559">Create a primary key</h2>
|
|
<paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US"><ahelp hid=".">Select to create a primary key. Add a primary key to every database table to uniquely identify each record. For some database systems within %PRODUCTNAME, a primary key is mandatory for editing the tables.</ahelp></paragraph>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_OPT_PK_AUTOMATIC" id="bm_id1500289" localize="false"/>
|
|
<h3 id="par_idN10560">Automatically add a primary key</h3>
|
|
<paragraph role="paragraph" id="par_idN10564" xml-lang="en-US"><ahelp hid=".">Select to automatically add a primary key as an additional field.</ahelp></paragraph>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_OPT_PK_SINGLE" id="bm_id9485152.00000001" localize="false"/>
|
|
<h3 id="par_idN10567">Use an existing field as a primary key</h3>
|
|
<paragraph role="paragraph" id="par_idN1056B" xml-lang="en-US"><ahelp hid=".">Select to use an existing field with unique values as a primary key.</ahelp></paragraph>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_LB_PK_FIELDNAME" id="bm_id6801049" localize="false"/>
|
|
<h4 id="par_idN1056E">Field name</h4>
|
|
<paragraph role="paragraph" id="par_idN10572" xml-lang="en-US"><ahelp hid=".">Select the field name.</ahelp></paragraph>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CK_PK_AUTOVALUE" id="bm_id8796349" localize="false"/>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CK_PK_AUTOVALUE_AUTOMATIC" id="bm_id1406292" localize="false"/>
|
|
<h4 id="par_idN10575">Auto value</h4>
|
|
<paragraph role="paragraph" id="par_idN10579" xml-lang="en-US"><ahelp hid=".">Select to automatically insert a value and increment the field's value for each new record. The database must support automatic incrementation in order to use the <emph>Auto value</emph> feature.</ahelp></paragraph>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_OPT_PK_SEVERAL" id="bm_id130008" localize="false"/>
|
|
<h3 id="par_idN1057C">Define primary key by several fields</h3>
|
|
<paragraph role="paragraph" id="par_idN10580" xml-lang="en-US"><ahelp hid=".">Select to create a primary key from a combination of several existing fields.</ahelp></paragraph>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_FIELDS_PK_AVAILABLE" id="bm_id2555009" localize="false"/>
|
|
<h4 id="par_idN10583">Available fields</h4>
|
|
<paragraph role="paragraph" id="par_idN10587" xml-lang="en-US"><ahelp hid=".">Select a field and click > to add it to the list of primary key fields.</ahelp></paragraph>
|
|
<embed href="text/shared/autopi/01090100.xhp#take"/>
|
|
<embed href="text/shared/autopi/01090100.xhp#remove"/>
|
|
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_FIELDS_PK_SELECTED" id="bm_id8829309" localize="false"/>
|
|
<h4 id="par_idN1059A">Primary key fields</h4>
|
|
<paragraph role="paragraph" id="par_idN1059E" xml-lang="en-US"><ahelp hid=".">Select a field and click < to remove it from the list of primary key fields. The primary key is created as a concatenation of the fields in this list, from top to bottom.</ahelp></paragraph>
|
|
<paragraph role="paragraph" id="par_idN105A1" xml-lang="en-US"><link href="text/sdatabase/tablewizard04.xhp">Table Wizard - Create table</link></paragraph>
|
|
</body>
|
|
</helpdocument>
|