CREATE TABLE ef_offers_master (
offer_id TEXT,
offer_advid TEXT,
offer_advertiser TEXT,
offer_class TEXT,
offer_weight TEXT
);
INSERT INTO ef_offers_master (offer_id, offer_advid, offer_advertiser, offer_class, offer_weight) VALUES
('1','1','adv1','app-trial','0'),
('2','2','adv2','app-trial','A0'),
('3','3','adv3','app-search','B111'),
('4','4','adv4','app-search','0'),
('5','1','adv1','app-hm','B111'),
('6','2','adv2','app-misc','0'),
('7','2','adv2','app-hm','A'),
('8','3','adv3','app-trial','F211'),
('9,','5','adv5','app-trial','Z22'),
('10,','5','adv5','app-trial','X12'),
('11,','11','adv11','app-search','A1');
CREATE TABLE default_class_weights (
offer_class TEXT,
default_weight TEXT
);
INSERT INTO default_class_weights ( offer_class, default_weight) VALUES
('app-trial' , 'A'),
('app-hm', 'B'),
('app-search', 'C');
CREATE TABLE default_adv_weights (
advertiser_name TEXT,
advertiser_id TEXT,
advertiser_weight TEXT
);
INSERT INTO default_adv_weights ( advertiser_name, advertiser_id, advertiser_weight) VALUES
('adv1' , '1', '111'),
('adv2', '2', '222'),
('adv3', '3', '333'),
('adv4', '4', '444');