[irssi-scripts.git] / urllog.sql

CREATE TABLE `urls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `server` varchar(25) NOT NULL DEFAULT '<None>',
  `target` varchar(100) NOT NULL DEFAULT '<Unknown>',
  `nick` varchar(40) NOT NULL DEFAULT '<Unknown>',
  `url` text NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fullline` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10108 DEFAULT CHARSET=latin1;
Commit	Line	Data
3f24f7e4	1	CREATE TABLE `urls` (
	2	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	3	`server` varchar(25) NOT NULL DEFAULT '<None>',
	4	`target` varchar(100) NOT NULL DEFAULT '<Unknown>',
	5	`nick` varchar(40) NOT NULL DEFAULT '<Unknown>',
	6	`url` text NOT NULL,
	7	`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	8	`fullline` text NOT NULL,
	9	PRIMARY KEY (`id`)
	10	) ENGINE=InnoDB AUTO_INCREMENT=10108 DEFAULT CHARSET=latin1;