【文档说明】数据库基础知识培训胶片V16课件1.ppt，共(79)页，703.012 KB，由小橙橙上传

转载请保留链接：https://www.ichengzhen.cn/view-92441.html

以下为本文档部分文字说明：

数据库基础知识培训胶片集成产品部数据库原理3目标通过这部分课程的学习,您将了解以下内容:关系数据库基本概念常用数据库对象常用数据类型4INDatabaseInformixServerSMPSCPSMAPSMAPSMAPThedatabas

eplaystheroleofthebase,savingandprocessingthedatathatshouldbeeasilyaccessedbytheuser.Whatisadatabase

?Usually,adatabaserunsintheserverparttoserveaccessrequestsfromclients.5DBClient(DBA)DBDBServerDBClient(Us

er)DBClient(User)UsersuseDDLtodefineadatabaseUsersuseDMLtooperatedatainadatabaseUsersuseprogramstomanag

edatabaseDDL,DML&Programs6TablesAdatabaseinaRDBMSisacollectionofinformationthatisgroupedintooneormoretables.Atableisanarrayofdataitemsorganizedinto

rowsandcolumns.Stock7PPSServiceDataTableINServiceDatabaseFPHServiceDataTableSubscriberDataTableTablesarerelat

ionalSubIDBalanceIDDFlag1001100.0001012200.001MSISDNNumBalanceIDDFlagSubID1001100.0001001012200.001101FPHNum

BalanceIDDFlagSubID80081012341100.00010080081043212200.0011018RowsRowsEachrowofatablestandsforoneinstanceofthesubjectofthetable,whichisoneparti

cularexampleofthatentity.Stock9ColumnsEachcolumnofatablestandsforoneattribute,whichisonecharacteristic,feature,orf

actthatistrueofthesubjectofthetable.ColumnsStock10OperationsonTables11DatabaseObjectsObjectDescriptionTableBasicunitofstorage;compose

dofrowsandcolumnsViewLogicallyrepresentssubsetsofdatafromoneormoretablesSequenceNumericvaluegenerator

IndexImprovestheperformanceofsomequeriesSynonymGivesalternativenamestoobjects12WhatisaView?EMPLOYEESTable:13WhyUseViews?Torestr

ictdataaccessTomakecomplexquerieseasyToprovidedataindependenceTopresentdifferentviewsofthesamedata14WhatareCon

straints?Constraintsenforcerulesatthetablelevel.Constraintspreventthedeletionofatableiftherearedependencies.Thefol

lowingconstrainttypesarevalid:NOTNULLUNIQUEPRIMARYKEYFOREIGNKEYCHECK15WhatisanIndex?Anindex:Isaschem

aobjectIsusedbytheOracleservertospeeduptheretrievalofrowsbyusingapointerCanreducediskI/ObyusingarapidpathaccessmethodtolocatedataquicklyIsindepe

ndentofthetableitindexesIsusedandmaintainedautomaticallybytheOracleserver16HowAreIndexesCreated?Automatically:Aun

iqueindexiscreatedautomaticallywhenyoudefineaPRIMARYKEYorUNIQUEconstraintinatabledefinition.Manually:Usersc

ancreatenonuniqueindexesoncolumnstospeedupaccesstotherows.17DataTypesDataTypeDescriptionVARCHAR2(size)Varia

ble-lengthcharacterdataCHAR(size)Fixed-lengthcharacterdataNUMBER(p,s)Variable-lengthnumericdataDATEDateandtimevaluesLONGVariable-leng

thcharacterdataupto2gigabytesCLOBCharacterdataupto4gigabytesRAWandLONGRAWRawbinarydataBLOBBinarydataupto4gigab

ytesBFILEBinarydatastoredinanexternalfile;upto4gigabytesROWIDA64basenumbersystemrepresentingtheuniqueaddress

ofarowinitstable.18总结通过这部分课程的学习,您需要掌握以下内容:关系数据库基本概念常用数据库对象表索引约束常用数据类型SQL语言基础20目标通过这部分课程的学习,您将了解以下内容:SQL语句的种类执行基本的Select语句在表中插入数据行在表中修改

数据行从表中删除数据行控制事务处理21SQLStatementsSELECTINSERTUPDATEDELETECREATEALTERDROPTRUNCATECOMMITROLLBACKSAVEPOINTGRANTREVOKEDataretrievalDatamani

