db.sql

关于ajax在web2.0中的应用(主要是实例程序)

DROP TABLE IF EXISTS ALBUM;
CREATE TABLE  ALBUM (
  ALBUM_ID int(16) NOT NULL auto_increment,
  ALBUM_NAME varchar(255) NOT NULL default '',
  ALBUM_URL varchar(255) NOT NULL default '',
  ALBUM_DESC varchar(255) NOT NULL default '',
  ALBUM_CATEGORY varchar(32) NOT NULL default '',
  ACTIVE_STATUS varchar(4) NOT NULL default 'Y',
  PRIMARY KEY  (ALBUM_ID)
) TYPE=MyISAM ;

INSERT INTO ALBUM VALUES(1,'Landscape one','landscape1.jpg','This is a picture landscape one','LANDSCAPE','Y');
INSERT INTO ALBUM VALUES(2,'Landscape two','landscape2.jpg','This is a picture landscape two','LANDSCAPE','Y');
INSERT INTO ALBUM VALUES(3,'Landscape three','landscape3.jpg','This is a picture landscape three','LANDSCAPE','Y');
INSERT INTO ALBUM VALUES(4,'Landscape four','landscape4.jpg','This is a picture landscape four','LANDSCAPE','Y');
INSERT INTO ALBUM VALUES(5,'Landscape five','landscape5.jpg','This is a picture landscape five','LANDSCAPE','Y');
INSERT INTO ALBUM VALUES(6,'Landscape six','landscape6.jpg','This is a picture landscape six','LANDSCAPE','Y');

INSERT INTO ALBUM VALUES(7,'Tree one','tree1.jpg','This is a picture tree one','TREE','Y');
INSERT INTO ALBUM VALUES(8,'Tree two','tree2.jpg','This is a picture tree two','TREE','Y');
INSERT INTO ALBUM VALUES(9,'Tree three','tree3.jpg','This is a picture tree three','TREE','Y');
INSERT INTO ALBUM VALUES(10,'Tree four','tree4.jpg','This is a picture tree four','TREE','Y');
INSERT INTO ALBUM VALUES(11,'Tree five','tree5.jpg','This is a picture tree five','TREE','Y');
INSERT INTO ALBUM VALUES(12,'Tree six','tree6.jpg','This is a picture tree six','TREE','Y');

INSERT INTO ALBUM VALUES(13,'Bird one','bird1.jpg','This is a picture  bird one','BIRD','Y');
INSERT INTO ALBUM VALUES(14,'Bird two','bird2.jpg','This is a picture  bird two','BIRD','Y');
INSERT INTO ALBUM VALUES(15,'Bird three','bird3.jpg','This is a picture  bird three','BIRD','Y');
INSERT INTO ALBUM VALUES(16,'Bird four','bird4.jpg','This is a picture  bird four','BIRD','Y');
INSERT INTO ALBUM VALUES(17,'Bird five','bird5.jpg','This is a picture  bird five','BIRD','Y');
INSERT INTO ALBUM VALUES(18,'Bird six','bird6.jpg','This is a picture  bird six','BIRD','Y');