"Fossies" - the Fresh Open Source Software Archive

Member "OCSNG_UNIX_SERVER_2.6/ocsreports/files/update/7009.sql" (17 Apr 2019, 878 Bytes) of package /linux/privat/OCSNG_UNIX_SERVER_2.6.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 ALTER TABLE `bios` ADD COLUMN `MMANUFACTURER` varchar(255) default NULL;
    2 ALTER TABLE `bios` ADD COLUMN `MMODEL` varchar(255) default NULL;
    3 ALTER TABLE `bios` ADD COLUMN `MSN` varchar(255) default NULL;
    4 
    5 CREATE TABLE IF NOT EXISTS `plugins` (
    6   `id` int(6) unsigned NOT NULL,
    7   `name` varchar(30) COLLATE utf8_bin NOT NULL,
    8   `version` double NOT NULL,
    9   `licence` varchar(50) COLLATE utf8_bin DEFAULT NULL,
   10   `author` varchar(30) COLLATE utf8_bin DEFAULT NULL,
   11   `verminocs` double NOT NULL,
   12   `activated` tinyint(1) NOT NULL,
   13   `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
   14 ) ENGINE=InnoDB DEFAULT CHARSET=UTF8;
   15 
   16 ALTER TABLE `plugins` ADD PRIMARY KEY (`id`);
   17 ALTER TABLE `plugins` MODIFY `id` int(6) unsigned NOT NULL AUTO_INCREMENT;
   18 
   19 INSERT INTO `config` VALUES('OCS_SERVER_ADDRESS',0,'127.0.0.1','Ocs serveur ip for plugin webservice');