Offline |
|
|
Csatlakozott: 2018.11.02. 12:23 Hozzászólások: 148
Megköszönt másnak: 2 alkalommal Megköszönték neki: 19 alkalommal
|
Így szerintem kényelmesebb, mert ha nem 11 karakter, akkor gáz van CREATE TABLE Teszt ( ID INT NOT NULL AUTO_INCREMENT, XY VARCHAR(255) NOT NULL, YX VARCHAR(255), XYZ INT, PRIMARY KEY (ID) );
✪ BeNiCh' írta: Szia. -- phpMyAdmin SQL Dump -- version 4.2.12deb2+deb8u2 -- http://www.phpmyadmin.net -- -- Hoszt: localhost -- Létrehozás ideje: 2016. Okt 31. 08:19 -- Szerver verzió: 5.5.52-0+deb8u1 -- PHP verzió: 5.6.27-0+deb8u1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Adatbázis: `exodus_go_2017` -- -- -------------------------------------------------------- -- -- Tábla szerkezet ehhez a táblához `exodus_go_2017` -- CREATE TABLE IF NOT EXISTS `exodus_go_2017` ( `Id` INT(11) NOT NULL, `Felhasznalonev` VARCHAR(32) NOT NULL, `Jelszo` VARCHAR(32) NOT NULL, `Email` VARCHAR(32) NOT NULL, `Jatekosnev` VARCHAR(32) NOT NULL, `Olesek` INT(11) NOT NULL, `Rang` INT(11) NOT NULL, `Dollar` INT(11) NOT NULL, `Kulcs` INT(11) NOT NULL, `Skinek` INT(11) NOT NULL, `Premium` INT(11) NOT NULL, `Hud` INT(11) NOT NULL, `MVP` INT(11) NOT NULL, `Vip` INT(11) NOT NULL, `VipTime` INT(11) NOT NULL, `QuestH` INT(11) NOT NULL, `QuestMVP` INT(11) NOT NULL, `QuestNeed` INT(11) NOT NULL, `QuestHave` INT(11) NOT NULL, `QuestWeap` INT(11) NOT NULL, `QuestHead` INT(11) NOT NULL, `ErdemErem` INT(11) NOT NULL, `JutLada` INT(11) NOT NULL, `JutKulcs` INT(11) NOT NULL, `JutPont` INT(11) NOT NULL, `JutDoll` INT(11) NOT NULL, `Ido` INT(11) NOT NULL, `F0` INT(11) NOT NULL, `F1` INT(11) NOT NULL, `F2` INT(11) NOT NULL, `F3` INT(11) NOT NULL, `F4` INT(11) NOT NULL, `F5` INT(11) NOT NULL, `F6` INT(11) NOT NULL, `F7` INT(11) NOT NULL, `F8` INT(11) NOT NULL, `F9` INT(11) NOT NULL, `F10` INT(11) NOT NULL, `F11` INT(11) NOT NULL, `F12` INT(11) NOT NULL, `F13` INT(11) NOT NULL, `F14` INT(11) NOT NULL, `F15` INT(11) NOT NULL, `F16` INT(11) NOT NULL, `F17` INT(11) NOT NULL, `F18` INT(11) NOT NULL, `F19` INT(11) NOT NULL, `F20` INT(11) NOT NULL, `F21` INT(11) NOT NULL, `F22` INT(11) NOT NULL, `F23` INT(11) NOT NULL, `F24` INT(11) NOT NULL, `F25` INT(11) NOT NULL, `F26` INT(11) NOT NULL, `F27` INT(11) NOT NULL, `F28` INT(11) NOT NULL, `F29` INT(11) NOT NULL, `F30` INT(11) NOT NULL, `F31` INT(11) NOT NULL, `F32` INT(11) NOT NULL, `F33` INT(11) NOT NULL, `F34` INT(11) NOT NULL, `F35` INT(11) NOT NULL, `F36` INT(11) NOT NULL, `F37` INT(11) NOT NULL, `F38` INT(11) NOT NULL, `F39` INT(11) NOT NULL, `F40` INT(11) NOT NULL, `F41` INT(11) NOT NULL, `F42` INT(11) NOT NULL, `F43` INT(11) NOT NULL, `F44` INT(11) NOT NULL, `F45` INT(11) NOT NULL, `F46` INT(11) NOT NULL, `F47` INT(11) NOT NULL, `F48` INT(11) NOT NULL, `F49` INT(11) NOT NULL, `F50` INT(11) NOT NULL, `F51` INT(11) NOT NULL, `F52` INT(11) NOT NULL, `F53` INT(11) NOT NULL, `F54` INT(11) NOT NULL, `F55` INT(11) NOT NULL, `F56` INT(11) NOT NULL, `F57` INT(11) NOT NULL, `F58` INT(11) NOT NULL, `F59` INT(11) NOT NULL, `F60` INT(11) NOT NULL, `F61` INT(11) NOT NULL, `F62` INT(11) NOT NULL, `F63` INT(11) NOT NULL, `F64` INT(11) NOT NULL, `F65` INT(11) NOT NULL, `F66` INT(11) NOT NULL, `F67` INT(11) NOT NULL, `F68` INT(11) NOT NULL, `F69` INT(11) NOT NULL, `F70` INT(11) NOT NULL, `F71` INT(11) NOT NULL, `F72` INT(11) NOT NULL, `F73` INT(11) NOT NULL, `F74` INT(11) NOT NULL, `F75` INT(11) NOT NULL, `F76` INT(11) NOT NULL, `F77` INT(11) NOT NULL, `F78` INT(11) NOT NULL, `F79` INT(11) NOT NULL, `F80` INT(11) NOT NULL, `F81` INT(11) NOT NULL, `F82` INT(11) NOT NULL, `F83` INT(11) NOT NULL, `F84` INT(11) NOT NULL, `F85` INT(11) NOT NULL, `F86` INT(11) NOT NULL, `F87` INT(11) NOT NULL, `F88` INT(11) NOT NULL, `F89` INT(11) NOT NULL, `F90` INT(11) NOT NULL, `F91` INT(11) NOT NULL, `F92` INT(11) NOT NULL, `F93` INT(11) NOT NULL, `F94` INT(11) NOT NULL, `F95` INT(11) NOT NULL, `F96` INT(11) NOT NULL, `F97` INT(11) NOT NULL, `F98` INT(11) NOT NULL, `F99` INT(11) NOT NULL, `F100` INT(11) NOT NULL, `F101` INT(11) NOT NULL, `F102` INT(11) NOT NULL, `F103` INT(11) NOT NULL, `F104` INT(11) NOT NULL, `F105` INT(11) NOT NULL, `F106` INT(11) NOT NULL, `F107` INT(11) NOT NULL, `F108` INT(11) NOT NULL, `F109` INT(11) NOT NULL, `F110` INT(11) NOT NULL, `F111` INT(11) NOT NULL, `F112` INT(11) NOT NULL, `F113` INT(11) NOT NULL, `F114` INT(11) NOT NULL, `F115` INT(11) NOT NULL, `F116` INT(11) NOT NULL, `F117` INT(11) NOT NULL, `F118` INT(11) NOT NULL, `F119` INT(11) NOT NULL, `F120` INT(11) NOT NULL, `F121` INT(11) NOT NULL, `F122` INT(11) NOT NULL, `F123` INT(11) NOT NULL, `F124` INT(11) NOT NULL, `F125` INT(11) NOT NULL, `F126` INT(11) NOT NULL, `F127` INT(11) NOT NULL, `F128` INT(11) NOT NULL, `F129` INT(11) NOT NULL, `F130` INT(11) NOT NULL, `F131` INT(11) NOT NULL, `F132` INT(11) NOT NULL, `F133` INT(11) NOT NULL, `F134` INT(11) NOT NULL, `F135` INT(11) NOT NULL, `F136` INT(11) NOT NULL, `F137` INT(11) NOT NULL, `F138` INT(11) NOT NULL, `F139` INT(11) NOT NULL, `F140` INT(11) NOT NULL, `F141` INT(11) NOT NULL, `F142` INT(11) NOT NULL, `F143` INT(11) NOT NULL, `F144` INT(11) NOT NULL, `F145` INT(11) NOT NULL, `F146` INT(11) NOT NULL, `F147` INT(11) NOT NULL, `F148` INT(11) NOT NULL, `F149` INT(11) NOT NULL, `F150` INT(11) NOT NULL, `F151` INT(11) NOT NULL, `F152` INT(11) NOT NULL, `F153` INT(11) NOT NULL, `F154` INT(11) NOT NULL, `F155` INT(11) NOT NULL, `F156` INT(11) NOT NULL, `F157` INT(11) NOT NULL, `F158` INT(11) NOT NULL, `F159` INT(11) NOT NULL, `F160` INT(11) NOT NULL, `F161` INT(11) NOT NULL, `F162` INT(11) NOT NULL, `F163` INT(11) NOT NULL, `F164` INT(11) NOT NULL, `F165` INT(11) NOT NULL, `F166` INT(11) NOT NULL, `F167` INT(11) NOT NULL, `F168` INT(11) NOT NULL, `F169` INT(11) NOT NULL, `F170` INT(11) NOT NULL, `F171` INT(11) NOT NULL, `F172` INT(11) NOT NULL, `F173` INT(11) NOT NULL, `F174` INT(11) NOT NULL, `F175` INT(11) NOT NULL, `F176` INT(11) NOT NULL, `F177` INT(11) NOT NULL, `F178` INT(11) NOT NULL, `F179` INT(11) NOT NULL, `F180` INT(11) NOT NULL, `F181` INT(11) NOT NULL, `F182` INT(11) NOT NULL, `F183` INT(11) NOT NULL, `F184` INT(11) NOT NULL, `F185` INT(11) NOT NULL, `F186` INT(11) NOT NULL, `F187` INT(11) NOT NULL, `F188` INT(11) NOT NULL, `F189` INT(11) NOT NULL, `F190` INT(11) NOT NULL, `F191` INT(11) NOT NULL, `F192` INT(11) NOT NULL, `F193` INT(11) NOT NULL, `F194` INT(11) NOT NULL, `F195` INT(11) NOT NULL, `F196` INT(11) NOT NULL, `F197` INT(11) NOT NULL, `F198` INT(11) NOT NULL, `F199` INT(11) NOT NULL, `F200` INT(11) NOT NULL, `F201` INT(11) NOT NULL, `F202` INT(11) NOT NULL, `F203` INT(11) NOT NULL, `F204` INT(11) NOT NULL, `F205` INT(11) NOT NULL, `F206` INT(11) NOT NULL, `F207` INT(11) NOT NULL, `F208` INT(11) NOT NULL, `F209` INT(11) NOT NULL, `F210` INT(11) NOT NULL, `F211` INT(11) NOT NULL, `F212` INT(11) NOT NULL, `F213` INT(11) NOT NULL, `F214` INT(11) NOT NULL, `F215` INT(11) NOT NULL, `F216` INT(11) NOT NULL, `F217` INT(11) NOT NULL, `F218` INT(11) NOT NULL, `F219` INT(11) NOT NULL, `F220` INT(11) NOT NULL, `F221` INT(11) NOT NULL, `F222` INT(11) NOT NULL, `F223` INT(11) NOT NULL, `F224` INT(11) NOT NULL, `F225` INT(11) NOT NULL, `F226` INT(11) NOT NULL, `F227` INT(11) NOT NULL, `F228` INT(11) NOT NULL, `F229` INT(11) NOT NULL, `F230` INT(11) NOT NULL, `F231` INT(11) NOT NULL, `F232` INT(11) NOT NULL, `F233` INT(11) NOT NULL, `F234` INT(11) NOT NULL, `F235` INT(11) NOT NULL, `F236` INT(11) NOT NULL, `F237` INT(11) NOT NULL, `F238` INT(11) NOT NULL, `F239` INT(11) NOT NULL, `F240` INT(11) NOT NULL, `F241` INT(11) NOT NULL, `F242` INT(11) NOT NULL, `F243` INT(11) NOT NULL, `F244` INT(11) NOT NULL, `F245` INT(11) NOT NULL, `F246` INT(11) NOT NULL, `F247` INT(11) NOT NULL, `F248` INT(11) NOT NULL, `F249` INT(11) NOT NULL, `F250` INT(11) NOT NULL, `F251` INT(11) NOT NULL, `F252` INT(11) NOT NULL, `F253` INT(11) NOT NULL, `F254` INT(11) NOT NULL, `F255` INT(11) NOT NULL, `F256` INT(11) NOT NULL, `F257` INT(11) NOT NULL, `F258` INT(11) NOT NULL, `F259` INT(11) NOT NULL, `F260` INT(11) NOT NULL, `F261` INT(11) NOT NULL, `F262` INT(11) NOT NULL, `F263` INT(11) NOT NULL, `F264` INT(11) NOT NULL, `F265` INT(11) NOT NULL, `F266` INT(11) NOT NULL, `A0` INT(11) NOT NULL, `A1` INT(11) NOT NULL, `A2` INT(11) NOT NULL, `A3` INT(11) NOT NULL, `A4` INT(11) NOT NULL, `A5` INT(11) NOT NULL, `A6` INT(11) NOT NULL, `A7` INT(11) NOT NULL, `A8` INT(11) NOT NULL, `A9` INT(11) NOT NULL, `A10` INT(11) NOT NULL, `A11` INT(11) NOT NULL, `A12` INT(11) NOT NULL, `A13` INT(11) NOT NULL, `A14` INT(11) NOT NULL, `A15` INT(11) NOT NULL, `A16` INT(11) NOT NULL, `A17` INT(11) NOT NULL, `A18` INT(11) NOT NULL, `A19` INT(11) NOT NULL, `A20` INT(11) NOT NULL, `A21` INT(11) NOT NULL, `A22` INT(11) NOT NULL, `U0` INT(11) NOT NULL, `U1` INT(11) NOT NULL, `U2` INT(11) NOT NULL, `U3` INT(11) NOT NULL, `U4` INT(11) NOT NULL, `U5` INT(11) NOT NULL, `U6` INT(11) NOT NULL, `U7` INT(11) NOT NULL, `U8` INT(11) NOT NULL, `U9` INT(11) NOT NULL, `U10` INT(11) NOT NULL, `U11` INT(11) NOT NULL, `U12` INT(11) NOT NULL, `U13` INT(11) NOT NULL, `U14` INT(11) NOT NULL, `U15` INT(11) NOT NULL, `U16` INT(11) NOT NULL, `U17` INT(11) NOT NULL, `U18` INT(11) NOT NULL, `U19` INT(11) NOT NULL, `U20` INT(11) NOT NULL, `U22` INT(11) NOT NULL, `M0` INT(11) NOT NULL, `M1` INT(11) NOT NULL, `M2` INT(11) NOT NULL, `M3` INT(11) NOT NULL, `M4` INT(11) NOT NULL, `M5` INT(11) NOT NULL, `M6` INT(11) NOT NULL, `M7` INT(11) NOT NULL, `M8` INT(11) NOT NULL, `M9` INT(11) NOT NULL, `M10` INT(11) NOT NULL, `M11` INT(11) NOT NULL, `M12` INT(11) NOT NULL, `M13` INT(11) NOT NULL, `M14` INT(11) NOT NULL, `M15` INT(11) NOT NULL, `M16` INT(11) NOT NULL, `M17` INT(11) NOT NULL, `M18` INT(11) NOT NULL, `M19` INT(11) NOT NULL, `M20` INT(11) NOT NULL, `M21` INT(11) NOT NULL, `M22` INT(11) NOT NULL, `G0` INT(11) NOT NULL, `G1` INT(11) NOT NULL, `G2` INT(11) NOT NULL, `G3` INT(11) NOT NULL, `G4` INT(11) NOT NULL, `G5` INT(11) NOT NULL, `G6` INT(11) NOT NULL, `G7` INT(11) NOT NULL, `G8` INT(11) NOT NULL, `G9` INT(11) NOT NULL, `G10` INT(11) NOT NULL, `G11` INT(11) NOT NULL, `G12` INT(11) NOT NULL, `S0` INT(11) NOT NULL, `S1` INT(11) NOT NULL, `S2` INT(11) NOT NULL, `S3` INT(11) NOT NULL, `S4` INT(11) NOT NULL, `S5` INT(11) NOT NULL, `S6` INT(11) NOT NULL, `S7` INT(11) NOT NULL, `S8` INT(11) NOT NULL, `S9` INT(11) NOT NULL, `S10` INT(11) NOT NULL, `S11` INT(11) NOT NULL, `S12` INT(11) NOT NULL, `S13` INT(11) NOT NULL, `S14` INT(11) NOT NULL, `S15` INT(11) NOT NULL, `K0` INT(11) NOT NULL, `K1` INT(11) NOT NULL, `K2` INT(11) NOT NULL, `K3` INT(11) NOT NULL, `K4` INT(11) NOT NULL, `K5` INT(11) NOT NULL, `K6` INT(11) NOT NULL, `K7` INT(11) NOT NULL, `K8` INT(11) NOT NULL, `K9` INT(11) NOT NULL, `K10` INT(11) NOT NULL, `K11` INT(11) NOT NULL, `K12` INT(11) NOT NULL, `K13` INT(11) NOT NULL, `K14` INT(11) NOT NULL, `K15` INT(11) NOT NULL, `K16` INT(11) NOT NULL, `K17` INT(11) NOT NULL, `K18` INT(11) NOT NULL, `K19` INT(11) NOT NULL, `K20` INT(11) NOT NULL, `K21` INT(11) NOT NULL, `K22` INT(11) NOT NULL, `K23` INT(11) NOT NULL, `K24` INT(11) NOT NULL, `K25` INT(11) NOT NULL, `K26` INT(11) NOT NULL, `K27` INT(11) NOT NULL, `K28` INT(11) NOT NULL, `K29` INT(11) NOT NULL, `K30` INT(11) NOT NULL, `K31` INT(11) NOT NULL, `K32` INT(11) NOT NULL, `K33` INT(11) NOT NULL, `K34` INT(11) NOT NULL, `K35` INT(11) NOT NULL, `K36` INT(11) NOT NULL, `K37` INT(11) NOT NULL, `K38` INT(11) NOT NULL, `K39` INT(11) NOT NULL, `K40` INT(11) NOT NULL, `K41` INT(11) NOT NULL, `K42` INT(11) NOT NULL, `K43` INT(11) NOT NULL, `K44` INT(11) NOT NULL, `L0` INT(11) NOT NULL, `L1` INT(11) NOT NULL, `L2` INT(11) NOT NULL, `L3` INT(11) NOT NULL, `L4` INT(11) NOT NULL, `L5` INT(11) NOT NULL, `L6` INT(11) NOT NULL, `L7` INT(11) NOT NULL, `L8` INT(11) NOT NULL, `L9` INT(11) NOT NULL, `L10` INT(11) NOT NULL, `L11` INT(11) NOT NULL, `L12` INT(11) NOT NULL, `L13` INT(11) NOT NULL, `L14` INT(11) NOT NULL, `L15` INT(11) NOT NULL, `L16` INT(11) NOT NULL, `L17` INT(11) NOT NULL, `L18` INT(11) NOT NULL, `L19` INT(11) NOT NULL, `L20` INT(11) NOT NULL, `L21` INT(11) NOT NULL, `L22` INT(11) NOT NULL, `L23` INT(11) NOT NULL, `L24` INT(11) NOT NULL, `Skin0` INT(11) NOT NULL, `Skin1` INT(11) NOT NULL, `Skin2` INT(11) NOT NULL, `Skin3` INT(11) NOT NULL, `Skin4` INT(11) NOT NULL, `Skin5` INT(11) NOT NULL, `Skin6` INT(11) NOT NULL, `Skin7` INT(11) NOT NULL, `Skin8` INT(11) NOT NULL, `Skin9` INT(11) NOT NULL, `Skin10` INT(11) NOT NULL, `Skin11` INT(11) NOT NULL, `Skin12` INT(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Indexes for dumped tables -- -- -- Indexes for table `exodus_go_2017` -- ALTER TABLE `exodus_go_2017` ADD PRIMARY KEY (`Id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `exodus_go_2017` -- ALTER TABLE `exodus_go_2017` MODIFY `Id` INT(11) NOT NULL AUTO_INCREMENT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|