Magellan Linux

Contents 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 - (show annotations) (download) (as text)
Mon Feb 8 09:22:28 2016 UTC (8 years, 2 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 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 }