
Славик
15.07.2016
20:58:06
CREATE TABLE user (id integer primary key, first_name text, last_name text, username text);
CREATE TABLE audio (file_id text primary key, duration integer, performer text, title text, mime_type text, file_size integer);
CREATE TABLE document (file_id text primary key, thumb integer, file_name text, mime_type text, file_size integer);
CREATE TABLE sticker (file_id text primary key, width integer, height integer, thumb integer, emoji text, file_size integer);
CREATE TABLE chat (id integer primary key, type text, title text, username text, first_name text, last_name text);
CREATE TABLE voice (file_id text primary key, duration integer, mime_type text, file_size integer);
CREATE TABLE photo_size (file_id text primary key, width integer, height integer, file_size integer);
CREATE TABLE location (_id integer primary key autoincrement, longitude real, latitude real);
CREATE TABLE user_profile_photos (_id integer primary key autoincrement, total_count integer, photos boolean);
CREATE TABLE file (file_id text primary key, file_size integer, file_path text);
CREATE TABLE video (file_id text primary key, width integer, height integer, duration integer, thumb integer, mime_type text, file_size integer);
CREATE TABLE reply_keyboard_hide (_id integer primary key autoincrement, hide_keyboard boolean, selective boolean);
CREATE TABLE force_reply (_id integer primary key autoincrement, force_reply boolean, selective boolean);
CREATE TABLE input_file (_id integer primary key autoincrement, chat_id text, text text, parse_mode text, disable_web_page_preview boolean, disable_notification boolean, reply_to_message_id integer, reply_markup text);
CREATE TABLE message (message_id integer primary key, from integer, date integer, chat integer, forward_from integer, forward_from_chat integer, forward_date integer, reply_to_message integer, edit_date integer, text t
ext, entities boolean, audio integer, document integer, photo boolean, sticker integer, video integer, voice integer, caption text, contact integer, location integer, venue venue, new_chat_member integer, `left_chat_
member` integer, new_chat_title text, 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, pinned_message integer);
CREATE TABLE inline_query_result_photo (type text, id text primary key, title text, caption text, document_url text, mime_type text, description text, reply_markup inline_keyboard_markup, input_message_content input_mess
age_content, thumb_url text, thumb_width integer, thumb_height integer);
CREATE TABLE inline_query_result_gif (type text, id text primary key, latitude float number, longitude float number, title text, reply_markup inline_keyboard_markup, input_message_content input_message_content, thumb_url t
ext, thumb_width integer, thumb_height integer);
CREATE TABLE inline_query_result_mpeg4gif (type text, id text primary key, latitude real, longitude real, title text, address text, foursquare_id text, reply_markup inline_keyboard_markup, input_message_content input_mes
sage_content, thumb_url text, thumb_width integer, thumb_height integer);
CREATE TABLE inline_query_result_video (type text, id text primary key, phone_number text, first_name text, last_name text, reply_markup inline_keyboard_markup, input_message_content input_message_content, thumb_url text,
thumb_width integer, thumb_height integer);
CREATE TABLE reply_keyboard_markup (_id integer primary key autoincrement, keyboard boolean, resize_keyboard boolean, one_time_keyboard boolean, selective boolean);
CREATE TABLE inline_query_result_article (type text, id text primary key, voice_url text, title text, voice_duration integer, reply_markup inline_keyboard_markup, input_message_content input_message_content);
CREATE TABLE contact (_id integer primary key autoincrement, phone_number text, first_name text, last_name text, user_id integer);