HoffnungTR adlı üyeden alıntı:
mesajı görüntüle
CREATE TABLE `baskets` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `size_id` int(11) NOT NULL, `stocks` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; CREATE TABLE `products` ( `id` int(11) NOT NULL, `title` text COLLATE utf8_turkish_ci NOT NULL, `price` decimal(10,2) NOT NULL, `photo` text COLLATE utf8_turkish_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; CREATE TABLE `products_stocks` ( `id` int(11) NOT NULL, `finance_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `size_id` int(11) NOT NULL, `stocks` int(11) NOT NULL, `status` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; CREATE TABLE `sizes` ( `id` int(11) NOT NULL, `title` text COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci; ALTER TABLE `baskets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; ALTER TABLE `products_stocks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; ALTER TABLE `sizes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
