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 8485 by niro, Fri Feb 5 12:06:33 2016 UTC revision 9469 by niro, Thu Apr 6 13:34:54 2017 UTC
    # Line 1  Line 1 
    1  create_database_schema()  create_database_schema()
    2  {  {
    3   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    4   "meta"   "meta_schema"
    5   "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     "version int(11) NOT NULL PRIMARY KEY"
    12     )
    13     sql_create_table
    14    
    15     TABLE_DEFINITION=(
    16     "cfg_fluxbox_autostart"
    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"
    19   "name varchar(255) NOT NULL"   "name varchar(255) NOT NULL"
    # Line 136  create_database_schema() Line 142  create_database_schema()
    142   sql_create_table   sql_create_table
    143    
    144   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=(  
    145   "cfg_printers"   "cfg_printers"
    146   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    147   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
    # Line 183  create_database_schema() Line 178  create_database_schema()
    178   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    179   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    180   "serverlist varchar(255) NOT NULL"   "serverlist varchar(255) NOT NULL"
    181   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    182   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    183   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    184   )   )
    # Line 200  create_database_schema() Line 195  create_database_schema()
    195   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    196   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    197   "shell varchar(255) DEFAULT NULL"   "shell varchar(255) DEFAULT NULL"
    198   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    199   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    200   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    201   )   )
    # Line 217  create_database_schema() Line 212  create_database_schema()
    212   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    213   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    214   "store varchar(255) NOT NULL"   "store varchar(255) NOT NULL"
    215   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    216   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    217   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    218   )   )
    # Line 249  create_database_schema() Line 244  create_database_schema()
    244   sql_create_table   sql_create_table
    245    
    246   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    247   "client_location"   "client_locations"
    248   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
    249     "bootserver varchar(255) NOT NULL"
    250   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    251   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    252   "pxe_prompt tinyint(1) NOT NULL"   "pxe_prompt tinyint(1) NOT NULL"
    # Line 269  create_database_schema() Line 265  create_database_schema()
    265    
    266   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    267   "client_serials"   "client_serials"
    268   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    269   "location varchar(255) NOT NULL"   "location varchar(255) NOT NULL"
    270   "mtime int(11) DEFAULT NULL"   "mtime int(11) DEFAULT NULL"
    271   "mac varchar(17) NOT NULL"   "mac varchar(17) NOT NULL"
    # Line 363  create_database_schema() Line 359  create_database_schema()
    359   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    360   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    361   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    362     "description varchar(255) DEFAULT NULL AFTER value"
    363     )
    364     sql_create_table
    365    
    366     TABLE_DEFINITION=(
    367     "values_network_wireless_auth_mode"
    368     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    369     "value varchar(255) NOT NULL"
    370     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    371     )
    372     sql_create_table
    373    
    374     TABLE_DEFINITION=(
    375     "values_network_wireless_bitrate"
    376     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    377     "value varchar(255) NOT NULL"
    378     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    379     )
    380     sql_create_table
    381    
    382     TABLE_DEFINITION=(
    383     "values_network_wireless_channel"
    384     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    385     "value varchar(255) NOT NULL"
    386     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    387     )
    388     sql_create_table
    389    
    390     TABLE_DEFINITION=(
    391     "values_network_wireless_frequency"
    392     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    393     "value varchar(255) NOT NULL"
    394     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    395     )
    396     sql_create_table
    397    
    398     TABLE_DEFINITION=(
    399     "values_network_wireless_key_length"
    400     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    401     "value varchar(255) NOT NULL"
    402     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    403     )
    404     sql_create_table
    405    
    406     TABLE_DEFINITION=(
    407     "values_network_wireless_mode"
    408     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    409     "value varchar(255) NOT NULL"
    410     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    411   )   )
    412   sql_create_table   sql_create_table
    413    
    # Line 391  create_database_schema() Line 436  create_database_schema()
    436   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    437   )   )
    438   sql_create_table   sql_create_table
    439    
    440     TABLE_DEFINITION=(
    441     "client_boot"
    442     "serial int(255) NOT NULL PRIMARY KEY"
    443     "cmdline varchar(255) DEFAULT NULL"
    444     )
    445     sql_create_table
    446  }  }
    Legend:
    Removed from v.8485  
    changed lines
      Added in v.9469