SX1H8BSs

1CREATE TABLE IF NOT EXISTS `gangs_wars` (
2  `id` int(11) NOT NULL,
3  `g1point` int(11) NOT NULL DEFAULT '0',
4  `g2point` int(11) NOT NULL DEFAULT '0',
5  `g1` int(11) NOT NULL,
6  `g2` int(11) NOT NULL,
7  `gfile` varchar(32) NOT NULL DEFAULT 'notfile.ini',
8  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
9  `htmlpng` varchar(64) NOT NULL DEFAULT 'brak.html|brak.png' COMMENT 'Nazwa plikow z danymi o sparze',
10  `playerscores` text NOT NULL
11) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin2;
12
13
14ALTER TABLE `gangs_wars`
15  ADD PRIMARY KEY (`id`);
16
17ALTER TABLE `gangs_wars`
18  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;