---
 -- Database: `gawsh`
---
-
 -- --------------------------------------------------------
 
---
--- Stand-in structure for view `recentvisits`
---
-DROP VIEW IF EXISTS `recentvisits`;
-CREATE TABLE IF NOT EXISTS `recentvisits` (
-`alias` varchar(50)
-,`FROM_UNIXTIME(visits.time)` datetime
-,`ip` varchar(128)
-,`referrer` text
-);
--- --------------------------------------------------------
-
---
--- Stand-in structure for view `searchurlsvisits`
---
-DROP VIEW IF EXISTS `searchurlsvisits`;
-CREATE TABLE IF NOT EXISTS `searchurlsvisits` (
-`id` int(10) unsigned
-,`alias` varchar(50)
-,`url` text
-,`ip` varchar(128)
-,`time` varchar(15)
-,`status` varchar(2)
-,`visits` bigint(21)
-);
--- --------------------------------------------------------
-
---
 -- Table structure for table `urls`
---
-
-DROP TABLE IF EXISTS `urls`;
 CREATE TABLE IF NOT EXISTS `urls` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `alias` varchar(50) NOT NULL,

  KEY `alias` (`alias`),
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


INSERT INTO `urls` (`id`, `alias`, `url`, `ip`, `time`, `status`) VALUES
(1, 'admin', '', '127.0.0.1', '1323141765', '-1'),
(2, '401', '', '127.0.0.1', '1323141766', '-1'),

(5, '410', '', '127.0.0.1', '1323141769', '-1'),
(6, '503', '', '127.0.0.1', '1323141770', '-1');


-- Table structure for table `visits`
DROP TABLE IF EXISTS `visits`;
CREATE TABLE IF NOT EXISTS `visits` (
  `id` int(10) unsigned NOT NULL,
