diff options
| author | tpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da> | 2010-01-20 01:29:50 +0000 |
|---|---|---|
| committer | tpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da> | 2010-01-20 01:29:50 +0000 |
| commit | 8362bf63dea22bbf6736609b0f49c152f975eb63 (patch) | |
| tree | 0eea3928e39e50fae91d4e68b21b1e6cbae25604 /kexi/doc/dev/kexidb_sql.txt | |
| download | koffice-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.txt | 36 |
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....... |
