Author: intralanman Date: Tue Dec 9 15:25:14 2008 New Revision: 10685 Log: what are you semi-colons doing here? Modified: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql Modified: freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql ============================================================================== --- freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql (original) +++ freeswitch/trunk/scripts/contrib/intralanman/C/lcr/sql/mysql-5.0.sql Tue Dec 9 15:25:14 2008 @@ -34,7 +34,7 @@ `date_end` datetime NOT NULL DEFAULT '2030-12-31', `quality` float(10,6) NOT NULL, `reliability` float(10,6) NOT NULL, - `enabled` boolean NOT NULL DEFAULT '1'; + `enabled` boolean NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `carrier_id` (`carrier_id`), KEY `digits` (`digits`), @@ -52,7 +52,7 @@ CREATE TABLE `carriers` ( `id` int(11) NOT NULL auto_increment, `carrier_name` varchar(255) default NULL, - `enabled` boolean NOT NULL DEFAULT '1'; + `enabled` boolean NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; @@ -66,7 +66,7 @@ `carrier_id` int(11) default NULL, `prefix` varchar(255) NOT NULL, `suffix` varchar(255) NOT NULL, - `enabled` boolean NOT NULL DEFAULT '1'; + `enabled` boolean NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `carrier_id` (`carrier_id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;