Magellan Linux

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 8515 - (hide annotations) (download) (as text)
Mon Feb 8 09:22:28 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 1067 byte(s)
-schema version 4 and values version 2, get wireless_ default values from database
1 niro 8515 update_to_database_schema_version_4()
2     {
3     TABLE_DEFINITION=(
4     "values_network_wireless_auth_mode"
5     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
6     "value varchar(255) NOT NULL"
7     "enabled tinyint(1) NOT NULL DEFAULT '1'"
8     )
9     sql_create_table
10    
11     TABLE_DEFINITION=(
12     "values_network_channel"
13     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
14     "value varchar(255) NOT NULL"
15     "enabled tinyint(1) NOT NULL DEFAULT '1'"
16     )
17     sql_create_table
18    
19     TABLE_DEFINITION=(
20     "values_network_wireless_frequency"
21     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
22     "value varchar(255) NOT NULL"
23     "enabled tinyint(1) NOT NULL DEFAULT '1'"
24     )
25     sql_create_table
26    
27     TABLE_DEFINITION=(
28     "values_network_key_length"
29     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
30     "value varchar(255) NOT NULL"
31     "enabled tinyint(1) NOT NULL DEFAULT '1'"
32     )
33     sql_create_table
34    
35     TABLE_DEFINITION=(
36     "values_network_wireless_mode"
37     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
38     "value varchar(255) NOT NULL"
39     "enabled tinyint(1) NOT NULL DEFAULT '1'"
40     )
41     sql_create_table
42     }