iftikharyk / trongate-framework Goto Github PK

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

-- 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; SET time_zone = "+00:00";

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=3 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=2240 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=2 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=2 DEFAULT CHARSET=utf8;

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

END