芝麻web文件管理V1.00
编辑当前文件:/home2/sdektunc/yii/demos/blog/protected/data/blog.db
SQLite format 3 @ -% l l 'ApprovedCommentStatus# - ' Pending ApprovalCommentStatus !ArchivedPostStatus !PublishedPostStatus ! DraftPostStatus tbl_tag# tbl_commenttbl_post tbl_user!tbl_lookup \ 7 demo$2a$10$JTJf6/XqC94rrOtzuF397OHa4mbmZrVTBOQCmYD9U.obZRUut4BoCwebmaster@example.com ` # A Test PostLorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.testI^I^" Welcome!This blog system is developed using Yii. It is meant to demonstrate how to use Yii to build a complete real-world application. Complete source code may be found in the Yii releases. Feel free to try this system by writing new posts and leaving comments.yii, blogI^I^ > ;1 This is a test comment.I^Testertester@example.com ~ ~Z Y!!}tabletbl_lookuptbl_lookupCREATE TABLE tbl_lookup ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name VARCHAR(128) NOT NULL, code INTEGER NOT NULL, type VARCHAR(128) NOT NULL, position INTEGER NOT NULL )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)Pstabletbl_usertbl_userCREATE TABLE tbl_user ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, username VARCHAR(128) NOT NULL, password CHAR(64) NOT NULL, email VARCHAR(128) NOT NULL, profile TEXT )~Otabletbl_posttbl_postCREATE TABLE tbl_post ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, title VARCHAR(128) NOT NULL, content TEXT NOT NULL, tags TEXT, status INTEGER NOT NULL, create_time INTEGER, update_time INTEGER, author_id INTEGER NOT NULL, CONSTRAINT FK_post_author FOREIGN KEY (author_id) REFERENCES tbl_user (id) ON DELETE CASCADE ON UPDATE RESTRICT ) i tabletbl_tagtbl_tag CREATE TABLE tbl_tag ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name VARCHAR(128) NOT NULL, frequency INTEGER DEFAULT 1 )##otabletbl_commenttbl_commentCREATE TABLE tbl_comment ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, content TEXT NOT NULL, status INTEGER NOT NULL, create_time INTEGER, author VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, url VARCHAR(128), post_id INTEGER NOT NULL, CONSTRAINT FK_comment_post FOREIGN KEY (post_id) REFERENCES tbl_post (id) ON DELETE CASCADE ON UPDATE RESTRICT ) test blog yii