DB Conection successful
Query failed: Duplicate entry '1' for key 'PRIMARY'
xx
INSERT INTO `parameters` (`parameter_id`, `cat`, `parameter`, `val`) VALUES
(1, 'home', 'title', ''),
(2, 'home', 'desc', ''),
(3, 'home', 'keywords', ''),
(4, 'interior', 'title', '')yy
Query was 192 chars long.
Query failed: Duplicate entry '1' for key 'PRIMARY'
xx
INSERT INTO `section` (`section_id`, `name`, `position`) VALUES (1, 'Main', 0)yy
Query was 82 chars long.
Query failed: Unknown column 'pword' in 'field list'
xx
INSERT INTO `users` (`user_id`, `email`, `pword`, `roles`, `lastlogin`) VALUES (1, 'PoohBah', 'e02f98289218ce2ece571a97a01dd37c', 'Home Page, Page Content, Calendar, Links, Photo Galleries, Map Page, Paypal Pages, Users', '2008-07-08 12:30:46'),
(2, 'steve@streamcreative.com', 'e02f98289218ce2ece571a97a01dd37c', 'Home Page, Page Content, Calendar, Links, Photo Galleries, File Library, Map Page, Paypal Pages, Users', '2008-07-17 16:10:10')yy
Query was 447 chars long.
Query failed: Duplicate entry '0' for key 'PRIMARY'
xx
--
-- Dumping data for table `specials`
--
INSERT INTO `specials` (`special_id`, `name`, `includePrefix`) VALUES
(0, 'Page', ''),
(1, 'Google Map Page', 'map'),
(2, 'Links Page', 'links'),
(3, 'Multimedia Library', 'multi'),
(4, 'Calendar', 'cal'),
(5, 'Paypal Page', 'paypal'),
(6, 'Photo Gallery', 'gallery')yy
Query was 326 chars long.
Query failed: Table 'members' already exists
xx
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE `members` (
`member_id` int(11) NOT NULL auto_increment,
`email` varchar(80) NOT NULL default '',
`password` varchar(127) NOT NULL default '',
`first` varchar(80) NOT NULL default '',
`last` varchar(80) NOT NULL default '',
`organization` varchar(80) NOT NULL default '',
`approved` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 yy
Query was 573 chars long.
Query failed: Duplicate entry '1' for key 'PRIMARY'
xx
--
-- Dumping data for table `libfile_ext`
--
INSERT INTO `libfile_ext` (`libfile_ext_id`, `file_ext`, `file_type`, `mime_type`) VALUES
(1, 'flv', 'VIDEO', 'video/x-flv'),
(2, 'pdf', 'DOCUMENT', 'application/pdf'),
(3, 'mpeg', 'VIDEO', 'video/mpeg'),
(4, 'mpg', 'VIDEO', 'video/mpeg'),
(5, 'mov', 'VIDEO', 'video/quicktime'),
(6, 'doc', 'DOCUMENT', 'application/msword'),
(7, 'xls', 'DOCUMENT', 'xls'),
(8, 'wmv', 'VIDEO', 'audio/x-ms-wmv'),
(9, 'mp3', 'AUDIO', 'audio/x-mpeg-3'),
(10, 'docx', 'DOCUMENT', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(11, 'xlsx', 'DOCUMENT', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'),
(12, 'wav', 'AUDIO', 'audio/x-wav')yy
Query was 715 chars long.