HOME ABOUT

Schema

typenametbl_namerootpagesql
tableClubsClubs2CREATE TABLE [Clubs] ( [Id] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(32) NOT NULL, [Code] VARCHAR(32) NOT NULL, [City] VARCHAR(32) NOT NULL )
tablesqlite_sequencesqlite_sequence3CREATE TABLE sqlite_sequence(name,seq)
tableNewsNews4CREATE TABLE [News] ( [Id] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(32) NOT NULL, [Code] VARCHAR(32) NOT NULL, [City] VARCHAR(32) NOT NULL )
tableMessagesMessages5CREATE TABLE [Messages] ( [id] INTEGER PRIMARY KEY AUTOINCREMENT, [UserName] TEXT, [Message] TEXT, [Active] BIT, [TimeStamp] DATETIME DEFAULT CURRENT_TIMESTAMP )
tableMembersMembers6CREATE 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 )
indexsqlite_autoindex_Members_1Members8
No data provided.
/home/smartsco/public_html/dbase/master.db3
/home/smartsco/public_html/dbase/s20251230a.db3