Tema: Re: mysql LT raides
Autorius: bambukas
Data: 2009-12-17 17:06:34
pabandyk su kokiu "HeidiSQL" prisijungti
pasidaryk lenele:


CREATE TABLE `sutartys` (

`autonumer` int(11) NOT NULL auto_increment,

`eil_nr` decimal(18,0) default NULL,

`sut_pasirasymo_data` date default NULL,

`sut_reg_nr` decimal(18,0) default NULL,

`sut_nr` varchar(50) character set utf8 collate utf8_lithuanian_ci default 
NULL,

`imon_pavadin` varchar(50) character set utf8 collate utf8_lithuanian_ci 
default NULL,

`rekvizitai_adr` varchar(250) character set utf8 collate utf8_lithuanian_ci 
default NULL,

`rekvizitai_tel` varchar(50) character set utf8 collate utf8_lithuanian_ci 
default NULL,

`imon_kodas` int(11) default NULL,

`sut_isigal_data` date default NULL,

`galioja_iki` date default NULL,

`terminuota` enum('TAIP','NE') default 'NE',

`galioja` enum('TAIP','NE') default 'TAIP',

`sutart_dalykas` varchar(250) character set utf8 collate utf8_lithuanian_ci 
default NULL,

`salygos` varchar(250) character set utf8 collate utf8_lithuanian_ci default 
NULL,

`irase_kas` varchar(50) character set utf8 collate utf8_lithuanian_ci 
default NULL,

`irase_kada` timestamp NOT NULL default CURRENT_TIMESTAMP,

`taise_kas` varchar(50) character set utf8 collate utf8_lithuanian_ci 
default NULL,

`taise_kada` datetime default NULL,

`obj_id` int(11) default NULL,

PRIMARY KEY (`autonumer`),

KEY `autonumer` (`autonumer`)

) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8;


"N" <nesvarbu@nera.lt> wrote in message 
news:hg8tnc$dbh$1@trimpas.omnitel.net...
> Naujokas su mysql baze gal padesit kuriant lentele kokia kodacija naudojat 
> kad nebutu problema su lietuviskomis raidemis nes dabar kiek bandau keisti 
> vis meta errorus bandant insertinti koki zodi su lt raidem ?
>
>