Results 1 to 8 of 8

Thread: - - !

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User a_panov's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 45

    Exclamation - - !

    . . . - , - . 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,

    <-> <->

  2. #2
    Registered User a_panov's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 45

    Talking

    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;
    , . " " karateka . - = , . " " .

    , .

  3. #3
    Registered User a_panov's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 45

    Exclamation

    . . 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

  4. #4
    Master of Magic Ar4i's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 6,563
    category_kat category_kum category.
    category_detail , ( ) ( ).
    Ar4i

  5. #5
    Registered User a_panov's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 45
    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. . , . .

  6. #6
    Registered 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?

  7. #7
    Registered User a_panov's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 45
    , /. " " ->
    - , /

    :

    ( , MySQL , , ):

    1. . "", "", "". - .

    2. . , - . , .. - --, -- .. - . , -- ...

    3. - , , . (, 5 , , ). ( / ) run time .
    - , , ...
    - , , ( )... - ...

    .. .

    4. - .. MySQL/Postgre - ( .2) ... : , , ... -- ( )...

    . . , . ...

  8. #8
    Registered 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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |