Пример #1
0
 public function installShrtnr()
 {
     $script = "\nCREATE TABLE `links` (\n  `lnkID` int(11) NOT NULL AUTO_INCREMENT,\n  `lnkURL` varchar(50000) NOT NULL,\n  `lnkTimestamp` datetime NOT NULL,\n  `lnkIP` varchar(15) NOT NULL,\n  `lnkClicks` int(11) NOT NULL,\n  `lnkCustomURL` varchar(10) DEFAULT NULL,\n  `lnkSingleUse` tinyint(1) DEFAULT NULL,\n  PRIMARY KEY (`lnkID`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
     if (dbconnection::execSQLUnprepared($script) === true) {
         $this->success("", false, "Database was prepared successfully! You can start using shrtnr!");
     } else {
         $this->error("Error creating shrtnr tables... maybe do it by hand?");
     }
     exit;
 }