lookielookies
02-15-2008, 12:28 PM
When trying to import a database, I rceive the following error:
Error
SQL query:
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;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 7
Can someone help me out fixing this?
Here's the sql:
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 ;
INSERT INTO `admins` VALUES(1, 'admin', 'admin', NULL);
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 ;
INSERT INTO `categories` VALUES(1, 'Admin Features');
INSERT INTO `categories` VALUES(2, 'JV Giveaway Organizer');
DROP TABLE IF EXISTS `check`;
CREATE TABLE IF NOT EXISTS `check` (
`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
`created` datetime default NULL COMMENT 'Creation Time',
`updated` datetime default NULL COMMENT 'Modification Time',
`name` varchar(255) default NULL COMMENT 'JV Giveaway',
`loginlink` varchar(254) default NULL COMMENT 'Login URL',
`login` varchar(255) default NULL COMMENT 'Login',
`pass` varchar(255) default NULL COMMENT 'Password',
`gift` varchar(255) default NULL COMMENT 'Gift',
`landing` varchar(254) default NULL COMMENT 'Landing Page',
`info` tinyint(1) default '0' COMMENT 'Gift Info',
`ecover` tinyint(1) default '0' COMMENT 'eCover',
`subscr` tinyint(1) default '0' COMMENT 'Subscription Message',
`contact` tinyint(1) default '0' COMMENT 'Contact Adress or URL',
`optin` tinyint(1) default '0' COMMENT 'OptIn Form',
`conf` varchar(254) default NULL COMMENT 'Confirmation Page',
`thanks` tinyint(1) default '0' COMMENT 'Thanks You - Message',
`confinstr` tinyint(1) default '0' COMMENT 'Confirmation Instructions',
`whitelist` tinyint(1) default '0' COMMENT 'Whitelist Instructions',
`cont2` tinyint(1) default '0' COMMENT 'Contact Adress or URL',
`special` tinyint(1) default '0' COMMENT 'Special Offer Or Bonus',
`offer` varchar(254) default NULL COMMENT 'Special Offer Page',
`success` tinyint(1) default '0' COMMENT 'Successful Confirmation Message',
`bottom` tinyint(1) default '0' COMMENT 'Link-At-The-Bottom Message',
`special2` tinyint(1) default '0' COMMENT 'Special Offer',
`down` tinyint(1) default '0' COMMENT 'Link To Download Page',
`downlpage` varchar(254) default NULL COMMENT 'Download Page',
`thanks2` tinyint(1) default '0' COMMENT 'Thank You - Message',
`downlinstr` tinyint(1) default '0' COMMENT 'Download Instructions',
`downllink` tinyint(1) default '0' COMMENT 'Download Link',
`cont3` tinyint(1) default '0' COMMENT 'Contact Adress or URL',
`back` tinyint(1) default '0' COMMENT 'Back End Offer Or Bonus',
`ar` varchar(255) default NULL COMMENT 'Autoresponder Address',
`double` tinyint(1) default '0' COMMENT 'Double OptIn',
`follow` tinyint(1) default '0' COMMENT 'Follow-Up Messages',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
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=60 ;
INSERT INTO `fieldsprop` VALUES(1, 'check', 'id', 'ID');
INSERT INTO `fieldsprop` VALUES(2, 'check', 'created', 'Creation Time');
INSERT INTO `fieldsprop` VALUES(3, 'check', 'updated', 'Modification Time');
INSERT INTO `fieldsprop` VALUES(4, 'jv', 'id', 'ID');
INSERT INTO `fieldsprop` VALUES(5, 'jv', 'created', 'Creation Time');
INSERT INTO `fieldsprop` VALUES(6, 'jv', 'updated', 'Modification Time');
INSERT INTO `fieldsprop` VALUES(7, 'check', 'name', 'JV Giveaway');
INSERT INTO `fieldsprop` VALUES(8, 'check', 'loginlink', 'Login URL');
INSERT INTO `fieldsprop` VALUES(9, 'check', 'login', 'Login');
INSERT INTO `fieldsprop` VALUES(10, 'check', 'pass', 'Password');
INSERT INTO `fieldsprop` VALUES(11, 'check', 'gift', 'Gift');
INSERT INTO `fieldsprop` VALUES(12, 'check', 'landing', 'Landing Page');
INSERT INTO `fieldsprop` VALUES(13, 'check', 'info', 'Gift Info');
INSERT INTO `fieldsprop` VALUES(14, 'check', 'ecover', 'eCover');
INSERT INTO `fieldsprop` VALUES(15, 'check', 'subscr', 'Subscription Message');
INSERT INTO `fieldsprop` VALUES(16, 'check', 'contact', 'Contact Adress or URL');
INSERT INTO `fieldsprop` VALUES(17, 'check', 'optin', 'OptIn Form');
INSERT INTO `fieldsprop` VALUES(18, 'check', 'conf', 'Confirmation Page');
INSERT INTO `fieldsprop` VALUES(19, 'check', 'thanks', 'Thanks You - Message');
INSERT INTO `fieldsprop` VALUES(20, 'check', 'confinstr', 'Confirmation Instructions');
INSERT INTO `fieldsprop` VALUES(21, 'check', 'whitelist', 'Whitelist Instructions');
INSERT INTO `fieldsprop` VALUES(22, 'check', 'cont2', 'Contact Adress or URL');
INSERT INTO `fieldsprop` VALUES(23, 'check', 'special', 'Special Offer Or Bonus');
INSERT INTO `fieldsprop` VALUES(24, 'check', 'offer', 'Special Offer Page');
INSERT INTO `fieldsprop` VALUES(25, 'check', 'success', 'Successful Confirmation Message');
INSERT INTO `fieldsprop` VALUES(26, 'check', 'bottom', 'Link-At-The-Bottom Message');
INSERT INTO `fieldsprop` VALUES(27, 'check', 'special2', 'Special Offer');
INSERT INTO `fieldsprop` VALUES(28, 'check', 'down', 'Link To Download Page');
INSERT INTO `fieldsprop` VALUES(29, 'check', 'downlpage', 'Download Page');
INSERT INTO `fieldsprop` VALUES(30, 'check', 'thanks2', 'Thank You - Message');
INSERT INTO `fieldsprop` VALUES(31, 'check', 'downlinstr', 'Download Instructions');
INSERT INTO `fieldsprop` VALUES(32, 'check', 'downllink', 'Download Link');
INSERT INTO `fieldsprop` VALUES(33, 'check', 'cont3', 'Contact Adress or URL');
INSERT INTO `fieldsprop` VALUES(34, 'check', 'back', 'Back End Offer Or Bonus');
INSERT INTO `fieldsprop` VALUES(35, 'check', 'ar', 'Autoresponder Address');
INSERT INTO `fieldsprop` VALUES(36, 'check', 'double', 'Double OptIn');
INSERT INTO `fieldsprop` VALUES(37, 'check', 'follow', 'Follow-Up Messages');
INSERT INTO `fieldsprop` VALUES(38, 'jv', 'jv', 'JV Giveaway');
INSERT INTO `fieldsprop` VALUES(42, 'jv', 'login', 'Login');
INSERT INTO `fieldsprop` VALUES(41, 'jv', 'loginlink', 'Login URL');
INSERT INTO `fieldsprop` VALUES(43, 'jv', 'pass', 'Password');
INSERT INTO `fieldsprop` VALUES(44, 'jv', 'start', 'Start Date');
INSERT INTO `fieldsprop` VALUES(45, 'jv', 'end', 'End Date');
INSERT INTO `fieldsprop` VALUES(46, 'jv', 'refm', 'Refer Members');
INSERT INTO `fieldsprop` VALUES(47, 'jv', 'refp', 'Refer Partners');
INSERT INTO `fieldsprop` VALUES(48, 'jv', 'gift', 'Gift');
INSERT INTO `fieldsprop` VALUES(49, 'jv', 'landing', 'Landing Page');
INSERT INTO `fieldsprop` VALUES(50, 'jv', 'members', 'Number of Referred Members');
INSERT INTO `fieldsprop` VALUES(51, 'jv', 'partners', 'Number of Referred Partners');
INSERT INTO `fieldsprop` VALUES(52, 'jv', 'rank', 'Ranking');
INSERT INTO `fieldsprop` VALUES(53, 'jv', 'visits', 'Number of Visits');
INSERT INTO `fieldsprop` VALUES(54, 'jv', 'signups', 'Number of Signups');
INSERT INTO `fieldsprop` VALUES(55, 'jv', 'ratio1', 'Conversion Ratio (%)');
INSERT INTO `fieldsprop` VALUES(56, 'jv', 'oto', 'OTO');
INSERT INTO `fieldsprop` VALUES(57, 'jv', 'otovisits', 'Number of Visits');
INSERT INTO `fieldsprop` VALUES(58, 'jv', 'otosales', 'Number of Sales');
INSERT INTO `fieldsprop` VALUES(59, 'jv', 'ratio2', 'Conversion Ratio (%)');
DROP TABLE IF EXISTS `jv`;
CREATE TABLE IF NOT EXISTS `jv` (
`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
`created` datetime default NULL COMMENT 'Creation Time',
`updated` datetime default NULL COMMENT 'Modification Time',
`jv` varchar(255) default NULL COMMENT 'JV Giveaway',
`loginlink` varchar(254) default NULL COMMENT 'Login URL',
`login` varchar(255) default NULL COMMENT 'Login',
`pass` varchar(255) default NULL COMMENT 'Password',
`start` date default NULL COMMENT 'Start Date',
`end` date default NULL COMMENT 'End Date',
`refm` varchar(254) default NULL COMMENT 'Refer Members',
`refp` varchar(254) default NULL COMMENT 'Refer Partners',
`gift` varchar(255) default NULL COMMENT 'Gift',
`landing` varchar(254) default NULL COMMENT 'Landing Page',
`members` varchar(255) default NULL COMMENT 'Number of Referred Members',
`partners` varchar(255) default NULL COMMENT 'Number of Referred Partners',
`rank` varchar(255) default NULL COMMENT 'Ranking',
`visits` varchar(255) default NULL COMMENT 'Number of Visits',
`signups` varchar(255) default NULL COMMENT 'Number of Signups',
`ratio1` varchar(255) default NULL COMMENT 'Conversion Ratio (%)',
`oto` varchar(254) default NULL COMMENT 'OTO',
`otovisits` varchar(255) default NULL COMMENT 'Number of Visits',
`otosales` varchar(255) default NULL COMMENT 'Number of Sales',
`ratio2` varchar(255) default NULL COMMENT 'Conversion Ratio (%)',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
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=7 ;
INSERT INTO `scripts` VALUES(1, 'change_password.php', '', 'Change Password', 1, 2);
INSERT INTO `scripts` VALUES(2, 'edit_categories.php', '', 'Edit Categories', 1, 0);
INSERT INTO `scripts` VALUES(3, 'edit_scripts.php', '', 'Edit Features', 1, 0);
INSERT INTO `scripts` VALUES(4, 'logout.php', '', 'Logout', 1, 2);
INSERT INTO `scripts` VALUES(5, 'data_manager.php?i=5', 'check', 'Checklists', 2, 1);
INSERT INTO `scripts` VALUES(6, 'data_manager.php?i=6', 'jv', 'JV Giveaways', 2, 1);
Greetz!
;)
Error
SQL query:
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;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 7
Can someone help me out fixing this?
Here's the sql:
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 ;
INSERT INTO `admins` VALUES(1, 'admin', 'admin', NULL);
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 ;
INSERT INTO `categories` VALUES(1, 'Admin Features');
INSERT INTO `categories` VALUES(2, 'JV Giveaway Organizer');
DROP TABLE IF EXISTS `check`;
CREATE TABLE IF NOT EXISTS `check` (
`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
`created` datetime default NULL COMMENT 'Creation Time',
`updated` datetime default NULL COMMENT 'Modification Time',
`name` varchar(255) default NULL COMMENT 'JV Giveaway',
`loginlink` varchar(254) default NULL COMMENT 'Login URL',
`login` varchar(255) default NULL COMMENT 'Login',
`pass` varchar(255) default NULL COMMENT 'Password',
`gift` varchar(255) default NULL COMMENT 'Gift',
`landing` varchar(254) default NULL COMMENT 'Landing Page',
`info` tinyint(1) default '0' COMMENT 'Gift Info',
`ecover` tinyint(1) default '0' COMMENT 'eCover',
`subscr` tinyint(1) default '0' COMMENT 'Subscription Message',
`contact` tinyint(1) default '0' COMMENT 'Contact Adress or URL',
`optin` tinyint(1) default '0' COMMENT 'OptIn Form',
`conf` varchar(254) default NULL COMMENT 'Confirmation Page',
`thanks` tinyint(1) default '0' COMMENT 'Thanks You - Message',
`confinstr` tinyint(1) default '0' COMMENT 'Confirmation Instructions',
`whitelist` tinyint(1) default '0' COMMENT 'Whitelist Instructions',
`cont2` tinyint(1) default '0' COMMENT 'Contact Adress or URL',
`special` tinyint(1) default '0' COMMENT 'Special Offer Or Bonus',
`offer` varchar(254) default NULL COMMENT 'Special Offer Page',
`success` tinyint(1) default '0' COMMENT 'Successful Confirmation Message',
`bottom` tinyint(1) default '0' COMMENT 'Link-At-The-Bottom Message',
`special2` tinyint(1) default '0' COMMENT 'Special Offer',
`down` tinyint(1) default '0' COMMENT 'Link To Download Page',
`downlpage` varchar(254) default NULL COMMENT 'Download Page',
`thanks2` tinyint(1) default '0' COMMENT 'Thank You - Message',
`downlinstr` tinyint(1) default '0' COMMENT 'Download Instructions',
`downllink` tinyint(1) default '0' COMMENT 'Download Link',
`cont3` tinyint(1) default '0' COMMENT 'Contact Adress or URL',
`back` tinyint(1) default '0' COMMENT 'Back End Offer Or Bonus',
`ar` varchar(255) default NULL COMMENT 'Autoresponder Address',
`double` tinyint(1) default '0' COMMENT 'Double OptIn',
`follow` tinyint(1) default '0' COMMENT 'Follow-Up Messages',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
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=60 ;
INSERT INTO `fieldsprop` VALUES(1, 'check', 'id', 'ID');
INSERT INTO `fieldsprop` VALUES(2, 'check', 'created', 'Creation Time');
INSERT INTO `fieldsprop` VALUES(3, 'check', 'updated', 'Modification Time');
INSERT INTO `fieldsprop` VALUES(4, 'jv', 'id', 'ID');
INSERT INTO `fieldsprop` VALUES(5, 'jv', 'created', 'Creation Time');
INSERT INTO `fieldsprop` VALUES(6, 'jv', 'updated', 'Modification Time');
INSERT INTO `fieldsprop` VALUES(7, 'check', 'name', 'JV Giveaway');
INSERT INTO `fieldsprop` VALUES(8, 'check', 'loginlink', 'Login URL');
INSERT INTO `fieldsprop` VALUES(9, 'check', 'login', 'Login');
INSERT INTO `fieldsprop` VALUES(10, 'check', 'pass', 'Password');
INSERT INTO `fieldsprop` VALUES(11, 'check', 'gift', 'Gift');
INSERT INTO `fieldsprop` VALUES(12, 'check', 'landing', 'Landing Page');
INSERT INTO `fieldsprop` VALUES(13, 'check', 'info', 'Gift Info');
INSERT INTO `fieldsprop` VALUES(14, 'check', 'ecover', 'eCover');
INSERT INTO `fieldsprop` VALUES(15, 'check', 'subscr', 'Subscription Message');
INSERT INTO `fieldsprop` VALUES(16, 'check', 'contact', 'Contact Adress or URL');
INSERT INTO `fieldsprop` VALUES(17, 'check', 'optin', 'OptIn Form');
INSERT INTO `fieldsprop` VALUES(18, 'check', 'conf', 'Confirmation Page');
INSERT INTO `fieldsprop` VALUES(19, 'check', 'thanks', 'Thanks You - Message');
INSERT INTO `fieldsprop` VALUES(20, 'check', 'confinstr', 'Confirmation Instructions');
INSERT INTO `fieldsprop` VALUES(21, 'check', 'whitelist', 'Whitelist Instructions');
INSERT INTO `fieldsprop` VALUES(22, 'check', 'cont2', 'Contact Adress or URL');
INSERT INTO `fieldsprop` VALUES(23, 'check', 'special', 'Special Offer Or Bonus');
INSERT INTO `fieldsprop` VALUES(24, 'check', 'offer', 'Special Offer Page');
INSERT INTO `fieldsprop` VALUES(25, 'check', 'success', 'Successful Confirmation Message');
INSERT INTO `fieldsprop` VALUES(26, 'check', 'bottom', 'Link-At-The-Bottom Message');
INSERT INTO `fieldsprop` VALUES(27, 'check', 'special2', 'Special Offer');
INSERT INTO `fieldsprop` VALUES(28, 'check', 'down', 'Link To Download Page');
INSERT INTO `fieldsprop` VALUES(29, 'check', 'downlpage', 'Download Page');
INSERT INTO `fieldsprop` VALUES(30, 'check', 'thanks2', 'Thank You - Message');
INSERT INTO `fieldsprop` VALUES(31, 'check', 'downlinstr', 'Download Instructions');
INSERT INTO `fieldsprop` VALUES(32, 'check', 'downllink', 'Download Link');
INSERT INTO `fieldsprop` VALUES(33, 'check', 'cont3', 'Contact Adress or URL');
INSERT INTO `fieldsprop` VALUES(34, 'check', 'back', 'Back End Offer Or Bonus');
INSERT INTO `fieldsprop` VALUES(35, 'check', 'ar', 'Autoresponder Address');
INSERT INTO `fieldsprop` VALUES(36, 'check', 'double', 'Double OptIn');
INSERT INTO `fieldsprop` VALUES(37, 'check', 'follow', 'Follow-Up Messages');
INSERT INTO `fieldsprop` VALUES(38, 'jv', 'jv', 'JV Giveaway');
INSERT INTO `fieldsprop` VALUES(42, 'jv', 'login', 'Login');
INSERT INTO `fieldsprop` VALUES(41, 'jv', 'loginlink', 'Login URL');
INSERT INTO `fieldsprop` VALUES(43, 'jv', 'pass', 'Password');
INSERT INTO `fieldsprop` VALUES(44, 'jv', 'start', 'Start Date');
INSERT INTO `fieldsprop` VALUES(45, 'jv', 'end', 'End Date');
INSERT INTO `fieldsprop` VALUES(46, 'jv', 'refm', 'Refer Members');
INSERT INTO `fieldsprop` VALUES(47, 'jv', 'refp', 'Refer Partners');
INSERT INTO `fieldsprop` VALUES(48, 'jv', 'gift', 'Gift');
INSERT INTO `fieldsprop` VALUES(49, 'jv', 'landing', 'Landing Page');
INSERT INTO `fieldsprop` VALUES(50, 'jv', 'members', 'Number of Referred Members');
INSERT INTO `fieldsprop` VALUES(51, 'jv', 'partners', 'Number of Referred Partners');
INSERT INTO `fieldsprop` VALUES(52, 'jv', 'rank', 'Ranking');
INSERT INTO `fieldsprop` VALUES(53, 'jv', 'visits', 'Number of Visits');
INSERT INTO `fieldsprop` VALUES(54, 'jv', 'signups', 'Number of Signups');
INSERT INTO `fieldsprop` VALUES(55, 'jv', 'ratio1', 'Conversion Ratio (%)');
INSERT INTO `fieldsprop` VALUES(56, 'jv', 'oto', 'OTO');
INSERT INTO `fieldsprop` VALUES(57, 'jv', 'otovisits', 'Number of Visits');
INSERT INTO `fieldsprop` VALUES(58, 'jv', 'otosales', 'Number of Sales');
INSERT INTO `fieldsprop` VALUES(59, 'jv', 'ratio2', 'Conversion Ratio (%)');
DROP TABLE IF EXISTS `jv`;
CREATE TABLE IF NOT EXISTS `jv` (
`id` int(11) unsigned NOT NULL auto_increment COMMENT 'ID',
`created` datetime default NULL COMMENT 'Creation Time',
`updated` datetime default NULL COMMENT 'Modification Time',
`jv` varchar(255) default NULL COMMENT 'JV Giveaway',
`loginlink` varchar(254) default NULL COMMENT 'Login URL',
`login` varchar(255) default NULL COMMENT 'Login',
`pass` varchar(255) default NULL COMMENT 'Password',
`start` date default NULL COMMENT 'Start Date',
`end` date default NULL COMMENT 'End Date',
`refm` varchar(254) default NULL COMMENT 'Refer Members',
`refp` varchar(254) default NULL COMMENT 'Refer Partners',
`gift` varchar(255) default NULL COMMENT 'Gift',
`landing` varchar(254) default NULL COMMENT 'Landing Page',
`members` varchar(255) default NULL COMMENT 'Number of Referred Members',
`partners` varchar(255) default NULL COMMENT 'Number of Referred Partners',
`rank` varchar(255) default NULL COMMENT 'Ranking',
`visits` varchar(255) default NULL COMMENT 'Number of Visits',
`signups` varchar(255) default NULL COMMENT 'Number of Signups',
`ratio1` varchar(255) default NULL COMMENT 'Conversion Ratio (%)',
`oto` varchar(254) default NULL COMMENT 'OTO',
`otovisits` varchar(255) default NULL COMMENT 'Number of Visits',
`otosales` varchar(255) default NULL COMMENT 'Number of Sales',
`ratio2` varchar(255) default NULL COMMENT 'Conversion Ratio (%)',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
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=7 ;
INSERT INTO `scripts` VALUES(1, 'change_password.php', '', 'Change Password', 1, 2);
INSERT INTO `scripts` VALUES(2, 'edit_categories.php', '', 'Edit Categories', 1, 0);
INSERT INTO `scripts` VALUES(3, 'edit_scripts.php', '', 'Edit Features', 1, 0);
INSERT INTO `scripts` VALUES(4, 'logout.php', '', 'Logout', 1, 2);
INSERT INTO `scripts` VALUES(5, 'data_manager.php?i=5', 'check', 'Checklists', 2, 1);
INSERT INTO `scripts` VALUES(6, 'data_manager.php?i=6', 'jv', 'JV Giveaways', 2, 1);
Greetz!
;)