+44 (0)785 715 1348
office@bogdans.co.uk

Currently Browsing: YII

YII blog database schema example 0

Posted on 28, March 2013

in Category Web development

YII blog example comes with a default database schema. Here’s the code to build it. CREATE TABLE tbl_lookup ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(128) NOT NULL, code INTEGER NOT NULL, type VARCHAR(128) NOT NULL, position INTEGER NOT NULL ); CREATE TABLE tbl_user ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, username VARCHAR(128) NOT NULL, password VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, profile TEXT ); CREATE TABLE tbl_post ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, title VARCHAR(128) NOT NULL, content TEXT NOT NULL, tags TEXT, status INTEGER NOT NULL, create_time INTEGER, [&hellip

Read More