-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 31, 2025 at 07:43 AM
-- Server version: 8.3.0
-- PHP Version: 7.4.33

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: `unicablec`
--

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

--
-- Table structure for table `adduser`
--

DROP TABLE IF EXISTS `adduser`;
CREATE TABLE IF NOT EXISTS `adduser` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` tinytext,
  `email` varchar(255) DEFAULT NULL,
  `custid` varchar(255) DEFAULT NULL,
  `houseno` varchar(200) DEFAULT NULL,
  `address` text,
  `phone` varchar(50) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `vc` varchar(500) NOT NULL DEFAULT '0',
  `stb` varchar(500) NOT NULL DEFAULT '0',
  `pay_ch` text NOT NULL,
  `is_cable` int NOT NULL DEFAULT '1',
  `mnth` varchar(100) NOT NULL DEFAULT 'July',
  `yrs` varchar(100) NOT NULL DEFAULT '2020',
  `area_id` bigint NOT NULL DEFAULT '0',
  `area_name` varchar(500) DEFAULT NULL,
  `packid` bigint DEFAULT '0',
  `packname` varchar(500) DEFAULT NULL,
  `packpr` decimal(10,2) NOT NULL DEFAULT '0.00',
  `packpr_id` bigint NOT NULL DEFAULT '0',
  `prevdue` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pexpiry` date NOT NULL DEFAULT '2020-09-01',
  `ncf` float NOT NULL DEFAULT '0',
  `actv` int DEFAULT '1',
  `lpaydt` date DEFAULT NULL,
  `lpayamt` float DEFAULT NULL,
  `mso` bigint DEFAULT NULL,
  `sdhd` varchar(300) DEFAULT NULL,
  `boxdate` date DEFAULT NULL,
  `com_id` bigint NOT NULL DEFAULT '1',
  `msoacno` varchar(500) DEFAULT NULL,
  `line_ids` bigint DEFAULT NULL,
  `landmark` varchar(500) DEFAULT NULL,
  `off_id` varchar(100) DEFAULT NULL,
  `discounts` float DEFAULT NULL,
  `safno` varchar(400) DEFAULT NULL,
  `phone_off` varchar(300) DEFAULT NULL,
  `father_name` varchar(500) DEFAULT NULL,
  `note` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `custid` (`custid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
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 */;
