Check-in [57183d69b5]
Overview
Comment:Added database notes
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:57183d69b5196b9fa22a620c9563d859d0cbb51b
User & Date: rkeene on 2014-09-07 11:00:42
Other Links: manifest | tags
Context
2014-09-07
11:01
Formatting fixes check-in: 4c07c8ed11 user: rkeene tags: trunk
11:00
Added database notes check-in: 57183d69b5 user: rkeene tags: trunk
10:44
Working on making the Tcl result usable by C check-in: 9b31b33a93 user: rkeene tags: trunk
Changes

Modified README.md from [ab12e62b97] to [ebe9eec651].

     6      6   Paths
     7      7   -----
     8      8   AppFS should normally be mounted on "/opt/appfs".
     9      9   
    10     10   /opt/appfs/hostname
    11     11   	Fetches: http://hostname/appfs/index
    12     12   	Contains CSV file: hash,extraData
    13         -
    14     13   	Fetches: http://hostname/appfs/sha1/<hash>
    15     14   	Contains CSV file: package,version,os,cpuArch,sha1,isLatest
    16     15   
    17     16   /opt/appfs/hostname/package/os-cpuArch/version
    18     17   /opt/appfs/hostname/sha1/
    19     18   	Fetches: http://hostname/appfs/sha1/<sha1>
    20     19   	Contains CSV file:
................................................................................
    22     21   		type == directory; extraData = (null)
    23     22   		type == symlink; extraData = source
    24     23   		type == file; extraData = size,sha1
    25     24   
    26     25   /opt/appfs/hostname/{sha1,package/os-cpuArch/version}/file
    27     26   	Fetches: http://hostname/appfs/sha1/<sha1>
    28     27   
           28  +Database
           29  +--------
           30  +    hostname_to_packages(hostname, sha1);
           31  +    package_info(sha1 PRIMARY KEY, package, version, os, cpuArch, isLatest)
           32  +    package_to_files(package_sha1, type, time, source, size, file_sha1, name)