Zend Framework Tutorial 1 - Start here

November 15, 2006 on 4:26 pm | In Zend Framework |
After the infrastructure has been set up, I start my project. At the very beginning, I would like make the thing as simple as possible. Only one table in the database at this moment.

Due to the restriction by my web host, I only can name the database as

backupdi_bmdb

I only can change the part after ‘backupdi_‘,namely bmdb for this case.

The table name will be

bm_bmark

which I can name it myself. bmbmark is made of the first alphabet of book and mark. So, the MySQL schema would be stands for bookmark,

Code (mysql)
  1. CREATE DATABASE `backupdi_bmdb`;
  2. CREATE TABLE `bm_bmark` (
  3.   `bm_id` BIGINT(20) NOT NULL,
  4.   `bm_name` VARCHAR(64) DEFAULT NULL,
  5.   `bm_url` VARCHAR(128) DEFAULT NULL,
  6.   `bm_kword` VARCHAR(20) DEFAULT NULL,
  7.   `bm_des` VARCHAR(128) DEFAULT NULL COMMENT ‘Description’,
  8.   `bm_atime` DATETIME DEFAULT NULL COMMENT ‘add time’,
  9.   `bm_lmtime` DATETIME DEFAULT NULL COMMENT ‘last modify time’,
  10.   `bm_lvtime` DATETIME DEFAULT NULL COMMENT ‘last visit time’,
  11.   PRIMARY KEY  (`bm_id`)
  12. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  13.  

Save this SQL schema file as mysql_schema.sql to \bookmark\app\install


No Comments yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Since May 6,2007 We have Visitors
dog ramps

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^