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 +msg
| Tables in msg | ||
|---|---|---|
| Table Name | Rows | DDL |
| Message_Action | 5820 | CREATE TABLE Message_Action (
msg_id INTEGER,
user_id INTEGER,
action_cd char(1),
add_ts REAL,
ip_id INTEGER,
note_txt TEXT
)
|
| Message_Auth | 5 | CREATE TABLE Message_Auth (
grantee_id INTEGER,
user_id INTEGER,
PRIMARY KEY (user_id,grantee_id)
);
|
| Message_Box | 5 | CREATE TABLE Message_Box (
user_id INTEGER,
box_nm TEXT,
anon_yn char(1),
exp_dt INTEGER,
base_url TEXT,
blob_txt TEXT,
PRIMARY KEY (user_id,box_nm)
);
|
| Message_Data | 4716 | CREATE TABLE Message_Data (
msg_id INTEGER PRIMARY KEY,
to_id INT,
from_id INT,
parent_id INT,
type_id INT,
site_id INT,
fk_id INT,
box_nm TEXT,
add_ts TEXT,
status_fl char(1),
weight_no INT,
respond_yn char(1),
from_nm TEXT,
email_addr TEXT,
subject_str TEXT,
link_url TEXT,
msg_txt Text);
CREATE INDEX Message_To_IX
ON Message_Data (to_id);
CREATE INDEX Message_FROM_IX
ON Message_Data (from_id)
|
| Message_Type | 4 | CREATE TABLE Message_Type (
type_id INTEGER PRIMARY KEY,
type_nm TEXT,
prog_str TEXT
)
|