
Славик
27.02.2016
08:43:03
вы все равно молчите
ловите задротский вброс
create table if not exists user (_id integer primary key autoincrement, id integer, first_name string, last_name string, username string);
create table if not exists chat (_id integer primary key autoincrement, id integer, type string, title string, username string, first_name string, last_name string);
create table if not exists message (_id integer primary key autoincrement, message_id integer, from user, date integer, chat chat, forward_from user, forward_date integer, reply_to_message message, text string, audio audio, document document, photo boolean, sticker sticker, video video, voice voice, caption string, contact contact, location location, new_chat_participant user, left_chat_participant user, new_chat_title string, new_chat_photo boolean, delete_chat_photo boolean, group_chat_created boolean, supergroup_chat_created boolean, channel_chat_created boolean, migrate_to_chat_id integer, migrate_from_chat_id integer);
create table if not exists photo_size (_id integer primary key autoincrement, file_id string, width integer, height integer, file_size integer);
create table if not exists audio (_id integer primary key autoincrement, file_id string, duration integer, performer string, title string, mime_type string, file_size integer);
create table if not exists document (_id integer primary key autoincrement, file_id string, thumb photo_size, file_name string, mime_type string, file_size integer);
create table if not exists sticker (_id integer primary key autoincrement, file_id string, width integer, height integer, thumb photo_size, file_size integer);
create table if not exists video (_id integer primary key autoincrement, file_id string, width integer, height integer, duration integer, thumb photo_size, mime_type string, file_size integer);
create table if not exists voice (_id integer primary key autoincrement, file_id string, duration integer, mime_type string, file_size integer);
create table if not exists contact (_id integer primary key autoincrement, phone_number string, first_name string, last_name string, user_id integer);
create table if not exists location (_id integer primary key autoincrement, longitude float, latitude float);
create table if not exists user_profile_photos (_id integer primary key autoincrement, total_count integer, photos boolean);
create table if not exists file (_id integer primary key autoincrement, file_id string, file_size integer, file_path string);
create table if not exists reply_keyboard_markup (_id integer primary key autoincrement, keyboard boolean, resize_keyboard boolean, one_time_keyboard boolean, selective boolean);
create table if not exists reply_keyboard_hide (_id integer primary key autoincrement, hide_keyboard boolean, selective boolean);
create table if not exists force_reply (_id integer primary key autoincrement, force_reply boolean, selective boolean);
create table if not exists input_file (_id integer primary key autoincrement, chat_id integer or string, text string, parse_mode string, disable_web_page_preview boolean, disable_notification boolean, reply_to_message_id integer, reply_markup reply_keyboard_markup or reply_keyboard_hide or force_reply);
create table if not exists inline_query_result_article (_id integer primary key autoincrement, type string, id string, video_url string, mime_type string, message_text string, parse_mode string, disable_web_page_preview boolean, video_width integer, video_height integer, video_duration integer, thumb_url string, title string, description string);
create table if not exists inline_query_result_photo (_id integer primary key autoincrement, result_id string, from user, query string);