Forums / Cotonti / Extensions / [Release] Notifier for Cotonti

Subscribe to a topic by email or PM

tensh
#34376 2012-05-20 15:08

Contributors
Thanked: 12 times

you most probably forgot to execute some sql in your database...?

 

SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE TABLE sed_notifier (
  not_id int(11) NOT NULL auto_increment,
  not_userid int(11) default NULL,
  not_state tinyint(1) NOT NULL default '0',
  not_bypm tinyint(1) NOT NULL default '0',
  not_date int(11) NOT NULL default '0',
  not_notified int(11) NOT NULL default '0',
  not_item varchar(16) NOT NULL default '',
  not_desc varchar(128) NOT NULL default '',
  PRIMARY KEY (not_id)
) TYPE=MyISAM;
 
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('notifier_pm', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('notifier_em', '0');
 
ALTER TABLE sed_users ADD user_autosubscribe VARCHAR(5) NOT NULL default '' AFTER user_pmnotify;