24gTLtq7

1on error exit
2/
3
4if not exists fbcounter
5/
6create table fbcounter(
7module_id vchar(25),
8attribute_id vchar(25),
9dim_value vchar(25),
10client vchar(25),
11att_owner vchar(25),
12rel_att_owner vchar(25),
13rel_value vchar(25),
14prefiks vchar(25),
15counter int8,
16last_update date,
17user_stamp vchar(25)
18)
19/
20end if
21/
22DROP INDEX uidfbcounter
23/
24CREATE UNIQUE INDEX uidfbcounter ON fbcounter (module_id, attribute_id, dim_value, rel_value, client)
25/
26DELETE FROM aagindex WHERE index_name='evifbcounter'
27/
28INSERT INTO aagindex (column_list,db_name,frequency,index_name,location_name,module,multi_company,status,storage_struct,table_name,type,unique_flag,with_clause) 
29 VALUES ('module_id, attribute_id, dim_value, rel_value, client','ALL','ANN','evifbcounter','','EV',0,'N','','fbcounter','',1,'' ) 
30/