

DELETE FROM vcard_template_o;

INSERT INTO vcard_setting VALUES (NULL,'0','vcard version', 'vcardversion', '2.3', 'vcard version', 'vcardversion', '0');

INSERT INTO vcard_setting VALUES (NULL,'8','Online Users', 'online_users', '0', 'Do you want know online users feature?', 'yesno', '0');



CREATE TABLE vcard_useronline ( 

	timestamp int(15) DEFAULT '0' NOT NULL, 

	ip varchar(40) NOT NULL, 

	file varchar(100) NOT NULL, 

	KEY (timestamp), 

	KEY ip (ip), 

	KEY file (file) 

);



ALTER TABLE vcard_cards CHANGE message_id message_id VARCHAR(25) NOT NULL;



