<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_movie", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`filename` varchar(128) NOT NULL default '',\r\n\t\t`type` varchar(128) NOT NULL default '',\r\n\t\t`name` varchar(255) default NULL,\r\n\t\t`size` int(32) default NULL,\r\n\t\t`width` int(11) NOT NULL default '0',\r\n\t\t`height` int(11) NOT NULL default '0',\r\n\t\t`autostart` int(11) NOT NULL default '0',\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='movie', value='Film'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='movies', value='Films'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='erroruploadmovie', value='Er is een fout opgestreden tijdens het toevoegen van de film'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='moviesize', value='Grootte'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='moviebig', value='Groot (640 x 480 pixels)'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='moviesmall', value='Klein (320 x 240 pixels)'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='movieautostart', value='Start de film automatisch'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='movie', value='Movie'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='movies', value='Movies'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='erroruploadmovie', value='An error occurred while uploading the movie'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='moviesize', value='Size'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='moviebig', value='Large (640 x 480 pixel)'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='moviesmall', value='Small (320 x 240 pixel)'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='movieautostart', value='Automatically start the movie'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_external", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`url` text NOT NULL default '',\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='external', value='Extern'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='external', value='External'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
if (!sql::exists("media")) {
sql::create("media", "\r\n\t\t\t`ID` int(11) NOT NULL auto_increment,\r\n\t\t\t`folder` int(11) NOT NULL default '0',\r\n\t\t\t`filename` varchar(255) NOT NULL default '',\r\n\t\t\t`original` varchar(255) NOT NULL default '',\r\n\t\t\t`width` int(11) NOT NULL default '0',\r\n\t\t\t`height` int(11) NOT NULL default '0',\r\n\t\t\t`size` int(11) NOT NULL default '0',\r\n\t\t\t`modified` datetime NOT NULL default '0000-00-00 00:00:00',\r\n\t\t\t`deleted` int(4) NOT NULL default '0',\r\n\t\t\tPRIMARY KEY (`ID`)\r\n\t\t");
sql::create("media_folder", "\r\n\t\t\t`ID` int(11) NOT NULL auto_increment,\r\n\t\t\t`order` int(11) NOT NULL default '0',\r\n\t\t\t`name` varchar(50) NOT NULL default '',\r\n\t\t\tPRIMARY KEY (`ID`)\r\n\t\t");
/* Create or first folder */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "media_folder SET `ID`=1, `order`=0, `name`='Standard'");
}
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='image', value='Afbeelding'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='selectimage', value='Selecteer afbeelding'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='imagesonwebsite', value='Afbeeldingen op uw website'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='image', value='Image'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='selectimage', value='Select image'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='imagesonwebsite', value='Images on your website'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_story", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`title` varchar(255) NOT NULL default '',\r\n\t\t`text` longtext NOT NULL,\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='story', value='Artikel'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='contents', value='Inhoud'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='draftexplaination', value='U bent momenteel een kladversie aan het wijzigen. Indien u deze wijziging publiek wil maken klik dan op de Publiceer knop. Indien u terug wil gaan naar de laatste publieke versie, klik dan op de Vorige versie knop.'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='modifyexplaination', value='U bent momenteel de laatste publieke versie aan het wijzigen. Indien u deze wijzigingen als een kladversie wilt bewaren, klik dan op de Wijzig knop. Indien u deze wijzigingen meteen publiek wil maken, klik dan op de Publiceer knop.'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='publish', value='Publiceer'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='revert', value='Vorige versie'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='story', value='Story'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='contents', value='Contents'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='draftexplaination', value='You are currently editing a draft. If you want to make your changes public, click on the Publish button below. If you want to revert you changes and continue with the last public version click the Revert button.'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='modifyexplaination', value='You are currently editing the latest public version of this story. If you want to save these changes as a draft, click the Edit button. If you want to make these changes public click on the Publish button.'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='publish', value='Publish'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='revert', value='Revert'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_image", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`image` varchar(255) NOT NULL default '',\r\n\t\t`modified` datetime NOT NULL default '0000-00-00 00:00:00',\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_form", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`title` varchar(254) NOT NULL,\r\n\t\t`button` varchar(254) NOT NULL,\r\n\t\t`email` varchar(254) NOT NULL,\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::create("contents_form_elements", "\r\n\t\t`element` int(11) NOT NULL auto_increment,\r\n\t\t`form` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`order` int(11) NOT NULL default '0',\r\n\t\t`type` varchar(16) NOT NULL default 'text',\r\n\t\t`title` varchar(254) NOT NULL,\r\n\t\t`size` int(11) NOT NULL default '0',\r\n\t\t`default` text NOT NULL,\r\n\t\t`action` varchar(254) NOT NULL default '',\r\n\t\t`required` int(11) NOT NULL default '0',\r\n\t\tPRIMARY KEY (`element`)\r\n\t");
sql::create("contents_form_elements_options", "\r\n\t\t`option` int(11) NOT NULL auto_increment,\r\n\t\t`element` int(11) NOT NULL default '0',\r\n\t\t`order` int(11) NOT NULL default '0',\r\n\t\t`title` varchar(254) NOT NULL,\r\n\t\tPRIMARY KEY (`option`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='form', value='Formulier'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='formcouldnotbesend', value='Het formulier kon niet verzonden worden'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='isrequired', value='is verplicht'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='required', value='Verplicht'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='default', value='Standaard'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='nodefault', value='Geen standaard keuze'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='length', value='Lengte'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='height', value='Hoogte'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='type', value='Type'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='action', value='Actie'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='submit', value='Verzenden'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='print', value='Printen'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='fieldsdraganddrop', value='Klik op een veld om te wijzigen of sleep het veld naar de gewenste positie'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='typetext', value='Tekstregel'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='typetextarea', value='Tekstveld'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='typeemail', value='Email adres'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='typeselect', value='Keuzemenu'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='typeradio', value='Keuzerondjes'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_collection", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`type` varchar(255) NOT NULL default '',\r\n\t\t`limit` int(11) NOT NULL default '0',\r\n\t\t`sort` int(11) NOT NULL default '0',\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='collection', value='Verzameling'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='readmore', value='Lees verder...'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='collection', value='Collection'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='readmore', value='Read more...'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_links", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`link` int(11) NOT NULL auto_increment,\r\n\t\t`position` int(11) NOT NULL default '0',\r\n\t\t`url` varchar(255) NOT NULL default '',\r\n\t\t`title` varchar(255) NOT NULL default '',\r\n\t\t`target` varchar(16) NOT NULL default '',\r\n\t\tUNIQUE KEY `id_revision_link` (`ID`,`revision`,`link`)\r\n\t");
config::create('linksAlign', 'string', 'right');
/* Dutch language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='links', value='Links'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='linksurl', value='Adres'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='linkstarget', value='Doel'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='newwindow', value='Nieuw venster'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='currentwindow', value='Hetzelfde venster'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='linksdraganddrop', value='Klik op een link om te wijzigen of sleep de links naar de gewenste positie'");
/* English language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='links', value='Links'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='linksurl', value='URL'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='linkstarget', value='Target'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='newwindow', value='New window'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='currentwindow', value='Current window'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='linksdraganddrop', value='Click a link to edit it or drag and drop the links in the order you want'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_files", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`filename` varchar(128) NOT NULL default '',\r\n\t\t`title` varchar(255) NOT NULL default '',\r\n\t\t`type` varchar(128) NOT NULL default '',\r\n\t\t`name` varchar(255) default NULL,\r\n\t\t`size` int(32) default NULL,\r\n\t\t`modified` datetime default NULL,\r\n\t\t`position` int(11) NOT NULL default '0',\r\n\t\t`attachment` int(11) NOT NULL default '0',\r\n\t\tUNIQUE KEY `id_revision_filename` (`ID`,`revision`,`filename`)\r\n\t");
/* Dutch language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='attachments', value='Bijlagen'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='files', value='Bestanden'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='filesize', value='Grootte'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='filetype', value='Type'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='filemodified', value='Gewijzigd op'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='filesdraganddrop', value='Klik op een bestand om te wijzigen of sleep de bestanden naar de gewenste positie'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='filesselect', value='Selecteer het bestand dat u wilt uploaden'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='fileerror', value='Er is een fout opgetreden. Het geselecteerde bestand kon niet geupload worden.'");
/* English language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='attachments', value='Attachments'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='files', value='Files'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='filesize', value='Size'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='filetype', value='Type'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='filemodified', value='Modified on'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='filesdraganddrop', value='Click a file to edit it or drag and drop the files in the order you want'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='filesselect', value='Select the file you wish to upload'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='fileerror', value='An error occurred. The selected file could not be uploaded.'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_slides", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`position` int(11) NOT NULL default '0',\r\n\t\t`thumbnail` varchar(255) NOT NULL default '',\r\n\t\t`image` varchar(255) NOT NULL default '',\r\n\t\t`title` text NOT NULL default '',\r\n\t\t`description` text NOT NULL default '',\r\n\t\tPRIMARY KEY (`ID`,`revision`,`position`)\r\n\t");
/* Dutch language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='slides', value='Dia\\'s'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='title', value='Titel'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='description', value='Beschrijving'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='image', value='Afbeelding'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='thumbnail', value='Voorvertoning'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='select', value='Selecteer'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='slidesdraganddrop', value='Klik op een dia om te wijzigen of sleep de dia\\'s naar de gewenste positie'");
/* English language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='slides', value='Slides'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='title', value='Title'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='description', value='Description'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='image', value='Image'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='thumbnail', value='Thumbnail'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='select', value='Select'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='slidesdraganddrop', value='Click a slide to edit it or drag and drop the slides in the order you want'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_gallery", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`gallery` int(11) NOT NULL default '0',\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
/* Dutch language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='gallery', value='Fotoalbum'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='editgallery', value='Wijzig album'");
/* English language strings */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='gallery', value='Photo gallery'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='editgallery', value='Edit gallery'");
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_aside", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`text` longtext NOT NULL,\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='aside', value='Marge'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='aside', value='Aside'");
sql::create("plugins_event", "\r\n\t\t`name` varchar(254) NOT NULL default '',\r\n\t\t`plugin` varchar(254) NOT NULL default '',\r\n\t\tPRIMARY KEY (`name`(128),`plugin`(128))\r\n\t");
sql::create("plugins_types", "\r\n\t\t`ID` varchar(254) NOT NULL default '',\r\n\t\t`plugin` varchar(254) NOT NULL default '',\r\n\t\t`children_allowed` text NOT NULL default '',\r\n\t\t`parents_allowed` text NOT NULL default '',\r\n\t\t`root_allowed` int(11) NOT NULL default '1',\r\n\t\t`visible` int(11) NOT NULL default '1',\r\n\t\tPRIMARY KEY (`ID`)\r\n\t");
if (!sql::exists("types")) {
sql::create("types", "\r\n\t\t\t`ID` int(11) NOT NULL auto_increment,\r\n\t\t\t`name` varchar(254) NOT NULL default '',\r\n\t\t\t`children_allowed` text NOT NULL default '',\r\n\t\t\t`parents_allowed` text NOT NULL default '',\r\n\t\t\t`root_allowed` int(11) NOT NULL default '1',\r\n\t\t\t`visible` int(11) NOT NULL default '1',\r\n\t\t\t`sort` int(11) NOT NULL default '0',\r\n\t\t\tPRIMARY KEY (`ID`)\r\n\t\t");
sql::create("types_groups", "\r\n\t\t\t`type` int(11) NOT NULL default '0',\r\n\t\t\t`group` int(11) NOT NULL default '0',\r\n\t\t\t`content` text NOT NULL,\r\n\t\t\tPRIMARY KEY (`type`,`group`)\r\n\t\t");
/* Create the default pagetype */
sql::query("\r\n\t\t\tINSERT INTO " . _TABLE_PREFIX_ . "types SET \r\n\t\t\t\t`ID`=1, `name`='Default', `children_allowed`= '*', `parents_allowed`= '*', `root_allowed`= 1\r\n\t\t");
sql::query("\r\n\t\t\tINSERT INTO " . _TABLE_PREFIX_ . "types_groups SET \r\n\t\t\t\t`type`=1, `group`=0, `content`= 'title,story'\r\n\t\t");
}
/* Basic tables */
sql::create("config", "\r\n\t\t`name` varchar(254) NOT NULL default '',\r\n\t\t`type` varchar(254) NOT NULL default '',\r\n\t\t`data` text NOT NULL,\r\n\t\tPRIMARY KEY (`name`)\r\n\t");
sql::create("tickets", "\r\n\t\t`ticket` varchar(64) NOT NULL default '',\r\n\t\t`id` int(64) NOT NULL default '0',\r\n\t\t`generated` datetime NOT NULL default '0000-00-00 00:00:00'\r\n\t");
/* Translation and languages */
if (!sql::exists("language")) {
sql::create("language", "\r\n\t\t\t`id` char(2) NOT NULL default '',\r\n\t\t\t`name` varchar(50) NOT NULL default '',\r\n\t\t\t`public` int(4) NOT NULL default '0',\r\n\t\t\t`position` int(11) NOT NULL default '0',\r\n\t\t\t`site` int(11) NOT NULL default '0',\r\n\t\t\tUNIQUE KEY `id_site` (`id`,`site`)\r\n\t\t");
/* Create our default language */
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "language SET `id`='" . _DEFAULT_LANGUAGE_ . "', `name`='" . _DEFAULT_LANGUAGE_NAME_ . "', `public`=1, `site`=" . _DEFAULT_SITE_);
}
sql::create("strings", "\r\n\t\t`id` varchar(255) NOT NULL default '',\r\n\t\t`language` varchar(5) NOT NULL default '',\r\n\t\t`value` text NOT NULL,\r\n\t\t`group` varchar(64) NOT NULL default '',\r\n\t\tUNIQUE KEY `id_language` (`id`,`language`)\r\n\t");
sql::create("strings_groups", "\r\n\t\t`group` varchar(64) NOT NULL default '',\r\n\t\t`name` varchar(255) NOT NULL default '',\r\n\t\tPRIMARY KEY (`group`)\r\n\t");
/* Content */
if (!sql::exists("contents")) {
sql::create("contents", "\r\n\t\t\t`ID` int(11) NOT NULL auto_increment,\r\n\t\t\t`parent` int(11) NOT NULL default '0',\r\n\t\t\t`left` int(11) NOT NULL default '0',\r\n\t\t\t`right` int(11) NOT NULL default '0',\r\n\t\t\t`site` int(11) NOT NULL default '0',\r\n\t\t\t`name` varchar(254) NOT NULL default '',\r\n\t\t\t`title` varchar(254) NOT NULL default '',\r\n\t\t\t`slug` varchar(254) NOT NULL default '',\r\n\t\t\t`type` varchar(64) NOT NULL default '',\r\n\t\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t\t`status` int(11) NOT NULL default '0',\r\n\t\t\t`set` int(11) NOT NULL default '0',\r\n\t\t\t`position` int(11) default NULL,\r\n\t\t\t`r_view` int(11) NOT NULL default '0',\r\n\t\t\t`r_view_inv` int(11) NOT NULL default '0',\r\n\t\t\t`r_edit` int(11) NOT NULL default '0',\r\n\t\t\t`r_edit_inv` int(11) NOT NULL default '0',\r\n\t\t\t`r_create` int(11) NOT NULL default '0',\r\n\t\t\t`r_create_inv` int(11) NOT NULL default '0',\r\n\t\t\t`r_admin` int(11) NOT NULL default '0',\r\n\t\t\t`r_admin_inv` int(11) NOT NULL default '0',\r\n\t\t\t`author` int(11) NOT NULL default '0',\r\n\t\t\t`language` char(2) NOT NULL default 'nl',\r\n\t\t\t`activation` int(11) NOT NULL default '0',\r\n\t\t\t`expiration` int(11) NOT NULL default '0',\r\n\t\t\t`created` int(11) NOT NULL default '0',\r\n\t\t\t`published` int(11) NOT NULL default '0',\r\n\t\t\t`modified` int(11) NOT NULL default '0',\r\n\t\t\t`visible` int(11) NOT NULL default '1',\r\n\t\t\tPRIMARY KEY (`ID`)\r\n\t\t");
/* Create the default homepage */
sql::query("\r\n\t\t\tINSERT INTO " . _TABLE_PREFIX_ . "contents SET \r\n\t\t\t\t`ID`=1, `parent`=0, `left`=1, `right`=2, `site`=" . _DEFAULT_SITE_ . ", `name`='Home', `title`='', `slug`='index', `type`='1', `revision`=0, \r\n\t\t\t\t`status`=1, `set`=0, `position`=0, `r_view`=3, `r_view_inv`=0, `r_edit`=6, `r_edit_inv`=0, `r_create`=6, `r_create_inv`=0,\r\n\t\t\t\t`r_admin`=6, `r_admin_inv`=0, `author`=1, `language`='" . _DEFAULT_LANGUAGE_ . "', \r\n\t\t\t\t`activation`=0, `expiration`=0, `created`= " . time() . ", `published` = " . time() . ", `modified`= " . time() . ", \r\n\t\t\t\t`visible`=1\r\n\t\t");
}
if (!sql::exists("contents_revisions")) {
sql::create("contents_revisions", "\r\n\t\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t\t`created` int(11) NOT NULL default '0',\r\n\t\t\t`modified` int(11) NOT NULL default '0',\r\n\t\t\t`description` text NOT NULL,\r\n\t\t\t`author` int(11) NOT NULL default '0',\r\n\t\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t\t");
/* Create the default homepage */
sql::query("\r\n\t\t\tINSERT INTO " . _TABLE_PREFIX_ . "contents_revisions SET \r\n\t\t\t\t`ID`=1, `revision`=0, `created`= " . time() . ", `modified`= " . time() . ", `author`=1\r\n\t\t");
}
<?php
/************************************************************************
* Dashboard2
* Copyright 2006-2010 by Niels Leenheer
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
sql::create("contents_seo", "\r\n\t\t`ID` int(11) NOT NULL default '0',\r\n\t\t`revision` int(11) NOT NULL default '0',\r\n\t\t`keywords` text NOT NULL,\r\n\t\t`description` text NOT NULL,\r\n\t\tUNIQUE KEY `id_revision` (`ID`,`revision`)\r\n\t");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='seo', value='SEO'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='keywords', value='Sleutelwoorden'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='nl', id='description', value='Beschrijving'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='seo', value='SEO'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='keywords', value='Keywords'");
sql::query("INSERT INTO " . _TABLE_PREFIX_ . "strings SET language='en', id='description', value='Description'");
