CREATE TABLE IF NOT EXISTS `innodb_table_stats` (
  `database_name` varchar(64) NOT NULL,
  `table_name` varchar(199) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `n_rows` bigint(20) unsigned NOT NULL,
  `clustered_index_size` bigint(20) unsigned NOT NULL,
  `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

-- Dumping data for table mysql.innodb_table_stats: ~117 rows (approximately)
INSERT INTO `innodb_table_stats` (`database_name`, `table_name`, `last_update`, `n_rows`, `clustered_index_size`, `sum_of_other_index_sizes`) VALUES
	('anime_db', 'anime', '2025-03-13 12:24:07', 2, 1, 0),
	('animelist', 'anime', '2025-03-13 12:24:13', 15, 1, 0),
	('animelist', 'anime_genres', '2025-03-13 12:24:13', 34, 1, 2),
	('animelist', 'anime_licensor', '2025-03-13 12:24:13', 15, 1, 2),
	('animelist', 'anime_studio', '2025-03-13 12:24:13', 15, 1, 2),
	('animelist', 'episode', '2025-03-13 12:24:13', 15, 1, 1),
	('animelist', 'genre', '2025-03-13 12:24:13', 13, 1, 0),
	('animelist', 'licensor', '2025-03-13 12:24:13', 5, 1, 0),
	('animelist', 'studio', '2025-03-13 12:24:13', 12, 1, 0),
	('animelist', 'users', '2025-03-13 12:24:13', 11, 1, 0),
	('animelist', 'users_anime', '2025-03-13 12:24:13', 10, 1, 2),
	('animelist', 'users_list', '2025-03-13 12:24:13', 10, 2, 0),
	('bootstrapprakseraivis', 'wp_commentmeta', '2025-06-17 13:31:42', 0, 1, 2),
	('bootstrapprakseraivis', 'wp_comments', '2025-06-17 13:31:42', 0, 1, 5),
	('bootstrapprakseraivis', 'wp_links', '2025-06-17 13:31:42', 0, 1, 1),
	('bootstrapprakseraivis', 'wp_options', '2025-06-17 13:31:42', 150, 69, 2),
	('bootstrapprakseraivis', 'wp_postmeta', '2025-06-17 13:31:42', 165, 3, 2),
	('bootstrapprakseraivis', 'wp_posts', '2025-06-17 13:31:42', 91, 5, 4),
	('bootstrapprakseraivis', 'wp_term_relationships', '2025-06-17 13:31:42', 40, 1, 1),
	('bootstrapprakseraivis', 'wp_term_taxonomy', '2025-06-17 13:31:42', 11, 1, 2),
	('bootstrapprakseraivis', 'wp_termmeta', '2025-06-17 13:31:42', 0, 1, 2),
	('bootstrapprakseraivis', 'wp_terms', '2025-06-17 13:31:42', 11, 1, 2),
	('bootstrapprakseraivis', 'wp_usermeta', '2025-06-17 13:31:42', 30, 1, 2),
	('bootstrapprakseraivis', 'wp_users', '2025-06-17 13:31:42', 1, 1, 3),
	('bootstrappraksewordpress', 'wp_commentmeta', '2025-06-17 13:31:42', 0, 1, 2),
	('bootstrappraksewordpress', 'wp_comments', '2025-06-17 13:31:42', 0, 1, 5),
	('bootstrappraksewordpress', 'wp_links', '2025-06-17 13:31:43', 0, 1, 1),
	('bootstrappraksewordpress', 'wp_options', '2025-06-17 13:31:43', 143, 69, 2),
	('bootstrappraksewordpress', 'wp_postmeta', '2025-06-17 13:31:43', 37, 1, 2),
	('bootstrappraksewordpress', 'wp_posts', '2025-06-17 13:31:43', 35, 1, 4),
	('bootstrappraksewordpress', 'wp_term_relationships', '2025-06-17 13:31:43', 9, 1, 1),
	('bootstrappraksewordpress', 'wp_term_taxonomy', '2025-06-17 13:31:43', 6, 1, 2),
	('bootstrappraksewordpress', 'wp_termmeta', '2025-06-17 13:31:43', 0, 1, 2),
	('bootstrappraksewordpress', 'wp_terms', '2025-06-17 13:31:43', 6, 1, 2),
	('bootstrappraksewordpress', 'wp_usermeta', '2025-06-17 13:31:43', 21, 1, 2),
	('bootstrappraksewordpress', 'wp_users', '2025-06-17 13:31:43', 1, 1, 3),
	('database_prakse', 'wp_commentmeta', '2025-03-13 18:58:51', 0, 1, 2),
	('database_prakse', 'wp_comments', '2025-03-13 18:58:51', 1, 1, 5),
	('database_prakse', 'wp_links', '2025-03-13 18:58:51', 0, 1, 1),
	('database_prakse', 'wp_options', '2025-03-13 18:58:51', 139, 69, 2),
	('database_prakse', 'wp_postmeta', '2025-03-13 18:58:51', 72, 1, 2),
	('database_prakse', 'wp_posts', '2025-03-13 18:58:51', 30, 3, 4),
	('database_prakse', 'wp_term_relationships', '2025-03-13 18:58:51', 7, 1, 1),
	('database_prakse', 'wp_term_taxonomy', '2025-03-13 18:58:51', 3, 1, 2),
	('database_prakse', 'wp_termmeta', '2025-03-13 18:58:51', 0, 1, 2),
	('database_prakse', 'wp_terms', '2025-03-13 18:58:51', 3, 1, 2),
	('database_prakse', 'wp_usermeta', '2025-03-13 18:58:51', 23, 1, 2),
	('database_prakse', 'wp_users', '2025-03-13 18:58:51', 1, 1, 3),
	('materialwork', 'category', '2025-03-14 09:57:14', 7, 1, 0),
	('materialwork', 'material', '2025-03-14 09:58:45', 75, 1, 2),
	('materialwork', 'unit', '2025-03-14 09:55:00', 6, 1, 0),
	('materialwork', 'wcategory', '2025-03-14 09:56:00', 2, 1, 0),
	('materialwork', 'work', '2025-03-14 10:18:37', 82, 1, 3),
	('metodes', 'fun_login', '2025-03-14 07:52:14', 58, 1, 1),
	('metodes', 'fun_person', '2025-03-14 07:52:14', 33, 1, 0),
	('metodes', 'fun_users', '2025-03-14 07:52:14', 24, 1, 1),
	('mysql', 'gtid_slave_pos', '2019-10-21 12:17:49', 0, 1, 0),
	('notepad', 'categories', '2025-06-10 07:20:45', 13, 1, 0),
	('notepad', 'comments', '2025-06-09 13:00:34', 0, 1, 2),
	('notepad', 'favourites', '2025-06-09 12:55:44', 0, 1, 2),
	('notepad', 'file_likes', '2025-06-09 12:56:17', 0, 1, 2),
	('notepad', 'file_users', '2025-06-07 09:31:03', 27, 1, 2),
	('notepad', 'files', '2025-06-07 09:31:03', 27, 2, 0),
	('notepad', 'published_file_categories', '2025-06-09 15:21:47', 21, 1, 2),
	('notepad', 'published_files', '2025-06-09 15:20:15', 12, 161, 2),
	('notepad', 'users', '2025-03-13 13:08:28', 2, 2, 0),
	('phpmyadmin', 'pma__bookmark', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__central_columns', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__column_info', '2019-10-21 12:19:11', 0, 1, 1),
	('phpmyadmin', 'pma__designer_settings', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__export_templates', '2019-10-21 12:19:11', 0, 1, 1),
	('phpmyadmin', 'pma__favorite', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__history', '2019-10-21 12:19:11', 0, 1, 1),
	('phpmyadmin', 'pma__navigationhiding', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__pdf_pages', '2019-10-21 12:19:11', 0, 1, 1),
	('phpmyadmin', 'pma__recent', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__relation', '2019-10-21 12:19:11', 0, 1, 1),
	('phpmyadmin', 'pma__savedsearches', '2019-10-21 12:19:11', 0, 1, 1),
	('phpmyadmin', 'pma__table_coords', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__table_info', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__table_uiprefs', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__tracking', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__userconfig', '2019-10-21 13:36:49', 0, 1, 0),
	('phpmyadmin', 'pma__usergroups', '2019-10-21 12:19:11', 0, 1, 0),
	('phpmyadmin', 'pma__users', '2019-10-21 12:19:11', 0, 1, 0),
	('raivis', 'actor', '2025-03-13 18:59:07', 200, 1, 1),
	('raivis', 'address', '2025-03-13 18:59:08', 603, 5, 1),
	('raivis', 'category', '2025-03-13 18:59:08', 16, 1, 0),
	('raivis', 'city', '2025-03-13 18:59:08', 600, 3, 1),
	('raivis', 'country', '2025-03-13 18:59:08', 109, 1, 0),
	('raivis', 'customer', '2025-03-13 18:59:08', 599, 5, 3),
	('raivis', 'film', '2025-03-13 18:59:08', 1000, 12, 5),
	('raivis', 'film_actor', '2025-03-13 18:59:08', 5462, 12, 5),
	('raivis', 'film_category', '2025-03-13 18:59:08', 1000, 4, 1),
	('raivis', 'film_text', '2025-03-13 18:59:08', 1000, 11, 1),
	('raivis', 'inventory', '2025-03-13 18:59:08', 4581, 11, 12),
	('raivis', 'language', '2025-03-13 18:59:08', 6, 1, 0),
	('raivis', 'payment', '2025-03-13 18:59:08', 16086, 97, 39),
	('raivis', 'rental', '2025-03-13 18:59:08', 16005, 97, 73),
	('raivis', 'staff', '2025-03-13 18:59:08', 2, 4, 2),
	('raivis', 'store', '2025-03-13 18:59:08', 2, 1, 2),
	('sakila', 'actor', '2025-03-13 18:59:01', 200, 1, 1),
	('sakila', 'address', '2025-03-13 18:59:01', 603, 5, 1),
	('sakila', 'category', '2025-03-13 18:59:01', 16, 1, 0),
	('sakila', 'city', '2025-03-13 18:59:01', 600, 3, 1),
	('sakila', 'country', '2025-03-13 18:59:01', 109, 1, 0),
	('sakila', 'customer', '2025-03-13 18:59:01', 599, 5, 3),
	('sakila', 'film', '2025-03-13 18:59:01', 1000, 12, 5),
	('sakila', 'film_actor', '2025-03-13 18:59:01', 5462, 12, 5),
	('sakila', 'film_category', '2025-03-13 18:59:01', 1000, 4, 1),
	('sakila', 'film_text', '2025-03-13 18:59:01', 1000, 11, 1),
	('sakila', 'inventory', '2025-03-13 18:59:01', 4581, 11, 12),
	('sakila', 'language', '2025-03-13 18:59:01', 6, 1, 0),
	('sakila', 'payment', '2025-03-13 18:59:01', 16086, 97, 39),
	('sakila', 'rental', '2025-03-13 18:59:01', 16008, 97, 73),
	('sakila', 'staff', '2025-03-13 18:59:01', 2, 4, 2),
	('sakila', 'store', '2025-03-13 18:59:01', 2, 1, 2);

-- Dumping structure for table mysql.plugin
CREATE TABLE IF NOT EXISTS `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='MySQL plugins';

-- Dumping data for table mysql.plugin: 0 rows

-- Dumping structure for table mysql.proc
CREATE TABLE IF NOT EXISTS `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(141) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL') NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob DEFAULT NULL,
  `aggregate` enum('NONE','GROUP') NOT NULL DEFAULT 'NONE',
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Stored Procedures';

-- Dumping data for table mysql.proc: 0 rows

-- Dumping structure for table mysql.procs_priv
CREATE TABLE IF NOT EXISTS `procs_priv` (
  `Host` char(60) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') NOT NULL,
  `Grantor` char(141) NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Procedure privileges';

-- Dumping data for table mysql.procs_priv: 0 rows

-- Dumping structure for table mysql.proxies_priv
CREATE TABLE IF NOT EXISTS `proxies_priv` (
  `Host` char(60) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Proxied_host` char(60) NOT NULL DEFAULT '',
  `Proxied_user` char(80) NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT 0,
  `Grantor` char(141) NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='User proxy privileges';

-- Dumping data for table mysql.proxies_priv: 1 rows
-- Dumping structure for table mysql.roles_mapping
CREATE TABLE IF NOT EXISTS `roles_mapping` (
  `Host` char(60) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Role` char(80) NOT NULL DEFAULT '',
  `Admin_option` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  UNIQUE KEY `Host` (`Host`,`User`,`Role`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Granted roles';

-- Dumping data for table mysql.roles_mapping: 0 rows

-- Dumping structure for table mysql.servers
CREATE TABLE IF NOT EXISTS `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(80) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT 0,
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='MySQL Foreign Servers table';

-- Dumping data for table mysql.servers: 0 rows

-- Dumping structure for table mysql.slow_log
CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `user_host` mediumtext NOT NULL,
  `query_time` time(6) NOT NULL,
  `lock_time` time(6) NOT NULL,
  `rows_sent` int(11) NOT NULL,
  `rows_examined` int(11) NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int(11) NOT NULL,
  `insert_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `sql_text` mediumtext NOT NULL,
  `thread_id` bigint(21) unsigned NOT NULL,
  `rows_affected` int(11) NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='Slow log';

-- Dumping data for table mysql.slow_log: 2 rows

-- Dumping structure for table mysql.tables_priv
CREATE TABLE IF NOT EXISTS `tables_priv` (
  `Host` char(60) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Table_name` char(64) NOT NULL DEFAULT '',
  `Grantor` char(141) NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger','Delete versioning rows') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Table privileges';

-- Dumping data for table mysql.tables_priv: 0 rows

-- Dumping structure for table mysql.table_stats
CREATE TABLE IF NOT EXISTS `table_stats` (
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `cardinality` bigint(21) unsigned DEFAULT NULL,
  PRIMARY KEY (`db_name`,`table_name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=0 COMMENT='Statistics on Tables';

-- Dumping data for table mysql.table_stats: 0 rows

-- Dumping structure for table mysql.time_zone
CREATE TABLE IF NOT EXISTS `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zones';

-- Dumping data for table mysql.time_zone: 0 rows

-- Dumping structure for table mysql.time_zone_leap_second
CREATE TABLE IF NOT EXISTS `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL,
  PRIMARY KEY (`Transition_time`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Leap seconds information for time zones';

-- Dumping data for table mysql.time_zone_leap_second: 0 rows

-- Dumping structure for table mysql.time_zone_name
CREATE TABLE IF NOT EXISTS `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zone names';

-- Dumping data for table mysql.time_zone_name: 0 rows

-- Dumping structure for table mysql.time_zone_transition
CREATE TABLE IF NOT EXISTS `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zone transitions';

-- Dumping data for table mysql.time_zone_transition: 0 rows

-- Dumping structure for table mysql.time_zone_transition_type
CREATE TABLE IF NOT EXISTS `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT 0,
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zone transition types';

-- Dumping data for table mysql.time_zone_transition_type: 0 rows

-- Dumping structure for table mysql.transaction_registry
CREATE TABLE IF NOT EXISTS `transaction_registry` (
  `transaction_id` bigint(20) unsigned NOT NULL,
  `commit_id` bigint(20) unsigned NOT NULL,
  `begin_timestamp` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `commit_timestamp` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `isolation_level` enum('READ-UNCOMMITTED','READ-COMMITTED','REPEATABLE-READ','SERIALIZABLE') NOT NULL,
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `commit_id` (`commit_id`),
  KEY `begin_timestamp` (`begin_timestamp`),
  KEY `commit_timestamp` (`commit_timestamp`,`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

-- Dumping data for table mysql.transaction_registry: ~0 rows (approximately)

-- Dumping structure for view mysql.user
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `user` (
	`Host` CHAR(60) NOT NULL COLLATE 'utf8_bin',
	`User` CHAR(80) NOT NULL COLLATE 'utf8_bin',
	`Password` LONGTEXT NULL COLLATE 'utf8mb4_bin',
	`Select_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Insert_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Update_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Delete_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Create_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Drop_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Reload_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Shutdown_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Process_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`File_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Grant_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`References_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Index_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Alter_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Show_db_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Super_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Create_tmp_table_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Lock_tables_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Execute_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Repl_slave_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Repl_client_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Create_view_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Show_view_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Create_routine_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Alter_routine_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Create_user_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Event_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Trigger_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Create_tablespace_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`Delete_history_priv` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`ssl_type` VARCHAR(9) NULL COLLATE 'latin1_swedish_ci',
	`ssl_cipher` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`x509_issuer` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`x509_subject` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`max_questions` BIGINT(20) UNSIGNED NOT NULL,
	`max_updates` BIGINT(20) UNSIGNED NOT NULL,
	`max_connections` BIGINT(20) UNSIGNED NOT NULL,
	`max_user_connections` BIGINT(21) NOT NULL,
	`plugin` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`authentication_string` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`password_expired` VARCHAR(1) NOT NULL COLLATE 'latin1_swedish_ci',
	`is_role` VARCHAR(1) NULL COLLATE 'latin1_swedish_ci',
	`default_role` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`max_statement_time` DECIMAL(12,6) NOT NULL
) ENGINE=MyISAM;

-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `user` AS SELECT
  Host,
  User,
  IF(JSON_VALUE(Priv, '$.plugin') IN ('mysql_native_password', 'mysql_old_password'), IFNULL(JSON_VALUE(Priv, '$.authentication_string'), ''), '') AS Password,
  IF(JSON_VALUE(Priv, '$.access') &         1, 'Y', 'N') AS Select_priv,
  IF(JSON_VALUE(Priv, '$.access') &         2, 'Y', 'N') AS Insert_priv,
  IF(JSON_VALUE(Priv, '$.access') &         4, 'Y', 'N') AS Update_priv,
  IF(JSON_VALUE(Priv, '$.access') &         8, 'Y', 'N') AS Delete_priv,
  IF(JSON_VALUE(Priv, '$.access') &        16, 'Y', 'N') AS Create_priv,
  IF(JSON_VALUE(Priv, '$.access') &        32, 'Y', 'N') AS Drop_priv,
  IF(JSON_VALUE(Priv, '$.access') &        64, 'Y', 'N') AS Reload_priv,
  IF(JSON_VALUE(Priv, '$.access') &       128, 'Y', 'N') AS Shutdown_priv,
  IF(JSON_VALUE(Priv, '$.access') &       256, 'Y', 'N') AS Process_priv,
  IF(JSON_VALUE(Priv, '$.access') &       512, 'Y', 'N') AS File_priv,
  IF(JSON_VALUE(Priv, '$.access') &      1024, 'Y', 'N') AS Grant_priv,
  IF(JSON_VALUE(Priv, '$.access') &      2048, 'Y', 'N') AS References_priv,
  IF(JSON_VALUE(Priv, '$.access') &      4096, 'Y', 'N') AS Index_priv,
  IF(JSON_VALUE(Priv, '$.access') &      8192, 'Y', 'N') AS Alter_priv,
  IF(JSON_VALUE(Priv, '$.access') &     16384, 'Y', 'N') AS Show_db_priv,
  IF(JSON_VALUE(Priv, '$.access') &     32768, 'Y', 'N') AS Super_priv,
  IF(JSON_VALUE(Priv, '$.access') &     65536, 'Y', 'N') AS Create_tmp_table_priv,
  IF(JSON_VALUE(Priv, '$.access') &    131072, 'Y', 'N') AS Lock_tables_priv,
  IF(JSON_VALUE(Priv, '$.access') &    262144, 'Y', 'N') AS Execute_priv,
  IF(JSON_VALUE(Priv, '$.access') &    524288, 'Y', 'N') AS Repl_slave_priv,
  IF(JSON_VALUE(Priv, '$.access') &   1048576, 'Y', 'N') AS Repl_client_priv,
  IF(JSON_VALUE(Priv, '$.access') &   2097152, 'Y', 'N') AS Create_view_priv,
  IF(JSON_VALUE(Priv, '$.access') &   4194304, 'Y', 'N') AS Show_view_priv,
  IF(JSON_VALUE(Priv, '$.access') &   8388608, 'Y', 'N') AS Create_routine_priv,
  IF(JSON_VALUE(Priv, '$.access') &  16777216, 'Y', 'N') AS Alter_routine_priv,
  IF(JSON_VALUE(Priv, '$.access') &  33554432, 'Y', 'N') AS Create_user_priv,
  IF(JSON_VALUE(Priv, '$.access') &  67108864, 'Y', 'N') AS Event_priv,
  IF(JSON_VALUE(Priv, '$.access') & 134217728, 'Y', 'N') AS Trigger_priv,
  IF(JSON_VALUE(Priv, '$.access') & 268435456, 'Y', 'N') AS Create_tablespace_priv,
  IF(JSON_VALUE(Priv, '$.access') & 536870912, 'Y', 'N') AS Delete_history_priv,
  ELT(IFNULL(JSON_VALUE(Priv, '$.ssl_type'), 0) + 1, '', 'ANY','X509', 'SPECIFIED') AS ssl_type,
  IFNULL(JSON_VALUE(Priv, '$.ssl_cipher'), '') AS ssl_cipher,
  IFNULL(JSON_VALUE(Priv, '$.x509_issuer'), '') AS x509_issuer,
  IFNULL(JSON_VALUE(Priv, '$.x509_subject'), '') AS x509_subject,
  CAST(IFNULL(JSON_VALUE(Priv, '$.max_questions'), 0) AS UNSIGNED) AS max_questions,
  CAST(IFNULL(JSON_VALUE(Priv, '$.max_updates'), 0) AS UNSIGNED) AS max_updates,
  CAST(IFNULL(JSON_VALUE(Priv, '$.max_connections'), 0) AS UNSIGNED) AS max_connections,
  CAST(IFNULL(JSON_VALUE(Priv, '$.max_user_connections'), 0) AS SIGNED) AS max_user_connections,
  IFNULL(JSON_VALUE(Priv, '$.plugin'), '') AS plugin,
  IFNULL(JSON_VALUE(Priv, '$.authentication_string'), '') AS authentication_string,
  'N' AS password_expired,
  ELT(IFNULL(JSON_VALUE(Priv, '$.is_role'), 0) + 1, 'N', 'Y') AS is_role,
  IFNULL(JSON_VALUE(Priv, '$.default_role'), '') AS default_role,
  CAST(IFNULL(JSON_VALUE(Priv, '$.max_statement_time'), 0.0) AS DECIMAL(12,6)) AS max_statement_time
  FROM global_priv; ;


-- Dumping database structure for notepad
CREATE DATABASE IF NOT EXISTS `notepad` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `notepad`;

-- Dumping structure for table notepad.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Publicētā faila kategorijas id',
  `name` varchar(50) NOT NULL COMMENT 'Publicētā faila kategorijas nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Publicētā faila kategorijas';

-- Dumping data for table notepad.categories: ~13 rows (approximately)
INSERT INTO `categories` (`id`, `name`) VALUES
	(1, 'mango'),
	(2, 'juice'),
	(3, 'writing'),
	(4, 'asking'),
	(5, 'limbo'),
	(6, 'jigsaw'),
	(7, 'kitchen'),
	(8, 'food'),
	(9, 'luna'),
	(10, 'moon'),
	(11, 'pool'),
	(12, 'twitch'),
	(13, 'youtube'),
	(14, 'waltz');

-- Dumping structure for table notepad.comments
CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Publicētā faila komentāra id',
  `published_file_id` int(11) unsigned NOT NULL COMMENT 'Publicētā faila id',
  `user_id` int(11) unsigned NOT NULL COMMENT 'Lietotāja id',
  `text` text NOT NULL COMMENT 'Komentāra saturs',
  `date` date NOT NULL COMMENT 'Komentāra publicēšanas datums',
  `time` time NOT NULL COMMENT 'Komentāra publicēšanas laiks',
  PRIMARY KEY (`id`),
  KEY `FK_comments_published_files` (`published_file_id`),
  KEY `FK_comments_users` (`user_id`),
  CONSTRAINT `FK_comments_published_files` FOREIGN KEY (`published_file_id`) REFERENCES `published_files` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_comments_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Lietotāja pievienotie komentāri publicētiem failiem';

-- Dumping data for table notepad.comments: ~0 rows (approximately)

-- Dumping structure for table notepad.favourites
CREATE TABLE IF NOT EXISTS `favourites` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Lietotāja iemīļotākie publicētie faili id',
  `published_file_id` int(11) unsigned NOT NULL COMMENT 'Publicēto faila id',
  `user_id` int(11) unsigned NOT NULL COMMENT 'Lietotāja id',
  PRIMARY KEY (`id`),
  KEY `FK_favourites_published_files` (`published_file_id`),
  KEY `FK_favourites_users` (`user_id`),
  CONSTRAINT `FK_favourites_published_files` FOREIGN KEY (`published_file_id`) REFERENCES `published_files` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_favourites_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Lietotāja iemīļotākie publicētie faili';

-- Dumping data for table notepad.favourites: ~0 rows (approximately)

-- Dumping structure for table notepad.files
CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Faila id',
  `name` varchar(255) NOT NULL COMMENT 'Faila nosaukums',
  `text` text NOT NULL COMMENT 'Faila teksts, kuru lietotājs bija sarakstījis',
  `description` text NOT NULL COMMENT 'Faila apraksts, kuru lietotājs var pievienot vēlāk savā failu sarakstā',
  `image` mediumblob NOT NULL COMMENT 'Faila attēls, kuru lietotājs var pievienot vēlāk savā failu sarakstā',
  `date` date NOT NULL COMMENT 'Datums, kad fails tika izveidots',
  `time` time NOT NULL COMMENT 'Laiks, kad fails tika izveidots',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula, kura glabā lietotāja izveidotos failus.';

-- Dumping data for table notepad.files: ~27 rows (approximately)
INSERT INTO `files` (`id`, `name`, `text`, `description`, `image`, `date`, `time`) VALUES
	(1, 'Mango Juice testing 2', 'Mango juice is best juice', 'This is where my mango juice recipe lies 22342ggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg', _binary '', '2025-04-01', '17:41:44'),
	(2, 'TestBold Mango', '<font face="Times New Roman"><b>\n            Testing</b></font>', 'Hmahajaw\r\nMango', _binary '', '2025-04-01', '17:43:16'),
	(3, 'Test2', '<b><i>\n            T</i></b><font face="Verdana">e<font size="4">s</font>t2 </font>t<u>est</u>', '', _binary '', '2025-04-01', '17:45:09'),
	(4, 'TesttingTestTrest', 'Testing test trest', '', _binary '', '2025-04-01', '17:49:21'),
	(5, 'Modal Testing', 'Testing the modal', '', _binary '', '2025-04-01', '17:51:18'),
	(6, 'Modal testing part 2', 'Testing the modal once again boy', '', _binary '', '2025-04-01', '17:53:19'),
	(7, 'Modal testing part 3', 'Testing the modal thingy once more..', '', _binary '', '2025-04-01', '17:55:49'),
	(8, 'Modal testing 4', 'Testing... The modal damn it...', '', _binary '', '2025-04-01', '18:00:10'),
	(9, 'Modals mmm', 'Modals mmmmmm...', '', _binary '', '2025-04-01', '18:03:16'),
	(10, 'Modals like!', 'Modals, me like!', '', _binary '', '2025-04-01', '18:05:30'),
	(11, 'Modals haha', 'Start writing here... Modals haha', '', _binary '', '2025-04-01', '18:07:20'),
	(12, 'Modal works?', 'Modal works?', '', _binary '', '2025-04-01', '18:07:59'),
	(13, 'Modalsssss', 'Modal maybe not need to work', '', _binary '', '2025-04-01', '18:08:57'),
	(14, 'mangoses', 'Start writing here... mangoses', '', _binary '', '2025-04-01', '18:12:02'),
	(15, 'Mangeosgr', 'Mngoes?1', '', _binary '', '2025-04-01', '18:12:57'),
	(16, 'Modal workings?', 'Modal workings?', '', _binary '', '2025-04-01', '18:16:10'),
	(17, 'Pls work', 'Pls work', '', _binary '', '2025-04-01', '18:18:56'),
	(18, 'Waorkgin', '<b>\r\n            Wokring agrv</b>rbv', '', _binary '', '2025-04-01', '18:21:44'),
	(19, 'It works', 'Wo<i><font face="Times New Roman">rks</font></i>?', '', _binary '', '2025-04-01', '18:24:16'),
	(20, 'Testingersings', 'Testingers', 'Testingersings once again', _binary '', '2025-04-01', '18:47:24'),
	(21, 'Start writing here bro', 'Start writing here...', '', _binary '', '2025-04-01', '18:47:53'),
	(22, 'Mango OS', '<font size="5">\r\n            The mango OS</font>', '', _binary '', '2025-04-02', '10:58:56'),
	(23, 'adams prasija', 'Start writing here...', '', _binary '', '2025-04-02', '11:15:35'),
	(24, 'Testing Fonts View', '<div style="text-align: center;"><span style="font-family: &quot;Times New Roman&quot;; font-size: xx-large;"><b>Test</b></span></div><div style="text-align: left;"><font size="3"><font face="Courier New" style="">Thi<b>s is </b></font><font face="Arial" style="font-weight: bold;"><u>a</u></font><font face="Georgia" style="font-weight: bold;"><u> tes</u>t for t<i>h</i></font><font face="Verdana" style=""><i style=""><b>e fo</b>nts and stuff</i></font></font></div><div style="text-align: right;"><font size="3"><font face="Verdana" style=""><i style="">Mango</i></font></font></div>', '', _binary '', '2025-06-07', '11:12:58'),
	(25, 'Testing autosave', 'Mango j<b><i>uice</i></b>', '', _binary '', '2025-06-07', '11:24:14'),
	(26, 'Test Fail Piemers', 'Mango j<b><i>uice</i></b>', '', _binary '', '2025-06-07', '11:28:22'),
	(27, 'Testing Autosave Again', 'Start wM<b><u>ango juceio</u></b>', '', _binary '', '2025-06-07', '11:31:03'),
	(28, 'Testing once again', 'Start wM<b><u>ango juceio</u></b>', '', _binary '', '2025-06-07', '11:34:01');

-- Dumping structure for table notepad.file_likes
CREATE TABLE IF NOT EXISTS `file_likes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Lietotāja patīk vai nepatīk faila id',
  `published_file_id` int(11) unsigned NOT NULL COMMENT 'Publicētā faila id',
  `user_id` int(11) unsigned NOT NULL COMMENT 'Lietotāja id',
  `is_like` tinyint(1) unsigned NOT NULL COMMENT '1=patīk, 0=nepatīk fails',
  PRIMARY KEY (`id`),
  KEY `FK_file_likes_published_files` (`published_file_id`),
  KEY `FK_file_likes_users` (`user_id`),
  CONSTRAINT `FK_file_likes_published_files` FOREIGN KEY (`published_file_id`) REFERENCES `published_files` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_file_likes_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Lietotāja atzīmētās "patīk" vai "nepatīk" faili';

-- Dumping data for table notepad.file_likes: ~0 rows (approximately)

-- Dumping structure for table notepad.file_users
CREATE TABLE IF NOT EXISTS `file_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sasaistīto lietotāju un failu id',
  `files_id` int(11) unsigned NOT NULL COMMENT 'Failu id',
  `users_id` int(11) unsigned NOT NULL COMMENT 'Lietotāju id',
  PRIMARY KEY (`id`),
  KEY `FK_file_users_files` (`files_id`),
  KEY `FK_file_users_users` (`users_id`),
  CONSTRAINT `FK_file_users_files` FOREIGN KEY (`files_id`) REFERENCES `files` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_file_users_users` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula, kura sasaista lietotājus pie saviem failiem.';

-- Dumping data for table notepad.file_users: ~27 rows (approximately)
INSERT INTO `file_users` (`id`, `files_id`, `users_id`) VALUES
	(1, 1, 1),
	(2, 2, 1),
	(3, 3, 2),
	(4, 4, 2),
	(5, 5, 2),
	(6, 6, 2),
	(7, 7, 2),
	(8, 8, 2),
	(9, 9, 2),
	(10, 10, 2),
	(11, 11, 2),
	(12, 12, 2),
	(13, 13, 2),
	(14, 14, 2),
	(15, 15, 2),
	(16, 16, 2),
	(17, 17, 2),
	(18, 18, 2),
	(19, 19, 2),
	(20, 20, 1),
	(21, 21, 1),
	(22, 22, 1),
	(23, 23, 2),
	(24, 24, 2),
	(25, 25, 2),
	(26, 26, 2),
	(27, 27, 2),
	(28, 28, 2);

-- Dumping structure for table notepad.published_files
CREATE TABLE IF NOT EXISTS `published_files` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Publicētā faila id',
  `file_id` int(11) unsigned NOT NULL COMMENT 'Failu id',
  `user_id` int(11) unsigned NOT NULL COMMENT 'Lietotāju id',
  `title` varchar(255) NOT NULL COMMENT 'Publicētā faila nosaukums',
  `description` text NOT NULL COMMENT 'Publicētā faila apraksts',
  `text` text NOT NULL COMMENT 'Lietotāja izvēlētā faila teksts',
  `thumbnail` mediumblob NOT NULL COMMENT 'Publicētā faila bilde',
  `date` date NOT NULL COMMENT 'Publicētā faila publicēšanās datums',
  `time` time NOT NULL COMMENT 'Publicētā faila publicēšanās laiks',
  PRIMARY KEY (`id`),
  KEY `FK__files` (`file_id`),
  KEY `FK__users` (`user_id`),
  CONSTRAINT `FK__files` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK__users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Publicēti faili priekš browse.php';

-- Dumping data for table notepad.published_files: ~12 rows (approximately)
INSERT INTO `published_files` (`id`, `file_id`, `user_id`, `title`, `description`, `text`, `thumbnail`, `date`, `time`) VALUES
	(1, 22, 1, 'Testing Post 1', 'This is the first test of posts using the text from file "Mango OS"!', '<font size="5">\r\n            The mango OS</font>', _binary 0x[encoded data, 43470 characters], '2025-06-09', '15:36:53'),
	(2, 2, 1, 'Post Test 2', 'This is the 2nd post test with categories and text from file "TestBold Mango"', '<font face="Times New Roman"><b>\n            Testing</b></font>', _binary 0x[encoded data, 62248 characters], '2025-06-09', '15:49:15'),
	(3, 20, 1, 'Testingersings Post 3', 'Yessir, te notiekas lietas', 'Testingers', _binary 0x[encoded data, 44364 characters], '2025-06-09', '15:56:20');
INSERT INTO `published_files` (`id`, `file_id`, `user_id`, `title`, `description`, `text`, `thumbnail`, `date`, `time`) VALUES
	(4, 21, 1, 'Start Testing Here Bro 4', 'Test 4', 'Start writing here...', _binary 0x[encoded data, 335109 characters]