SQLite format 3

@  ~A

�
~A.?�
�
Iv$

�
9
�	D��ITI�!�3//
�{tablesqlb_temp_table_2sqlb_temp_table_2CREATE TABLE "sqlb_temp_table_2" (
	"id"	INTEGER NOT NULL,
	"name"	VARCHAR(150),
	"active"	BOOLEAN NOT NULL DEFAULT 1,
	"user_id"	INTEGER,
	"interval"	INTEGER NOT NULL DEFAULT 20,
	"url"	TEXT,
	"type"	VARCHAR(20),
	"weight"	INTEGER DEFAULT 2000,
	"hostname"	VARCHAR(255),
	"port"	INTEGER,
	"created_date"	TIMESTAMP,
	"keyword"	VARCHAR(255),
	"maxretries"	INTEGER NOT NULL DEFAULT 0,
	PRIMARY KEY("id" AUTOINCREMENT),
	FOREIGN KEY("user_id") REFERENCES "user"("id") ON DELETE SET NUL�//
�gtablesqlb_�
�gtablemonitormonitorCREATE TABLE "monitor" (
	"id"	INTEGER NOT NULL,
	"name"	VARCHAR(150),
	"active"	BOOLEAN NOT NULL DEFAULT 1,
	"user_id"	INTEGER,
	"interval"	INTEGER NOT NULL DEFAULT 20,
	"url"	TEXT,
	"type"	VARCHAR(20),
	"weight"	INTEGER DEFAULT 2000,
	"hostname"	VARCHAR(255),
	"port"	INTEGER,
	"created_date"	TIMESTAMP,
	"keyword"	VARCHAR(255),
	"maxretries"	INTEGER NOT NULL DEFAULT 0,
	PRIMARY KEY("id" AUTOINCREMENT),
	FOREIGN KEY("user_id") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE CASCADE
)�(
A5
�gindexmonitor_notification_indexmonitor_notificationCREATE INDEX [monitor_notification_index]
ON [monitor_notification](
  [monitor_id], 
  [notification_id])"J
iindexuser_idmonitor
CREATE INDEX [user_id] ON [monitor]([user_id])R
uindeximportantheartbeatCREATE INDEX [important] ON [heartbeat]([important])U
!
yindexmonitor_idheartbeatCREATE INDEX [monitor_id] ON [heartbeat]([monitor_id])�M	55
�=tablemonitor_notificationmonitor_notification
CREATE TABLE [monitor_notification](
  [id] INTEGER PRIMARY KEY NOT NULL, 
  [monitor_id] INTEGER NOT NULL REFERENCES [monitor]([id]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [notification_id] INTEGER NOT NULL REFERENCES [notification]([id]) ON DELETE CASCADE ON UPDATE CASCADE)�r%%
�'tablenotificationnotification	CREATE TABLE [notification](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
  [name] VARCHAR(255), 
  [config] VARCHAR(255), 
  [active] BOOLEAN NOT NULL DEFAULT 1, 
  [user_id] INTEGER NOT NULL)�7
�EtablesettingsettingCREATE TABLE [setting](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT, 
  [key] VARCHAR(200) NOT NULL UNIQUE, 
  [value] VARCHAR(200), 
  [type] VARCHAR(20))-A
indexsqlite_autoindex_setting_1setting
�
�tablemonitormonitorCREATE TABLE [monitor](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
  [name] VARCHAR(150), 
  [active] BOOLEAN NOT NULL DEFAULT 1, 
  [user_id] INTEGER REFERENCES [user]([id]) ON DELETE SET NULL ON UPDATE CASCADE, 
  [interval] INTEGER NOT NULL DEFAULT 20, 
  [url] TEXT, 
  [type] VARCHAR(20), 
  [weight] INTEGER DEFAULT 2000, 
  [hostname] VARCHAR(255),L
qindexuser_idmonitorCREATE INDEX "user_id" ON "monitor" (
	"user_id"
)�m
�=tableuseruserCREATE TABLE [user](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
  [username] VARCHAR(255) NOT NULL UNIQUE, 
  [password] VARCHAR(255), 
  [active] BOOLEAN NOT NULL DEFAULT 1, 
  [timezone] VARCHAR(150))';
indexsqlite_autoindex_user_1userP++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�

�]tableheartbeatheartbeatCREATE TABLE [heartbeat](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
  [important] BOOLEAN NOT NULL DEFAULT 0, 
  [monitor_id] INTEGER NOT NULL REFERENCES [monitor]([id]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [status] SMALLINT NOT NULL, 
  [msg] TEXT, 
  [time] DATETIME NOT NULL, 
  [ping] INTEGER, 
  [duration] INTEGER NOT NULL DEFAULT 0)


�������
notification	�
setting�

monitorsqlb_

monitor