51,397
社区成员




CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT NULL,
FRIEND_SEX CHAR(2) NOT NULL,
FRIEND_BIRTHDAY DATETIME NOT NULL,
FRIEND_WORKUNIT VARCHAR(100),
FRIEND_HOMEADD VARCHAR(200),
FRIEND_PHONECODE VARCHAR(40),
FRIEND_MOBILE VARCHAR(20) NOT NULL,
FRIEND_QQ VARCHAR(20) NOT NULL,
FRIEND_EMAILE VARCHAR(40),
FRIEND_MAILINGADD VARCHAR(200),
FRIEND_POSTCODE VARCHAR(10));