Refactor some database pages

Place in sdatabase/ folder Change-Id: Ia787f7634755be2fd4936914cacecded5bee4221 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110208 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
author: Olivier Hallot <olivier.hallot@libreoffice.org> 2021-01-31 14:10:55 -0300
committer: Olivier Hallot <olivier.hallot@libreoffice.org> 2021-01-31 21:57:58 +0100
commit: 5fd683cd1c13cc20d0c7205c895b4e5ca1c39196 (patch)
tree: 0cdb2869a265182088c9e5488b5c1d8edd26bc38 /source/text/sdatabase
parent: c0f70b871b7a558f5f7de355e6e18636cd90ac93 (diff)
3 files changed, 148 insertions, 1 deletions
diff --git a/source/text/sdatabase/05000000.xhp b/source/text/sdatabase/05000000.xhp
index f542990b74..a68f9ee4b7 100644
--- a/source/text/sdatabase/05000000.xhp
+++ b/source/text/sdatabase/05000000.xhp
@@ -32,7 +32,7 @@
 <paragraph role="paragraph" id="par_id3147102" xml-lang="en-US">Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records.</paragraph>
 </section>
 <paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">In the $[officename] Help, you will find further information on the following subjects:</paragraph>
-<h2 id="hd_id3152425"><link href="text/shared/explorer/database/05010000.xhp" name="Create new or edit table design">Create new or edit table design</link></h2>
+<h2 id="hd_id3152425"><link href="text/sdatabase/05010000.xhp" name="Create new or edit table design">Create new or edit table design</link></h2>
 <embed href="text/shared/01/05340400.xhp#data_sources"/>
 <embed href="text/shared/02/12100200.xhp#findrecord"/>
 <h2 id="hd_id3149095"><link href="text/shared/main0212.xhp" name="Sort and Filter Data">Sort and Filter Data</link></h2>
