[OpticKiller]

Hi Guys i got the SQL tables here

but am not sure how to make it into a file datebase so i can upload it to phpmyadmin

Код:

CREATE TABLE IF NOT EXISTS `repairpoints` (
  `repairpointID` int(10) NOT NULL,
  `repairpointPosX` varchar(128) NOT NULL default '0.0',
  `repairpointPosY` varchar(128) NOT NULL default '0.0',
  `repairpointPosZ` varchar(128) NOT NULL default '0.0',
  `repairpointInterior` int(10) NOT NULL default '0',
  `repairpointVirtualWorld` int(10) NOT NULL default '0',
  `repairpointFee` int(10) NOT NULL default '5',
  PRIMARY KEY  (`repairpointID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

INSERT INTO `repairpoints` (`repairpointID`, `repairpointPosX`, `repairpointPosY`, `repairpointPosZ`, `repairpointInterior`, `repairpointVirtualWorld`, `repairpointFee`) VALUES
(1, '0.0', '0.0', '0.0', 0, 0, 5),
(2, '0.0', '0.0', '0.0', 0, 0, 5),
(3, '0.0', '0.0', '0.0', 0, 0, 5),
(4, '0.0', '0.0', '0.0', 0, 0, 5),
(5, '0.0', '0.0', '0.0', 0, 0, 5),
(6, '0.0', '0.0', '0.0', 0, 0, 5),
(7, '0.0', '0.0', '0.0', 0, 0, 5),
(8, '0.0', '0.0', '0.0', 0, 0, 5),
(9, '0.0', '0.0', '0.0', 0, 0, 5),
(10, '0.0', '0.0', '0.0', 0, 0, 5),
(11, '0.0', '0.0', '0.0', 0, 0, 5),
(12, '0.0', '0.0', '0.0', 0, 0, 5),
(13, '0.0', '0.0', '0.0', 0, 0, 5),
(14, '0.0', '0.0', '0.0', 0, 0, 5),
(15, '0.0', '0.0', '0.0', 0, 0, 5),
(16, '0.0', '0.0', '0.0', 0, 0, 5),
(17, '0.0', '0.0', '0.0', 0, 0, 5),
(18, '0.0', '0.0', '0.0', 0, 0, 5),
(19, '0.0', '0.0', '0.0', 0, 0, 5),
(20, '0.0', '0.0', '0.0', 0, 0, 5),
(21, '0.0', '0.0', '0.0', 0, 0, 5),
(22, '0.0', '0.0', '0.0', 0, 0, 5),
(23, '0.0', '0.0', '0.0', 0, 0, 5),
(24, '0.0', '0.0', '0.0', 0, 0, 5),
(25, '0.0', '0.0', '0.0', 0, 0, 5);

[Vince]

Open phpMyAdmin and click the button that reads 'Query window' in the left pane. Paste all of your queries there and hit execute.

[OpticKiller]

Thanks Vince

[OpticKiller]

hmm getting this error for some reason.

Код:

SQL query:

CREATE TABLE IF NOT EXISTS  `repairpoints` (

 `repairpointID` INT( 10 ) NOT NULL ,
 `repairpointPosX` VARCHAR( 128 ) NOT NULL DEFAULT  '0.0',
 `repairpointPosY` VARCHAR( 128 ) NOT NULL DEFAULT  '0.0',
 `repairpointPosZ` VARCHAR( 128 ) NOT NULL DEFAULT  '0.0',
 `repairpointInterior` INT( 10 ) NOT NULL DEFAULT  '0',
 `repairpointVirtualWorld` INT( 10 ) NOT NULL DEFAULT  '0',
 `repairpointFee` INT( 10 ) NOT NULL DEFAULT  '5',
PRIMARY KEY (  `repairpointID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 ROW_FORMAT = DYNAMIC ;

MySQL said: