g75h6DzV

1<?php
2
3
4
5
6CREATE TABLE IF NOT EXISTS {db_prefix}log_enotify_pms (
7  id_enot mediumint(8) NOT NULL auto_increment,
8  enot_item_id mediumint(8) NOT NULL,
9  enot_title varchar(255) NOT NULL,
10  enot_time int(10) NOT NULL,
11  enot_link tinytext NOT NULL,
12  enot_sender varchar(255) NOT NULL,
13  enot_sender_link text NOT NULL,
14  id_member mediumint(8) NOT NULL,
15  enot_read tinyint(3) NOT NULL default '0',
16  PRIMARY KEY  (id_enot),
17  UNIQUE KEY enot_item_id (enot_item_id)
18)");
19
20
21CREATE TABLE IF NOT EXISTS {db_prefix}log_enotify_replies (
22  id_enot mediumint(8) NOT NULL auto_increment,
23  enot_item_id mediumint(8) NOT NULL,
24  enot_title varchar(255) NOT NULL,
25  enot_time int(10) NOT NULL,
26  enot_link tinytext NOT NULL,
27  enot_sender varchar(255) NOT NULL,
28  enot_sender_link text NOT NULL,
29  id_member mediumint(8) NOT NULL,
30  enot_read tinyint(3) NOT NULL default '0',
31  PRIMARY KEY  (id_enot),
32  UNIQUE KEY enot_item_id (enot_item_id)
33)");
34
35
36INSERT IGNORE INTO {db_prefix}settings
37	(variable, value)
38VALUES ('enotify_life', '5000'),
39	('enotify_refresh', '10000'),
40	('enotify_pms', '1'),
41	('enotify_replies', '1'),
42	('enotify_exp', '48')");
43
44?>