2c2
< // $Id: customfilter.install,v 1.3.2.1 2007/10/27 17:07:32 arhip Exp $
---
> // $Id: customfilter.install,v 1.3.2.2 2007/12/31 15:28:38 arhip Exp $
16c16
<         `cache` boolean NOT NULL default '1',
---
>         `cache` tinyint(1) NOT NULL default '1',
19c19,21
<         `longtips` text);");
---
>         `longtips` text,
>         PRIMARY KEY(sid) 
>       ) /*!40100 DEFAULT CHARACTER SET UTF8 */");
30,31c32,35
<         `func` boolean NOT NULL default '0',
<         `weight` int(5) NOT NULL default '0');");
---
>         `func` tinyint(1) NOT NULL default '0',
>         `weight` int(5) NOT NULL default '0',
>         PRIMARY KEY(fid)
>       ) /*!40100 DEFAULT CHARACTER SET UTF8 */");
33,34c37
<       break;    
< 
---
>       break;
36,37d38
<       db_query("DROP SEQUENCE customfilter_set_sid_seq");
<       db_query("DROP SEQUENCE customfilter_filter_fid_seq");
39,41c40,42
<         sid int NOT NULL default '0',
<         name varchar NOT NULL default '',
<         cache int NOT NULL default '1',
---
>         sid serial,
>         name varchar(32) NOT NULL default '',
>         cache smallint NOT NULL default '1',
44c45,47
<         longtips text);");
---
>         longtips text,
>         PRIMARY KEY(sid) 
>       )");
47,50c50,53
<         fid int NOT NULL default '0',
<         sid int NOT NULL default '0',
<         parentid int NOT NULL default '0',
<         name varchar NOT NULL default '',
---
>         fid serial,
>         sid int_unsigned NOT NULL default '0',
>         parentid int_unsigned NOT NULL default '0',
>         name varchar(32) NOT NULL default '',
52c55
<         matches int NOT NULL default '1',
---
>         matches smallint NOT NULL default '1',
55,59c58,63
<         func int NOT NULL default '0',
<         weight int NOT NULL default '0');");
<         db_query("CREATE SEQUENCE customfilter_set_sid_seq");
<         db_query("CREATE SEQUENCE customfilter_filter_fid_seq");
<       break;  
---
>         func smallint NOT NULL default '0',
>         weight int NOT NULL default '0',
>         PRIMARY KEY(fid)
>       )");
>         
>       break;
74,86c78,79
<   switch ($GLOBALS['db_type']) {
<     case 'mysql':
<     case 'mysqli':
<       db_query("DROP TABLE {customfilter_filter}");
<       db_query("DROP TABLE {customfilter_set}");
<     break;
<     case 'pgsql':
<       db_query("DROP TABLE {customfilter_filter}");
<       db_query("DROP TABLE {customfilter_set}");
<       db_query("DROP SEQUENCE customfilter_set_sid_seq");
<       db_query("DROP SEQUENCE customfilter_filter_fid_seq");
<     break;
<   }
---
>   db_query("DROP TABLE {customfilter_filter}");
>   db_query("DROP TABLE {customfilter_set}");
94c87,95
<   $result[] = update_sql("ALTER TABLE {customfilter_set} ADD COLUMN `cache` int NOT NULL default '1' AFTER `name`;");
---
>   
>   switch ($GLOBALS['db_type']) {
>     case 'mysql':
>     case 'mysqli':
>       $result[] = update_sql("ALTER TABLE {customfilter_set} ADD COLUMN `cache` boolean NOT NULL default '1' AFTER `name`;");
>       break;
>     case 'pgsql':
>       break;
>   }