Skocz do zawartości

  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • ✅ Pełny dostęp do działów i ukrytych treści
    • ✅ Możliwość pisania i odpowiadania w tematach
    • ✅ System prywatnych wiadomości
    • ✅ Zbieranie reputacji i rozwijanie swojego profilu
    • ✅ Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

Problem z zapytaniem SQL

Exxon

Przez Exxon
w Metin2 - Tworzenie serwerów prywatnych

Rekomendowane odpowiedzi

Exxon Uczeń

Exxon

Opublikowano
Uczeń

Exxon

Opublikowano

Witam posiadam strone starą od kongo chce dodać tabelki zapytaniem poniżej ale tabelki mi nie robi jak baza nazywa sie Site a jak dam Site1  to działa jak przeniosę to tabelki się psują.. pomoże ktoś ?

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50521
Source Host           : localhost:3306
Source Database       : site

Target Server Type    : MYSQL
Target Server Version : 50521
File Encoding         : 65001

Date: 2014-11-17 18:51:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `banneds`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Banneds` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Acc_Id` int(11) NOT NULL,
  `By` int(11) NOT NULL,
  `When` datetime NOT NULL,
  `To` datetime NOT NULL,
  `Why` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of banneds
-- ----------------------------

-- ----------------------------
-- Table structure for `cashbill_used`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `cashbill_used` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(255) COLLATE utf8_bin NOT NULL,
  `UsedBy` varchar(255) COLLATE utf8_bin NOT NULL,
  `UsedWhen` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cashbill_used
-- ----------------------------


-- ----------------------------
-- Table structure for `events`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Events` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `When` datetime NOT NULL,
  `FinishAt` datetime NOT NULL,
  `Description` text COLLATE utf8_bin NOT NULL,
  `By` varchar(20) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for `is_log`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `is_log` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ItemId` int(11) NOT NULL,
  `AccountId` int(11) NOT NULL,
  `Left` int(11) NOT NULL,
  `When` datetime NOT NULL,
  `Success` int(1) NOT NULL,
  `IP` varchar(15) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of is_log
-- ----------------------------

-- ----------------------------
-- Table structure for `itemshop_items`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `ItemShop_items` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Menu_ID` int(11) NOT NULL,
  `Name` varchar(100) COLLATE utf8_bin NOT NULL,
  `Content` text COLLATE utf8_bin NOT NULL,
  `Cena` int(11) NOT NULL,
  `Item_ID` int(100) DEFAULT NULL,
  `count` int(100) DEFAULT NULL,
  `imagepath` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `Buys` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- ----------------------------
-- Table structure for `itemshop_menu`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `ItemShop_menu` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for `news`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `news` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `tytul` varchar(100) COLLATE utf8_bin NOT NULL,
  `tresc` text COLLATE utf8_bin NOT NULL,
  `autor` varchar(100) COLLATE utf8_bin NOT NULL,
  `data` datetime NOT NULL,
  `edited` datetime DEFAULT NULL,
  `editedby` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for `packages`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Packages` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) COLLATE utf8_bin NOT NULL,
  `Options` varchar(255) COLLATE utf8_bin NOT NULL,
  `PackageOn` int(11) NOT NULL,
  `Cena` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of packages
-- ----------------------------

-- ----------------------------
-- Table structure for `przelew`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Przelew` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Kod` varchar(100) NOT NULL,
  `Wartosc` int(11) NOT NULL,
  `Monety` int(11) NOT NULL,
  `Wykorzystany` int(255) NOT NULL DEFAULT '0',
  `Kiedy` datetime DEFAULT NULL,
  `Przez` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of przelew
-- ----------------------------

-- ----------------------------
-- Table structure for `sm_log`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `SM_log` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Kod` varchar(15) COLLATE utf8_bin DEFAULT NULL,
  `Wartosc` float NOT NULL,
  `Kto` int(11) NOT NULL,
  `Kiedy` datetime NOT NULL,
  `Przez` enum('Przelew','SMS','PayPal') COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of sm_log
-- ----------------------------

-- ----------------------------
-- Table structure for `support`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Support` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Who` varchar(100) COLLATE utf8_bin NOT NULL,
  `Title` varchar(100) COLLATE utf8_bin NOT NULL,
  `Content` text COLLATE utf8_bin NOT NULL,
  `IP` varchar(100) COLLATE utf8_bin NOT NULL,
  `When` datetime NOT NULL,
  `Open` enum('True','False') COLLATE utf8_bin NOT NULL,
  `Last_answer` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of support
-- ----------------------------

-- ----------------------------
-- Table structure for `support_answers`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Support_answers` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Ticket_Id` int(11) NOT NULL,
  `Who` varchar(100) COLLATE utf8_bin NOT NULL,
  `Content` text COLLATE utf8_bin NOT NULL,
  `When` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of support_answers
-- ----------------------------

-- ----------------------------
-- Table structure for `traffic`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `Traffic` (
  `IP` varchar(15) COLLATE utf8_bin NOT NULL,
  `Income_Date` datetime NOT NULL,
  `LastTime_Date` datetime NOT NULL,
  `Shows` int(11) NOT NULL,
  `AccountId` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


ALTER TABLE account.account ADD `confirmedtoken` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `email`;
ALTER TABLE account.account ADD `coins` int( 100 ) NOT NULL DEFAULT 0 AFTER `cash`; 
UPDATE account.account SET confirmedtoken=MD5(login); 
ALTER TABLE account.account ADD `actived` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'Y' AFTER `email`;
ALTER TABLE account.account ADD `passres_time` int(11) NOT NULL DEFAULT 0 AFTER `actived`;
ALTER TABLE account.account ADD `changeon` varchar ( 50 ) CHARACTER SET utf8 COLLATE `utf8_bin` NOT NULL DEFAULT '';
ALTER TABLE account.account ADD `changeemail` int (11) NOT NULL DEFAULT 0;

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

Tematy
×
×
  • Dodaj nową pozycję...