Changeset d37a49a in freewrt

Timestamp:

May 8, 2007, 5:08:55 PM (19 years ago)

Author:

Thorsten Glaser <tg@…>

Children:

c5c3ea9

Parents:

ab7d480

Message:

first draft of the actual database scheme

runs through without syntax errors; feel free to point out
any semantical errors or other improvements to me, as I know
barely enough SQL for a select statement and can't even do
insert without having the docs in front of me…

git-svn-id: ​svn://www.freewrt.org/branches/common-adk@2470 afb5a338-a214-0410-bd46-81f09a774fd1

Files:

• docs/nfo-draft (modified) (1 diff)
• tools/nfotiser/.gitignore (deleted)
• tools/nfotiser/mknfodb.sql (added)

docs/nfo-draft

@@ -354 +354 @@
 Draft database design – ERM
 
+Note: the field and database names here are shown in mixed case;
+in the actual database, only the UPPERCASE letters from the draft
+(not the underscores, lower-case letters and comments) are used as
+field names IN LOWERCASE. (e.g, desc is shorter than DESCRIPTION,
+and ord works whereas ORDER is a keyword).
+
  ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
  ┃                                              ┏━━━━━━━━━━━━━━━━━━━━━━━━━━┓              ⁿ∶¹ ┃
  ┃ ╭─────────────────╮     ╭────────────────╮   ┃    ╭─────────────╮   1:1 ┃ ╭──────────────╮ ┃     ╭─────────────╮
- ┃ │ FLAVOURS        │     │ CSYMS          │   ┃    │ SOURCES     │       ┃ │ PACKAGES     │ ┃     │ RCCONF_SYMS │
+ ┃ │ FLAVOURS        │     │ CSYMS          │   ┃    │ SOURCES     │       ┃ │ PACKAGES     │ ┃     │ RCCONF_syms │
  ┃₁├─────────────────┤ 1:1 ├────────────────┤   ┃    ├─────────────┤       ┃ ├──────────────┤ ┃     ├─────────────┤
  ┃ⁿ̄│ C̲S̲Y̲̲M̲            ┿━━━━━┿ C̲S̲Y̲M̲           ┿┳┳┳┛ ┏━━┿ D̲I̲R̲E̲C̲T̲O̲R̲Y̲   ┿━┓ 1:n ┗━┿ C̲̲S̲Y̲M̲         ┿━┛   ┏━┿ N̲A̲M̲E̲        │
  ┗━┿ PACKAGE (csym)  │     │ BROKEN         │┃┃┃  ┃  │ PERMIT_SRC  │ ┣━━━━━━━┿ SOURCE       │     ┃ │ VALUE       │
    │ FLAVOUR (name)  │     │ CITEM (type)   │┃┃┃  ┃┏━┿ DISTFILES   │ ┃       │ MENUITEM     │     ┃ │ TAG         │
-   │ PERMIT_BIN      │     │ DEFAULT        │┃┃┗━ ̴┃̴┃̴ ̴┿ VDEPS¹      │ ┃       │ NAME         │     ┃ ╰─────────────╯
- ┏━┿ BDEPS (dirs)¹   │     │ DESCRIPTION    │┃┃   ┃┃ │ URLS        │ ┃       │ VERSION      │     ┃
- ┃ ╰─────────────────╯     │ HELPTEXT       │┃┃   ┃┃ ╰─────────────╯ ┃       │ DASHVER      │     ┃
+   │ PERMIT_BIN      │     │ DEFauLT        │┃┃┗━ ̴┃̴┃̴ ̴┿ VDEPS¹      │ ┃       │ NAME         │     ┃ ╰─────────────╯
+ ┏━┿ BDEPS (dirs)¹   │     │ DESCription    │┃┃   ┃┃ │ URLS        │ ┃       │ VERSION      │     ┃
+ ┃ ╰─────────────────╯     │ HELPtext       │┃┃   ┃┃ ╰─────────────╯ ┃       │ DASHVER      │     ┃
  ┃ ⑴ m:n relationship      │ MDEPS (csyms)¹ ┿┛┃   ┃┃₁                ┃       │ PKGNAME      │     ┃
  ┃                         │ SDEPS (csyms)¹ ┿━┛   ┃┃ⁿ̄                ┃ m:n   │ PERMIT_BIN   │     ┃
  ┃ ╭─────────────╮  ┏━━━━━━┿ CATEGORY       │     ┃┃                 ┗━━━━━━━┿ BDEPS        │ 1:n ┃
  ┃ │ CATEGORIES  │  ┃ ¹∶ⁿ  │ DIRECTORY      ┿━━━━━┫┃ ╭───────────────╮       │ RCCONF_SYMS  ┿━━━━━┛
- ┃ ├─────────────┤  ┃      │ ORDER          │ ⁿ∶¹ ┃┃ │ DISTFILES     │       │ CONFFILES    │
+ ┃ ├─────────────┤  ┃      │ ORDer          │ ⁿ∶¹ ┃┃ │ DISTFILES     │       │ CONFFILES    │
  ┃ │ N̲A̲M̲E̲        ┿━━┛      ╰────────────────╯     ┃┃ ├───────────────┤       │ USERS        │
- ┃ │ DESCRIPTION │                                ┃┗━┿ D̲I̲S̲T̲F̲I̲L̲E̲      │       │ GROUPS       │
- ┃ ╰─────────────╯                            m:n ┃  │ MASTER_SITES  │       ╰──────────────╯
+ ┃ │ DESCription │                                ┃┗━┿ D̲I̲S̲T̲F̲I̲L̲E̲      │       │ GROUPS       │
+ ┃ ╰─────────────╯                            m:n ┃  │ master_SITES  │       ╰──────────────╯
  ┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛  │ HASHES        │
                                                      ╰───────────────╯