I am using SQLite3 for my primary database. SQLite has extremely simple schema that consists of one table called "sqlite_master". This program lets you see the schema of select databases on my server.
I will also open source the code for the site which you can browse with the Code Viewer
Available Databases | ||||
|---|---|---|---|---|
| ID | DB Name | Platform | File | |
| 1 | main | sqlite | main.db | |
| Holds global information for the site including User Database and Web_Site Description | ||||
| 2 | log | sqlite | log.db | |
| Holds large logging database for the site | ||||
| 3 | dir | sqlite | dir.db | |
| Contains files to create a link directory. | ||||
| 4 | cal | sqlite | cal.db | |
| Contains Information for the web site calendar. | ||||
| 5 | mstock | sqlite | mstock.db | |
| Contains Meta Information about Mirostock used on the site. | ||||
| 6 | code | sqlite | code.db | |
| Program used to display the code used on this open source web site. | ||||
| 7 | comm | sqlite | comm.db | |
| Database provides a model for analyzing a community | ||||
| 8 | msg | sqlite | msg.db | |
| Database contains messages from and to users | ||||
Connecting +code
| Tables in code | ||
|---|---|---|
| Table Name | Rows | DDL |
| Code_Package | 0 | CREATE TABLE Code_Package ( package_id INTEGER PRIMARY KEY, parent_id INTEGER default 0, version_id INTEGER default 0, revision_id INTEGER default 0, package_nm TEXT, package_desc TEXT) |
| Code_Revision | 8 | CREATE TABLE Code_Revision (
change_id INTEGER PRIMARY KEY,
code_id INTEGER not null,
version_id INTEGER DEFAULT 0,
revision_id INTEGER DEFAULT 0,
user_id INTEGER DEFAULT 0,
revision_ts REAL not null,
md5_hash TEXT default '',
desc_txt TEXT, blog_url TEXT);
CREATE INDEX Code_Rev_Code_IX
ON Code_Revision (code_id)
|
| Code_Viewer | 11 | CREATE TABLE Code_Viewer (
code_id INTEGER PRIMARY KEY NOT NULL,
hit_cnt INTEGER default 0,
display_cd INTEGER default 0,
category_id INTEGER default 0,
version_id INTEGER default 0,
revision_id INTEGER default 0,
program_nm TEXT,
code_path TEXT,
url TEXT,
keywords TEXT,
short_desc TEXT,
package_id INTEGER default 0)
|
| Test_Table | 1 | CREATE TABLE Test_Table (test_id INTEGER PRIMARY KEY, test_nm TEXT) |