kritbit

kritbit Git Source Tree


Root/web/application/migrations/1.php

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?php
 
use \vendor\DB\DB;
 
echo "Creating session table..." . PHP_EOL;
DB::query("CREATE TABLE sessions (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          sessionid VARCHAR(255),
          ip VARCHAR(255),
          userAgent VARCHAR(255),
          data TEXT
)");
 
echo "Creating users table..." . PHP_EOL;
DB::query("CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    email VARCHAR(255)
)");
 
echo "Adding user " . PHP_EOL;
DB::insert("users", ["email" => "adamsna@datanethost.net"]);

Archive Download this file

Branches

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