کد:
-- phpMyAdmin SQL Dump
-- version 4.0.5
-- http://www.phpmyadmin.net
--
-- Host: 79.143.176.2
-- Generation Time: Sep 13, 2013 at 06:42 PM
-- Server version: 5.0.95
-- PHP Version: 5.3.17
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 utf8 */;
--
-- Database: `payline`
--
-- --------------------------------------------------------
--
-- Table structure for table `account`
--
CREATE TABLE IF NOT EXISTS `account` (
`id` int(11) NOT NULL auto_increment,
`acc_name` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`acc_cardnum` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`acc_no` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`acc_bank` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`acc_shaba` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=2730 AUTO_INCREMENT=73 ;
--
-- Dumping data for table `account`
--
INSERT INTO `account` (`id`, `acc_name`, `acc_cardnum`, `acc_no`, `acc_bank`, `acc_shaba`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `banks`
--
CREATE TABLE IF NOT EXISTS `banks` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`api_ref` varchar(255) NOT NULL,
`is_def` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=8192 AUTO_INCREMENT=44 ;
--
-- Dumping data for table `banks`
--
INSERT INTO `banks` (`id`, `name`, `api_ref`, `is_def`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `gateway`
--
CREATE TABLE IF NOT EXISTS `gateway` (
`id` int(11) NOT NULL auto_increment,
`gateway_name` varchar(255) collate utf8_persian_ci default NULL,
`website` varchar(255) collate utf8_persian_ci default NULL,
`gateway_pin` varchar(255) collate utf8_persian_ci default NULL,
`gateway_pass` varchar(255) collate utf8_persian_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=10 ;
--
-- Dumping data for table `gateway`
--
INSERT INTO `gateway` (`id`, `gateway_name`, `website`, `gateway_pin`, `gateway_pass`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`matn` varchar(32) character set utf8 collate utf8_persian_ci NOT NULL,
`time` varchar(32) character set utf8 collate utf8_persian_ci NOT NULL,
`show_index` varchar(32) character set utf8 collate utf8_persian_ci NOT NULL,
`show_cpanel` varchar(32) character set utf8 collate utf8_persian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=4096 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `news`
--
INSERT INTO `news` (`id`, `name`, `matn`, `time`, `show_index`, `show_cpanel`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `tasvie`
--
CREATE TABLE IF NOT EXISTS `tasvie` (
`id` int(11) NOT NULL auto_increment,
`type` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`stat` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`res_id` text character set utf8 collate utf8_persian_ci NOT NULL,
`acc` text character set utf8 collate utf8_persian_ci NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tasvie`
--
INSERT INTO `tasvie` (`id`, `type`, `stat`, `res_id`, `acc`t`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `tickets`
--
CREATE TABLE IF NOT EXISTS `tickets` (
`id` int(11) NOT NULL auto_increment,
`subject` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`part` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`stat` text character set utf8 collate utf8_persian_ci NOT NULL,
`time` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `tickets`
--
INSERT INTO `tickets` (`id`, `subject`,`tittle`, `part`, `time`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `trans`
--
CREATE TABLE IF NOT EXISTS `notifications` (
`id` int(11) NOT NULL auto_increment,
`trans_id` varchar(255) character set utf8 collate utf8_persian_ci NOT NULL,
`amount` text character set utf8 collate utf8_persian_ci NOT NULL,
`bank` text character set utf8 collate utf8_persian_ci NOT NULL,
`time` text character set utf8 collate utf8_persian_ci NOT NULL,
`result` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `trans`
--
INSERT INTO `trans` (`id`, `trans_id`, `amount`, `bank`, `time`, `result`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL auto_increment,
`name` text character set utf8 collate utf8_persian_ci NOT NULL,
`family` text character set utf8 collate utf8_persian_ci NOT NULL,
`email` text character set utf8 collate utf8_persian_ci NOT NULL,
`tel` text character set utf8 collate utf8_persian_ci NOT NULL,
`credit` text character set utf8 collate utf8_persian_ci NOT NULL,
`pass` text character set utf8 collate utf8_persian_ci NOT NULL,
`pass2` text character set utf8 collate utf8_persian_ci NOT NULL,
`time` text character set utf8 collate utf8_persian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `family`, `email`, `tel`, `credit`, `pass`, `pass2`) VALUES
-- --------------------------------------------------------
/*!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 */;