There is something else going on. This is the log (no errors creating
tables) of the following model on mysql 5.5. web2py trunk (but at least on
table creation nothing should have changed since 1.99.7)
db.define_table('book',
Field('bookname')
)
db.define_table('bookpage',
Field('content', 'text'),
Field('image', 'upload'),
Field('from_book', db.book),
Field('modified_on', 'datetime', default=request.now))
db.bookpage.content.requires = IS_NOT_EMPTY()
db.bookpage.from_book.requires = IS_NOT_EMPTY()
db.bookpage.modified_on.writable = False
db.define_table('page_link',
Field('in_page', db.bookpage),
Field('out_page', db.bookpage),
Field('the_text'))
timestamp: 2012-08-24T17:58:04.909000
CREATE TABLE book(
id INT AUTO_INCREMENT NOT NULL,
bookname VARCHAR(255),
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
success!
timestamp: 2012-08-24T17:58:04.937000
CREATE TABLE bookpage(
id INT AUTO_INCREMENT NOT NULL,
content LONGTEXT,
image VARCHAR(255),
from_book INT, INDEX from_book__idx (from_book), FOREIGN KEY
(from_book)REFERENCES book
(id) ON DELETE CASCADE,
modified_on DATETIME,
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
success!
timestamp: 2012-08-24T17:58:04.959000
CREATE TABLE page_link(
id INT AUTO_INCREMENT NOT NULL,
in_page INT, INDEX in_page__idx (in_page), FOREIGN KEY (in_page)REFERENCES
bookpage
(id) ON DELETE CASCADE,
out_page INT, INDEX out_page__idx (out_page), FOREIGN KEY
(out_page)REFERENCES bookpage
(id) ON DELETE CASCADE,
the_text VARCHAR(255),
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
success!
--