pulationlanguage(DML)Datadefinitionlanguage(DDL)Datacontrollanguage(DCL)22基础SELECT语句语法SELECT*|{[DISTINCT]column|expre

ssion[alias],...}FROMtable;23使用算术操作符SELECTlast_name,salary,salary+300FROMemployees;…24使用列的别名SELECTlast_name"Name",salary*12"AnnualSalary"FROMemp

loyees;SELECTlast_nameASname,commission_pctcommFROMemployees;……25使用连接符和字符串SELECTlast_name||'isa'||job

_idAS"EmployeeDetails"FROMemployees;…26排除重复的行SELECTDISTINCTdepartment_idFROMemployees;27使用WHERE条件SELECTemployee_id,last_name,job_id,department_idFROM

employeesWHEREdepartment_id=90;28字符串和日期值都使用单引号.字符串值区分大小写，日期值需注意格式.SELECTlast_name,job_id,department_idFROMem

ployeesWHERElast_name='Whalen';29比较条件操作符=>>=<<=<>含义等于大于大于或等于小于小于或等于不等于30其它的比较条件操作符BETWEEN...AND...IN(set)LIKEI

SNULL含义两个值之间匹配值列表中值匹配一个字符样式空值31使用BETWEEN条件可以使用该条件显示某范围内的值.SELECTlast_name,salaryFROMemployeesWHEREsalaryBETWEEN2500AND3500;Lowerlimit

Upperlimit32SELECTemployee_id,last_name,salary,manager_idFROMemployeesWHEREmanager_idIN(100,101,201);使用IN条件满足成员列表中的条件.33使用LIKE条件搜索条件能包括两

种模式匹配类型:%表示许多字符._表示一个字符.SELECTfirst_nameFROMemployeesWHEREfirst_nameLIKE'S%';34使用NULL条件测验空值使用ISNULL条件.SELECTlas

t_name,manager_idFROMemployeesWHEREmanager_idISNULL;35逻辑条件OperatorANDORNOT含义两部分条件都返回真值则结果返回真值两部分条件中有任意一部分返回真值则结

果返回真值如果条件返回假则结果返回真值36使用AND操作符要求条件都为真.SELECTemployee_id,last_name,job_id,salaryFROMemployeesWHEREsalary>=10000ANDjob_idLIKE'%MAN%';37SELECT

last_name,job_idFROMemployeesWHEREjob_idNOTIN('IT_PROG','ST_CLERK','SA_REP');UsingtheNOTOperator38SELECTlast_name,job_id,department_id,hir

e_dateFROMemployeesORDERBYhire_date;ORDERBY条件带ORDERBY条件的排序ASC:升序，缺省DESC:降序ORDERBY条件在Select语句最后.…39数据操作语句一条DML语句在下列情况下被

执行:向表中增加新的数据行修改表中存在的数据从表中删除数据一个事务由DML语句集合形成的逻辑工作单元构成.40INSERT语句语法.INSERTINTOtable[(column[,column...])]VALUES(value[,value...

]);41向表中插入新的数据行插入的新行应包括所有的列值.插入的值应按照表中列缺省的顺序排列.如插入所有的列,INSERT条件中可随意选择是否列出所有列.INSERTINTOdepartments(department_id,dep

artment_name,manager_id,location_id)VALUES(70,'PublicRelations',100,1700);1rowcreated.42INSERTINTOemploy

eesVALUES(114,'Den','Raphealy','DRAPHEAL','515.127.4561',TO_DATE('FEB3,1999','MONDD,YYYY'),'AC_ACCOUNT',1

1000,NULL,100,30);1rowcreated.插入特殊的日期型值Verifyyouraddition.43带子查询的INSERT语句.字段的数据类型必须匹配.INSERTINTOsa

les_reps(id,name,salary,commission_pct)SELECTemployee_id,last_name,salary,commission_pctFROMemployeesWHEREjob_idLIKE'

%REP%';4rowscreated.从另外一个表中复制行44UPDATE语句语法可一次性修改多行UPDATEtableSETcolumn=value[,column=value,...][WHEREcondition];45UPDATEemployeesSETdep

artment_id=70WHEREemployee_id=113;1rowupdated.在WHERE条件中指定需要修改的行.修改表中所有的行.修改表中数据UPDATEcopy_empSETdepartment_id=110;22ro

