#
# Table Data for `prefixas_admin`
#
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (1, 'AD', 'admins.gif', 'Administratoriai', 'administrators.php', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (2, 'AC', 'article_cats.gif', 'Straipsniø kategorijos', 'article_cats.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (3, 'A', 'articles.gif', 'Straipsniai', 'articles.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (4, 'B', 'blacklist.gif', 'Juodasis sàraðas', 'blacklist.php', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (5, 'C', '', 'Komentarai', 'reserved', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (6, 'CP', 'c-pages.gif', 'Pridëtiniai puslapiai', 'custom_pages.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (7, 'DB', 'db_backup.gif', 'Duombazës kopijos', 'db_backup.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (8, 'DC', 'dl_cats.gif', 'Siuntimø kategorijos', 'download_cats.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (9, 'D', 'dl.gif', 'Siuntimai', 'downloads.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (10, 'FQ', 'faq.gif', 'DUK', 'faq.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (11, 'F', 'forums.gif', 'Forumai', 'forums.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (12, 'IM', 'images.gif', 'Paveikslëliai', 'images.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (13, 'I', 'infusions.gif', 'Modifikacijos', 'infusions.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (14, 'IP', '', 'Modifikacijø panelës', 'reserved', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (15, 'M', 'members.gif', 'Nariai', 'members.php', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (16, 'N', 'news.gif', 'Naujienos', 'news.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (17, 'NC', 'news_cats.gif', 'Naujienø kategorijos', 'news_cats.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (18, 'P', 'panels.gif', 'Panelës', 'panels.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (19, 'PH', 'photoalbums.gif', 'Foto albumai', 'photoalbums.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (20, 'PI', 'phpinfo.gif', 'PHP Info', 'phpinfo.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (21, 'PO', 'polls.gif', 'Apklausos', 'polls.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (22, 'S', 'shout.gif', 'Ðaukykla', 'shoutbox.php', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (23, 'SL', 'site_links.gif', 'Tinklapio nuorodos', 'site_links.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (24, 'SU', 'submissions.gif', 'Pateikimai', 'submissions.php', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (25, 'U', 'upgrade.gif', 'Atnaujinimas', 'upgrade.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (26, 'UG', 'user_groups.gif', 'Vartotojø grupës', 'user_groups.php', 2);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (27, 'WC', 'wl_cats.gif', 'Web nuorodø kategorijos', 'weblink_cats.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (28, 'W', 'wl.gif', 'Web nuorodos', 'weblinks.php', 1);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (29, 'S1', 'settings.gif', 'Pagrindiniai nustatymai', 'settings_main.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (30, 'S2', 'settings_time.gif', 'Datos ir laiko nustatymai', 'settings_time.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (31, 'S3', 'settings_forum.gif', 'Forumo nustatymai', 'settings_forum.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (32, 'S4', 'registration.gif', 'Registracijos nustatymai', 'settings_registration.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (33, 'S5', 'photoalbums.gif', 'Foto galerijos nustatymai', 'settings_photo.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (34, 'S6', 'settings_misc.gif', 'Ávairûs nustatymai', 'settings_misc.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (35, 'S7', 'settings_pm.gif', 'Asmeniniø þinuèiø nustatymai', 'settings_messages.php', 3);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (38, 'IP', 'user_gold.gif', 'User Gold', '../infusions/user_gold_panel/admin/index.php', 4);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (37, 'IP', 'infusion_panel.gif', 'Usergalerie', '../infusions/usergalerie/settings.php', 4);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (39, 'IP', 'infusion_panel.gif', 'SF Gift System', '../infusions/sf_gift_system/admin.php', 4);
INSERT INTO `prefixas_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES (40, 'IP', 'infusion_panel.gif', '', '../infusions/admin_pm_count/admin_pm_count.php', 4);
Error
SQL query:
--
-- Database: `friends`
--
-- --------------------------------------------------------
--
-- Table structure for table `fusion_admin`
--
CREATE TABLE `fusion_admin` (
`admin_id` tinyint( 2 ) unsigned NOT NULL AUTO_INCREMENT ,
`admin_rights` char( 2 ) COLLATE utf8_lithuanian_ci NOT NULL default '',
`admin_image` varchar( 50 ) COLLATE utf8_lithuanian_ci NOT NULL default '',
`admin_title` varchar( 50 ) COLLATE utf8_lithuanian_ci NOT NULL default '',
`admin_link` varchar( 100 ) COLLATE utf8_lithuanian_ci NOT NULL default 'reserved',
`admin_page` tinyint( 1 ) unsigned NOT NULL default '1',
PRIMARY KEY ( `admin_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_lithuanian_ci AUTO_INCREMENT =39;
MySQL said: Documentation
#1050 - Table 'fusion_admin' already exists
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: mysql2.bendras.com
-- Generation Time: Dec 28, 2007 at 03:27 PM
-- Server version: 5.0.32
-- PHP Version: 5.2.2-2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `friends`
--
-- --------------------------------------------------------
--
-- Table structure for table `fusion_admin`
--
CREATE TABLE `fusion_admin` (
`admin_id` tinyint(2) unsigned NOT NULL auto_increment,
`admin_rights` char(2) collate utf8_lithuanian_ci NOT NULL default '',
`admin_image` varchar(50) collate utf8_lithuanian_ci NOT NULL default '',
`admin_title` varchar(50) collate utf8_lithuanian_ci NOT NULL default '',
`admin_link` varchar(100) collate utf8_lithuanian_ci NOT NULL default 'reserved',
`admin_page` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci AUTO_INCREMENT=39 ;
--
-- Dumping data for table `fusion_admin`
--
INSERT INTO `fusion_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES
(1, 'AD', 'admins.gif', 'Administratoriai', 'administrators.php', 2),
(2, 'AC', 'article_cats.gif', 'Straipsniø kategorijos', 'article_cats.php', 1),
(3, 'A', 'articles.gif', 'Straipsniai', 'articles.php', 1),
(4, 'B', 'blacklist.gif', 'Juodasis sàraðas', 'blacklist.php', 2),
(5, 'C', '', 'Comments', 'reserved', 2),
(6, 'CP', 'c-pages.gif', 'Pridëtiniai puslapiai', 'custom_pages.php', 1),
(7, 'DB', 'db_backup.gif', 'Duomenø bazës atsarginës kopijos', 'db_backup.php', 3),
(8, 'DC', 'dl_cats.gif', 'Siuntimø kategorijos', 'download_cats.php', 1),
(9, 'D', 'dl.gif', 'Siuntimai', 'downloads.php', 1),
(10, 'FQ', 'faq.gif', 'DUK <br> (<i>Daþnausiai uþduodami klausimai</i>)', 'faq.php', 1),
(11, 'F', 'forums.gif', 'Forumai', 'forums.php', 1),
(12, 'IM', 'images.gif', 'Paveiksliukai', 'images.php', 1),
(13, 'I', 'infusions.gif', 'Modifikacijos', 'infusions.php', 3),
(14, 'IP', '', 'Infusion Panels', 'reserved', 3),
(15, 'M', 'members.gif', 'Vartotojai', 'members.php', 2),
(16, 'N', 'news.gif', 'Naujienos', 'news.php', 1),
(17, 'NC', 'news_cats.gif', 'Naujienø kategorijos', 'news_cats.php', 1),
(18, 'P', 'panels.gif', 'Panelës', 'panels.php', 3),
(19, 'PH', 'photoalbums.gif', 'Foto albumai', 'photoalbums.php', 1),
(20, 'PI', 'phpinfo.gif', 'PHP info', 'phpinfo.php', 3),
(21, 'PO', 'polls.gif', 'Apklausos', 'polls.php', 1),
(22, 'S', 'shout.gif', 'Ðaukykla', 'shoutbox.php', 2),
(23, 'SL', 'site_links.gif', 'Tinklapio nuorodos', 'site_links.php', 3),
(24, 'SU', 'submissions.gif', 'Pateikimai', 'submissions.php', 2),
(25, 'U', 'upgrade.gif', 'Tinklapio atnaujinimas', 'upgrade.php', 3),
(26, 'UG', 'user_groups.gif', 'Vartotojø grupës', 'user_groups.php', 2),
(27, 'WC', 'wl_cats.gif', 'Web nuorodø kategorijos', 'weblink_cats.php', 1),
(28, 'W', 'wl.gif', 'Web nuorodos', 'weblinks.php', 1),
(29, 'S1', 'settings.gif', 'PAGRINDINIAI TINKLAPIO NUSTATYMAI', 'settings_main.php', 3),
(30, 'S2', 'settings_time.gif', 'Datos ir laiko nustatymai', 'settings_time.php', 3),
(31, 'S3', 'settings_forum.gif', 'Forumo nustatymai', 'settings_forum.php', 3),
(32, 'S4', 'registration.gif', 'Registracijos nustatymai', 'settings_registration.php', 3),
(33, 'S5', 'photoalbums.gif', 'Foto galerijos nustatymai', 'settings_photo.php', 3),
(34, 'S6', 'settings_misc.gif', 'Ávairûs nustatymai', 'settings_misc.php', 3),
(35, 'S7', 'settings_pm.gif', 'Asmeniniø þinuèiø savybës', 'settings_messages.php', 3);
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: mysql2.bendras.com
-- Generation Time: Dec 28, 2007 at 03:53 PM
-- Server version: 5.0.32
-- PHP Version: 5.2.2-2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `friends`
--
-- --------------------------------------------------------
--
-- Table structure for table `fusion_admin`
--
CREATE TABLE `fusion_admin` (
`admin_id` tinyint(2) unsigned NOT NULL auto_increment,
`admin_rights` char(2) collate utf8_lithuanian_ci NOT NULL default '',
`admin_image` varchar(50) collate utf8_lithuanian_ci NOT NULL default '',
`admin_title` varchar(50) collate utf8_lithuanian_ci NOT NULL default '',
`admin_link` varchar(100) collate utf8_lithuanian_ci NOT NULL default 'reserved',
`admin_page` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci AUTO_INCREMENT=39 ;
--
-- Dumping data for table `fusion_admin`
--
INSERT INTO `fusion_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES
(1, 'AD', 'admins.gif', 'Administratoriai', 'administrators.php', 2),
(2, 'AC', 'article_cats.gif', 'Straipsniø kategorijos', 'article_cats.php', 1),
(3, 'A', 'articles.gif', 'Straipsniai', 'articles.php', 1),
(4, 'B', 'blacklist.gif', 'Juodasis sàraðas', 'blacklist.php', 2),
(5, 'C', '', 'Comments', 'reserved', 2),
(6, 'CP', 'c-pages.gif', 'Pridëtiniai puslapiai', 'custom_pages.php', 1),
(7, 'DB', 'db_backup.gif', 'Duomenø bazës atsarginës kopijos', 'db_backup.php', 3),
(8, 'DC', 'dl_cats.gif', 'Siuntimø kategorijos', 'download_cats.php', 1),
(9, 'D', 'dl.gif', 'Siuntimai', 'downloads.php', 1),
(10, 'FQ', 'faq.gif', 'DUK <br> (<i>Daþnausiai uþduodami klausimai</i>)', 'faq.php', 1),
(11, 'F', 'forums.gif', 'Forumai', 'forums.php', 1),
(12, 'IM', 'images.gif', 'Paveiksliukai', 'images.php', 1),
(13, 'I', 'infusions.gif', 'Modifikacijos', 'infusions.php', 3),
(14, 'IP', '', 'Infusion Panels', 'reserved', 3),
(15, 'M', 'members.gif', 'Vartotojai', 'members.php', 2),
(16, 'N', 'news.gif', 'Naujienos', 'news.php', 1),
(17, 'NC', 'news_cats.gif', 'Naujienø kategorijos', 'news_cats.php', 1),
(18, 'P', 'panels.gif', 'Panelës', 'panels.php', 3),
(19, 'PH', 'photoalbums.gif', 'Foto albumai', 'photoalbums.php', 1),
(20, 'PI', 'phpinfo.gif', 'PHP info', 'phpinfo.php', 3),
(21, 'PO', 'polls.gif', 'Apklausos', 'polls.php', 1),
(22, 'S', 'shout.gif', 'Ðaukykla', 'shoutbox.php', 2),
(23, 'SL', 'site_links.gif', 'Tinklapio nuorodos', 'site_links.php', 3),
(24, 'SU', 'submissions.gif', 'Pateikimai', 'submissions.php', 2),
(25, 'U', 'upgrade.gif', 'Tinklapio atnaujinimas', 'upgrade.php', 3),
(26, 'UG', 'user_groups.gif', 'Vartotojø grupës', 'user_groups.php', 2),
(27, 'WC', 'wl_cats.gif', 'Web nuorodø kategorijos', 'weblink_cats.php', 1),
(28, 'W', 'wl.gif', 'Web nuorodos', 'weblinks.php', 1),
(29, 'S1', 'settings.gif', 'PAGRINDINIAI TINKLAPIO NUSTATYMAI', 'settings_main.php', 3),
(30, 'S2', 'settings_time.gif', 'Datos ir laiko nustatymai', 'settings_time.php', 3),
(31, 'S3', 'settings_forum.gif', 'Forumo nustatymai', 'settings_forum.php', 3),
(32, 'S4', 'registration.gif', 'Registracijos nustatymai', 'settings_registration.php', 3),
(33, 'S5', 'photoalbums.gif', 'Foto galerijos nustatymai', 'settings_photo.php', 3),
(34, 'S6', 'settings_misc.gif', 'Ávairûs nustatymai', 'settings_misc.php', 3),
(35, 'S7', 'settings_pm.gif', 'Asmeniniø þinuèiø savybës', 'settings_messages.php', 3),
(36, 'ME', 'meeting.gif', 'Susipaþinimo valdymas', 'meeting.php', 1),
(37, 'ME', 'meeting.gif', 'Susipaþinimo valdymas', 'meeting.php', 1),
(38, 'ME', 'meeting.gif', 'Susipaþinimo valdymas', 'meeting.php', 1);