Parašė ZW· 2009 Kov. 18 14:03:57
#3
Downloads skilti ar lentelia... Gal galima tiksliau... Su
mysql ma sekasi silpnai...
Tai gal kas parasytu download ir download_cats sql uzklausa kaip per nauja lenteles padaryt... tada senas visiskai istrinciau
-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Darbinė stotis: mysql2.bendras.com
-- Atlikimo laikas: 2009 m. Kovo 18 d. 14:25
-- Serverio versija: 5.0.32
-- PHP versija: 5.2.2-2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Duombazė: `******`
--
-- --------------------------------------------------------
--
-- Sukurta duomenų struktūra lentelei `fusion_downloads`
--
CREATE TABLE IF NOT EXISTS `fusion_downloads` (
`download_id` smallint(5) unsigned NOT NULL auto_increment,
`download_title` varchar(100) collate utf8_lithuanian_ci NOT NULL default '',
`download_description` text collate utf8_lithuanian_ci NOT NULL,
`download_url` varchar(200) collate utf8_lithuanian_ci NOT NULL default '',
`download_cat` smallint(5) unsigned NOT NULL default '0',
`download_license` varchar(50) collate utf8_lithuanian_ci NOT NULL default '',
`download_os` varchar(50) collate utf8_lithuanian_ci NOT NULL default '',
`download_version` varchar(20) collate utf8_lithuanian_ci NOT NULL default '',
`download_filesize` varchar(20) collate utf8_lithuanian_ci NOT NULL default '',
`download_datestamp` int(10) unsigned NOT NULL default '0',
`download_count` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci AUTO_INCREMENT=1 ;
--
-- Sukurta duomenų kopija lentelei `fusion_downloads`
--
Teisingas butu tokia uzklausa...???
Redagavo ZW· 2009 Kov. 18 14:03:56