-- phpMyAdmin SQL Dump
-- version 2.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 11, 2008 at 02:27 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `openworship`
--

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

--
-- Table structure for table `ls_users`
--

CREATE TABLE IF NOT EXISTS `ls_users` (
  `lsu_id` int(11) NOT NULL auto_increment,
  `lsu_username` varchar(50) NOT NULL,
  `lsu_password` varchar(200) NOT NULL,
  `lsu_email` varchar(200) default NULL,
  `lsu_fname` varchar(200) default NULL,
  `lsu_lname` varchar(200) default NULL,
  `lsu_opensong_admin` varchar(1) NOT NULL default 'N',
  `lsu_user_admin` varchar(1) NOT NULL default 'N',
  `lsu_last_login` date default NULL,
  `lsu_num_logins` int(11) default '0',
  PRIMARY KEY  (`lsu_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=122 ;

--
-- Dumping data for table `ls_users`
--

INSERT INTO `ls_users` (`lsu_id`, `lsu_username`, `lsu_password`, `lsu_email`, `lsu_fname`, `lsu_lname`, `lsu_opensong_admin`, `lsu_user_admin`, `lsu_last_login`, `lsu_num_logins`) VALUES
(121, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'none@open-worship.org', 'John', 'Doe', 'Y', 'Y', '2008-07-11', 1);

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

--
-- Table structure for table `opensong_prefs`
--

CREATE TABLE IF NOT EXISTS `opensong_prefs` (
  `osp_id` int(11) NOT NULL auto_increment,
  `osp_ls_fk` int(11) NOT NULL,
  `osp_ccolor` varchar(20) default NULL,
  `osp_cbold` varchar(20) default NULL,
  `osp_citalic` varchar(20) default NULL,
  `osp_lcolor` varchar(20) default NULL,
  `osp_lbold` varchar(20) default NULL,
  `osp_litalic` varchar(20) default NULL,
  `osp_linkdl` varchar(20) default NULL,
  `osp_linkpdf` varchar(20) default NULL,
  `osp_pdftags` varchar(20) default NULL,
  `osp_pdffont` varchar(20) default NULL,
  `osp_ccli` varchar(100) default NULL,
  PRIMARY KEY  (`osp_id`),
  KEY `osp_ls_fk` (`osp_ls_fk`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `opensong_prefs`
--

INSERT INTO `opensong_prefs` (`osp_id`, `osp_ls_fk`, `osp_ccolor`, `osp_cbold`, `osp_citalic`, `osp_lcolor`, `osp_lbold`, `osp_litalic`, `osp_linkdl`, `osp_linkpdf`, `osp_pdftags`, `osp_pdffont`, `osp_ccli`) VALUES
(14, 120, 'FF0000', 'true', 'true', '000000', 'false', 'false', 'true', 'true', 'true', 'default', '  123456');