-- http://www.phpmyadmin.net
--




--
-- Database: `pp`


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

--
-- Table structure for table `links`
--

CREATE TABLE IF NOT EXISTS `links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `short` varchar(10) NOT NULL,
  `email` varchar(200) NOT NULL,
  `amount` varchar(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `curr` varchar(10) NOT NULL DEFAULT 'USD',
  `srv` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `short` (`short`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;


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

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `name` varchar(64) NOT NULL,
  `URL` varchar(255) NOT NULL,
  `custom` int(1) NOT NULL DEFAULT '1',
  `admin_user` varchar(255) NOT NULL,
  `admin_pass` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `prv` int(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `URL` (`URL`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`name`, `URL`, `custom`, `admin_user`, `admin_pass`, `email`, `prv`) VALUES
('PayLink', 'https://code.condize.com/pay', 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'ahmedalimody@gmail.com', 0);

