for-kr-3-sql

/*
 * creation DB for lab
 */

use [master]
drop database if exists [kr3];
create database [kr3];
use [kr3];


create table [Animator] (
    [ID]            integer identity(1,1),

    [Number]        char        not null,
    [Fired]         date        null        default('100622'),
    [TestPole]      int         not null    default(CRYPT_GEN_RANDOM(1))

    primary key([ID])
);

insert into [Animator]([Number]) values('q'),('e'),('t'),('c');

select * from [Animator]