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

Parent Directory | Revision Log | Patch

	revision 8740 by niro, Wed Feb 17 12:07:37 2016 UTC	revision 9473 by niro, Thu Apr 6 13:57:45 2017 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 142  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 276  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 370  create_database_schema()	Line 348  create_database_schema()
348	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
349	"value varchar(255) NOT NULL"	"value varchar(255) NOT NULL"
350	"enabled tinyint(1) NOT NULL DEFAULT '1'"	"enabled tinyint(1) NOT NULL DEFAULT '1'"
351		"description varchar(255) DEFAULT NULL AFTER value"
352	)	)
353	sql_create_table	sql_create_table
354
#	Line 446  create_database_schema()	Line 425  create_database_schema()
425	"enabled tinyint(1) NOT NULL DEFAULT '1'"	"enabled tinyint(1) NOT NULL DEFAULT '1'"
426	)	)
427	sql_create_table	sql_create_table
428
429		TABLE_DEFINITION=(
430		"client_boot"
431		"serial int(255) NOT NULL PRIMARY KEY"
432		"cmdline varchar(255) DEFAULT NULL"
433		)
434		sql_create_table
435	}	}

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.8740   changed lines   Added in v.9473