wsupdated.46UPDATEcopy_empSETdepartment_id=(SELECTdepartment_idFROMemployeesWHEREemployee_id=100)WHERE

job_id=(SELECTjob_idFROMemployeesWHEREemployee_id=200);1rowupdated.基于另外表SELECT得到的值修改数据使用子查询实现：47DELETE语句语法DELETE[FROM]table[WHEREconditi

on];48通过WHERE条件指定删除的行.省略WHERE条件，所有的行都将被删除.从表中删除多行DELETEFROMdepartmentsWHEREdepartment_name='Finance';1row

deleted.DELETEFROMcopy_emp;22rowsdeleted.49DELETEFROMemployeesWHEREdepartment_id=(SELECTdepartment_idFROMdepa

rtmentsWHEREdepartment_nameLIKE'%Public%');1rowdeleted.基于另外表SELECT得到的值删除数据通过子查询语句从另外表中得到值作为删除条件.50数据库

事务一个数据库完整事务包含以下情况:构成对数据的一次一致性改变的DML语句（一条或多条）一条DDL语句51数据库事务当第一条DMLSQL语句执行时开始当下列任意事件发生时结束:提交或回滚语句执行一条DDL执行(自动提交)系统崩溃52控制事务SAVEPOINTBSAVEP

OINTADELETEINSERTUPDATEINSERTCOMMITTimeTransactionROLLBACKtoSAVEPOINTBROLLBACKtoSAVEPOINTAROLLBACK53UPDATE...SAVEPOINTupdate_done;S

avepointcreated.INSERT...ROLLBACKTOupdate_done;Rollbackcomplete.回滚改变到一个标记在当前的事务中可通过SAVEPOINT语句创建标记.ROLLBACKTOSAVEPOINT语句可回滚到标记.54自动的co

mmit发生在:DDL语句执行隐性的事务处理55COMMIT;Commitcomplete.改变数据.Commit改变.DELETEFROMemployeesWHEREemployee_id=99999;1rowdeleted.INSERTINTOdepartmentsVALUE

S(290,'CorporateTax',NULL,1700);1rowinserted.提交数据56回滚后数据状态将丢弃所有未COMMIT的改变：DELETEFROMcopy_emp;22rowsdele

ted.ROLLBACK;Rollbackcomplete.57如何写SQL语句SQL语句不区分大小写.关键字不能分行隔开.条件通常被分行放置.缩进被用来提高语句的可读性58总结通过这部分课程的学习,您将了解以下内

容:SQL语句类型写一个SELECT语句:描述DML语句在表中插入数据行在表中修改数据行从表中删除数据行控制事务处理59练习请见《Oracle数据库维护上机任务书》课堂练习-〉SQL语言基础数据库函数61目标通

过这部分课程的学习,您将了解以下内容:描述SQL中用到的不同类型的函数在SELECT语句中使用字符，数值和日期等函数转换函数的使用62SQLFunctionsFunctionInputarg1arg2argnFunctionperforms

actionOutputResultvalue63字符型函数字符型函数LOWERUPPERINITCAPCONCATSUBSTRLENGTHINSTRLPAD|RPADTRIMREPLACE大小写处理函数字符处理函数64FunctionResult大小写处理函数能对字符串进行大小写转换.

LOWER('SQLCourse')UPPER('SQLCourse')INITCAP('SQLCourse')sqlcourseSQLCOURSESqlCourse65使用大小写处理函数SELECTemployee_id,last_name,department_idFROMemploye

esWHERElast_name='higgins';norowsselectedSELECTemployee_id,last_name,department_idFROMemployeesWHERELOWER(last_name)='higgins';66CONCAT('Hel

lo','World')SUBSTR('HelloWorld',1,5)LENGTH('HelloWorld')INSTR('HelloWorld','W')LPAD(salary,10,'*')RPAD(salary

,10,'*')TRIM('H'FROM'HelloWorld')HelloWorldHello106*****2400024000*****elloWorldFunctionResult字符处理函数

下列函数能对字符串进行处理:67SELECTemployee_id,CONCAT(first_name,last_name)NAME,job_id,LENGTH(last_name),INSTR(last_name,'a')"C

ontains'a'?"FROMemployeesWHERESUBSTR(job_id,4)='REP';使用字符处理函数12312368数值函数ROUND:四舍五入到指定的小数位数ROUND(45.926,2)45.93TRUNC:截断值到指定的小数位数TRUNC(45.92

