DOWNLOAD CODE -PHP Project – Employee management system
PHP Project – Advocate office management system
In the legal services sector, staying innovative is crucial to maintain a competitive edge. The Online Lawyer Management System, developed using PHP and MySQL, offers a platform that revolutionizes the connection between legal professionals and clients. The growing demand for free law practice management software has made it easier for law firms to streamline their operations at no cost. Open-source software, in particular, is highly versatile, allowing law firms to customize it according to their unique needs without paying licensing fees.
Free Legal Practice Management Software: Features and Benefits
Free legal practice management software caters to solo practitioners and small law firms, offering a comprehensive suite of features. These include:
- Case Management
- Client Communication
- Billing and Invoicing
- Document Management
- Time Tracking
These tools help law firms improve productivity and simplify processes without the financial strain of proprietary software.
Key Features of the Online Lawyer Management System
The Online Lawyer Management System offers advanced features that enhance both efficiency and user experience in legal practices. Here are the key features:
- Client Management
The system helps manage client information effortlessly. Clients can register their cases, track progress, and stay informed through easy-to-use dashboards. - Case Stage Tracking
Keep track of each case’s status in real time, from the initial consultation to its resolution, ensuring both clients and legal professionals are on the same page. - Legal Acts Integration
The system integrates a vast repository of legal acts, giving lawyers quick access to relevant legislation, which aids in thorough research and accurate representation. - Case Registration
Clients can easily register their cases online, streamlining the process for everything from personal injury claims to corporate litigation. - Comprehensive Reporting Tools
The system allows users to generate detailed reports on various aspects of their practice, helping with data-driven decisions and improving management.
Advantages of Free Legal Document Management Software
For law firms focusing on document workflows, free legal document management software offers a practical and cost-effective solution. Key features include:
- Version Control
- Document Sharing
- Access Control
These features foster collaboration and enhance productivity without the added expense of licensing fees.
Free Legal Matter Management Software
Free legal matter management software equips firms with tools for tracking case details, deadlines, and milestones. Whether for solo practitioners or large firms, these solutions facilitate efficient case management with no significant financial investment.
Optimizing Law Office Operations with Free Software
The availability of free law office management software presents a significant opportunity for law firms to optimize their operations. By leveraging open-source and free legal software solutions, firms can improve efficiency, productivity, and client service while minimizing costs.
Factors to Consider When Choosing Free Law Office Management Software
While selecting free law practice management software, consider the following factors:
- Customization
Many free solutions offer customizable features to meet the specific needs of your firm. - Security
Ensuring the security of sensitive data is vital, and free solutions typically prioritize data protection and compliance with industry standards. - Customer Support
Free solutions often come with solid support systems to help you with any inquiries or technical issues.
FAQs About Free Law Office Management Software
- Can free legal practice management software handle complex case management?
Yes, many free options offer robust case management features suitable for small to medium-sized firms. - Is free law firm software secure for storing sensitive client information?
This source code is designed for academic purposes, but for commercial use, a Pro version is available with added security features. - Can I upgrade to a paid version for additional features?
The lite version is for educational use only, while the Pro version is a commercial version with more features. - How user-friendly are open-source legal practice management software platforms?
Open-source platforms are typically designed to be intuitive, with user-friendly interfaces and comprehensive help resources. - Are there any hidden costs with free legal document management software?
Most free legal software is available at no charge, but these versions are intended for academic purposes only.
How to Run the Free and Open Source Law Practice Management Software
- Download the source code (zip file) and SQL file of the free law office management software.
- Extract the project folder (zip file) related to kortex_lite.
- Copy the project folder to htdocs.
- Open localhost/phpmyadmin and create a database.
- Import the SQL file named kortex_lite.
- Check that the database name is correct in the source code files.
Conclusion
Choosing the right free law firm management software can have a significant impact on your practice’s efficiency and effectiveness. By using these free and open-source solutions, legal professionals can streamline workflows, enhance client service, and improve overall productivity. With the right software, law firms can optimize their operations without the burden of high licensing costs, ultimately leading to more success in the legal field.
index.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <meta name="description" content=""> <meta name="author" content="Mayuri K Freelancer"> <meta name="keywords" content=""> <title>Kortex lite - Advocate office Software</title> <!-- Fonts --> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@300;400;500;700;900&display=swap" rel="stylesheet"> <!-- End fonts --> <!-- core:css --> <link rel="stylesheet" href="assets/vendors/core/core.css"> <!-- endinject --> <!-- Plugin css for this page --> <!-- End plugin css for this page --> <!-- Author Name- Mayuri K. for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com Visit website - www.mayurik.com --> <!-- inject:css --> <link rel="stylesheet" href="assets/fonts/feather-font/css/iconfont.css"> <link rel="stylesheet" href="assets/vendors/flag-icon-css/css/flag-icon.min.css"> <!-- endinject --> <link rel="shortcut icon" href="../assets/images/favicon.png" /> </head> <body> <script> window.location.replace("control/login.php"); </script> <!-- core:js --> <script src="assets/vendors/core/core.js"></script> <!-- endinject --> <!-- Plugin js for this page --> <!-- End plugin js for this page --> <!-- inject:js --> <script src="assets/vendors/feather-icons/feather.min.js"></script> <script src="assets/js/template.js"></script> <!-- endinject --> <!-- Author Name- Mayuri K. for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com Visit website - www.mayurik.com --> </body> </html> |
login.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 |
<?php error_reporting(0); session_start(); include 'connection1.php'; if(isset($_POST['username']) && isset($_POST['password'])){ $username= $_POST['username']; $password= $_POST['password']; $passw = hash('sha256',$password); function createSalt(){ return '2123293dsj2hu2nikhiljdsd'; } $salt = createSalt(); $pass = hash('sha256',$salt.$passw); // echo $pass; //exit; /* <!-- Author Name- Mayuri K. for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com Visit website - www.mayurik.com --> } */ //$plaintext_password = "Password@123"; // The hash of the password that // can be stored in the database // $hash = password_hash($password, // PASSWORD_DEFAULT); // Print the generated hash // echo "Generated hash: ".$hash; //exit; $msg = ''; //exit; $sql_query = "select id, username, password from admin where username= '$username' and password = '$pass' limit 1"; $result = $conn->query($sql_query); if($result->num_rows > 0){ // Storing google recaptcha response // in $recaptcha variable $recaptcha = $_POST['g-recaptcha-response']; // Put secret key here, which we get // from google console $secret_key = '6LcXEiAhAAAAALaf8ygYOebTAENC3QsvAMjXFuuB'; // Hitting request to the URL, Google will // respond with success or error scenario $url = 'https://www.google.com/recaptcha/api/siteverify?secret=' . $secret_key . '&response=' . $recaptcha; // Making request to verify captcha $response = file_get_contents($url); // Response return by google is in // JSON format, so we have to parse // that json $response = json_decode($response); // Checking, if response is true or not $row = $result->fetch_assoc(); if ($response->success == true) { /* echo '<script>alert("Google reCAPTACHA verified")</script>'; */ if($row['username'] == $username && $row['password'] == $pass ){ /* echo "$row[0]"; print_r($row); */ $_SESSION['username'] = $username; $_SESSION['name'] = $name; $_SESSION['id'] =$row['id']; $_SESSION['password']=$password; $_SESSION['photo']=$photo; ?> <div class="popup popup--icon -success js_success-popup popup--visible"> <div class="popup__background"></div> <div class="popup__content"> <h3 class="popup__content__title"> Success </h3> <p>Login Successfully</p> <p> <!-- <a href="index.php"><button class="button button--success" data-for="js_success-popup"></button></a> --> <?php echo "<script>setTimeout(\"location.href = 'dashboard.php';\",1500);</script>"; ?> </p> </div> </div> <!-- <script> window.location="index.php"; </script> --> <?php } else {?> <div class="popup popup--icon -error js_error-popup popup--visible"> <div class="popup__background"></div> <div class="popup__content"> <h3 class="popup__content__title"> Error </h3> <p>Invalid Email or Password</p> <p> <a href="login.php"><button class="button button--error" data-for="js_error-popup">Close</button></a> </p> </div> </div> <!-- <script> // alert("Invalid email or Password!"); window.location="login.php"; </script> --> <?php //// $message = "Invalid email or Password!"; } } else { echo '<script>alert("Please verify Google reCAPTACHA")</script>'; } } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <meta name="description" content=""> <meta name="author" content="Mayuri K Freelancer"> <meta name="keywords" content=""> <title>Kortex lite - Advocate office Software</title> <!-- Fonts --> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@300;400;500;700;900&display=swap" rel="stylesheet"> <!-- End fonts --> <!-- core:css --> <link rel="stylesheet" href="../assets/vendors/core/core.css"> <!-- endinject --> <!-- Plugin css for this page --> <!-- End plugin css for this page --> <!-- inject:css --> <link rel="stylesheet" href="../assets/fonts/feather-font/css/iconfont.css"> <link rel="stylesheet" href="../assets/vendors/flag-icon-css/css/flag-icon.min.css"> <!-- endinject --> <!-- Layout styles --> <link rel="stylesheet" href="../assets/css/demo1/style.css"> <!-- End layout styles --> <link rel="shortcut icon" href="../assets/images/favicon.png" /> <link rel="stylesheet" href="popup_style.css"> <!-- Google reCAPTCHA CDN --> <script src= "https://www.google.com/recaptcha/api.js" async defer></script> </head> <body> <div class="main-wrapper"> <div class="page-wrapper full-page"> <div class="page-content d-flex align-items-center justify-content-center p-0"> <div class="row w-100 mx-0 auth-page"> <div class="col-md-6 login-img p-0"> <img src="../assets/images/login-img.jpg" width="100%" class="vh-100" style="object-fit: cover;"> </div> <div class="col-md-6 bg-white"> <div class="col-md-8 mx-auto"> <div class="auth-form-wrapper px-4 py-7 vh-100"> <img src="assets/images/logo.png" style="height: 135px;padding-top: 10px;"> <form class="forms-sample login-form" method = "post" enctype="multipart/form-data"> <div class="mb-3"> <label for="userEmail" class="form-label">Email address</label> <input type="email" class="form-control" name="username" id="userEmail" placeholder="Email"> </div> <div class="mb-3"> <label for="userPassword" class="form-label">Password</label> <input type="password" class="form-control" name="password" id="userPassword" autocomplete="current-password" placeholder="Password" id="inputField2"> <span toggle="#inputField2" class="fa fa-eye field-icon toggle-password"></span> </div> <div class="form-check mb-3"> <input type="checkbox" class="form-check-input" id="authCheck"> <label class="form-check-label" for="authCheck"> Remember me` </label> </div> <!-- div to show reCAPTCHA --> <div class="g-recaptcha mb-4" data-sitekey="6LcXEiAhAAAAAJRpKyjYMJx0ZXIfmM1COjUj4uAe"> </div> <div> <input type="submit" name="login" value="Login" class="btn btn-primary w-100 me-2 mb-2 mb-md-0 text-white"> </div> </form> </div> </div> </div> </div> </div> </div> </div> /* <!-- Author Name- Mayuri K. for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com Visit website - www.mayurik.com --> } */ <!-- core:js --> <script src="../assets/vendors/core/core.js"></script> <!-- endinject --> <!-- Plugin js for this page --> <!-- End plugin js for this page --> <!-- inject:js --> <script src="../assets/vendors/feather-icons/feather.min.js"></script> <script src="../assets/js/template.js"></script> <!-- endinject --> <!-- Custom js for this page --> <!-- End custom js for this page --> <script> // Function to check for spaces function checkForSpaces(event) { if (event.target.value.includes(' ')) { alert('Space is not allowed!'); event.target.value = event.target.value.replace(/\s/g, ''); // Remove spaces from input } } // Get input elements var usernameInput = document.getElementById('userEmail'); var passwordInput = document.getElementById('userPassword'); // Attach event listeners to input elements usernameInput.addEventListener('input', checkForSpaces); passwordInput.addEventListener('input', checkForSpaces); </script> </body> </html> |
kortex_lite.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 30, 2024 at 07:39 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `kortex_lite` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(10) NOT NULL, `name` varchar(50) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `photo` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `name`, `username`, `password`, `photo`) VALUES (1, 'Mayuri K', 'mayuri.infospace@gmail.com', 'aa7f019c326413d5b8bcad4314228bcd33ef557f5d81c7cc977f7728156f4357', '05profile.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `case_register` -- CREATE TABLE `case_register` ( `id` int(11) NOT NULL, `title` varchar(50) NOT NULL, `case_no` varchar(20) NOT NULL, `client_name` varchar(50) NOT NULL, `court` varchar(50) NOT NULL, `case_type` varchar(50) NOT NULL, `case_stage` varchar(50) NOT NULL, `legel_acts` varchar(50) NOT NULL, `description` varchar(100) NOT NULL, `filling_date` date NOT NULL, `hearing_date` date NOT NULL, `opposite_lawyer` varchar(50) NOT NULL, `total_fees` int(20) NOT NULL, `unpaid` int(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `case_register` -- INSERT INTO `case_register` (`id`, `title`, `case_no`, `client_name`, `court`, `case_type`, `case_stage`, `legel_acts`, `description`, `filling_date`, `hearing_date`, `opposite_lawyer`, `total_fees`, `unpaid`) VALUES (1, 'Land Dispute Case', 'LD001', '1', '2', '1', '1', '1', 'Dispute over land ownership between two parties.', '2023-05-20', '2024-01-15', 'John Smith', 5000, 2000), (2, 'Divorce Case', 'DV002', '2', '3', '2', '2', '2', 'Legal separation between married couple.', '2023-07-10', '2024-02-20', 'Emily Johnson', 7500, 3000), (3, 'Employment Discrimination Case', 'ED003', '3', '1', '1', '3', '4', 'Allegations of workplace discrimination.', '2023-09-05', '2024-03-10', 'Rachel White', 10000, 4000), (4, 'Personal Injury Case', 'PI004', '4', '4', '1', '4', '3', 'Compensation claim for injuries sustained in a car accident.', '2023-10-15', '2024-04-05', 'Michael Brown', 8000, 2000), (5, 'Criminal Case', 'CR005', '5', '6', '3', '5', '5', 'Alleged theft of property.', '2023-11-20', '2024-05-15', 'David Wilson', 12000, 6000), (6, 'Child Custody Case', 'CC006', '6', '7', '2', '2', '6', 'Dispute over custody of children in divorce proceedings.', '2024-01-05', '2024-06-20', 'Sarah Davis', 9000, 3000), (7, 'Tax Evasion Case', 'TE007', '7', '8', '1', '6', '7', 'Alleged evasion of taxes by a business entity.', '2024-02-10', '2024-07-05', 'Daniel Clark', 15000, 7000), (8, 'Environmental Law Violation Case', 'EV008', '8', '10', '1', '7', '8', 'Violation of environmental regulations by a corporation.', '2024-03-20', '2024-08-10', 'Olivia Martinez', 11000, 5000), (9, 'Employment Contract Dispute Case', 'EC009', '9', '9', '1', '3', '9', 'Dispute over terms of employment contract.', '2024-04-15', '2024-09-20', 'Matthew Garcia', 8500, 2000), (10, 'Adoption Case', 'AD010', '10', '5', '2', '2', '10', 'Legal process of adopting a child.', '2024-05-10', '2024-10-15', 'Ava Lee', 9500, 4000); -- -------------------------------------------------------- -- -- Table structure for table `case_stage` -- CREATE TABLE `case_stage` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `status` varchar(50) NOT NULL COMMENT '0-active,1-deactive' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `case_stage` -- INSERT INTO `case_stage` (`id`, `name`, `status`) VALUES (1, 'Initial Review', '0'), (2, 'Investigation', 'Pending'), (3, 'Legal Review', '0'), (4, 'Resolution Negotiation', 'Pending'), (5, 'Final Decision', 'Pending'), (6, 'Appeal Process', 'Pending'), (7, 'Settlement', 'Completed'), (8, 'Closure', 'Completed'), (9, 'Reopening', 'Pending'), (10, 'Litigation', 'Active'); -- -------------------------------------------------------- -- -- Table structure for table `case_types` -- CREATE TABLE `case_types` ( `id` int(11) NOT NULL, `case_type` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `case_types` -- INSERT INTO `case_types` (`id`, `case_type`) VALUES (1, 'Civil'), (2, 'Criminal'), (3, 'Family'), (4, 'Employment'), (5, 'Personal Injury'), (6, 'Tax'), (7, 'Environmental'), (8, 'Contract'), (9, 'Intellectual Property'), (10, 'Immigration'); -- -------------------------------------------------------- -- -- Table structure for table `clients` -- CREATE TABLE `clients` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `gender` varchar(10) NOT NULL, `dob` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `mobile` varchar(20) NOT NULL, `address` varchar(100) NOT NULL, `status` varchar(20) NOT NULL COMMENT '0-active,1-deactive' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `clients` -- INSERT INTO `clients` (`id`, `name`, `gender`, `dob`, `email`, `mobile`, `address`, `status`) VALUES (1, 'John Doe', 'Male', '1990-05-15', 'john.doe@example.com', '1234567890', '123 Main St, City, Country', '0'), (2, 'Jane Smith', 'Female', '1985-09-25', 'jane.smith@example.com', '9876543210', '456 Elm St, Town, Country', '0'), (3, 'Michael Johnson', 'Male', '1978-11-10', 'michael.johnson@example.com', '4567890123', '789 Oak St, Village, Country', '0'), (4, 'Emily Brown', 'Female', '1995-03-20', 'emily.brown@example.com', '7890123456', '321 Pine St, Hamlet, Country', '0'), (5, 'David Lee', 'Male', '1980-07-12', 'david.lee@example.com', '2345678901', '987 Maple St, City, Country', '0'), (6, 'Sarah Wilson', 'Female', '1992-01-05', 'sarah.wilson@example.com', '8901234567', '654 Cedar St, Town, Country', '0'), (7, 'Daniel Martinez', 'Male', '1987-04-30', 'daniel.martinez@example.com', '3456789012', '789 Birch St, Village, Country', '0'), (8, 'Olivia Taylor', 'Female', '1983-08-17', 'olivia.taylor@example.com', '9012345678', '543 Pine St, Hamlet, Country', '0'), (9, 'Matthew Anderson', 'Male', '1975-12-22', 'matthew.anderson@example.com', '0123456789', '234 Oak St, City, Country', '0'), (10, 'Ava Garcia', 'Female', '1998-06-08', 'ava.garcia@example.com', '5678901234', '876 Elm St, Town, Country', '0'); -- -------------------------------------------------------- -- -- Table structure for table `court` -- CREATE TABLE `court` ( `id` int(11) NOT NULL, `court_category` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `court` -- INSERT INTO `court` (`id`, `court_category`) VALUES (1, 'Supreme Court'), (2, 'High Court'), (3, 'District Court'), (4, 'Appellate Court'), (5, 'Juvenile Court'), (6, 'Family Court'), (7, 'Tax Court'), (8, 'Administrative Court'), (9, 'Magistrate Court'), (10, 'Probate Court'); -- -------------------------------------------------------- -- -- Table structure for table `legel_acts` -- CREATE TABLE `legel_acts` ( `id` int(11) NOT NULL, `act_name` varchar(50) NOT NULL, `status` int(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `legel_acts` -- INSERT INTO `legel_acts` (`id`, `act_name`, `status`) VALUES (1, 'Consumer Protection Act', 0), (2, 'Family and Medical Leave Act', 0), (3, 'Americans with Disabilities Act', 0), (4, 'Civil Rights Act', 0), (5, 'Fair Labor Standards Act', 0), (6, 'Clean Air Act', 0), (7, 'Occupational Safety and Health Act', 0), (8, 'Freedom of Information Act', 0), (9, 'National Environmental Policy Act', 0), (10, 'Equal Pay Act', 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `case_register` -- ALTER TABLE `case_register` ADD PRIMARY KEY (`id`); -- -- Indexes for table `case_stage` -- ALTER TABLE `case_stage` ADD PRIMARY KEY (`id`); -- -- Indexes for table `case_types` -- ALTER TABLE `case_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `clients` -- ALTER TABLE `clients` ADD PRIMARY KEY (`id`); -- -- Indexes for table `court` -- ALTER TABLE `court` ADD PRIMARY KEY (`id`); -- -- Indexes for table `legel_acts` -- ALTER TABLE `legel_acts` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `case_register` -- ALTER TABLE `case_register` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `case_stage` -- ALTER TABLE `case_stage` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `case_types` -- ALTER TABLE `case_types` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `clients` -- ALTER TABLE `clients` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `court` -- ALTER TABLE `court` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `legel_acts` -- ALTER TABLE `legel_acts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; COMMIT; /*!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 */; |