ajax.sql

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

-- --------------------------------------------------------

--
-- Table structure for table 'AJAX_LAYOUT'
--
DROP TABLE IF EXISTS AJAX_LAYOUT;
CREATE TABLE  AJAX_LAYOUT (
  LAYOUT_ID int(16) NOT NULL auto_increment,
  USER_ID int(16) NOT NULL default '0',
  COL_NARROW_LEFT longtext,
  COL_NARROW_RIGHT longtext,
  COL_WIDE longtext,
  ACTIVE_STATUS varchar(4) NOT NULL default 'Y',
  PRIMARY KEY  (LAYOUT_ID)
) TYPE=MyISAM ;

--
-- Dumping data for table 'AJAX_LAYOUT'
--
INSERT INTO AJAX_LAYOUT VALUES (1,1,'1,2','3,4','5,6','Y');
INSERT INTO AJAX_LAYOUT VALUES (2,2,'1,2,3','4,5','6','Y');

-- --------------------------------------------------------

--
-- Table structure for table 'AJAX_PORTLET'
--
DROP TABLE IF EXISTS AJAX_PORTLET;
CREATE TABLE  AJAX_PORTLET (
  PORTLET_ID int(16) NOT NULL auto_increment,
  DISPLAY_NAME varchar(255) NOT NULL default '',
  JAVA_CLASS_NAME varchar(255) NOT NULL default '',
  ACTIVE_STATUS varchar(4) NOT NULL default 'Y',
  PRIMARY KEY  (PORTLET_ID)
) TYPE=MyISAM ;

--
-- Dumping data for table 'AJAX_PORTLET'
--
INSERT INTO AJAX_PORTLET VALUES (1,'Welcome','book.portal.portlet.Welcome','Y');
INSERT INTO AJAX_PORTLET VALUES (2,'Yahoo News','book.portal.portlet.YahooNews','Y');
INSERT INTO AJAX_PORTLET VALUES (3,'Sina News','book.portal.portlet.SinaNews','Y');
INSERT INTO AJAX_PORTLET VALUES (4,'Google News','book.portal.portlet.GoogleNews','Y');
INSERT INTO AJAX_PORTLET VALUES (5,'Bookmarks','book.portal.portlet.Bookmark','Y');
INSERT INTO AJAX_PORTLET VALUES (6,'Calender','book.portal.portlet.Calender','Y');

-- --------------------------------------------------------

--
-- Table structure for table 'AJAX_USER'
--

DROP TABLE IF EXISTS AJAX_USER;
CREATE TABLE  AJAX_USER (
  USER_ID int(16) NOT NULL auto_increment,
  USER_NAME varchar(255) NOT NULL default '',
  PASSWORD varchar(255) NOT NULL default '',
  DISPLAY_NAME varchar(255) NOT NULL default '',
  EMAIL_ADDRESS varchar(255) NOT NULL default '',
  PHONE_NUMBER varchar(128) default NULL,
  ACTIVE_STATUS varchar(4) NOT NULL default 'Y',
  PRIMARY KEY  (USER_ID)
) TYPE=MyISAM;

--
-- Dumping data for table `AJAX_USER`
--

INSERT INTO AJAX_USER VALUES (1,'demo1','demo1','demo1','demo1@ajax','123456','Y');
INSERT INTO AJAX_USER VALUES (2,'demo2','demo2','demo2','demo2@ajax','654321','Y');

-- --------------------------------------------------------

--
-- Table structure for table 'AJAX_CONTENT'
--

DROP TABLE IF EXISTS AJAX_CONTENT;
CREATE TABLE  AJAX_CONTENT (
  CONTENT_ID int(16) NOT NULL auto_increment,
  USER_ID int(16) NOT NULL default '0',
  CONTENT_TYPE varchar(16) NOT NULL default '',
  CONTENT_MAIN longtext NOT NULL default '',
  ACTIVE_STATUS varchar(4) NOT NULL default 'Y',
  PRIMARY KEY  (CONTENT_ID)
) TYPE=MyISAM;

--
-- Dumping data for table `AJAX_USERS`
--

INSERT INTO AJAX_CONTENT VALUES (1,1,'BOOKMARK','<a href="http://www.sina.com.cn">sina.com</a>','Y');
INSERT INTO AJAX_CONTENT VALUES (2,1,'BOOKMARK','<a href="http://www.google.com">google</a>','Y');
INSERT INTO AJAX_CONTENT VALUES (3,1,'BOOKMARK','<a href="http://www.yahoo.com">Yahoo</a>','Y');
INSERT INTO AJAX_CONTENT VALUES (4,1,'BOOKMARK','<a href="http://www.sohu.com">Sohu</a>','Y');