zCeGJegq

1$createCouponTableQuery = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}frequentVisitorCoupons_coupons (
2    couponId mediumint not null auto_increment unique,
3    primary key (couponId),
4    totalHits mediumint not nu ll,
5    isText boolean not null,
6    imageUrl text(1000)
7    )";
8
9    $createTargetTableQuery = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}frequentVisitorCoupons_targets (
10      targetId medium int not null auto_increment unique,
11      primary key (targetId),
12      isSitewide tinyint(1) not null,
13      targetUrl varchar(500),
14      displayThreshold tinyint(5) not null default 20,
15      offerCutoff tinyint(5),
16      fk_coupons_targets mediumint not null unique,
17      foreign key fk_coupons_targets references wp_frequentVisitorCoupons_coupons(couponId) on delete cascade
18    )";
19
20    $createVisitsTableQuery = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}frequentVisitorCoupons_visits (
21      visitId mediumint(9) not null auto_increment unique,
22      primary key (visitId),
23      visitorId mediumint(9) not null,
24      urlVisited varchar(500) not null
25    )";