ApiQL v3 live documentation

phpmk Realtime CRUD

WebSocket-only CRUD backend for realtime-crud.php.mk.

Runtime URLs

Transport	URL
REST	`https://realtime-crud.php.mk/apiql/`
WebSocket	`wss://realtime-crud.php.mk/apiql/ws`

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/TABLE_INFO?limit=20"

Overview

This service exposes only the tables listed in allowed_actions. Change the external JSON config, restart the service, then refresh this page.

Endpoints44 generated

Tables and views discovered from the active config and MySQL schema.

Pagination20 default / 100 max

Control response size with limit and offset.

ModeConfigured endpoints

REST and WebSocket use the same auth, permissions and query builder.

Interactive console

Try live API

Run a real request against this ApiQL service. Choose REST or WebSocket, enter a token, pick an endpoint and inspect the full live response.

Ready

https://realtime-crud.php.mk/apiql/

Request preview will appear here.

Response JSON will appear here.

Authentication

REST accepts Authorization: Bearer TOKEN, X-APIQL-TOKEN: TOKEN or ?token=TOKEN. WebSocket clients authenticate after connecting.

{"action":"auth","token":"YOUR_TOKEN"}

JavaScript SDK

The service exposes the SDK directly, so the browser can use the same endpoint for REST and realtime calls.

<script src="https://realtime-crud.php.mk/apiql/sdk/apiql-v3.js"></script>
<script>
const apiql = new ApiQL({
  endpoint: 'https://realtime-crud.php.mk/apiql',
  token: 'YOUR_TOKEN',
  transport: 'auto'
});

const rows = await apiql.get('TABLE_INFO', { limit: 20 });
apiql.on('TABLE_INFO', event => console.log(event));
</script>

WebSocket protocol

{"action":"auth","token":"YOUR_TOKEN"}

{"action":"subscribe","event":"TABLE_INFO","query":{"filter":{"TABLE_INFO.COLUMN_NAME":"value"}}}

Realtime events are generated only by CRUD operations that pass through ApiQL v3. Direct database writes are visible on the next read but do not emit WebSocket events.

Schema generated

Endpoints

Each endpoint below is generated from the current MySQL schema. Columns hidden by disabled_columns are not shown unless allow_all is enabled.

Endpoint

/TABLE_INFO

listinsertupdatedelete

Columns

Field	Type	Null
`TABLE_NAME`	varchar(64)	NO
`COLUMN_NAME`	varchar(64)	NO
`ORDINAL_POSITION`	int unsigned	NO
`COLUMN_DEFAULT`	text	YES
`IS_NULLABLE`	varchar(3)	NO
`DATA_TYPE`	longtext	NO
`CHARACTER_MAXIMUM_LENGTH`	bigint	YES
`NUMERIC_PRECISION`	bigint unsigned	YES
`CHARACTER_SET_NAME`	varchar(64)	YES
`EXTRA`	varchar(256)	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/TABLE_INFO?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/TABLE_INFO?filter[TABLE_INFO.COLUMN_NAME]=value&sort[TABLE_INFO.TABLE_NAME]=DESC"

JavaScript SDK

const rows = await apiql.get('TABLE_INFO', { limit: 20 });
apiql.on('TABLE_INFO.update', row => console.log(row));

Endpoint

/bot

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`input`	text	YES
`output`	text	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/bot?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/bot?filter[bot.input]=value&sort[bot.id]=DESC"

JavaScript SDK

const rows = await apiql.get('bot', { limit: 20 });
await apiql.insert('bot', { input: 'value' });
apiql.on('bot.update', row => console.log(row));

Endpoint

/cities

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`city`	varchar(40)	NO	MUL
`lat`	decimal(10,6)	NO
`lng`	decimal(11,6)	NO
`country_iso`	varchar(2)	NO	MUL
`country`	varchar(24)	NO	MUL
`dest_parent`	varchar(40)	YES
`dest_type`	varchar(15)	YES
`population`	int	YES
`population_proper`	int	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/cities?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/cities?filter[cities.city]=value&sort[cities.id]=DESC"

JavaScript SDK

const rows = await apiql.get('cities', { limit: 20 });
await apiql.insert('cities', { city: 'value' });
apiql.on('cities.update', row => console.log(row));

Endpoint

/countries

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`code`	varchar(2)	NO	UNI
`name`	varchar(100)	NO
`language_id`	int	NO	MUL
`status`	enum('active','inactive')	NO		active
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/countries?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/countries?filter[countries.code]=value&sort[countries.id]=DESC"

