<?php
// Kickstart the framework
$f3 = (require 'lib/base.php');
$f3->set('DEBUG', 1);
if ((double) PCRE_VERSION < 7.9) {
trigger_error('PCRE version is out of date');
}
$db = new DB\SQL('sqlite:database.sqlite');
$db->exec("\nDROP TABLE IF EXISTS `Objects`;\n\t\t\nCREATE TABLE `Objects` (\n `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,\n `Name` CHAR(256) NULL DEFAULT NULL,\n `Properties` MEDIUMTEXT NULL DEFAULT NULL,\n PRIMARY KEY (`id`)\n);\n\n-- ---\n-- Table 'Properties'\n-- \n-- ---\n\nDROP TABLE IF EXISTS `Properties`;\n\t\t\nCREATE TABLE `Properties` (\n `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,\n `Name` INTEGER NULL DEFAULT NULL,\n PRIMARY KEY (`id`)\n);\n\n-- ---\n-- Table 'Contents'\n-- \n-- ---\n\nDROP TABLE IF EXISTS `Contents`;\n\t\t\nCREATE TABLE `Contents` (\n `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,\n `Propertie` INT NULL DEFAULT NULL,\n `Content` INTEGER NULL DEFAULT NULL,\nKEY (`id`)\n);\n\n-- ---\n-- Foreign Keys \n-- ---\n");
$f3->route('GET /', function ($f3) {
echo $db->log();
});
require 'view/admin.php';
$f3->run();
