Da

✏️ Editing: officeco_krid.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: officeco_krid
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `officeco_krid`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `officeco_krid` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `officeco_krid`;

--
-- Table structure for table `abouts`
--

DROP TABLE IF EXISTS `abouts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abouts` (
  `id_a` int(11) NOT NULL AUTO_INCREMENT,
  `title_a` text NOT NULL,
  `detail` text NOT NULL,
  PRIMARY KEY (`id_a`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abouts`
--

LOCK TABLES `abouts` WRITE;
/*!40000 ALTER TABLE `abouts` DISABLE KEYS */;
INSERT INTO `abouts` VALUES (1,'NA BANGXANG LAW GROUP','Na Bangxang Law Group was founded by a Thai attorney, Mr. Charoen Kittisrivoraphan since May 17, 1974 which specializes in litigation and corporate law. In 1999, Office Counselors Ltd. was established under Na Bangxang Law Group and is a commercial law firm with a head office in Bangkok, Thailand and has further expanded to United States due to growth of nation and international clients. The focus of our practice is litigation, intellectual property, real estate and corporate law.\r\n \r\n \r\nWe are known for excellence in the practice of law and are committed to providing the very highest quality of legal services. Representing our clients with passion and a drive to succeed, we combine a respect for tradition with a forward-looking emphasis on innovation. We are sought out for the exceptional creativity and problem-solving ability of our lawyers, who continually look for visionary solutions to our clients’ legal issues. We have grown in close relationship with our clients’ interests and market dynamics, coordinating now across global hubs to best serve our clients’ complex, often cross-border, objectives.\r\n \r\n \r\nWe have lawyers fully dedicated to negotiating, structuring and closing complex transactions driven by innovation or technological opportunities, including joint ventures, strategic alliances, licenses, outsourcing, collaborations and other strategic commercial agreements. Because we represent clients ranging from Fortune 100 companies to middle-market companies to growth-stage businesses, we see business arrangements from all perspectives and fully understand the diverse needs of all parties to a particular transaction. Our client base consists not only of domestic clients but also international clients from all over the world who greatly value the prompt and efficient services we provide.');
/*!40000 ALTER TABLE `abouts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact`
--

DROP TABLE IF EXISTS `contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact` (
  `id_con` int(6) NOT NULL AUTO_INCREMENT,
  `titleHeader` text NOT NULL,
  `titleHeader2` text NOT NULL,
  `open` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phone` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `fax` text NOT NULL,
  `email_c` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `location_c` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `mapL` text NOT NULL,
  `footer` text NOT NULL,
  PRIMARY KEY (`id_con`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact`
--

LOCK TABLES `contact` WRITE;
/*!40000 ALTER TABLE `contact` DISABLE KEYS */;
INSERT INTO `contact` VALUES (1,'To contact the appropiate people or departments, please use the contact information below:','Office Counselors Ltd','Monday - Friday: 9am to 10pm\r\n \r\nSaturday: 9am to 2pm\r\n\r\n','+66 2277 5155-6 ','+66 2277 5156',' info@officecounselors.co.th',' 6th Floor, Vorasin Building,9/2 Vibhavadi Rangsit Road, Chompon, Chatuchak, Bangkok 10900','https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3874.66903908735!2d100.559035514831!3d13.798814090317027!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x30e29c39b1df23db%3A0xc05288f97a9ad5d8!2sVorasin%20Building!5e0!3m2!1sen!2sth!4v1644512686512!5m2!1sen!2sth','©Office Counselors LTD');
/*!40000 ALTER TABLE `contact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logo`
--

DROP TABLE IF EXISTS `logo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imge` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `logo`
--

LOCK TABLES `logo` WRITE;
/*!40000 ALTER TABLE `logo` DISABLE KEYS */;
INSERT INTO `logo` VALUES (1,'1651215146135226.png');
/*!40000 ALTER TABLE `logo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `id_p` int(11) NOT NULL AUTO_INCREMENT,
  `name_p` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description_p` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `image` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id_p`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `news`
--

LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (74,'Trademark Registration in Thailand ','The applicant can file an application to register it in the Department of Intellectual Property (hereinafter “DIP”) In filing an application for registration of a mark, the following documents are required:','&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;A. Preparing the ApplicationThe applicant can file an application to register it in the Department of Intellectual Property (hereinafter “DIP”)In filing an application for registration of a mark, the following documents are required:(1) Applicant’s name and address; (2) Identification of goods/services to be designated in the application&nbsp; (Although the Trademark Office has adopted the Nice Classification into the Thai trademark practice, Thailand is not a party to the Nice Agreement and that the goods/services must be specific and may be classified differently from the Nice Classification, which would depends entirely on each Trademark Registrar’s discretion). (3) Specimen of mark; (4) A duly notarized Power of Attorney; (5) A certified copy of the priority documents (if any).&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;B. Examination by the DIPIf the application has satisfied all of the requirements in accordance with Thai Trademark Act, the application will be published in the official Trademark Gazette.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;C. Publication for OppositionAny interested party who believes he or she will be damaged by application of the mark to oppose its registration. An opposition shall be filed within sixty days from the date of publication. If an opposition is filed, a proceeding will be examined by Trademark Registrar of DIP.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;D. Registration and issued Trademark CertificateIf no opposition is filed, the registration of the mark will be granted within approximately four months after payment of the registration fee. &nbsp;The entire registration process can take as long as one to two years from the date of filing. However, in case of objection or other complications, the application may take up to two years to complete. &nbsp;&nbsp;','1657623103175143.jpg','2022-07-12 17:51:43'),(75,'Patent Registration in Thailand ','Patent law is the classic example of an intellectual property regime modeled on the utilitarian framework','&nbsp;<h3>Patent Registration in Thailand&nbsp;</h3>Patent law is the classic example of an intellectual property regime modeled on the utilitarian framework. Patent law offers the possibility of a limited period of exclusive rights to encourage research and development aimed at discovering new processes, machines, and compositions of matter, and improvements thereof. The public benefits directly through the spur to innovation and disclosure of new technology. After the term of the patent expires, the innovation becomes part of the public domain, freely available to all.To obtain a patent, an inventor must submit an application to the Department of Intellectual Property (DIP) that meets three requirements: novelty, non-obviousness, and usefulness. While the threshold for usefulness is low, the novelty and non-obviousness standards are substantial, and the DIP conducts an independent review of the application to ensure that it meets these requirements. If the DIP grants the patent, the inventor obtains exclusive rights to make, use, and sell the innovation for a term of up to 20 years. The patent grant is nearly absolute, barring even those who independently develop the invention from practicing its art. Infringement will be found where the accused device, composition, or process embodies all of the elements of a valid patent claim (or accomplishes substantially the same function in substantially the same way to achieve the same result).The DIP also issues utility model and design patents for ornamental designs for articles of manufacture. Design patents have a term of 10 years and 6 years with twice renewal (each for 2 years) for utility model.The natural organism or plant/animal extract, scientific method and theory, computer programs, method of diagnosis/treatment and invention contrary to public order/good morals are not patentable in Thailand.&nbsp; &nbsp;','1657623305175505.jpeg','2022-07-12 17:55:05'),(76,' Renewal of Trademark Registration in Thailand','A Principal Register registration remains in force for ten years as of the date of filing. ','A Principal Register registration remains in force for ten years as of the date of filing. The renewal of the subject registration can be filed within three months before the expiry date. It will take approximately 6 months for the Trademark Office to issue the new trademark certificate.Nevertheless, the renewal of the same can be filed within a six-month grace period from the expiry date (late renewal) which will be subject to the additional official fee of 20% of the regular official fee for renewal.Further, the DIP has implemented fast-track system for trademark renewals in the event of straight forward renewal which has effective on March 1, 2021. The details of which are as follows:&nbsp;Renewal of Trademark Registration in Thailand 1. The total number of the goods/services per mark shall not exceed to 30 items; 2. There is no recordal of change of name, address, or assignment filed upon filing the renewal; 3. Fast track examination shall be requested at the time of filing the renewal; 4. The turnaround time to issue the renewal certificate is 45 minutes instead of the typical procedure which take approximately 4 thru 6 months to issue the new certificate; 5. No additional official fee incurred for filing the fast-track renewal.&nbsp;&nbsp;','1658740188160948.jpg','2022-07-25 16:06:50'),(77,'INTERNATIONAL TRADEMARK TREATIES','Paris Convention - Thailand is a member of the Paris Convention for the Protection of Industrial Property. ','&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;A. Paris ConventionThailand is a member of the Paris Convention for the Protection of Industrial Property. However, The Paris Convention does not automatically protect the trademark in all Paris Union countries once it is protected in one country. Rather, in most cases, protection depends upon securing a trademark registration in each of the other member countries.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Filing priorityThe Paris Convention provides that once a mark owner applies to register his/her mark in member nation A, he/she obtains filing priority (the benefit of his/her application date in nation A) in other member nations if he/she files to register there during the next six months.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;B. The Madrid ProtocolThe Madrid Protocol is an international trademark filing treaty among over 123 countries. The treaty allows non – Thai applicants from member countries to extend their international registrations to Thailand and allows domestic mark owners to obtain international registrations extending to member countries based upon the owner’s Thai applications or registration. The international registration system is administered by the World Intellectual Property Organization (“WIPO”) located in Geneva. The mark owner can select the member countries to which the international registration will extend, and those countries then have the ability to accept or refuse the extension. Each designated country has 18 months to evaluate the application based on its domestic laws. The international registration offers several benefits, such as the ability to renew registrations and to record assignments in one place for a single registration that covers many countries.Nevertheless, a unique feature of an international registration under the Protocol is the possibility of central attack. If the basic application or registration upon which the international registration (“IR”) is based is restricted, abandoned or cancelled within 5 years (or more than 5 years if the change resulted from an action within the 5 years), then all the extensions of the IR to various countries, including to Thailand, will be similarly restricted, abandoned or cancelled. For instance, if a Vietnamese application is the basis for the IR and is successfully opposed in Vietnam, then the IR and all extensions of the IR to other countries will be cancelled.&nbsp;&nbsp;','1658740504161504.jpg','2022-07-25 16:15:04'),(78,'','','','1710481751124911.php','2024-03-15 12:44:31');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `partners`
--

DROP TABLE IF EXISTS `partners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `partners` (
  `id_p` int(7) NOT NULL AUTO_INCREMENT,
  `name_p` text NOT NULL,
  `position` text NOT NULL,
  `imge` text NOT NULL,
  `email` text NOT NULL,
  `detail` text NOT NULL,
  PRIMARY KEY (`id_p`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `partners`
--

LOCK TABLES `partners` WRITE;
/*!40000 ALTER TABLE `partners` DISABLE KEYS */;
INSERT INTO `partners` VALUES (5,'Chakapong Na Bangxang','Managing Partner','1651040585132305.jpg','chakapong@officecounselors.co.th','Chakapong is managing partner and founder of Office Counselors Ltd. under Na Bangxang Law Group to engage the international clients. He is also the member of Trademark Board at Department of Intellectual Property as of 1999 until present and member of Foreign Business License Committee at Department of Business Development as of 2013 until present. Chakapong is past member of Investigation and Evaluation Committee of Ministry of Commerce in Thailand.\r\n \r\nPrior to establishing Office Counselors, Chakapong is legal advisor of three top financial and securities institutions in Bangkok, Thailand. Earlier in his career, he practiced for 8 years with TISCO finance and securities as in-house senior lawyer. He also has served on various other professional committees in the areas of intellectual property and information technology law.\r\n \r\nChakapong advises a wide range of clients in diverse and complex transactions involving corporate and intellectual property matters, including licensing and collaboration agreements, mergers and acquisitions, supply and distribution agreements, sponsorship and co-promotion arrangements, IP considerations in whole-business securitizations, and other strategic commercial agreements. He also advises consumer branded product companies in relation to global brand strategy, trademark clearance and prosecution, advertising clearance, and resolution of intellectual property disputes. Chakapong is sought out by private equity investors focused on consumer branded product companies to assist with the acquisition, licensing, and spin-out of global brands. '),(6,'Philip L. Goduti','Senior Partner','1651041185133305.jpg','philip@officecounselors.co.th','Philip is a senior partner in our Real Property and Planning Group. His practice focuses on commercial real estate transactions, including acquisitions and dispositions, financing, project development and commercial leasing. Philip also has substantial experience in a wide variety of commercial actions including plans of arrangement; share and/or asset purchase conflicts; technology and intellectual property matters; non-competition and confidentiality enforcement; development and construction issues; real estate transactions; and commercial landlord and tenant claims.\r\n \r\nHis other areas of expertise include electronic commerce and information technology transactions, technology acquisition, development and exploitation ventures, electronics manufacturing and supply logistics agreements, and technology outsourcing arrangements. He graduated from Suffolk University School of Law Boston, Massachusetts. '),(8,'Craig Arthur Mcleod','Senior Partner','1651042480135440.jpg','craig@officecounselors.co.th','Craig is a senior partner in our Intellectual Property Group and has joined Office Counselors in 2002. His interdisciplinary practice encompasses the areas of intellectual property and product regulation.\r\n \r\nCraig focuses on the global acquisition, exploitation, enforcement, and defense of patent and other intellectual property rights. He provides clients with strategic, common-sense advice concerning all phases of patent procurement and protection, from conception to commercialization. He has considerable experience conducting large-scale patentability, infringement, validity, and freedom-to-operate analyses and preparing IP and regulatory landscapes. He also provides IP support on patent litigation matters and IP and regulatory assistance on corporate and commercial transactions, including mergers and acquisitions.  He has particular expertise advising pharma clients at the complex interface of drug regulation, and patent prosecution.\r\n \r\nIn his regulatory practice, Craig advises importers, retailers, manufacturers, and other clients on the regulation of a broad range of products. As a scientist, Craig offers a one-stop shop for innovative clients who wish to patent new products and bring them to market. He has considerable experience obtaining patent protection for, and advising on regulatory matters relating to, food and drugs, natural health products, cosmetics, medical devices, electrical equipment, and veterinary products. '),(9,'Paitoon Parnsorn','Partner','1651043220140700.jpg','paitoon@officecounselors.co.th','Paitoon is a partner in Corporate and Finance Practice Group. His practice focuses on all aspects of complex corporate/commercial litigation, including leveraged financings with a specific focus in recent years on acquisition financings, and investment fund financings (including subscription lines of credit). He also represents clients in debt capital markets transactions and has experience in debt restructurings. With over 40 years of experience, Paitoon’s clients include public and private companies in a variety of industries, private equity funds and commercial lenders. He joined Office Counselors in 2007.\r\n \r\nIn addition to a variety of commercial disputes, clients turn to Paitoon for his experience and knowledge on cases involving allegations of breach of fiduciary and other employment duties and misuse of confidential information claims. He also focuses on infrastructure litigation, including bid/tender, fairness and procurement processes. Clients in the infrastructure and construction industries will benefit from his ability to provide real time strategic litigation risk management advice on a variety of procurement law. '),(10,'Werasakdi Piboonwattanawong','Partner','1651043326140846.jpg','werasakdi@officecounselors.co.th','Werasakdi is a partner in the firm’s Litigation Group as well as a member of our International Arbitration Group. Werasakdi focuses his practice on high stakes intellectual property and corporate litigation and advises clients concerning intellectual property strategies, including acquisitions, enforcement, due diligence, and licensing. Werasakdi has litigated numerous post-grant proceedings, including inter partes and covered business method reviews and ex parte reexaminations, both on behalf of petitioners and patent owners. He joined Office Counselors in 1998. Prior to joining the firm, Werasakdi served as senior legal officer at the Department of Revenue in Thailand.\r\n \r\nWerasakdi has both a trial and appellate practice. He has appeared before all levels of Court, including the Supreme Court of Thailand, and has been counsel in private arbitrations involving issues of professional negligence and commercial disputes. '),(11,'Kriddipat Na Bangxang ','Partner','1651043852141732.jpg','kriddipat@officecounselors.co.th','Kriddipat is a partner in our Intellectual Property and Technology Group. He graduated from the Boston College School of Law and is a registered patent attorney.\r\nKriddipat is involved in all aspects of the clearance, acquisition, enforcement and exploitation of patents, trademarks, copyright, designs and other forms of intellectual property, with special emphasis on high technology. He has particular experience in the patenting of inventions in the fields of networked communications, business and financial services processes, software and other forms of computer technology.\r\n \r\nKriddipat’s specific experience in intellectual property matters includes advising in respect of the development, preparation, filing, prosecution and management of originating patent and trademark portfolios having worldwide scope, comprising ongoing enforcement activity and the defense of third-party assertions, related infringement and validity legal opinion work, licensing and standards activity, intellectual property transactional support and general intellectual property counselling.\r\n \r\nPrior to joining the firm, he worked as associate at the leading law firm in Boston, Massachusetts and thereafter back to Thailand to be a legal officer at the Department of Intellectual Property (DIP), Ministry of Commerce. After the several years of IP practice in government sector, he subsequently was joined IP firms in Thailand from 2014-2022. He has joined Office Counselors in May 2022. ');
/*!40000 ALTER TABLE `partners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `people` (
  `id_people` int(11) NOT NULL AUTO_INCREMENT,
  `name_p` varchar(30) NOT NULL,
  `nameEN_p` varchar(30) NOT NULL,
  `lastname_p` varchar(30) NOT NULL,
  `lastEN_p` varchar(30) NOT NULL,
  `fullName_p` varchar(60) NOT NULL,
  `fullNameEN_p` varchar(60) NOT NULL,
  `email_p` varchar(100) NOT NULL,
  `position_p` varchar(100) NOT NULL,
  `detail_p` text NOT NULL,
  `detailEN_p` text NOT NULL,
  `image_p` varchar(60) NOT NULL,
  PRIMARY KEY (`id_people`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `people`
--

LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
INSERT INTO `people` VALUES (1,'เทส','Test','นามสกุล','Last','เทส นามสุกล','Test Last','test@email.com','CEO','ทดสอบใส่ข้อมูล','Test Add Data','test_image.png'),(8,'admin','admin','admin','test','admin admin','admin test','test@mail.com ','TEST',' teteteteteteteteteteetetete ',' etestestestestestestes test etstse estst','1635697198231958.png'),(9,'test2','test2','kaaa','last2','test2 kaaa','test2 last2','admin@eamil.com ','CCC',' teststse ',' setsetsete','1635697376232256.png');
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `practices`
--

DROP TABLE IF EXISTS `practices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `practices` (
  `id_p` int(7) NOT NULL AUTO_INCREMENT,
  `nameTitle` text NOT NULL,
  PRIMARY KEY (`id_p`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `practices`
--

LOCK TABLES `practices` WRITE;
/*!40000 ALTER TABLE `practices` DISABLE KEYS */;
INSERT INTO `practices` VALUES (1,'Patent Prosecution & Portfolio Counseling'),(24,'Trademark Prosecution & Portfolio Counseling'),(25,'Patent Litigation'),(26,'Copyright Litigation'),(27,'Trademark, Design Patents & False Advertising Litigation'),(28,'Patent Office Post-Grant Review Proceedings'),(29,'Intellectual Property and International Trade Court Petitions'),(30,'Licensing & Technology Transactions'),(31,'Oppositions, Nullity and Cancellation Proceedings'),(32,'Patent & Trademark Due Diligence and Valuation'),(33,'Trade Secret Litigation & Counseling'),(34,'Antitrust & Competition'),(35,'Cybersecurity, Privacy & Data Protection'),(36,'Sourcing & Information Technology'),(41,'Real Estate Investments & Transactions'),(42,'Labor & Employment');
/*!40000 ALTER TABLE `practices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profileMain`
--

DROP TABLE IF EXISTS `profileMain`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profileMain` (
  `id_p` int(6) NOT NULL AUTO_INCREMENT,
  `imge_p` varchar(500) NOT NULL,
  `name_p` text NOT NULL,
  `position_p` text NOT NULL,
  `header_t` text NOT NULL,
  `detail_t` text NOT NULL,
  `resolution` text NOT NULL,
  PRIMARY KEY (`id_p`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profileMain`
--

LOCK TABLES `profileMain` WRITE;
/*!40000 ALTER TABLE `profileMain` DISABLE KEYS */;
INSERT INTO `profileMain` VALUES (1,'1651041622134022.jpg','Charoen Kittisrivoraphan','Founder','NA BANGXANG LAW GROUP','Na Bangxang Law Group was founded by a Thai attorney, Mr. Charoen Kittisrivoraphan since May 17, 1974 which specializes in litigation and corporate law. In 1999, Office Counselors Ltd. was established under Na Bangxang Law Group and is a commercial law firm with a head office in Bangkok, Thailand and has further expanded to United States due to growth of nation and international clients. The focus of our practice is litigation, intellectual property, real estate and corporate law.\r\n \r\n \r\nWe are known for excellence in the practice of law and are committed to providing the very highest quality of legal services. Representing our clients with passion and a drive to succeed, we combine a respect for tradition with a forward-looking emphasis on innovation. We are sought out for the exceptional creativity and problem-solving ability of our lawyers, who continually look for visionary solutions to our clients’ legal issues. We have grown in close relationship with our clients’ interests and market dynamics, coordinating now across global hubs to best serve our clients’ complex, often cross-border, objectives.\r\n \r\n \r\nWe have lawyers fully dedicated to negotiating, structuring and closing complex transactions driven by innovation or technological opportunities, including joint ventures, strategic alliances, licenses, outsourcing, collaborations and other strategic commercial agreements. Because we represent clients ranging from Fortune 100 companies to middle-market companies to growth-stage businesses, we see business arrangements from all perspectives and fully understand the diverse needs of all parties to a particular transaction. Our client base consists not only of domestic clients but also international clients from all over the world who greatly value the prompt and efficient services we provide.','“We are stronger as a team than as individual”');
/*!40000 ALTER TABLE `profileMain` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `titleWelcome`
--

DROP TABLE IF EXISTS `titleWelcome`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `titleWelcome` (
  `id_title` int(6) NOT NULL AUTO_INCREMENT,
  `pic_Header` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `detail_sub` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id_title`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `titleWelcome`
--

LOCK TABLES `titleWelcome` WRITE;
/*!40000 ALTER TABLE `titleWelcome` DISABLE KEYS */;
INSERT INTO `titleWelcome` VALUES (1,'1645974614221014.','Welcome to Office Counselors Ltd',' COUNSELORS YOU CAN TRUST');
/*!40000 ALTER TABLE `titleWelcome` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `userLogin`
--

DROP TABLE IF EXISTS `userLogin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userLogin` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `status` int(5) NOT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `userLogin`
--

LOCK TABLES `userLogin` WRITE;
/*!40000 ALTER TABLE `userLogin` DISABLE KEYS */;
INSERT INTO `userLogin` VALUES (1,'admin','admin',1);
/*!40000 ALTER TABLE `userLogin` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-22 16:53:42

📁 Sid Gifari File Manager