summaryrefslogtreecommitdiffstats
path: root/kexi/doc/dev/kexidb_sql.txt
diff options
context:
space:
mode:
authortpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da>2010-01-20 01:29:50 +0000
committertpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da>2010-01-20 01:29:50 +0000
commit8362bf63dea22bbf6736609b0f49c152f975eb63 (patch)
tree0eea3928e39e50fae91d4e68b21b1e6cbae25604 /kexi/doc/dev/kexidb_sql.txt
downloadkoffice-8362bf63dea22bbf6736609b0f49c152f975eb63.tar.gz
koffice-8362bf63dea22bbf6736609b0f49c152f975eb63.zip
Added old abandoned KDE3 version of koffice
git-svn-id: svn://anonsvn.kde.org/home/kde/branches/trinity/applications/koffice@1077364 283d02a7-25f6-0310-bc7c-ecb5cbfe19da
Diffstat (limited to 'kexi/doc/dev/kexidb_sql.txt')
-rw-r--r--kexi/doc/dev/kexidb_sql.txt36
1 files changed, 36 insertions, 0 deletions
diff --git a/kexi/doc/dev/kexidb_sql.txt b/kexi/doc/dev/kexidb_sql.txt
new file mode 100644
index 000000000..128bbae4b
--- /dev/null
+++ b/kexi/doc/dev/kexidb_sql.txt
@@ -0,0 +1,36 @@
+---------------------------------------------------------
+ KexiDB Common SQL definition
+ Copyright (C) 2003 Jaroslaw Staniek js at iidea dot pl
+ Started: 2003-09-10
+ Kexi home page: http://www.koffice.org/kexi/
+---------------------------------------------------------
+
+0. Preface
+----------
+Below is definition (formal grammar and comments) for SQL used externally by KexiDB.
+"Externally" means that this language is visible to the user and can be used
+by her/him to define queries.
+
+Many attempts has been done to create common part of many SQL versions that
+are currently in everyday use, mainly:
+- SQLite
+- MySQL
+- PostgreSQL
+
+
+1.1 CREATE TABLE
+----------------
+
+<CREATE_TABLE> ::= CREATE TABLE <table_name> (
+ <field_def>[,<field_def>]*
+ [,<table_constraint>]*
+ )
+<field_def> ::= <field_name> <field_type> <field_constraint>
+
+Note
+----
+CREATE TABLE statement could be added to KexiDBSQL for advanced users convenience,
+although tables can be easier created with gui. CREATE TABLE for KexiDB have
+non-standard options KexiDB-specific.
+
+TODO.......