Mājas lapas izveide - ātri, lēti un kvalitatīvi

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Hosts: localhost
-- Izveidošanas laiks: 28.02.2010 01:56
-- Servera versija: 5.1.37
-- PHP Versija: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datubāze: `draugiem.lv`
--

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `ferma`
--

CREATE TABLE IF NOT EXISTS `ferma` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`price` int(2) NOT NULL,
`earning` int(2) NOT NULL,
`xp` int(2) NOT NULL,
`level` int(2) NOT NULL,
`maxlevel` int(2) NOT NULL,
`time` float NOT NULL,
`image` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

--
-- Dati tabulai `ferma`
--

INSERT INTO `ferma` (`id`, `name`, `price`, `earning`, `xp`, `level`, `maxlevel`, `time`, `image`) VALUES
(1, 'Salati', 9, 11, 3, 0, 10, 1.5, 'ferma_2.jpg'),
(2, 'Spinati', 15, 28, 5, 0, 13, 6, 'ferma_7.jpg'),
(3, 'Redisi', 50, 63, 3, 0, 10, 8, 'ferma_1.jpg'),
(4, 'Skabenes', 30, 37, 5, 2, 12, 4, 'ferma_3.jpg'),
(5, 'Meza zemenes', 15, 34, 5, 4, 14, 8, 'ferma_4.jpg'),
(6, 'Burkani', 32, 38, 3, 0, 10, 4, 'ferma_5.jpg'),
(7, 'Petersili', 30, 43, 4, 1, 11, 6, 'ferma_6.jpg'),
(8, 'Aboli', 300, 1540, 490, 4, 9999, 360, 'ferma_8.jpg'),
(9, 'Dilles', 30, 62, 5, 5, 15, 12, 'ferma_dille.jpg'),
(10, 'Rutki', 80, 88, 8, 6, 16, 4, 'ferma_rutks.jpg'),
(11, 'Bietes', 60, 74, 8, 7, 17, 6, 'ferma_biete.jpg'),
(12, 'Puravi', 100, 120, 8, 8, 9999, 8, 'ferma_puravs.jpg'),
(13, 'Bumbiere', 500, 2520, 560, 8, 9999, 360, 'ferma_bumbiere.jpg'),
(14, 'Selerijas', 130, 168, 8, 9, 21, 12, 'ferma_selerija.jpg'),
(15, 'Sipoli', 75, 85, 12, 10, 22, 4, 'ferma_sipols.jpg'),
(16, 'Pupas', 60, 80, 12, 11, 21, 6, 'ferma_pupa.jpg'),
(17, 'Soja', 120, 150, 12, 12, 22, 8, 'ferma_soja.jpg'),
(18, 'Japanas Kirsis', 1000, 3290, 630, 12, 9999, 360, 'ferma_kirsis.jpg'),
(19, 'Rapsis', 200, 246, 12, 13, 23, 12, 'ferma_rapsis.jpg'),
(20, 'Paprika', 100, 136, 15, 14, 24, 12, 'ferma_paprika.jpg'),
(21, 'Kviesi', 100, 110, 12, 15, 25, 6, 'ferma_kviesi.jpg'),
(22, 'Marutki', 200, 260, 15, 15, 26, 16, ''),
(23, 'Tomati', 300, 380, 15, 16, 26, 20, ''),
(24, 'Kabaci', 400, 520, 15, 17, 27, 24, ''),
(25, 'Kirbi', 450, 475, 18, 18, 28, 8, ''),
(26, 'Patisoni', 500, 540, 18, 19, 29, 12, ''),
(27, 'Miezi', 150, 180, 15, 20, 9999, 10, ''),
(28, 'Kaposti', 630, 680, 18, 20, 30, 14, ''),
(29, 'Ziedkaposti', 540, 620, 20, 21, 31, 16, ''),
(30, 'Brokoli', 700, 800, 20, 22, 32, 20, ''),
(31, 'Kartupeli', 600, 730, 20, 23, 33, 24, ''),
(32, 'Sampinjoni', 670, 800, 22, 24, 34, 18, ''),
(33, 'Janoga', 1600, 4620, 630, 24, 9999, 360, ''),
(34, 'Rudzi', 250, 300, 20, 25, 9999, 14, ''),
(35, 'Gurki', 800, 880, 23, 25, 50, 16, ''),
(36, 'Kukuruza', 850, 970, 25, 26, 50, 20, ''),
(37, 'Cili', 300, 340, 26, 27, 50, 10, ''),
(38, 'Saules Puke', 500, 580, 27, 28, 50, 14, ''),
(39, 'Kiploki', 705, 800, 28, 29, 50, 16, ''),
(40, 'Raceni', 525, 610, 30, 30, 50, 14, ''),
(41, 'Dzervenes', 706, 805, 30, 31, 50, 16, ''),
(42, 'Kinas Kaposts', 800, 925, 31, 32, 55, 20, ''),
(43, 'Arbuzs', 750, 823, 32, 33, 55, 12, ''),
(44, 'Rabarbers', 850, 950, 33, 34, 55, 16, ''),
(45, 'Raudene', 530, 560, 35, 35, 40, 8, ''),
(46, 'Upenes', 2100, 5600, 700, 36, 9999, 360, ''),
(47, 'Ingvers', 610, 675, 45, 40, 60, 10, ''),
(48, 'Topinamburs', 715, 800, 50, 50, 65, 12, '');