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)

/home/   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:     2_script_eopbri.sql (1.88 KB)      -rw-r--r--

-- DB eopbri
use eopbri;
-- table department 	
ALTER TABLE `Department` ADD `attachFile` CHAR( 1 ) NOT NULL ;

-- table DocReceiveSend
ALTER TABLE `DocReceiveSend` ADD `DrsNoRegisReceive` CHAR( 1 ) NOT NULL ;	

-- table DocSecretLevel
ALTER TABLE `DocSecretLevel` ADD `THeGIF_CID` CHAR( 3 ) NOT NULL ;
TRUNCATE TABLE `DocSecretLevel`;
INSERT INTO `DocSecretLevel` (`DclID`, `DclName`, `THeGIF_CID`) VALUES 
(0, '»ЎµФ', '001'),
(1, 'ЕСє', '002'),
(2, 'ЕСєБТЎ', '003'),
(3, 'ЕСє·ХиКШґ', '004'),
(4, '»Ў»Фґ', '');

-- table DocSpeedLevel  
ALTER TABLE `DocSpeedLevel` ADD `THeGIF_SID` CHAR( 3 ) NOT NULL ;
TRUNCATE TABLE `DocSpeedLevel`;
INSERT INTO `DocSpeedLevel` (`DslID`, `DslName`, `THeGIF_SID`) VALUES 
(0, '»ЎµФ', '001'),
(1, 'ґиЗ№', '002'),
(2, 'ґиЗ№БТЎ', '003'),
(3, 'ґиЗ№·ХиКШґ', '004');

-- table Documents 
ALTER TABLE `Documents` ADD `Doc_Letter_ID` INT( 11 ) NOT NULL ;


-- table SysConfig 
ALTER TABLE `SysConfig` ADD `canDelDocPs` CHAR( 1 ) NOT NULL ,
ADD `useTHeGIF` CHAR( 1 ) NOT NULL ;	
update `SysConfig`  set useTHeGIF ='N';

-- table collegedetail
ALTER TABLE `collegedetail` ADD `pdId` INT NOT NULL;
update `collegedetail` set pdId='1' WHERE `collegeID`='99';

-- table collegedetail
ALTER TABLE `DocAttatches` CHANGE `DocID` `DocID` BIGINT( 11 ) NOT NULL DEFAULT '0' ;


-- table Department
update Department a, Department b
set a.deptParent = b.deptParentId
where a.deptId = b.deptId;

-- table collegedetail
INSERT INTO `collegedetail` (`cID`, `collegeID`, `collegeName`, `collegeAbbr`, `collegeHost`, `collegeType`, `collegeqCID`, `collegecUID`, `pdId`) VALUES
(39, '41', 'ЗФ·ВТЕСВѕВТєТЕєГБГТЄЄ№№Х бѕГи', 'Зѕє. бѕГи', '110.77.140.204', 'Y', 3, 2, 0);


CREATE TABLE IF NOT EXISTS `correspondenceletter_department` (
  `dm_ID` char(10) NOT NULL,
  `dm_department` text NOT NULL,
  `dmUse` char(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

bool(false)