File: stats.sql

package info (click to toggle)
blootbot 1.2.0-6.3
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 1,368 kB
  • ctags: 603
  • sloc: perl: 16,607; sh: 147; makefile: 54; sql: 47
file content (10 lines) | stat: -rw-r--r-- 250 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE stats (
	nick VARCHAR(20) NOT NULL,
	type VARCHAR(8) NOT NULL,
	channel VARCHAR(16) NOT NULL DEFAULT "PRIVATE",

	time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
	counter SMALLINT UNSIGNED DEFAULT '0',

	PRIMARY KEY (nick,type,channel)
);