foreveralone

foreveralone Git Source Tree


Root/web/application/migrations/2.php

<?php

use \vendor\DB\DB;

$autoIncrement = \system\engine\HF_Model::AUTOINCREMENT_SQLITE;
DB::query("CREATE TABLE messages (
          id INTEGER PRIMARY KEY $autoIncrement,
          user_to INTEGER,
          user_from INTEGER,
          message VARCHAR(255)
)");

DB::query("CREATE INDEX messages_to_idx ON messages(user_to)");
DB::query("CREATE INDEX messages_from_idx ON messages(user_from)");

Archive Download this file

Branches

Tags

Number of commits:
Page rendered in 0.09901s using 11 queries.