customer_services_table.sql
上传用户:xiao730204
上传日期:2007-01-04
资源大小:141k
文件大小:1k
- CREATE TABLE customer_services_table (
- customer_service_id BIGINT NOT NULL AUTO_INCREMENT,
- user_id BIGINT NOT NULL DEFAULT 0,
- service_id BIGINT NOT NULL DEFAULT 0,
- contract_start DATETIME NOT NULL,
- contract_end DATETIME NOT NULL,
- price TEXT NOT NULL DEFAULT '',
- notes TEXT NOT NULL DEFAULT '',
- billing_cycle TEXT NOT NULL DEFAULT '',
- status TEXT NOT NULL DEFAULT '',
- PRIMARY KEY( customer_service_id ),
- INDEX( customer_service_id, user_id, service_id )
- )