| 485 | | // USERACTIVITY TABLE - record user activity |
| 486 | | |
| 487 | | if ($table_name == "useractivity") { |
| 488 | | //echo "table doesn't exist. Stopping before creation."; exit; |
| 489 | | $sql = "CREATE TABLE `" . DB_PREFIX . $table_name . "` ( |
| 490 | | `useract_id` int(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| 491 | | `useract_archived` enum('Y','N') NOT NULL DEFAULT 'N', |
| 492 | | `useract_updatedts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 493 | | `useract_userid` int(20) NOT NULL DEFAULT 0, |
| 494 | | `useract_status` varchar(32) NOT NULL DEFAULT 'show', |
| 495 | | `useract_key` varchar(255) NULL, |
| 496 | | `useract_value` text NULL, |
| 497 | | `useract_key2` varchar(255) NULL, |
| 498 | | `useract_value2` text NULL, |
| 499 | | `useract_date` timestamp NULL, |
| 500 | | `useract_updateby` int(20) NOT NULL DEFAULT 0, |
| 501 | | INDEX (`useract_userid`) |
| 502 | | ) ENGINE=" . DB_ENGINE . " DEFAULT CHARSET=" . DB_CHARSET . " COLLATE=" . DB_COLLATE . " COMMENT='User Activity';"; |
| 503 | | echo $lang['install_step2_creating_table'] . ": '" . DB_PREFIX . $table_name . "'...<br />\n"; |
| 504 | | $db->query($sql); |
| 505 | | } |
| 506 | | |
| 507 | | |