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 00000000..128bbae4
--- /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.......