core/set/install/lk_sqlite3.php

26 lines
469 B
PHP
Executable File

<?php
\DB::set("CREATE TABLE IF NOT EXISTS `orders` (
`id` INTEGER PRIMARY KEY NOT NULL,
`tel` TEXT,
`fio` TEXT,
`user_id` TEXT,
`t` TEXT,
`status` TEXT,
`email` TEXT,
`org_id` INTEGER,
`manager` INTEGER,
`comment` TEXT,
`adres_dostavki` INTEGER,
`dostavka` TEXT
)
");
\DB::set("CREATE TABLE IF NOT EXISTS `users_orgs` (
`id` INTEGER PRIMARY KEY NOT NULL,
`user` INTEGER,
`org` INTEGER
)
")
?>