diff --git a/source/text/sdatabase/05010000.xhp b/source/text/sdatabase/05010000.xhp
new file mode 100644
index 0000000000..faabb59c8f
--- /dev/null
+++ b/source/text/sdatabase/05010000.xhp
@@ -0,0 +1,86 @@
+<?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="textsharedexplorerdatabase05010000xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Table Design</title>
+<filename>/text/sdatabase/05010000.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+</history>
+</meta>
+<body>
+<section id="table_design">
+<h1 id="hd_id3154228"><link href="text/sdatabase/05010000.xhp" name="Table Design">Table Design</link></h1>
+<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US">In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table.</paragraph>
+</section>
+<section id="howtoget">
+  <embed href="text/shared/00/00000450.xhp#tabellenentwurf"/>
+</section>
+<embed href="text/shared/guide/database_main.xhp#database_main"/>
+<embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/>
+<paragraph role="paragraph" id="par_id3146957" xml-lang="en-US">The window has its own menu bar. It also contains the following new command: <link href="text/sdatabase/05010100.xhp" name="Index Design"><emph>Index Design</emph></link></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_BACKGROUND" id="bm_id3147088" localize="false"/>
+<h2 id="hd_id3152551">Table definition area</h2>
+<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_BACKGROUND">This area is where you define the table structure.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_NAMECELL" id="bm_id3145382" localize="false"/>
+<h3 id="hd_id3153031">Field Name</h3>
+<paragraph role="paragraph" id="par_id3156113" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_NAMECELL">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_TYPECELL" id="bm_id3148473" localize="false"/>
+<h3 id="hd_id3147618">Field type</h3>
+<paragraph role="paragraph" id="par_id3154897" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_TYPECELL">Specifies the field type. The available field types are limited by the database engine being used.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_COMMENTCELL" id="bm_id3149233" localize="false"/>
+<h3 id="hd_id3156119">Description</h3>
+<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_COMMENTCELL">Specifies an optional description for each field.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3155630" xml-lang="en-US">The row headers contain the following context menu commands:</paragraph>
+<h3 id="hd_id3156330">Cut</h3>
+<paragraph role="paragraph" id="par_id3159157" xml-lang="en-US">Cuts the selected row to the clipboard.</paragraph>
+<h3 id="hd_id3159177">Copy</h3>
+<paragraph role="paragraph" id="par_id3148685" xml-lang="en-US">Copies the selected row to the clipboard.</paragraph>
+<h3 id="hd_id3156327">Paste</h3>
+<paragraph role="paragraph" id="par_id3152472" xml-lang="en-US">Pastes the content of the clipboard.</paragraph>
+<h3 id="hd_id3144511">Delete</h3>
+<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:Delete">Deletes the selected row.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLEDESIGN_INSERTROWS" id="bm_id3159414" localize="false"/>
+<h3 id="hd_id3147303">Insert Rows</h3>
+<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_INSERTROWS">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLEDESIGN_TABED_PRIMARYKEY" id="bm_id3150791" localize="false"/>
+<h3 id="hd_id3153524">Primary Key</h3>
+<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_TABED_PRIMARYKEY">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys.</paragraph>
+<h2 id="hd_id3153104">Field properties</h2>
+<paragraph role="paragraph" id="par_id3148922" xml-lang="en-US">Defines the field properties of the currently selected field.</paragraph>
+<h3 id="hd_id3150767">Length</h3>
+<paragraph role="paragraph" id="par_id3144761" xml-lang="en-US">Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters.</paragraph>
+<h3 id="hd_id3154948">Decimal places</h3>
+<paragraph role="paragraph" id="par_id3149203" xml-lang="en-US">Specifies the number of decimal places for a numerical field or decimal field.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_DEFAULT" id="bm_id3158410" localize="false"/>
+<h3 id="hd_id3156422">Default value</h3>
+<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_DEFAULT">Specifies the value that is the default in new data records.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_FORMAT_SAMPLE" id="bm_id3149562" localize="false"/>
+<h3 id="hd_id3147289">Format example</h3>
+<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT_SAMPLE">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_FORMAT" id="bm_id3147319" localize="false"/>
+<h3 id="hd_id3154129">...</h3>
+<paragraph role="paragraph" id="par_id3154146" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT">This button opens the <link href="text/shared/01/05340405.xhp" name="Field Format"><emph>Field Format</emph></link> dialog.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLE_DESIGN_HELP_WINDOW" id="bm_id3152941" localize="false"/>
+<h2 id="hd_id3152576">Help area</h2>
+<paragraph role="paragraph" id="par_id3150685" xml-lang="en-US"><ahelp hid="HID_TABLE_DESIGN_HELP_WINDOW">Displays a help string or hint defined by the database designer for the given field.</ahelp></paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/05010100.xhp b/source/text/sdatabase/05010100.xhp
new file mode 100644
index 0000000000..a5fff83087
--- /dev/null
+++ b/source/text/sdatabase/05010100.xhp
@@ -0,0 +1,61 @@
+<?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="textsharedexplorerdatabase05010100xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Index design</title>
+<filename>/text/sdatabase/05010100.xhp</filename>
+</topic>
+</meta>
+<body>
+<section id="index_design">
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/IndexDesignDialog" id="bm_id3156410" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/.uno:DBIndexDesign" id="bm_id3149828" localize="false"/><h1 id="hd_id3153311"><link href="text/sdatabase/05010100.xhp" name="Index design">Index design</link></h1>
+<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US"><ahelp hid=".uno:DBIndexDesign">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp></paragraph>
+</section>
+<section id="howtoget">
+  <embed href="text/shared/00/00000450.xhp#indexentwurf"/>
+</section>
+<embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/INDEX_LIST" id="bm_id3148473" localize="false"/><h2 id="hd_id3149578">Index list</h2>
+<paragraph role="paragraph" id="par_id3155342" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/INDEX_LIST">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_NEW" id="bm_id3158430" localize="false"/><h3 id="hd_id3149795">New Index</h3>
+<paragraph role="paragraph" id="par_id3150085" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_NEW">Creates a new index.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_DROP" id="bm_id3148642" localize="false"/><h3 id="hd_id3145317">Delete Current Index</h3>
+<paragraph role="paragraph" id="par_id3154860" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_DROP">Deletes the current index.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME" id="bm_id3154285" localize="false"/><h3 id="hd_id3150986">Rename Current Index</h3>
+<paragraph role="paragraph" id="par_id3148685" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME">Renames the current index.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE" id="bm_id3151245" localize="false"/><h3 id="hd_id3153628">Save Current Index</h3>
+<paragraph role="paragraph" id="par_id3148563" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE">Saves the current index in the data source.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RESET" id="bm_id3147265" localize="false"/><h3 id="hd_id3154924">Reset Current Index</h3>
+<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RESET">Resets the current index to the setting that it had when the dialog was started.</ahelp></paragraph>
+<h2 id="hd_id3152812">Index details</h2>
+<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US">As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/UNIQUE" id="bm_id3145171" localize="false"/><h3 id="hd_id3154138">Unique</h3>
+<paragraph role="paragraph" id="par_id3156282" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/UNIQUE">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity.</paragraph>
+<h3 id="hd_id3150448">Fields</h3>
+<paragraph role="paragraph" id="par_id3147085" xml-lang="en-US">The<emph> Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_FIELD" id="bm_id3147230" localize="false"/><h3 id="hd_id3149765">Index field</h3>
+<paragraph role="paragraph" id="par_id3158408" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_FIELD">Displays a list of the fields in the current table. You can select more than one field.</ahelp><comment>i73718</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_SORTORDER" id="bm_id3154910" localize="false"/><h3 id="hd_id3153192">Sort order</h3>
+<paragraph role="paragraph" id="par_id3149561" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order of the indexes.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/close" id="bm_id3145785" localize="false"/><h2 id="hd_id3155132">Close</h2>
+<paragraph role="paragraph" id="par_id3154190" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/close">Closes the dialog.</ahelp></paragraph>
+</body>
+</helpdocument>
author	Olivier Hallot <olivier.hallot@libreoffice.org>	2021-01-31 14:10:55 -0300
committer	Olivier Hallot <olivier.hallot@libreoffice.org>	2021-01-31 21:57:58 +0100
commit	5fd683cd1c13cc20d0c7205c895b4e5ca1c39196 (patch)
tree	0cdb2869a265182088c9e5488b5c1d8edd26bc38 /source/text/sdatabase
parent	c0f70b871b7a558f5f7de355e6e18636cd90ac93 (diff)