JavaScript SDK

const rows = await apiql.get('countries', { limit: 20 });
await apiql.insert('countries', { code: 'value' });
apiql.on('countries.update', row => console.log(row));

Endpoint

/cv

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`name`	varchar(255)	NO
`ime`	varchar(100)	YES
`prezime`	varchar(100)	YES
`kategorija`	varchar(100)	NO
`adress`	varchar(255)	NO
`education`	varchar(255)	NO
`pol`	varchar(100)	YES
`datum_na_raganje`	date	YES
`mesto_na_raganje`	varchar(100)	YES
`grad`	varchar(64)	YES
`mobilen_telefon`	varchar(100)	YES
`domasen_telefon`	varchar(100)	YES
`telefon_na_rabota`	varchar(100)	YES
`faks`	varchar(100)	YES
`e_mail`	varchar(100)	YES
`veb_strana`	varchar(100)	YES
`mejl_za_novosti`	varchar(100)	YES
`majcin_jazik`	varchar(100)	YES
`albanski`	varchar(100)	YES
`germanski`	varchar(100)	YES
`angliski`	varchar(100)	YES
`italijanski`	varchar(100)	NO
`francuski`	varchar(100)	NO
`ruski`	varchar(100)	NO
`drugi_jazici`	varchar(100)	NO
`word`	varchar(100)	NO
`excel`	varchar(100)	NO
`internet`	varchar(100)	NO
`outlook`	varchar(100)	NO
`power_point`	varchar(100)	NO
`Dakt_vestini`	varchar(100)	NO
`ostanati_komjuterski_vestini`	varchar(100)	NO
`kreativnost`	varchar(100)	NO
`spretnost`	varchar(100)	NO
`inicijativa`	varchar(100)	NO
`vrednost`	varchar(100)	NO
`lojalnost`	varchar(100)	NO
`prestavitelnost`	varchar(100)	NO
`trpelivost`	varchar(100)	NO
`pozitiven_stav`	varchar(100)	NO
`res_problem`	varchar(100)	NO
`temelnost`	varchar(100)	NO
`energicnost`	varchar(100)	NO
`ostanati_komp_osobini`	varchar(100)	NO
`analitika`	varchar(100)	NO
`komunikacii`	varchar(100)	NO
`ubeditelni`	varchar(100)	NO
`liderski`	varchar(100)	NO
`menagment`	varchar(100)	NO
`timska_rabota`	varchar(100)	NO
`pregovori`	varchar(100)	NO
`organizacija`	varchar(100)	NO
`planiranje`	varchar(100)	NO
`proekt_menagment`	varchar(100)	NO
`brzo_citanje`	varchar(100)	NO
`ostanati_spec_osobini`	varchar(100)	NO
`smetkovodstvo`	varchar(100)	NO
`komercija`	varchar(100)	NO
`kompjuteri`	varchar(100)	NO
`zanaetcija`	varchar(100)	NO
`kelner`	varchar(100)	NO
`menager`	varchar(11)	NO
`marketing`	varchar(11)	NO
`proizvodstvo`	text	NO
`prodavac`	text	NO
`magacin`	text	NO
`drugi_oblasti`	varchar(100)	NO
`bracen_status`	varchar(100)	NO
`min_plata`	varchar(100)	NO
`osuduvan`	varchar(100)	NO
`zavisnik_od_opojni_sredstva`	varchar(100)	NO
`momentalno_vraboten`	varchar(100)	NO
`momentalna_profesija`	varchar(100)	NO
`EmployeeDesc`	varchar(255)	NO
`vozacka`	varchar(100)	NO
`kategorija_vozacka`	varchar(100)	NO
`A`	varchar(100)	NO
`B`	varchar(100)	NO
`C`	varchar(100)	NO
`D`	varchar(100)	NO
`E`	varchar(100)	NO
`sopstveno_vozilo`	varchar(100)	NO
`hobi`	varchar(100)	NO
`stranstvo`	varchar(100)	NO
`poludnevno`	text	NO
`od_doma`	varchar(255)	NO
`prva_smena`	text	NO
`vtora_treta`	text	NO
`sezonsko`	text	NO
`neodredeno`	varchar(255)	NO
`obrazovanie`	varchar(100)	NO
`obraz_institucija`	varchar(100)	NO
`god_na_zapocnuvanje`	varchar(100)	NO
`god_na_zavrsuvanje`	varchar(100)	NO
`mesto`	varchar(100)	NO
`dobiena_titula`	varchar(100)	NO
`nasoka`	varchar(100)	NO
`rab_iskustvo`	varchar(100)	NO
`kompanija`	varchar(100)	NO
`lokacija`	varchar(100)	NO
`vrab_od_do`	varchar(100)	NO
`pozicija`	varchar(100)	NO
`rab_zadaci`	varchar(100)	NO
`referenci`	varchar(100)	NO
`dopolnitelna_obuka`	varchar(100)	NO
`seminari`	varchar(100)	NO
`sertifikati`	varchar(100)	NO
`attach`	varchar(255)	NO
`attach1`	varchar(255)	NO
`attach2`	varchar(255)	NO
`attach3`	varchar(255)	NO
`Slika`	varchar(255)	NO
`QualificationNeed`	varchar(255)	NO
`QualificationType`	varchar(255)	NO
`GetCVHelp`	varchar(255)	NO
`GetInterviewHelp`	varchar(255)	NO
`GetCVSeminar`	varchar(255)	NO
`GetInterviewSeminar`	varchar(255)	NO
`Announced`	int	NO
`iskustvo2`	text	YES
`odobri`	int	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/cv?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/cv?filter[cv.name]=value&sort[cv.id]=DESC"

