<?php
include ('dbconnect.php');
$sql="
CREATE DATABASE `transport` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
";
$result=mysql_query($sql);
$sql="
CREATE TABLE reportTable
(
    reportName  varchar(20) NOT NULL PRIMARY KEY,
    rus varchar(50),
    eng varchar(50),
    status  bool
);";

$result=mysql_query($sql);
$sql="
CREATE TABLE companyAndSysData
(
    dataName    varchar(100),
    dataValue   varchar(100)
);";
$result=mysql_query($sql);
$sql="
CREATE TABLE fieldTable
(
    idName  varchar(20) NOT NULL PRIMARY KEY,
    rus varchar(50),
    eng varchar(50)
);";
$result=mysql_query($sql);
$sql="
CREATE TABLE accessTable
(
    login   varchar(20),
    reportName  varchar(20),
    fieldName varchar(20)
);";



$result=mysql_query($sql);
$sql="
CREATE TABLE sysUsers
(
    id  int NOT NULL PRIMARY KEY,
    login   varchar(20) NOT NULL UNIQUE,
    passwrd varchar(50),
    username    varchar(50),
    usermail    varchar(30) UNIQUE,
    userstatus  tinyint
);";

$result=mysql_query($sql);
$sql="
INSERT INTO `transport`.`sysUsers` (
`id` ,
`login` ,
`passwrd` ,
`username` ,
`usermail` ,
`userstatus`
)
VALUES (
'1', 'bundris', '08d81ce8dcee4cf11b54f947463ec19b', 'Boris', 'gr-buratino@yandex.ru', '2'
);";

$result=mysql_query($sql);
$sql="
INSERT INTO `transport`.`sysUsers` (
`id` ,
`login` ,
`passwrd` ,
`username` ,
`usermail` ,
`userstatus`
)
VALUES (
'2', 'loki', '08d81ce8dcee4cf11b54f947463ec19b', 'Alexander', 'killgamesh666@gmail.com', '2'
);";
$result=mysql_query($sql);

?>