select 
    COUNT(ID ) 
from 
    SITES 
where 
    domain = ? 

insert into 
    VISITS ( SITE , 
    DATE , 
    DAY , 
    WEEK , 
    DAYINWEEK , 
    HOUR , 
    HOURINDAY , 
    REFERRER , 
    IP , 
    URL , 
    AGENT ) 
values 
    ( ? , 
    ? , 
    ? , 
    ? , 
    ? , 
    ? , 
    ? , 
    ? , 
    ? , 
    ? , 
    ? ) 

update 
    USRS 
set 
    LOGIN = ? , 
    NAME = ? , 
    PASSWORD = ? 
where 
    ID = ? 

select 
    ID 
from 
    SITES 
where 
    domain = ? 

commit 

select 
    ID , 
    DOMAIN 
from 
    SITES 
where 
    ID = ? 

select 
    ID , 
    LOGIN , 
    NAME , 
    PASSWORD 
from 
    USRS 
where 
    ID = ? 

select 
    USRS.ID 
from 
    USRS 
order by 
    ID 

select 
    ID 
from 
    USRS 
where 
    login = ? 

create index IF NOT EXISTS IDX_VISITS_SITE on VISITS(SITE ) 

create index IF NOT EXISTS IDX_VISITS_IP on VISITS(IP ) 

create index IF NOT EXISTS IDX_VISITS_DAYINWEEK on VISITS(DAYINWEEK ) 

rollback 

create index IF NOT EXISTS IDX_VISITS_DATE on VISITS(DATE ) 

create index IF NOT EXISTS IDX_VISITS_HOUR on VISITS(HOUR ) 

create index IF NOT EXISTS IDX_VISITS_DAY on VISITS(DAY ) 

create index IF NOT EXISTS IDX_VISITS_HOURINDAY on VISITS(HOURINDAY ) 

create index IF NOT EXISTS IDX_VISITS_WEEK on VISITS(WEEK )