Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: SQL
Parašė WantedBoy· 2007 Lie. 15 00:07:02
#1
Gal galite pasakyti kaip importint lentele per
phpmyadmin? Nu turiu sql faila ir noriu kad padarytu lentele is to failo.
Parašė ozzWANTED· 2007 Lie. 15 00:07:27
#2
Nu pizdiec, gi yra mygtukas "import", spaudi ant jo, pasirenki failą ir siunti....
Parašė WantedBoy· 2007 Lie. 15 00:07:32
#3
tai kad nera import mygtuko.Yra tik Export :?
Parašė Demonas· 2007 Lie. 15 00:07:21
#4
atsidarai savo ta sql faila, kuri norejai importuot kopini viska, kas yra jame, tada eini i SQL myadmine, ten ipastini viska ir issaugai.
Parašė WantedBoy· 2007 Lie. 15 00:07:01
#5
tai ir beda kaip ja issaugot c| :?
Parašė Demonas· 2007 Lie. 15 00:07:55
#6
pma yra mygtukas SQL?:?
Parašė WantedBoy· 2007 Lie. 15 00:07:29
#7
tai kad as ikeliu viska is sql failo spaudziu go ir ka toliau daryt? B)
Parašė Demonas· 2007 Lie. 15 00:07:59
#8
nemeta eroro?
Parašė WantedBoy· 2007 Lie. 15 00:07:29
#9
nea ?|
Parašė Demonas· 2007 Lie. 15 00:07:26
#10
sukuria lenteles reikiamas?
Parašė WantedBoy· 2007 Lie. 15 00:07:29
#11
turi sukurt boxscore taciau nesukuria.Nu man atrodo lenteles yra
phpmyadmin puslapio kaireje puseje ane? Jei taip tai ten nauja neatsiranda. :(
Redagavo WantedBoy· 2007 Lie. 15 00:07:56
Parašė WantedBoy· 2007 Lie. 15 00:07:46
#12
Va tas SQl failas.Sakykit kaip ji ikelt? Idedu
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 22, 2007 at 03:36 PM
-- Server version: 4.1.12
-- PHP Version: 4.4.2
--
-- Database: `League_Manager`
--
-- --------------------------------------------------------
--
-- Table structure for table `boxscore`
--
DROP TABLE IF EXISTS `boxscore`;
CREATE TABLE IF NOT EXISTS `boxscore` (
`season_id` varchar(255) NOT NULL default '1',
`id` int(11) NOT NULL auto_increment,
`team` varchar(255) NOT NULL default '',
`score` int(11) NOT NULL default '0',
`opponent` varchar(255) NOT NULL default '',
`score1` int(11) NOT NULL default '0',
`ip` varchar(255) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`pog` varchar(255) NOT NULL default '',
`comments` longtext NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `boxscore`
--
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
DROP TABLE IF EXISTS `comments`;
CREATE TABLE IF NOT EXISTS `comments` (
`season_id` int(11) NOT NULL default '0',
`id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`comments` longtext NOT NULL,
`game_id` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `fullstats`
--
DROP TABLE IF EXISTS `fullstats`;
CREATE TABLE IF NOT EXISTS `fullstats` (
`season_id` varchar(255) NOT NULL default '1',
`id` int(11) NOT NULL auto_increment,
`Name` varchar(255) NOT NULL default '',
`Points` int(11) default NULL,
`Minutes` int(11) default NULL,
`FGM` int(11) default NULL,
`FGA` int(11) default NULL,
`threepm` int(11) default NULL,
`threepa` int(11) default NULL,
`FTM` int(11) default NULL,
`FTA` int(11) default NULL,
`Orebounds` int(11) default NULL,
`Drebounds` int(11) default NULL,
`Rebounds` int(11) NOT NULL default '0',
`Assist` int(11) default NULL,
`Block` int(11) default NULL,
`Steal` int(11) default NULL,
`Turnovers` int(11) default NULL,
`fouls` int(22) NOT NULL default '0',
`gps` int(11) NOT NULL default '0',
`fullrev` int(11) NOT NULL default '0',
`tps` int(11) NOT NULL default '0',
UNIQUE KEY `Name` (`Name`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `fullstats`
--
-- --------------------------------------------------------
--
-- Table structure for table `gamestats`
--
DROP TABLE IF EXISTS `gamestats`;
CREATE TABLE IF NOT EXISTS `gamestats` (
`game_id` int(11) NOT NULL default '0',
`team` varchar(255) NOT NULL default '',
`points` int(11) NOT NULL default '0',
`minutes` int(11) NOT NULL default '0',
`fgm` int(11) NOT NULL default '0',
`fga` int(11) NOT NULL default '0',
`threepm` int(11) NOT NULL default '0',
`threepa` int(11) NOT NULL default '0',
`ftm` int(11) NOT NULL default '0',
`fta` int(11) NOT NULL default '0',
`orebounds` int(11) NOT NULL default '0',
`drebounds` int(11) NOT NULL default '0',
`rebounds` int(11) NOT NULL default '0',
`assist` int(11) NOT NULL default '0',
`block` int(11) NOT NULL default '0',
`steal` int(11) NOT NULL default '0',
`turnovers` int(11) NOT NULL default '0',
`fouls` int(11) NOT NULL default '0',
`opponent` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `gamestats`
--
-- --------------------------------------------------------
--
-- Table structure for table `nba`
--
DROP TABLE IF EXISTS `nba`;
CREATE TABLE IF NOT EXISTS `nba` (
`season_id` int(11) NOT NULL default '1',
`id` int(11) NOT NULL auto_increment,
`team` varchar(255) NOT NULL default '',
`Pos` varchar(255) NOT NULL default '',
`pos1` varchar(255) NOT NULL default '',
`pos2` varchar(255) NOT NULL default '',
`pos3` varchar(255) NOT NULL default '',
`pos4` varchar(255) NOT NULL default '',
`pos5` varchar(255) NOT NULL default '',
`fname` varchar(255) NOT NULL default '',
`lname` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`playerid` int(11) NOT NULL default '0',
`exp` int(11) NOT NULL default '0',
`age` int(11) NOT NULL default '0',
`lineup` int(11) NOT NULL default '0',
`height` varchar(255) NOT NULL default '',
`weight` varchar(255) NOT NULL default '',
`Ovr` int(11) NOT NULL default '0',
`FG` int(11) NOT NULL default '0',
`threept` int(11) NOT NULL default '0',
`Range` varchar(255) NOT NULL default '',
`FT` int(11) NOT NULL default '0',
`Dunk` int(11) NOT NULL default '0',
`Jump` int(11) NOT NULL default '0',
`Blocks` int(11) NOT NULL default '0',
`Insscore` int(11) NOT NULL default '0',
`strength` int(11) NOT NULL default '0',
`offrebounds` int(11) NOT NULL default '0',
`defrebounds` int(11) NOT NULL default '0',
`Quick` int(11) NOT NULL default '0',
`Speed` int(11) NOT NULL default '0',
`Steals` int(11) NOT NULL default '0',
`Pass` int(11) NOT NULL default '0',
`Dribble` int(11) NOT NULL default '0',
`OffAware` int(11) NOT NULL default '0',
`DefAware` int(11) NOT NULL default '0',
`fat` int(11) NOT NULL default '0',
`inj` int(11) NOT NULL default '0',
`pri` int(11) NOT NULL default '0',
`sea_min` int(11) NOT NULL default '0',
`nbdl_eligble` varchar(255) NOT NULL default '0',
`class` varchar(255) NOT NULL default '',
`injured` varchar(255) NOT NULL default '0',
`game_hurt` int(11) NOT NULL default '0',
`game_comeback` int(11) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=570 ;
-- --------------------------------------------------------
--
-- Table structure for table `nba_draft`
--
DROP TABLE IF EXISTS `nba_draft`;
CREATE TABLE IF NOT EXISTS `nba_draft` (
`playerid` int(11) NOT NULL auto_increment,
`Projected` varbinary(255) NOT NULL default '',
`flashranking` varchar(255) NOT NULL default '',
`Pos` varchar(255) NOT NULL default '',
`Pos2` varchar(255) NOT NULL default '',
`Pos3` varchar(255) NOT NULL default '',
`lname` varchar(255) NOT NULL default '',
`fname` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`feet` int(11) NOT NULL default '0',
`inch` int(11) NOT NULL default '0',
`wt` int(11) NOT NULL default '0',
`age` int(11) NOT NULL default '0',
`drib` varchar(255) NOT NULL default '0',
`oaw` varchar(255) NOT NULL default '0',
`mass` varchar(255) NOT NULL default '0',
`bench` varbinary(255) NOT NULL default '0',
`lane` varchar(255) NOT NULL default '0',
`sprint` varchar(255) NOT NULL default '0',
`vertical` varchar(255) NOT NULL default '0',
`sprintwball` varchar(255) NOT NULL default '0',
`athleticperc` varchar(255) NOT NULL default '0',
`athletic` varchar(255) NOT NULL default '',
`highflyer` varchar(255) NOT NULL default '',
`playmaker` varchar(255) NOT NULL default '',
`power` varchar(255) NOT NULL default '',
`outscorer` varchar(255) NOT NULL default '',
`insscorer` varchar(255) NOT NULL default '',
`shooter` varchar(255) NOT NULL default '',
`insstopper` varchar(255) NOT NULL default '',
`outstopper` varchar(255) NOT NULL default '',
`slasher` varchar(255) NOT NULL default '',
`aggressive` varchar(255) NOT NULL default '',
`selected` int(11) NOT NULL default '0',
KEY `id` (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `nba_draft`
--
-- --------------------------------------------------------
--
-- Table structure for table `nba_draft_order`
--
DROP TABLE IF EXISTS `nba_draft_order`;
CREATE TABLE IF NOT EXISTS `nba_draft_order` (
`id` int(11) NOT NULL auto_increment,
`team` varchar(255) NOT NULL default '',
`rd` varchar(255) NOT NULL default '',
`pick` int(11) NOT NULL default '0',
`player` varchar(255) NOT NULL default '',
`Original_Team` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `nba_draft_order`
--
-- --------------------------------------------------------
--
-- Table structure for table `picture`
--
DROP TABLE IF EXISTS `picture`;
CREATE TABLE IF NOT EXISTS `picture` (
`name` varchar(255) NOT NULL default '',
`id` int(11) NOT NULL default '0',
`pic` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `picture`
--
-- --------------------------------------------------------
--
-- Table structure for table `scouting`
--
DROP TABLE IF EXISTS `scouting`;
CREATE TABLE IF NOT EXISTS `scouting` (
`id` int(11) NOT NULL auto_increment,
`game_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`opponent` varchar(255) NOT NULL default '',
`comment` longtext NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `scouting`
--
-- --------------------------------------------------------
--
-- Table structure for table `stats`
--
DROP TABLE IF EXISTS `stats`;
CREATE TABLE IF NOT EXISTS `stats` (
`id` int(11) NOT NULL auto_increment,
`game_id` int(11) NOT NULL default '0',
`team` varchar(255) NOT NULL default '0',
`opponent` varchar(255) NOT NULL default '',
`season_id` varchar(255) NOT NULL default 'play1',
`pos` varchar(255) NOT NULL default '',
`pos2` varchar(255) NOT NULL default '',
`Name` varchar(255) NOT NULL default '',
`Points` int(11) NOT NULL default '0',
`Rebounds` int(11) NOT NULL default '0',
`Assist` int(11) NOT NULL default '0',
`Block` int(11) NOT NULL default '0',
`Steal` int(11) NOT NULL default '0',
`Turnovers` int(11) NOT NULL default '0',
`Fouls` int(11) NOT NULL default '0',
`Minutes` int(11) NOT NULL default '0',
`fgm` int(11) NOT NULL default '0',
`fga` int(11) NOT NULL default '0',
`fgp` varchar(255) NOT NULL default '',
`threepm` int(11) NOT NULL default '0',
`threepa` int(11) NOT NULL default '0',
`tpp` varchar(255) NOT NULL default '',
`FTM` int(11) NOT NULL default '0',
`FTA` int(11) NOT NULL default '0',
`ftp` varchar(255) NOT NULL default '',
`Orebounds` int(11) NOT NULL default '0',
`Drebounds` int(22) NOT NULL default '0',
`ptrev` int(11) NOT NULL default '0',
`rebrev` int(11) NOT NULL default '0',
`astrev` int(11) NOT NULL default '0',
`blkrev` int(11) NOT NULL default '0',
`threeprev` int(11) NOT NULL default '0',
`stlrev` int(11) NOT NULL default '0',
`fgrev` int(11) NOT NULL default '0',
`ftrev` int(11) NOT NULL default '0',
`test` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `stats`
--
-- --------------------------------------------------------
--
-- Table structure for table `team`
--
DROP TABLE IF EXISTS `team`;
CREATE TABLE IF NOT EXISTS `team` (
`season_id` int(11) NOT NULL default '1',
`id` int(11) NOT NULL default '1',
`team_id` int(11) NOT NULL auto_increment,
`team_color` varchar(255) NOT NULL default '',
`team_name` varchar(255) NOT NULL default '',
`team_nickname` varchar(255) NOT NULL default '',
`picture` varchar(255) NOT NULL default '',
`Score_Pic` varchar(255) NOT NULL default '',
`news` longtext NOT NULL,
`wins` int(11) NOT NULL default '0',
`losses` int(11) NOT NULL default '0',
`dw` int(11) NOT NULL default '0',
`dl` int(11) NOT NULL default '0',
`cw` int(11) NOT NULL default '0',
`cl` int(11) NOT NULL default '0',
`hw` int(11) NOT NULL default '0',
`hl` int(11) NOT NULL default '0',
`aw` int(11) NOT NULL default '0',
`al` int(11) NOT NULL default '0',
`Conference` varchar(255) NOT NULL default '',
`Division` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`icq` varchar(255) NOT NULL default '',
`aim` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`access` int(11) NOT NULL default '0',
`password` varchar(255) NOT NULL default '',
`TCR` int(15) NOT NULL default '0',
`Expected_Wins` int(15) NOT NULL default '0',
`gp` int(11) NOT NULL default '0',
PRIMARY KEY (`team_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `team`
--
INSERT INTO `team` (`season_id`, `id`, `team_id`, `team_color`, `team_name`, `team_nickname`, `picture`, `Score_Pic`, `news`, `wins`, `losses`, `dw`, `dl`, `cw`, `cl`, `hw`, `hl`, `aw`, `al`, `Conference`, `Division`, `name`, `icq`, `aim`, `email`, `access`, `password`, `TCR`, `Expected_Wins`, `gp`) VALUES (1, 1, 2, '#006532', 'Boston', 'Celtics', '<img src="http://nlw.nbalive-world.com/images/bos_logo.gif"', '<img src="scoreboardimages/bos_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Atlantic', '', '', '', '', 0, '0', 161, 17, 0),
(1, 1, 3, '#000000', 'Chicago', 'Bulls', '<img src="http://nlw.nbalive-world.com/images/chi_logo.gif"', '<img src="scoreboardimages/chi_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Central', '', '', '', '', 3, '0', 142, 25, 2),
(1, 1, 4, '#061642', 'Cleveland', 'Cavaliers', '<img src="http://nlw.nbalive-world.com/images/cle_logo.gif"', '<img src="scoreboardimages/cle_logo.gif" width="60" height="40">', 'I WILL NEVER TRADE LEBRON SO DONT BOTHER ASKING!!!', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Central', '', '', '', '', 0, '0', 129, 24, 2),
(1, 1, 5, '#0C469E', 'Dallas', 'Mavericks', '<img src="http://nlw.nbalive-world.com/images/dal_logo.gif"', '<img src="scoreboardimages/dal_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'SouthWest', '', '', '', '', 3, '0', 173, 29, 1),
(1, 1, 6, '#0961A8', 'Denver', 'Nuggets', '<img src="http://nlw.nbalive-world.com/images/den_logo.gif"', '<img src="scoreboardimages/den_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'NorthWest', '', '', '', '', 0, '0', 95, 24, 1),
(1, 1, 7, '#FB002C', 'Detroit', 'Pistons', '<img src="http://nlw.nbalive-world.com/images/det_logo.gif"', '<img src="scoreboardimages/det_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Central', '', '', '', '', 0, '0', 130, 28, 1),
(1, 1, 8, '#00275E', 'Golden State', 'Warriors', '<img src="http://nlw.nbalive-world.com/images/gsw_logo.gif"', '<img src="scoreboardimages/gsw_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'Pacific', '', '', '', '', 0, '0', 116, 24, 1),
(1, 1, 9, '#D50025', 'Houston', 'Rockets', '<img src="http://nlw.nbalive-world.com/images/hou_logo.gif"', '<img src="scoreboardimages/hou_logo.gif" width="60" height="40">', 'Switched teams with former Rockets owner, Now i''m the new Rockets owner.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'SouthWest', '', '', '', '', 1, '0', 155, 26, 2),
(1, 1, 10, '#061642', 'Indiana', 'Pacers', '<img src="http://nlw.nbalive-world.com/images/ind_logo.gif"', '<img src="scoreboardimages/ind_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Central', '', '', '', '', 1, '0', 100, 21, 0),
(1, 1, 11, '#FB0025', 'LA Clippers', 'Clippers', '<img src="http://nlw.nbalive-world.com/images/lac_logo.gif"', '<img src="scoreboardimages/lac_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'Pacific', '', '', '', '', 0, '0', 94, 100, 0),
(1, 1, 12, '#542583', 'LA Lakers', 'Lakers', '<img src="http://nlw.nbalive-world.com/images/lal_logo.gif"', '<img src="scoreboardimages/lal_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'Pacific', '', '', '', '', 0, '0', 183, 25, 1),
(1, 1, 13, '#5E76A8', 'Memphis', 'Grizzlies', '<img src="http://nlw.nbalive-world.com/images/mem_logo.gif"', '<img src="scoreboardimages/mem_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'SouthWest', '', '', '', '', 0, '0', 127, 24, 0),
(1, 1, 14, '#000000', 'Miami', 'Heat', '<img src="http://nlw.nbalive-world.com/images/mia_logo.gif"', '<img src="scoreboardimages/mia_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'SouthEast', '', '', '', '', 0, '0', 165, 31, 0),
(1, 1, 15, '#3F0D75', 'Milwaukee', 'Bucks', '<img src="http://nlw.nbalive-world.com/images/mil_logo.gif"', '<img src="scoreboardimages/mil_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Central', '', '', '', '', 0, '0', 127, 22, 0),
(1, 1, 16, '#0E3765', 'Minnesota', 'Timberwolves', '<img src="http://nlw.nbalive-world.com/images/min_logo.gif"', '<img src="scoreboardimages/min_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'NorthWest', '', '', '', '', 3, '0', 206, 22, 0),
(1, 1, 17, '#06143E', 'New Jersey', 'Nets', '<img src="http://nlw.nbalive-world.com/images/njn_logo.gif"', '<img src="scoreboardimages/njn_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Atlantic', '', '', '', '', 0, '0', 136, 26, 0),
(1, 1, 19, '#225FA8', 'New York', 'Knicks', '<img src="images/nyk_logo.gif"', '<img src="scoreboardimages/nyk_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Atlantic', '', '', '', '', 0, '0', 105, 24, 0),
(1, 1, 20, '#0961A8', 'Orlando', 'Magic', '<img src="images/orl_logo.gif"', '<img src="scoreboardimages/orl_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'SouthEast', '', '', '', '', 0, '0', 109, 22, 1),
(1, 1, 21, '#000000', 'Philadelphia', '76ers', '<img src="images/phi_logo.gif"', '<img src="scoreboardimages/phi_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Atlantic', '', '', '', '', 0, '0', 114, 19, 1),
(1, 1, 22, '#23006A', 'Phoenix', 'Suns', '<img src="images/pho_logo.gif"', '<img src="scoreboardimages/pho_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'Pacific', '', '', '', '', 0, '0', 108, 31, 0),
(1, 1, 23, '#000000', 'Portland', 'Blazers', '<img src="images/por_logo.gif"', '<img src="scoreboardimages/por_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'NorthWest', '', '', '', '', 0, '0', 132, 18, 0),
(1, 1, 24, '#383896', 'Sacramento', 'Kings', '<img src="images/sac_logo.gif"', '<img src="scoreboardimages/sac_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'Pacific', '', '', '', '', 0, '0', 110, 23, 0),
(1, 1, 25, '#000000', 'San Antonio', 'Spurs', '<img src="images/sas_logo.gif"', '<img src="scoreboardimages/sas_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'SouthWest', '', '', '', '', 0, '0', 108, 100, 0),
(1, 1, 26, '#1D3F2C', 'Seattle', 'Supersonics', '<img src="images/sea_logo.gif"', '<img src="scoreboardimages/sea_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'NorthWest', '', '', '', '', 0, '0', 123, 21, 0),
(1, 1, 27, '#CE0F3F', 'Toronto', 'Raptors', '<img src="images/tor_logo.gif"', '<img src="scoreboardimages/tor_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'Atlantic', '', '', '', '', 0, '0', 121, 19, 0),
(1, 1, 28, '#06143E', 'Utah', 'Jazz', '<img src="images/uth_logo.gif"', '<img src="scoreboardimages/uth_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'NorthWest', '', '', '', '', 0, '0', 100, 22, 0),
(1, 1, 29, '#0E3765', 'Washington', 'Wizards', '<img src="images/was_logo.gif"', '<img src="scoreboardimages/was_logo.gif" width="60" height="40">', ' ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'SouthEast', '', '', '', '', 0, '0', 113, 24, 0),
(1, 1, 30, '#FE3310', 'Charlotte', 'Bobcats', '<img src="images/cha_logo.gif"', '<img src="scoreboardimages/cha_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'SouthEast', '', '', '', '', 0, '0', 75, 18, 0),
(1, 1, 1, '', 'Atlanta', 'Hawks', '<img src="http://nlw.nbalive-world.com/images/atl_logo.gif"', '<img src="scoreboardimages/atl_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastern', 'SouthEast', '', '', '', '', 0, '0', 114, 17, 1),
(1, 1, 18, '', 'New Orleans', 'Hornets', '<img src="http://nlw.nbalive-world.com/images/nor_logo.gif"', '<img src="scoreboardimages/nor_logo.gif" width="60" height="40">', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Western', 'SouthWest', '', '', '', '', 0, '0', 129, 19, 0);
-- --------------------------------------------------------
--
-- Table structure for table `team_news`
--
DROP TABLE IF EXISTS `team_news`;
CREATE TABLE IF NOT EXISTS `team_news` (
`id` int(11) NOT NULL auto_increment,
`team` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`headline` longtext NOT NULL,
`content` longtext NOT NULL,
`fullcontent` longtext NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `team_news`
--
-- --------------------------------------------------------
--
-- Table structure for table `team_number`
--
DROP TABLE IF EXISTS `team_number`;
CREATE TABLE IF NOT EXISTS `team_number` (
`team_number` int(11) NOT NULL default '0',
`team_name` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `team_number`
--
INSERT INTO `team_number` (`team_number`, `team_name`) VALUES (0, 'Atlanta'),
(1, 'Boston'),
(2, 'Charlotte'),
(3, 'Chicago'),
(4, 'Cleveland'),
(5, 'Dallas'),
(6, 'Denver'),
(7, 'Detroit'),
(8, 'Golden State'),
(9, 'Houston'),
(10, 'Indiana'),
(11, 'LA Clippers'),
(12, 'LA Lakers'),
(13, 'Memphis'),
(14, 'Miami'),
(15, 'Milwaukee'),
(16, 'Minnesota'),
(17, 'New Jersey'),
(18, 'New Orleans'),
(19, 'New York'),
(20, 'Orlando'),
(21, 'Philadelphia'),
(22, 'Phoenix'),
(23, 'Portland'),
(24, 'Sacramento'),
(25, 'San Antonio'),
(26, 'Seattle'),
(27, 'Toronto'),
(28, 'Utah'),
(29, 'Washington'),
(50, 'Free Agents');
-- --------------------------------------------------------
--
-- Table structure for table `transactions`
--
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE IF NOT EXISTS `transactions` (
`id` int(11) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`team1` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`player1` varchar(255) NOT NULL default '',
`player2` varchar(255) NOT NULL default '',
`player3` varchar(255) NOT NULL default '',
`player4` varchar(255) NOT NULL default '',
`comment1` longtext NOT NULL,
`comto` varchar(255) NOT NULL default '',
`team2` varchar(255) NOT NULL default '',
`comfor` varchar(255) NOT NULL default '',
`player5` varchar(255) NOT NULL default '',
`player6` varchar(255) NOT NULL default '',
`player7` varchar(255) NOT NULL default '',
`player8` varchar(255) NOT NULL default '',
`comment2` longtext NOT NULL,
`contract` varchar(255) NOT NULL default '',
`comof` varchar(255) NOT NULL default '',
`yrs` int(11) NOT NULL default '0',
`totsal` int(11) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `transactions`
--
Redagavo WantedBoy· 2007 Lie. 15 00:07:11
Parašė DarK-SouL· 2007 Lie. 15 00:07:51
#13
Palandziok po
phpmyadmin turetum suprast :D
Turetu but kazkas panasaus i atlikti SQL veiksmus ar pns...
Nepamenu :D
Parašė Demonas· 2007 Lie. 15 00:07:28
#14
kopink koda nuo DRP TABLE IF EXISTS iki galo ir rasyk i SQL pma.
Parašė WantedBoy· 2007 Lie. 15 01:07:15
#15
Krc kazkaip isikele is dabar kai einu i saito url man ismeta balta vaizda su uzrasu:
Column 'id' in field list is ambiguous Gal zinot ka reiskia? ?|
Parašė ozzWANTED· 2007 Lie. 15 10:07:54
#16
dubliuojasi name'ai. Arba pervadink, arba naudok simpiliatorius, aka pvz. tf.*, tt.*, tu.*, tu.user_name etc...