-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Mar 17, 2026 at 11:22 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: `tcv`
--

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

--
-- 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` bigint 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;

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

--
-- Table structure for table `cbill`
--

DROP TABLE IF EXISTS `cbill`;
CREATE TABLE IF NOT EXISTS `cbill` (
  `blid` bigint NOT NULL AUTO_INCREMENT,
  `bl_cid` bigint NOT NULL DEFAULT '0',
  `bl_dt` date NOT NULL DEFAULT '2020-06-01',
  `bl_pid` bigint NOT NULL DEFAULT '0',
  `bl_no` varchar(200) DEFAULT NULL,
  `bl_cname` varchar(300) NOT NULL,
  `bl_address` varchar(500) NOT NULL,
  `bl_phone` varchar(200) NOT NULL,
  `bl_paych` varchar(500) NOT NULL,
  `bl_amt` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_payamt` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_stat` int NOT NULL DEFAULT '0',
  `bl_paydt` date NOT NULL DEFAULT '2020-06-01',
  `bl_paymd` varchar(300) DEFAULT NULL,
  `bl_trn` varchar(500) DEFAULT NULL,
  `bl_payuid` varchar(500) DEFAULT NULL,
  `bl_attch` varchar(500) DEFAULT NULL,
  `bl_due` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_user` varchar(500) DEFAULT NULL,
  `bl_expiry` date NOT NULL DEFAULT '2020-06-01',
  `bl_prevdue` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_tp` int NOT NULL,
  `bl_month` varchar(100) NOT NULL DEFAULT 'Oct',
  `bl_year` varchar(100) NOT NULL DEFAULT '2020',
  `bl_stdt` date NOT NULL DEFAULT '2020-01-01',
  `bl_disc` decimal(10,2) NOT NULL,
  `bl_gst` decimal(10,2) NOT NULL,
  `bl_pak` decimal(10,2) NOT NULL,
  `bl_mso` bigint DEFAULT NULL,
  `bl_area` bigint DEFAULT NULL,
  `bl_remarks` varchar(500) DEFAULT NULL,
  `oth_due` float DEFAULT '0',
  `oth_reason` varchar(500) DEFAULT NULL,
  `bl_com` bigint DEFAULT NULL,
  `bl_line` bigint DEFAULT '0',
  PRIMARY KEY (`blid`),
  KEY `idx_bl_no` (`bl_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `obill`
--

