
//  text
CREATE TABLE baners ( id counter, banername string, chenal string, fromfile string, fileline integer DEFAULT 0 , activate bit DEFAULT -1, period integer DEFAULT 10 , timeon integer DEFAULT 0 ) 

CREATE TABLE count_user ( id counter, name string, dater date) 

CREATE TABLE count_chenal ( id counter, chenal string, name string, dater date) 

ALTER TABLE Users ADD COLUMN onlinetimer integer DEFAULT 0 
UPDATE users SET onlinetimer=0

ALTER TABLE Users ADD COLUMN startdate date 
UPDATE users SET startdate= Day(Now()) & "." & Month(Now()) & "." & Year(Now())  

ALTER TABLE Users ADD COLUMN lastdate date 
UPDATE users SET lastdate=Day(Now()) & "." & Month(Now()) & "." & Year(Now()) 

INSERT INTO textres ( textper, textval ) VALUES ("BanerStart", "**************************" )
INSERT INTO textres ( textper, textval ) VALUES ("Banerend",   "************************************************************ " )




//update users set pass=name&name where pass is null

INSERT INTO Setting ( per, valuep ) VALUES ("useronline", 0 );
INSERT INTO Setting ( per, valuep ) VALUES ("alluser", 0 );
INSERT INTO Setting ( per, valuep ) VALUES ("timeon", 0 );
INSERT INTO Setting ( per, valuep ) VALUES ("vicstart", 0 );






//  
update Setting set valuep=5 WHERE per="ver"