-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 20, 2023 at 01:03 PM
-- Server version: 5.7.17-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `collectpoint`
--
CREATE DATABASE IF NOT EXISTS `collectpoint` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `collectpoint`;

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

--
-- Table structure for table `autobackup`
--

DROP TABLE IF EXISTS `autobackup`;
CREATE TABLE `autobackup` (
  `minit` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `autobackup`
--

TRUNCATE TABLE `autobackup`;
--
-- Dumping data for table `autobackup`
--

INSERT INTO `autobackup` (`minit`) VALUES
(30);

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

--
-- Table structure for table `branch`
--

DROP TABLE IF EXISTS `branch`;
CREATE TABLE `branch` (
  `ID` int(11) NOT NULL,
  `BranchName` varchar(255) DEFAULT NULL,
  `BranchAddress` text,
  `BranchTel` varchar(50) DEFAULT NULL,
  `BranchCode` varchar(13) DEFAULT NULL,
  `BranchFax` varchar(50) DEFAULT NULL,
  `BranchEmail` varchar(100) DEFAULT NULL,
  `BranchStatus` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `branch`
--

TRUNCATE TABLE `branch`;
--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`ID`, `BranchName`, `BranchAddress`, `BranchTel`, `BranchCode`, `BranchFax`, `BranchEmail`, `BranchStatus`) VALUES
(1, 'สำนักงานใหญ่', '103/70 หมู่บ้านฟลอราวิลล์ ซอยสุวินทวงศ์ 38 ถนนสุวินทวงศ์ แขวงลำผักชี เขตหนองจอก กรุงเทพมหานคร 10530', '0656505922', '0', '021027648', 'info@phetchampha.com', 'H');

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

--
-- Table structure for table `card`
--

DROP TABLE IF EXISTS `card`;
CREATE TABLE `card` (
  `CardID` int(11) NOT NULL,
  `MemCode` varchar(10) DEFAULT NULL,
  `CardPoint` decimal(20,2) DEFAULT NULL,
  `CardLastPoint` decimal(20,2) DEFAULT NULL,
  `CardStatus` char(1) DEFAULT NULL,
  `CardCode` varchar(50) DEFAULT NULL,
  `CardRegDate` datetime DEFAULT NULL,
  `CardExpireDate` datetime DEFAULT NULL,
  `LastRBaht` decimal(20,2) DEFAULT NULL,
  `RBaht` decimal(20,2) DEFAULT NULL,
  `RBalance` decimal(20,2) DEFAULT NULL,
  `CardTel` varchar(10) DEFAULT NULL,
  `OldFrom` varchar(50) DEFAULT NULL,
  `ReplaceReason` varchar(255) DEFAULT NULL,
  `CancelReason` varchar(255) DEFAULT NULL,
  `PointAmount` decimal(20,2) DEFAULT NULL,
  `BalanceAmount` decimal(20,2) DEFAULT NULL,
  `PointToMoney` decimal(20,2) NOT NULL,
  `BranchID` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `card`
--

TRUNCATE TABLE `card`;
-- --------------------------------------------------------

--
-- Table structure for table `cardprint`
--

DROP TABLE IF EXISTS `cardprint`;
CREATE TABLE `cardprint` (
  `CardPrint` varchar(1) DEFAULT NULL,
  `CardWidth` decimal(5,2) DEFAULT NULL,
  `CardHight` decimal(5,2) DEFAULT NULL,
  `ImgPrint` varchar(1) DEFAULT NULL,
  `ImgWidth` decimal(5,2) DEFAULT NULL,
  `ImgHight` decimal(5,2) DEFAULT NULL,
  `ImgX` decimal(5,2) DEFAULT NULL,
  `ImgY` decimal(5,2) DEFAULT NULL,
  `NamePrint` varchar(1) DEFAULT NULL,
  `NameX` decimal(5,2) DEFAULT NULL,
  `NameY` decimal(5,2) DEFAULT NULL,
  `QRCodePrint` varchar(1) DEFAULT NULL,
  `QRCodeX` decimal(5,2) DEFAULT NULL,
  `QRCodeY` decimal(5,2) DEFAULT NULL,
  `NameFontSize` decimal(5,2) DEFAULT NULL,
  `CardCodePrint` varchar(1) DEFAULT NULL,
  `CardCodeX` decimal(5,2) DEFAULT NULL,
  `CardCodeY` decimal(5,2) DEFAULT NULL,
  `CardCodeFontSize` decimal(5,2) DEFAULT NULL,
  `PrintBackground` varchar(1) DEFAULT NULL,
  `Background` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `cardprint`
--

TRUNCATE TABLE `cardprint`;
--
-- Dumping data for table `cardprint`
--

INSERT INTO `cardprint` (`CardPrint`, `CardWidth`, `CardHight`, `ImgPrint`, `ImgWidth`, `ImgHight`, `ImgX`, `ImgY`, `NamePrint`, `NameX`, `NameY`, `QRCodePrint`, `QRCodeX`, `QRCodeY`, `NameFontSize`, `CardCodePrint`, `CardCodeX`, `CardCodeY`, `CardCodeFontSize`, `PrintBackground`, `Background`) VALUES
('Y', '86.00', '54.00', 'Y', '30.00', '35.00', '5.00', '10.00', 'Y', '33.00', '10.00', 'Y', '60.00', '25.00', '15.00', 'Y', '33.00', '16.00', '15.00', 'N', 'CardBackguoud.jpg');

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

--
-- Table structure for table `cardtrans`
--

DROP TABLE IF EXISTS `cardtrans`;
CREATE TABLE `cardtrans` (
  `CTranID` int(11) NOT NULL,
  `CardCode` varchar(50) DEFAULT NULL,
  `CardLastPoint` decimal(20,2) DEFAULT NULL,
  `CardPoint` decimal(20,2) DEFAULT NULL,
  `CardPointBalance` decimal(20,2) DEFAULT NULL,
  `TransType` char(1) DEFAULT NULL,
  `TransDate` datetime DEFAULT NULL,
  `UserCode` varchar(50) DEFAULT NULL,
  `CardBaht` decimal(11,2) DEFAULT NULL,
  `CardBahtBalance` decimal(11,2) DEFAULT NULL,
  `CardLastBaht` decimal(11,2) DEFAULT NULL,
  `MemCode` varchar(10) DEFAULT NULL,
  `PointToMoney` decimal(20,2) DEFAULT NULL,
  `BranchID` int(11) DEFAULT NULL,
  `CategoryID` int(11) DEFAULT NULL,
  `GetMoney` decimal(11,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `cardtrans`
--

TRUNCATE TABLE `cardtrans`;
-- --------------------------------------------------------

--
-- Table structure for table `cardtype`
--

DROP TABLE IF EXISTS `cardtype`;
CREATE TABLE `cardtype` (
  `Type` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `cardtype`
--

TRUNCATE TABLE `cardtype`;
--
-- Dumping data for table `cardtype`
--

INSERT INTO `cardtype` (`Type`) VALUES
('N');

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

--
-- Table structure for table `constant`
--

DROP TABLE IF EXISTS `constant`;
CREATE TABLE `constant` (
  `ConName` varchar(255) DEFAULT NULL,
  `ConAddress` text,
  `ConTel` varchar(50) DEFAULT NULL,
  `ConTaxId` varchar(13) DEFAULT NULL,
  `ConFax` varchar(50) DEFAULT NULL,
  `ConEmail` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `constant`
--

TRUNCATE TABLE `constant`;
--
-- Dumping data for table `constant`
--

INSERT INTO `constant` (`ConName`, `ConAddress`, `ConTel`, `ConTaxId`, `ConFax`, `ConEmail`) VALUES
('สหกรณ์การเกษตรตัวอย่าง จำกัด', '103/70 หมู่บ้านฟลอราวิลล์ ซอยสุวินทวงศ์ 38 ถนนสุวินทวงศ์ แขวงลำผักชี เขตหนองจอก กรุงเทพมหานคร 10530', '0656505922', '0105560075964', '021027648', 'info@phetchampha.com');

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

--
-- Table structure for table `coupon`
--

DROP TABLE IF EXISTS `coupon`;
CREATE TABLE `coupon` (
  `PrintCoupon` char(1) DEFAULT NULL,
  `Width` int(5) DEFAULT NULL,
  `Hight` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `coupon`
--

TRUNCATE TABLE `coupon`;
--
-- Dumping data for table `coupon`
--

INSERT INTO `coupon` (`PrintCoupon`, `Width`, `Hight`) VALUES
('Y', 80, 80);

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

--
-- Table structure for table `discount`
--

DROP TABLE IF EXISTS `discount`;
CREATE TABLE `discount` (
  `ID` int(11) NOT NULL,
  `Point` decimal(20,2) DEFAULT NULL,
  `Discount` decimal(20,2) DEFAULT NULL,
  `Round` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `discount`
--

TRUNCATE TABLE `discount`;
--
-- Dumping data for table `discount`
--

INSERT INTO `discount` (`ID`, `Point`, `Discount`, `Round`) VALUES
(1, '1000.00', '10.00', 'Y');

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

--
-- Table structure for table `logs`
--

DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs` (
  `LogID` int(50) NOT NULL,
  `UserCode` varchar(50) DEFAULT NULL,
  `Action` text,
  `Date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `logs`
--

TRUNCATE TABLE `logs`;
-- --------------------------------------------------------

--
-- Table structure for table `member`
--

DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `MemID` int(11) NOT NULL,
  `MemCode` varchar(10) DEFAULT NULL,
  `MemCoopCode` varchar(50) DEFAULT NULL,
  `MemIDCard` varchar(13) DEFAULT NULL,
  `MemName` varchar(255) DEFAULT NULL,
  `MemAddress` text,
  `MemTel` varchar(10) DEFAULT NULL,
  `MemPhoto` varchar(255) DEFAULT NULL,
  `MemStatus` char(1) DEFAULT NULL,
  `MemReason` varchar(255) DEFAULT NULL,
  `MemDateRegis` datetime DEFAULT NULL,
  `MemDateResign` datetime DEFAULT NULL,
  `MemBranchID` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `member`
--

TRUNCATE TABLE `member`;
-- --------------------------------------------------------

--
-- Table structure for table `point`
--

DROP TABLE IF EXISTS `point`;
CREATE TABLE `point` (
  `ID` int(11) NOT NULL,
  `Category` varchar(255) DEFAULT NULL,
  `Money` decimal(20,2) DEFAULT NULL,
  `Point` decimal(20,2) DEFAULT NULL,
  `Round` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `point`
--

TRUNCATE TABLE `point`;
--
-- Dumping data for table `point`
--

INSERT INTO `point` (`ID`, `Category`, `Money`, `Point`, `Round`) VALUES
(1, 'เชื้อเพลิง', '1000.00', '5.00', 'N'),
(2, 'เคมีเกษตร', '5000.00', '100.00', 'N'),
(3, 'ของใช้ในครัวเรือน', '1000.00', '10.00', 'N'),
(4, 'อาหาร', '100.00', '1.00', 'N'),
(5, 'เบ็ดเตล็ด', '100.00', '2.00', 'N');

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

--
-- Table structure for table `sn`
--

DROP TABLE IF EXISTS `sn`;
CREATE TABLE `sn` (
  `SNCode` varchar(50) NOT NULL,
  `SNExpire` varbinary(50) NOT NULL,
  `SNID` int(11) NOT NULL,
  `SNSerialHDD` varchar(50) NOT NULL,
  `SNStart` varbinary(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `sn`
--

TRUNCATE TABLE `sn`;
--
-- Dumping data for table `sn`
--

INSERT INTO `sn` (`SNCode`, `SNExpire`, `SNID`, `SNSerialHDD`, `SNStart`) VALUES
('F5359-1931C-585EF', 0x31363035313134303030, 1, 'F43F-0252', 0x31363032353232303030);

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

--
-- Table structure for table `transaction`
--

DROP TABLE IF EXISTS `transaction`;
CREATE TABLE `transaction` (
  `ID` int(20) NOT NULL,
  `UserCode` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `transaction`
--

TRUNCATE TABLE `transaction`;
--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`ID`, `UserCode`) VALUES
(1, NULL);

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `UserID` int(11) NOT NULL,
  `UserCode` varchar(50) DEFAULT NULL,
  `UserFullName` varchar(255) DEFAULT NULL,
  `UserName` varchar(50) DEFAULT NULL,
  `UserPassword` varchar(50) DEFAULT NULL,
  `UserStatus` char(1) DEFAULT NULL,
  `UserRegDate` datetime DEFAULT NULL,
  `UserLevel` varchar(2) DEFAULT NULL,
  `UserBranchID` int(11) NOT NULL,
  `GID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `user`
--

TRUNCATE TABLE `user`;
--
-- Dumping data for table `user`
--

INSERT INTO `user` (`UserID`, `UserCode`, `UserFullName`, `UserName`, `UserPassword`, `UserStatus`, `UserRegDate`, `UserLevel`, `UserBranchID`, `GID`) VALUES
(1, 'U6303001', 'ศิริพงษ์ จันทร์กระจ่าง', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Y', '2020-03-30 09:06:37', '1', 1, 1),
(2, 'U6303002', 'ศิริพงษ์ จันทร์กระจ่าง', 'superadmin', '17c4520f6cfd1ab53d8745e84681eb49', 'Y', '2020-03-30 09:06:37', '99', 1, 99);

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

--
-- Table structure for table `usergroup`
--

DROP TABLE IF EXISTS `usergroup`;
CREATE TABLE `usergroup` (
  `GID` int(11) NOT NULL,
  `GroupName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `usergroup`
--

TRUNCATE TABLE `usergroup`;
--
-- Dumping data for table `usergroup`
--

INSERT INTO `usergroup` (`GID`, `GroupName`) VALUES
(2, 'ผู้จัดการ'),
(3, 'พนักงาน');

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

--
-- Table structure for table `usergrouppermission`
--

DROP TABLE IF EXISTS `usergrouppermission`;
CREATE TABLE `usergrouppermission` (
  `PID` int(11) NOT NULL,
  `GID` int(11) DEFAULT NULL,
  `PageName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `usergrouppermission`
--

TRUNCATE TABLE `usergrouppermission`;
--
-- Dumping data for table `usergrouppermission`
--

INSERT INTO `usergrouppermission` (`PID`, `GID`, `PageName`) VALUES
(1, 99, 'member_register'),
(2, 99, 'member_update'),
(3, 99, 'member_resign'),
(4, 99, 'card_newcard'),
(5, 99, 'card_replacecard'),
(6, 99, 'card_cancelcard'),
(7, 99, 'point_addpoint'),
(8, 99, 'point_reducepoint'),
(9, 99, 'point_transpoint'),
(10, 99, 'point_convertpoint'),
(11, 99, 'money_deposit'),
(12, 99, 'money_withdraw'),
(13, 99, 'money_transmoney'),
(14, 99, 'report_member'),
(15, 99, 'report_resign'),
(16, 99, 'report_memberall-pdf'),
(17, 99, 'report_person'),
(18, 99, 'report_card-pdf'),
(19, 99, 'report_discount-pdf'),
(20, 99, 'report_transaction'),
(21, 99, 'config_constant'),
(22, 99, 'config_branch'),
(23, 99, 'config_usergroup'),
(24, 99, 'config_user'),
(25, 99, 'config_card'),
(26, 99, 'config_cardprint'),
(27, 99, 'config_printcoupon'),
(28, 99, 'config_point'),
(29, 99, 'config_discount'),
(30, 99, 'config_database'),
(31, 99, 'config_regis'),
(32, 1, 'member_register'),
(33, 1, 'member_update'),
(34, 1, 'member_resign'),
(35, 1, 'card_newcard'),
(36, 1, 'card_replacecard'),
(37, 1, 'card_cancelcard'),
(38, 1, 'point_addpoint'),
(39, 1, 'point_reducepoint'),
(40, 1, 'point_transpoint'),
(41, 1, 'point_convertpoint'),
(42, 1, 'money_deposit'),
(43, 1, 'money_withdraw'),
(44, 1, 'money_transmoney'),
(45, 1, 'report_member'),
(46, 1, 'report_resign'),
(47, 1, 'report_memberall-pdf'),
(48, 1, 'report_person'),
(49, 1, 'report_card-pdf'),
(50, 1, 'report_discount-pdf'),
(51, 1, 'report_transaction'),
(52, 1, 'config_constant'),
(53, 1, 'config_branch'),
(54, 1, 'config_usergroup'),
(55, 1, 'config_user'),
(56, 1, 'config_card'),
(57, 1, 'config_cardprint'),
(58, 1, 'config_printcoupon'),
(59, 1, 'config_point'),
(60, 1, 'config_discount'),
(61, 1, 'config_database'),
(62, 1, 'config_regis'),
(63, 2, 'member_register'),
(64, 2, 'member_update'),
(65, 2, 'member_resign'),
(66, 2, 'card_newcard'),
(67, 2, 'card_replacecard'),
(68, 2, 'card_cancelcard'),
(69, 2, 'point_addpoint'),
(70, 2, 'point_reducepoint'),
(71, 2, 'point_transpoint'),
(72, 2, 'point_convertpoint'),
(73, 2, 'money_deposit'),
(74, 2, 'money_withdraw'),
(75, 2, 'money_transmoney'),
(76, 2, 'report_member'),
(77, 2, 'report_resign'),
(78, 2, 'report_memberall-pdf'),
(79, 2, 'report_person'),
(80, 2, 'report_card-pdf'),
(81, 2, 'report_discount-pdf'),
(82, 2, 'report_transaction'),
(83, 2, 'config_constant'),
(84, 2, 'config_branch'),
(85, 2, 'config_usergroup'),
(86, 2, 'config_user'),
(87, 2, 'config_card'),
(88, 2, 'config_cardprint'),
(89, 2, 'config_printcoupon'),
(90, 2, 'config_point'),
(91, 2, 'config_discount'),
(92, 2, 'config_database'),
(93, 2, 'config_regis'),
(94, 99, 'report_transaction-bydate'),
(95, 99, 'report_transaction-convert'),
(96, 2, 'report_transaction-bydate'),
(97, 2, 'report_transaction-convert');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `card`
--
ALTER TABLE `card`
  ADD PRIMARY KEY (`CardID`);

--
-- Indexes for table `cardtrans`
--
ALTER TABLE `cardtrans`
  ADD PRIMARY KEY (`CTranID`);

--
-- Indexes for table `discount`
--
ALTER TABLE `discount`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`LogID`);

--
-- Indexes for table `member`
--
ALTER TABLE `member`
  ADD PRIMARY KEY (`MemID`);

--
-- Indexes for table `point`
--
ALTER TABLE `point`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `sn`
--
ALTER TABLE `sn`
  ADD PRIMARY KEY (`SNID`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`UserID`);

--
-- Indexes for table `usergroup`
--
ALTER TABLE `usergroup`
  ADD PRIMARY KEY (`GID`);

--
-- Indexes for table `usergrouppermission`
--
ALTER TABLE `usergrouppermission`
  ADD PRIMARY KEY (`PID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `card`
--
ALTER TABLE `card`
  MODIFY `CardID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `cardtrans`
--
ALTER TABLE `cardtrans`
  MODIFY `CTranID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `discount`
--
ALTER TABLE `discount`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `LogID` int(50) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `member`
--
ALTER TABLE `member`
  MODIFY `MemID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `point`
--
ALTER TABLE `point`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `sn`
--
ALTER TABLE `sn`
  MODIFY `SNID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `ID` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `UserID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `usergroup`
--
ALTER TABLE `usergroup`
  MODIFY `GID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `usergrouppermission`
--
ALTER TABLE `usergrouppermission`
  MODIFY `PID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;
/*!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 */;
