Changeset 1526246
- Timestamp:
- 11/01/2016 07:57:41 PM (9 years ago)
- File:
-
- 1 edited
-
swiftpost/trunk/swiftpost-setup.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
swiftpost/trunk/swiftpost-setup.php
r1506183 r1526246 229 229 id bigint(20) unsigned NOT NULL AUTO_INCREMENT, 230 230 postid bigint(20) unsigned NOT NULL, 231 status varchar(15) COLLATE utf8mb4_unicode_ciNOT NULL DEFAULT 'live',231 status varchar(15) NOT NULL DEFAULT 'live', 232 232 run int(11) NOT NULL DEFAULT '1', 233 233 impressions int(11) NOT NULL DEFAULT '0', 234 234 order_id int(15) NOT NULL DEFAULT '0', 235 235 lineitem_id int(15) NOT NULL DEFAULT '0', 236 slotid varchar(64) COLLATE utf8mb4_unicode_ciNOT NULL,236 slotid varchar(64) NOT NULL, 237 237 startdate date NOT NULL DEFAULT '0000-00-00', 238 238 starttime varchar(12) NOT NULL DEFAULT '12:00am', 239 239 enddate date NOT NULL DEFAULT '0000-00-00', 240 240 endtime varchar(12) NOT NULL DEFAULT '11:45pm', 241 fc varchar(6) COLLATE utf8mb4_unicode_ciNOT NULL,242 fc_impressions varchar(8) COLLATE utf8mb4_unicode_ciNOT NULL,243 fc_howmany varchar(8) COLLATE utf8mb4_unicode_ciNOT NULL,244 fc_type varchar(16) COLLATE utf8mb4_unicode_ciNOT NULL,245 fc_lifetime varchar(32) COLLATE utf8mb4_unicode_ciNOT NULL,246 gd varchar(6) COLLATE utf8mb4_unicode_ciNOT NULL,247 geo text COLLATE utf8mb4_unicode_ciNOT NULL,248 post_status varchar(20) COLLATE utf8mb4_unicode_ciNOT NULL DEFAULT 'off',241 fc varchar(6) NOT NULL, 242 fc_impressions varchar(8) NOT NULL, 243 fc_howmany varchar(8) NOT NULL, 244 fc_type varchar(16) NOT NULL, 245 fc_lifetime varchar(32) NOT NULL, 246 gd varchar(6) NOT NULL, 247 geo text NOT NULL, 248 post_status varchar(20) NOT NULL DEFAULT 'off', 249 249 created datetime NOT NULL, 250 250 timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, … … 258 258 dbDelta("CREATE TABLE IF NOT EXISTS {$wpdb->prefix}swiftpost_abtest ( 259 259 id bigint(20) unsigned NOT NULL AUTO_INCREMENT, 260 name varchar(64) COLLATE utf8mb4_unicode_ciNOT NULL DEFAULT 'A/B Test',260 name varchar(64) NOT NULL DEFAULT 'A/B Test', 261 261 hypothesis text, 262 262 postid_a bigint(20) unsigned NOT NULL, … … 268 268 enddate date NOT NULL DEFAULT '0000-00-00', 269 269 endtime varchar(12) NOT NULL DEFAULT '11:45pm', 270 status varchar(15) COLLATE utf8mb4_unicode_ciNOT NULL DEFAULT 'running',270 status varchar(15) NOT NULL DEFAULT 'running', 271 271 created datetime NOT NULL, 272 272 timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
Note: See TracChangeset
for help on using the changeset viewer.