Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/manage_22222/Dental/   drwxr-xr-x
Free 52.62 GB of 127.8 GB (41.18%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     sql.txt (36.86 KB)      -rw-r--r--

-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- вОКµм: localhost
-- аЗЕТг№ЎТГКГйТ§: 21 Б.¤. 2008  №.
-- ГШи№ўН§а«ФГмїаЗНГм: 5.0.24
-- ГШи№ўН§ PHP: 5.1.6
-- 
-- °Т№ўйНБЩЕ: `manage_db`
-- 

-- --------------------------------------------------------

-- 
-- в¤Г§КГйТ§µТГТ§ `personal_den_tb`
-- 

CREATE TABLE `personal_den_tb` (
  `Person_code` int(5) unsigned zerofill NOT NULL auto_increment,
  `Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
  `HN_code` varchar(10) NOT NULL default '',
  `Teach_code` int(3) unsigned zerofill NOT NULL default '000',
  `Code` int(3) unsigned zerofill NOT NULL default '000',
  `First_name` varchar(30) NOT NULL default '',
  `Name` varchar(60) NOT NULL default '',
  `Lastname` varchar(60) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Datetype` date NOT NULL default '0000-00-00',
  `Sex` varchar(10) NOT NULL default '',
  `Age` varchar(10) NOT NULL default '',
  `Nationality` varchar(50) NOT NULL default '',
  `Hostpital` int(1) unsigned zerofill NOT NULL default '0',
  `Nation` varchar(50) NOT NULL default '',
  `Religion` varchar(50) NOT NULL default '',
  `Citizen_id` varchar(13) NOT NULL default '',
  `Father_name` varchar(100) NOT NULL default '',
  `Mother_name` varchar(100) NOT NULL default '',
  `ProvinceId` int(2) unsigned NOT NULL default '0',
  `Zipcode` varchar(10) NOT NULL default '',
  `Phone` varchar(20) NOT NULL default '',
  `Mobile` varchar(15) NOT NULL default '',
  `Work` varchar(155) NOT NULL default '',
  `Status2` varchar(50) NOT NULL default '',
  `Status3` varchar(50) NOT NULL default '',
  `Education` varchar(150) NOT NULL default '',
  `Email_name` varchar(50) NOT NULL default '',
  `Email_1` varchar(50) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Phone_1` varchar(20) NOT NULL default '',
  `Mobile_1` varchar(15) NOT NULL default '0',
  `Degree_code` varchar(50) NOT NULL default '0',
  `Group_1` varchar(200) NOT NULL default '',
  `Group_2` varchar(200) NOT NULL default '',
  `Group_3` varchar(200) NOT NULL default '',
  `Group_4` varchar(50) NOT NULL default '',
  `Person_type` tinyint(1) NOT NULL default '0',
  `Dental_code` tinyint(6) NOT NULL default '0',
  `Club_nid` varchar(15) NOT NULL default '',
  `Dentis_code` tinyint(5) NOT NULL default '0',
  `Username` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  `Flag_del` tinyint(1) NOT NULL default '0',
  `Permision` char(2) NOT NULL default '',
  PRIMARY KEY  (`Person_code`),
  KEY `Teacher_code` (`Person_code`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=tis620  AUTO_INCREMENT=65 ;

-- 
-- dump µТГТ§ `personal_den_tb`
-- 

INSERT INTO `personal_den_tb` (`Person_code`, `Teacher_code`, `HN_code`, `Teach_code`, `Code`, `First_name`, `Name`, `Lastname`, `DateBirth`, `Datetype`, `Sex`, `Age`, `Nationality`, `Hostpital`, `Nation`, `Religion`, `Citizen_id`, `Father_name`, `Mother_name`, `ProvinceId`, `Zipcode`, `Phone`, `Mobile`, `Work`, `Status2`, `Status3`, `Education`, `Email_name`, `Email_1`, `Address`, `Img1`, `Phone_1`, `Mobile_1`, `Degree_code`, `Group_1`, `Group_2`, `Group_3`, `Group_4`, `Person_type`, `Dental_code`, `Club_nid`, `Dentis_code`, `Username`, `Password`, `Flag_del`, `Permision`) VALUES (00034, 00068, '491782', 000, 000, '№ТВ', 'ЗФГР', 'єШ­вЎЇФ', '2519-09-11', '2549-05-01', 'ЄТВ', '30', 'д·В', 2, 'д·В', 'ѕШ·ё', '325030010489', '', '', 16, '', '', '09-5456860', '', '', '', '', '', '', '214 Б. 10  µ.№ТґХ    Н. №ТґХ', '../../images/lingual.jpg', '', '', '', '', '', '', '', 0, 0, '', 0, '', '', 0, ''),
(00035, 00068, '491783', 000, 000, '№Т§КТЗ', 'НСЁ©ГТ', '№ШИФЕ', '2523-07-09', '2549-05-01', 'Л­Ф§', '23', 'д·В', 2, 'д·В', 'ѕШ·ё', '373040003496', '', '', 11, ' 20000', '', '06-8283984', '', '', '', '', '', '', '26/368 Б. 1 µ§№Т»иТ  Н.аБЧН§', '../../images/lingual.jpg', '', '', '', '', '', '', '', 0, 0, '', 0, '', '', 0, ''),
(00032, 00058, '491774', 000, 000, '№ТВ', 'ѕ§ИёГ', 'бЎи№аЎЙБ', '2515-04-23', '2549-05-01', 'ЄТВ', '34', 'д·В', 2, 'д·В', 'ѕШ·ё', '334040083587', '33333333', '33', 11, ' 20000', '', '07-1346915', 'ѕ№СЎ§Т№єС­ЄХ/ЎТГа§Ф№', '', '', 'НТЄХЗИЦЎЙТ / КТВНТЄХѕ', '', '', '29 /119  Б.2  µ.єйТ№КЗ№  Н. аБЧН§ 33', '', '', '', '', 'www', 'ww', 'www', '', 0, 0, '', 0, '', '', 0, ''),
(00033, 00054, '491777', 000, 000, '№ТВ', 'ґУГ§¤м', '№З№№Т§', '2511-04-01', '2549-05-01', 'ЄТВ', '38', 'д·В', 2, 'д·В', 'ѕШ·ё', '570020000350', '', '', 11, ' 20000', '', '', '', '', '', '', '', '', '46/49 Б.5  µ.єТ§·ГТВ  Н. аБЧН§', '../../images/damon3.jpg', '', '', '', '', '', '', '', 0, 0, '', 0, '', '', 0, ''),
(00036, 00000, '491788', 000, 000, '№ТВ', 'гВ', 'аЕФИЎЕТ§', '2502-01-03', '2549-05-01', 'ЄТВ', '47', 'д·В', 2, 'д·В', 'ѕШ·ё', '330200095966', '', '', 11, ' 20000', '', '05-0869487', '', '', '', '', '', '', '62/10 Б. 6   µ. єйТ№КЗ№   Н. аБЧН§', '', '', '', 'вГ¤дЗГСКµСєНСЎаКє', '', '', '', '', 0, 0, '', 0, '', '', 0, ''),
(00037, 00054, '492420', 000, 000, '№ТВ', 'Н№Шѕ§Йм', 'б«ивЎ', '2520-06-11', '2549-05-25', 'ЄТВ', '28', 'д·В', 2, 'д·В', 'ѕШ·ё', '320020009695', '', '', 11, ' 20000', '', '06-1563566', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '72/3 Б. 3 µ. Л№Н§«ТЎ   Н.єйТ№єЦ§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00038, 00069, '492379', 000, 000, '№ТВ', 'КШЄТµФ', 'ѕ§Йм»ГРґФЙ°м', '2517-12-27', '2549-05-24', 'ЄТВ', '31', 'д·В', 2, 'д·В', 'ѕШ·ё', '320010080624', '', '', 11, ' 20000', '', '01-5889178', '', '', '', '', '', '', '27/117  Б.2  µ.єйТ№КЗ№  Н.аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00039, 00071, '492528', 000, 000, '№Т§', 'НШЙТ', 'б«иаµХВЗ', '2502-05-12', '2549-05-30', 'Л­Ф§', '47', 'д·В', 2, 'д·В', 'ѕШ·ё', '320020001845', '', '', 11, '', '', '09-0979035', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '283/5  Б.4  µ. Л№Н§НГШі  Н. єйТ№єЦ§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00040, 00058, '492450', 000, 000, '№ТВ', 'єШ­аЕФИ', 'а№ХВБа·И', '2499-09-15', '2549-05-26', 'ЄТВ', '50', 'д·В', 2, 'д·В', 'ѕШ·ё', '310240034148', '', '', 11, ' 20000', '', '09-5417436', '', '', '', '', '', '', '5/115 Б. 1  µ. ґН№ЛСЗМН  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00041, 00054, '492530', 000, 000, '№ТВ', 'НФ№·Гм¶Т', 'БТµа·З', '2524-06-14', '2549-05-30', 'ЄТВ', '25', 'д·В', 2, 'д·В', 'ѕШ·ё', '343090064151', '', '', 11, ' 20000', '', '04-1290099', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '110/33  Б.5  µ. єТ§·ГТВ  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00042, 00071, '492532', 000, 000, '№ТВ', 'дЗ', 'ГСµ№мНШєЕ', '2517-06-25', '2549-05-30', 'ЄТВ', '31', 'д·В', 2, 'д·В', 'ѕШ·ё', '360090032241', '', '', 11, ' 20000', '', '05-9415708', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '139/1  Б.1  µ. Л№Н§дБйᴧ  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00043, 00054, '492529', 000, 000, '№Т§КТЗ', '»С­ЁіТ', 'ёГГБГСЎЙм', '2522-04-05', '2549-05-30', 'Л­Ф§', '27', 'д·В', 2, 'д·В', 'ѕШ·ё', '320010053155', '', '', 11, ' 20000', '', '09-6005059', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '91/2 Б. 7 µ. Л№Н§ГХ  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00044, 00054, '492533', 000, 000, '№Т§КТЗ', 'ѕСЄ№Х', '¤ШйБѕ§Йм', '2523-02-05', '2549-05-25', 'Л­Ф§', '26', 'д·В', 2, 'д·В', 'ѕШ·ё', '320050037730', '', '', 11, '', '', '09-2487032', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '73/2  Б. 4  µ. єйТ№КЗ№   Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00045, 00127, '492490', 000, 000, '№Т§', 'ѕЕНВГЗХ', 'НФ§¤№ТЗФ№', '2502-03-17', '2549-05-29', 'Л­Ф§', '29', 'д·В', 2, 'д·В', 'ѕШ·ё', '324030008226', '', '', 11, '', '', '06-8373933', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '657/3  ¶. ѕФѕФё   µ§ єйТ№вўґ   Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00046, 00069, '492537', 000, 000, '№ТВ', 'вКГСЄ', 'ЗХГР­Тві', '2520-01-20', '2549-05-30', 'ЄТВ', '29', 'д·В', 2, 'д·В', 'ѕШ·ё', '320010126243', '', '', 11, ' 20000', '', '01-2922937', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '718/48   «.вГ§дБйўХґ   Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00047, 00068, '492538', 000, 000, '№Т§КТЗ', 'ИШАБТИ', 'ґШЕВГСµ№м', '2509-12-24', '2549-05-30', 'Л­Ф§', '39', 'д·В', 2, 'д·В', 'ѕШ·ё', '323990001277', '', '', 11, '', '038-445481', '06-5361467', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '84 ¶. єйТ№єЦ§-бЎЕ§  µ. єйТ№єЦ§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00048, 00069, '492379', 000, 000, '№ТВ', 'ЗХ№СК', 'аГЧН§ЁУГЩ­', '2509-01-05', '2549-05-24', 'ЄТВ', '40', 'д·В', 2, 'д·В', 'ѕШ·ё', '320010062774', '', '', 11, '', '', '09-0955745', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '71/31  Б.1 µ.НиТ§ИФЕТ  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00049, 00071, '492536', 000, 000, '№Т§КТЗ', 'ГШ觹АТ', 'ѕШ·ё»ГРИТКµГм', '2511-08-01', '2549-05-30', 'Л­Ф§', '38', 'д·В', 2, 'д·В', 'ѕШ·ё', '320010012061', '', '', 11, '', '', '', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '585/38  Б. 9  µ§ ¤ЕН§ЎФиЗ  Н. єйТ№єЦ§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00050, 00058, '492539', 000, 000, '№Т§', 'ГСµµФВТ', 'КЎШЕаЕФИЗТіФЄ', '2522-04-23', '2549-01-30', 'Л­Ф§', '27', 'д·В', 2, 'д·В', 'ѕШ·ё', '320010048712', '', '', 11, ' 20000', '', '06-1555645', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '59/60 Б. 11  µ.Л№Н§ГХ   Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00051, 00058, '492541', 000, 000, '№Т§КТЗ', 'КШіС°ЄТ', 'ЎУаЛ№Фґ', '2523-11-14', '2549-05-30', 'Л­Ф§', '26', 'д·В', 2, 'д·В', 'ѕШ·ё', '533050003074', '', '', 11, '', '', '06-1498032', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '700/415  Б.7  µ. ґН№ЛСЗЙиН  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00052, 00071, '492543', 000, 000, '№Т§КТЗ', 'ЁУ»Щ№', 'КТГѕС№ём', '2525-11-14', '2549-05-30', 'Л­Ф§', '24', 'д·В', 2, 'д·В', 'ѕШ·ё', '333050110523', '', '', 11, ' 20000', '', '07-1378372', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '700/415  Б.7  µ. ґН№ЛСЗЙиН  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00053, 00069, '492540', 000, 000, '№Т§КТЗ', 'ГШЁФГТ', '·ФѕВм»С­­Т', '2530-04-04', '2549-05-30', 'Л­Ф§', '19', 'д·В', 2, 'д·В', 'ѕШ·ё', '141060011002', '', '', 11, ' 20000', '', '06-6661897', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '75 /1  Б.6   µ. ґН№ЛСЗМиН   Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00054, 00052, '492544', 000, 000, '№ТВ', 'ЄТµФЄТВ', 'єШ­ГСµ№м', '2512-05-12', '2549-05-30', 'ЄТВ', '37', 'д·В', 2, 'д·В', 'ѕШ·ё', '325040057547', '', '', 11, '', '038-214051', '05-9148741', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '700/153  Б. 1  µ. єйТ№аЎиТ  Н. ѕТ№·Н§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00055, 00068, '492546', 000, 000, '№ТВ', 'а·Нґ·ЩЕ', 'аКГХКЎШЕЗ§Им', '2513-05-01', '2549-05-30', 'ЄТВ', '36', 'д·В', 2, 'д·В', 'ѕШ·ё', '320100030576', '', '', 11, ' 20000', '', '01-5231045', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '40/5 Б.7  µ. №Т»иТ   Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00056, 00068, '492548', 000, 000, '№Т§КТЗ', 'НЗТГСµ№м', '»ШкЎКЩ§а№Ф№', '2522-06-23', '2549-05-30', 'Л­Ф§', '26', 'д·В', 2, 'д·В', 'ѕШ·ё', '330190008007', '', '', 11, ' 20000', '', '06-1342245', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '44/20  Б.1  µ§Л№Н§ГХ  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00057, 00068, '492549', 000, 000, '№ТВ', 'КБАТГ', 'БФКТ', '2525-12-31', '2549-05-30', 'ЄТВ', '24', 'д·В', 2, 'д·В', 'ѕШ·ё', '341210004152', '', '', 11, ' 20000', '', '09-0994330', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '36/36  Б.5  «. ґУГ§ёГГБ   µ. ґН№ЛСЗМиН  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00058, 00054, '492535', 000, 000, '№ТВ', 'а©ЕФБ', 'ЎЩ¦С§', '2520-02-05', '2549-05-30', 'ЄТВ', '29', 'д·В', 2, 'д·В', 'ѕШ·ё', '371100011041', '', '', 56, '', '', '05-9856781', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '18  Б.  11  µ. Л№Н§»ЕФ§  Н. аЕТўЗС­', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00059, 00054, '492547', 000, 000, '№ТВ', '»ГХЄТ', 'КЩ§КС§аўµГ', '2507-09-27', '2549-05-30', 'ЄТВ', '41', 'д·В', 2, 'д·В', 'ѕШ·ё', '347120061304', '', '', 11, '', '', '04-1645689', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '24/1 Б. 9  µ.БТєв»Г§   Н. ѕТ№·Н§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00060, 00071, '492405', 000, 000, '№Т§КТЗ', 'ЁФГТ№ШЄ', 'НВЩи№ШЄ', '2513-09-26', '2549-05-24', 'Л­Ф§', '35', 'д·В', 2, 'д·В', 'ѕШ·ё', '321030065869', '', '', 11, '', '', '09-5415124', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '36/68  Б. 2  µ.єйТ№КЗ№  Н.аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00062, 00069, '492565', 000, 000, '№ТВ', 'µН§', 'ГНґбЎйЗ', '2515-05-28', '2549-05-31', 'ЄТВ', '34', 'д·В', 2, 'д·В', 'ѕШ·ё', '322040003328', '', '', 11, ' 20000', '', '09-9890774', 'ѕ№СЎ§Т№·СиЗд»', '', '', '', '', '', '35/5  µ. Л№Н§дБйᴧ   Н§ аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2'),
(00063, 00068, '492381', 000, 000, '№Т§', 'дѕаГТР', 'гЁѕГЛБ', '2504-03-18', '2549-05-24', 'Л­Ф§', '45', 'д·В', 2, 'д·В', 'ѕШ·ё', '320980012957', '', '', 11, ' 20000', '', '', '', '', '', '', '', '', '848/70 ¶.КШўШБЗФ·  µ. єТ§»ГТКГйНВ  Н. аБЧН§', '', '', '', '', '', '', '', '', 0, 0, '', 0, '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '2');

CREATE TABLE `tooth_tb` (
  `Tooth_code` int(2) unsigned NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` varchar(10) NOT NULL default '',
  `Description_2` text NOT NULL,
  PRIMARY KEY  (`Tooth_code`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=tis620 AUTO_INCREMENT=95 ;

-- 
-- dump µТГТ§ `tooth_tb`
-- 

INSERT INTO `tooth_tb` (`Tooth_code`, `Code_id`, `Description_1`, `Description_2`) VALUES (32, 'C005', '15', ''),
(29, 'C002', '12', ''),
(30, 'C003', '13', ''),
(31, 'C004', '14', ''),
(28, 'C011', '11', ''),
(33, 'C006', '16', ''),
(34, 'C007', '17', ''),
(35, 'C008', '18', ''),
(36, 'C009', '21', ''),
(37, 'C010', '22', ''),
(38, 'C011', '23', ''),
(39, 'C012', '24', ''),
(40, 'C013', '25', ''),
(41, 'C014', '26', ''),
(43, 'C015', '27', ''),
(44, 'C016', '28', ''),
(45, 'C017', '31', ''),
(46, 'C018', '32', ''),
(47, 'C019', '33', ''),
(49, 'C020', '34', ''),
(50, 'C021', '35', ''),
(51, 'C022', '51', ''),
(52, 'C023', '52', ''),
(53, 'C024', '36', ''),
(54, 'C025', '41', ''),
(55, 'C026', '42', ''),
(56, 'C027', '43', ''),
(57, 'C027', '44', ''),
(58, 'C028', '45', ''),
(59, 'C029', '46', ''),
(60, 'C030', '47', ''),
(61, 'C030', '48', ''),
(62, 'C031', '53', ''),
(63, 'C32', '54', ''),
(64, 'C033', '55', ''),
(66, 'C033', 'Full mouth', ''),
(67, 'C034', 'Lower left', ''),
(68, 'C036', 'Lower righ', ''),
(69, '', 'Upper left', ''),
(70, '', 'Upper righ', ''),
(71, '', '·С駻ҡ', ''),
(72, '', 'їС№є№', ''),
(73, '', 'їС№є№ўЗТ', ''),
(74, '', 'їС№є№«йТВ', ''),
(75, '', 'їС№ЕиТ§', ''),
(76, '', 'їС№ЕиТ§ўЗТ', ''),
(77, '', 'їС№ЕиТ§«йТ', ''),
(78, '', '61', ''),
(79, '', '62', ''),
(80, '', '63', ''),
(81, '', '64', ''),
(82, '', '65', ''),
(83, '', '71', ''),
(84, '', '72', ''),
(85, '', '73', ''),
(86, '', '74', ''),
(87, '', '75', ''),
(88, '', '81', ''),
(89, '', '82', ''),
(90, '', '83', ''),
(91, '', '84', ''),
(92, '', '85', '');

-- 
-- в¤Г§КГйТ§µТГТ§ `treatcat_tb`
-- 

CREATE TABLE `treatcat_tb` (
  `Code` int(3) unsigned zerofill NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=tis620 AUTO_INCREMENT=75 ;

-- 
-- dump µТГТ§ `treatcat_tb`
-- 

INSERT INTO `treatcat_tb` (`Code`, `Code_id`, `Description_1`, `Description_2`, `Description_3`) VALUES (052, 'A001', 'Oral Examination and consult', '', ''),
(053, 'A002', 'Oral Medicine', '', ''),
(054, 'A003', 'Periodontics', '', ''),
(055, 'A004', 'Operative', '', ''),
(056, 'A005', 'Dental Surgery', '', ''),
(057, 'A006', 'Endodontics', '', ''),
(058, 'A007', 'Fixed Prosthodontics', '', ''),
(059, 'A008', 'Preventive', '', ''),
(060, 'A009', 'Orthodontics', '', ''),
(061, 'A010', 'Removable Prosthodontics', '', ''),
(062, 'A011', 'X-ray', '', ''),
(063, 'A012', 'Cosmetic Dentistry', '', ''),
(064, 'A013', 'Miscelleneous', '', ''),
(065, 'A014', 'Implant', '', ''),
(066, 'A015', 'Merchandise', '', ''),
(067, 'A12', 'consult', 'Periodontics', '');


-- 
-- в¤Г§КГйТ§µТГТ§ `treatment_tb`
-- 

CREATE TABLE `treatment_tb` (
  `Teach_code` int(3) unsigned zerofill NOT NULL auto_increment,
  `Code_1` varchar(10) NOT NULL default '',
  `Name` varchar(30) NOT NULL default '',
  `Price` float(8,2) NOT NULL default '0.00',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Teach_code`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=tis620 AUTO_INCREMENT=154 ;

-- 
-- dump µТГТ§ `treatment_tb`
-- 

INSERT INTO `treatment_tb` (`Teach_code`, `Code_1`, `Name`, `Price`, `Description_1`, `Description_2`, `Description_3`) VALUES (034, 'B001', '·СиЗд»', 1000.00, 'Alveolectomy', 'јиТµСґµЎбµи§ЎГРґЩЎ', 'Dental Surgery'),
(035, 'B002', '·СиЗд»', 200.00, 'Amalgam Filling Polishing', 'ўСґЗСКґШНШґїС№', 'Cosmetic Dentistry'),
(036, 'C003', '', 40.00, 'Amoxy Dry Syrup 2 Oz./1 Bot.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(037, 'C004', '', 50.00, 'Amoxycillin 250 mg./12 caps.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(038, 'C005', '·СиЗд»', 100.00, 'Amoxycillin 250 mg./24 caps.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(039, 'C006', '·СиЗд»', 100.00, 'Amoxycillin 500 mg./12 caps.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(040, 'C007', '·СиЗд»', 100.00, 'Amoxycillin 500 mg./24 caps.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(041, 'B008', '·СиЗд»', 8000.00, 'Bleaching (Full mouth)', 'їНЎїС№ўТЗ', 'Cosmetic Dentistry'),
(042, 'B009', '·СиЗд»', 3000.00, 'Bleaching (Lower)', 'їНЎїС№ўТЗ', 'Cosmetic Dentistry'),
(043, 'B010', '·СиЗд»', 8000.00, 'Bleaching (Upper)', 'їНЎїС№ўТЗ', 'Cosmetic Dentistry'),
(044, 'B011', '·СиЗд»', 1000.00, 'Bleaching Tray (Full mouth)', '¶ТґїНЎКХїС№', 'Cosmetic Dentistry'),
(045, 'B012', '·СиЗд»', 500.00, 'Bleaching Tray (Lower)', '¶ТґїНЎКХїС№', 'Cosmetic Dentistry'),
(046, 'B013', '·СиЗд»', 500.00, 'Bleaching Tray (Upper)', '¶ТґїНЎКХїС№', 'Cosmetic Dentistry'),
(047, 'B014', '·СиЗд»', 10000.00, 'Bridge (Full ceramic)', 'КРѕТ№їС№', 'Fixed Prosthodontics'),
(049, 'B015', '·СиЗд»', 10000.00, 'Bridge (High Precious)', 'КРѕТ№їС№', 'Fixed Prosthodontics'),
(050, 'B016', '·СиЗд»', 5000.00, 'Bridge (Non Precious)', 'КРѕТ№їС№', 'Fixed Prosthodontics'),
(051, 'B017', '', 6000.00, 'Bridge (Palladium)', 'КРѕТ№їС№', 'Fixed Prosthodontics'),
(052, 'B018', '·СиЗд»', 8000.00, 'Bridge (Semiprecious)', 'КРѕТ№їС№', 'Fixed Prosthodontics'),
(053, 'B019', '·СиЗд»', 2000.00, 'Bridge (Temporary)', 'КРѕТ№їС№ЄСиЗ¤ГТЗ', 'Fixed Prosthodontics'),
(054, 'B020', '·СиЗд»', 400.00, 'Cementing (Bridge)', 'ВЦґ«ХаБ№µмКРѕТ№їС№', 'Fixed Prosthodontics'),
(055, 'B021', '·СиЗд»', 400.00, 'Cementing (Crown)', 'ВЦґ«ХаБ№µм¤ГНєїС№', 'Fixed Prosthodontics'),
(056, 'B022', '·СиЗд»', 400.00, 'Cementing(Inlay)', 'ВЦґ«ХаБ№µм', 'Fixed Prosthodontics'),
(057, 'B023', '·СиЗд»', 400.00, 'Cementing(Onlay)', 'ВЦґ«ХаБ№µм', 'Fixed Prosthodontics'),
(058, 'B024', '·СиЗд»', 400.00, 'Class I Amalgam Filling', 'НШґїС№ґйЗВНБСЕЎСБ', 'Operative'),
(059, 'B024', '·СиЗд»', 400.00, 'Class I Compomer Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(060, 'B025', '·СиЗд»', 400.00, 'Class I Large Amalgam Filling', 'НШґїС№ґйЗВНБСЕЎСБ', 'Operative'),
(061, 'B026', '·СиЗд»', 400.00, 'Class I LC.Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(062, 'B027', '·СиЗд»', 800.00, 'Class II MOD Amalgam Filling', 'НШґїС№ґйЗВНБСЕЎСБ', 'Operative'),
(063, 'B028', '·СиЗд»', 1000.00, 'Class II MOD Compomer Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(064, 'B029', '·СиЗд»', 1000.00, 'Class II MOD Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(065, 'B030', '·СиЗд»', 600.00, 'Class II OD Amalgam Filling', 'НШґїС№ґйЗВНБСЕЎСБ', 'Operative'),
(066, 'B031', '·СиЗд»', 800.00, 'Class II OD Compomer Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(067, 'B032', '·СиЗд»', 800.00, 'Class II OD LC.Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(068, 'B033', '·СиЗд»', 600.00, 'Class II OM Amalgam Filling', 'НШґїС№ґйЗВНБСЕЎСБ', 'Operative'),
(069, 'B034', '·СиЗд»', 800.00, 'Class II OM Compomer Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(070, 'B035', '·СиЗд»', 800.00, 'Class II OM LC.Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(071, 'B036', '·СиЗд»', 400.00, 'Class III D LC.Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(072, 'B037', '·СиЗд»', 400.00, 'Class III M LC.Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(073, 'B038', '·СиЗд»', 600.00, 'Class IV D LC. Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(079, 'B039', '·СиЗд»', 600.00, 'Class IV M LC.Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(080, 'B040', '·СиЗд»', 400.00, 'Class V Compomer Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(081, 'B041', '·СиЗд»', 400.00, 'Class V Composite Resin Filling', 'НШґїС№ґйЗВ¤НБвѕКФµаГ«Ф№', 'Operative'),
(082, 'B042', '·СиЗд»', 999.99, 'Complete Denture', 'їС№»ЕНБ·С駻ҡ', 'Removable Prosthodontics'),
(083, 'B043', '·СиЗд»', 1000.00, 'Complete Denture (High Impact)', 'їС№»ЕНБ·С駻ҡ', 'Removable Prosthodontics'),
(084, 'B044', '·СиЗд»', 400.00, 'Class V Compomer Filling', 'НШґїС№ґйЗВ¤НБвѕаБНГм', 'Operative'),
(085, 'B045', '·СиЗд»', 15000.00, 'Complete Denture (Vitallium)', 'їС№»ЕНБ·С駻ҡ', 'Removable Prosthodontics'),
(086, 'B046', '·СиЗд»', 10000.00, 'Crown (Full ceramic)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(087, 'B047', '·СиЗд»', 10000.00, 'Crown (High Precious)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(088, 'B048', '·СиЗд»', 5000.00, 'Crown (Non Precious)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(089, 'B049', '', 6000.00, 'Crown (Palladium)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(090, 'B050', '·СиЗд»', 10000.00, 'Crown (Procera)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(091, 'B051', '·СиЗд»', 8000.00, 'Crown (Semiprecious)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(092, 'B052', '·СиЗд»', 1000.00, 'Crown (Temporary)', '¤ГНєїС№ЄСиЗ¤ГТЗ', 'Fixed Prosthodontics'),
(093, 'B053', '·СиЗд»', 5.00, 'Danzen 5 mg./10 tabs.', 'ВТЕґНТЎТГєЗБ', 'Oral Medicine'),
(094, 'B054', '·СиЗд»', 50.00, 'Dental Floss', 'аКй№гВдЛБўСґїС№', 'Merchandise'),
(095, 'B055', '·СиЗд»', 300.00, 'Extraction', '¶Н№їС№', 'Dental Surgery'),
(096, 'B056', '·СиЗд»', 1200.00, 'Facing with LC.Composite Resin', 'а¤ЕЧНєїС№', 'Operative'),
(097, 'B057', '·СиЗд»', 1500.00, 'Fiber Post & Core (anterior)', 'аґЧНВїС№', 'Fixed Prosthodontics'),
(098, 'B058', '·СиЗд»', 0.00, 'Fiber Post & Core (posterior)', 'аґЧНВїС№', 'Fixed Prosthodontics'),
(099, 'B059', '·СиЗд»', 50.00, 'Floss Threader', 'аўзБ№УдЛБўСґїС№', 'Merchandise'),
(100, 'B060', '·СиЗд»', 150.00, 'Fluoride Application', 'а¤ЕЧНєїЕЩННдГґм', 'X-ray'),
(101, 'B061', '·СиЗд»', 0.00, 'Follow Up', 'ґЩНТЎТГ', 'Oral Examination and consult'),
(102, 'B062', '·СиЗд»', 10000.00, 'Full Metal Crown(Gold)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(103, 'B063', '·СиЗд»', 5000.00, 'Full Metal Crown(Nonprecious)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(104, 'B064', '·СиЗд»', 6000.00, 'Full Metal Crown(Palladium)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(105, 'B065', '·СиЗд»', 8000.00, 'Full Metal Crown(Semiprecious)', '¤ГНєїС№', 'Fixed Prosthodontics'),
(106, 'B066', '·СиЗд»', 30.00, 'Ibuprofen 200 mg./10 tabs.', 'ВТбЎй»Зґ', 'Oral Medicine'),
(107, 'B067', '·СиЗд»', 60000.00, 'Implant Placement', 'ГТЎа·ХВБ', 'ГТЎа·ХВБ'),
(108, 'B068', '·СиЗд»', 6000.00, 'Inlay(Ceramic)', 'гКиїС№', 'Operative'),
(109, 'B069', '·СиЗд»', 6000.00, 'Inlay(Gold)', 'гКиїС№', 'Operative'),
(110, 'B070', '·СиЗд»', 0.00, 'Irrigation with NSS', 'ЕйТ§бјЕ', 'Dental Surgery'),
(111, 'B071', '·СиЗд»', 0.00, 'Miscellaneous', 'аєзґаµЕзґ', 'X-ray'),
(112, 'B072', '·СиЗд»', 1000.00, 'MouthGuard', '¶Тґ«ФЕФ⤹ЎС№їС№ЎГРб·Ў', '¶Тґ«ФЕФ⤹ЎС№їС№ЎГРб·Ў'),
(113, 'B073', '·СиЗд»', 1000.00, 'Night Guard', '¶Тґ«ФЕФ⤹ЎС№їС№ЎГРб·Ў', 'X-ray'),
(114, 'B074', '·СиЗд»', 50.00, 'Nurofen 200 mg. 10 tabs', 'ВТбЎй»Зґ', 'Oral Medicine'),
(115, 'B075', '·СиЗд»', 6000.00, 'Onlay(Ceramic)', 'гКиїС№', 'Operative'),
(116, 'B076', '·СиЗд»', 0.00, 'Oral Check-up', 'µГЗЁКШўАТѕЄиН§»ТЎ', 'Oral Examination and consult'),
(117, 'B077', '·СиЗд»', 85.00, 'Orofar Buccal Spray 30 ml./1 Bot.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(118, 'B078', '·СиЗд»', 10.00, 'Paracetamol 325 mg./10 tabs.', 'ВТбЎй»Зґ', 'Oral Medicine'),
(119, 'B079', '·СиЗд»', 10.00, 'Paracetamol 500 mg./10 tabs.', 'ВТбЎй»Зґ', 'Oral Medicine'),
(120, 'B080', '·СиЗд»', 20.00, 'ParaSyrup 60 cc./1 Bot.', 'ВТбЎй»Зґ', 'ВТбЎй»Зґ'),
(121, 'B080', '·СиЗд»', 50.00, 'PenicillinV 250 mg./12 caps.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(122, 'B081', '·СиЗд»', 80.00, 'PenicillinV 250 mg./24 caps.', 'ВТбЎйНСЎаКє', 'Oral Medicine'),
(123, 'B082', '·СиЗд»', 50.00, 'Ponstan 250 mg./10 caps.', 'ВТбЎй»Зґ', 'Oral Medicine'),
(124, 'B083', '·СиЗд»', 80.00, 'Ponstan 500 mg./10 tabs.', 'ВТбЎй»Зґ', 'Oral Medicine'),
(125, 'B084', '·СиЗд»', 0.00, 'Preliminary Impression', 'ѕФБѕм»ТЎ', 'Oral Examination and consult'),
(126, 'B085', '·СиЗд»', 400.00, 'Repair (Denture)', '«иНБїС№»ЕНБ', 'Miscelleneous'),
(127, 'B086', '·СиЗд»', 300.00, 'Repair (Vitallium Partial Denture)', '«иНБїС№»ЕНБ', 'Miscelleneous'),
(128, 'B087', '·СиЗд»', 300.00, 'Repair(Temporary Plate)', '«иНБїС№»ЕНБ', 'Miscelleneous'),
(129, 'B088', '·СиЗд»', 1500.00, 'Root Canal Treatment (Anterior)', 'ГСЎЙТ¤ЕН§ГТЎїС№', 'Endodontics'),
(130, 'B089', '·СиЗд»', 3500.00, 'Root Canal Treatment (Molar)', 'ГСЎЙТ¤ЕН§ГТЎїС№', 'Endodontics'),
(131, 'B090', '·СиЗд»', 2500.00, 'Root Canal Treatment (Premolar)', 'ГСЎЙТ¤ЕН§ГТЎїС№', 'Endodontics'),
(132, 'B091', '·СиЗд»', 500.00, 'Scaling', 'ўЩґЛФ№»Щ№бЕРўСґїС№', 'Periodontics'),
(133, 'B092', '·СиЗд»', 200.00, 'Sealant', 'а¤ЕЧНєїС№', 'Preventive'),
(134, 'B093', '·СиЗд»', 4000.00, 'Single Lower Denture', 'їС№»ЕНБа©ѕТРїС№ЕиТ§', 'Removable Prosthodontics'),
(135, 'B094', '·СиЗд»', 5000.00, 'Single Lower Denture (High Impact)', 'їС№»ЕНБа©ѕТРїС№ЕиТ§', 'Removable Prosthodontics'),
(136, 'B095', '·СиЗд»', 5000.00, 'Single Lower Denture (Vitallium)', 'їС№»ЕНБа©ѕТРїС№ЕиТ§', 'Removable Prosthodontics'),
(137, 'B096', '·СиЗд»', 4000.00, 'Single Upper Denture', 'їС№»ЕНБа©ѕТРїС№є№', 'Removable Prosthodontics'),
(138, 'B097', '·СиЗд»', 5000.00, 'Single Upper Denture (High Impact)', 'їС№»ЕНБа©ѕТРїС№є№', 'Removable Prosthodontics'),
(139, 'B098', '·СиЗд»', 4000.00, 'Single Upper Denture (Vitallium)', 'їС№»ЕНБа©ѕТРїС№є№', 'Removable Prosthodontics'),
(140, 'B099', '·СиЗд»', 94.00, 'Solcoseryl Dental Adhesive Paste 5g./1 Catridge', 'ВТбЎйНСЎаКє', 'Removable Prosthodontics'),
(141, 'B100', '·СиЗд»', 0.00, 'Stitch Off', 'µСґдЛБ', 'Miscelleneous'),
(142, 'B101', '·СиЗд»', 1500.00, 'Surgical Removal', 'јиТµСґїС№¤Шґ', 'Dental Surgery'),
(143, 'B102', '·СиЗд»', 50.00, 'Temporary Filling', 'НШґїС№ЄСиЗ¤ГТЗ', 'Operative'),
(144, 'B103', '·СиЗд»', 1000.00, 'Temporary Plate', 'їС№»ЕНБѕЕТКµФЎЄ№Фґ¶Нґдґй', 'Removable Prosthodontics'),
(145, 'B104', '·СиЗд»', 10.00, 'Trinolone Oral Paste 1 mg./1 Pack', '¤ГХБ·ТбјЕг№ЄиН§»ТЎ', 'Oral Medicine'),
(146, 'B105', '·СиЗд»', 6000.00, 'Veneer (Ceramic)', 'а¤ЕЧНєїС№а«ГТБФ¤', 'Cosmetic Dentistry'),
(147, 'B106', '·СиЗд»', 4000.00, 'Vitallium Partial Denture (Lower)', 'їС№»ЕНБв¤Г§вЕЛРЄ№Фґ¶Нґдґй', 'Removable Prosthodontics'),
(148, 'B107', '·СиЗд»', 4000.00, 'Vitallium Partial Denture (Upper)', 'їС№»ЕНБв¤Г§вЕЛРЄ№Фґ¶Нґдґй', 'Removable Prosthodontics'),
(149, 'B108', '·СиЗд»', 100.00, 'X-Ray Periapical', 'аНзЎ«аГВмїС№', 'X-ray'),
(150, 'B109', '·СиЗд»', 150.00, 'ВТКХїС№ Butler Sensitive', 'ВТКХїС№', 'Merchandise');


-- 
-- в¤Г§КГйТ§µТГТ§ `dentis_tb`
-- 

CREATE TABLE `dentis_tb` (
  `Dentis_code` int(2) NOT NULL auto_increment,
  `Person_code` tinyint(5) NOT NULL default '0',
  `Class` varchar(100) NOT NULL default '',
  `Orderlist` varchar(5) NOT NULL default '0',
  `Dental_code` tinyint(6) NOT NULL default '0',
  `First_name` varchar(30) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Lastname` varchar(100) NOT NULL default '',
  `Sex` varchar(10) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Religion` varchar(30) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Name_eng` varchar(155) NOT NULL default '',
  `Lastname_eng` varchar(155) NOT NULL default '',
  `ProvinceId` int(2) unsigned NOT NULL default '0',
  `Phone_1` varchar(10) NOT NULL default '',
  `Phone_2` varchar(10) NOT NULL default '',
  `Email` varchar(155) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Datetype` date NOT NULL default '0000-00-00',
  `Panal_code` tinyint(5) NOT NULL default '0',
  `Year_1` varchar(5) NOT NULL default '00000',
  `Flag` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`Dentis_code`,`Dental_code`),
  UNIQUE KEY `code` (`Dentis_code`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=tis620 AUTO_INCREMENT=46 ;

-- 
-- dump µТГТ§ `dentis_tb`
-- 

INSERT INTO `dentis_tb` (`Dentis_code`, `Person_code`, `Class`, `Orderlist`, `Dental_code`, `First_name`, `Name`, `Lastname`, `Sex`, `DateBirth`, `Religion`, `Address`, `Img1`, `Name_eng`, `Lastname_eng`, `ProvinceId`, `Phone_1`, `Phone_2`, `Email`, `Description_1`, `Description_2`, `Datetype`, `Panal_code`, `Year_1`, `Flag`) VALUES (37, 0, '', '·2241', 0, '·ѕ.', 'дЗ·Вм', 'єШ­ЗФ·ВТ', 'ЄТВ', '2548-05-01', 'ѕШ·ё', '25/35 Б 4 ц єТ§·ГТВ', '../images/481740.JPG', 'wai', '  boon', 0, '038-286282', '01-5656539', 'chokchai@sriracha.com', 'ЁШМТЕ§ЎГімБЛТЗФ·ВТЕСВ', 'ЁСґїС№', '2525-04-27', 0, '2525', 0);

-- 
-- в¤Г§КГйТ§µТГТ§ `descriptionplan_tb`
-- 

CREATE TABLE `descriptionplan_tb` (
  `Code` int(6) NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=tis620 AUTO_INCREMENT=55 ;

-- 
-- dump µТГТ§ `descriptionplan_tb`
-- 

INSERT INTO `descriptionplan_tb` (`Code`, `Code_id`, `Description_1`, `Description_2`, `Description_3`) VALUES (36, 'A006', '¤ГХБ·ТбјЕг№ЄиН§»ТЎ', '', ''),
(35, 'A005', '¤ГНєїС№', '', ''),
(34, 'A004', '¤ГНєїС№ЄСиЗ¤ГТЗ', '', ''),
(30, 'A001', 'ўСґїС№', '', ''),
(31, 'A002', 'ўСґЗСКґШНШґїС№', '', ''),
(32, 'A003', 'ўЩґЛФ№»Щ№бЕРўСґїС№', '', ''),
(37, 'A007', 'а¤ЕЧНєїЕЩННдГґм', '', ''),
(38, 'A008', 'а¤ЕЧНєїС№', '', ''),
(39, 'A009', '«иНБїС№»ЕНБ', '', ''),
(40, 'A010', 'ґЩНТЎТГ', '', ''),
(41, 'A011', 'аґЧНВїС№', '', ''),
(42, 'A012', 'µГЗЁКШўАТѕЄиН§»ТЎ', '', ''),
(43, 'A013', 'µСґдЛБ', '', ''),
(44, 'A014', 'µФґ¤ГНєїС№ЄСиЗ¤ГТЗ', '', ''),
(45, 'A015', 'µФґ¤ГНєїС№¶ТЗГ', '', ''),
(46, 'A016', '¶Н№їС№', '', ''),
(47, 'A017', '¶Н№їС№¤Шґ', '', ''),
(48, 'A018', '¶Тґ«ФЕФ⤹ЎС№їС№ЎГРб·Ў', '', ''),
(49, 'A019', '¶ТґїНЎКХїС№', '', ''),
(50, 'A020', '·УаўХйВЗ', '', ''),
(51, 'A021', '№йУВТєйЗ№»ТЎ¦иТаЄЧйНвГ¤', '', ''),
(52, 'A022', 'аєзґаµЕзґ', '', ''),
(53, 'A023', 'ј№ЦЎЛЕШБГиН§їС№', '', '');
-- 
-- в¤Г§КГйТ§µТГТ§ `diagnosis_tb`
-- 

CREATE TABLE `diagnosis_tb` (
  `Code` tinyint(3) unsigned zerofill NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=tis620 AUTO_INCREMENT=67 ;

-- 
-- dump µТГТ§ `diagnosis_tb`
-- 

INSERT INTO `diagnosis_tb` (`Code`, `Code_id`, `Description_1`, `Description_2`, `Description_3`) VALUES (034, '001', 'Acute apical abscess', '', ''),
(035, '002', 'Acute apical periodontitis(AAP)', '', ''),
(036, '003', 'Acute Gingivitis', '', ''),
(037, '004', 'Alveolitis', '', ''),
(038, '005', 'Apical Cyst', '', ''),
(039, '006', 'Apical Granuloma', '', ''),
(040, '007', 'Asymptomatic pulpitis', '', ''),
(041, '008', 'Bruxism', '', ''),
(042, '009', 'Cervical Abrasion', '', ''),
(043, '010', 'Cervical Attrition', '', ''),
(044, '011', 'Cervical Erosion', '', ''),
(045, '012', 'Chronic apical abscess(CAA)', '', ''),
(046, '013', 'Chronic apical periodontitis(CAP)', '', ''),
(047, '014', 'Chronic Gingivitis', '', ''),
(048, '014', 'Condensing osteitis', '', ''),
(049, '016', 'Dental Caries', '', ''),
(050, '017', 'Denture Fracture', '', ''),
(051, '018', 'Diastema', '', ''),
(052, '019', 'Discolored Tooth', '', ''),
(053, '020', 'Dislodge of Bridge', '', ''),
(054, '021', 'Dislodge of Crown', '', ''),
(055, '022', 'Dislodge of filling', '', ''),
(056, '023', 'Dislodge of Inlay', '', ''),
(058, '024', 'Dislodge of Onlay', '', ''),
(059, '025', 'Edentulous', '', ''),
(060, '026', 'Fluorosis', '', ''),
(061, '027', 'Gingival Recession', '', ''),
(062, '028', 'Horizontal Impaction', '', ''),
(063, '029', 'Incomplete Root Canal Treatment', '', ''),
(064, '030', 'Mesio-Angular Impaction', '', ''),
(065, '031', 'Mild Gingivitis', '', '');

-- 
-- в¤Г§КГйТ§µТГТ§ `teachplan_tb`
-- 

CREATE TABLE `teachplan_tb` (
  `Teach_id` int(4) unsigned NOT NULL auto_increment,
  `HN_code` varchar(10) NOT NULL default '0',
  `No_code` int(7) NOT NULL default '0',
  `Person_code` int(5) unsigned zerofill NOT NULL default '00000',
  `Tooth_code` int(2) NOT NULL default '0',
  `Teach1` varchar(50) NOT NULL default '',
  `Teach2` varchar(50) NOT NULL default '',
  `Teach3` varchar(50) NOT NULL default '',
  `Teach4` varchar(50) NOT NULL default '',
  `Teach5` varchar(50) NOT NULL default '',
  `Teach6` varchar(50) NOT NULL default '',
  `Teach7` varchar(50) NOT NULL default '',
  `Teach8` varchar(50) NOT NULL default '',
  `Teach9` varchar(50) NOT NULL default '',
  `Teach10` varchar(50) NOT NULL default '',
  `Teach11` varchar(50) NOT NULL default '',
  `Teach12` varchar(50) NOT NULL default '',
  `Teach13` varchar(50) NOT NULL default '',
  `Teach_13` varchar(255) NOT NULL default '',
  `Tooth_code1` int(2) unsigned NOT NULL default '0',
  `Tooth_code3` int(2) unsigned NOT NULL default '0',
  `Tooth_code4` int(2) unsigned NOT NULL default '0',
  `Tooth_code5` int(2) unsigned NOT NULL default '0',
  `Tooth_code6` int(2) unsigned NOT NULL default '0',
  `Tooth_code7` int(2) unsigned NOT NULL default '0',
  `Tooth_code8` int(2) unsigned NOT NULL default '0',
  `Tooth_code11` int(2) unsigned NOT NULL default '0',
  `Tooth_code12` int(2) unsigned NOT NULL default '0',
  `Religion` varchar(50) NOT NULL default '',
  `Code` int(3) NOT NULL default '0',
  `Date_1` date NOT NULL default '0000-00-00',
  `Date` date NOT NULL default '0000-00-00',
  `Time_in` time NOT NULL default '00:00:00',
  `Time_out` time NOT NULL default '00:00:00',
  `Time` time NOT NULL default '00:00:00',
  `Teach_code` int(3) unsigned zerofill NOT NULL default '000',
  `Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
  `Flag` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Teach_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=tis620 AUTO_INCREMENT=14 ;

-- 
-- dump µТГТ§ `teachplan_tb`
-- 

INSERT INTO `teachplan_tb` (`Teach_id`, `HN_code`, `No_code`, `Person_code`, `Tooth_code`, `Teach1`, `Teach2`, `Teach3`, `Teach4`, `Teach5`, `Teach6`, `Teach7`, `Teach8`, `Teach9`, `Teach10`, `Teach11`, `Teach12`, `Teach13`, `Teach_13`, `Tooth_code1`, `Tooth_code3`, `Tooth_code4`, `Tooth_code5`, `Tooth_code6`, `Tooth_code7`, `Tooth_code8`, `Tooth_code11`, `Tooth_code12`, `Religion`, `Code`, `Date_1`, `Date`, `Time_in`, `Time_out`, `Time`, `Teach_code`, `Teacher_code`, `Flag`) VALUES (8, '491774', 0, 00032, 0, '', '', '', '', '\r\n', '', '', '', '', '', '', '', '', '', 13, 0, 0, 0, 0, 0, 0, 0, 0, '1 аґЧН№', 0, '2549-05-01', '2549-05-01', '00:00:12', '00:00:12', '00:00:12', 000, 00058, 0),
(10, '491774', 0, 00032, 0, 'X-ray', 'Scaling', 'tooth Bleaching', '', '\n RCT', 'Extraction', 'Surcigal Removal', 'Temporary Plate', '', '', '', '', 'Other TxPlan', '222', 2, 2, 2, 2, 2, 2, 2, 2, 2, '3 аґЧН№', 0, '2550-02-14', '2550-05-15', '00:00:12', '00:00:12', '00:00:12', 000, 00058, 0),
(11, '491774', 0, 00032, 0, '', '', '', '', '\n', '', '', '', '', '', '', '', '', '2222', 2, 2, 2, 2, 2, 2, 2, 2, 2, '6 аґЧН№', 0, '2550-06-23', '2549-05-01', '00:00:12', '00:00:12', '00:00:12', 000, 00058, 0);