JavaScript SDK

const rows = await apiql.get('cv', { limit: 20 });
await apiql.insert('cv', { name: 'value' });
apiql.on('cv.update', row => console.log(row));

Endpoint

/datingcash_reports

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`name`	varchar(250)	NO
`report_query`	longtext	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/datingcash_reports?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/datingcash_reports?filter[datingcash_reports.name]=value&sort[datingcash_reports.id]=DESC"

JavaScript SDK

const rows = await apiql.get('datingcash_reports', { limit: 20 });
await apiql.insert('datingcash_reports', { name: 'value' });
apiql.on('datingcash_reports.update', row => console.log(row));

Endpoint

/destinations

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`lang`	varchar(3)	NO		en
`type`	enum('general','cities','regions','activities','lakes','national parks','mountains')	NO		general
`alias`	varchar(500)	NO	UNI
`title`	varchar(500)	NO
`main_photo`	varchar(500)	NO
`description`	text	NO
`content`	longtext	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/destinations?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/destinations?filter[destinations.lang]=value&sort[destinations.id]=DESC"

JavaScript SDK

const rows = await apiql.get('destinations', { limit: 20 });
await apiql.insert('destinations', { lang: 'value' });
apiql.on('destinations.update', row => console.log(row));

Endpoint

/dns

listinsertupdatedelete

Columns

Field	Type	Null	Default
`id`	int	NO	0
`domain`	varchar(200)	NO
`dns_type`	enum('A','NS','CNAME')	NO	A
`dns_name`	varchar(150)	NO
`dns_value`	varchar(300)	NO
`ttl`	int	NO	1
`updated`	datetime	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/dns?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/dns?filter[dns.domain]=value&sort[dns.id]=DESC"

JavaScript SDK

const rows = await apiql.get('dns', { limit: 20 });
apiql.on('dns.update', row => console.log(row));

Endpoint

/dns_records

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`cf_id`	varchar(128)	NO	UNI
`type`	enum('A','NS','CNAME')	NO	MUL	A
`domain_id`	int	NO	MUL
`name`	varchar(150)	NO	MUL
`value`	varchar(300)	NO
`ttl`	int	NO		1
`updated`	datetime	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/dns_records?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/dns_records?filter[dns_records.cf_id]=value&sort[dns_records.id]=DESC"

JavaScript SDK

const rows = await apiql.get('dns_records', { limit: 20 });
await apiql.insert('dns_records', { cf_id: 'value' });
apiql.on('dns_records.update', row => console.log(row));

Endpoint

/documentation_translations

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int unsigned	NO	PRI		auto_increment
`lang_key`	varchar(80)	NO	UNI
`source_language`	varchar(5)	NO	MUL	en
`target_language`	varchar(5)	NO		mk
`source_text`	text	NO
`translated_text`	mediumtext	YES
`status`	enum('pending','translated','failed')	NO		pending
`last_error`	text	YES
`created_at`	datetime	NO
`updated_at`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/documentation_translations?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/documentation_translations?filter[documentation_translations.lang_key]=value&sort[documentation_translations.id]=DESC"

JavaScript SDK