6,2)45.92MOD:做除法取余数MOD(1600,300)10069日期函数两个日期中的间隔月数MONTHS_BETWEENADD_MONTHSNEXT_DAYLAST_DAYROUNDTRUNC在日期中增加历法月数指定日期中的下一天这个月的最后一天Round日期Truncate日期Fu

nctionDescription70•MONTHS_BETWEEN('01-SEP-95','11-JAN-94')使用日期函数•ADD_MONTHS('11-JAN-94',6)•NEXT_DAY('01-SEP-95

','FRIDAY')•LAST_DAY('01-FEB-95')19.6774194'11-JUL-94''08-SEP-95''28-FEB-95'71转换函数隐性的数据类型转换显性的数据类型转换数据类型转换72UsingtheTO_CHARFunctionwithDatesTheform

atmodel:MustbeenclosedinsinglequotationmarksandiscasesensitiveCanincludeanyvaliddateformatelementHasanfmelementtoremovepaddedblanksorsuppre

ssleadingzerosIsseparatedfromthedatevaluebyacommaTO_CHAR(date,'format_model')73YYYY日期格式基本模型YEARMMMONTHDYDAYFullyearinnumbersYearspelled

outTwo-digitvalueformonthThree-letterabbreviationofthedayoftheweekFullnameofthedayoftheweekFullnameofthemonthM

ONThree-letterabbreviationofthemonthDDNumericdayofthemonth74使用TO_CHAR函数转换日期SELECTlast_name,TO_CHAR(hire_date,'fmDD

MonthYYYY')ASHIREDATEFROMemployees;…75使用TO_NUMBER和TO_DATE函数转换字符型到数值型:转换字符型到日期型:TO_NUMBER(char[,'format_model'])TO_DATE(char[,'format

_model'])76总结通过这部分课程的学习，您应该已经了解:描述SQL中用到的不同类型的函数在SELECT语句中使用字符，数值和日期等函数转换函数的使用77练习请见《Oracle数据库维护上机任务书》课堂练习-〉数据库函数78问题和解答3F7IaLdPgSjVnYq$t*w-A1D4

G8JbMeQhTlWoZr%u(x+B2E6H9KcOfRiUmXp!s&v)z0C3F7IaMdPgSkVnYq$t*x-A1D5G8JbNeQiTlWo#r%u(y+B3E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPhSkVnZq$t*x-A2D5G8KbNeQiT

lXo#r%v(y+B3E6I9LcOgRjUmYp!t&w)z1C4F7JaMePhSkWnZq$u*x-A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LdOgRjVmYp!t&w-z1C4G7JaMeP

hTkWnZr$u*x+A2E5H8KcNfQiUlXp#s%v)y0B3F6IaLdOgSjVmYq!t&w-z1D4G7JbMePhTkWoZr$u(x+A2E5H9KcNfRiUlXp#s&v)y0C3F6IaLdPgSjVnYq!t*w-A1D4G8JbMeQhTlWoZr%u(x+B

2E5H9KcOfRiUmXp#s&v)z0C3F7IaLdPgSkVnYq$t*w-A1D5G8JbNeQhTlWo#r%u(y+B2E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8KbNeQiTlWo#r%v(

y+B3E6H9LcOgRjUmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LcOgRjVmYp!t&w)z1C4G7JaMePhSkWnZr$u*x+A2D5H8KcNf

QiUlXo#s%v)y0B3F6I9LdOgSjVmYq!t&w-z1D4G7JbMePhTkWnZr$u(x+A2E5H8KcNfRiUlXp#s%v)y0C3F6IaLdOgSjVnYq!t*w-z1D4G8JbMeQhTkWoZ

r%u(x+B2E5H9KcOfRiUmXp#s&v)z0C3F7IaLdPgSjVnYq$t*w-A1D4G8JbNeQhTlWoZr%u(y+B2E6H9KcOfRjUmXp!s&v)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8KbNeQiTlWo#r%u(y+B3E6H9L

cOfRjUmYp!s&w)z0C4F7JaMdPhSkVnZq$u*x-A2D5G8KbNfQiTlXo#r%v(y0B3E6I9LcOgRjVmYp!t&w)z1C4F7JaMePhSkWnZq$u

*x+A2D5H8KbNfQiUlXo#s%v(y0B3F6I9LdOgRjVmYq!t&w-z1C4G7JbMePhTkWnZr$u(x+A2E5H8KcNfRiUlXp#s%v)y0B3F6IaLdO

gSjVmYq!t*w-z1D4G7JbMeQhTkWoZr$u(x+B2E5H9KcNfRiUmXp#s&v)y0C3F7IaLdPgSjVnYq$t*w-A1D4G8JbMeQhTlWoZr%u(x+B2E6H9KcOfRiUmXp!s&v)z0C3F7IaMdPg

SkVnYq$t*x-A1D5G8JbNeQiTlWo#r%u(y+B3E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPhSkVnZq$t*x-A2D5G8KbNeQiTlXo#r%v(y+B3E6I9LcOgRjUmYp!t&w)z1C4F

7JaMePhSkWnZq$u*x+A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LdOgRjVmYp!t&w-z1C4G7JaMePhTkWnZr$u*x+A2E5H8KcNfQiUlXp#s%v)yF7

JaMdPhSkWnZq$u*x-A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LdOgRjVmYp!t&w-z1C4G7JaMePhTkWnZr$u*x+A2E5H8KcNfQiUlXp#s%v)y0B3F6I9LdOgSj

VmYq!t&w-z1D4G7JbMePhTkWoZr$u(x+A2E5H9KcNfRiUlXp#s&v)y0C3F6IaLdPgSjVnYq!t*w-A1D4G8JbMeQhTkWoZr%u(x+B2E5H9KcOfRiUmXp#s&v)z0C

3F7IaLdPgSkVnYq$t*w-A1D5G8JbNeQhTlWo#r%u(y+B2E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8KbNeQiTlW

o#r%v(y+B3E6H9LcOgRjUmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5H8KbNfQiTlXo#r%v(y0B3E6I9LcOgRjVmYp!t&w)z1C4G7JaMePhSkWnZr$u*x

+A2D5H8KcNfQiUlXo#s%v)y0B3F6I9LdOgSnZq$u*x-A2D5G8KbNfQiTlXo#r%v(y0B3E6I9LcOgRjVmYp!t&w)z1C4G7JaMePhSkWnZr$u*x+A2

D5H8KcNfQiUlXo#s%v)y0B3F6I9LdOgRjVmYq!t&w-z1C4G7JbMePhTkWnZr$u(x+A2E5H8KcNfRiUlXp#s%v)y0C3F6IaLdOgSjVnYq!t*w-z1D4G8JbM

eQhTkWoZr$u(x+B2E5H9KcNfRiUmXp#s&v)y0C3F7IaLdPgSjVnYq$t*w-A1D4G8JbNeQhTlWoZr%u(y+B2E6H9KcOfRjUmXp!s&v)z0C4F

7IaMdPgSkVnYq$t*x-A1D5G8JbNeQiTlWo#r%u(y+B3E6H9LcOfRjUmYp!s&w)z0C4F7JaMdPhSkVnZq$u*x-A2D5G8KbNfQiTlXo#r%v(y+B3E6I9LcOgRjUmYp!t&w)z1C4F7JaMePhSkWnZq$u

*x+A2D5H8KbNfQiUlXo#s%v(y0B3F6I9LdOgRjVmYq!t&w-z1C4G7JaMePhTkWnZr$u*x+A2E5H8KcNfQiUlXp#s%v)y0B3F6IaLdOgSjVmYq!t*w-z1D4G

7JbMeQhTkWoZr$u(x+B2E5H9KcNfRiUmXp#s&v)y0C3F6IaLdPgSjVnYq!t*w-A1D4G8JbMeQhTlWoZr%u(x+B2E6H9KcOfRiUmXp!s&v)z0C3F7IaMdPgSkVnYq$t*x-A

1D5G8JbNeQhTlWo#r%u(y+B2E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPhSkVnZq$t*x-A2D5G8KbNeQiTlXo#r%v(y+B3E6I9LcOgRj

UmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LdOgRjVmYp!t&w-z1C4G7JaMePhTkWnZr$u*x+A2E5H8KcNfQi

UlXo#s%v)y0B3F6I9LdOgSjVmYq!t&w-z1D4G7JbMePhTkWoZr$u(x+A2E5H9KcNfRiUlXp#s&v)y0C3F6IaLdPgSjr$u*x+A2D5H8KcNfQiUlXo#s%v)y0B3F6I9

LdOgSjV(y+B2E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8KbNeQiTlWo#r%v(y+B3E6H9LcOgRjUmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5H8KbNfQiTlXo#v

)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8KbNeQiTlWo#r%v(y+B3E6H9LcOgRjUmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5G8KbNfQiTlXo#

r%v(y0B3E6I9LcOgRjVmYp!t&w)z1C4G7JaMePhSkWnZr$u*x+A2D5H8KcRjUmYp!s&w)4G8JbNeQhTlWoZr%u(y+B2E6H9KcOfRjUmXp!s&v)

z0C4F7IaMdPgSkVnZu(x+B2E5H9KcOfRiUmXp#s&v)y0C3F7IaLdPgSjVnYq$t*w-A1D4G8JbNeQhTlWoZr%u(y+B2E6H9KcOfRjUmXp!s&v)z0C4F7IaMdPgSkVnZq$

t*x-A1D5G8KbNeQiTlWo#r%u(y+B3E6H9LcOfRjUmYp!s&w)z0C4F7JaMdPhSkVnZq$u*x-A2D5G8KbNfQiTlXo#r%v(y0B3E6I9LcOgRjVmYp!t&w)z1C4F7Ja

MePhSkWnZq$u*x+A2D5H8KbNfQiUlXo#s%v(y0B3F6I9LdOgRjVmYq!t&w-z1C4G7JbMePhTkWnZr$u(x+A2E5H8KcNfQiUlXp#s%1C4F7JaMePhSkW

nZq$u*x+A2D5H8KbNfQiUlXo#s%v(y0B3F6I9LdOgRjVmYq!t&w-z1C4G7JbMePhTkWnZr$u*x+A2E5H8KcNfQiUlXp#s%v)y0B3F6IaLdOgSjVm

Yq!t*w-z1D4G7JbMeQhTkWoZr$u(x+B2E5H9KcNfRiUmXp#s&v)y0C3F6IaLdPgSjVnYq!t*w-A1D4G8JbMeQhTlWoZr%u(x+B2E6H9KcOfRiUmXp!s&v)z0C3F7IaMdPgSkVnYq$t*x-A1D5G8J

bNeQiTlWo#r%u(y+B2E6LdPgSjVnYq!t*w-A1D4G8JbMeQhTlWoZr%u(x+B2E6H9KcOfRiUmXp!s&v)z0C3F7IaMdPgSkVnYq$t*w-A1D5G8

JbNeQhTlWo#r%u(y+B2E6H9LcOfRjUmXp!s&w)z0C4F7IaMdPhSkVnZq$t*x-A2D5G8KbNeQiTlXo#r%v(y+B3E6I9LcOgRjUmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5H8KbNfQ

iTlXo#s%v(y0B3E6I9LdOgRjVmYp!t&w-z1C4G7JaMePhTkWnZr$u*x+A2D5H8KcNfQiUlXo#s%v)y0B3F6I9LdOgSjVmYq!t&w-z1D4G

7JbMePhTkWoZr$u(x+A2E5H9KcNfRiUlXp#1D5G8KbNeQiTlWo#r%v(y+B3E6H9LcOgRjUmYp!s&w)z1C4F7JaMdPhSkWnZq$u*x-A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LcOgRjVmYp!t&w)

z1C4G7JaMePhSkWnZr$u*x+A2D5H8KcNfQiUlXo#s%v)y0B3F6I9LdOgSjVmYq!t&w-z1D4G7JbMePhTkWnZr$u(x+A2E5H8KcNfRiUlXp#s%v)y0C3F6IaLdOkW

nZr$u*x+A2D5H8KcNfQiUlXo#s%v)y0B3F6I9LdOgSjVmYq!t&w-z1C4G7JbMePhTkWnZr$u(x+A2E5H8KcNfRiUlXp#s%v)y0C3F6IaLdOgSjVnYq!t*w-z1D4G8Jb

MeQhTkWoZr%u(x+B2E5H9KcNfRiUmXp#s&v)y0C3F7IaLdPgSjVnYq$t*w-A1D4G8JbNeQhTlWoZr%u(y+B2E6H9KcOfRjUmXp!s&v)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8JbN

eQiTlWo#r%u(y+B3E6H9LcOfRjUmYp!s&w)z0C4F7JaMdPhSkVnZq$u*x-A2D5cOfRjUmXp!s&v)z0C3F7Ia