Example MSSQL and MySQL tables to hold logging data:
/*MSSQL*/ CREATE TABLE [dbo].[CRUSHFTP_LOG]( [LOG_ROW_NUM] [float] NOT NULL, [LOG_MILLIS] [float] NOT NULL, [LOG_TAG] [varchar](50) NULL, [LOG_DATA] [varchar](2000) NULL, CONSTRAINT [PK_CRUSHFTP_LOG] PRIMARY KEY CLUSTERED ( [LOG_ROW_NUM] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /*MYSQL*/ CREATE TABLE `CRUSHFTP_LOG` ( LOG_ROW_NUM DOUBLE NOT NULL PRIMARY KEY, LOG_MILLIS DOUBLE NOT NULL, LOG_TAG VARCHAR(50) DEFAULT NULL, LOG_DATA VARCHAR(2000) DEFAULT NULL);
Add new attachment
Only authorized users are allowed to upload new attachments.
«
This particular version was published on 25-Oct-2018 04:31 by Ben Spink.
G’day (anonymous guest)
Log in
JSPWiki