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 8497 by niro, Fri Feb 5 13:48:23 2016 UTC revision 10646 by niro, Wed Aug 30 13:56:46 2017 UTC
    # Line 1  Line 1 
    1  create_database_schema()  create_database_schema()
    2  {  {
    3   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    4   "meta"   "meta_schema"
    5   "schema_version int(11) NOT NULL PRIMARY KEY"   "version int(11) NOT NULL PRIMARY KEY"
    6   )   )
    7   sql_create_table   sql_create_table
    8    
    9   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    10   "cfg_autostart"   "meta_values"
    11   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "version int(11) NOT NULL PRIMARY KEY"
      "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'"  
    12   )   )
    13   sql_create_table   sql_create_table
    14    
    # Line 136  create_database_schema() Line 131  create_database_schema()
    131   sql_create_table   sql_create_table
    132    
    133   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=(  
    134   "cfg_printers"   "cfg_printers"
    135   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    136   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
    # Line 183  create_database_schema() Line 167  create_database_schema()
    167   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    168   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    169   "serverlist varchar(255) NOT NULL"   "serverlist varchar(255) NOT NULL"
    170   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    171   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    172   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    173   )   )
    # Line 200  create_database_schema() Line 184  create_database_schema()
    184   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    185   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    186   "shell varchar(255) DEFAULT NULL"   "shell varchar(255) DEFAULT NULL"
    187   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    188   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    189   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    190   )   )
    # Line 217  create_database_schema() Line 201  create_database_schema()
    201   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    202   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    203   "store varchar(255) NOT NULL"   "store varchar(255) NOT NULL"
    204   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    205   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    206   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    207   )   )
    # Line 249  create_database_schema() Line 233  create_database_schema()
    233   sql_create_table   sql_create_table
    234    
    235   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    236   "client_location"   "client_locations"
    237   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
    238     "bootserver varchar(255) NOT NULL"
    239   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    240   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    241   "pxe_prompt tinyint(1) NOT NULL"   "pxe_prompt tinyint(1) NOT NULL"
    # Line 269  create_database_schema() Line 254  create_database_schema()
    254    
    255   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    256   "client_serials"   "client_serials"
    257   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    258   "location varchar(255) NOT NULL"   "location varchar(255) NOT NULL"
    259   "mtime int(11) DEFAULT NULL"   "mtime int(11) DEFAULT NULL"
    260   "mac varchar(17) NOT NULL"   "mac varchar(17) NOT NULL"
    # Line 283  create_database_schema() Line 268  create_database_schema()
    268   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY"
    269   "os varchar(50) NOT NULL"   "os varchar(50) NOT NULL"
    270   "utils varchar(50) NOT NULL"   "utils varchar(50) NOT NULL"
    271     "arch varchar(50) NOT NULL"
    272   )   )
    273   sql_create_table   sql_create_table
    274    
    # Line 363  create_database_schema() Line 349  create_database_schema()
    349   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    350   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    351   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    352     "description varchar(255) DEFAULT NULL"
    353     )
    354     sql_create_table
    355    
    356     TABLE_DEFINITION=(
    357     "values_network_wireless_auth_mode"
    358     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    359     "value varchar(255) NOT NULL"
    360     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    361     )
    362     sql_create_table
    363    
    364     TABLE_DEFINITION=(
    365     "values_network_wireless_bitrate"
    366     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    367     "value varchar(255) NOT NULL"
    368     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    369     )
    370     sql_create_table
    371    
    372     TABLE_DEFINITION=(
    373     "values_network_wireless_channel"
    374     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    375     "value varchar(255) NOT NULL"
    376     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    377     )
    378     sql_create_table
    379    
    380     TABLE_DEFINITION=(
    381     "values_network_wireless_frequency"
    382     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    383     "value varchar(255) NOT NULL"
    384     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    385     )
    386     sql_create_table
    387    
    388     TABLE_DEFINITION=(
    389     "values_network_wireless_key_length"
    390     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    391     "value varchar(255) NOT NULL"
    392     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    393     )
    394     sql_create_table
    395    
    396     TABLE_DEFINITION=(
    397     "values_network_wireless_mode"
    398     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    399     "value varchar(255) NOT NULL"
    400     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    401   )   )
    402   sql_create_table   sql_create_table
    403    
    # Line 391  create_database_schema() Line 426  create_database_schema()
    426   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    427   )   )
    428   sql_create_table   sql_create_table
    429    
    430     TABLE_DEFINITION=(
    431     "client_boot"
    432     "serial int(255) NOT NULL PRIMARY KEY"
    433     "cmdline varchar(255) DEFAULT NULL"
    434     )
    435     sql_create_table
    436  }  }
    Legend:
    Removed from v.8497  
    changed lines
      Added in v.10646