const rows = await apiql.get('documentation_translations', { limit: 20 });
await apiql.insert('documentation_translations', { lang_key: 'value' });
apiql.on('documentation_translations.update', row => console.log(row));

Endpoint

/domains

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO	MUL
`domain`	varchar(200)	NO	UNI
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
`status`	enum('pending','active','expired','deleted','pending_update')	NO	MUL	pending

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/domains?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/domains?filter[domains.user_id]=value&sort[domains.id]=DESC"

JavaScript SDK

const rows = await apiql.get('domains', { limit: 20 });
await apiql.insert('domains', { user_id: 'value' });
apiql.on('domains.update', row => console.log(row));

Endpoint

/dpusrs

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`username`	varchar(250)	NO
`email`	varchar(500)	NO
`geo`	varchar(100)	NO
`total_amount_spent`	decimal(10,2)	NO		0.00

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/dpusrs?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/dpusrs?filter[dpusrs.username]=value&sort[dpusrs.id]=DESC"

JavaScript SDK

const rows = await apiql.get('dpusrs', { limit: 20 });
await apiql.insert('dpusrs', { username: 'value' });
apiql.on('dpusrs.update', row => console.log(row));

Endpoint

/fb_cookies

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`user_id`	int	NO
`created`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/fb_cookies?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/fb_cookies?filter[fb_cookies.user_id]=value&sort[fb_cookies.id]=DESC"

JavaScript SDK

const rows = await apiql.get('fb_cookies', { limit: 20 });
await apiql.insert('fb_cookies', { user_id: 'value' });
apiql.on('fb_cookies.update', row => console.log(row));

Endpoint

/fb_queue

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`type`	enum('message','status')	NO		status
`target`	varchar(150)	YES
`content`	text	NO
`is_completed`	tinyint(1)	YES
`schedule`	datetime	NO
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/fb_queue?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/fb_queue?filter[fb_queue.type]=value&sort[fb_queue.id]=DESC"

JavaScript SDK

const rows = await apiql.get('fb_queue', { limit: 20 });
await apiql.insert('fb_queue', { type: 'value' });
apiql.on('fb_queue.update', row => console.log(row));

Endpoint

/fb_recently_liked_profiles

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`fbid`	bigint	NO
`name`	varchar(150)	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/fb_recently_liked_profiles?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/fb_recently_liked_profiles?filter[fb_recently_liked_profiles.fbid]=value&sort[fb_recently_liked_profiles.id]=DESC"

JavaScript SDK

const rows = await apiql.get('fb_recently_liked_profiles', { limit: 20 });
await apiql.insert('fb_recently_liked_profiles', { fbid: 'value' });
apiql.on('fb_recently_liked_profiles.update', row => console.log(row));

Endpoint

/jobs

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`alias`	varchar(100)	NO	UNI
`due`	datetime	NO
`job`	longtext	YES
`is_pp`	tinyint(1)	NO		0

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/jobs?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/jobs?filter[jobs.alias]=value&sort[jobs.id]=DESC"

JavaScript SDK

const rows = await apiql.get('jobs', { limit: 20 });
await apiql.insert('jobs', { alias: 'value' });
apiql.on('jobs.update', row => console.log(row));

Endpoint

/languages

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`code`	varchar(5)	NO	UNI
`name`	varchar(100)	NO
`local_name`	varchar(200)	NO
`status`	enum('active','inactive')	NO
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/languages?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/languages?filter[languages.code]=value&sort[languages.id]=DESC"

JavaScript SDK

const rows = await apiql.get('languages', { limit: 20 });
await apiql.insert('languages', { code: 'value' });
apiql.on('languages.update', row => console.log(row));

Endpoint

/logs

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`name`	varchar(100)	NO
`log`	longtext	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/logs?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/logs?filter[logs.name]=value&sort[logs.id]=DESC"

JavaScript SDK

const rows = await apiql.get('logs', { limit: 20 });
await apiql.insert('logs', { name: 'value' });
apiql.on('logs.update', row => console.log(row));

Endpoint

/loto

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`broj`	int	NO
`izvlecen`	int	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/loto?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/loto?filter[loto.broj]=value&sort[loto.id]=DESC"

JavaScript SDK

const rows = await apiql.get('loto', { limit: 20 });
await apiql.insert('loto', { broj: 'value' });
apiql.on('loto.update', row => console.log(row));

Endpoint

/macrodroid

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`device_serial`	varchar(100)	YES
`cell_id`	varchar(50)	YES
`location`	varchar(100)	YES
`baterry`	varchar(30)	YES
`wifi`	varchar(150)	YES
`volume`	varchar(30)	YES
`uptime`	varchar(30)	YES
`storage_free`	varchar(30)	YES
`ip`	varchar(30)	YES
`system_time`	varchar(30)	YES
`power`	varchar(30)	YES
`manufacturer`	varchar(150)	YES
`model`	varchar(200)	YES
`app_f_name`	varchar(200)	YES
`app_f_code`	varchar(200)	YES
`call_number`	varchar(50)	YES
`call_name`	varchar(150)	YES
`sms_number`	varchar(50)	YES
`sms_name`	varchar(150)	YES
`sms_msg`	text	YES
`not_app_name`	varchar(200)	YES
`not_action_names`	varchar(200)	YES
`not_title`	text	YES
`not_ticker`	varchar(200)	YES
`notification`	text	YES
`not_text_lines`	varchar(200)	YES
`not_text_big`	longtext	YES
`app_name`	varchar(200)	YES
`app_package`	varchar(200)	YES
`clipboard`	longtext	YES
`log`	json	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/macrodroid?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/macrodroid?filter[macrodroid.device_serial]=value&sort[macrodroid.id]=DESC"

JavaScript SDK

const rows = await apiql.get('macrodroid', { limit: 20 });
await apiql.insert('macrodroid', { device_serial: 'value' });
apiql.on('macrodroid.update', row => console.log(row));

Endpoint

/mail_logs

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO
`mail_server_id`	int	NO
`from_name`	varchar(300)	NO
`email`	varchar(250)	NO
`subject`	text	YES
`body`	longtext	YES
`status`	enum('delivered','failed')	NO
`log`	json	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
`time_opened`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_logs?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_logs?filter[mail_logs.user_id]=value&sort[mail_logs.id]=DESC"

JavaScript SDK

const rows = await apiql.get('mail_logs', { limit: 20 });
await apiql.insert('mail_logs', { user_id: 'value' });
apiql.on('mail_logs.update', row => console.log(row));

Endpoint

/mail_queue

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO
`from_name`	varchar(300)	NO
`email`	varchar(250)	NO
`subject`	text	YES
`body`	longtext	YES
`domain`	varchar(300)	YES
`status`	enum('pending','failed')	NO		pending
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
`modified`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_queue?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_queue?filter[mail_queue.user_id]=value&sort[mail_queue.id]=DESC"

JavaScript SDK

const rows = await apiql.get('mail_queue', { limit: 20 });
await apiql.insert('mail_queue', { user_id: 'value' });
apiql.on('mail_queue.update', row => console.log(row));

Endpoint

/mail_servers

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO		1
`smtp_host`	varchar(250)	NO
`smtp_port`	int	NO
`smtp_user`	varchar(250)	NO
`charset`	varchar(100)	NO
`smtp_crypto`	varchar(50)	YES
`priority`	enum('2','3','1')	NO		2
`header`	varchar(300)	YES
`smtp_limit_24h`	int	NO		100
`status`	enum('active','inactive')	NO		active
`last_used`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_servers?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_servers?filter[mail_servers.user_id]=value&sort[mail_servers.id]=DESC"

JavaScript SDK

const rows = await apiql.get('mail_servers', { limit: 20 });
await apiql.insert('mail_servers', { user_id: 'value' });
apiql.on('mail_servers.update', row => console.log(row));

Endpoint

/mail_unsubscribed

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`hash`	varchar(35)	NO	UNI
`email`	varchar(300)	NO
`domain`	varchar(250)	NO
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_unsubscribed?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/mail_unsubscribed?filter[mail_unsubscribed.hash]=value&sort[mail_unsubscribed.id]=DESC"

JavaScript SDK

const rows = await apiql.get('mail_unsubscribed', { limit: 20 });
await apiql.insert('mail_unsubscribed', { hash: 'value' });
apiql.on('mail_unsubscribed.update', row => console.log(row));

Endpoint

/migration_versions

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`version`	varchar(14)	NO	PRI
`executed_at`	datetime	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/migration_versions?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/migration_versions?filter[migration_versions.executed_at]=value&sort[migration_versions.version]=DESC"

JavaScript SDK

const rows = await apiql.get('migration_versions', { limit: 20 });
await apiql.insert('migration_versions', { executed_at: 'value' });
apiql.on('migration_versions.update', row => console.log(row));

Endpoint

/onesignal_users

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO
`onesignal_user_id`	varchar(100)	NO	UNI
`domain`	varchar(250)	NO
`status`	enum('active','inactive')	NO
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
`modified`	int	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/onesignal_users?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/onesignal_users?filter[onesignal_users.user_id]=value&sort[onesignal_users.id]=DESC"

JavaScript SDK

const rows = await apiql.get('onesignal_users', { limit: 20 });
await apiql.insert('onesignal_users', { user_id: 'value' });
apiql.on('onesignal_users.update', row => console.log(row));

Endpoint

/posts

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO	MUL
`privacy`	enum('private','users','public')	NO		public
`header_image`	text	YES
`title`	text	NO
`body`	longtext	YES
`tags`	varchar(300)	YES	MUL
`views`	int	NO		0
`created`	datetime	YES
`modified`	datetime	YES
`status`	enum('pending','active','banned')	NO		pending

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/posts?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/posts?filter[posts.user_id]=value&sort[posts.id]=DESC"

JavaScript SDK

const rows = await apiql.get('posts', { limit: 20 });
await apiql.insert('posts', { user_id: 'value' });
apiql.on('posts.update', row => console.log(row));

Endpoint

/sessions

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default
`id`	varchar(128)	NO	PRI
`ip_address`	varchar(45)	NO
`timestamp`	int unsigned	NO	MUL	0
`data`	blob	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/sessions?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/sessions?filter[sessions.ip_address]=value&sort[sessions.id]=DESC"

JavaScript SDK

const rows = await apiql.get('sessions', { limit: 20 });
await apiql.insert('sessions', { ip_address: 'value' });
apiql.on('sessions.update', row => console.log(row));

Endpoint

/sites

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`domain`	varchar(45)	NO	UNI
`language_id`	int	NO	MUL	1
`name`	varchar(200)	NO
`title`	text	YES
`description`	text	YES
`keywords`	text	YES
`css_style`	longtext	YES
`accepted_genders`	varchar(20)	YES
`accepted_preferences`	varchar(20)	YES
`status`	enum('pending','active','banned','deleted','dns_error')	NO		pending
`created`	datetime	NO
`modified`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/sites?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/sites?filter[sites.domain]=value&sort[sites.id]=DESC"

JavaScript SDK

const rows = await apiql.get('sites', { limit: 20 });
await apiql.insert('sites', { domain: 'value' });
apiql.on('sites.update', row => console.log(row));

Endpoint

/sms_queue

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`text`	text	YES
`status`	enum('pending','sent')	NO	MUL	pending
`proba`	json	NO
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
`sent`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/sms_queue?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/sms_queue?filter[sms_queue.text]=value&sort[sms_queue.id]=DESC"

JavaScript SDK

const rows = await apiql.get('sms_queue', { limit: 20 });
await apiql.insert('sms_queue', { text: 'value' });
apiql.on('sms_queue.update', row => console.log(row));

Endpoint

/smss

listinsertupdatedelete

Columns

Field	Type	Null	Default
`primary`	int	NO	0
`text`	text	YES
`proba`	json	NO
`status`	enum('pending','sent')	NO	pending

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/smss?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/smss?filter[smss.text]=value&sort[smss.primary]=DESC"

JavaScript SDK

const rows = await apiql.get('smss', { limit: 20 });
apiql.on('smss.update', row => console.log(row));

Endpoint

/templates

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`alias`	varchar(100)	NO	UNI
`page`	varchar(100)	NO
`name`	varchar(150)	YES
`author`	varchar(150)	YES
`doctype`	varchar(200)	YES
`contrast`	varchar(200)	NO
`licence`	varchar(200)	NO
`date_added`	datetime	YES
`image`	text	YES
`download_link`	text	YES
`preview`	text	YES
`layout`	varchar(200)	YES
`tags`	varchar(100)	YES
`colors`	varchar(100)	YES
`created`	datetime	YES
`status`	enum('active','inactive','deleted')	NO		active
`downloads`	int	NO		0

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates?filter[templates.alias]=value&sort[templates.id]=DESC"

JavaScript SDK

const rows = await apiql.get('templates', { limit: 20 });
await apiql.insert('templates', { alias: 'value' });
apiql.on('templates.update', row => console.log(row));

Endpoint

/templates_colors

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`name`	varchar(200)	NO	UNI

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates_colors?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates_colors?filter[templates_colors.name]=value&sort[templates_colors.id]=DESC"

JavaScript SDK

const rows = await apiql.get('templates_colors', { limit: 20 });
await apiql.insert('templates_colors', { name: 'value' });
apiql.on('templates_colors.update', row => console.log(row));

Endpoint

/templates_layouts

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`name`	varchar(200)	NO	UNI

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates_layouts?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates_layouts?filter[templates_layouts.name]=value&sort[templates_layouts.id]=DESC"

JavaScript SDK

const rows = await apiql.get('templates_layouts', { limit: 20 });
await apiql.insert('templates_layouts', { name: 'value' });
apiql.on('templates_layouts.update', row => console.log(row));

Endpoint

/templates_tags

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`name`	varchar(200)	NO	UNI

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates_tags?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/templates_tags?filter[templates_tags.name]=value&sort[templates_tags.id]=DESC"

JavaScript SDK

const rows = await apiql.get('templates_tags', { limit: 20 });
await apiql.insert('templates_tags', { name: 'value' });
apiql.on('templates_tags.update', row => console.log(row));

Endpoint

/tmp

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`mobile`	varchar(20)	NO
`referenceId`	varchar(100)	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/tmp?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/tmp?filter[tmp.mobile]=value&sort[tmp.id]=DESC"

JavaScript SDK

const rows = await apiql.get('tmp', { limit: 20 });
await apiql.insert('tmp', { mobile: 'value' });
apiql.on('tmp.update', row => console.log(row));

Endpoint

/tmp_complete

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`mobile`	varchar(20)	NO
`referenceId`	varchar(100)	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/tmp_complete?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/tmp_complete?filter[tmp_complete.mobile]=value&sort[tmp_complete.id]=DESC"

JavaScript SDK

const rows = await apiql.get('tmp_complete', { limit: 20 });
await apiql.insert('tmp_complete', { mobile: 'value' });
apiql.on('tmp_complete.update', row => console.log(row));

Endpoint

/transactions

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_id`	int	NO
`transaction_id`	varchar(150)	NO	UNI
`provider`	enum('paypal')	NO		paypal
`paypal_email`	varchar(250)	YES
`product_id`	varchar(20)	NO
`product_name`	varchar(100)	NO
`amount`	decimal(10,2)	NO
`currency`	enum('AUD','BRL','CAD','CNY','CZK','DKK','EUR','HKD','HUF','INR','ILS','JPY','MYR','MXN','TWD','NZD','NOK','PHP','PLN','GBP','RUB','SGD','SEK','CHF','THB','USD')	NO		EUR
`url_notification`	text	YES
`url_ok`	text	YES
`url_failed`	text	YES
`status`	enum('pending','canceled','expired','completed','in_progress')	NO		pending
`created`	datetime	NO
`request_to_provider`	datetime	YES
`response_from_provider`	datetime	YES
`expired_time`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/transactions?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/transactions?filter[transactions.user_id]=value&sort[transactions.id]=DESC"

JavaScript SDK

const rows = await apiql.get('transactions', { limit: 20 });
await apiql.insert('transactions', { user_id: 'value' });
apiql.on('transactions.update', row => console.log(row));

Endpoint

/translations

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`lang_key`	varchar(50)	NO	UNI
`en`	longtext	NO
`mk`	longtext	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED
`modified`	datetime	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/translations?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/translations?filter[translations.lang_key]=value&sort[translations.id]=DESC"

JavaScript SDK

const rows = await apiql.get('translations', { limit: 20 });
await apiql.insert('translations', { lang_key: 'value' });
apiql.on('translations.update', row => console.log(row));

Endpoint

/translations2

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`from`	varchar(2)	NO	MUL
`to`	varchar(2)	NO	MUL
`original`	longtext	NO
`translated`	longtext	YES
`created`	datetime	NO
`user_id`	int	NO
`status`	enum('approved','pending','rejected')	NO		pending

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/translations2?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/translations2?filter[translations2.from]=value&sort[translations2.id]=DESC"

JavaScript SDK

const rows = await apiql.get('translations2', { limit: 20 });
await apiql.insert('translations2', { from: 'value' });
apiql.on('translations2.update', row => console.log(row));

Endpoint

/user

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int unsigned	NO	PRI	auto_increment
`ime`	varchar(45)	NO	MUL
`prezime`	varchar(45)	NO
`email`	varchar(100)	NO	UNI
`username`	varchar(45)	NO	UNI
`active`	tinyint(1)	NO
`adresa`	varchar(100)	NO
`kredit`	int unsigned	NO
`rodenden`	date	NO
`grad`	varchar(45)	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/user?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/user?filter[user.ime]=value&sort[user.id]=DESC"

JavaScript SDK

const rows = await apiql.get('user', { limit: 20 });
await apiql.insert('user', { ime: 'value' });
apiql.on('user.update', row => console.log(row));

Endpoint

/user_agents

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`user_agent_id`	varchar(100)	NO	UNI
`user_agent`	text	YES
`platform`	varchar(200)	YES
`platform_details`	varchar(300)	YES
`detected_model`	varchar(300)	YES	MUL
`browser`	varchar(200)	YES
`browser_version`	varchar(200)	YES
`mobile`	varchar(200)	YES
`robot`	varchar(200)	YES
`languages`	text	YES
`device_name`	varchar(300)	YES
`device_image`	longtext	YES
`device_released`	varchar(200)	YES
`device_body`	varchar(300)	YES
`device_os`	varchar(300)	YES
`device_storage`	varchar(300)	YES
`device_display_size`	varchar(100)	YES
`device_camera_pixels`	varchar(100)	YES
`device_ram_memory`	varchar(100)	YES
`device_battery`	varchar(100)	YES
`device_comment`	text	YES
`device_details_network`	text	YES
`device_details_launch`	text	YES
`device_details_body`	text	YES
`device_details_display`	text	YES
`device_details_platform`	text	YES
`device_details_memory`	text	YES
`device_details_main_camera`	text	YES
`device_details_selfie_camera`	text	YES
`device_details_sound`	text	YES
`device_details_comms`	text	YES
`device_details_features`	text	YES
`device_details_battery`	text	YES
`device_details_misc`	text	YES
`created`	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/user_agents?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/user_agents?filter[user_agents.user_agent_id]=value&sort[user_agents.id]=DESC"

JavaScript SDK

const rows = await apiql.get('user_agents', { limit: 20 });
await apiql.insert('user_agents', { user_agent_id: 'value' });
apiql.on('user_agents.update', row => console.log(row));

Endpoint

/user_logs

listinsertupdatedelete

Columns

Field	Type	Null	Key	Extra
`id`	int	NO	PRI	auto_increment
`user_id`	int	NO
`log_type`	enum('visit','login','logout','download')	NO
`created`	datetime	NO
`log`	longtext	YES

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/user_logs?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/user_logs?filter[user_logs.user_id]=value&sort[user_logs.id]=DESC"

JavaScript SDK

const rows = await apiql.get('user_logs', { limit: 20 });
await apiql.insert('user_logs', { user_id: 'value' });
apiql.on('user_logs.update', row => console.log(row));

Endpoint

/users

listinsertupdatedelete

Columns

Field	Type	Null	Key	Default	Extra
`id`	int	NO	PRI		auto_increment
`site_id`	int	NO		1
`language_id`	int	NO		1
`username`	varchar(100)	NO	UNI
`email`	varchar(250)	NO	UNI
`mobile`	varchar(150)	YES
`name`	varchar(150)	YES
`surname`	varchar(250)	YES
`gender`	varchar(15)	YES
`city`	varchar(200)	YES
`country`	varchar(2)	YES
`language`	varchar(2)	YES
`mail_notif_general`	tinyint(1)	NO		1
`mail_notif_security`	tinyint(1)	NO		1
`mail_notif_privacy_terms`	tinyint(1)	NO		1
`mail_notif_events`	tinyint(1)	NO		1
`mail_notif_hosting`	tinyint(1)	NO		1
`mail_notif_services`	tinyint(1)	NO		1
`mail_notif_jobs`	tinyint(1)	NO		0
`mail_notif_templates`	tinyint(1)	NO		0
`mail_notif_blog`	tinyint(1)	NO		0
`mail_notif_newsletter`	tinyint(1)	NO		1
`photo`	longtext	YES
`created`	datetime	NO
`last_activity`	datetime	YES
`status`	enum('pending','active','deleted','banned')	NO

REST

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/users?limit=20&offset=0"

curl -H "Authorization: Bearer YOUR_TOKEN" "https://realtime-crud.php.mk/apiql/users?filter[users.site_id]=value&sort[users.id]=DESC"

JavaScript SDK

const rows = await apiql.get('users', { limit: 20 });
await apiql.insert('users', { site_id: 'value' });
apiql.on('users.update', row => console.log(row));