Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
21 lines (18 sloc) 582 Bytes
CREATE TABLE karma (
id int(10) unsigned NOT NULL default '0',
user varchar(20) NOT NULL default '',
level varchar(20) NOT NULL default '',
granted_by varchar(20) NOT NULL default '',
granted_at datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id),
KEY user (user),
KEY level (level)
);
CREATE TABLE karma_seq (
id int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (id)
);
-- Add karma to admin
INSERT INTO karma (id, user, level, granted_by, granted_at)
VALUES(1, 'admin', 'pear.group', '', NOW());
INSERT INTO karma_seq (id) VALUES(NULL);