Re: [Webical-developers] 0.2 RC download

[Ivo v. D. <ivo...@gm...>]

Hey,

I've taken a look at it and it seems the sql file is not incorrect, just a
bit impractical. The file does work if you execute it without first
selecting a database (because it wants to create the database as well).
Perhaps this line needs to be dropped or the documentation sharpened. I'll
let Mattijs decide.
The applicationContext-release.xml is fixed. Perhaps a new release on monday
(after some testing)?

Regards,
Ivo

On 9/14/07, Zoran Kovacevic <zo...@fu...> wrote:
>
> > Feel free to download it and test it on your machines.
>
> I also had a problem with the database:
>
> zorankovacevic$ /usr/local/mysql/bin/mysql -u root <
> /Users/zorankovacevic/Desktop/webical-0.2\ Folder/DB_setup.sql
> ERROR 1064 (42000) at line 47: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'IF NOT EXISTS CREATE DATABASE `webical`
>    `lastRefreshTimeStamp` bigint(20) defa' at line 10
>
> I fixed it by temporarily letting hibernate create the needed tables. I
> have dumped the created and clean tables in the attached file. Please
> verify!
>
> (the AUTH_webical.sql does work)
>
> --
> Zoran Kovacevic
> Func. Internet Integration
> W http://www.func.nl
> M +31 6 48104284
> T +31 20 4230000
> F +31 20 4223500
> GPG http://www.func.nl/keys/z.k...@fu...
>
> -- MySQL Administrator dump 1.4
> --
> -- ------------------------------------------------------
> -- Server version       5.0.45
>
>
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!40101 SET NAMES utf8 */;
>
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
> */;
>
>
> --
> -- Create schema webical
> --
>
> USE webical;
>
> --
> -- Definition of table `webical`.`application_settings`
> --
>
> DROP TABLE IF EXISTS `webical`.`application_settings`;
> CREATE TABLE  `webical`.`application_settings` (
>   `applicationSettingsId` bigint(20) NOT NULL auto_increment,
>   `customPageTitle` mediumtext,
>   `pluginWorkPath` mediumtext,
>   `pluginPackageExtension` mediumtext,
>   `calendarRefreshTimeMs` int(11) default NULL,
>   `pluginCleanupEnabled` bit(1) default NULL,
>   `configurationUsername` mediumtext,
>   `configurationPassword` mediumtext,
>   PRIMARY KEY  (`applicationSettingsId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`application_settings`
> --
>
> /*!40000 ALTER TABLE `application_settings` DISABLE KEYS */;
> LOCK TABLES `application_settings` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `application_settings` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`application_settings_plugin_paths`
> --
>
> DROP TABLE IF EXISTS `webical`.`application_settings_plugin_paths`;
> CREATE TABLE  `webical`.`application_settings_plugin_paths` (
>   `applicationSettingsId` bigint(20) NOT NULL,
>   `plugin_path` mediumtext,
>   KEY `FK888DA9CFD92BC9E2` (`applicationSettingsId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`application_settings_plugin_paths`
> --
>
> /*!40000 ALTER TABLE `application_settings_plugin_paths` DISABLE KEYS */;
> LOCK TABLES `application_settings_plugin_paths` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `application_settings_plugin_paths` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`application_settings_resource_paths`
> --
>
> DROP TABLE IF EXISTS `webical`.`application_settings_resource_paths`;
> CREATE TABLE  `webical`.`application_settings_resource_paths` (
>   `applicationSettingsId` bigint(20) NOT NULL,
>   `resource_path` mediumtext,
>   KEY `FK8C31272AD92BC9E2` (`applicationSettingsId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`application_settings_resource_paths`
> --
>
> /*!40000 ALTER TABLE `application_settings_resource_paths` DISABLE KEYS
> */;
> LOCK TABLES `application_settings_resource_paths` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `application_settings_resource_paths` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`calendar`
> --
>
> DROP TABLE IF EXISTS `webical`.`calendar`;
> CREATE TABLE  `webical`.`calendar` (
>   `calendarId` bigint(20) NOT NULL auto_increment,
>   `name` mediumtext NOT NULL,
>   `type` mediumtext NOT NULL,
>   `url` mediumtext NOT NULL,
>   `username` mediumtext,
>   `password` mediumtext,
>   `visible` bit(1) default NULL,
>   `offSetFrom` bigint(20) default NULL,
>   `offSetTo` bigint(20) default NULL,
>   `lastRefreshTimeStamp` bigint(20) default NULL,
>   `userId` varchar(255) NOT NULL,
>   PRIMARY KEY  (`calendarId`),
>   KEY `FKF55EFB3EF4310590` (`userId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`calendar`
> --
>
> /*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
> LOCK TABLES `calendar` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `calendar` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event`
> --
>
> DROP TABLE IF EXISTS `webical`.`event`;
> CREATE TABLE  `webical`.`event` (
>   `eventId` bigint(20) NOT NULL auto_increment,
>   `calendarId` bigint(20) NOT NULL,
>   `clazz` mediumtext,
>   `description` mediumtext,
>   `geo` mediumtext,
>   `location` mediumtext,
>   `organizer` mediumtext,
>   `status` mediumtext,
>   `summary` mediumtext,
>   `transp` mediumtext,
>   `uid` mediumtext,
>   `url` mediumtext,
>   `created` datetime default NULL,
>   `dtStart` datetime default NULL,
>   `lastMod` datetime default NULL,
>   `dtStamp` datetime default NULL,
>   `seq` int(11) default NULL,
>   `dtEnd` datetime default NULL,
>   `duration` varchar(255) default NULL,
>   PRIMARY KEY  (`eventId`),
>   KEY `FK5C6729A5DB02C36` (`calendarId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event`
> --
>
> /*!40000 ALTER TABLE `event` DISABLE KEYS */;
> LOCK TABLES `event` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_attach`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_attach`;
> CREATE TABLE  `webical`.`event_attach` (
>   `eventId` bigint(20) NOT NULL,
>   `attach` mediumtext,
>   KEY `FK2079378A47C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_attach`
> --
>
> /*!40000 ALTER TABLE `event_attach` DISABLE KEYS */;
> LOCK TABLES `event_attach` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_attach` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_attendee`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_attendee`;
> CREATE TABLE  `webical`.`event_attendee` (
>   `eventId` bigint(20) NOT NULL,
>   `attendee` mediumtext,
>   KEY `FKE746D8BF47C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_attendee`
> --
>
> /*!40000 ALTER TABLE `event_attendee` DISABLE KEYS */;
> LOCK TABLES `event_attendee` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_attendee` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_categories`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_categories`;
> CREATE TABLE  `webical`.`event_categories` (
>   `eventId` bigint(20) NOT NULL,
>   `categories` mediumtext,
>   KEY `FKD2164E147C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_categories`
> --
>
> /*!40000 ALTER TABLE `event_categories` DISABLE KEYS */;
> LOCK TABLES `event_categories` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_categories` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_comment`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_comment`;
> CREATE TABLE  `webical`.`event_comment` (
>   `eventId` bigint(20) NOT NULL,
>   `comment` mediumtext,
>   KEY `FK4F94CDBA47C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_comment`
> --
>
> /*!40000 ALTER TABLE `event_comment` DISABLE KEYS */;
> LOCK TABLES `event_comment` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_comment` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_contact`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_contact`;
> CREATE TABLE  `webical`.`event_contact` (
>   `eventId` bigint(20) NOT NULL,
>   `contact` mediumtext,
>   KEY `FK4FA6037B47C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_contact`
> --
>
> /*!40000 ALTER TABLE `event_contact` DISABLE KEYS */;
> LOCK TABLES `event_contact` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_contact` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_exDate`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_exDate`;
> CREATE TABLE  `webical`.`event_exDate` (
>   `eventId` bigint(20) NOT NULL,
>   `exDate` datetime default NULL,
>   KEY `FK276F284647C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_exDate`
> --
>
> /*!40000 ALTER TABLE `event_exDate` DISABLE KEYS */;
> LOCK TABLES `event_exDate` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_exDate` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_exRule`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_exRule`;
> CREATE TABLE  `webical`.`event_exRule` (
>   `eventId` bigint(20) NOT NULL,
>   `exRule` mediumtext,
>   KEY `FK2775CF9447C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_exRule`
> --
>
> /*!40000 ALTER TABLE `event_exRule` DISABLE KEYS */;
> LOCK TABLES `event_exRule` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_exRule` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_rDate`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_rDate`;
> CREATE TABLE  `webical`.`event_rDate` (
>   `eventId` bigint(20) NOT NULL,
>   `rDate` datetime default NULL,
>   KEY `FK1AABD55B47C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_rDate`
> --
>
> /*!40000 ALTER TABLE `event_rDate` DISABLE KEYS */;
> LOCK TABLES `event_rDate` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_rDate` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_rRule`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_rRule`;
> CREATE TABLE  `webical`.`event_rRule` (
>   `eventId` bigint(20) NOT NULL,
>   `rRule` mediumtext,
>   KEY `FK1AB27CA947C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_rRule`
> --
>
> /*!40000 ALTER TABLE `event_rRule` DISABLE KEYS */;
> LOCK TABLES `event_rRule` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_rRule` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_rStatus`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_rStatus`;
> CREATE TABLE  `webical`.`event_rStatus` (
>   `eventId` bigint(20) NOT NULL,
>   `rStatus` mediumtext,
>   KEY `FK39A7FE5F47C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_rStatus`
> --
>
> /*!40000 ALTER TABLE `event_rStatus` DISABLE KEYS */;
> LOCK TABLES `event_rStatus` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_rStatus` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_related`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_related`;
> CREATE TABLE  `webical`.`event_related` (
>   `eventId` bigint(20) NOT NULL,
>   `related` mediumtext,
>   KEY `FK57EE7B8647C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_related`
> --
>
> /*!40000 ALTER TABLE `event_related` DISABLE KEYS */;
> LOCK TABLES `event_related` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_related` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_resources`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_resources`;
> CREATE TABLE  `webical`.`event_resources` (
>   `eventId` bigint(20) NOT NULL,
>   `resources` mediumtext,
>   KEY `FKA08132C047C8C010` (`eventId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_resources`
> --
>
> /*!40000 ALTER TABLE `event_resources` DISABLE KEYS */;
> LOCK TABLES `event_resources` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_resources` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`event_xProps`
> --
>
> DROP TABLE IF EXISTS `webical`.`event_xProps`;
> CREATE TABLE  `webical`.`event_xProps` (
>   `id` bigint(20) NOT NULL,
>   `xprop_value` mediumtext,
>   `xprop_name` varchar(255) NOT NULL,
>   PRIMARY KEY  (`id`,`xprop_name`),
>   KEY `FK45BCAD1D99D48BF6` (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`event_xProps`
> --
>
> /*!40000 ALTER TABLE `event_xProps` DISABLE KEYS */;
> LOCK TABLES `event_xProps` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `event_xProps` ENABLE KEYS */;
>
>
> --
> -- Definition of table `webical`.`user`
> --
>
> DROP TABLE IF EXISTS `webical`.`user`;
> CREATE TABLE  `webical`.`user` (
>   `userId` varchar(255) NOT NULL,
>   `firstName` text,
>   `lastNamePrefix` text,
>   `lastName` text,
>   `birthDate` date default NULL,
>   PRIMARY KEY  (`userId`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> --
> -- Dumping data for table `webical`.`user`
> --
>
> /*!40000 ALTER TABLE `user` DISABLE KEYS */;
> LOCK TABLES `user` WRITE;
> UNLOCK TABLES;
> /*!40000 ALTER TABLE `user` ENABLE KEYS */;
>
>
>
>
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Webical-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/webical-developers
>
>


-- 
Ivo van Dongen
Func. Internet Integration
W http://www.func.nl
T +31 20 4230000
F +31 20 4223500