Blog
tutiwiki
Toieva
Photo
Keikaku
Login
Game
Game2
CollectionTrade
Sweet
Englishwiki
Analysis
Gacha

ページデータ(テーブル作成SQL文)

ページデータ
CREATE TABLE page_data(id INTEGER PRIMARY KEY, page_level, page_rank, page_name, page_reading, page_id, page_image, page_pic, page_type, title, title_reading, page_badge, page_color, page_design, page_thumbnail, page_size, page_comment, number_of_inserts, insertion1, insertion2, insertion3, insertion4, insertion5, insertion6, insertion7, insertion8, insertion9, insertion10, insertion11, insertion12, master_page, update_count, summary, evaluation, page_number_of_image, number_of_links, access_count, premium_access_count, premium_visitor, update_day, update_time, date_of_last_update, time_of_last_update, created_date, creation_time, registration_date, registration_time, elapsed_time, next_maintenance_date, number_of_favorite_people, quotation, credit_rate, nice_number, the_value_of_page, credibility, update_frequency, access_frequency, accuracy, ticket_usage, copyright_and_risk_level, risk_level, rarity, user_update_frequency, good_value, infomation_credibility, credit_rating_level, page_completeness, cognitive_degree, person_seeing_now, popular_time, staying_time, award_medal, total_charactar_count, icon_chip, cumulative_donation, special_image, total_column_score, charactar_count, update_level, used_grammar_count, grammar_usage_count, visitor, popularity_count, popularity_probability, croweded_time, popular_time2, rare_item_appearance_probability, author, number_of_people_read, probability_of_reading, customers, the_most_count_customers, time_to_finish_reading, credibility2, related_blog, sister_page, paring_page, cross_checker, page_lock_authority_person, quote_permission_list, editable_age, usage_ticket_for_viewing, related_page, user_created, regist_time, special_image_of_this_page, number_of_columns_on_this_page, related_blog2, the_terminology_on_the_page, grammar_count_on_the_page, page_detail, all_count, today_count, yesterday_count, access_phase, number_of_inset, people_of_master, number_of_master, made_in_year, update_phase, clicks_of_edit_button, clicks_of_freeze_button, clicks_of_reload_button, page_src, note, author2, duplicate, on_mouse_times, freeze, frequency, user_of_most_accessed, number_of_times_tickets_were_used, time_of_last_update2, related_blog3, page_access_days, staying_time2, quote_text, photo_deversion, advanced_site, access_count2, number_of_ticket_used_user, access_user_list, body_copy, the_value_of_infomation, version, animal_crystal, page_icon);

ページデータ(タップル挿入SQL文)

INSERT INTO page_data(id, page_level, page_rank, page_name, page_reading, page_id, page_image, page_pic, page_type, title, title_reading, page_badge, page_color, page_design, page_thumbnail, page_size, page_comment, number_of_inserts, insertion1, insertion2, insertion3, insertion4, insertion5, insertion6, insertion7, insertion8, insertion9, insertion10, insertion11, insertion12, master_page, update_count, summary, evaluation, page_number_of_image, number_of_links, access_count, premium_access_count, premium_visitor, update_day, update_time, date_of_last_update, time_of_last_update, created_date, creation_time, registration_date, registration_time, elapsed_time, next_maintenance_date, number_of_favorite_people, quotation, credit_rate, nice_number, the_value_of_page, credibility, update_frequency, access_frequency, accuracy, ticket_usage, copyright_and_risk_level, risk_level, rarity, user_update_frequency, good_value, infomation_credibility, credit_rating_level, page_completeness, cognitive_degree, person_seeing_now, popular_time, staying_time, award_medal, total_charactar_count, icon_chip, cumulative_donation, special_image, total_column_score, charactar_count, update_level, used_grammar_count, grammar_usage_count, visitor, popularity_count, popularity_probability, croweded_time, popular_time2, rare_item_appearance_probability, author, number_of_people_read, probability_of_reading, customers, the_most_count_customers, time_to_finish_reading, credibility2, related_blog, sister_page, paring_page, cross_checker, page_lock_authority_person, quote_permission_list, editable_age, usage_ticket_for_viewing, related_page, user_created, regist_time, special_image_of_this_page, number_of_columns_on_this_page, related_blog2, the_terminology_on_the_page, grammar_count_on_the_page, page_detail, all_count, today_count, yesterday_count, access_phase, number_of_inset, people_of_master, number_of_master, made_in_year, update_phase, clicks_of_edit_button, clicks_of_freeze_button, clicks_of_reload_button, page_src, note, author2, duplicate, on_mouse_times, freeze, frequency, user_of_most_accessed, number_of_times_tickets_were_used, time_of_last_update2, related_blog3, page_access_days, staying_time2, quote_text, photo_deversion, advanced_site, access_count2, number_of_ticket_used_user, access_user_list, body_copy, the_value_of_infomation, version, animal_crystal, page_icon)
VALUES (null, "page_level", "page_rank", "page_name", "page_reading", "page_id", "page_image", "page_pic", "page_type", "title", "title_reading", "page_badge", "page_color", "page_design", "page_thumbnail", "page_size", "page_comment", "number_of_inserts", "insertion1", "insertion2", "insertion3", "insertion4", "insertion5", "insertion6", "insertion7", "insertion8", "insertion9", "insertion10", "insertion11", "insertion12", "master_page", "update_count", "summary", "evaluation", "page_number_of_image", "number_of_links", "access_count", "premium_access_count", "premium_visitor", "update_day", "update_time", "date_of_last_update", "time_of_last_update", "created_date", "creation_time", "registration_date", "registration_time", "elapsed_time", "next_maintenance_date", "number_of_favorite_people", "quotation", "credit_rate", "nice_number", "the_value_of_page", "credibility", "update_frequency", "access_frequency", "accuracy", "ticket_usage", "copyright_and_risk_level", "risk_level", "rarity", "user_update_frequency", "good_value", "infomation_credibility", "credit_rating_level", "page_completeness", "cognitive_degree", "person_seeing_now", "popular_time", "staying_time", "award_medal", "total_charactar_count", "icon_chip", "cumulative_donation", "special_image", "total_column_score", "charactar_count", "update_level", "used_grammar_count", "grammar_usage_count", "visitor", "popularity_count", "popularity_probability", "croweded_time", "popular_time2", "rare_item_appearance_probability", "author", "number_of_people_read", "probability_of_reading", "customers", "the_most_count_customers", "time_to_finish_reading", "credibility2", "related_blog", "sister_page", "paring_page", "cross_checker", "page_lock_authority_person", "quote_permission_list", "editable_age", "usage_ticket_for_viewing", "related_page", "user_created", "regist_time", "special_image_of_this_page", "number_of_columns_on_this_page", "related_blog2", "the_terminology_on_the_page", "grammar_count_on_the_page", "page_detail", "all_count", "today_count", "yesterday_count", "access_phase", "number_of_inset", "people_of_master", "number_of_master", "made_in_year", "update_phase", "clicks_of_edit_button", "clicks_of_freeze_button", "clicks_of_reload_button", "page_src", "note", "author2", "duplicate", "on_mouse_times", "freeze", "frequency", "user_of_most_accessed", "number_of_times_tickets_were_used", "time_of_last_update2", "related_blog3", "page_access_days", "staying_time2", "quote_text", "photo_deversion", "advanced_site", "access_count2", "number_of_ticket_used_user", "access_user_list", "body_copy", "the_value_of_infomation", "version", "animal_crystal", "page_icon")

コラムデータ

コラムデータ