Rev 9 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 9 | Rev 14 | ||
---|---|---|---|
1 | <?php |
1 | <?php |
2 | 2 | ||
3 | if (!defined('IBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
3 | if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgeführt werden.'); |
4 | 4 | ||
5 | ib_newdatabasetable('popper_konten', $m2, 'user', "bigint(21) NOT NULL default '0'", |
5 | ib_newdatabasetable('popper_konten', $m2, 'user', "bigint(21) NOT NULL default '0'", |
6 | 'folder', "bigint(21) NOT NULL default '0'", |
6 | 'folder', "bigint(21) NOT NULL default '0'", |
7 | 'name', "varchar(255) NOT NULL default ''", |
7 | 'name', "varchar(255) NOT NULL default ''", |
8 | 'server', "varchar(255) NOT NULL default ''", |
8 | 'server', "varchar(255) NOT NULL default ''", |
9 | 'port', "int(11) NOT NULL default '0'", |
9 | 'port', "int(11) NOT NULL default '0'", |
10 | 'username', "varchar(255) NOT NULL default ''", |
10 | 'username', "varchar(255) NOT NULL default ''", |
11 | 'passwort', "varchar(255) NOT NULL default ''", |
11 | 'passwort', "varchar(255) NOT NULL default ''", |
12 | 'personenname', "varchar(255) NOT NULL default ''", |
12 | 'personenname', "varchar(255) NOT NULL default ''", |
13 | 'last_fetch', "int(11) NOT NULL default '0'", |
13 | 'last_fetch', "int(11) NOT NULL default '0'", |
14 | 'delete', "enum('0','1') NOT NULL default '1'", |
14 | 'delete', "enum('0','1') NOT NULL default '1'", |
15 | 'replyaddr', "varchar(255) default ''"); |
15 | 'replyaddr', "varchar(255) default ''"); |
16 | 16 | ||
17 | if (function_exists('set_searchable')) set_searchable($m2, 'popper_konten', 1); |
17 | if (function_exists('set_searchable')) set_searchable($m2, 'popper_konten', 1); |
18 | 18 | ||
19 | ib_newdatabasetable('popper_messages', $m2, 'user', "bigint(21) NOT NULL default '0'", |
19 | ib_newdatabasetable('popper_messages', $m2, 'user', "bigint(21) NOT NULL default '0'", |
20 | 'dir', "varchar(255) default NULL", |
20 | 'dir', "varchar(255) default NULL", |
21 | 'konto', "int(11) default NULL", |
21 | 'konto', "int(11) default NULL", |
22 | 'uidl', "varchar(255) NOT NULL default ''", |
22 | 'uidl', "varchar(255) NOT NULL default ''", |
23 | 'replyaddr', "varchar(255) default ''", |
23 | 'replyaddr', "varchar(255) default ''", |
24 | 'tos', "text", |
24 | 'tos', "text", |
25 | 'froms', "text", |
25 | 'froms', "text", |
26 | 'subject', "text", |
26 | 'subject', "text", |
27 | 'is_mime', "tinyint(1) default NULL", |
27 | 'is_mime', "tinyint(1) default NULL", |
28 | 'was_read', "tinyint(1) default NULL", |
28 | 'was_read', "tinyint(1) default NULL", |
29 | 'mail', "longtext", |
29 | 'mail', "longtext", |
30 | 'acc_id', "int(11)", |
30 | 'acc_id', "int(11)", |
31 | 'date', "varchar(14) default NULL", |
31 | 'date', "varchar(14) default NULL", |
32 | 'priority', "tinyint(4) default '0'", |
32 | 'priority', "tinyint(4) default '0'", |
33 | 'from_name', "text"); |
33 | 'from_name', "text"); |
34 | 34 | ||
35 | if (function_exists('set_searchable')) set_searchable($m2, 'popper_messages', 0); |
35 | if (function_exists('set_searchable')) set_searchable($m2, 'popper_messages', 0); |
36 | 36 | ||
37 | my_add_key($mysql_zugangsdaten['praefix'].'popper_messages', 'uidl', false, 'uidl'); |
37 | my_add_key($mysql_zugangsdaten['praefix'].'popper_messages', 'uidl', false, 'uidl'); |
38 | 38 | ||
39 | ?> |
39 | ?> |
40 | 40 |