hvB8JRuX

1-- phpMyAdmin SQL Dump
2-- version 3.5.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Apr 05, 2013 at 10:48 PM
7-- Server version: 5.5.25a
8-- PHP Version: 5.4.4
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `shortener`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `admin`
27--
28
29CREATE TABLE IF NOT EXISTS `admin` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `username` varchar(24) COLLATE utf8_romanian_ci NOT NULL,
32  `password` varchar(256) COLLATE utf8_romanian_ci NOT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci AUTO_INCREMENT=2 ;
35
36--
37-- Dumping data for table `admin`
38--
39
40INSERT INTO `admin` (`id`, `username`, `password`) VALUES
41(1, 'admin', 'a5ff20e027ef3106d327a99321fb0313');
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `links`
47--
48
49CREATE TABLE IF NOT EXISTS `links` (
50  `id` int(11) NOT NULL AUTO_INCREMENT,
51  `url` varchar(2048) NOT NULL,
52  `gid` varchar(256) NOT NULL,
53  `alias` varchar(256) NOT NULL,
54  `date` datetime NOT NULL,
55  PRIMARY KEY (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `settings`
62--
63
64CREATE TABLE IF NOT EXISTS `settings` (
65  `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
66  `api` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
67  `ad1` varchar(2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
68  `ad2` varchar(2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
69  `ad3` varchar(2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
70  `frame` int(11) NOT NULL,
71  `twitter` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
72  `facebook` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
73  `gplus` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
74  `captcha` int(1) NOT NULL
75) ENGINE=InnoDB DEFAULT CHARSET=latin1;
76
77--
78-- Dumping data for table `settings`
79--
80
81INSERT INTO `settings` (`title`, `api`, `ad1`, `ad2`, `ad3`, `frame`, `twitter`, `facebook`, `gplus`, `captcha`) VALUES
82('URL Shortener', '', '', '', '', 0, 'pricop2007', '', '', 0);
83
84/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
85/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
86/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;