Changeset 297 for quests/structure/banner.sql

Timestamp:

Feb 8, 2008, 11:08:10 PM (17 years ago)

Author:

maron

Message:

Zobrazení serverů odkazující na nás, filtr

File:

• quests/structure/banner.sql (modified) (1 diff)

quests/structure/banner.sql

@@ +1 @@
+- phpMyAdmin SQL Dump
+-- version 2.9.1.1
+-- http://www.phpmyadmin.net
+-- 
+-- Host: localhost
+-- Generation Time: Feb 08, 2008 at 11:09 PM
+-- Server version: 5.0.27
+-- PHP Version: 5.2.0
+-- 
+-- Database: `quests`
+-- 
 
+-- --------------------------------------------------------
 
+-- 
+-- Table structure for table `banner`
+-- 
 
 CREATE TABLE `banner` (
-`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`Date` DATETIME NOT NULL ,
-`Web` TEXT NOT NULL
-) ENGINE = MYISAM ;
+  `ID` int(11) NOT NULL auto_increment,
+  `Date` datetime NOT NULL,
+  `Web` text NOT NULL,
+  `Show` int(11) NOT NULL default '1',
+  `Description` text NOT NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `Show` (`Show`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
+
+/*
+ALTER TABLE `banner` ADD `Show` INT NOT NULL DEFAULT '1',
+ADD `Description` TEXT NOT NULL ;
+
+ALTER TABLE `banner` ADD INDEX ( `Show` ) ;
+*/