1 files changed, 30 insertions, 0 deletions
diff --git a/tests/testsuites/pgsql-basic.sql b/tests/testsuites/pgsql-basic.sql
new file mode 100644
index 0000000..8b589e2
--- /dev/null
+++ b/tests/testsuites/pgsql-basic.sql
@@ -0,0 +1,30 @@
+DROP DATABASE IF EXISTS syslogtest;
+CREATE DATABASE syslogtest;
+\c syslogtest
+
+CREATE TABLE systemevents (
+	ID serial not null primary key,
+	CustomerID bigint,
+	ReceivedAt timestamp without time zone NULL,
+	DeviceReportedTime timestamp without time zone NULL,
+	Facility smallint NULL,
+	Priority smallint NULL,
+	FromHost varchar(60) NULL,
+	Message text,
+	NTSeverity int NULL,
+	Importance int NULL,
+	EventSource varchar(60),
+	EventUser varchar(60) NULL,
+	EventCategory int NULL,
+	EventID int NULL,
+	EventBinaryData text NULL,
+	MaxAvailable int NULL,
+	CurrUsage int NULL,
+	MinUsage int NULL,
+	MaxUsage int NULL,
+	InfoUnitID int NULL ,
+	SysLogTag varchar(60),
+	EventLogType varchar(60),
+	GenericFileName VarChar(60),
+	SystemID int NULL
+);