Stuff on loan? Keep track of it using MySQL and phpMyAdmin

Launch phpMyAdmin ->
Select SQL tab ->
Copy/paste the following ->

CREATE TABLE IF NOT EXISTS `stuff_on_loan` (
`description` varchar(255) NOT NULL default ”,
`borrower` varchar(255) NOT NULL default ”,
`start` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`stop` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`rid` int(10) NOT NULL auto_increment,
PRIMARY KEY (`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Leave a Reply

Your email address will not be published. Required fields are marked *