yingyes

--

-- Table structure for table `admin_layout`

--

 

DROP TABLE IF EXISTS `admin_layout`;

CREATE TABLE IF NOT EXISTS `admin_layout` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(128) NOT NULL default '',

  `template` int(11) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `text` text NOT NULL,

  `order` tinyint(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

 

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

 

--

-- Table structure for table `admin_pages`

--

 

DROP TABLE IF EXISTS `admin_pages`;

CREATE TABLE IF NOT EXISTS `admin_pages` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(128) NOT NULL default '',

  `template` int(11) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `status` enum('offline','regular','front_page') NOT NULL default 'offline',

  `text` text NOT NULL,

  `meta_keywords` varchar(255) NOT NULL default '',

  `order` tinyint(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

 

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

 

--

-- Table structure for table `css`

--

 

DROP TABLE IF EXISTS `css`;

CREATE TABLE IF NOT EXISTS `css` (

  `id` int(11) NOT NULL auto_increment,

  `template` int(11) NOT NULL default '0',

  `name` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `orderby` int(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

 

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

 

--

-- Table structure for table `js`

--

 

DROP TABLE IF EXISTS `js`;

CREATE TABLE IF NOT EXISTS `js` (

  `id` int(11) NOT NULL auto_increment,

  `template` int(11) NOT NULL default '0',

  `name` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `orderby` int(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

 

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

 

--

-- Table structure for table `layout`

--

 

DROP TABLE IF EXISTS `layout`;

CREATE TABLE IF NOT EXISTS `layout` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(128) NOT NULL default '',

  `template` int(11) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `text` text NOT NULL,

  `order` tinyint(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

 

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

 

--

-- Table structure for table `media`

--

 

DROP TABLE IF EXISTS `media`;

CREATE TABLE IF NOT EXISTS `media` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(255) NOT NULL default '',

  `path` varchar(255) NOT NULL default '',

  `size` varchar(8) NOT NULL default '',

  `date` date NOT NULL default '0000-00-00',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

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

 

--

-- Table structure for table `pages`

--

 

DROP TABLE IF EXISTS `pages`;

CREATE TABLE IF NOT EXISTS `pages` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(128) NOT NULL default '',

  `template` int(11) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `status` enum('offline','regular','front_page') NOT NULL default 'offline',

  `text` text NOT NULL,

  `nav_link` tinyint(1) NOT NULL default '0',

  `meta_keywords` varchar(255) NOT NULL default '',

  `orderby` tinyint(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

 

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

 

--

-- Table structure for table `sections`

--

 

DROP TABLE IF EXISTS `sections`;

CREATE TABLE IF NOT EXISTS `sections` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(128) NOT NULL default '',

  `template` int(11) NOT NULL default '0',

  `title` varchar(255) NOT NULL default '',

  `url` varchar(255) NOT NULL default '',

  `status` enum('offline','regular','front_page') NOT NULL default 'offline',

  `text` text NOT NULL,

  `meta_keywords` varchar(255) NOT NULL default '',

  `order` tinyint(4) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

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

 

--

-- Table structure for table `site_config`

--

 

DROP TABLE IF EXISTS `site_config`;

CREATE TABLE IF NOT EXISTS `site_config` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(128) NOT NULL default '',

  `comment` varchar(255) NOT NULL default '',

  `value` text NOT NULL,

  `category` varchar(32) NOT NULL default '',

  `orderby` int(11) NOT NULL default '0',

  `type` enum('numeric','text','textarea','checkbox','separator','selector','multiselector') NOT NULL default 'text',

  `active` tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

 

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

 

--

-- Table structure for table `templates`

--

 

DROP TABLE IF EXISTS `templates`;

CREATE TABLE IF NOT EXISTS `templates` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(255) NOT NULL default 'default',

  `preview` varchar(255) NOT NULL default '',

  `description` text NOT NULL,

  `front_page` varchar(255) NOT NULL default '',

  `images_dir` varchar(128) NOT NULL default '',

  `swf_dir` varchar(128) NOT NULL default '',

  `pdf_dir` varchar(128) NOT NULL default '',

  PRIMARY KEY  (`id`),

  UNIQUE KEY `template` (`name`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;