Subversion Repositories cheapmusic

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
155 - 1 
--
2 
-- Seo Panel 3.8.0 changes
3 
--
4 
 
5 
--
6 
-- Table structure for table `currency`
7 
--
8 
 
9 
CREATE TABLE IF NOT EXISTS `currency` (
10 
  `id` int(11) NOT NULL AUTO_INCREMENT,
11 
  `name` varchar(160) COLLATE utf8_unicode_ci NOT NULL,
12 
  `iso_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
13 
  `symbol` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
14 
  `unicode` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
15 
  `position` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
16 
  `paypal` tinyint(1) NOT NULL DEFAULT '0',
17 
  `status` tinyint(1) NOT NULL DEFAULT '1',
18 
  PRIMARY KEY (`id`),
19 
  UNIQUE KEY `iso_code` (`iso_code`)
20 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=68 ;
21 
 
22 
--
23 
-- Dumping data for table `currency`
24 
--
25 
 
26 
INSERT INTO `currency` (`id`, `name`, `iso_code`, `symbol`, `unicode`, `position`, `paypal`, `status`) VALUES
27 
(1, 'United Arab Emirates Dirham', 'AED', 'د.إ', '', 'after', 0, 1),
28 
(2, 'Netherlands Antillian Guilder', 'ANG', 'Æ’', 'ƒ', 'before', 0, 1),
29 
(3, '', 'AOA', 'AOA', 'AOA', 'before', 0, 1),
30 
(4, 'Argentine Peso', 'ARS', '$', '$', 'before', 0, 1),
31 
(5, 'Australian Dollar', 'AUD', '$', '$', 'before', 1, 1),
32 
(6, '', 'BAM', 'KM', 'KM', 'before', 0, 1),
33 
(7, 'Barbados Dollar', 'BBD', '$', '$', 'before', 0, 1),
34 
(8, '', 'BGL', 'лв', 'л&', 'before', 0, 1),
35 
(9, 'Bahraini Dinar', 'BHD', 'BD', 'BD', 'after', 0, 1),
36 
(10, 'Brunei Dollar', 'BND', '$', '$', 'before', 0, 1),
37 
(11, 'Brazilian Real', 'BRL', 'R$', 'R$', 'before', 1, 1),
38 
(12, 'Canadian Dollar', 'CAD', '$', '$', 'before', 1, 1),
39 
(13, 'Swiss Franc', 'CHF', 'Fr', 'Fr', 'before', 1, 1),
40 
(14, 'Chilean Unidades de Fomento', 'CLF', 'UF', 'UF', 'after', 0, 1),
41 
(15, 'Chilean Peso', 'CLP', '$', '$', 'before', 0, 1),
42 
(16, 'Yuan (Chinese) Renminbi', 'CNY', '¥', '¥', 'before', 0, 1),
43 
(17, 'Colombian Peso', 'COP', '$', '$', 'before', 0, 1),
44 
(18, 'Costa Rican Colon', 'CRC', 'â‚¡', '₡', 'before', 0, 1),
45 
(19, 'Czech Republic Koruna', 'CZK', 'Kč', 'Kč', 'after', 1, 1),
46 
(20, 'Danish Krone', 'DKK', 'kr', 'kr', 'before', 1, 1),
47 
(21, 'Estonian Kroon (EEK)', 'EEK', 'KR', 'KR', 'before', 0, 1),
48 
(22, 'Egyptian Pound', 'EGP', 'E£', 'E£', 'before', 0, 1),
49 
(23, 'Euro', 'EUR', '€', '€', 'before', 1, 1),
50 
(24, 'Fiji Dollar', 'FJD', 'FJ$', 'FJ$', 'before', 0, 1),
51 
(25, 'British Pound', 'GBP', '£', '£', 'before', 1, 1),
52 
(26, 'Guatemalan Quetzal', 'GTQ', 'Q', 'Q', 'before', 0, 1),
53 
(27, 'Hong Kong Dollar', 'HKD', '$', '$', 'before', 1, 1),
54 
(28, '', 'HRK', 'kn', 'kn', 'before', 0, 1),
55 
(29, 'Hungarian Forint', 'HUF', 'Ft', 'Ft', 'before', 1, 1),
56 
(30, 'Indonesian Rupiah', 'IDR', 'Rp', 'Rp', 'before', 0, 1),
57 
(31, 'Israeli Shekel', 'ILS', '₪', '₪', 'before', 1, 1),
58 
(32, 'Indian Rupee', 'INR', 'Rs', 'Rs', 'before', 0, 1),
59 
(33, 'Jordanian Dinar', 'JOD', 'د.ا', '', '', 0, 1),
60 
(34, 'Japanese Yen', 'JPY', '¥', '¥', 'before', 1, 1),
61 
(35, 'Kenyan Schilling', 'KES', 'KSh', 'Ksh', 'before', 0, 1),
62 
(36, '(South) Korean Won', 'KRW', 'â‚©', '₩', 'before', 0, 1),
63 
(37, 'Kuwaiti Dinar', 'KWD', 'KD', 'KD', 'after', 0, 1),
64 
(38, 'Cayman Islands Dollar', 'KYD', '$', '$', 'before', 0, 1),
65 
(39, '', 'LTL', 'Lt', 'Lt', 'before', 0, 1),
66 
(40, '', 'LVL', 'Ls', 'Ls', 'before', 0, 1),
67 
(41, 'Moroccan Dirham', 'MAD', 'د.م', '', '', 0, 1),
68 
(42, 'Maldive Rufiyaa', 'MVR', 'Rf', 'Rf', 'before', 0, 1),
69 
(43, '', 'MXN', '$', '$', 'before', 1, 1),
70 
(44, 'Malaysian Ringgit', 'MYR', 'RM', 'RM', 'before', 1, 1),
71 
(45, 'Nigerian Naira', 'NGN', '₦', '₦', 'before', 0, 1),
72 
(46, 'Norwegian Kroner', 'NOK', 'kr', 'kr', 'before', 1, 1),
73 
(47, 'New Zealand Dollar', 'NZD', '$', '$', 'before', 1, 1),
74 
(48, 'Omani Rial', 'OMR', 'OMR', '﷼', 'after', 0, 1),
75 
(49, 'Peruvian Nuevo Sol', 'PEN', 'S/.', 'S/.', 'before', 0, 1),
76 
(50, 'Philippine Peso', 'PHP', '₱', '₱', 'before', 1, 1),
77 
(51, 'Polish Zloty', 'PLN', 'zł', 'Zł', 'before', 1, 1),
78 
(52, 'Qatari Rial', 'QAR', 'QAR', '﷼', 'after', 0, 1),
79 
(53, 'Romanian Leu', 'RON', 'lei', 'lei', 'before', 0, 1),
80 
(54, 'Russian Ruble', 'RUB', 'руб', 'р&', 'before', 1, 1),
81 
(55, 'Saudi Arabian Riyal', 'SAR', 'SAR', '﷼', 'after', 0, 1),
82 
(56, 'Swedish Krona', 'SEK', 'kr', 'kr', 'before', 1, 1),
83 
(57, 'Singapore Dollar', 'SGD', '$', '$', 'before', 1, 1),
84 
(58, 'Thai Baht', 'THB', '฿', 'ł', 'before', 1, 1),
85 
(59, 'Turkish Lira', 'TRY', 'TL', 'TL', 'before', 1, 1),
86 
(60, 'Trinidad and Tobago Dollar', 'TTD', '$', '$', 'before', 0, 1),
87 
(61, 'Taiwan Dollar', 'TWD', '$', '$', 'before', 0, 1),
88 
(62, '', 'UAH', 'â‚´', '₴', 'before', 0, 1),
89 
(63, 'US Dollar', 'USD', '$', '$', 'before', 1, 1),
90 
(64, 'Venezualan Bolivar', 'VEF', 'Bs ', 'Bs.', 'before', 0, 1),
91 
(65, 'Vietnamese Dong', 'VND', 'â‚«', '₫', 'before', 0, 1),
92 
(66, 'East Caribbean Dollar', 'XCD', '$', '$', 'before', 0, 1),
93 
(67, 'South African Rand', 'ZAR', 'R', 'R', 'before', 0, 1);
94 
 
95 
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`)
96 
VALUES ('Currency', 'SP_PAYMENT_CURRENCY', 'USD', 'system', 'medium', '1');
97 
 
