Location: PHPKode > projects > Openology PHP Application Integration > openology/install/sql.txt
CREATE TABLE bbb_user (
ID INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
ad_name VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
ad_pass VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE bbb_file (
ID INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
filename VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
) TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Return current item: Openology PHP Application Integration