mysql - #1005 - Cant create table... (errno: 150) -

-

i have primary keys , drop tables in correct order.

i want stockid foreign key in refund table.

my schema looks this...

create table refunds ( refundid smallint auto_increment, stockid smallint, refunddate date, foreign key (stockid) references tblstock(stockid), primary key (refundid) );  create table tblstock ( stockid smallint auto_increment, stockname varchar(60), stocknumbers smallint );

when referencing table foreign key reference, table needs exist. and, column being referenced should primary key. try this:

create table tblstock (   stockid smallint auto_increment primary key,   stockname varchar(60),   stocknumbers smallint );  create table refunds (   refundid smallint auto_increment,   stockid smallint,   refunddate date,   foreign key (stockid) references tblstock(stockid),   primary key (refundid) );

Comments

Post a Comment

Popular posts from this blog

rest - Spring boot: Request method 'PUT' not supported -

-
i getting request method 'put' not supported error on hitting put method on restful api upload file. following information uploaded ticket. client log restcontroller spring boot app config tomcat log pom.xml 1. client log $ curl -x put -t "/cygdrive/c/a/documents/test.pptx" http://localhost:8080/piranha-storage-service/buckets/gnaval.bucket1/test.pptx <html><head><title>apache tomcat/7.0.52 - error report</title><style><!--h1 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:22px;} h2 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:16px;} h3 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:14px;} body {font-family:tahoma,arial,sans-serif;color:black;background-color:white;} b {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;} p {font-family:tahoma,arial,sans-serif;background:white;co...
Read more

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp...
Read more

symfony - imagine_filter() not generating the correct url in LiipImagineBundle -

-
i think there bug in bundle liipimaginebundle. explain: here new config of bundle: liip_imagine: resolvers: default: web_path: web_root: %kernel.root_dir%/../web/img # %kernel.root_dir%/../web/img folder filtered images created! cache_prefix: media/cache # media/cache prefix of folder cached images created filter_sets: cache: ~ my_thumb: quality: 75 filters: thumbnail: { size: [120, 90], mode: outbound } this twig part displaying image: {# way filtered image not created!#} <img src="{{ 'img/test.jpg' | imagine_filter('my_thumb') }}" /> {# way, filted images created. asset() must used. #} <img src="{{ asset('img/test.jpg' | imagine_filter('my_thumb')) }}" /> the generated link of image not correct! in fact, obtained link is: http://localhost/media/cache...
Read more