interrobot.v2.db•4.08 MB
SQLite format 3 @ � + .zq � 1���A��C] -
A indexsqlite_autoindex_Plugins_1Plugins�
�tableOptionsOptionsCREATE TABLE Options
(
Id INTEGER Primary Key Autoincrement NOT NULL,
Key VARCHAR(32) NOT NULL,
Value VARCHAR(255) NOT NULL,
UNIQUE(Key) ON CONFLICT REPLACE
)-A indexsqlite_autoindex_Options_1Options��etableCrawlsCrawls CREATE TABLE Crawls
(
Id INTEGER Primary Key Autoincrement NOT NULL,
Project INTEGER NOT NULL,
UniqueId VARCHAR(64) NOT NULL,
Created VARCHAR(32) NOT NULL,
Modified VARCHAR(32) NOT NULL,
Complete INTEGER NOT NULL,
Timer INTEGER NOT NULL,
Report TEXT NOT NULL,
Log TEXT NOT NULL,
UNIQUE(Project, UniqueId) ON CONFLICT REPLACE,
FOREIGN KEY (Project) REFERENCES Projects(Id) ON DELETE CASCADE
)+ ? indexsqlite_autoindex_Crawls_1Crawls
��
tableQueuersQueuersCREATE TABLE Queuers
(
Id INTEGER Primary Key Autoincrement NOT NULL,
Project INTEGER NOT NULL,
Crawl INTEGER NOT NULL,
Created VARCHAR(32) NOT NULL,
Modified VARCHAR(32) NOT NULL,
Url VARCHAR(2048) NOT NULL,
Type INTEGER NOT NULL,
External INTEGER NOT NULL,
UNIQUE(Project, Url) ON CONFLICT REPLACE,
FOREIGN KEY (Project) REFERENCES Projects(Id) ON DELETE CASCADE,
FOREIGN KEY (Crawl) REFERENCES Crawls(Id) ON DELETE CASCADE
)-A indexsqlite_autoindex_Queuers_1Queuers��]tableResourcesResourcesCREATE TABLE Resources
(
Id INTEGER Primary Key Autoincrement NOT NULL,
Project INTEGER NOT NULL,
Crawl INTEGER NOT NULL,
Created VARCHAR(32) NOT NULL,
Modified VARCHAR(32) NOT NULL,
Name VARCHAR(255) NOT NULL,
Href VARCHAR(2048) NOT NULL,
Url VARCHAR(2048) NOT NULL,
Collection INTEGER NOT NULL,
Type INTEGER NOT NULL,
Status INTEGER NOT NULL,
External INTEGER NOT NULL,
Redirect INTEGER NOT NULL,
NoRobots INTEGER NOT NULL,
Ip VARCHAR(128) NOT NULL,
Size INTEGER NOT NULL,
Time INTEGER NOT NULL,
LinksHealth INTEGER NOT NULL,
AssetsHealth INTEGER NOT NULL,
UNIQUE(Project, Href) ON CONFLICT REPLACE,
FOREIGN KEY (Project) REFERENCES Projects(Id) ON DELETE CASCADE,
FOREIGN KEY (Crawl) REFERENCES Crawls(Id) ON DELETE CASCADE
)1E indexsqlite_autoindex_Resources_1ResourcesP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�'�!tableProjectsProjectsCREATE TABLE Projects
(
Id INTEGER Primary Key Autoincrement NOT NULL,
Crawl INTEGER DEFAULT NULL,
Created VARCHAR(32) NOT NULL,
Modified VARCHAR(32) NOT NULL,
Url VARCHAR(2048) NOT NULL UNIQUE,
Status INTEGER NOT NULL,
Icon BLOB NOT NULL,
RobotsText TEXT NOT NULL,
RobotsUpdated VARCHAR(32) NOT NULL,
ValidatedFile INTEGER NOT NULL,
Settings TEXT NOT NULL,
FOREIGN KEY (Crawl) REFERENCES Crawls(Id) ON DELETE SET NULL
)/C indexsqlite_autoindex_Projects_1Project
J J �C EE5�n�9O
2025-05-27T17:37:34.1960096Z2025-05-27T17:37:34.2628161Zhttps://pragmar.com/�PNG
IHDR \r�f sBIT|d� (IDATx����n�g����'3;v���T@�B�UY"���
��,��% $�t����**�*�Ci m�!A�����N<.�]X��<����������?{~=fۛ�|F�l�a��џ߰:]D�q�>� � (&