5古詩(shī)兩首教學(xué)設(shè)計(jì)

1、?S_&S_&R 螴 RR 螴 R R 螴 R R 螴 R R 螴 R R 螴 R R 螴 RR 螴 R? ? ? ?q? ?f ?tablemetameta CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR) ;indexsqlite_autoindex_meta_1meta 儀 嘋tablekeywordskeywords CREATETABLEkeywords(idINTEGERPRIMARYKEY,short_name VARCHAR NOT NULL,keyw

2、ord VARCHAR NOT NULL,favicon_url VARCHAR NOTNULL,urlVARCHARNOTNULL,safe_for_autoreplaceINTEGER,originating_urlVARCHAR,date_created INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodingsVARCHAR,show_in_default_listINTEGER,suggest_urlVARCHAR,prepopulate_idINTEGERDEFAULT0,created_by_policyINTE

3、GERDEFAULT0,instant_urlVARCHAR,last_modifiedINTEGER DEFAULT 0,sync_guid VARCHAR)? ?tableautofillautofill CREATE TABLE autofill (name VARCHAR, value VARCHAR,value_lowerVARCHAR,pair_idINTEGERPRIMARYKEY,countINTEGERDEFAULT1)N gindexautofill_nameautofillCREATE INDEX autofill_name ON autofill (name)t ?in

4、dexautofill_name_value_lowerautofillCREATE INDEX autofill_name_value_lowerON autofill (name, value_lower)乮 %?tablecredit_cardscredit_cardsCREATE TABLE credit_cards ( guid VARCHARPRIMARY KEY, name_on_card VARCHAR, expiration_month INTEGER, expiration_year INTEGER,card_number_encryptedBLOB,date_modifi

5、edINTEGERNOTNULLDEFAULT0)7 K%indexsqlite_autoindex_credit_cards_1credit_cards? )?tableautofill_datesautofill_datesCREATE TABLE autofill_dates ( pair_id INTEGER DEFAULT 0, date_created INTEGER DEFAULT0)p 9)?indexautofill_dates_pair_idautofill_datesCREATE INDEX autofill_dates_pair_id ON autofill_dates

6、 (pair_id)? /?tableautofill_profilesautofill_profilesCREATE TABLE autofill_profiles ( guid VARCHAR PRIMARY KEY, company_name VARCHAR,address_line_1 VARCHAR, address_line_2 VARCHAR, city VARCHAR, state VARCHAR, zipcodeVARCHAR, country VARCHAR, country_code VARCHAR, date_modified INTEGER NOT NULL DEFA

7、ULT0)A U/indexsqlite_autoindex_autofill_profiles_1autofill_profilesxx#?= ?J ?n ? G? Z? 99乲tableautofill_profile_namesautofill_profile_names CREATETABLEautofill_profile_names ( guid VARCHAR, first_name VARCHAR, middle_name VARCHAR,last_name VARCHAR) ;?tableautofill_profile_emailsautofill_profile_emai

8、ls CREATETABLEautofill_profile_emails ( guid VARCHAR, email VARCHAR)? ;丒tableautofill_profile_phonesautofill_profile_phones CREATETABLEautofill_profile_phones(guidVARCHAR,typeINTEGERDEFAULT0,numberVARCHAR)n ;utableautofill_profiles_trashautofill_profiles_trash CREATETABLE autofill_profiles_trash ( g

9、uid VARCHAR)? !?tableie7_loginsie7_logins CREATE TABLE ie7_logins (url_hash VARCHAR NOT NULL,password_valueBLOB,date_createdINTEGERNOTNULL,UNIQUE(url_hash)3 G!indexsqlite_autoindex_ie7_logins_1ie7_logins Z +!windexie7_logins_hashie7_logins CREATE INDEX ie7_logins_hash ON ie7_logins (url_hash)? 乢tabl

10、eweb_app_iconsweb_app_icons CREATETABLEweb_app_icons(urlLONGVARCHAR,widthint,heightint,imageBLOB,UNIQUE(url,width,height)9 Mindexsqlite_autoindex_web_app_icons_1web_app_icons k ?tableweb_appsweb_apps CREATETABLEweb_apps(urlLONGVARCHARUNIQUE,has_all_imagesINTEGERNOTNULL)/ Cindexsqlite_autoindex_web_a

11、pps_1web_apps W 1oindexweb_apps_url_indexweb_apps CREATE INDEX web_apps_url_index ON web_apps (url) ?tabletoken_servicetoken_service CREATE TABLE token_service (service VARCHARPRIMARYKEYNOTNULL,encrypted_tokenBLOB)9 Mindexsqlite_autoindex_token_service_1token_service- ? +厎 tablekeywords_backupkeywor

12、ds_backupCREATE TABLE keywords_backup(id INT,short_name TEXT,keyword TEXT,favicon_url TEXT,url TEXT,safe_for_autoreplace INT,originating_url TEXT,date_created INT,usage_count INT,input_encodings TEXT,show_in_default_list INT,suggest_url TEXT,prepopulate_id INT,created_by_policy INT,instant_url TEXT,

13、last_modified INT,sync_guid TEXT) X ?X? a? 651ED989F4AF0C7DE778A01651AE7840D8CB481BE3袑澾 ?寊 繭聴?淋 N?跑 O?h觹 f?&?n 嚷 唩 5!U 焓 ?z 耓y ?9 個(gè)?x瀃?W?B 鴜?鱟?腢 DF?*? = 隒?蕩 e- 炻虗 6 廋?錳?A?俏狹 Ny:0 啯 b 亄?O 渃慁 5 薌 洙壅砑x 湸撛 F 腩先髙鏕線 b 6P+-m 韈+?壑G昣滀篒錪hUXR?鍌 a僠 FF288B5EE81C46B6C03A4262AC5E0416CE4BA347D5袑澾 ?寊 繭聴?翡燔 hH 婽?梷毪 f?芯 WF?攰 P0?鐮 ?4S?縈?磁飼!徣 Z笿瞊祣?-tK 鎾鰷噠抿驀瑥涮?繍 ROD?瑉?q/ 祼 嗓 貸 4 蟨 V 鷳 6. 騍 9Wc?1? 珬 ?Mx 遊 D#G 啃 2 襎 Ej 窯R? 鍌- a? F1413734E33B556499DE6FF704D05772385A22EA8C袑澾 ?寊 繭聴?翡燔 hH 婽 ? 梷 毪 f? 悝: aRGw?醷梕 sO 銨姲 F陵p艜 0?%J 鷟 Z?Y 2 蹼?z KO 嶍 E;闈_?NVP?hl8I 睽?莙怢=猷捪鉸 K 冷?m