/trongate-framework

The Trongate PHP framework

Primary LanguagePHPOtherNOASSERTION

For best results, it's HIGHLY recommended to use the Trongate Desktop App, which is available at https://trongate.io.

If - for some reason - you'd like to use the Trongate framework without the desktop app AND you'd like to use the API manager then you'll need to set up a mySQL database. Here's a dump of some SQL code that will get you started with API authentication:

START

-- phpMyAdmin SQL Dump -- version 4.7.9 -- https://www.phpmyadmin.net/

-- Host: localhost -- Generation Time: Aug 13, 2019 at 08:25 PM -- Server version: 10.1.31-MariaDB -- PHP Version: 7.0.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION;

CREATE TABLE IF NOT EXISTS comments ( id int(11) NOT NULL AUTO_INCREMENT, comment text NOT NULL, date_created int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL, target_table varchar(125) NOT NULL, update_id int(11) NOT NULL, code varchar(6) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS trongate_tokens ( id int(11) NOT NULL AUTO_INCREMENT, token varchar(125) NOT NULL, user_id int(11) NOT NULL DEFAULT '0', expiry_date int(11) NOT NULL, code varchar(3) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS trongate_users ( id int(11) NOT NULL AUTO_INCREMENT, code varchar(32) DEFAULT NULL, user_level_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO trongate_users (id, code, user_level_id) VALUES (1, 'UVsY8ASG5evncc4U6trru2XH5Tbq7MU5', 1);

CREATE TABLE IF NOT EXISTS trongate_user_levels ( id int(11) NOT NULL AUTO_INCREMENT, level_title varchar(125) NOT NULL DEFAULT '', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO trongate_user_levels (id, level_title) VALUES (1, 'admin');

CREATE TABLE IF NOT EXISTS trongate_administrators ( id int(11) NOT NULL, username varchar(65) NOT NULL, password varchar(60) NOT NULL, trongate_user_id int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO trongate_administrators (id, username, password, trongate_user_id) VALUES (11, 'admin', '$2y$11$SoHZDvbfLSRHAi3WiKIBiu.tAoi/GCBBO4HRxVX1I3qQkq3wCWfXi', 1);

ALTER TABLE trongate_administrators ADD PRIMARY KEY (id);

ALTER TABLE trongate_administrators MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; COMMIT;

COMMIT;

END