create table �t�Ӹ�� (��~�O text, ���q���Y varchar, �a�} varchar(16));

create index �t�Ӹ��index1 on �t�Ӹ�� using btree (��~�O);

create index �t�Ӹ��index2 on �t�Ӹ�� using hash (���q���Y);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into �t�Ӹ�� values ('�q���~', '�F�F���', '�_A01��');

insert into �t�Ӹ�� values ('�s�y�~', '�]���������q', '��B10��');

insert into �t�Ӹ�� values ('�\���~', '�����ѥ��������q', '��Z01�E');

create table �׻����Ѹ� (�Ѹ� text, ʬ�ॳ���� varchar, ����1A���� char(16));

create index �׻����Ѹ�index1 on �׻����Ѹ� using btree (�Ѹ�);

create index �׻����Ѹ�index2 on �׻����Ѹ� using hash (ʬ�ॳ����);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into �׻����Ѹ� values('����ԥ塼���ǥ����ץ쥤','��A01��');

insert into �׻����Ѹ� values('����ԥ塼������ե��å���','ʬB10��');

insert into �׻����Ѹ� values('����ԥ塼���ץ�����ޡ�','��Z01��');

create table ͪߩѦ��� (��� text, ��׾�ڵ� varchar, ���1A�� char(16));

create index ͪߩѦ���index1 on ͪߩѦ��� using btree (���);

create index ͪߩѦ���index2 on ͪߩѦ��� using hash (��׾�ڵ�);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into ͪߩѦ��� values('��ǻ�͵��÷���', 'ѦA01߾');

insert into ͪߩѦ��� values('��ǻ�ͱ׷��Ƚ�', '��B10��');

insert into ͪߩѦ��� values('��ǻ�����α׷���', '��Z01��');

create table ��ٸ���� (����ɱ text, ��Ƴ��� varchar, ���� varchar(16));

create index ��ٸ����index1 on ��ٸ���� using btree (����ɱ);

create index ��ٸ����index2 on ��ٸ���� using hash (��Ƴ���);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into ��ٸ���� values ('�����', '������', 'ơA01��');

insert into ��ٸ���� values ('������', '����ȴ����Ƴ', '��B10��');

insert into ��ٸ���� values ('����', 'ӡ��ϴǹȴ����Ƴ', '��Z01Ħ');

create table Ӌ��C���Z (���Z text, ����`�� varchar, �俼1A���� char(16));

create index Ӌ��C���Zindex1 on Ӌ��C���Z using btree (���Z);

create index Ӌ��C���Zindex2 on Ӌ��C���Z using hash (����`��);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into Ӌ��C���Z values('����ԥ�`���ǥ����ץ쥤','�CA01��');

insert into Ӌ��C���Z values('����ԥ�`������ե��å���','��B10��');

insert into Ӌ��C���Z values('����ԥ�`���ץ�����ީ`','��Z01��');

create table ��ג�������ђ�� (��ђ�� text, �ʬ������������ varchar, ������1A������ char(16));

create index ��ג�������ђ��index1 on ��ג�������ђ�� using btree (��ђ��);

create index ��ג�������ђ��index2 on ��ג�������ђ�� using hash (�ʬ������������);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into ��ג�������ђ�� values('������Ԓ�咡������ǒ�������ג�쒥�','���A01���');

insert into ��ג�������ђ�� values('������Ԓ�咡���������钥Ւ����Ò�����','�ʬB10���');

insert into ��ג�������ђ�� values('������Ԓ�咡������ג�풥���钥ޒ��','���Z01���');

create table �ͪ�ߩ�Ѧ��듾� (��듾� text, ��“׾��ړ�� varchar, ����1A��󓱸 char(16));

create index �ͪ�ߩ�Ѧ��듾�index1 on �ͪ�ߩ�Ѧ��듾� using btree (��듾�);

create index �ͪ�ߩ�Ѧ��듾�index2 on �ͪ�ߩ�Ѧ��듾� using hash (��“׾��ړ��);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into �ͪ�ߩ�Ѧ��듾� values('��ēǻ��͓�𓽺��Ó�����', '�ѦA01�߾');

insert into �ͪ�ߩ�Ѧ��듾� values('��ēǻ��͓�ד����ȓ��', '���B10���');

insert into �ͪ�ߩ�Ѧ��듾� values('��ēǻ��͓����Γ�ד�����', '���Z01���');

create table �v�Z�@�p�� (�p�� text, ���ރR�[�h varchar, ���l1A���� char(16));

create index �v�Z�@�p��index1 on �v�Z�@�p�� using btree (�p��);

create index �v�Z�@�p��index2 on �v�Z�@�p�� using hash (���ރR�[�h);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into �v�Z�@�p�� values('�R���s���[�^�f�B�X�v���C','�@A01��');

insert into �v�Z�@�p�� values('�R���s���[�^�O���t�B�b�N�X','��B10��');

insert into �v�Z�@�p�� values('�R���s���[�^�v���O���}�[','�lZ01��');

create table 計算機用語 (用語 text, 分類コード varchar, 備考1Aだよ char(16));

create index 計算機用語index1 on 計算機用語 using btree (用語);

create index 計算機用語index2 on 計算機用語 using hash (分類コード);

WARNING: hash indexes are not WAL-logged and their use is discouraged

insert into 計算機用語 values('コンピュータディスプレイ','機A01上');

insert into 計算機用語 values('コンピュータグラフィックス','分B10中');

insert into 計算機用語 values('コンピュータプログラマー','人Z01下');