98 
--
99 
-- Table structure for table `user_specs`
100 
--
101 
 
102 
CREATE TABLE IF NOT EXISTS `user_specs` (
103 
`id` int(11) NOT NULL,
104 
  `user_type_id` int(11) NOT NULL,
105 
  `spec_column` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
106 
  `spec_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL
107 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
108 
 
109 
--
110 
-- Indexes for table `user_specs`
111 
--
112 
ALTER TABLE `user_specs`
113 
 ADD PRIMARY KEY (`id`);
114 
 
115 
--
116 
-- AUTO_INCREMENT for table `user_specs`
117 
--
118 
ALTER TABLE `user_specs`
119 
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
120 
 
121 
alter table usertypes add column status tinyint(4) default 1;
122 
insert into user_specs(user_type_id,spec_column,spec_value) values (2,'keywordcount',50),(2,'websitecount',10),(2,'price',0);
123 
 
124 
ALTER TABLE `backlinkresults` ADD `id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
125 
ALTER TABLE `keywordcrontracker` ADD `id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
126 
ALTER TABLE `searchresultdetails` ADD `id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
127 
ALTER TABLE `rankresults` ADD `id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
128 
ALTER TABLE `saturationresults` ADD `id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
129 
 
130 
ALTER TABLE `users` ADD `expiry_date` DATE NULL DEFAULT NULL ;
131 
 
132 
UPDATE `searchengines` SET `regex` = '<li.*?class="?g.*?><h3 class="r"><a href="\\/url\\?q=(.*?)&amp;sa=U.*?>(.*?)<\\/a>.*?<\\/div><span.*?>(.*?)<\\/span>'  WHERE `url` LIKE '%google%';
133 
 
134 
delete from featured_directories where id in (2,3);