PHP Classes

File: db/main.sql

Recommend this page to a friend!
  Classes of Mateo   Ollama Artificial Intelligence PHP Telegram Bot   db/main.sql   Download  
File: db/main.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Ollama Artificial Intelligence PHP Telegram Bot
Telegram bot to interact with Ollama AI models
Author: By
Last change:
Date: 4 months ago
Size: 477 bytes
 

Contents

Class file image Download 
CREATE TABLE `users` (
  `id` bigint PRIMARY KEY,
  `model` VARCHAR(20) NOT NULL,
  `rank` int NOT NULL
);

CREATE TABLE `userRank` (
  `id` int PRIMARY KEY,
  `name` VARCHAR(20) NOT NULL
);

ALTER TABLE `users` ADD FOREIGN KEY (`rank`) REFERENCES `userRank` (`id`);

INSERT INTO `userRank` (id, name) VALUES (1, 'Banned');
INSERT INTO `userRank` (id, name) VALUES (2, '2');
INSERT INTO `userRank` (id, name) VALUES (3, '3');
INSERT INTO `userRank` (id, name) VALUES (4, '4');