Changeset 109 for db/databaze_tabulky/sql.sql

Timestamp:

Oct 14, 2007, 1:35:47 PM (17 years ago)

Author:

hosiplan

Message:

+ možnost přihlásit se jako v minimanageru tzn. na herní ACC
+ jednoduchá administrace
+ správa bugů z bugreporter
+ export characteru
+ hledání creepů + jejich drop
+ úprava databáze

File:

• db/databaze_tabulky/sql.sql (modified) (3 diffs)

db/databaze_tabulky/sql.sql

@@ -21 +21 @@
 
 CREATE TABLE `bug_report` (
-  `id` int(11) unsigned NOT NULL auto_increment,
-  `nick` varchar(50) NOT NULL,
-  `typ` varchar(250) NOT NULL,
-  `vlozeno` bigint(20) unsigned NOT NULL,
+  `id` int( 11 ) unsigned NOT NULL auto_increment,
+  `nick` varchar( 50 ) NOT NULL,
+  `typ` varchar( 250 ) NOT NULL,
+  `vlozeno` bigint( 20 ) unsigned NOT NULL,
   `popis` text NOT NULL,
   `opraveno` enum('0','1') NOT NULL default '0',
   `popis_opravy` text NOT NULL,
-  `opravil` bigint(20) unsigned NOT NULL,
-  `opravil_nick` varchar(50) NOT NULL,
+  `opravil` bigint( 20 ) unsigned NOT NULL,
+  `opravil_nick` varchar( 50 ) NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Bug report system' AUTO_INCREMENT=1 ;
@@ -41 +41 @@
 
 CREATE TABLE `komentare` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `vlozil` text NOT NULL,
-  `vlozil_nick` varchar(50) NOT NULL,
-  `prava` varchar(100) NOT NULL default 'Hráč',
-  `kdy` text NOT NULL,
+  `id` BIGINT( 20 ) unsigned NOT NULL auto_increment,
+  `vlozil_nick` varchar( 50 ) NOT NULL,
+  `prava` varchar( 100 ) NOT NULL default 'Hráč',
+  `kdy` BIGINT( 20 ) NOT NULL,
   `komentar` text NOT NULL,
-  `ceho` text NOT NULL,
-  `ceho_id` bigint(20) unsigned NOT NULL,
+  `ceho` varchar( 50 ) NOT NULL,
+  `ceho_id` BIGINT( 20 ) unsigned NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
@@ -60 +59 @@
 
 CREATE TABLE `klice` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `klic` varchar(20) NOT NULL,
+  `id` int( 10 ) unsigned NOT NULL auto_increment,
+  `klic` varchar( 20 ) NOT NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `klic` (`klic`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- 
+-- Struktura tabulky `acc_online`
+-- 
+-- Vytvoření: Sobota 13. října 2007, 12:45
+-- Poslední změna: Sobota 13. října 2007, 12:45
+-- 
+
+CREATE TABLE `acc_online` (
+`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`nick` VARCHAR( 50 ) NOT NULL ,
+`phpsession` VARCHAR( 32 ) NOT NULL ,
+`hodnost` SMALLINT( 3 ) UNSIGNED NOT NULL ,
+`dateoflogin` BIGINT( 20 ) UNSIGNED NOT NULL
+) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
+
+-- 
+-- Struktura tabulky `acc_down_char`
+-- 
+-- Vytvoření: Sobota 13. října 2007, 13:47
+-- Poslední změna: Sobota 13. října 2007, 13:47
+-- 
+
+CREATE TABLE `acc_down_char` (
+`id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`acc` VARCHAR( 20 ) NOT NULL ,
+`char` VARCHAR( 20 ) NOT NULL ,
+`date` BIGINT( 20 ) UNSIGNED NOT NULL ,
+`ip` VARCHAR( 15 ) UNSIGNED NOT NULL
+) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;