Skip to content

Instantly share code, notes, and snippets.

@henideepak

henideepak/create a watchdog table in drupal

Created October 9, 2019 05:09
Show Gist options
  • Save henideepak/763d66122f7d3990f840b6d925ca901d to your computer and use it in GitHub Desktop.
Save henideepak/763d66122f7d3990f840b6d925ca901d to your computer and use it in GitHub Desktop.
Download ZIP
create a watchdog table in drupal
Raw
create a watchdog table in drupal
CREATE TABLE `watchdog` (
`wid` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`type` varchar(16) NOT NULL default '',
`message` longtext NOT NULL,
`variables` longtext NOT NULL,
`severity` tinyint(3) unsigned NOT NULL default '0',
`link` varchar(255) NOT NULL default '',
`location` text NOT NULL,
`referer` varchar(128) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`wid`),
KEY `type` (`type`)
) DEFAULT CHARSET=utf8;
@lhuachokadabra
Copy link

CREATE TABLE watchdog (
wid int(11) NOT NULL auto_increment,
uid int(11) NOT NULL default '0',
type varchar(64) NOT NULL default '',
message longtext NOT NULL,
variables longtext NOT NULL,
severity tinyint(3) unsigned NOT NULL default '0',
link varchar(255) NOT NULL default '',
location text NOT NULL,
referer varchar(128) NOT NULL default '',
hostname varchar(128) NOT NULL default '',
timestamp int(11) NOT NULL default '0',
PRIMARY KEY (wid),
KEY type (type)
) DEFAULT CHARSET=utf8;

// If you use ElasticShare as search engine

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment