<?php


$tables = [
	"user" => [
		"id" => "INTEGER PRIMARY KEY",
		"username" => "TEXT NOT NULL",
		"password" => "TEXT NOT NULL",
	],
	"int" => [
		"id" => "INTEGER PRIMARY KEY",
		"intro" => "TEXT NOT NULL",
	],
	"name" => [
		"id" => "INTEGER PRIMARY KEY",
		"fname" => "TEXT NOT NULL",
		"parto" => "TEXT NOT NULL",
		"partt" => "TEXT NOT NULL",
	],
	"themes" => [
		"id" => "INTEGER PRIMARY KEY",
		"themeid" => "TEXT NOT NULL",
	],
	"spapi" => [
		"id" => "INTEGER PRIMARY KEY",
		"apikey" => "TEXT NOT NULL",
	],
	"dns" => [
		"id" => "INTEGER PRIMARY KEY",
		"title" => "TEXT",
		"url" => "TEXT",
	],
	"m3u_lists" => [
		"id" => "INTEGER PRIMARY KEY",
		"title" => "TEXT",
		"url" => "TEXT",
		"dns_id" => "INTEGER",
		"import_date" => "TIMESTAMP",
		"status" => "TEXT",
		"playlist_count" => "INTEGER",
	],
	"mac_tracking" => [
		"id" => "INTEGER PRIMARY KEY",
		"mac_address" => "TEXT UNIQUE",
		"device_name" => "TEXT",
		"app_version" => "TEXT",
		"last_access" => "TIMESTAMP",
		"access_count" => "INTEGER",
		"first_access" => "TIMESTAMP",
		"ip_address" => "TEXT",
		"status" => "TEXT",
	],
];

?>