public function __construct(array $data = array())
{
parent::__construct($data);
$this->db = Database::db();
$this->_collection_filters = array();
$this->_order_by = null;
if (!isset(self::$_create_flags[__CLASS__]) || !self::$_create_flags[__CLASS__]++) {
$this->_create();
}
}
protected function _create()
{
// VISITAS
// - id : 12871781
// - uri : sem/concurso-traje-buceo.html
// - template : sem-concursotrajebuceo-201503
// - variation : A
// - conversion: lead
Database::db()->exec("\n\t\t\tCREATE TABLE IF NOT EXISTS visits (\n\t\t\t\tid INTEGER PRIMARY KEY NOT NULL,\n\t\t\t\turi text NOT NULL,\n\t\t\t\ttemplate text NOT NULL,\n\t\t\t\tvariation text NOT NULL,\n\t\t\t\tconversion text NULL\n\t\t\t)\n\t\t");
}
/**
*
*/
protected function _create()
{
Database::db()->exec("\n\t\t\tCREATE TABLE IF NOT EXISTS hooks (\n\t\t\t\tid INTEGER PRIMARY KEY NOT NULL,\n\t\t\t\thook text NOT NULL,\n\t\t\t\tconfig text NOT NULL,\n\t\t\t\ttemplate text NOT NULL,\n\t\t\t\tstatus INTEGER NOT NULL\n\t\t\t)\n ");
}
/**
*
*/
protected function _create()
{
// VISTAS Y CONVERSIONES POR PLANTILLA/VARIACIÓN
// - template : sem-concursotrajebuceo-201503
// - variation : A
// - views : 436
// - conversions : 5
Database::db()->exec("\n\t\t\tCREATE TABLE IF NOT EXISTS stats (\n\t\t\t\ttemplate text NOT NULL,\n\t\t\t\tvariation text NOT NULL,\n\t\t\t\tviews integer NOT NULL,\n\t\t\t\tconversions integer NOT NULL\n\t\t\t)\n\t\t");
}
