脚本(4)
private function createSql():void{
var csql:String="CREATE TABLE IF NOT EXISTS ql_customer (" +
" customer_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
" customer_name VARCHAR(200), " +
" customer_address VARCHAR(200), " +
" customer_telephone VARCHAR(50)," +
" customer_mobile CHAR(11)," +
" customer_fax VARCHAR(50)," +
" img_url VARCHAR(100)," +
" customer_desc TEXT" +
")";
sqlArray.push(csql);
var esql:String="CREATE TABLE IF NOT EXISTS ql_employee (" +
" employee_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
" employee_name VARCHAR(200), " +
" employee_address VARCHAR(200), " +
" employee_mobile CHAR(11)," +
" employee_sex CHAR(1)," +
" employee_birthday DATE," +
" employee_study,VARCHAR(20)," +
" employee_job,VARCHAR(50)," +
" employee_desc TEXT" +
")";
sqlArray.push(esql);
var msql:String="CREATE TABLE IF NOT EXISTS ql_money_day (" +
" id INTEGER PRIMARY KEY AUTOINCREMENT, " +
" create_date DATE," +
" used_money NUMERIC,"+
" used_way VARCHAR(20),"+
" desc TEXT"+
")";
sqlArray.push(msql);
}