Repository navigation
Expand file tree
/
Copy pathschema.sql
More file actions
28 lines (28 loc) · 3.18 KB
/
Copy pathschema.sql
File metadata and controls
28 lines (28 loc) · 3.18 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
CREATE TABLE Computer (FileSystem TEXT, Hardware TEXT, IsRouter INTEGER, IsPlayer INTEGER, IsRented INTEGER, Users TEXT, ConfigOS TEXT, Procs TEXT, IsCTF INTEGER, ID TEXT PRIMARY KEY);
CREATE TABLE InfoGen (Seed INTEGER, VersionsControl TEXT, Exploits TEXT DEFAULT '', Guilds TEXT, Clock TEXT, DeleteVersion INTEGER, AllLibs TEXT DEFAULT '', Invoices TEXT DEFAULT '', GlobalMoney TEXT, ZeroDaySystem TEXT);
CREATE TABLE Players (ComputerID TEXT, PlayerID TEXT PRIMARY KEY, infoMapX REAL, infoMapY REAL, indMap INTEGER, Storage TEXT DEFAULT '', GameOver INTEGER DEFAULT 0, Nickname TEXT DEFAULT '', TutoData TEXT DEFAULT '', Missions TEXT DEFAULT '', LastConnection TEXT, WalletID TEXT DEFAULT '', WalletPass TEXT DEFAULT '', MissionsCooldown TEXT DEFAULT '', CTFCooldown TEXT DEFAULT '', RentalsInfo TEXT DEFAULT '', StocksInfo TEXT DEFAULT '', LoginData TEXT DEFAULT '', ShopHardware longtext NOT NULL, BankUser TEXT DEFAULT '', ZeroDayRequest longtext DEFAULT '', BankTraces TEXT DEFAULT '', TLCooldown TEXT DEFAULT '', TokenTrace TEXT DEFAULT '', PassiveTraces TEXT DEFAULT '', GuiLaunchCooldown TEXT DEFAULT '');
CREATE TABLE MailAccounts (Mails TEXT, User TEXT PRIMARY KEY, password TEXT);
CREATE TABLE WebPages (Web TEXT, ExternalPort INTEGER, PublicIp TEXT, LocalIp TEXT, Address TEXT, TypeNet INTEGER, NumVisits INTEGER DEFAULT 0, DateCreation INTEGER DEFAULT 0, PRIMARY KEY(PublicIp, LocalIp));
CREATE TABLE BankAccounts (Transactions TEXT, User TEXT PRIMARY KEY, Password TEXT);
CREATE TABLE Files (ID TEXT PRIMARY KEY, Content TEXT, refCount INTEGER NOT NULL DEFAULT 1);
CREATE TABLE Map (posX REAL, posY REAL, Bssid TEXT, Essid TEXT, ID TEXT, WebAddress TEXT, TipoRed INTEGER, Seed INTEGER, Mission TEXT DEFAULT '', IpAddress TEXT PRIMARY KEY, AccessType INTEGER, LibVersions TEXT, generateds TEXT DEFAULT '', MissionNpcNames TEXT, Date INTEGER, GenerationProfile INTEGER DEFAULT 0);
CREATE TABLE Passwords (ID TEXT PRIMARY KEY, PlainPassword TEXT);
CREATE TABLE Logs (ID TEXT PRIMARY KEY, Log TEXT);
CREATE TABLE Coins (CoinName TEXT PRIMARY KEY, CoinContent TEXT, OwnerPlayerID TEXT, WebAddress TEXT DEFAULT '');
CREATE TABLE Stocks (Id INTEGER PRIMARY KEY AUTOINCREMENT, IpAddress TEXT UNIQUE, StocksContent TEXT, points INTEGER);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE Wallets (WalletID TEXT PRIMARY KEY, WalletContent TEXT);
CREATE TABLE CTFs (EventName TEXT PRIMARY KEY, EventContent TEXT, OwnerPlayerID TEXT);
CREATE TABLE SharedConns (ComputerID TEXT PRIMARY KEY, Players TEXT);
CREATE TABLE PlayerConns (ComputerID TEXT PRIMARY KEY, RouterID TEXT, LocalIp TEXT);
CREATE TABLE BackupPlayers (ID TEXT PRIMARY KEY, FileSystem TEXT, IsRouter INTEGER, Users TEXT, ConfigOS TEXT, Hardware TEXT);
CREATE TABLE BackupPlayerFiles (ID TEXT PRIMARY KEY, Content TEXT, RouterID TEXT);
CREATE INDEX idxEbssid ON Map (Bssid, Essid);
CREATE INDEX idxWebAddress ON Map (WebAddress);
CREATE INDEX idxTypeNet ON WebPages (TypeNet);
CREATE INDEX idxNumVisits ON WebPages (NumVisits);
CREATE INDEX idxDateCreation ON WebPages (DateCreation);
CREATE INDEX idxAddress ON WebPages (Address);
CREATE INDEX idx_posXY ON Map(posX, posY);
CREATE INDEX idxStockAddress ON Stocks(IpAddress);
CREATE INDEX idxRouterID ON BackupPlayerFiles(RouterID);