Hoi
Als ik een MySQL database wil installeren, zie ik deze error:
Dit is mijn database code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `demo_demo`
--
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
DROP TABLE IF EXISTS `admins`;
CREATE TABLE IF NOT EXISTS `admins` (
`id` int(11) unsigned NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`permissions` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admins`
--
INSERT INTO `admins` (`id`, `login`, `password`, `permissions`) VALUES (1, 'admin', 'admin', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `any`
--
DROP TABLE IF EXISTS `any`;
CREATE TABLE IF NOT EXISTS `any` (
`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
`created` datetime default NULL COMMENT 'Creation Time',
`updated` datetime default NULL COMMENT 'Modification Time',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `any`
--
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL auto_increment,
`categories` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`id`, `categories`) VALUES (1, 'Admin Features');
INSERT INTO `categories` (`id`, `categories`) VALUES (2, 'My Ads');
-- --------------------------------------------------------
--
-- Table structure for table `fieldsprop`
--
DROP TABLE IF EXISTS `fieldsprop`;
CREATE TABLE IF NOT EXISTS `fieldsprop` (
`id` int(11) NOT NULL auto_increment,
`table_name` varchar(255) default NULL,
`field_name` varchar(255) default NULL,
`full_name` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=108 ;
--
-- Dumping data for table `fieldsprop`
--
INSERT INTO `fieldsprop` (`id`, `table_name`, `field_name`, `full_name`) VALUES (1, 'banner', 'id', 'ID');
INSERT INTO `fieldsprop` (`id`, `table_name`, `field_name`, `full_name`) VALUES (2, 'banner', 'created', 'Creation Time');
INSERT INTO `fieldsprop` (`id`, `table_name`, `field_name`, `full_name`) VALUES (3, 'banner', 'updated', 'Modification Time');
-- --------------------------------------------------------
--
-- Table structure for table `scripts`
--
DROP TABLE IF EXISTS `scripts`;
CREATE TABLE IF NOT EXISTS `scripts` (
`id` int(11) NOT NULL auto_increment,
`script_name` varchar(255) default NULL,
`table_name` varchar(255) default NULL,
`name` varchar(255) default NULL,
`cat_id` int(2) default NULL,
`flag` int(1) default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `scripts`
--
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (1, 'change_password.php', '', 'Change Password', 1, 2);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (2, 'edit_categories.php', '', 'Edit Categories', 1, 0);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (3, 'edit_scripts.php', '', 'Edit Features', 1, 0);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (4, 'logout.php', '', 'Logout', 1, 2);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (5, 'data_manager.php?i=5', 'banner', 'Banner Ads', 2, 1);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (6, 'data_manager.php?i=6', 'solo', 'Solo Ads', 2, 1);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (7, 'data_manager.php?i=7', 'class', 'Classified Ads', 2, 1);
INSERT INTO `scripts` (`id`, `script_name`, `table_name`, `name`, `cat_id`, `flag`) VALUES (8, 'data_manager.php?i=8', 'other', 'Other Ads', 2, 1);
-- --------------------------------------------------------
--
-- Table structure for table `solo`
--
DROP TABLE IF EXISTS `solo`;
CREATE TABLE IF NOT EXISTS `solo` (
`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
`created` datetime default NULL COMMENT 'Creation Time',
`updated` datetime default NULL COMMENT 'Modification Time',
`prod` varchar(255) default NULL COMMENT 'Product Name',
`url` varchar(254) default NULL COMMENT 'Product URL',
`head` varchar(255) default NULL COMMENT 'Headline',
`ad` text COMMENT 'Solo Ad',
`date` date default NULL COMMENT 'Test Date',
`list` varchar(255) default NULL COMMENT 'List Name',
`subscr` varchar(255) default NULL COMMENT 'N° Of Subscribers',
`clicks` varchar(255) default NULL COMMENT 'Clicks',
`clthru` varchar(255) default NULL COMMENT 'Clicktrough Rate In %',
`Sales` varchar(255) default NULL COMMENT 'Sales',
`conv` varchar(255) default NULL COMMENT 'Conversion Ratio In %',
`cost` varchar(255) default NULL COMMENT 'Cost',
`result` varchar(255) default NULL COMMENT 'Result',
`profit` varchar(255) default NULL COMMENT 'Profit',
`rec` enum('Yes','No','Needs (more) testing') default NULL COMMENT 'Recommended?',
`notes` text COMMENT 'Notes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `solo`
Kan iemand me weer op weg helpen?
Groetjes,
Mieke