Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE rsyslogdb;
- USE rsyslogdb;
- CREATE TABLE SystemEvents
- {
- ID int unsigned not null auto_increment primary key,
- CustomerID bigint,
- ReceivedAt datetime NULL,
- DeviceReportedTime datetime 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
- };
- CREATE TABLE SystemEventsProperties
- {
- ID int unsigned not null auto_increment primary key,
- SystemEventID int NULL,
- ParamName varchar(255) NULL,
- ParamValue text NULL
- };
- [root@localhost yum.repos.d]# mysql -u root -p < /home/test/db
- Enter password:
- ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
- ID int unsigned not null auto_increment primary key,
- CustomerID bigint,
- Receiv' at line 2
- [root@localhost yum.repos.d]#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement