/usr/share/doc/sqliteman/en/ch07s02.html is in sqliteman-doc 1.2.2-0ubuntu6.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 | <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Create Table</title><link rel="stylesheet" href="kde-default.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.67.2"><meta name="keywords" content="Sqliteman, SQL, Sqlite, development, database"><link rel="start" href="index.html" title="The Sqliteman Handbook"><link rel="up" href="ch07.html" title="Chapter 7. Features and Dialogs"><link rel="prev" href="ch07.html" title="Chapter 7. Features and Dialogs"><link rel="next" href="ch07s03.html" title="Alter Table"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Create Table</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch07.html">Prev</a> </td><th width="60%" align="center">Chapter 7. Features and Dialogs</th><td width="20%" align="right"> <a accesskey="n" href="ch07s03.html">Next</a></td></tr></table><hr></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="createTable"></a>Create Table</h2></div></div></div><div class="orderedlist"><ol type="1"><li><p>First - as you see in the screenshot - you can create a table with mouse and only a few keyboard typing in the "Design" tab.</p></li><li><p>And the second one by pure SQL statement.</p></li></ol></div><p>
</p><div class="screenshot"><div class="mediaobject"><img src="createTable.png" alt="Create table dialog"></div></div><p>
</p><div class="variablelist"><dl><dt><span class="term">Database</span></dt><dd><p>A combo box with databases attached. Select one and the table will be created in this schema.</p></dd><dt><span class="term">Table Name</span></dt><dd><p>Name of new table. It must be given.</p></dd><dt><span class="term">Columns</span></dt><dd><p>Use "Add" and "Remove" buttons to create columns for this table. Every column must have a table-unique name, chosen data type (prepared combo box), optional NOT NULL constraint, and optional DEFAULT value.
</p><div class="important" style="margin-left: 0.5in; margin-right: 0.5in;"><h3 class="title">Important</h3><p>Consult Sqlite documentation for data type, NOT NULL, and DEFAULT handling specials, please.</p></div></dd><dt><span class="term">Create</span></dt><dd><p>Press this button to create table. The result of this operation is shown in the text area below.</p></dd><dt><span class="term">Advanced (SQL) tab</span></dt><dd><p>You can write full featured SQL CREATE TABLE statement here. A helper template is prepared for you. Every time you open this tab you will be asked to recreate a new SQL statement from the GUI settings in the first tab.</p></dd></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch07.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ch07.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="ch07s03.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 7. Features and Dialogs </td><td width="20%" align="center"><a accesskey="h" href="index.html">Contents</a></td><td width="40%" align="right" valign="top"> Alter Table</td></tr></table></div></body></html>
|