Results 1 to 8 of 8
Thread: - - !
Hybrid View
-
14th September 2009 15:20 #1
- - !
. . . - , - . MySQL PostgresSQL. , - -. UTF-8, Apache-PHP, OOo Delphi. - . - . , .
- -
, :
123 4
: , ,
:
: , ,
: ,
. , 1-, 2-, 3- 4-
8, 16, 32 64 . , 16 32 .
:
: , ,
/
:
: , ,
:
: , ,
, :
: 4-99
:,
9, 8... 1, 1, 2, 3...
: , , , , ICQ,
/ :
:
: , , , ,
:
: , , , , ICQ,
<-> <->
-
15th September 2009 18:36 #2
, . " " karateka . - = , . " " .Code:CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`karateka` ( `id_karateka` INT UNSIGNED NOT NULL, `name` TINYTEXT NOT NULL, `pol` ENUM( 'm', 'f' ) NOT NULL default 'm', `rajdane` DATE NOT NULL, `stepen` ENUM( '9k', '8k', '7k', '6k', '5k', '4k', '3k', '2k', '1k', '1d', '2d', '3d', '4d', '5d', '6d', '7d', '8d', '9d' ) NOT NULL default '9k', `type` ENUM( '1', '2', '3', '4' ) NOT NULL default '1' COMMENT '1 - sastezatel, 2 - trenior, 3 - pomostnik trenior, 4 - sekretar', `id_contact` INT UNSIGNED NOT NULL , `id_club` INT UNSIGNED NOT NULL , PRIMARY KEY ( `id_karateka` ) ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`club` ( `id_club` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` TINYTEXT NOT NULL , `id_contact` INT UNSIGNED NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`contact` ( `id_contact` INT UNSIGNED NOT NULL , `tel1` VARCHAR(20) NULL , `tel2` VARCHAR(20) NULL , `email` VARCHAR(20) NULL , `skype` VARCHAR(20) NULL , `icq` VARCHAR(20) NULL , `address` TINYTEXT NULL , `info` TINYTEXT NULL , PRIMARY KEY ( `id_contact` ) ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`competition` ( `id_competition` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` TINYTEXT NOT NULL , `data` DATE NOT NULL, `id_contact` INT UNSIGNED NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`category` ( `id_category` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `id_competition` INT UNSIGNED NOT NULL, `name` TINYTEXT NOT NULL , `min_age` TINYINT(100) UNSIGNED, `max_age` TINYINT(100) UNSIGNED, `min_rank` ENUM( '9k', '8k', '7k', '6k', '5k', '4k', '3k', '2k', '1k', '1d', '2d', '3d', '4d', '5d', '6d', '7d', '8d', '9d' ), `max_rank` ENUM( '9k', '8k', '7k', '6k', '5k', '4k', '3k', '2k', '1k', '1d', '2d', '3d', '4d', '5d', '6d', '7d', '8d', '9d' ), `pol` ENUM( 'm', 'f', 'mf' ) NOT NULL default 'm' ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
, .
-
21st September 2009 00:01 #3
. . category_kat category_kum . 1-6 s1-6 . , enum "y" "n" . - , - . !
Code:CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`contact` ( `id_contact` INT UNSIGNED NOT NULL AUTO_INCREMENT, `tel1` VARCHAR(20) NULL , `tel2` VARCHAR(20) NULL , `email` VARCHAR(20) NULL , `skype` VARCHAR(20) NULL , `icq` VARCHAR(20) NULL , `address` TINYTEXT NULL , `info` TINYTEXT NULL , PRIMARY KEY ( `id_contact` ) ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`karateka` ( `id_karateka` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` TINYTEXT NOT NULL, `pol` ENUM( 'm', 'f' ) NOT NULL default 'm', `rajdane` DATE NOT NULL, `kilogrami` TINYINT UNSIGNED, `stepen` ENUM( '9k', '8k', '7k', '6k', '5k', '4k', '3k', '2k', '1k', '1d', '2d', '3d', '4d', '5d', '6d', '7d', '8d', '9d' ) NOT NULL default '9k', `type` ENUM( '1', '2', '3', '4' ) NOT NULL default '1' COMMENT '1 - sastezatel, 2 - trenior, 3 - pomostnik trenior, 4 - sekretar', `id_contact` INT UNSIGNED, `id_club` INT UNSIGNED NOT NULL, ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`club` ( `id_club` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` TINYTEXT NOT NULL, `id_contact` INT UNSIGNED ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`competition` ( `id_competition` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` TINYTEXT NOT NULL , `data` DATE NOT NULL, `id_contact` INT UNSIGNED ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`category` ( `id_category` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `id_competition` INT UNSIGNED NOT NULL, `name` TINYTEXT NOT NULL , `kat_kum` ENUM('kat', 'kum') NOT NULL, `min_age` TINYINT(100) UNSIGNED, `max_age` TINYINT(100) UNSIGNED, `max_kilogrami` TINYINT UNSIGNED, `min_rank` ENUM( '9k', '8k', '7k', '6k', '5k', '4k', '3k', '2k', '1k', '1d', '2d', '3d', '4d', '5d', '6d', '7d', '8d', '9d' ), `max_rank` ENUM( '9k', '8k', '7k', '6k', '5k', '4k', '3k', '2k', '1k', '1d', '2d', '3d', '4d', '5d', '6d', '7d', '8d', '9d' ), `pol` ENUM( 'm', 'f', 'mf' ) NOT NULL default 'm' ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`karatekas` ( `id_karateka` INT UNSIGNED NOT NULL, `id_category` INT UNSIGNED NOT NULL, PRIMARY KEY (`id_karateka`, `id_category`) ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`category_kat` ( `category_kat` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `id_category` INT UNSIGNED NOT NULL, `game` INT UNSIGNED NOT NULL, `a_id_karateka` INT UNSIGNED, `s_id_karateka` INT UNSIGNED, `winner` INT UNSIGNED, `a1` REAL(2, 1), `a2` REAL(2, 1), `a3` REAL(2, 1), `a4` REAL(2, 1), `a5` REAL(2, 1), `a6` REAL(2, 1), `s1` REAL(2, 1), `s2` REAL(2, 1), `s3` REAL(2, 1), `s4` REAL(2, 1), `s5` REAL(2, 1), `s6` REAL(2, 1) ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `test2`.`category_kum` ( `category_kum` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `id_category` INT UNSIGNED NOT NULL, `game` INT UNSIGNED NOT NULL, `a_id_karateka` INT UNSIGNED, `s_id_karateka` INT UNSIGNED, `winner` INT UNSIGNED ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
www.karatebulgaria.com/alex
-
21st September 2009 10:57 #4
category_kat category_kum category.
category_detail , ( ) ( ).Ar4i
-
21st September 2009 11:20 #5
Ar4i!

category_kat / .
id_category.
game. 15 8 . 16 ( 3 4 ) 13 14 .
2 (Aka) (Shiro).
:
1. ( , ) . . 5 , . "6" "s6" . - - winner.
2. . , 5 5- a1 5. , 5 s1 s5.
"" ? - - . 6 s6 . ID- - winner.
2.1 "" a6 s6 . .
2.2 . a6 s6. " " , 5- , 5 . a6 s6.
, . . .
, .
category_kat id_category game. - -, - .
- 16 , 15. game 8 winner.
======================================== =
kategory_kum winner. . , . .
-
23rd September 2009 23:38 #6Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
:
num- , stepen type karateka - 2 stepen type ID- .
, : table_name_id TableNameID " " - "type", "address", "info" "rajdane", "stepen", "pol" .. auto_increment ID ( )
foreign keys - mysql 1:1 :
CREATE TABLE `test2`.`category_kat` (
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`category_id` INT UNSIGNED NOT NULL references category( id ),
......
)
- . category_kum winner .
- contact, karateka club ? 1 , 1 , .. .prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
24th September 2009 10:20 #7
, /. " " ->
. . , . ...- , /
:
( , MySQL , , ):
1. . "", "", "". - .
2. . , - . , .. - --, -- .. - . , -- ...
3. - , , . (, 5 , , ). ( / ) run time .
- , , ...
- , , ( )... - ...
.. .
4. - .. MySQL/Postgre - ( .2) ... : , , ... -- ( )...
-
24th September 2009 19:39 #8Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
- - .
- 1 - , :
/
.
- , ID ( ) - .
ID table_name_ID - hungarian notation ( ). .
-
: 15 ...prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in