door KillerSponge » 26 apr 2005 16:12
[syntax="mysql"]CREATE TABLE `phpweb_configuration` (
`title` text NOT NULL,
`admin` text NOT NULL,
`pass` text NOT NULL,
`menu_left` int(11) NOT NULL default '0',
`menu_right` int(11) NOT NULL default '0',
`header_location` text NOT NULL,
`first_page` int(11) NOT NULL default '0',
`mlcp` int(11) NOT NULL default '0',
`mrcp` int(11) NOT NULL default '0'
) ;
INSERT INTO `phpweb_configuration` VALUES ('KillerSponge.com PHPweb', 'admin', 'admin', 1, 1, 'images/header.jpg', 1, 0, 0);
CREATE TABLE `phpweb_menu_left` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`position` int(11) NOT NULL default '0',
`p_number` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=0 ;
CREATE TABLE `phpweb_menu_left_items` (
`id` int(11) NOT NULL auto_increment,
`collumn_id` int(11) NOT NULL default '0',
`page_id` int(11) NOT NULL default '0',
`name` text NOT NULL,
`position` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=0 ;
CREATE TABLE `phpweb_menu_right` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`position` int(11) NOT NULL default '0',
`p_number` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=0 ;
CREATE TABLE `phpweb_menu_right_items` (
`id` int(11) NOT NULL auto_increment,
`collumn_id` int(11) NOT NULL default '0',
`page_id` int(11) NOT NULL default '0',
`name` text NOT NULL,
`position` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=0 ;
CREATE TABLE `phpweb_pages` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`content` text NOT NULL,
`advanced` text NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=0 ;[/syntax]
en zo?