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 +mstock
| Tables in mstock | ||
|---|---|---|
| Table Name | Rows | DDL |
| MS_Project | 262 | CREATE TABLE MS_Project (
project_id INTEGER PRIMARY KEY,
hits INT,
user_id INT,
source_id INT,
foreign_id INT,
credits INT,
title_nm TEXT,
artist_nm TEXT,
artist_url TEXT,
add_dt INT,
project_nm TEXT,
project_url TEXT,
picture_url TEXT,
width_no INT,
height_no INT,
short_desc TEXT,
foreign_url TEXT
)
|
| MS_Source | 15 | CREATE TABLE MS_Source (
source_id INTEGER PRIMARY KEY,
blob_id INT,
ref_cd char(1),
source_nm TEXT,
url_pattern TEXT,
ad_url TEXT,
ad_banner TEXT)
|
| sqlite_stat1 | 0 | CREATE TABLE sqlite_stat1(tbl,idx,stat) |