Advertisement

Schema Browser

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

IDDB NamePlatformFile
1mainsqlitemain.db
Holds global information for the site including User Database and Web_Site Description
2logsqlitelog.db
Holds large logging database for the site
3dirsqlitedir.db
Contains files to create a link directory.
4calsqlitecal.db
Contains Information for the web site calendar.
5mstocksqlitemstock.db
Contains Meta Information about Mirostock used on the site.
6codesqlitecode.db
Program used to display the code used on this open source web site.
7commsqlitecomm.db
Database provides a model for analyzing a community
8msgsqlitemsg.db
Database contains messages from and to users

Connecting +mstock

Tables in mstock
Table NameRowsDDL
MS_Project258
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_Source14
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_stat10
CREATE TABLE sqlite_stat1(tbl,idx,stat)