DROP TABLE IF EXISTS `obill`;
CREATE TABLE IF NOT EXISTS `obill` (
  `blid` bigint NOT NULL AUTO_INCREMENT,
  `bl_cid` bigint NOT NULL DEFAULT '0',
  `bl_dt` date NOT NULL DEFAULT '2020-06-01',
  `bl_pid` bigint NOT NULL DEFAULT '0',
  `bl_no` varchar(200) DEFAULT NULL,
  `bl_cname` varchar(300) NOT NULL,
  `bl_address` varchar(500) NOT NULL,
  `bl_phone` varchar(200) NOT NULL,
  `bl_paych` varchar(500) NOT NULL,
  `bl_amt` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_payamt` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_stat` int NOT NULL DEFAULT '0',
  `bl_paydt` date NOT NULL DEFAULT '2020-06-01',
  `bl_paymd` varchar(300) DEFAULT NULL,
  `bl_trn` varchar(500) DEFAULT NULL,
  `bl_payuid` varchar(500) DEFAULT NULL,
  `bl_attch` varchar(500) DEFAULT NULL,
  `bl_due` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_user` varchar(500) DEFAULT NULL,
  `bl_expiry` date NOT NULL DEFAULT '2020-06-01',
  `bl_prevdue` decimal(10,2) NOT NULL DEFAULT '0.00',
  `bl_tp` int NOT NULL,
  `bl_month` varchar(100) NOT NULL DEFAULT 'Oct',
  `bl_year` varchar(100) NOT NULL DEFAULT '2020',
  `bl_stdt` date NOT NULL DEFAULT '2020-01-01',
  `bl_disc` decimal(10,2) NOT NULL,
  `bl_gst` decimal(10,2) NOT NULL,
  `bl_pak` decimal(10,2) NOT NULL,
  `bl_mso` bigint DEFAULT NULL,
  `bl_area` bigint DEFAULT NULL,
  PRIMARY KEY (`blid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sender_ids`
--

DROP TABLE IF EXISTS `sender_ids`;
CREATE TABLE IF NOT EXISTS `sender_ids` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sender_id` varchar(100) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `sms_count` int DEFAULT '0',
  `last_reset` datetime DEFAULT CURRENT_TIMESTAMP,
  `is_active` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sender_id` (`sender_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `tbl_access`
--

DROP TABLE IF EXISTS `tbl_access`;
CREATE TABLE IF NOT EXISTS `tbl_access` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `pageid` bigint NOT NULL,
  `utype` bigint NOT NULL,
  `pview` bigint NOT NULL,
  `psave` bigint NOT NULL,
  `pupdate` bigint NOT NULL,
  `pdelete` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_acs`
--

DROP TABLE IF EXISTS `tbl_acs`;
CREATE TABLE IF NOT EXISTS `tbl_acs` (
  `acid` bigint NOT NULL AUTO_INCREMENT,
  `acname` varchar(500) NOT NULL,
  PRIMARY KEY (`acid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_area`
--

DROP TABLE IF EXISTS `tbl_area`;
CREATE TABLE IF NOT EXISTS `tbl_area` (
  `arid` bigint NOT NULL AUTO_INCREMENT,
  `arname` varchar(200) NOT NULL,
  PRIMARY KEY (`arid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_audit_log`
--

DROP TABLE IF EXISTS `tbl_audit_log`;
CREATE TABLE IF NOT EXISTS `tbl_audit_log` (
  `log_id` int NOT NULL AUTO_INCREMENT,
  `log_action_type` varchar(100) NOT NULL COMMENT 'Type of action (e.g., BILL_DELETE, PAYMENT_DELETE)',
  `log_action_details` text NOT NULL COMMENT 'Detailed description of the action',
  `log_user_id` varchar(100) NOT NULL COMMENT 'Logged user ID',
  `log_user_name` varchar(255) NOT NULL COMMENT 'Logged user name',
  `log_user_type` varchar(10) NOT NULL COMMENT 'User type (1=Admin, 2=Operator, etc)',
  `log_ip_address` varchar(50) NOT NULL COMMENT 'IP address of the user',
  `log_date` date NOT NULL COMMENT 'Date of action',
  `log_time` time NOT NULL COMMENT 'Time of action',
  `log_page_name` varchar(255) NOT NULL COMMENT 'Page name where action occurred',
  `log_page_url` text NOT NULL COMMENT 'Full URL of the page',
  `log_bill_id` varchar(100) DEFAULT NULL COMMENT 'Bill ID affected',
  `log_customer_id` varchar(100) DEFAULT NULL COMMENT 'Customer ID affected',
  `log_month` varchar(20) DEFAULT NULL COMMENT 'Month (for bulk deletes)',
  `log_year` varchar(20) DEFAULT NULL COMMENT 'Year (for bulk deletes)',
  `log_area` varchar(100) DEFAULT NULL COMMENT 'Area ID (for area-wise deletes)',
  `log_amount` varchar(50) DEFAULT NULL COMMENT 'Amount involved',
  `log_company` varchar(255) DEFAULT NULL COMMENT 'Company name',
  `log_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Record creation timestamp',
  PRIMARY KEY (`log_id`),
  KEY `log_user_id` (`log_user_id`),
  KEY `log_date` (`log_date`),
  KEY `log_action_type` (`log_action_type`),
  KEY `log_bill_id` (`log_bill_id`),
  KEY `log_customer_id` (`log_customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Audit log for tracking bill delete actions';

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

--
-- Table structure for table `tbl_billpay`
--

DROP TABLE IF EXISTS `tbl_billpay`;
CREATE TABLE IF NOT EXISTS `tbl_billpay` (
  `pay_id` bigint NOT NULL AUTO_INCREMENT,
  `pay_date` date NOT NULL,
  `pay_amt` decimal(10,2) NOT NULL,
  `pay_bill` bigint NOT NULL,
  `pay_by` varchar(200) NOT NULL,
  `pay_user` varchar(500) NOT NULL,
  `pay_rmrk` varchar(1000) NOT NULL,
  PRIMARY KEY (`pay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_change_package`
--

DROP TABLE IF EXISTS `tbl_change_package`;
CREATE TABLE IF NOT EXISTS `tbl_change_package` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userid` int NOT NULL,
  `price` varchar(255) NOT NULL,
  `pay_ch` text NOT NULL,
  `packpr` varchar(255) NOT NULL,
  `ncf` varchar(255) DEFAULT NULL,
  `chp` float DEFAULT NULL,
  `ala` float DEFAULT NULL,
  `dbp` float DEFAULT NULL,
  `totalc` int DEFAULT NULL,
  `chno` int DEFAULT NULL,
  `alano` int DEFAULT NULL,
  `bpno` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_change_package_details`
--

DROP TABLE IF EXISTS `tbl_change_package_details`;
CREATE TABLE IF NOT EXISTS `tbl_change_package_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `pac_id` int NOT NULL,
  `cust_date` date NOT NULL,
  `pac_type` int NOT NULL,
  `chid` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_company`
--

DROP TABLE IF EXISTS `tbl_company`;
CREATE TABLE IF NOT EXISTS `tbl_company` (
  `c_id` bigint NOT NULL AUTO_INCREMENT,
  `c_logo` varchar(500) DEFAULT NULL,
  `c_name` varchar(500) DEFAULT NULL,
  `c_phone` varchar(200) DEFAULT NULL,
  `c_mobile` varchar(200) DEFAULT NULL,
  `c_email` varchar(300) DEFAULT NULL,
  `c_emailalt` varchar(300) DEFAULT NULL,
  `c_address` varchar(300) DEFAULT NULL,
  `isgst` int DEFAULT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_docs`
--

DROP TABLE IF EXISTS `tbl_docs`;
CREATE TABLE IF NOT EXISTS `tbl_docs` (
  `did` bigint NOT NULL AUTO_INCREMENT,
  `d_cid` bigint NOT NULL,
  `d_type` int DEFAULT NULL,
  `d_name` varchar(200) DEFAULT NULL,
  `d_file` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_financial_year_bill_seq`
--

DROP TABLE IF EXISTS `tbl_financial_year_bill_seq`;
CREATE TABLE IF NOT EXISTS `tbl_financial_year_bill_seq` (
  `seq_id` int NOT NULL AUTO_INCREMENT,
  `financial_year_start` date NOT NULL COMMENT 'Financial year start date (April 1st)',
  `financial_year_end` date NOT NULL COMMENT 'Financial year end date (March 31st)',
  `year_label` varchar(20) NOT NULL COMMENT 'Financial year label (e.g., 2025-2026)',
  `current_bill_no` int NOT NULL DEFAULT '0' COMMENT 'Current bill number counter',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`seq_id`),
  UNIQUE KEY `year_label` (`year_label`),
  KEY `financial_year_start` (`financial_year_start`),
  KEY `financial_year_end` (`financial_year_end`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Track bill number sequence per financial year';

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

--
-- Table structure for table `tbl_lane`
--

DROP TABLE IF EXISTS `tbl_lane`;
CREATE TABLE IF NOT EXISTS `tbl_lane` (
  `lnid` bigint NOT NULL AUTO_INCREMENT,
  `lnname` varchar(200) NOT NULL,
  `lnarid` bigint NOT NULL,
  PRIMARY KEY (`lnid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_ledger`
--

DROP TABLE IF EXISTS `tbl_ledger`;
CREATE TABLE IF NOT EXISTS `tbl_ledger` (
  `lid` bigint NOT NULL AUTO_INCREMENT,
  `lname` varchar(500) NOT NULL,
  `ldate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_login`
--

DROP TABLE IF EXISTS `tbl_login`;
CREATE TABLE IF NOT EXISTS `tbl_login` (
  `l_id` bigint NOT NULL AUTO_INCREMENT,
  `l_uid` varchar(500) NOT NULL,
  `l_pass` varchar(500) NOT NULL,
  `l_name` varchar(300) NOT NULL,
  `l_read` varchar(300) NOT NULL,
  `l_type` int NOT NULL,
  `l_act` int NOT NULL,
  `user_id` bigint NOT NULL,
  `zone_id` bigint DEFAULT '0',
  PRIMARY KEY (`l_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_mso`
--

DROP TABLE IF EXISTS `tbl_mso`;
CREATE TABLE IF NOT EXISTS `tbl_mso` (
  `m_id` bigint NOT NULL AUTO_INCREMENT,
  `m_name` varchar(300) NOT NULL,
  `m_phone` varchar(100) DEFAULT NULL,
  `m_email` varchar(200) DEFAULT NULL,
  `m_altemail` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`m_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_multi`
--

DROP TABLE IF EXISTS `tbl_multi`;
CREATE TABLE IF NOT EXISTS `tbl_multi` (
  `m_ids` bigint NOT NULL AUTO_INCREMENT,
  `m_custid` bigint NOT NULL,
  `m_done` int NOT NULL DEFAULT '0',
  `mnth` varchar(200) NOT NULL,
  `yrs` varchar(200) NOT NULL,
  PRIMARY KEY (`m_ids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_opay`
--

DROP TABLE IF EXISTS `tbl_opay`;
CREATE TABLE IF NOT EXISTS `tbl_opay` (
  `pay_id` bigint NOT NULL AUTO_INCREMENT,
  `pay_date` date DEFAULT NULL,
  `pay_amt` decimal(10,2) DEFAULT NULL,
  `pay_bill` bigint NOT NULL,
  `pay_by` varchar(500) DEFAULT NULL,
  `pay_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`pay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_pack`
--

DROP TABLE IF EXISTS `tbl_pack`;
CREATE TABLE IF NOT EXISTS `tbl_pack` (
  `pid` bigint NOT NULL AUTO_INCREMENT,
  `pname` varchar(500) DEFAULT NULL,
  `details` varchar(1000) DEFAULT NULL,
  `pdt` date NOT NULL DEFAULT '2020-01-01',
  `prc` float NOT NULL DEFAULT '0',
  `ptype` int DEFAULT '0',
  `pmso` int NOT NULL DEFAULT '0',
  `pnochannel` int NOT NULL DEFAULT '0',
  `base_rate` float DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_package_details`
--

DROP TABLE IF EXISTS `tbl_package_details`;
CREATE TABLE IF NOT EXISTS `tbl_package_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `pac_id` int NOT NULL,
  `cust_date` date NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_pages`
--

DROP TABLE IF EXISTS `tbl_pages`;
CREATE TABLE IF NOT EXISTS `tbl_pages` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `pagename` varchar(500) NOT NULL,
  `dispname` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_problems`
--

DROP TABLE IF EXISTS `tbl_problems`;
CREATE TABLE IF NOT EXISTS `tbl_problems` (
  `pid` bigint NOT NULL AUTO_INCREMENT,
  `pname` varchar(500) NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_server_bill`
--

DROP TABLE IF EXISTS `tbl_server_bill`;
CREATE TABLE IF NOT EXISTS `tbl_server_bill` (
  `m_id` bigint NOT NULL AUTO_INCREMENT,
  `m_month` varchar(100) NOT NULL,
  `m_year` varchar(100) NOT NULL,
  `m_area` bigint NOT NULL,
  `m_done` int NOT NULL DEFAULT '0',
  `m_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`m_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_sms`
--

DROP TABLE IF EXISTS `tbl_sms`;
CREATE TABLE IF NOT EXISTS `tbl_sms` (
  `smsid` bigint NOT NULL AUTO_INCREMENT,
  `cnt` int NOT NULL,
  `smsdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`smsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_stbvc`
--

DROP TABLE IF EXISTS `tbl_stbvc`;
CREATE TABLE IF NOT EXISTS `tbl_stbvc` (
  `ids` bigint NOT NULL AUTO_INCREMENT,
  `stbs` varchar(500) DEFAULT NULL,
  `vcs` varchar(500) DEFAULT NULL,
  `types` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_ticket`
--

DROP TABLE IF EXISTS `tbl_ticket`;
CREATE TABLE IF NOT EXISTS `tbl_ticket` (
  `tkt_id` bigint NOT NULL AUTO_INCREMENT,
  `ctype` int NOT NULL,
  `custid` bigint NOT NULL,
  `strtdt` date NOT NULL,
  `pticket` varchar(500) NOT NULL,
  `pdet` varchar(1000) NOT NULL,
  `stat` varchar(120) NOT NULL DEFAULT 'PENDING',
  `suser` varchar(300) NOT NULL,
  `sdate` date NOT NULL DEFAULT '2020-01-01',
  `sdet` varchar(1000) NOT NULL,
  PRIMARY KEY (`tkt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_trans`
--

DROP TABLE IF EXISTS `tbl_trans`;
CREATE TABLE IF NOT EXISTS `tbl_trans` (
  `trnid` bigint NOT NULL AUTO_INCREMENT,
  `trn_ac` bigint NOT NULL,
  `trn_name` varchar(300) NOT NULL,
  `trn_amt` decimal(10,2) NOT NULL DEFAULT '0.00',
  `trn_date` date NOT NULL,
  `trn_type` varchar(50) NOT NULL,
  `trn_memo` varchar(500) DEFAULT NULL,
  `trn_gst` int NOT NULL DEFAULT '0',
  `trn_grate` float NOT NULL DEFAULT '0',
  `trn_gamt` decimal(10,2) DEFAULT '0.00',
  `trn_igst` int NOT NULL DEFAULT '0',
  `trn_billid` bigint DEFAULT '0',
  `trn_user` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`trnid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_utype`
--

DROP TABLE IF EXISTS `tbl_utype`;
CREATE TABLE IF NOT EXISTS `tbl_utype` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `names` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 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 */;
