Dashboard > OverDrive > Home > Database Readme > Information > Page Comparison
Database Readme
Version 3 by Ted Husted
on Jun 08, 2005 06:56.


compared with
Current by Ted Husted
on Oct 13, 2005 07:22.

(show comment)
 
Key
These lines were removed. This word was removed.
These lines were added. This word was added.

View page history


There are 3 changes. View first change.

 * Right now, the PhoneBook application is using a MySQL 4.0 database by default.
 ** We mean to change the default that to [SharpHSQL|http://www.c-sharpcorner.com/database/SharpHSQL.asp] Real Soon Now, and make it easy to switch between various database systems. But for now, you will need [MySQL 4.0|ftp://mirror.mcs.anl.gov/pub/mysql/Downloads/MySQL-4.0/] installed.
 ** Create a database named phonebook
 ** Create an entry table
  ** We mean to change the default that to [SharpHSQL|http://www.c-sharpcorner.com/database/SharpHSQL.asp] Real Soon Now, and make it easy to switch between various database systems.
 ** But for now, you will need [MySQL 4.0|ftp://mirror.mcs.anl.gov/pub/mysql/Downloads/MySQL-4.0/] installed. Then, all you need to do is execute the {{Phonebook-Start.sql}} script
  
{code:sq]}
 # Database: phonebook
 # Table: 'entry'
 #
  {code:sql}
 CREATE DATABASE `phonebook`;
 USE `phonebook`;
 CREATE TABLE `entry` (
  `pk_entry` char(36) NOT NULL default '',
  `last_name` char(18) NOT NULL default '',
  `first_name` char(18) NOT NULL default '',
  `extension` char(18) NOT NULL default '',
  `user_name` char(9) NOT NULL default '',
  `editor` tinyint(3) unsigned NOT NULL default '0',
  `hired` datetime NOT NULL default '0000-00-00 00:00:00',
  `hours` double NOT NULL default '37.5'
 ) TYPE=MyISAM ROW_FORMAT=FIXED;
 INSERT INTO `entry` (`pk_entry`,`last_name`,`first_name`,`extension`,`user_name`,`editor`,`hired`,`hours`) VALUES
  ('c5b6bbb1-66d6-49cb-9db6-743af6627828','Clinton','William','5557437828','bubba',0,'1992-08-19 00:00:00',37.5),
  ('7c424227-8e19-4fb5-b089-423cfca723e1','Roosevelt','Theodore','5557438942','bull',0,'2001-09-14 00:00:00',37.5),
  ('9320ea40-0c01-43e8-9cec-8fb9b3928c2c','Kennedy','John F.','5557433928','fitz',0,'1987-05-29 00:00:00',37.5),
  ('3b27c933-c1dc-4d85-9744-c7d9debae196','Pierce','Franklin','5557437919','hawkeye',0,'1984-11-18 00:00:00',35),
  ('554ff9e7-a6f5-478a-b76b-a666f5c54e40','Jefferson','Thomas','5557435440','monty',0,'1976-07-04 00:00:00',37.5);
 {code}
  
 ----
  
 See also
  
 * [Subversion Readme]
 * [VStudio Readme]
Site running on a free Atlassian Confluence Open Source Project License granted to OSS. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.5 Build:#811 Jul 25, 2007) - Bug/feature request - Contact Administrators