PHP Classes

MySQL

Recommend this page to a friend!

      URL shortener by hycus  >  All threads  >  MySQL  >  (Un) Subscribe thread alerts  
Subject:MySQL
Summary:missing create table
Messages:2
Author:andre
Date:2013-10-09 14:06:55
Update:2013-10-09 14:34:57
 

  1. MySQL   Reply   Report abuse  
Picture of andre andre - 2013-10-09 14:06:56
Hi,

why didn't you have added a .sql file, to create the table, to your project?

Regards

André

  2. Re: MySQL   Reply   Report abuse  
Picture of andre andre - 2013-10-09 14:34:57 - In reply to message 1 from andre
--
-- database: `urls`
-- or this what you've entered on $this->dbname = 'hycus_demos';
--

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

--
-- table structure for table: `shorturls`
-- or this what you've entered on $this->dbtablename = 'shorturls';
--

CREATE TABLE IF NOT EXISTS `shorturls` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shorturlid` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
`longurl` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
`hits` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;