Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

    Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

    Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

    revision 9463 by niro, Thu Apr 6 12:53:35 2017 UTC revision 14425 by niro, Wed Jul 15 07:23:38 2020 UTC
    # Line 13  create_database_schema() Line 13  create_database_schema()
    13   sql_create_table   sql_create_table
    14    
    15   TABLE_DEFINITION=(   TABLE_DEFINITION=(
      "cfg_autostart"  
      "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"  
      "serial int(11) NOT NULL"  
      "name varchar(255) NOT NULL"  
      "exec varchar(255) DEFAULT NULL"  
      "enabled tinyint(1) NOT NULL DEFAULT '1'"  
      "flg_modified tinyint(1) NOT NULL DEFAULT '0'"  
      )  
      sql_create_table  
       
      TABLE_DEFINITION=(  
    16   "cfg_citrix_serverlist"   "cfg_citrix_serverlist"
    17   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    18   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
    # Line 47  create_database_schema() Line 36  create_database_schema()
    36   "name varchar(255) NOT NULL"   "name varchar(255) NOT NULL"
    37   "exec varchar(255) NOT NULL"   "exec varchar(255) NOT NULL"
    38   "comment varchar(255) DEFAULT NULL"   "comment varchar(255) DEFAULT NULL"
    39     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    40   )   )
    41   sql_create_table   sql_create_table
    42    
    # Line 142  create_database_schema() Line 132  create_database_schema()
    132   sql_create_table   sql_create_table
    133    
    134   TABLE_DEFINITION=(   TABLE_DEFINITION=(
      "cfg_other_menuitems"  
      "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"  
      "serial int(11) NOT NULL"  
      "name varchar(255) DEFAULT NULL"  
      "exec varchar(255) DEFAULT NULL"  
      "workdir varchar(255) DEFAULT NULL"  
      "icon varchar(255) DEFAULT NULL"  
      )  
      sql_create_table  
       
      TABLE_DEFINITION=(  
    135   "cfg_printers"   "cfg_printers"
    136   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    137   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
    # Line 175  create_database_schema() Line 154  create_database_schema()
    154   "screensaver varchar(255) NOT NULL"   "screensaver varchar(255) NOT NULL"
    155   "timeout int(11) DEFAULT '10'"   "timeout int(11) DEFAULT '10'"
    156   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    157     "dpms tinyint(1) NOT NULL DEFAULT '1'"
    158   )   )
    159   sql_create_table   sql_create_table
    160    
    # Line 276  create_database_schema() Line 256  create_database_schema()
    256    
    257   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    258   "client_serials"   "client_serials"
    259   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    260   "location varchar(255) NOT NULL"   "location varchar(255) DEFAULT NULL"
    261   "mtime int(11) DEFAULT NULL"   "mtime int(11) DEFAULT NULL"
    262   "mac varchar(17) NOT NULL"   "mac varchar(17) DEFAULT NULL"
    263   "hwdetected tinyint(1) NOT NULL DEFAULT '0'"   "hwdetected tinyint(1) NOT NULL DEFAULT '0'"
    264   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    265   )   )
    # Line 288  create_database_schema() Line 268  create_database_schema()
    268   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    269   "client_version"   "client_version"
    270   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY"
    271   "os varchar(50) NOT NULL"   "os varchar(50) DEFAULT NULL"
    272   "utils varchar(50) NOT NULL"   "utils varchar(50) DEFAULT NULL"
    273     "arch varchar(50) NOT NULL"
    274   )   )
    275   sql_create_table   sql_create_table
    276    
    # Line 370  create_database_schema() Line 351  create_database_schema()
    351   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    352   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    353   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    354   "description varchar(255) DEFAULT NULL AFTER value"   "description varchar(255) DEFAULT NULL"
    355   )   )
    356   sql_create_table   sql_create_table
    357    
    Legend:
    Removed from v.9463  
    changed lines
      Added in v.14425