Edit File: database.sqlite
SQLite format 3 @ !� + 5 !� ._ � )��8 , � ! � � 7 z � C�C� ~6 � �:�StableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "username" varchar, "email" varchar, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "role_id" integer not null)�K�utablerolesrolesCREATE TABLE "roles" ("id" integer primary key autoincrement not null, "name" varchar not null, "privilege_level" integer default '5', "created_at" datetime, "updated_at" datetime)��]tablepagespagesCREATE TABLE "pages" ("id" integer primary key autoincrement not null, "logo" varchar, "title" varchar default 'Website Streaming Anime Terbaik', "name" varchar default 'ladevnime', "description" varchar default 'Ladevnime adalah website streaming anime terbaik dan terupdate', "keywords" varchar default 'ladevnime, anime, streaming anime, nonton anime', "favicon" varchar default 'text', "canonical" varchar default 'http://localhost:8000', "created_at" datetime, "updated_at" datetime)v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�(##�tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)�`##�tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))5I# indexsqlite_autoindex_job_batches_1job_batchesS-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")��etablejobsjobsCREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)�$##�tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I# indexsqlite_autoindex_cache_locks_1cache_locks� �}tablecachecache CREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"))) = indexsqlite_autoindex_cache_1cache| E �#indexsessions_last_activity_indexsessions CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j 9 � indexsessions_user_id_indexsessions CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")�W �tablesessionssessions CREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))/ C indexsqlite_autoindex_sessions_1sessions �>77�tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokensa1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")j7�indexusers_username_uniqueusersCREATE UNIQUE INDEX "users_username_unique" on "users" ("username")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!�tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer " R ���Y/���qG � � � d 8 � � b 5 � � Y - � � � R 0 e 2024_10_02_154516_create_anime_follows_table- _ 2024_09_25_161522_create_anime_user_table< } 2024_09_25_121306_delete_nation_column_from_animes_table: y 2024_09_25_121236_add_nation_id_column_to_animes_table* Y 2024_09_25_103158_create_nations_table5 o 2024_09_24_192232_add_slug_column_to_genres_table6 q 2024_09_24_183702_add_slug_column_to_seasons_table6 q 2024_09_24_155508_add_avatar_column_to_users_table3 k 2024_09_24_134450_add_slug_column_to_tags_table+ [ 2024_09_21_171051_create_comments_table9 w 2024_09_20_135722_add_duration_column_to_animes_table, ] 2024_09_19_070224_create_anime_tag_table4 m 2024_09_19_053340_add_home_image_to_animes_table5 o 2024_09_19_050546_add_slug_column_to_animes_table* Y 2024_09_18_111337_create_banners_table6 q 2024_09_18_091234_add_is_completed_to_animes_table) W 2024_09_16_055334_create_videos_table) W 2024_09_12_061955_create_animes_table* Y 2024_09_11_122902_create_seasons_table' S 2024_09_11_120815_create_tags_table( U 2024_09_11_114103_create_types_table) W 2024_09_11_102248_create_genres_table* Y 2024_09_11_072236_create_socials_table, ] 2024_09_10_084446_create_histories_table7 s 2024_09_09_114511_add_role_id_column_to_users_table( U 2024_09_09_113957_create_roles_table( U 2024_09_09_112750_create_pages_table' S 0001_01_01_000002_create_jobs_table( U 0001_01_01_000001_create_cache_table( U 0001_01_01_000000_create_users_table � ����� pages roles animes users!migrations � � + admin@beta0.com � � beta0 � � �J ]� � Uc733https://fakeimg.pl/840x210?text=Ini+LogoLadevnime - Tempat Streaming Anime Terlengkap Dan TercepatladevnimeLadevnime adalah platform tempat streaming anime terlengkap dan tercepatladevnime, anime, snk, solo levelinghttps://fakeimg.pl/256x256?text=Ini+Faviconhttp://localhost:80002024-10-02 16:05:102024-10-02 16:05:10 � ��Z � 3 33member2024-10-02 16:05:102024-10-02 16:05:108 #33contributor2024-10-02 16:05:102024-10-02 16:05:107 !33head admin2024-10-02 16:05:102024-10-02 16:05:108 #33super admin2024-10-02 16:05:102024-10-02 16:05:101 33owner2024-10-02 16:05:102024-10-02 16:05:10 \ \ �! + � 33 ?Ladevbeta0admin@beta0.com$2y$12$jpHU2TLdVNrQGaDVP9ctjeU3nFbQ0.Cwie2g7RFe01Lfym8Roxpn62024-10-02 16:05:102024-10-02 16:05:10/storage/user/avatar.webp Y o0 d > � z � O � ���x{M�� ��6 ��EtableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "username" varchar, "email" varchar, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "role_id" integer not null, "avatar" varchar default '/storage/user/avatar.webp', foreign key("role_id") references "roles"("id") on delete cascade) �7�indexusers_username_uniqueusersCREATE UNIQUE INDEX "users_username_unique" on "users" ("username")a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")�K�utablerolesrolesCREATE TABLE "roles" ("id" integer primary key autoincrement not null, "name" varchar not null, "privilege_level" integer default '5', "created_at" datetime, "updated_at" datetime)��]tablepagespagesCREATE TABLE "pages" ("id" integer primary key autoincrement not null, "logo" varchar, "title" varchar default 'Website Streaming Anime Terbaik', "name" varchar default 'ladevnime', "description" varchar default 'Ladevnime adalah website streaming anime terbaik dan terupdate', "keywords" varchar default 'ladevnime, anime, streaming anime, nonton anime', "favicon" varchar default 'text', "canonical" varchar default 'http://localhost:8000', "created_at" datetime, "updated_at" datetime)v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�(##�tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)�`##�tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))��etablejobsjobsCREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)�$##�tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I# indexsqlite_autoindex_cache_locks_1cache_locks� �}tablecachecache CREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"))) = indexsqlite_autoindex_cache_1cache| E �#indexsessions_last_activity_indexsessions CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j 9 � indexsessions_user_id_indexsessions CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")�W �tablesessionssessions CREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))/ C indexsqlite_autoindex_sessions_1sessions �>77�tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokens5I# indexsqlite_autoindex_job_batches_1job_batchesS-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!�tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null) b � ��# � �� �utableanimesanimes"CREATE TABLE "animes" ("id" integer primary key autoincrement not null, "title" varchar not null, "name" varchar not null, "short_description" text not null, "thumbnail" varchar not null, "release_date" varchar default '-', "nation" varchar default '-', "score" varchar default '0.00 / 0.00', "current_episode" varchar default '1', "total_episode" varchar default '-', "view_count" integer default '0', "view_daily" integer default '0', "is_hot" tinyint(1) default '0', "is_priority" tinyint(1) default '0', "season_id" integer not null, "genre_id" integer not null, "type_id" integer not null, "created_at" datetime, "updated_at" datetime, "is_completed" tinyint(1) default '0', "slug" varchar not null default 'slug', "home_image" varchar default '', "duration" varchar default '-', "nation_id" integer, foreign key("season_id") references "seasons"("id") on delete cascade, foreign key("genre_id") references "genres"("id") on delete cascade, foreign key("type_id") references "types"("id") on delete cascade)�L �stablegenresgenres CREATE TABLE "genres" ("id" integer primary key autoincrement not null, "name" varchar not null, "created_at" datetime, "updated_at" datetime, "slug" varchar not null default '-')�i!�)tableseasonsseasons!CREATE TABLE "seasons" ("id" integer primary key autoincrement not null, "name" varchar not null, "order" integer not null, "created_at" datetime, "updated_at" datetime, "slug" varchar not null default '-')�= �]tabletagstags CREATE TABLE "tags" ("id" integer primary key autoincrement not null, "name" varchar not null, "created_at" datetime, "updated_at" datetime, "slug" varchar default '-')j7�indexusers_username_uniqueusersCREATE UNIQUE INDEX "users_username_unique" on "users" ("username")a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")�3�EtableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "username" varchar, "email" varchar, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "role_id" integer not null, "avatar" varchar default '/storage/user/avatar.webp', foreign key("role_id") references "roles"("id") on delete cascade)�$ �'tabletypestypes CREATE TABLE "types" ("id" integer primary key autoincrement not null, "name" varchar not null, "created_at" datetime, "updated_at" datetime)b 1�indexgenres_name_uniquegenres CREATE UNIQUE INDEX "genres_name_unique" on "genres" ("name")�Y � tablesocialssocials CREATE TABLE "socials" ("id" integer primary key autoincrement not null, "name" varchar, "link" varchar, "display_text" varchar, "logo" varchar, "created_at" datetime, "updated_at" datetime)�~ �KtablehistorieshistoriesCREATE TABLE "histories" ("id" integer primary key autoincrement not null, "name" varchar not null, "page" varchar not null, "status" varchar not null, "title" varchar not null, "created_at" datetime, "updated_at" datetime) " � A � � ��W��� �d,''�tableanime_followsanime_follows+CREATE TABLE "anime_follows" ("id" integer primary key autoincrement not null, "user_id" integer not null, "anime_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("anime_id") references "animes"("id") on delete cascade)�[+!!�tableanime_useranime_user#CREATE TABLE "anime_user" ("id" integer primary key autoincrement not null, "anime_id" integer not null, "user_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("anime_id") references "animes"("id") on delete cascade, foreign key("user_id") references "users"("id") on delete cascade)�r)�?tableanimesanimes*CREATE TABLE "animes" ("id" integer primary key autoincrement not null, "title" varchar not null, "name" varchar not null, "short_description" text not null, "thumbnail" varchar not null, "release_date" varchar default '-', "score" varchar default '0.00 / 0.00', "current_episode" varchar default '1', "total_episode" varchar default '-', "view_count" integer default '0', "view_daily" integer default '0', "is_hot" tinyint(1) default '0', "is_priority" tinyint(1) default '0', "season_id" integer not null, "genre_id" integer not null, "type_id" integer not null, "created_at" datetime, "updated_at" datetime, "is_completed" tinyint(1) default '0', "slug" varchar not null default 'slug', "home_image" varchar default '', "duration" varchar default '-', "nation_id" integer, foreign key("type_id") references "types"("id") on delete cascade on update no action, foreign key("genre_id") references "genres"("id") on delete cascade on update no action, foreign key("season_id") references "seasons"("id") on delete cascade on update no action, foreign key("nation_id") references "nations"("id") on delete cascade)�](�tablenationsnations(CREATE TABLE "nations" ("id" integer primary key autoincrement not null, "name" varchar not null, "alias" varchar not null, "slug" varchar not null, "created_at" datetime, "updated_at" datetime)�i' �%tablecommentscomments'CREATE TABLE "comments" ("id" integer primary key autoincrement not null, "description" varchar not null, "is_urgent" tinyint(1) default '0', "user_id" integer not null, "anime_id" integer, "video_id" integer, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("anime_id") references "animes"("id") on delete cascade, foreign key("video_id") references "videos"("id") on delete cascade)�U& �ytableanime_taganime_tag&CREATE TABLE "anime_tag" ("id" integer primary key autoincrement not null, "anime_id" integer not null, "tag_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("anime_id") references "animes"("id") on delete cascade, foreign key("tag_id") references "tags"("id") on delete cascade)�N%�stablebannersbanners%CREATE TABLE "banners" ("id" integer primary key autoincrement not null, "name" varchar not null, "link" varchar not null, "image" varchar not null, "is_top" tinyint(1) not null default '0', "is_bottom" tinyint(1) not null default '0', "order" integer not null, "created_at" datetime, "updated_at" datetime)�U$�tablevideosvideos$CREATE TABLE "videos" ("id" integer primary key autoincrement not null, "name" varchar not null, "anime_id" integer not null, "video" varchar not null, "thumbnail" varchar, "order" integer default '0', "created_at" datetime, "updated_at" datetime, foreign key("anime_id") references "animes"("id") on delete cascade)e*3� indexanimes_title_uniqueanimes"CREATE UNIQUE INDEX "animes_title_unique" on "animes" ("title")
Back