Schema
| type | name | tbl_name | rootpage | sql |
|---|
| table | Clubs | Clubs | 2 | CREATE TABLE [Clubs] (
[Id] INTEGER PRIMARY KEY AUTOINCREMENT,
[Name] VARCHAR(32) NOT NULL,
[Code] VARCHAR(32) NOT NULL,
[City] VARCHAR(32) NOT NULL
) |
| table | sqlite_sequence | sqlite_sequence | 3 | CREATE TABLE sqlite_sequence(name,seq) |
| table | News | News | 4 | CREATE TABLE [News] (
[Id] INTEGER PRIMARY KEY AUTOINCREMENT,
[Name] VARCHAR(32) NOT NULL,
[Code] VARCHAR(32) NOT NULL,
[City] VARCHAR(32) NOT NULL
) |
| table | Messages | Messages | 5 | CREATE TABLE [Messages] (
[id] INTEGER PRIMARY KEY AUTOINCREMENT,
[UserName] TEXT,
[Message] TEXT,
[Active] BIT,
[TimeStamp] DATETIME DEFAULT CURRENT_TIMESTAMP
) |
| table | Members | Members | 6 | CREATE TABLE [Members] (
[member_id] INTEGER PRIMARY KEY AUTOINCREMENT,
[nbid] VARCHAR(12) UNIQUE NOT NULL,
[firstname] VARCHAR(127) NOT NULL,
[surname] VARCHAR(127) NOT NULL,
[mobile_cell] VARCHAR(12) NOT NULL,
[email] VARCHAR(256) NOT NULL,
[active] BIT
) |
| index | sqlite_autoindex_Members_1 | Members | 8 | |
No data provided.
/home/smartsco/public_html/dbase/master.db3
/home/smartsco/public_html/dbase/s20251230a.db3